pretty much what you did. I didn't realize that it was in the docs already:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribeTable%2FColumn Not sure, but I think this function is supported in 0.6 but I could be wrong. On Thu, Aug 2, 2012 at 3:59 PM, Techy Teck <comptechge...@gmail.com> wrote: > And I got this error too- > > FAILED: Parse Error: line 1:19 mismatched input 'table1' expecting EOF > > > > > On Thu, Aug 2, 2012 at 12:44 PM, Techy Teck <comptechge...@gmail.com>wrote: > >> What format you used? I tried like this and it doesn't works for me- >> >> *describe formatted table1* >> >> I am running Hive 0.6. Anything else I need to do before running this >> query? >> >> >> >> >> On Thu, Aug 2, 2012 at 12:13 PM, Igor Tatarinov <i...@decide.com> wrote: >> >>> Try >>> describe formatted <table> >>> >>> igor >>> decide.com >>> >>> On Thu, Aug 2, 2012 at 12:04 PM, Anson Abraham >>> <anson.abra...@gmail.com>wrote: >>> >>>> is there a way to derive information (schema) off a hive table? >>>> >>>> doing a describe only shows the clolumn w/ types. >>>> >>>> But i want to know if a table is like this: >>>> >>>> ROW FORMAT DELIMITED >>>> >>>> FIELDS TERMINATED BY '\t' >>>> >>>> COLLECTION ITEMS TERMINATED BY '\002' >>>> >>>> MAP KEYS TERMINATED BY '\003' >>>> >>>> STORED AS INPUTFORMAT >>>> 'com.hadoop.mapred.DeprecatedLzoTextInputFormat' OUTPUTFORMAT >>>> 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'; >>>> >>>> >>>> >>>> Or like this: >>>> >>>> ROW FORMAT DELIMITED >>>> >>>> FIELDS TERMINATED BY '\t' >>>> >>>> STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' >>>> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'; >>>> >>>> >>>> where can i find that info? >>>> >>>> >>>> Thanks in advance. >>>> >>>> >>> >> >
