hivederby/mysql安装

rqcrx0a6 于 2021-06-02 发布在 Hadoop

关注(0)|答案(3)|浏览(286)

我从以下日志中有两个查询：
如何摆脱第一行警告消息。
为什么hive抱怨xml格式正确，或者我遗漏了什么。

15/04/23 18:26:58 WARN conf.HiveConf: HiveConf of name hive.metastore.local does 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 for an explanation.
SLF4J: Actual binding is 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
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:472)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:671)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:615)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at 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
at org.apache.hadoop.fs.Path.initialize(Path.java:206)
at org.apache.hadoop.fs.Path.<init>(Path.java:172)
at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:515)
at 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**

at java.net.URI.checkPath(URI.java:1823)
at java.net.URI.<init>(URI.java:745)
at org.apache.hadoop.fs.Path.initialize(Path.java:203)
... 10 more

好心的建议

hadoop Hive

来源：https://stackoverflow.com/questions/29911428/hive-derby-mysql-installation

3条答案

按热度按时间

v8wbuo2f1#

我也面临同样的问题。@partha是对的。问题是hadoop“path”不支持文件名中的“：”。
因此，我用以下属性修改了hive-site.xml，它成功了。

<name>hive.exec.scratchdir</name>
<value>/tmp/hive-${user.name}</value>

 <name>hive.exec.local.scratchdir</name>
 <value>/tmp/${user.name}</value>

<name>hive.downloaded.resources.dir</name>
<value>/tmp/${user.name}_resources</value>

赞(0）回复(0）举报 2021-06-03

o7jaxewo2#

问题是hadoop“path”不支持文件名中的“：”。
所以，替换${system:java.io.tmpdir}/${system:user.name}通过hive-site.xml中的/tmp/mydir
从此链接引用
https://cwiki.apache.org/confluence/display/hive/adminmanual+configuration.

赞(0）回复(0）举报 2021-06-03

dxpyg8gm3#

关于第一行警告消息，警告告诉您没有使用hive.metastore.local键。如果您更关心删除警告，请尝试从hive-site.xml中删除此配置

赞(0）回复(0）举报 2021-06-02