[DRILL-4100] DRILL JOIN STREAMING AGG ERROR

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.1.0
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: huntersjm
• Created: 17/Nov/15 08:29
• Updated: 19/Nov/15 01:39

Description

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