-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 設(shè)置相關(guān)屬性
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;