You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2020/12/29 18:39:12 UTC
[GitHub] [incubator-pinot] chundongwang-css opened a new issue #6393: ArrayIndexOutOfBoundsException from GroupByOrderByCombineOperator
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [incubator-pinot] chundongwang-css commented on issue #6393: ArrayIndexOutOfBoundsException from GroupByOrderByCombineOperator
Posted by GitBox <gi...@apache.org>.
chundongwang-css commented on issue #6393:
URL: https://github.com/apache/incubator-pinot/issues/6393#issuecomment-754896740
> @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.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [incubator-pinot] fx19880617 commented on issue #6393: ArrayIndexOutOfBoundsException from GroupByOrderByCombineOperator
Posted by GitBox <gi...@apache.org>.
fx19880617 commented on issue #6393:
URL: https://github.com/apache/incubator-pinot/issues/6393#issuecomment-754896131
@chundongwang-css has this issue resolved?
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [incubator-pinot] Jackie-Jiang commented on issue #6393: ArrayIndexOutOfBoundsException from GroupByOrderByCombineOperator
Posted by GitBox <gi...@apache.org>.
Jackie-Jiang commented on issue #6393:
URL: https://github.com/apache/incubator-pinot/issues/6393#issuecomment-752219077
It might be related to the `\t` character within the string column. The [fix](https://github.com/apache/incubator-pinot/pull/5858) is included in the `0.6.0` release
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org