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.