I referred to http://www.mazsoft.com/blog/post/2010/02/01/Setting-up-HadoopHive-to-use-MySQL-as-metastore.aspxwhen I setup metastore.
You can try that approach as well. On Mon, Apr 5, 2010 at 11:55 AM, Sagar Naik <[email protected]> wrote: > Hi > I tried to setup in embedded mode, the easiest one :) > Still no luck > > <property> > <name>mapred.reduce.tasks</name> > <value>local</value> > <description>The default number of reduce tasks per job. Typically set > to a prime close to the number of available hosts. Ignored when > mapred.job.tracker is "local". Hadoop set this to 1 by default, whereas > hive uses -1 as its default value. > By setting this property to -1, Hive will automatically figure out what > should be the number of reducers. > </description> > </property> > > <property> > <name>fs.default.name</name> > <value>namenode:54310</value> > </property> > > <property> > <name>javax.jdo.option.ConnectionURL</name> > > > <value>jdbc:derby:;databaseName=/data/hive/hive_metastore_db;create=true</value> > </property> > > > <property> > <name>javax.jdo.option.ConnectionDriverName</name> > <value>org.apache.derby.jdbc.EmbeddedDriver</value> > </property> > > > <property> > <name>hive.metastore.warehouse.dir</name> > <value>file:///data/hive/warehouse</value> > </property> > > > <property> > <name>hive.metastore.local</name> > <value>true</value> > </property> > > I made sure tht hive-site.xml is in classpath > > > bin/hive > hive-log4j.properties not found > Hive history file=/tmp/argus/hive_job_log_argus_201004051154_330230103.txt > 10/04/05 11:54:06 [main] INFO exec.HiveHistory: Hive history > file=/tmp/argus/hive_job_log_argus_201004051154_330230103.txt > hive> CREATE TABLE pokes (foo INT, bar STRING); > 10/04/05 11:54:10 [main] INFO parse.ParseDriver: Parsing command: CREATE > TABLE pokes (foo INT, bar STRING) > 10/04/05 11:54:10 [main] INFO parse.ParseDriver: Parse Completed > 10/04/05 11:54:10 [main] INFO parse.SemanticAnalyzer: Starting Semantic > Analysis > 10/04/05 11:54:10 [main] INFO parse.SemanticAnalyzer: Creating tablepokes > positin=13 > 10/04/05 11:54:10 [main] INFO ql.Driver: Semantic Analysis Completed > 10/04/05 11:54:10 [main] INFO ql.Driver: Starting command: CREATE TABLE > pokes (foo INT, bar STRING) > 10/04/05 11:54:10 [main] INFO exec.DDLTask: Default to LazySimpleSerDe for > table pokes > 10/04/05 11:54:10 [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/05 11:54:11 [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 > 10/04/05 11:54:11 [main] ERROR ql.Driver: FAILED: Execution Error, return > code 1 from org.apache.hadoop.hive.ql.exec.DDLTask > > > 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 > >
