将Sqlserver中数据抽取到HIVE外部表:F_WORKSTATION
1.sqool语句:
sqoop import --connect "jdbc:sqlserver://10.96.3.112:1433;database=SMES_CQ_2017" --username sa --password SMES@CQ --table F_WORKSTATION --target-dir '/data/cdh/hive/hiveExternal/F_WORKSTATION' --null-string '\\N' --null-non-string '\\N' --fields-terminated-by '\001' --lines-terminated-by '\n' -m 1
2.DDL创建:
CREATE EXTERNAL TABLE smes_source.F_WORKSTATION (
WORKSTATION_ID int ,
WORKSTATION_NAME varchar(20),
DESCRIPTION varchar(50) ,
WORKSTATION_TYPE char(1) ,
LINE_ID int ,
LOCATION_ID int ,
ICON_FILENAME varchar(50),
LAYOUT_ORDER int ,
MCNO int
)
row format delimited fields terminated by '\001'
lines terminated by '\n'
stored as textfile
location "/data/cdh/hive/hiveExternal/F_WORKSTATION_TEST";