Hello all:
I'm working on adding Hadoop as a data source to our query tool (ODBC connection against a Cloudera virtual machine (written in .NET)). Hive .9 is installed. I've got a question about views from the Hive documentation. https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=27362034#La nguageManualDDL-ShowTables The Create View section states: "No support for materialized views is currently available in Hive." The Show Tables section has this. Show Tables SHOW TABLES identifier_with_wildcards; SHOW TABLES lists all the base tables and views with names matching the given regular expression. I'm assuming the "and views" text should not be there. That being said, is there any way to pull view metadata using Hive at this time (using ODBC)? Finally, I've read a little about the Hive Metastore. It sounds like to access this would require a separate connection to either a Derby database or another database such as MySQL for multiple users. Would this Metastore have information about views or would the "No support for materialized views is currently available in Hive" also apply here? I see a TBL_Type column in the ERwin diagram under the TBLS table so I thought this information might be kept here (if supported). Thank you very much for your help!!! Best Regards, Todd Wilson Senior Technical Consultant Coffing Data Warehousing (513) 292-3158 www.CoffingDW.com <http://www.coffingdw.com/> ******************************** The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at gene...@coffingdw.com. *********************************
