hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kirk True <k...@mustardgrain.com>
Subject Re: Hive Metadata URI error
Date Mon, 12 Dec 2011 06:36:45 GMT
To me it looks like the error message is getting a blank for the URI 
property value. Can you triple-check the property _name_ is correct 
(including capitalization)?

On 12/11/11 9:35 PM, Periya.Data wrote:
> Sam: I added "file://". Now it looks like this:
> <value>file:///home/users/jtv/CDH3/hive/conf/metastore_db</value>
>
> The problem has not gone away. I still have the same problem. I tried 
> rebooting my ec-2 instance. Still no difference.
>
> What does it mean by "does not have a scheme". What is it expecting?
>
> Thanks,
> PD.
>
> On Sun, Dec 11, 2011 at 9:15 PM, Sam Wilson <swilson@monetate.com 
> <mailto:swilson@monetate.com>> wrote:
>
>     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
>     <mailto: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