hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Re: schema of hive database
Date Thu, 02 Aug 2012 19:59:54 GMT
And I got this error too-

FAILED: Parse Error: line 1:19 mismatched input 'table1' expecting EOF




On Thu, Aug 2, 2012 at 12:44 PM, Techy Teck <comptechgeeky@gmail.com> wrote:

> What format you used? I tried like this and it doesn't works for me-
>
> *describe formatted table1*
>
> I am running Hive 0.6. Anything else I need to do before running this
> query?
>
>
>
>
> On Thu, Aug 2, 2012 at 12: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