[
https://issues.apache.org/jira/browse/DRILL-6516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16535497#comment-16535497
]
ASF GitHub Bot commented on DRILL-6516:
---------------------------------------
Ben-Zvi commented on a change in pull request #1358: DRILL-6516: EMIT support
in streaming agg
URL: https://github.com/apache/drill/pull/1358#discussion_r200756450
##########
File path:
exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java
##########
@@ -394,4 +394,47 @@ public void testLateral_HashAgg_with_nulls() throws
Exception {
.baselineValues("dd",222L)
.build().run();
}
+
+ @Test
+ public void testMultipleBatchesLateral_WithStreamingAgg() throws Exception {
+ String sql = "SELECT t2.maxprice FROM (SELECT customer.c_orders AS
c_orders FROM "
+ + "dfs.`lateraljoin/multipleFiles/` customer) t1, LATERAL (SELECT
CAST(MAX(t.ord.o_totalprice)"
+ + " AS int) AS maxprice FROM UNNEST(t1.c_orders) t(ord) GROUP BY
t.ord.o_orderstatus) t2";
+
+ testBuilder()
+ .optionSettingQueriesForTestQuery("alter session set `%s` = true",
+ PlannerSettings.STREAMAGG.getOptionName())
+ .sqlQuery(sql)
+ .unOrdered()
+ .baselineColumns("maxprice")
+ .baselineValues(367190)
+ .baselineValues(316347)
+ .baselineValues(146610)
+ .baselineValues(306996)
+ .baselineValues(235695)
+ .baselineValues(177819)
+ .build().run();
+ }
+
+ @Test
+ public void testLateral_StreamingAgg_with_nulls() throws Exception {
+ String sql = "SELECT key, t3.dsls FROM cp.`lateraljoin/with_nulls.json` t
LEFT OUTER "
+ + "JOIN LATERAL (SELECT DISTINCT t2.sls AS dsls FROM UNNEST(t.sales)
t2(sls)) t3 ON TRUE";
+
+ testBuilder()
+ .optionSettingQueriesForTestQuery("alter session set `%s` = true",
+ PlannerSettings.STREAMAGG.getOptionName())
Review comment:
Same comment - disable hash-agg.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> Support for EMIT outcome in streaming agg
> -----------------------------------------
>
> Key: DRILL-6516
> URL: https://issues.apache.org/jira/browse/DRILL-6516
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Parth Chandra
> Assignee: Parth Chandra
> Priority: Major
> Fix For: 1.14.0
>
>
> Update the streaming aggregator to recognize the EMIT outcome
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
