Oracle SQL Developer and Apache Hive – Never the twain shall meet

If you have come trying to find out why you can’t connect when you know you haven’t fat fingered your password, take heart, you aren’t going crazy.

You likely used instructions in the following post to connect SQL Developer to Hive. Save yourself some time, as these don’t work.

https://blogs.oracle.com/datawarehousing/entry/oracle_sql_developer_data_modeler

If you use wireshark or something else, you will see “anonymous” is passed as a password, regardless of what you typed in the SQL Developer UI. In the hive source code, that is the default password when one is not provided. Since we know we provided a password, we can conclude the SQL Developer UI is not passing it.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.