hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anson Abraham <anson.abra...@gmail.com>
Subject Re: schema of hive database
Date Thu, 02 Aug 2012 19:19:07 GMT
ah, works.  thanks.

On Thu, Aug 2, 2012 at 3:13 PM, Igor Tatarinov <igor@decide.com> wrote:

> Try
> describe formatted <table>
>
> igor
> decide.com
>
> On Thu, Aug 2, 2012 at 12:04 PM, Anson Abraham <anson.abraham@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.
>>
>>
>

Mime
View raw message