HI Zeng, Thanks for response
Correct me if I m wrong. Does this mean we need a traditional DB instance running for Hive to work ? -Sagar On Apr 5, 2010, at 1:02 AM, Zheng Shao wrote: > 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
