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 <raviprasa...@gmail.com> wrote: > 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 the user. > > Like this , do we have any meta data tables ( data dictionary tables) > avilable in Hive to know about the Hive tables / views information. > > > -- > Regards, > RAVI PRASAD. T -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
