{"id":5158,"date":"2015-09-30T21:18:43","date_gmt":"2015-10-01T02:18:43","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=5158"},"modified":"2015-10-01T05:28:20","modified_gmt":"2015-10-01T10:28:20","slug":"oracle-sql-developer-and-apache-hive-never-the-twain-shall-meet","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2015\/09\/30\/oracle-sql-developer-and-apache-hive-never-the-twain-shall-meet\/","title":{"rendered":"Oracle SQL Developer and Apache Hive &#8211; Never the twain shall meet"},"content":{"rendered":"<p>If you have come trying to find out why you can&#8217;t connect when you <b>know<\/b> you haven&#8217;t fat fingered your password, take heart, you aren&#8217;t going crazy.<\/p>\n<p>You likely used instructions in the following post to connect SQL Developer to Hive.  Save yourself some time, as these don&#8217;t work.<\/p>\n<p><a href=https:\/\/blogs.oracle.com\/datawarehousing\/entry\/oracle_sql_developer_data_modeler target=_blank>https:\/\/blogs.oracle.com\/datawarehousing\/entry\/oracle_sql_developer_data_modeler<\/a><\/p>\n<p>If you use wireshark or something else, you will see &#8220;anonymous&#8221; 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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have come trying to find out why you can&#8217;t connect when you know you haven&#8217;t fat fingered your password, take heart, you aren&#8217;t going crazy. You likely used instructions in the following post to connect SQL Developer to&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2015\/09\/30\/oracle-sql-developer-and-apache-hive-never-the-twain-shall-meet\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[43,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5158"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=5158"}],"version-history":[{"count":6,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5158\/revisions"}],"predecessor-version":[{"id":5164,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5158\/revisions\/5164"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=5158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=5158"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=5158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}