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.
... View more