hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sagar Naik <sn...@attributor.com>
Subject Re: create table exception
Date Mon, 05 Apr 2010 18:55:46 GMT
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 <snaik@attributor.com> 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


Mime
View raw message