[ 
https://issues.apache.org/jira/browse/IMPALA-15285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18108000#comment-18108000
 ] 

ASF subversion and git services commented on IMPALA-15285:
----------------------------------------------------------

Commit 934656bfa2b9533f2b30dbd87a1b14e51053a98e in impala's branch 
refs/heads/master from stiga-huang
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=934656bfa ]

IMPALA-15285: Deflake test_spilling_aggs no spilling

There are some backend improvements that reduce the memory usage of
pre-aggregation nodes. test_spilling_aggs expects the query to spill by
setting query option buffer_pool_limit to a small value (30m). But now
it's not always spill. This decreases the query option to a lower value.

Testing
 - Ran the test locally

Change-Id: I35d7b7aa6ab45299dd1af06277c650f97bc1b765
Reviewed-on: http://gerrit.cloudera.org:8080/24726
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>


> test_spilling_aggs fails with no spilling
> -----------------------------------------
>
>                 Key: IMPALA-15285
>                 URL: https://issues.apache.org/jira/browse/IMPALA-15285
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Quanlong Huang
>            Assignee: Quanlong Huang
>            Priority: Major
>         Attachments: agg_no_spilling_profile.txt
>
>
> TestSpillingDebugActionDimensions.test_spilling_aggs fails intermittently due 
> to the query is not spilling.
> {noformat}
> AssertionError: Aggregation of SUM over SpilledPartitions did not match 
> expected results.
>   EXPECTED VALUE:
>   0
>   
>   
>   ACTUAL VALUE:
>   0
>   
>   OP:
>   >{noformat}
> The query is the first one in 
> testdata/workloads/functional-query/queries/QueryTest/spilling-aggs.test
> {code:sql}
> select l_orderkey, count(*)
> from lineitem
> group by 1
> order by 1 limit 10;{code}
> We might need to decrease buffer_pool_limit again like IMPALA-9452.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to