Re: Hive Metadata URI error

Sun, 11 Dec 2011 22:37:23 -0800

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 <swil...@monetate.com <mailto:swil...@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.d...@gmail.com
    <mailto:periya.d...@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.

Reply via email to