Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HDP 3.1 show tables does not shows view

Highlighted

HDP 3.1 show tables does not shows view

New Contributor

Hi,

We have just upgraded to HDP 3.1 and I found that Hive 3.1 show tables command does not list views.

While connecting with Tableau ODBC driver, only tables are visible, because it triggers show tables command.

not show views. Kindly let me know, if anyone has solved this issue??


Regards

Mamta Chawla

4 REPLIES 4

Re: HDP 3.1 show tables does not shows view

New Contributor

Did you find any answer to this?

Re: HDP 3.1 show tables does not shows view

New Contributor

We have the same problem - Hive views are invisible by using Hortonoworks ODBC (connection from Excel, Aginity, Tableau)

Re: HDP 3.1 show tables does not shows view

New Contributor

I've decribed this problem on Apache Hive Jiira, but my isssue was a duplicate. Here You are correct link with resolution of this problem:

https://issues.apache.org/jira/browse/HIVE-21301

Regards,

Re: HDP 3.1 show tables does not shows view

New Contributor

"show views" work for me

107431-1553645061978.png