sqoop

1.sqoop数据导入

sqoop import --connect jdbc:oracle:thin:@//10.1.166.171:1521/orcl --username system  
--password **** --table PLTDB_SP.SP_CALLCENTER_DEPT  --target-dir /data/95598/pltdb_sp/sp_callcenter_dept 
--fields-terminated-by '|' --hive-drop-import-delims --lines-terminated-by '
' 
--null-string '' --null-non-string '' -m 1 

2.建立外表

create external table pltdb_sp.sp_callcenter_dept
(
 DEPT_NO string comment '座席部门编号',  
 CALLCENTER_ID string comment '呼叫中心标识', 
 REMARK string comment '备注'
)
comment '呼叫中心座席相关部门信息表' 
row format delimited
fields terminated by '|'
location '/data/95598/pltdb_sp/SP_CALLCENTER_DEPT';