We are running Cloudera on Oracle BDA machine.
What I could not do is to query Hive tables through Windows ODBC driver.
- I am using a Windows 7 on an enterprise domain and installed 32bit Cloudera Hive ODBC driver.
- I logged in this Windows 7 with my personal user id and this user id can do everything on Hive with HUE or on BDA ssh console.
- Kerberos is enabled in our BDA environment, so that I preferred KErberos authentication while creating DSN. Hive ODBC driver worked ok during DSN definition. All tests succeded.
- To do more tests, I tried to connect Hive through Excel. But no tables are seen from Hive. Then I checked my DSN configuration, enabled show hive_system table. After that, in Excel I could only see the HIVE.hive_system table.
What could be wrong here?