schema of hive database

[Anson Abraham]

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.