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.

Hortonworks Hive ODBC Driver doesn't display Views.

Hortonworks Hive ODBC Driver doesn't display Views.

New Contributor

When using the Hortonworks 2.6.1 Hive ODBC connector with external tools such as Tableau, SAS, Business Objects, SQL Developer, etc. We can't see the views in a hive database just the tables. I'm assuming this is because of the following change https://issues.apache.org/jira/browse/HIVE-14558 (we are on HDP 3.0.1 so Hive is at 3.0). Data can still be retrieved from the views by running a query but I'm assuming the driver uses the show-tables for displaying so we can't see the views and this prevents various usability with tools utilizing the driver. Is there any way around this? It looks like this is fixed as part of https://issues.apache.org/jira/browse/HIVE-21301 but that version of hive isn't available in the newest HDP yet.

Don't have an account?
Coming from Hortonworks? Activate your account here