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:
- I connect through our remote server by using SSH with my user credentials
- 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) - 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.
Best Answer
I could not test the below described procedure as I don't have the same infrastructure as you, but I suggest you to try this and come back with further details if any of the steps fails.
DBeaver should be able to do this trick for you:
sudo su - hive_user
. I would rather expect "Before connect", but it depends in which sequence DBeaver connects to SSH tunnel and execute this command. If the first solution doesn't work then I would test the other one: