Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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.
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB