You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "lynn (JIRA)" <ji...@apache.org> on 2017/08/08 09:33:00 UTC
[jira] [Created] (HAWQ-1513) "string_agg" function does not support
query optimization on partitioned table
lynn created HAWQ-1513:
--------------------------
Summary: "string_agg" function does not support query optimization on partitioned table
Key: HAWQ-1513
URL: https://issues.apache.org/jira/browse/HAWQ-1513
Project: Apache HAWQ
Issue Type: Test
Components: Catalog
Reporter: lynn
Assignee: Radar Lei
SELECT
mid,
COUNT (*),
string_agg (
create_time ,|| '#' || s_id
ORDER BY
create_time
)
FROM
t1
WHERE
t1.create_time BETWEEN to_timestamp(
'2016-12-19 00:20:00:770',
'yyyy-MM-dd HH24:MI:ss.ff'
)
AND to_timestamp(
'2016-12-19 23:40:00:770',
'yyyy-MM-dd HH24:MI:ss.ff'
)group by mid;
when we explain the sql statement, we find it scan all the partition of table t1 in the query plan, and it has a huge impact on the query performance.
what can i do to solve this problem?
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)