hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Periya.Data" <periya.d...@gmail.com>
Subject Re: Hive Metadata URI error
Date Tue, 13 Dec 2011 02:30:17 GMT
Thanks for all your suggestions. I terminated my instances and re-launched
a set of new instances. And, installed hive via apt-get. I do not see any
problem now. Earlier, I had installed hive by downloading the tarball.

Interestingly, I noticed hive-site.xml file when installed through apt-get
(and did not see that file when installed using tarball. Had to manually
create it.).

-PD.

On Mon, Dec 12, 2011 at 4:27 PM, Carl Steinbach <carl@cloudera.com> wrote:

> 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