hive 导入数据报错是怎么回事啊

qq_37342040 2017-07-16 08:36:55
Logging initialized using configuration in jar:file:/usr/local/hive/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties
hive> show tables;
OK
testtable
Time taken: 1.649 seconds, Fetched: 1 row(s)
hive> load data local inpath '/home/date01' overwrite into table testtable;
Loading data to table default.testtable
Failed with exception Unable to move source file:/home/date01 to destination hdfs://localhost:9000/user/hive/warehouse/testtable/date01
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
hive>

hadoop是好着
root@master:~/桌面# jps
3643 SecondaryNameNode
3814 ResourceManager
4071 RunJar
3461 NameNode
4243 Jps
root@master:~/桌面#
下面是hive-site.xml配置

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?><!--

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>

<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>

<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>

<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>m123</value>
<description>password to use against metastore database</description>
</property>


<property>
<name>hive.metastore.warehouse.dir</name>
<value>/usr/local/hive/apache-hive-1.2.1-bin/warehouse</value>
</property>

<property>
<name>hive.exec.scratchdir</name>
<value>/usr/local/hive/apache-hive-1.2.1-bin/tmp</value>
</property>

<property>
<name>hive.querylog.location</name>
<value>/usr/local/hive/apache-hive-1.2.1-bin/log</value>
</property>

<property>
<name>hive.metastore.uris</name>
<value>thrift://192.168.86.133:9083</value>
<description>IP address (or fully-qualified domain name) and port of the metastore host</description>
</property>
...全文
651 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
qq_37342040 2017-07-18
  • 打赏
  • 举报
回复
不知道这个问题怎么回事
LinkSe7en 2017-07-17
  • 打赏
  • 举报
回复
你把文件put到hdfs上再试试

20,809

社区成员

发帖
与我相关
我的任务
社区描述
Hadoop生态大数据交流社区,致力于有Hadoop,hive,Spark,Hbase,Flink,ClickHouse,Kafka,数据仓库,大数据集群运维技术分享和交流等。致力于收集优质的博客
社区管理员
  • 分布式计算/Hadoop社区
  • 涤生大数据
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧