Toad World® Forums

Object explorer missing views in Hadoop databases connected via Impala / ODBC

Hi,

I've noticed views are not showing up in databases at all when looking at a database in Hadoop. I am connecting TOAD to the Hadoop server via Cloudera Impala driver (64 bit) ODBC connection.

Everything else works fine with this connection - I can see tables, browse data, query the views etc.. but the views do not show up in the object explorer. The "Views" tab does not even show up, there is only Database & Tables.

Version Details:

My PC: Windows 10 (64 bit)
TDP version: 5.07.106 (64 bit)
Cloudera ODBC driver for Impala version: 2.05.42.1031 (64 bit)

Let me know if you need any more details or screenshots.

Thanks,
Dan

Hi Dan,
so, unfortunately Impala ODBC does not support Get view function so we're waiting for them to fix their drivers. See https://issues.apache.org/jira/browse/IMPALA-1697

Thanks Dan, that is startling news, especially since those issues were first reported 3-4 years ago. I would have thought they would fix something like that by now.

Since waiting for the fix could potentially be years from now, are there any workarounds you know of to list the views within a database?

I can also revisit establishing a connection using the Hive driver. I was unsuccessful last time but if I am able to get that working, would that correctly display views?

Thanks,
Dan

Can you try to issue a DESCRIBE statement?


Other than that we know of no workaround.