查看“Greenplum Export CSV”的源代码

Greenplum Export CSV

=== Greenplum Export CSV ===
 # m02, bi, ~/tmp/
 PW=Bi...1123
 FN=/tmp/test_cross.txt
====Table====
 SSQL="logs.l_serv_monitor"

====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}

=== Res: 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


[[分类:Develop]]
[[分类:DB]]
[[分类:Greenplum]]