后使用快捷导航没有帐号？
查看: 2366|回复: 7
安装hive遇到的问题解决： java.lang.IllegalArgumentException:
注册会员, 积分 101, 距离下一级还需 99 积分
论坛徽章:6
异常信息：
Exception in thread &main& .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..hive.ql.session.SessionState.start(SessionState.java:444)
& && &&&at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672)
& && &&&at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616)
& && &&&at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
& && &&&at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
& && &&&at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
& && &&&at java.lang.reflect.Method.invoke(Method.java:606)
& && &&&at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
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:148)
& && &&&at org.apache.hadoop.fs.Path.&init&(Path.java:126)
& && &&&at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:487)
& && &&&at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:430)
& && &&&... 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:1804)
& && &&&at java.net.URI.&init&(URI.java:752)
& && &&&at org.apache.hadoop.fs.Path.initialize(Path.java:145)
& && &&&... 10 more
查看hive-site.xml配置，会看到配置值含有&system:java.io.tmpdir&的配置项
2.新建文件夹在hive目录下新建一个tmp目录
3.将含有&system:java.io.tmpdir&的配置项的值修改为如上地址
把${system:java.io.tmpdir}改成：/home/grid/apache-hive-1.2.1-bin/tmp
注册会员, 积分 101, 距离下一级还需 99 积分
论坛徽章:6
更正：把${system:java.io.tmpdir}改成：/home/grid/apache-hive-1.2.1-bin/tmp
把包含system:java.io.tmpdir里的value全替换成：/home/grid/apache-hive-1.2.1-bin/tmp
论坛徽章:36
学习一下 {:2_25:}
新手上路, 积分 1, 距离下一级还需 49 积分
论坛徽章:0
&&你好，请问是将 &value&${system:java.io.tmpdir}/${system:user.name}&/value&里面的system:user.name 这部分替换为tmp文件夹的路径？
注册会员, 积分 180, 距离下一级还需 20 积分
论坛徽章:5
谢谢分享正好遇到这样的错误过，但是没有记录原因
注册会员, 积分 153, 距离下一级还需 47 积分
论坛徽章:7
好问题，我也遇到了这个问题，mark
金牌会员, 积分 2284, 距离下一级还需 716 积分
论坛徽章:6
谢谢分享我也遇到了类似的问题
金牌会员, 积分 2284, 距离下一级还需 716 积分
论坛徽章:6
你好，请问是将 ${system:java.io.tmpdir}/${system:user.name}里面的system:user.name 这部分替换为tmp ...
${system:java.io.tmpdir}/${system:user.name} 这两个一起替换为 tmp 路径
扫一扫加入本版微信群温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
Caused by: javax.jdo.JDODataStoreException: Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"NestedThrowables:org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"& & & & at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:461)& & & & at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732)& & & & at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)& & & & at org.apache.hadoop.hive.metastore.ObjectStore.setMetaStoreSchemaVersion(ObjectStore.java:6664)解决方法：if ((this.readOnlyDatastore) || (this.fixedDatastore)) && &{ && & &this.autoCreateTables = && & &this.autoCreateColumns = && & &this.autoCreateConstraints = && &} && &else && &{ && & &boolean autoCreateSchema = conf.getBooleanProperty("datanucleus.autoCreateSchema"); && & &if (autoCreateSchema) && & &{ && & & &this.autoCreateTables = && & & &this.autoCreateColumns = && & & &this.autoCreateConstraints = && & &} && & &else& & &{ && & & &this.autoCreateColumns = conf.getBooleanProperty("datanucleus.autoCreateColumns"); && & & &this.autoCreateTables = conf.getBooleanProperty("datanucleus.autoCreateTables"); && & & &this.autoCreateConstraints = conf.getBooleanProperty("datanucleus.autoCreateConstraints"); && & &}& &}& &看来关键是 this.readOnlyDatastore & & & &this.fixedDatastore 这2个字段& 而且autoCreateSchema 这个设置为true 就可以决定了其他的设置，所以其他设置在此都无效了& 继续追踪org.datanucleus.store.AbstractStoreManager 发现了这2个字段的设置代码& this.readOnlyDatastore = conf.getBooleanProperty("datanucleus.readOnlyDatastore");& this.fixedDatastore = conf.getBooleanProperty("datanucleus.fixedDatastore"); &修改的配置的内容如下& & &property&& & & & &name&datanucleus.readOnlyDatastore&/name&& & & & &value&false&/value&& & &/property&& & &property&&& & & & &name&datanucleus.fixedDatastore&/name&& & & & &value&false&/value&&& & &/property&& & &property&&& & & & &name&datanucleus.autoCreateSchema&/name&&& & & & &value&true&/value&&& & &/property&& & &property&& & & & &name&datanucleus.autoCreateTables&/name&& & & & &value&true&/value&& & &/property&& & &property&& & & & &name&datanucleus.autoCreateColumns&/name&& & & & &value&true&/value&& & &/property&& &&& &&问题2：15/02/04 09:21:14 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.15/02/04 09:21:14 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not existLogging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-0.14.0.jar!/hive-log4j.propertiesException in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: The root scratch dir: /tmp/hive on HDFS should be writable. Current permissions are: rwx--x--x& & & & at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:444)& & & & at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672)& & & & at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616)& & & & 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:160)Caused by: java.lang.RuntimeException: The root scratch dir: /tmp/hive on HDFS should be writable. Current permissions are: rwx--x--x& & & & at org.apache.hadoop.hive.ql.session.SessionState.createRootHDFSDir(SessionState.java:529)& & & & at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:478)& & & & at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:430)& & & & ... 7 more解决方法：[root@hadoop ~]# hadoop fs -chmod -R 777 /tmp/hive[root@hadoop ~]# hadoop fs -ls /tmpFound 1 itemsdrwxrwxrwx & - root supergroup & & & & &0
08:48 /tmp/hive问题3：15/02/04 09:33:13 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.15/02/04 09:33:13 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not existLogging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-0.14.0.jar!/hive-log4j.propertiesException in thread "main" java.lang.RuntimeException: java.net.ConnectException: Call to hadoop/192.168.52.139:9000 failed on connection exception: java.net.ConnectException: Connection refused& & & & at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:444)& & & & at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672)& & & & at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616)& & & & 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:160)Caused by: java.net.ConnectException: Call to hadoop/192.168.52.139:9000 failed on connection exception: java.net.ConnectException: Connection refused解决方法:此问题是因为 hadoop没有启动，启动hadoop后问题解决问题4：[root@hadoop ~]# hive15/02/04 09:38:06 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.15/02/04 09:38:06 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not existLogging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-0.14.0.jar!/hive-log4j.propertieshive&解决方法：在0.10 &0.11或者之后的HIVE版本 hive.metastore.local 属性不再使用。在配置文件里面：&&property&&&name&hive.metastore.local&/name&& &value&false&/value&& &description&controls whether to connect to remove metastore server or open a new metastore server in Hive Client JVM&/description&&/property&删除掉，再次登录警告就消失了hive-site.xml 完整的内容如下：&?xml version="1.0" encoding="UTF-8" standalone="no"?&&?xml-stylesheet type="text/xsl" href="configuration.xsl"?&&configuration&& & &property&&& & & & &name&javax.jdo.option.ConnectionURL&/name&&& & & & &value&jdbc:mysql://192.168.52.139:3306/hive?createDatabaseIfNotExsit=characterEncoding=UTF-8&/value&&& & &/property&&& & &property&&& & & & &name&javax.jdo.option.ConnectionDriverName&/name&&& & & & &value&com.mysql.jdbc.Driver&/value&& & &/property&& & &property&& & & & &name&javax.jdo.option.ConnectionUserName&/name&& & & & &value&hive&/value&& & &/property&& & &property&&& & & & &name&javax.jdo.option.ConnectionPassword&/name&&& & & & &value&hive&/value&&& & &/property&&& & &property&& & & & &name&datanucleus.readOnlyDatastore&/name&& & & & &value&false&/value&& & &/property&& & &property&&& & & & &name&datanucleus.fixedDatastore&/name&& & & & &value&false&/value&&& & &/property&& & &property&&& & & & &name&datanucleus.autoCreateSchema&/name&&& & & & &value&true&/value&&& & &/property&& &&& & &property&& & & & &name&datanucleus.autoCreateTables&/name&& & & & &value&true&/value&& & &/property&& & &property&& & & & &name&datanucleus.autoCreateColumns&/name&& & & & &value&true&/value&& & &/property&&/configuration&
阅读(11672)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_087075',
blogTitle:'hive 启动问题记录 及解决方法',
blogAbstract:'问题1：Caused by: javax.jdo.JDODataStoreException: Required table missing : \"`VERSION`\" in Catalog \"\" Schema \"\". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable \"datanucleus.autoCreateTables\"NestedThrowables:org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:0,
publishTime:9,
permalink:'blog/static/',
commentCount:1,
mainCommentCount:1,
recommendCount:1,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'',
hmcon:'0',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}}