Cacher is the code snippet organizer for pro developers

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;