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. > >
