如题:在 greenplum 大量sum语句多个临时表关联,如何优化。
sql 示例: SELECT tk.column1 AS column1, tk.column2 AS column2, tk.date_time AS date_time, unit.column3 AS column3, unit.column4 AS column4, dau.column5 AS column5, deu.column6 AS column6, retention.column7 AS column7, retention.column8 AS column8 FROM ( SELECT SUM ( column1 ) AS column1, SUM ( column2 ) AS column2, date_time AS date_time FROM report_tk WHERE date_time >= 20200406 AND date_time <= 20200416 AND publisher_id = 22 GROUP BY date_time ) AS tk, ( SELECT SUM ( column3 ) AS column3, SUM ( column4 ) AS column4, date_time AS date_time FROM report_unit_utce8 WHERE date_time >= 20200406 AND date_time <= 20200416 AND publisher_id = 22 GROUP BY date_time ) AS unit, ( SELECT SUM ( column5 ) AS column5, date_time AS date_time FROM report_dau_app WHERE date_time >= 20200406 AND date_time <= 20200416 AND publisher_id = 22 AND channel = '&&' GROUP BY date_time ) AS dau, ( SELECT SUM ( column6 ) AS column6, date_time AS date_time FROM report_deu_app WHERE date_time >= 20200406 AND date_time <= 20200416 AND publisher_id = 22 AND channel = '&&' GROUP BY date_time ) AS deu, ( SELECT SUM ( column7 ) AS column7, SUM ( column8 ) AS column8, date_time AS date_time FROM report_retention WHERE date_time >= 20200406 AND date_time <= 20200416 AND publisher_id = 22 AND channel = '&&' GROUP BY date_time ) AS retention WHERE tk.date_time = unit.date_time AND tk.date_time = dau.date_time AND tk.date_time = deu.date_time AND tk.date_time = retention.date_time ORDER BY date_time DESC LIMIT 15 OFFSET 0
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。