hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sam Wilson <swil...@monetate.com>
Subject Re: Hive Metadata URI error
Date Mon, 12 Dec 2011 05:15:59 GMT
Try file:// in front of the property value...

Sent from my iPhone

On Dec 12, 2011, at 12:07 AM, "Periya.Data" <periya.data@gmail.com> wrote:

> Hi,
>    I am trying to create Hive tables on an EC2 instance. I get this strange error about
URI schema and log4j properties not found. I do not know how to fix this. 
> 
> On EC2 instance : Ubuntu 10.04, Hive-0.7.1-cdh3u2. 
> 
> Initially I did not have an entry for hive.metastore.uris property in my hive-default.xml
file. So, I created one.  Still, I get the errors as pasted below. I was under the assumption
that if we leave the uris value blank, it is will assume the local metastore. 
> 
> <property>
>   <name>hive.metastore.local</
> name>
>   <value>true</value>
>   <description>controls whether to connect to remove metastore server or open a
new metastore server in Hive Client JVM</description>
> </property>
> 
> <property>
>   <name>hive.metastore.uris</name>
>   <value>/home/users/jtv/CDH3/hive/conf/metastore_db</value>
> </property>
> 
> 
> root@ip-10-114-18-63:/home/users/jtv# hive -f ./scripts/log25.q 
> hive-log4j.properties not found
> Hive history file=/tmp/root/hive_job_log_root_201112120332_1795396613.txt
> 11/12/12 03:32:03 INFO exec.HiveHistory: Hive history file=/tmp/root/hive_job_log_root_201112120332_1795396613.txt
> 11/12/12 03:32:03 INFO parse.ParseDriver: Parsing command: CREATE TABLE log25_tbl (OperationEvent
STRING, HostIP STRING, StartTime STRING, SourceRepo STRING, SourceFolder STRING, DestRepo
STRING, DestFolder STRING, EntityOrObject STRING, BytesSent STRING, TotalTimeInSecs STRING)
COMMENT 'This is the Log_25 Table'
> 11/12/12 03:32:04 INFO parse.ParseDriver: Parse Completed
> 11/12/12 03:32:04 INFO parse.SemanticAnalyzer: Starting Semantic Analysis
> 11/12/12 03:32:04 INFO parse.SemanticAnalyzer: Creating table log25_tbl position=13
> 11/12/12 03:32:04 INFO ql.Driver: Semantic Analysis Completed
> 11/12/12 03:32:04 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, properties:null)
> 11/12/12 03:32:04 INFO ql.Driver: Starting command: CREATE TABLE log25_tbl (OperationEvent
STRING, HostIP STRING, StartTime STRING, SourceRepo STRING, SourceFolder STRING, DestRepo
STRING, DestFolder STRING, EntityOrObject STRING, BytesSent STRING, TotalTimeInSecs STRING)
COMMENT 'This is the Log_25 Table'
> 11/12/12 03:32:04 INFO exec.DDLTask: Default to LazySimpleSerDe for table log25_tbl
> 11/12/12 03:32:04 INFO hive.log: DDL: struct log25_tbl { string operationevent, string
hostip, string starttime, string sourcerepo, string sourcefolder, string destrepo, string
destfolder, string entityorobject, string  bytessent, string totaltimeinsecs}
> FAILED: Error in metadata: java.lang.IllegalArgumentException: URI:  does not have a
scheme
> 11/12/12 03:32:04 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:476)
>     at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3176)
>     at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:213)
>     at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)
>     at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>     at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)
>     at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)
>     at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
>     at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:209)
>     at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:286)
>     at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:310)
>     at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:317)
>     at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:490)
>     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:156)
> Caused by: java.lang.IllegalArgumentException: URI:  does not have a scheme
>     at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:127)
>     at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:1868)
>     at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:1878)
>     at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:470)
>     ... 17 more
> 
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
> 11/12/12 03:32:04 ERROR ql.Driver: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
> root@ip-10-114-18-63:/home/users/jtv# 
> ===================================
> 
> Suggestions are appreciated.
> 
> PD.

Mime
View raw message