摘要： 0.11版本以前：sed -e 's/\x01/|/g' file0.11版本以后：insert overwrite local directory '/opt/aimcpro/libc/test.txt' row format delimited fields terminated by '|'... 阅读全文

摘要： select min(call_log), a.mail_subject from (select mail_to,mail_subject from dw_user_deviler_201408 where log_date>=20140825 and mail_subject not ... 阅读全文

摘要： select regexp_extract(a.col2,'(phonenum=\")(.*?)\"',2) user_device, regexp_extract(a.col13,'(imsicode=\")(.*?)\"',2) imsi, regexp_extract(a.col12,... 阅读全文