I'm a DB Developer and in my company we're only able to interact with hive through a technical user who owns the specific write permissions for Hive on HDFS. So in practice this looks like this: 1. I connect through our remote server by using SSH with my user credentials 2. I switch to the technical hive user by doing sudo su - hive_user (DBA's wont hand out the password for this, so they prefer only giving us specific sudo permission for switching user like this) 3. I execute a query using beeline -f QUERY_FILE So as you can see I'm bound to work with the CLI (beeline) all the time, but I'd like to have the convenience using any SQL IDE from my Desktop. Is there any IDE for Hive, that allows me to connect to our DB as a technical user that can only be accessed by using sudo su - hive_user? A linked manual for this, also would be nice.

I'm troubleshooting a "sudden" issue on our somewhat old Informix server (11.50.UC9GE). After years of running without issue (and connecting w/o issue), suddenly today we can't connect to the server *remotely*. When I use dbaccess locally on the server and choose a connection method that prompts for username / password, the credentials work fine and I'm able to establish a connection. (note I can also intentionally enter invalid credentials and it will fail). This leads me to believe that the basic credentials I have are fine / unchanged. However, when we try to connect to the server remotely (via a JDBC driver in DB Visualizer), we get this error: An error occurred while establishing the connection: Long Message: Incorrect password or user com.informix.asf.IfxASFRemoteException: informix@ip-10-15-45-226.ec2.internal[MacBook-Pro.local] is not known on the database server. Details:    Type: java.sql.SQLException    Error Code: -951    SQL State: IX000 Up until today, this has always worked for us - any thoughts on what to check?

I am creating partition tables in postgreSQL. And the partition is on date column so its nearly high in number to show in schema. I want to show only my parent table for other users. I tried many searches but this kind of concept is not explained anywhere. This is my hierarchy, Master_table child_01_2013 child_02_2013 .... child_07_2019 so child table is in Monthly partition. I dont want to show all child table in my database. I am using Pg-admin 4 and DB visualizer(Free) tool for my works. Kindly help me to resolve this.