sqo-op –map-column-hive()

--map-column-hive PHOTO=string,PREVIEWPHOTO=string \oracle中blob类型转hive中string类型

sqoop import \ –connect jdbc:oracle:thin:@ip:1521/orcl \ –username \ –password \ –table \ –hive-import \ –hive-database \ –map-column-hive PHOTO=string,PREVIEWPHOTO=string \ –hive-table \ –hive-overwrite \ –delete-target-dir \ –hive-delims-replacement ‘ ‘ \ –fields-terminated-by ‘\t’ \ –lines-terminated-by ‘\n’ \ –null-string ‘\\N’ \ –null-non-string ‘\\N’ \ -m 1

————————
--map-column-hive PHOTO=string,PREVIEWPHOTO=string \oracle中blob类型转hive中string类型

sqoop import \ –connect jdbc:oracle:thin:@ip:1521/orcl \ –username \ –password \ –table \ –hive-import \ –hive-database \ –map-column-hive PHOTO=string,PREVIEWPHOTO=string \ –hive-table \ –hive-overwrite \ –delete-target-dir \ –hive-delims-replacement ‘ ‘ \ –fields-terminated-by ‘\t’ \ –lines-terminated-by ‘\n’ \ –null-string ‘\\N’ \ –null-non-string ‘\\N’ \ -m 1