推荐Demo数据使用文档

step1: 建表

CREATE TABLE IF NOT EXISTS region_name.rec_tem_behavior_table_test(requestid STRING,userid STRING,itemid STRING,event STRING,os STRING,playtime DOUBLE,event_time BIGINT) PARTITIONED BY (ds STRING); 

CREATE TABLE IF NOT EXISTS region_name.rec_tem_user_table_test(userid STRING,city STRING,register_time BIGINT,gender STRING,birthyear BIGINT) PARTITIONED BY (ds STRING) ;

CREATE TABLE IF NOT EXISTS region_name.rec_tem_item_table_test(itemid STRING,cate STRING,pub_time STRING) PARTITIONED BY (ds STRING) ;

step2: 下载数据

step3: 解压数据并上传

tar -zxvf rec_sln_data.tar.gz

tunnel upload rec_tem_behavior_table_test/ds=20210920.csv region_name.rec_tem_behavior_table_test/ds=20210920.csv -acp true;
tunnel upload rec_tem_behavior_table_test/ds=20210921.csv region_name.rec_tem_behavior_table_test/ds=20210921.csv -acp true;
tunnel upload rec_tem_behavior_table_test/ds=20210922.csv region_name.rec_tem_behavior_table_test/ds=20210922.csv -acp true;
tunnel upload rec_tem_behavior_table_test/ds=20210923.csv region_name.rec_tem_behavior_table_test/ds=20210923.csv -acp true;
tunnel upload rec_tem_behavior_table_test/ds=20210924.csv region_name.rec_tem_behavior_table_test/ds=20210924.csv -acp true;
tunnel upload rec_tem_behavior_table_test/ds=20210925.csv region_name.rec_tem_behavior_table_test/ds=20210925.csv -acp true;

tunnel upload rec_tem_user_table_test/ds=20210920.csv region_name.rec_tem_user_table_test/ds=20210920.csv -acp true;
tunnel upload rec_tem_user_table_test/ds=20210921.csv region_name.rec_tem_user_table_test/ds=20210921.csv -acp true;
tunnel upload rec_tem_user_table_test/ds=20210922.csv region_name.rec_tem_user_table_test/ds=20210922.csv -acp true;
tunnel upload rec_tem_user_table_test/ds=20210923.csv region_name.rec_tem_user_table_test/ds=20210923.csv -acp true;
tunnel upload rec_tem_user_table_test/ds=20210924.csv region_name.rec_tem_user_table_test/ds=20210924.csv -acp true;
tunnel upload rec_tem_user_table_test/ds=20210925.csv region_name.rec_tem_user_table_test/ds=20210925.csv -acp true;

tunnel upload rec_tem_item_table_test/ds=20210920.csv region_name.rec_tem_item_table_test/ds=20210920.csv -acp true;
tunnel upload rec_tem_item_table_test/ds=20210921.csv region_name.rec_tem_item_table_test/ds=20210921.csv -acp true;
tunnel upload rec_tem_item_table_test/ds=20210922.csv region_name.rec_tem_item_table_test/ds=20210922.csv -acp true;
tunnel upload rec_tem_item_table_test/ds=20210923.csv region_name.rec_tem_item_table_test/ds=20210923.csv -acp true;
tunnel upload rec_tem_item_table_test/ds=20210924.csv region_name.rec_tem_item_table_test/ds=20210924.csv -acp true;
tunnel upload rec_tem_item_table_test/ds=20210925.csv region_name.rec_tem_item_table_test/ds=20210925.csv -acp true;