You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "huntersjm (JIRA)" <ji...@apache.org> on 2015/11/17 09:30:10 UTC

[jira] [Created] (DRILL-4100) DRILL JOIN STREAMING AGG ERROR

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)