You can get the table name, using: select * from TBLS; Some more detailed information: select * from TABLE_PARAMS; select * from SERDE_PARAMS; select * from PARTITION_KEYS;
On Thu, Dec 26, 2013 at 2:18 PM, <shouvanik.hal...@accenture.com> wrote: > Hi, > > > > I am exploring HIVE options on EMR box from Amazon. Once I create a table > from HUE(Hadoop User Experience) console, I expect a table to get created > on MYSQL as this is the metastore. But I don’t find the table inside MYSQL > database. > > > > Any ideas? > > > > Thanks, > > Shouvanik > > ------------------------------ > > This message is for the designated recipient only and may contain > privileged, proprietary, or otherwise confidential information. If you have > received it in error, please notify the sender immediately and delete the > original. Any other use of the e-mail by you is prohibited. Where allowed > by local law, electronic communications with Accenture and its affiliates, > including e-mail and instant messaging (including content), may be scanned > by our systems for the purposes of information security and assessment of > internal compliance with Accenture policy. . > > ______________________________________________________________________________________ > > www.accenture.com >
