hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason Dere <>
Subject Re: Hive metastore using Oracle
Date Mon, 13 Jul 2015 20:29:28 GMT

Looks like it's having trouble with the hive.exec.local.scratchdir setting (which defaults
to "${}/${}"). Is variable substitution disabled (hive.variable.substitute)?
You might want to try explicitly setting hive.exec.local.scratchdir when running on the command


On Jul 13, 2015, at 7:47 AM, Garry Chen <<>>

Hi All,
                I am trying to setup a remote metastore for Hive using Oracle.  The following
is my steps and error message when try to start hive.  Please help and thank you very much.


1.       Create a hive user in Oracle instance
2.       Run as hive user
3.       Edite hive-site.xml
4.       Put ojdbc7.ora in /u01/app/hive-1.1.0/lib

hadoop> hive

Logging initialized using configuration in jar:file:/u01/app/hive-1.1.0/lib/hive-common-1.1.0.jar!/
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/u01/app/hive-1.1.0/lib/hive-jdbc-1.1.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/u01/app/hadoop-2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Exception in thread "main" java.lang.RuntimeException: java.lang.IllegalArgumentException: Relative path in absolute URI: ${$
        at org.apache.hadoop.hive.ql.session.SessionState.start(
        at org.apache.hadoop.hive.cli.CliDriver.main(
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
        at java.lang.reflect.Method.invoke(
        at org.apache.hadoop.util.RunJar.main(
Caused by: java.lang.IllegalArgumentException: Relative path
in absolute URI: ${$
        at org.apache.hadoop.fs.Path.initialize(
        at org.apache.hadoop.fs.Path.<init>(
        at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(
        at org.apache.hadoop.hive.ql.session.SessionState.start(
        ... 8 more
Caused by: Relative path in absolute URI: ${$
        at org.apache.hadoop.fs.Path.initialize(
        ... 11 more

View raw message