[GitHub] [druid] manu6909 opened a new issue #9555: ArrayIndexOutOfBoundsException while running groupby query on high granularity column

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org