导入Hive单分区表直接用sqoop命令就可以。
1)首先建立单分区表(内部表)
CREATE TABLE IF NOT EXISTS import.zbd_t_product_comparison (
GCJT_SYB_DESC STRING COMMENT '产品线',
brand STRING COMMENT '品牌',
year STRING COMMENT '年份',
month STRING COMMENT '月份',
machine_sets BIGINT COMMENT '台份',
money DECIMAL(28,12) COMMENT '金额'
)PARTITIONED BY (
dt bigint COMMENT 'yyyyMM'
)COMMENT '产品对比表'
row format delimited fields terminated by '\t'
stored as textfile;
(2)sqoop抽数命令
sqoop import --connect jdbc:mysql://10.39.52.58:3306/app_data \
--username root \
--password root2017 \
--query 'select gcjt_syb_desc,brand,year,month,machine_sets,money from zbd_import_t_product_comparison where month='201801'' \
--fields-terminated-by '\t' \
--delete-target-dir \
--hive-import \
--m 1 \
--hive-partition-key dt \
--hive-partition-value 201801 \
--hive-database import \
--hive-table zbd_t_product_comparison \
--direct