ArrayIndexOutOfBoundsException from GroupByOrderByCombineOperator

[chundongwang-css]

We're getting QueryExecutionError:\njava.lang.ArrayIndexOutOfBoundsException while executing below query:

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,

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.

[Jackie-Jiang]

It might be related to the \t character within the string column. The fix is included in the 0.6.0 release

[xiangfu0]

@chundongwang-css has this issue resolved?

[chundongwang-css]

@chundongwang-css has this issue resolved?

Cannot verify on 0.6.0 yet but confirmed this is related to \t character. Feel free to resolve it.