-Dorg.apache.sqoop.splitter.allow_text_splitter=true // If your database sorts in a case-insensitive order, this may result in a partial import or duplicate records.
-Dsqoop.hbase.add.row.key=true //作为rowkey的列,也正常写入列簇,作为普通列
Hive JDBC 设置相关属性
https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients
jdbc:hive2://<host1>:<port1>,<host2>:<port2>/dbName;initFile=<file>;sess_var_list?hive_conf_list#hive_var_list
Demo:
"jdbc:hive2://10.5.1xx.xxx:10000/original_db?hive.support.sql11.reserved.keywords=false";
hive shell 中:
set hive.support.sql11.reserved.keywords=false;