Patch is forthcoming.. https://issues.apache.org/jira/browse/HIVE-967
There is a stand alone util referenced in the JIRA that you can use for now. On Thu, Aug 2, 2012 at 3: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.
