[Author]: kwu
使用sqoop --options-file直接导入hive数据,把操作命令语句写在文件中,便于管理及管理
1、创建hive数据库及表
create database DB_TEST;
CREATE TABLE
UserRegLoginLog(
ID BIGINT,
fld_date TIMESTAMP,
fld_ip string,
fld_server_ip string,
fld_UA string,
UserId BIGINT ,
UserName string,
PassWord string,
ActionType INT ,
ActionTime TIMESTAMP ,
ActionIP string,
FromHost string,
UrlRefer string,
RemotePort string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ;
2、编写sqoop操作文件,注意做分隔符需要与hive的一致
vi UserRegLoginLog_hive.opt
import
--connect
jdbc:jtds:sqlserver://localhost:1433;;Data