hadoop - Hive derby/mysql installation -


i have 2 queries below logs:

  1. how rid of first line warn message.
  2. why hive complaining xml correctly formatted or missing something.

    15/04/23 18:26:58 warn conf.hiveconf: hiveconf of name hive.metastore.local not exist  logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-1.1.0.jar!/hive-log4j.properties slf4j: class path contains multiple slf4j bindings. slf4j: found binding in [jar:file:/usr/lib/hive/lib/hive-jdbc-1.1.0-standalone.jar!/org/slf4j/impl/staticloggerbinder.class] slf4j: found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/staticloggerbinder.class] slf4j: see http://www.slf4j.org/codes.html#multiple_bindings explanation. slf4j: actual binding of type [org.slf4j.impl.log4jloggerfactory] exception in thread "main" java.lang.runtimeexception: java.lang.illegalargumentexception: java.net.urisyntaxexception: relative path in absolute uri: ${system:java.io.tmpdir%7d/$%7bsystem:user.name%7d @ org.apache.hadoop.hive.ql.session.sessionstate.start(sessionstate.java:472) @ org.apache.hadoop.hive.cli.clidriver.run(clidriver.java:671) @ org.apache.hadoop.hive.cli.clidriver.main(clidriver.java:615) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:483) @ org.apache.hadoop.util.runjar.main(runjar.java:212) caused by: java.lang.illegalargumentexception: java.net.urisyntaxexception: relative path in absolute uri: ${system:java.io.tmpdir%7d/$%7bsystem:user.name%7d @ org.apache.hadoop.fs.path.initialize(path.java:206) @ org.apache.hadoop.fs.path.<init>(path.java:172) @ org.apache.hadoop.hive.ql.session.sessionstate.createsessiondirs(sessionstate.java:515) @ org.apache.hadoop.hive.ql.session.sessionstate.start(sessionstate.java:458) ... 7 more **caused by: java.net.urisyntaxexception: relative path in absolute uri: ${system:java.io.tmpdir%7d/$%7bsystem:user.name%7d** @ java.net.uri.checkpath(uri.java:1823) @ java.net.uri.<init>(uri.java:745) @ org.apache.hadoop.fs.path.initialize(path.java:203) ... 10 more 

kindly suggest

the issue hadoop "path" doesn't support ':' in filenames.

so, replace ${system:java.io.tmpdir}/${system:user.name} /tmp/mydir in hive-site.xml

referenced link

https://cwiki.apache.org/confluence/display/hive/adminmanual+configuration.