sqoop从Oracle导入hive报错

问题1:No primary key could be found for table xxx. Please specify one with --split-by or perform a sequential import with ‘-m 1’

原因:被抽取的Oracle表没有主键,并且sqoop脚本中开启了并行.
解决方法:
给Oracle表添加主键,不用修改sqoop脚本;
或者不用添加主键,但是要在sqoop脚本中添加参数(-m默认是4,需要指定为1):

--hive-import -m 1

问题2:Generating splits for a textual index column allowed only in case of “-Dorg.apache.sqoop.splitter.allow_text_splitter=true” property passed as a parameter

原因:需要手动开启支持切分
解决方案:在sqoop脚本中, sqoop import后面添加参数(-Dorg.apache.sqoop.splitter.allow_text_splitter=true),如图: