DRDS使用sqoop导入及range_hash分库分表功能测试
一、sqoop导入drds方式验证
1、sqoop导入单表数据:
a)创建表b_top_item_test1:
CREATE TABLE b_top_item_test1(
num_iid varchar(100),
dp_id varchar(100),
approve_status varchar(100),
title varchar(100),
price varchar(100),
nick varchar(100),
cid varchar(100),
pic_url varchar(200),
props varchar(4000),
list_time varchar(100),
modified varchar(100),
delist_time varchar(100));
b)sqoop脚本如下:
export --connect "jdbc:mysql://xxxx.drds.aliyuncs.com/ccms_anta?useUnicode=true&characterEncoding=utf-8" --username ccms_anta --password xxxx --table b_top_item_test1 --export-dir /u