转载请注明出处:http://blog.csdn.net/dongdong9223/article/details/86573691
本文出自【我是干勾鱼的博客】
Ingredients:
Language
-
Java:Java SE Development Kit 8u162(Oracle Java Archive),Linux下安装JDK并修改环境变量
-
Hadoop:hadoop-2.9.1.tar.gz(Apache Hadoop Releases Downloads, All previous releases of Hadoop are available from the Apache release archive site)
-
Hive:hive-2.3.4(mirrors.tuna.tsinghua.edu.cn,Mirror site for Hive)
之前写过2篇关于Hive使用的文章:
有的时候可能想直接使用load命令将文本数据导入到SequenceFile或者ORCFile类型的数据库中,执行的时候会报错:
FAILED: SemanticException Unable to load data to destination table. Error: The file that you are trying to load does not match the file format of the destination table.
解决办法就是创建一个普通文本类型的中间表datafile_temp,然后使用insert命令从中间表datafile_temp中获取数据导入到实际表datafile中:
0: jdbc:hive2://localhost:10000> insert overwrite table datafile_temp select * from datafile;