chundongwang-css opened a new issue #6393:
URL: https://github.com/apache/incubator-pinot/issues/6393
We're getting
`QueryExecutionError:\njava.lang.ArrayIndexOutOfBoundsException` while
executing below query:
```sql
SELECT name as key_col, COUNT(*) as val_col
FROM orders
WHERE created_at_seconds BETWEEN 1606756268 AND 1609175468
AND (organization_id <> 'example_uuid')
GROUP BY key_col
ORDER BY val_col DESC
LIMIT 5
```
The error log on server nodes are like,
```log
2020/12/29 17:50:16.761 ERROR [GroupByOrderByCombineOperator] [pqw-7] Caught
exception while processing and combining group-by order-by for index: 1,
operator:
org.apache.pinot.core.operator.query.AggregationGroupByOrderByOperator,
queryContext: QueryContext{_selectExpressions=[name, count(*)],
_aliasMap={name=key_col, count(*)=val_col},
_filter=(created_at_seconds BETWEEN '1606756268' AND '1609175468' AND
organization_id != 'example_uuid'), _groupByExpressions=[name],
_orderByExpressions=[count(*) DESC], _havingFilter=null,
_limit=5, _offset=0, _queryOptions={responseFormat=sql, groupByMode=sql,
timeoutMs=24999}, _debugOptions=null,
_brokerRequest=BrokerRequest(querySource:QuerySource(
tableName:enriched_station_orders_v1_OFFLINE), filterQuery:FilterQuery(id:0,
value:null, operator:AND, nestedFilterQueryIds:[1, 2]),
aggregationsInfo:[AggregationInfo(aggregationType:COUNT,
aggregationParams:{column=*}, isInSelectList:true, expressions:[*])],
groupBy:GroupBy(topN:5, expressions:[name]),
filterSubQueryMap:FilterQueryMap(filterQueryMap:{0=FilterQuery(id:0,
value:null,
operator:AND, nestedFilterQueryIds:[1, 2]), 1=FilterQuery(id:1,
column:created_at_seconds, value:[[1606756268 1609175468]],
operator:RANGE, nestedFilterQueryIds:[]), 2=FilterQuery(id:2,
column:organization_id, value:[example_uuid], operator:NOT,
nestedFilterQueryIds:[])}), queryOptions:{responseFormat=sql, groupByMode=sql,
timeoutMs=24999}, pinotQuery:PinotQuery(
dataSource:DataSource(tableName:enriched_station_orders_v1_OFFLINE),
selectList:[Expression(type:FUNCTION, functionCall:Function(operator:AS,
operands:[Expression(type:IDENTIFIER,
identifier:Identifier(name:name)), Expression(type:IDENTIFIER,
identifier:Identifier(name:key_col))])), Expression(type:FUNCTION,
functionCall:Function(operator:AS, operands:[Expression(
type:FUNCTION, functionCall:Function(operator:COUNT,
operands:[Expression(type:IDENTIFIER, identifier:Identifier(name:*))])),
Expression(type:IDENTIFIER, identifier:Identifier(name:val_col))]))],
filterExpression:Expression(type:FUNCTION,
functionCall:Function(operator:AND, operands:[Expression(type:FUNCTION,
functionCall:Function(operator:BETWEEN, operands:[Expression(type:IDENTIFIER,
identifier:Identifier(name:created_at_seconds)), Expression(type:LITERAL,
literal:<Literal longValue:1606756268>), Expression(type:LITERAL,
literal:<Literal longValue:1609175468>)])), Expression(
type:FUNCTION, functionCall:Function(operator:NOT_EQUALS,
operands:[Expression(type:IDENTIFIER,
identifier:Identifier(name:organization_id)), Expression(type:LITERAL,
literal:<Literal
stringValue:example_uuid>)]))])), groupByList:[Expression(type:IDENTIFIER,
identifier:Identifier(name:name))], orderByList:[Expression(type:FUNCTION,
functionCall:Function(operator:DESC,
operands:[Expression(type:FUNCTION, functionCall:Function(operator:COUNT,
operands:[Expression(type:IDENTIFIER, identifier:Identifier(name:*))]))]))],
limit:5), orderBy:[SelectionSort(
column:count(*), isAsc:false)], limit:5)}
```
Similar query would work fine on same table with different set of data, or
other column. So this might be some kind of data hitting a issue in the logic.
----------------------------------------------------------------
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:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org
