ODPS SQL_odps sql @ 写法

Aliyun ODPS Command Line Tool
Version 0.29.6
@Copyright 2017 Alibaba Cloud Computing Co., Ltd. All rights reserved.
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  -dfp  yyyy-MM-dd D:\data\ods_user_app_detail_dt_201612 ods_user_app_detail_dt_201612;
Upload session: 202110112149119db4ca0b1d7e8135
Start upload:D:\data\ods_user_app_detail_dt_201612
Using \n to split records
Upload in strict schema mode: true
Total bytes:34393452     Split input to 1 blocks
2021-10-11 21:49:11     scan block: '1'
2021-10-11 21:49:12     scan block complete, blockid=1
2021-10-11 21:49:12     upload block: '1'
2021-10-11 21:49:17     1:0:34393452:D:\data\ods_user_app_detail_dt_201612      55%     18.1 MB 3.6 MB/s
2021-10-11 21:49:21     1:0:34393452:D:\data\ods_user_app_detail_dt_201612      100%    32.8 MB 3.6 MB/s
2021-10-11 21:49:21     upload block complete, blockid=1
upload complete, average speed is 3 MB/s
OK
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  -dfp  yyyy-MM-dd D:\data\ods_user_call_detail_dt_201612 ods_user_call_detail_dt_201612;
Upload session: 20211011215027d2c5ca0b1d7f410d
Start upload:D:\data\ods_user_call_detail_dt_201612
Using \n to split records
Upload in strict schema mode: true
Total bytes:41498184     Split input to 1 blocks
2021-10-11 21:50:27     scan block: '1'
2021-10-11 21:50:28     scan block complete, blockid=1
2021-10-11 21:50:28     upload block: '1'
2021-10-11 21:50:33     1:0:41498184:D:\data\ods_user_call_detail_dt_201612     47%     18.7 MB 3.7 MB/s
2021-10-11 21:50:38     1:0:41498184:D:\data\ods_user_call_detail_dt_201612     100%    39.6 MB 4 MB/s
2021-10-11 21:50:38     upload block complete, blockid=1
upload complete, average speed is 3.3 MB/s
OK
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  -dfp  yyyy-MM-dd D:\data\ods_user_sms_detail_dt_201612 ods_user_sms_detail_dt_201612;
Upload session: 2021101121520890b6ca0b1d7f2bed
Start upload:D:\data\ods_user_sms_detail_dt_201612
Using \n to split records
Upload in strict schema mode: true
Total bytes:25275251     Split input to 1 blocks
2021-10-11 21:52:07     scan block: '1'
2021-10-11 21:52:08     scan block complete, blockid=1
2021-10-11 21:52:08     upload block: '1'
2021-10-11 21:52:13     1:0:25275251:D:\data\ods_user_sms_detail_dt_201612      96%     23.3 MB 4.7 MB/s
2021-10-11 21:52:14     1:0:25275251:D:\data\ods_user_sms_detail_dt_201612      100%    24.1 MB 4.8 MB/s
2021-10-11 21:52:14     upload block complete, blockid=1
upload complete, average speed is 3.4 MB/s
OK
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  D:\data\dim_app_flag  dim_app_flag;
Upload session: 202110112153541ebdca0b1d7f6852
Start upload:D:\data\dim_app_flag
Using \n to split records
Upload in strict schema mode: true
Total bytes:4614         Split input to 1 blocks
2021-10-11 21:53:54     scan block: '1'
2021-10-11 21:53:54     scan block complete, blockid=1
2021-10-11 21:53:54     upload block: '1'
2021-10-11 21:53:54     upload block complete, blockid=1
OK
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  D:\data\dim_sms_flag  dim_sms_flag;
Upload session: 2021101121552111bdca0b1d7eada9
Start upload:D:\data\dim_sms_flag
Using \n to split records
Upload in strict schema mode: true
Total bytes:8161         Split input to 1 blocks
2021-10-11 21:55:21     scan block: '1'
2021-10-11 21:55:21     scan block complete, blockid=1
2021-10-11 21:55:21     upload block: '1'
2021-10-11 21:55:21     upload block complete, blockid=1
upload complete, average speed is 8 KB/s
OK
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  D:\data\dim_call_flag  dim_call_flag;
Upload session: 20211011215535d0b6ca0b1d7f6394
Start upload:D:\data\dim_call_flag
Using \n to split records
Upload in strict schema mode: true
Total bytes:7505         Split input to 1 blocks
2021-10-11 21:55:35     scan block: '1'
2021-10-11 21:55:35     scan block complete, blockid=1
2021-10-11 21:55:35     upload block: '1'
2021-10-11 21:55:35     upload block complete, blockid=1
upload complete, average speed is 7.3 KB/s
OK
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  D:\data\dw_user_brand_sex  dw_user_brand_sex;
Upload session: 20211011215640d2c5ca0b1d7fa709
Start upload:D:\data\dw_user_brand_sex
Using \r\n to split records
Upload in strict schema mode: true
Total bytes:881416       Split input to 1 blocks
2021-10-11 21:56:40     scan block: '1'
2021-10-11 21:56:40     scan block complete, blockid=1
2021-10-11 21:56:40     upload block: '1'
2021-10-11 21:56:40     upload block complete, blockid=1
upload complete, average speed is 860.8 KB/s
OK
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  D:\data\dim_user_brand  dim_user_brand;
Upload session: 20211011215651a7a9ca0b1d7f6169
Start upload:D:\data\dim_user_brand
Using \r\n to split records
Upload in strict schema mode: true
Total bytes:40   Split input to 1 blocks
2021-10-11 21:56:51     scan block: '1'
2021-10-11 21:56:51     scan block complete, blockid=1
2021-10-11 21:56:51     upload block: '1'
2021-10-11 21:56:51     upload block complete, blockid=1
OK
odps@ u_ee02volv_1633959038>tunnel upload -fd "\t"  D:\data\dim_user_gender  dim_user_gender;
Upload session: 2021101121572292b6ca0b1d80334b
Start upload:D:\data\dim_user_gender
Using \r\n to split records
Upload in strict schema mode: true
Total bytes:12   Split input to 1 blocks
2021-10-11 21:57:22     scan block: '1'
2021-10-11 21:57:22     scan block complete, blockid=1
2021-10-11 21:57:22     upload block: '1'
2021-10-11 21:57:23     upload block complete, blockid=1
upload complete, average speed is 12 bytes/s
OK
odps@ u_ee02volv_1633959038>