hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Steinbach <c...@cloudera.com>
Subject Re: Hive Metadata URI error
Date Tue, 13 Dec 2011 00:27:08 GMT
Hi Periya,

You should only set the hive.metastore.uris property if you are running a
standalone MetaStore server, in which case you need to set
hive.metastore.local=false and set hive.metastore.uris to a Thrift URI.
Please see this document for more details:

https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin

Thanks.

Carl

On Sun, Dec 11, 2011 at 10:36 PM, Kirk True <kirk@mustardgrain.com> wrote:

>  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> 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>
>> 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