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 21:54:06 GMT
Can you tell me what version you guys are using?

Can anyone tell me to use *describe formatted table1 *which version of hive
we need?




On Thu, Aug 2, 2012 at 1:12 PM, Sandeep Reddy P <sandeepreddy.3647@gmail.com
> wrote:

> Nice one worked for me.
>
>
> On Thu, Aug 2, 2012 at 4:03 PM, Anson Abraham <anson.abraham@gmail.com>wrote:
>
>> pretty much what you did.  I didn't realize that it was in the docs
>> already:
>>
>>
>> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribeTable%2FColumn
>>
>> Not sure, but I think this function is supported in 0.6  but I could be
>> wrong.
>>
>>
>> On Thu, Aug 2, 2012 at 3:59 PM, Techy Teck <comptechgeeky@gmail.com>wrote:
>>
>>> 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.
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
>
> --
> Thanks,
> sandeep
>
>

Mime
View raw message