Member since
08-13-2014
47
Posts
4
Kudos Received
6
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 6789 | 03-02-2020 08:35 AM |
03-02-2020
02:25 PM
Hi Luis, If you run SHOW TABLES in the Impala ODBC session do you see the list of tables? Are only the external tables missing? Can you try running SHOW CURRENT ROLES to see if the lost of Sentry roles matches what you expect. I would also recommend checking the Impala logs, these will shed some more light on whether the table is not visible or if you are being denied access. Kind regards, Jim
... View more
03-02-2020
08:35 AM
Hi Luis, There are a couple of suggestions I can make to help narrow down what the cause may be. Are you able to run queries against these tables in Hue using both Impala and Hive? More than just seeing the tables in the navigation on the left are you actually able to SELECT from them using both engines? Are you using the same user in both Hue and the ODBC connection? I ask because if user is not allowed to access a table by Sentry then that table will not appear when you run SHOW TABLES. Have you run SELECT <db_name> in your ODBC SEL session prior to running SHOW TABLES or running a SQL query? Have you tried a SELECT statement on the table even if the metadata is not showing when you run SHOW TABLES? Try prefixing the database name to the table e.g. db_name.table_name. As always you should also check the logs to see if there are any clues as to why it is not working. Check to ensure that the version of the ODBC driver is compatible with the version of Impala you are using. Kind regards, Jim
... View more