dongxiaoman opened a new issue #7612:
URL: https://github.com/apache/pinot/issues/7612
When we run the below query on our cluster via Pinot UI, we get
`"errorCode": 200,
"message":
"QueryExecutionError:\njava.lang.ArrayIndexOutOfBoundsException"`
The query is simple as
`select account_key from point_entry where account_key =
'1fedf01cdb9aba9395172b5832445d1e' and account_fields_values not in
('intercompany_clearing') limit 1 option(timeoutMs=10000)`
Both of the columns in the query are multi-value columns.
The Server error log is below:
```
Caught exception while executing operator of index: 4 (query:
QueryContext{_tableName='point_entry_OFFLINE',
_selectExpressions=[account_key], _aliasList=[null], _filter=(account_key =
'1fedf01cdb9aba9395172b5832445d1e' AND account_fields_values NOT IN
('intercompany_clearing','cash','merchant_balance','fx_clearing') AND
created_at <= '1634813999'), _groupByExpressions=null, _havingFilter=null,
_orderByExpressions=null, _limit=100, _offset=0,
_queryOptions={responseFormat=sql, groupByMode=sql, timeoutMs=9863},
_debugOptions=null,
_brokerRequest=BrokerRequest(querySource:QuerySource(tableName:point_entry_OFFLINE),
pinotQuery:PinotQuery(dataSource:DataSource(tableName:point_entry_OFFLINE),
selectList:[Expression(type:IDENTIFIER,
identifier:Identifier(name:account_key))],
filterExpression:Expression(type:FUNCTION, functionCall:Function(operator:AND,
operands:[Expression(type:FUNCTION, functionCall:Function(operator:EQUALS,
operands:[Expression(type:IDENTIFIER, identifier:Identifier(n
ame:account_key)), Expression(type:LITERAL, literal:<Literal
stringValue:1fedf01cdb9aba9395172b5832445d1e>)])), Expression(type:FUNCTION,
functionCall:Function(operator:NOT_IN, operands:[Expression(type:IDENTIFIER,
identifier:Identifier(name:account_fields_values)), Expression(type:LITERAL,
literal:<Literal stringValue:intercompany_clearing>), Expression(type:LITERAL,
literal:<Literal stringValue:cash>), Expression(type:LITERAL, literal:<Literal
stringValue:merchant_balance>), Expression(type:LITERAL, literal:<Literal
stringValue:fx_clearing>)])), Expression(type:FUNCTION,
functionCall:Function(operator:LESS_THAN_OR_EQUAL,
operands:[Expression(type:IDENTIFIER, identifier:Identifier(name:created_at)),
Expression(type:LITERAL, literal:<Literal stringValue:1634813999>)]))])),
orderByList:[], limit:100, queryOptions:{responseFormat=sql, groupByMode=sql,
timeoutMs=9863}))})
```
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
