IDE Access to Hive without user password?
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:  


Install DBeaver, either as an Eclipse plug-in or as a stand-alone application
Create a new connection, for example by clicking on the  icon
Select Apache Hive as connection type, and then click "next":

In Generic JDBC connection setting, go first to "SSH" tab and setup your SSH tunnel:

Still in Generic JDBC connection setting, come back to "General" tab and click on "Connection details (name, type, ... )" at the bottom right of the window
On the new screen, click on "Shell commands":

Then I am less sure, but either in "Before connect" or "After connect", add your command 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:

Once done, click "Back" and fill in the "General" tab with your Hive user. You click "Test connection ..." to ensure everything works fine. Once it works, you can click on "Finish".