ah, works. thanks. On Thu, Aug 2, 2012 at 3: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. >> >> >
