See http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin for details.
Zheng On Mon, Apr 5, 2010 at 12:01 AM, Sagar Naik <[email protected]> wrote: > Hi > As a trial, I am trying to setup hive for local DFS,MR mode > I have set > <property> > <name>hive.metastore.uris</name> > <value>file:///data/hive/metastore/metadb</value> > <description>The location of filestore metadata base dir</description> > </property> > > in hive-site.xml > > But I m still getting the following error > > Pl help me in getting hive up and running > > > > > CREATE TABLE pokes (foo INT, bar STRING); > 10/04/04 23:58:08 [main] INFO parse.ParseDriver: Parsing command: CREATE > TABLE pokes (foo INT, bar STRING) > 10/04/04 23:58:08 [main] INFO parse.ParseDriver: Parse Completed > 10/04/04 23:58:08 [main] INFO parse.SemanticAnalyzer: Starting Semantic > Analysis > 10/04/04 23:58:08 [main] INFO parse.SemanticAnalyzer: Creating tablepokes > positin=13 > 10/04/04 23:58:08 [main] INFO ql.Driver: Semantic Analysis Completed > 10/04/04 23:58:08 [main] INFO ql.Driver: Starting command: CREATE TABLE pokes > (foo INT, bar STRING) > 10/04/04 23:58:08 [main] INFO exec.DDLTask: Default to LazySimpleSerDe for > table pokes > 10/04/04 23:58:08 [main] INFO hive.log: DDL: struct pokes { i32 foo, string > bar} > FAILED: Error in metadata: java.lang.IllegalArgumentException: URI: does not > have a scheme > 10/04/04 23:58:08 [main] ERROR exec.DDLTask: FAILED: Error in metadata: > java.lang.IllegalArgumentException: URI: does not have a scheme > org.apache.hadoop.hive.ql.metadata.HiveException: > java.lang.IllegalArgumentException: URI: does not have a scheme > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:281) > at > org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:1281) > at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:119) > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:99) > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:64) > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:582) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:462) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:324) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:155) > at org.apache.hadoop.mapred.JobShell.run(JobShell.java:54) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79) > at org.apache.hadoop.mapred.JobShell.main(JobShell.java:68) > Caused by: java.lang.IllegalArgumentException: URI: does not have a scheme > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:92) > at > org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:828) > at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:838) > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:275) > ... 20 more > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > -- Yours, Zheng
