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