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 <dwivedishash...@gmail.com > wrote: > inside configuration. all properties will be inside the configuration tags > > > On Tue, Jun 5, 2012 at 11:53 PM, Babak Bastan <babak...@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 <babak...@gmail.com> wrote: >> >>> It must be inside the <configuration></configuration> or outside this? >>> >>> >>> On Tue, Jun 5, 2012 at 8:15 PM, shashwat shriparv < >>> dwivedishash...@gmail.com> wrote: >>> >>>> It will be inside hive/conf >>>> >>>> >>>> On Tue, Jun 5, 2012 at 11:43 PM, Babak Bastan <babak...@gmail.com>wrote: >>>> >>>>> Thanks sShashwat, and where is this hive-site.xml >>>>> >>>>> On Tue, Jun 5, 2012 at 8:02 PM, shashwat shriparv < >>>>> dwivedishash...@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 <babak...@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 > > >
