Greenplum Export CSV：修订间差异
（创建页面，内容为“ ===Greenplum Export CSV=== m02, bi, ~/tmp/ PW=Bi...1123 FN=/tmp/test_cross.txt ====Greenplum Export CSV : Table==== SSQL="logs.l_serv_monitor" ====Greenplum Export CSV : SQL==== SSQL=`cat test_cross.sql` <small>''# test_cross.sql''</small> <small>''select create_date,''</small> <small>'' platform,''</small> <small>'' operatingsystemversion,''</small> <small>'' channelid,''</small> <small>'' chan…”） |
无编辑摘要 |
||
| 第1行： | 第1行： | ||
Greenplum Export CSV | |||
===Greenplum Export CSV=== | === Greenplum Export CSV === | ||
m02, bi, ~/tmp/ | # m02, bi, ~/tmp/ | ||
PW=Bi...1123 | PW=Bi...1123 | ||
FN=/tmp/test_cross.txt | FN=/tmp/test_cross.txt | ||
2022年12月29日 (四) 16:17的版本
Greenplum Export CSV
Greenplum Export CSV
# m02, bi, ~/tmp/ PW=Bi...1123 FN=/tmp/test_cross.txt
Greenplum Export CSV : Table
SSQL="logs.l_serv_monitor"
Greenplum Export CSV : SQL
SSQL=`cat test_cross.sql`
# test_cross.sql
select create_date,
platform,
operatingsystemversion,
channelid,
channelname,
count(*) cs
from ods.gio_ads_track_activation
where 1=1
and date_hour_id like '202210%'
group by create_date,
platform,
operatingsystemversion,
channelid,
channelname
order by create_date,
platform,
operatingsystemversion,
channelid,
channelname
Export
PGPASSWORD=${PW} psql -U gpadmin -h 10.10.139.20 -d owgp -w -c "copy (${SSQL}) to STDOUT with (FORMAT csv, header true, encoding UTF8)" > ${FN}
test_cross.txt
2022-10-01,Android,Android 10,"","",1752
2022-10-01,Android,Android 10,a9BG6rRn,wap站跳转app,7
2022-10-01,Android,Android 10,baidufeeds,百度原生信息流,83
2022-10-01,Android,Android 10,huaweiads_app_ocpd,华为应用商店oCPD,1143