xiangfu0 commented on code in PR #11117:
URL: https://github.com/apache/pinot/pull/11117#discussion_r1271015899
##########
pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/MultiStageEngineIntegrationTest.java:
##########
@@ -485,6 +486,25 @@ public void testLiteralOnlyFunc()
assertEquals(results.get(10).asText(), "hello!");
}
+ @Test
+ public void testMultiValueColumnGroupBy()
+ throws Exception {
+ String pinotQuery = "SELECT count(*), arrayToMV(RandomAirports) FROM
mytable "
+ + "GROUP BY arrayToMV(RandomAirports)";
+ JsonNode jsonNode = postQuery(pinotQuery);
+ Assert.assertEquals(jsonNode.get("resultTable").get("rows").size(), 154);
+ }
+
+ @Test
+ public void testMultiValueColumnGroupByOrderBy()
+ throws Exception {
+ String pinotQuery = "SELECT count(*), arrayToMV(RandomAirports) FROM
mytable "
Review Comment:
This only works at leaf stage not intermediate stage.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org
