从oracle导入hive

sqoop import --connect jdbc:oracle:thin:@10.39.1.43:1521/rcrm --username bi_query --password ####################### --query " 
select 
item_id,
edit_id,
tenant_id,
create_date,
model_id,
parent_id,
create_id,
create_code,
edit_code,
edit_date,
item_order,
top_point,
middle_point,
item_name,
lower_point,
grade_explain,
must_grade,
to_char(SysDate,'YYYY-MM-DD HH24:mi:ss') as etl_in_dt from szdxcrm.CRM_QUALITY_ITEM where $CONDITIONS " 
--hcatalog-database S4 --hcatalog-table CRM_QUALITY_ITEM 
--hcatalog-storage-stanza 'stored as ORC' --hive-delims-replacement " " -m 1

注意在shell中执行时，$CONDITIONS->$CONDITIONS,加入转义

来自为知笔记(Wiz)