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

Toad Data Point
1

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

2

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

3

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

4

Can you try to issue a DESCRIBE statement?

image
image.png1095×906 45.9 KB

Other than that we know of no workaround.

5

As an update, this issue is still partially ongoing.

When I say partially - we have 3 hadoop environments, dev / test, cert, and prod. They all should have the same / similar configurations. I connect to all 3 using the same ODBC drivers and similar connection parameters. But for some reason, dev / test and prod I am able to see views. But Cert, I am not able to see views. So this is odd since there should be no difference between environments. But if I am able to find out what that difference is I will let you know.

6

Hello, I am having problems seeing Hadoop views in the Object Explorer. I found this posting and I was wondered if this issue has been resolved in a later version. I have TOAD Data Point 5.1

I notice that I DO see ALL the tables and missing views in the pop-up list of the SQL Editor when I start typing the view/table name following the FROM statement....so DP must be getting them from somewhere?

Help! Otherwise, I will need to use HUE instead of DP, which I do not want to do!!!!!

7

Hello Polly,
which build are you on? We upgraded ODBC for 5.1.6 and views and tables should be fixed in Toad now.

8

So I just double checked my DP version, and I confirmed that I have "Toad Data Point 5.1.7.245 (64 bit)" loaded. I only see "List of Tables" in the Object Explorer, and do NOT see the category "Views" nor any of the views.

The interesting thing is that I can see both "List of Tables" and "Views" in the Object Explorer in my older copy of DP "Toad Data Point 4.1.0.226 (64 bit)". The list of table and view names are accurately displayed.

Both versions are pointing to the same ODBC data source using "Cloudera ODBC Driver for Impala 2.05.41.1029".