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