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
+
Igor Tatarinov 2012-08-02, 19:13
+
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
Copy link to this message
-
Re: schema of hive database
Edward Capriolo 2012-08-02, 19:10
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 <[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.