Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> schema of hive database


+
Anson Abraham 2012-08-02, 19:04
Copy link to this message
-
Re: schema of hive database
Try
describe formatted <table>

igor
decide.com

On Thu, Aug 2, 2012 at 12:04 PM, Anson Abraham <[EMAIL PROTECTED]>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.
>
>
+
Anson Abraham 2012-08-02, 19:19
+
Techy Teck 2012-08-02, 19:44
+
Techy Teck 2012-08-02, 19:59
+
Anson Abraham 2012-08-02, 20:03
+
Sandeep Reddy P 2012-08-02, 20:12
+
Techy Teck 2012-08-02, 21:54
+
Bejoy KS 2012-08-02, 22:14
+
Edward Capriolo 2012-08-02, 19:10