Re: Meta data tables - Hive

2014-04-21 Thread Alan Gates
Hive does not have a traditional SQL information schema. Instead it uses MySQL style show/describe. So it has show tables, etc. See https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Show Alan. On Apr 21, 2014, at 7:10 AM, Ravi Prasad wrote: > Hi all, >

Meta data tables - Hive

2014-04-21 Thread Ravi Prasad
Hi all, In Hive do we have any meta data tables where I can see all the table's / view's / Indexes information. For example, in Oracle, we have *USER_TABLES* meta data table to know about all the tables available in the user. *USER_VIEWS* to know about all the view information available in