[jira] [Created] (HAWQ-1514) TDE feature makes libhdfs3 require openssl1.1

[Yi Jin (JIRA)]

Yi Jin created HAWQ-1514:


 Summary: TDE feature makes libhdfs3 require openssl1.1
 Key: HAWQ-1514
 URL: https://issues.apache.org/jira/browse/HAWQ-1514
 Project: Apache HAWQ
  Issue Type: Task
  Components: libhdfs
Reporter: Yi Jin
Assignee: Radar Lei


New TDE feature delivered in libhdfs3 requires specific version of openssl, at 
least per my test, 1.0.21 does not work, and 1.1 source code built library 
passed.

So maybe we need some build and installation instruction improvement. 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Created] (HAWQ-1513) "string_agg" function does not support query optimization on partitioned table

[lynn (JIRA)]

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',
'-MM-dd HH24:MI:ss.ff'
)
AND to_timestamp(
'2016-12-19 23:40:00:770',
'-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)