首页 智能推荐AIRec 公测产品导览 PAI-Rec 推荐Demo数据使用文档

推荐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包:
tar -zxvf rec_sln_data.tar.gz
使用odpscmd上传数据:
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;

阿里云首页 智能推荐 AIRec 相关技术圈