Skip to content

Instantly share code, notes, and snippets.

@nlpjoe
Created July 31, 2020 07:52
Show Gist options
  • Save nlpjoe/0e3c4e191b78c9e805a088c0b66a13a3 to your computer and use it in GitHub Desktop.
Save nlpjoe/0e3c4e191b78c9e805a088c0b66a13a3 to your computer and use it in GitHub Desktop.
[tunnel 上传下载数据] #sql

全命令参考: http://help.aliyun-inc.com/internaldoc/detail/27833.html?spm=a2c1f.8259794.2.1.706796d5idBQN4

upload

tunnel upload log.txt test_project.test_table/p1="b1",p2="b2" --fd "||";
-- 将log.txt中的数据上传至项目空间test_project的表test_table(二级分区表)中的p1="b1",p2="b2"分区
tunnel upload  log.txt  test_table --scan=only;
-- 将log.txt中的数据上传至表 test_table 中。--scan参数表示需要扫描log.txt中的数据是否符合 test_table 的定义,如果不符合报错,并停止上传数据。

download

tunnel download  test_project.test_table/p1="b1",p2="b2"  test_table.txt;
-- 将test_project.test_table表(二级分区表)中的数据下载到 test_table.txt 文件中
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment