今天导数遇到一个问题,通过sqoop import从 postgresql导数据到hive中后,发现查询出来全部都是空的:
检查导入命令,没有错啊:
[root@dthost25 ~]#
sqoop import --connect jdbc:postgresql://192.168.xxx.xxx:5432/xxxxdb --username xxxx --password xxxxxxx --table rule --hive-import --hive-database lmj_test --hive-table ori_yyts_rule --hive-overwrite --delete-target-dir --hive-drop-import-delims --hive-drop-import-delims --null-string '' --null-non-string '' -m5
执行过程中也没有报错,顺利导入数据:
#运行日志(部分):
.......
File Input Format Counters
Bytes Read=0
File Output Format Counters
Bytes Written=869101
19/06/06 11:32:16 INFO mapreduce.ImportJobBase: Transferred 848.7314 KB in 24.4734 seconds (34.6797 KB/sec)
19/06/06 11:32:16 INFO mapreduce.ImportJobBase: Retrieved 1266 records.
19