Skip to content

Instantly share code, notes, and snippets.

@wfxr

wfxr/odps.md

Last active July 13, 2017 02:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wfxr/32acb60d0eb94faa946ceae6f64bfd9b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wfxr/32acb60d0eb94faa946ceae6f64bfd9b to your computer and use it in GitHub Desktop.
Download ZIP
阿里云ODPS操作
Raw
odps.md

match md5imei

insert overwrite table tmp_bid_log_join_result select * from tmp_bid_log left outer join tmp_all_md5imei on tmp_bid_log.md5imei = tmp_all_md5imei.md5imei;

batch upload (ignore dirty data)

tunnel upload /data/bid_log/baseinfo/2017/07/11/parsed/ tmp_bid_log -fd " " -dbr=true;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment