I have resolved the problem for “connect to Hortonworks Hive table via ODBC”. I entered localhost ip: 127.0.0.1, user name (hue) with no password, port (10000), I got successful connection to database from (ODBC adiministrator console on my Windows 7 machine.”
However, I got in anoher problem when I tried to read my Hive table in “SAP Hana InfiniteInsight “. I tried to view the data in SAP, I got the following error message” error 4000 Compiling Statement:”Failed : HiveAccessControlException Persmission”.
I tried “Hive command GRANT from Hive Council on the HDP 2.1 Sandbox and granted Hue SELECT to the table”. Still getting same message.
Please, provide your input to this. I need urgent Help!. I’m optimistic we will get a fix.