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