hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Babak Bastan <babak...@gmail.com>
Subject Re: Error while Creating Table in Hive
Date Tue, 05 Jun 2012 18:43:34 GMT
Ok sorry but that was my Mistake .I thought it works but no.
I wrote the command without ; and then I think It works but with ; at the
end of command

CREATE TABLE pokes (foo INT, bar STRING);

does'nt work


On Tue, Jun 5, 2012 at 8:34 PM, shashwat shriparv <dwivedishashwat@gmail.com
> wrote:

> inside configuration. all properties will be inside the configuration tags
>
>
> On Tue, Jun 5, 2012 at 11:53 PM, Babak Bastan <babakbsn@gmail.com> wrote:
>
>> Thank you so much my friend your idee works fine(no error) you are the
>> best :)
>>
>>
>> On Tue, Jun 5, 2012 at 8:20 PM, Babak Bastan <babakbsn@gmail.com> wrote:
>>
>>> It must be inside the <configuration></configuration> or outside
this?
>>>
>>>
>>> On Tue, Jun 5, 2012 at 8:15 PM, shashwat shriparv <
>>> dwivedishashwat@gmail.com> wrote:
>>>
>>>> It will be inside hive/conf
>>>>
>>>>
>>>> On Tue, Jun 5, 2012 at 11:43 PM, Babak Bastan <babakbsn@gmail.com>wrote:
>>>>
>>>>> Thanks sShashwat, and where is this hive-site.xml
>>>>>
>>>>> On Tue, Jun 5, 2012 at 8:02 PM, shashwat shriparv <
>>>>> dwivedishashwat@gmail.com> wrote:
>>>>>
>>>>>> set
>>>>>>
>>>>>> hive.metastore.warehouse.dir in hive-site.xml
>>>>>>
>>>>>> <property>
>>>>>>   <name>hive.metastore.local</name>
>>>>>>   <value>true</value>
>>>>>> </property>
>>>>>>
>>>>>> <name>hive.metastore.warehouse.dir</name>
>>>>>>                <value>/home/<your username>/hivefolder</value>
>>>>>>                <description>location of default database for
the
>>>>>> warehouse</description>
>>>>>>        </property>
>>>>>>
>>>>>>
>>>>>> On Tue, Jun 5, 2012 at 10:43 PM, Babak Bastan <babakbsn@gmail.com>wrote:
>>>>>>
>>>>>>> Hello Experts ,
>>>>>>>
>>>>>>> I'm new in Hive .When try to create a test Table in Hive I get
an
>>>>>>> error.I want to run this command:
>>>>>>> *CREATE TABLE Test (DateT STRING, Url STRING, Content STRING);*
>>>>>>> but this error occured:
>>>>>>> FAILED: Error in metadata: MetaException(message:Got exception:
>>>>>>> java.io.FileNotFoundException File file:/user/hive/warehouse/test
does not
>>>>>>> exist.)
>>>>>>> FAILED: Execution Error, return code 1 from
>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>>>>> How can I solve this Problem?
>>>>>>> Thank you so much
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>>
>>>>>> ∞
>>>>>> Shashwat Shriparv
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>>
>>>> ∞
>>>> Shashwat Shriparv
>>>>
>>>>
>>>>
>>>
>>
>
>
> --
>
>
> ∞
> Shashwat Shriparv
>
>
>

Mime
View raw message