如何将所有地图绘制者加载到蜂箱表中？

Question

下面是用例：

下面是用于表状态测试详细信息的sqoop生成的文件：

$ hadoop fs /STATEWISE_TESTING_DETAILS_23_Nov/STATEWISE_TESTING_DETAILS发现5项-rw-r- -r-1 cloudera超级组0 2020-11-23 15:38 /STATEWISE_TESTING_DETAILS_23_Nov/STATEWISE_TESTING_DETAILS/_SUCCESS -rw-r-r-1 cloudera超级组19674 2020-11-23 15:38 /STATEWISE_TESTING_DETAILS_23_Nov/STATEWISE_TESTING_DETAILS/part-m-00000 -rw-r-r-r-1 cloudera超级组19716 2020年-11-23 15:38 /STATEWISE_TESTING_DETAILS_23_Nov/STATEWISE_TESTING_DETAILS/part-m-00001 -rw-r-r-1 cloudera超级组18761 2020-11-23 15:38 /STATEWISE_TESTING_DETAILS_23_Nov/STATEWISE_TESTING_DETAILS/part-m-00002 -rw-r-r-1 cloudera超级群20176 2020-11-23 15:38 /STATEWISE_TESTING_DETAILS_23_11月/STATEWISE_part_DETAILS/part-m-00003

我想把它们都装进蜂箱里的桌子里.

我做不到.

蜂巢:将数据'/STATEWISE_TESTING_DETAILS_23_Nov/STATEWISE_TESTING_DETAILS/part-m-00000‘加载到表STATEWISE_TESTING_DETAILS中；

失败：

失败：''/STATEWISE_TESTING_DETAILS_23_Nov/STATEWISE_TESTING_DETAILS/part-m-00000'‘附近的ParseException行1:10缺少INPATH

Answer 1

似乎在INPATH语句中缺少了LOAD DATA。下面的命令如下所示

load data inpath '/STATEWISE_TESTING_DETAILS_23_Nov/STATEWISE_TESTING_DETAILS/part-m-00000' into table STATEWISE_TESTING_DETAILS;

此外，Sqoop能够将数据直接移动到Hive。通过这种方式，您可以让Sqoop执行load data函数，甚至创建Hive表。

看看这个：-

1. https://sqoop.apache.org/docs/1.4.7/SqoopUserGuide.html#_importing_data_into_hive
2. https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.5.0/bk_data-access/content/using_sqoop_to_move_data_into_hive.html