manu6909 opened a new issue #9555: ArrayIndexOutOfBoundsException while running groupby query on high granularity column URL: https://github.com/apache/druid/issues/9555 Druid query failed with ArrayIndexOutOfBoundsException error when running a group by query with a high granularity column. ### Affected Version 0.16.1-incubating ### Description While running a group by query using a high granularity column, druid SQL is throwing ArrayIndexOutOfBoundsException. This issue only observed while using a specific column in the group by clause Distinct values of the column used: 37 million Cluster setup: 5 node cluster with 2 brokers, 3 historicals and 1 master **Scenario 1** Query with group by and order by clause Query executed: `SELECT sum(total_bytes) as a, url from proxy_agg group by 2 order by 1 desc` Result : ERROR Exception log from broker log: Attachment (scenario1_broker.log) **Scenario 2** Query with group by, order by and limit clause Query executed: `SELECT sum(total_cs_bytes) as a, url from proxy_agg group by 2 order by 1 desc, 2 asc limit 1000` Result : ERROR Exception log from broker log: Attachment (scenario2_broker.log) [scenario1_broker.log](https://github.com/apache/druid/files/4368235/scenario1_broker.log) [scenario2_broker.log](https://github.com/apache/druid/files/4368237/scenario2_broker.log)
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
