hive启动后执行show databases 报错报如下错误是什么原因

本帖子已过去太久远了,不再提供回复功能。软件故障解决(6)
使用hive时出现如上错误
FAILED : Error in metadata : MetaException(message :Got exception : java.net.Connect Exception Call to hadoop/192.168.56.100:9000 failed on connection exception: java.net.ConnectException:Connection refused)
  hive是基于hadoop的 ,所以使用hive 必须先启动hadoop
通过命令 jps 产看进程 发现hadoop 没有启动&
& & &命令:start-all.sh 启动hadoop后 重试 &
问题解决。。
参考知识库
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
访问:3530次
排名:千里之外
原创:17篇
(1)(17)(3)(2)(1)STATEMENT…
当启动Hive的时候报错:
&code class=&hljs applescript has-numbering& style=&display: padding: 0 color: box-sizing: border- font-family: &Source Code Pro&,font-size: white-space: border-radius: 0 word-wrap: background:&&Caused &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&by&/span&: javax.jdo.JDOException: Couldnt obtain a new sequence (unique &span class=&hljs-property& style=&box-sizing: border-&&id&/span&) : Cannot execute statement: impossible &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&to&/span& &span class=&hljs-command& style=&box-sizing: border-&&write&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&to&/span& binary &span class=&hljs-command& style=&box-sizing: border-&&log&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&since&/span& BINLOG_FORMAT = STATEMENT &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&and&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&at&/span& least one table uses a storage engine limited &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&to&/span& row-based logging. InnoDB &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&is&/span& limited &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&to&/span& row-logging when &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&transaction&/span& isolation level &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&is&/span& READ COMMITTED &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&or&/span& READ UNCOMMITTED.
NestedThrowables:
java.sql.SQLException: Cannot execute statement: impossible &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&to&/span& &span class=&hljs-command& style=&box-sizing: border-&&write&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&to&/span& binary &span class=&hljs-command& style=&box-sizing: border-&&log&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&since&/span& BINLOG_FORMAT = STATEMENT &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&and&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&at&/span& least one table uses a storage engine limited &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&to&/span& row-based logging. InnoDB &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&is&/span& limited &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&to&/span& row-logging when &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&transaction&/span& isolation level &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&is&/span& READ COMMITTED &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&or&/span& READ UNCOMMITTED.&/code&&ul class=&pre-numbering& style=&box-sizing: border- position: width: 50 top: 0 left: 0 margin: 0 padding: 6px 0px 40 border-right: 1px solid rgb(221, 221, 221); list-style: text-align: background-color: rgb(238, 238, 238);&&&li style=&box-sizing: border- padding: 0px 5&&1&/li&&li style=&box-sizing: border- padding: 0px 5&&2&/li&&li style=&box-sizing: border- padding: 0px 5&&3&/li&&/ul&
这个问题是由于hive的元数据存储MySQL配置不当引起的,可以这样解决:
&code class=&hljs vbnet has-numbering& style=&display: padding: 0 color: box-sizing: border- font-family: &Source Code Pro&,font-size: white-space: border-radius: 0 word-wrap: background:&&mysql& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&set&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&global&/span& binlog_format=&span class=&hljs-comment& style=&color: rgb(136, 0, 0); box-sizing: border-&&'MIXED';&/span&&/code&&ul class=&pre-numbering& style=&box-sizing: border- position: width: 50 top: 0 left: 0 margin: 0 padding: 6px 0px 40 border-right: 1px solid rgb(221, 221, 221); list-style: text-align: background-color: rgb(238, 238, 238);&&&li style=&box-sizing: border- padding: 0px 5&&1&/li&&/ul&
2 For direct MetaStore DB connections, we don’t support retries at the client level.
当在Hive中创建表的时候报错:
&code class=&hljs vbnet has-numbering& style=&display: padding: 0 color: box-sizing: border- font-family: &Source Code Pro&,font-size: white-space: border-radius: 0 word-wrap: background:&&create table years (year &span class=&hljs-built_in& style=&color: rgb(102, 0, 102); box-sizing: border-&&string&/span&, &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&event&/span& &span class=&hljs-built_in& style=&color: rgb(102, 0, 102); box-sizing: border-&&string&/span&) row format delimited fields terminated &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&by&/span& &span class=&hljs-comment& style=&color: rgb(136, 0, 0); box-sizing: border-&&'\t';&/span&
FAILED: Execution &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&Error&/span&, &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&return&/span& code &span class=&hljs-number& style=&color: rgb(0, 102, 102); box-sizing: border-&&1&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&from&/span& org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:&span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&For&/span& direct MetaStore DB connections, we don&span class=&hljs-comment& style=&color: rgb(136, 0, 0); box-sizing: border-&&'t support retries at the client level.)&/span&&/code&&ul class=&pre-numbering& style=&box-sizing: border- position: width: 50 top: 0 left: 0 margin: 0 padding: 6px 0px 40 border-right: 1px solid rgb(221, 221, 221); list-style: text-align: background-color: rgb(238, 238, 238);&&&li style=&box-sizing: border- padding: 0px 5&&1&/li&&li style=&box-sizing: border- padding: 0px 5&&2&/li&&/ul&
这是由于字符集的问题,需要配置MySQL的字符集:
&code class=&hljs applescript has-numbering& style=&display: padding: 0 color: box-sizing: border- font-family: &Source Code Pro&,font-size: white-space: border-radius: 0 word-wrap: background:&&mysql& alter database hive &span class=&hljs-property& style=&box-sizing: border-&&character&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&set&/span& latin1;&/code&&ul class=&pre-numbering& style=&box-sizing: border- position: width: 50 top: 0 left: 0 margin: 0 padding: 6px 0px 40 border-right: 1px solid rgb(221, 221, 221); list-style: text-align: background-color: rgb(238, 238, 238);&&&li style=&box-sizing: border- padding: 0px 5&&1&/li&&/ul&
3 HiveConf of name hive.metastore.local does not exist
当执行Hive客户端时候出现如下错误:
&code class=&hljs applescript has-numbering& style=&display: padding: 0 color: box-sizing: border- font-family: &Source Code Pro&,font-size: white-space: border-radius: 0 word-wrap: background:&&WARN conf.HiveConf: HiveConf &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&of&/span& &span class=&hljs-property& style=&box-sizing: border-&&name&/span& hive.metastore.&span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&local&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&does&/span& &span class=&hljs-keyword& style=&color: rgb(0, 0, 136); box-sizing: border-&&not&/span& exist&/code&&ul class=&pre-numbering& style=&box-sizing: border- position: width: 50 top: 0 left: 0 margin: 0 padding: 6px 0px 40 border-right: 1px solid rgb(221, 221, 221); list-style: text-align: background-color: rgb(238, 238, 238);&&&li style=&box-sizing: border- padding: 0px 5&&1&/li&&/ul&
这是由于在0.10 0.11或者之后的HIVE版本 hive.metastore.local 属性不再使用。将该参数从hive-site.xml删除即可。
4 Permission denied: user=anonymous, access=EXECUTE, inode=”/tmp”
在启动Hive报如下错误:
&code class=&hljs ruby has-numbering& style=&display: padding: 0 color: box-sizing: border- font-family: &Source Code Pro&,font-size: white-space: border-radius: 0 word-wrap: background:&&(&span class=&hljs-constant& style=&box-sizing: border-&&Permission&/span& &span class=&hljs-symbol& style=&color: rgb(0, 102, 102); box-sizing: border-&&denied:&/span& user=anonymous, access=&span class=&hljs-constant& style=&box-sizing: border-&&EXECUTE&/span&, inode=&span class=&hljs-string& style=&color: rgb(0, 136, 0); box-sizing: border-&&&/tmp&&/span&&span class=&hljs-symbol& style=&color: rgb(0, 102, 102); box-sizing: border-&&:hadoop&/span&&span class=&hljs-symbol& style=&color: rgb(0, 102, 102); box-sizing: border-&&:supergroup&/span&&span class=&hljs-symbol& style=&color: rgb(0, 102, 102); box-sizing: border-&&:drwx------&/span&&/code&&ul class=&pre-numbering& style=&box-sizing: border- position: width: 50 top: 0 left: 0 margin: 0 padding: 6px 0px 40 border-right: 1px solid rgb(221, 221, 221); list-style: text-align: background-color: rgb(238, 238, 238);&&&li style=&box-sizing: border- padding: 0px 5&&1&/li&&/ul&
这是由于Hive没有hdfs:/tmp目录的权限,赋权限即可:
&code class=&hljs lasso has-numbering& style=&display: padding: 0 color: box-sizing: border- font-family: &Source Code Pro&,font-size: white-space: border-radius: 0 word-wrap: background:&&hadoop dfs &span class=&hljs-attribute& style=&box-sizing: border-&&-chmod&/span& &span class=&hljs-attribute& style=&box-sizing: border-&&-R&/span& &span class=&hljs-number& style=&color: rgb(0, 102, 102); box-sizing: border-&&777&/span& /tmp&/code&&code class=&hljs lasso has-numbering& style=&display: padding: 0 color: box-sizing: border- font-family: &Source Code Pro&,font-size: white-space: border-radius: 0 word-wrap: background:&&&/code&&div class=&blog-body& style=&box-sizing: -webkit-tap-highlight-color: font-size: 1.6 font-family: &Lantinghei SC&, &Open Sans&, Arial, &Hiragino Sans GB&, &Microsoft YaHei&, STHeiti, &WenQuanYi Micro Hei&, SimSun, sans- word-wrap: break- color: rgb(61, 70, 77); line-height: 30 margin-top: 30&&&val data-name=&blog_content_type& data-value=&richtext& style=&box-sizing: -webkit-tap-highlight-color:&&&/val&&div class=&BlogContent& style=&box-sizing: -webkit-tap-highlight-color:&&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&hive&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&的常见问题&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: C&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&1.     &/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&org.apache.thrift.transport.TTransportException: Could not create ServerSocket on address 0.0.0.0/0.0.0.0:10000&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color:&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&问题&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&:&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&hive --service hiveserver  &/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&启动&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&hiveserver&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&服务&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color:&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&解决方法&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&:端口被占用&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&  &/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&,&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&kill &/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&该端口进程或者重新制定端口&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&& hive --service hiveserver -p 10001&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: C&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&2.  &/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color:&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&解决方法&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&:&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&./hive -hiveconf hive.root.logger=DEBUG,console&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&输出错误日志,进行修改。一般都是&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&hive&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&用户&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&mysql&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&库权限问题.&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: C&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&3.&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&Error: dl failure on line 864&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: C&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&Error: failed /home/app/jdk1.7.0_21/jre/lib/i386/client/libjvm.so, because /home/app/jdk1.7.0_21/jre/lib/i386/client/libjvm.so: cannot restore segment prot after reloc: Permission denied&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16 font-family: &Century Gothic&;&& &/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color:&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&解决方法&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&:&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&& /usr/sbin/setenforce 0&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&&span style=&box-sizing: -webkit-tap-highlight-color:&&4.&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&运行&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&Hadoop&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&程序&/span&&/span& &span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&时,出现&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&  &/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&Filesystem closed&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&异常。&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&通过查证是设置了缓存。需要取消缓存。&/span&&/span&&span style=&font-family: &Century Gothic&; font-size: 16 background-color:&& &/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&通过修改配置文件&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&core-site.xml&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&:&/span&&/span&&span style=&font-family: &Century Gothic&; font-size: 16 background-color:&& &/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16 background: rgb(226, 239, 217);&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 12&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: C&&&property&&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16 text-indent: 28 background: rgb(226, 239, 217);&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 12&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: C&&&name&fs.hdfs.impl.disable.cache&/name&&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16 text-indent: 28 background: rgb(226, 239, 217);&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 12&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: C&&&value&true&/value&&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16 background: rgb(226, 239, 217);&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 12&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: C&&&/property&&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&程序仍然出现上述问题。&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&在程序中,加上这条语句:&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&JobConf  &/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&jobConf.set(&fs.hdfs.impl.disable.cache&, &true&);&/span&&/span&&span style=&font-family: &Century Gothic&; font-size: 16 background-color:&& &/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&程序运行成功。&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&5 &/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&Failed with exception Unable to move sourcehdfs://vmtmstorm01:8020/test to destination hdfs://vmtmstorm01:8020/user/hive/warehouse/ptest/name=ww/test&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask&/span&&/span&&/p&&p style=&box-sizing: -webkit-tap-highlight-color: margin-bottom: 16&&&span style=&box-sizing: -webkit-tap-highlight-color: font-size: 16&&&span style=&box-sizing: -webkit-tap-highlight-color:&&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&原因&/span&&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&:由于&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&hive&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&的用户权限问题,&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: &Century Gothic&;&&hive&/span&&span style=&box-sizing: -webkit-tap-highlight-color: font-family: 宋体;&&在源目录或者是目的目录没有操作的权限&/span&&/span&&/p&&/div&&/div&
参考知识库
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
访问:63039次
积分:1482
积分:1482
排名:千里之外
原创:71篇
转载:91篇
(1)(3)(15)(6)(11)(16)(33)(48)(33)

我要回帖

更多关于 hive show databases 的文章

 

随机推荐