Did you setup the /usr/hive/warehouse directory in hdfs and do a chmod g+w on it? That would be required before you run any queries.
On Jun 3, 2012, at 1:53 AM, Павел Мезенцев <pa...@mezentsev.org> wrote: > Hello all! > > I tried to create simple table in hive > > create table test (a string); > > But its failed: > 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 > > I set up hadoop and hive locally from couderra distribution CDH3 on Ubuntu > 12.04. > And use default settings. > > What I do wrong? How can I fix it? > > Thank you! > Best regards > Mezentsev Pavel > Russia