Support Questions
Find answers, ask questions, and share your expertise

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 (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 but that version of hive isn't available in the newest HDP yet.