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 '\n' \ --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';
We only live once, and time just goes by.