walterddr opened a new issue, #9980: URL: https://github.com/apache/pinot/issues/9980
Problematic GROUP BY V1 behavior returns STRING instead of INT as indicated in schema see: https://github.com/apache/pinot/actions/runs/3688265209/jobs/6242862869 ``` 2022-12-13T18:43:31.7985289Z [ERROR] org.apache.pinot.integration.tests.MultiStageEngineIntegrationTest.testGeneratedQueries Time elapsed: 14.5 s <<< FAILURE! 2022-12-13T18:43:31.7985807Z java.lang.AssertionError: 2022-12-13T18:43:31.7986071Z Caught exception while testing query! 2022-12-13T18:43:31.7986778Z Pinot query: SELECT DepartureDelayGroups, Flights FROM mytable WHERE FirstDepTime > 1504 AND DepDel15 BETWEEN 0 AND -9999 AND DestWac BETWEEN 21 AND 51 GROUP BY DepartureDelayGroups, Flights LIMIT 10000 2022-12-13T18:43:31.7987617Z H2 query: SELECT DepartureDelayGroups, Flights FROM mytable WHERE FirstDepTime > 1504 AND DepDel15 BETWEEN 0 AND -9999 AND DestWac BETWEEN 21 AND 51 GROUP BY DepartureDelayGroups, Flights LIMIT 10000 2022-12-13T18:43:31.7988094Z at org.testng.Assert.fail(Assert.java:82) 2022-12-13T18:43:31.7988602Z at org.apache.pinot.integration.tests.ClusterIntegrationTestUtils.failure(ClusterIntegrationTestUtils.java:889) 2022-12-13T18:43:31.7989290Z at org.apache.pinot.integration.tests.ClusterIntegrationTestUtils.testQuery(ClusterIntegrationTestUtils.java:568) 2022-12-13T18:43:31.7990007Z at org.apache.pinot.integration.tests.MultiStageEngineIntegrationTest.testQuery(MultiStageEngineIntegrationTest.java:128) 2022-12-13T18:43:31.7990760Z at org.apache.pinot.integration.tests.BaseClusterIntegrationTestSet.testGeneratedQueries(BaseClusterIntegrationTestSet.java:448) 2022-12-13T18:43:31.7991569Z at org.apache.pinot.integration.tests.MultiStageEngineIntegrationTest.testGeneratedQueries(MultiStageEngineIntegrationTest.java:99) ... 2022-12-13T18:43:31.8009092Z Caused by: java.lang.RuntimeException: Got Exceptions from Query Response: {"exceptions":[{"errorCode":200,"message":"QueryExecutionError:\njava.lang.RuntimeException: Received error query execution result block: {1000=Incompatible selection result data schema: Expected: [DepartureDelayGroups(INT),Flights(INT)]. Actual: [DepartureDelayGroups(STRING),Flights(STRING)]\njava.lang.IllegalStateException: Incompatible selection result data schema: Expected: [DepartureDelayGroups(INT),Flights(INT)]. Actual: [DepartureDelayGroups(STRING),Flights(STRING)]\n\tat com.google.common.base.Preconditions.checkState(Preconditions.java:444)\n\tat org.apache.pinot.query.runtime.operator.LeafStageTransferableBlockOperator.composeDistinctTransferableBlock(LeafStageTransferableBlockOperator.java:150)\n\tat org.apache.pinot.query.runtime.operator.LeafStageTransferableBlockOperator.composeTransferableBlock(LeafStageTransferableBlockOperator.java:129)"}],"numServersQueried": 0,"numServersResponded":0,"numSegmentsQueried":0,"numSegmentsProcessed":0,"numSegmentsMatched":0,"numConsumingSegmentsQueried":0,"numConsumingSegmentsProcessed":0,"numConsumingSegmentsMatched":0,"numDocsScanned":0,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":0,"timeUsedMs":0,"offlineThreadCpuTimeNs":0,"realtimeThreadCpuTimeNs":0,"offlineSystemActivitiesCpuTimeNs":0,"realtimeSystemActivitiesCpuTimeNs":0,"offlineResponseSerializationCpuTimeNs":0,"realtimeResponseSerializationCpuTimeNs":0,"offlineTotalCpuTimeNs":0,"realtimeTotalCpuTimeNs":0,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0,"numRowsResultSet":0,"numSegmentsPrunedByBroker":0,"numSegmentsPrunedByServer":0,"numSegmentsPrunedInvalid":0,"numSegmentsPrunedByLimit":0,"numSegmentsPrunedByValue":0,"explainPlanNumEmptyFilterSegments":0,"explainPlanNumMatchAllFilterSegments":0} 2022-12-13T18:43:31.8012893Z at org.apache.pinot.integration.tests.ClusterIntegrationTestUtils.testQueryInternal(ClusterIntegrationTestUtils.java:579) 2022-12-13T18:43:31.8013695Z at org.apache.pinot.integration.tests.ClusterIntegrationTestUtils.testQuery(ClusterIntegrationTestUtils.java:566) 2022-12-13T18:43:31.8014265Z ... 33 more 2022-12-13T18:43:31.8014944Z 2022-12-13T18:43:31.8015719Z [ERROR] org.apache.pinot.integration.tests.MultiStageEngineIntegrationTest.testHardcodedQueriesMultiStage Time elapsed: 4.356 s 2022-12-13T18:43:32.9604692Z [INFO] Running org.apache.pinot.integration.tests.ControllerPeriodicTasksIntegrationTest 2022-12-13T18:44:59.5704240Z Dec 13, 2022 6:43:46 PM org.glassfish.grizzly.http.server.NetworkListener start\ ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
