huntersjm created DRILL-4100:
--------------------------------
Summary: DRILL JOIN STREAMING AGG ERROR
Key: DRILL-4100
URL: https://issues.apache.org/jira/browse/DRILL-4100
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Affects Versions: 1.1.0
Reporter: huntersjm
SQL LIKE :
`select t1.a1 from (
select a1,count(a2) as total from t group by a1
) as a join (
select a1,count(a2) as total from t where a3 = 'true' group by a1 order by
total desc limit 100
) as f on t2.a1 = t1.a1
`
GET ERROR RESULT
PART OF Operator Profiles：
01-xx-00 - HASH_PARTITION_SENDER
Minor Fragment Setup Time Process Time Wait Time Max Batches
Max Records Peak Memory
01-00-00 0.000s 0.301s 0.028s 3 65,536 90KB
01-01-00 0.000s 0.406s 0.028s 3 65,536 91KB
01-xx-01 - STREAMING_AGGREGATE
Minor Fragment Setup Time Process Time Wait Time Max Batches
Max Records Peak Memory
01-00-01 0.174s 0.564s 0.000s 29 1,812,457 1MB
01-01-01 0.497s 0.553s 0.000s 29 1,812,973 1MB
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
