drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "huntersjm (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-4100) DRILL JOIN STREAMING AGG ERROR
Date Thu, 19 Nov 2015 01:30:11 GMT

     [ https://issues.apache.org/jira/browse/DRILL-4100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

huntersjm updated DRILL-4100:
-----------------------------
    Description: 
SQL LIKE :
{code:sql}
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 
{code}
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



  was:
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




> 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 :
> {code:sql}
> 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 
> {code}
> 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)

Mime
View raw message