Balkar Lathwal
08/18/2025, 3:18 PMBalkar Lathwal
08/18/2025, 3:19 PMQueryPlanningError:\n'
'Error composing query plan for: SELECT * from '
'ace_watchtower_agents_agent_kpi_events WHERE manager_ids = '
"'GU2406261237361289228350'\n"
'LIMIT 10001\n'
'org.apache.pinot.query.QueryEnvironment.planQuery(QueryEnvironment.java:138)\n'
'org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:158)\n'
'org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:133)\n'
'org.apache.pinot.broker.requesthandler.BrokerRequestHandlerDelegate.handleRequest(BrokerRequestHandlerDelegate.java:86)\n'
'Failed to convert query to relational expression:\n'
'SELECT `ace_watchtower_agents_agent_kpi_events`.`event_name`, '
'`ace_watchtower_agents_agent_kpi_events`.`event_timestamp`, '
'`ace_watchtower_agents_agent_kpi_events`.`executioner_id`, '
'`ace_watchtower_agents_agent_kpi_events`.`ingestion_timestamp`, '
'`ace_watchtower_agents_agent_kpi_events`.`manager_ids`, '
'`ace_watchtower_agents_agent_kpi_events`.`unique_key`\n'
'FROM `default`.`ace_watchtower_agents_agent_kpi_events` AS '
'`ace_watchtower_agents_agent_kpi_events`\n'
'WHERE `ace_watchtower_agents_agent_kpi_events`.`manager_ids` = '
"CAST('GU2406261237361289228350' AS VARCHAR CHARACTER SET `UTF-8` "
'ARRAY)\n'
'FETCH NEXT 10001 ROWS ONLY\n'
'org.apache.pinot.query.QueryEnvironment.toRelation(QueryEnvironment.java:259)\n'
'org.apache.pinot.query.QueryEnvironment.compileQuery(QueryEnvironment.java:235)\n'
'org.apache.pinot.query.QueryEnvironment.planQuery(QueryEnvironment.java:129)\n'
'org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:158)\n'
'while converting '
'`ace_watchtower_agents_agent_kpi_events`.`manager_ids` = '
"CAST('GU2406261237361289228350' AS VARCHAR CHARACTER SET `UTF-8` "
'ARRAY)\n'
'org.apache.calcite.sql2rel.ReflectiveConvertletTable.lambda$registerNodeTypeMethod$1(ReflectiveConvertletTable.java:99)\n'
'org.apache.calcite.sql2rel.SqlNodeToRexConverterImpl.convertCall(SqlNodeToRexConverterImpl.java:61)\n'
'org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:5838)\n'
'org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4985)\n'
'null\n'
'jdk.internal.reflect.GeneratedMethodAccessor403.invoke(Unknown '
'Source)\n'
'java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n'
'java.base/java.lang.reflect.Method.invoke(Method.java:566)\n'
'org.apache.calcite.sql2rel.ReflectiveConvertletTable.lambda$registerNodeTypeMethod$1(ReflectiveConvertletTable.java:95)\n'
"Was not expecting value 'ARRAY' for enumeration "
"'org.apache.calcite.sql.type.SqlTypeName' in this context\n"
'org.apache.calcite.util.Util.unexpected(Util.java:1928)\n'
'org.apache.calcite.rex.RexLiteral.valueMatchesType(RexLiteral.java:397)\n'
'org.apache.calcite.rex.RexBuilder.canRemoveCastFromLiteral(RexBuilder.java:693)\n'
'org.apache.calcite.rex.RexBuilder.makeCast(RexBuilder.java:604)\n'}Balkar Lathwal
08/18/2025, 3:20 PMBalkar Lathwal
08/18/2025, 3:20 PMBalkar Lathwal
08/18/2025, 3:20 PMBalkar Lathwal
08/18/2025, 3:21 PM{
"schemaName": "ace_watchtower_agents_agent_kpi_events",
"enableColumnBasedNullHandling": true,
"dimensionFieldSpecs": [
{
"name": "executioner_id",
"dataType": "STRING",
"notNull": true
},
{
"name": "event_name",
"dataType": "STRING",
"notNull": true
},
{
"name": "manager_ids",
"dataType": "STRING",
"singleValueField": false,
"notNull": false
},
{
"name": "unique_key",
"dataType": "STRING",
"notNull": true
}
],
"dateTimeFieldSpecs": [
{
"name": "event_timestamp",
"dataType": "LONG",
"notNull": false,
"format": "1:MILLISECONDS:EPOCH",
"granularity": "1:MILLISECONDS"
},
{
"name": "ingestion_timestamp",
"dataType": "LONG",
"notNull": false,
"format": "1:MILLISECONDS:EPOCH",
"granularity": "1:MILLISECONDS"
}
]
}Balkar Lathwal
08/18/2025, 3:22 PMBalkar Lathwal
08/18/2025, 3:22 PMBalkar Lathwal
08/18/2025, 3:23 PMXiang Fu
'GU2406261237361289228350'Balkar Lathwal
08/18/2025, 3:38 PM'From line 1, column 73 to line 1, column 96: Column '
"'GU2406261237361289228350' not found in any table\n"Balkar Lathwal
08/18/2025, 3:39 PMXiang Fu
GU2406261237361289228350 which makes the sql parser to recognize GU2406261237361289228350 as a column nameXiang Fu
Xiang Fu
Balkar Lathwal
08/18/2025, 4:01 PMBalkar Lathwal
08/18/2025, 4:01 PMBalkar Lathwal
08/18/2025, 4:01 PMBalkar Lathwal
08/18/2025, 4:02 PMXiang Fu
Balkar Lathwal
08/18/2025, 4:10 PMXiang Fu
Balkar Lathwal
08/18/2025, 4:14 PMXiang Fu
SET useMultistageEngine=true; should workBalkar Lathwal
08/18/2025, 4:18 PMXiang Fu
SET useMultistageEngine=true; SELECT * from ace_watchtower_agents_agent_kpi_events WHERE manager_ids = 'GU2406261237361289228350'Balkar Lathwal
08/18/2025, 4:18 PMXiang Fu
Xiang Fu
Balkar Lathwal
08/18/2025, 4:19 PMXiang Fu
WHERE arrayToMv(manager_ids) IN ('GU2406261237361289228350')Balkar Lathwal
08/18/2025, 4:20 PMBalkar Lathwal
08/18/2025, 4:26 PMBalkar Lathwal
08/18/2025, 4:26 PMBalkar Lathwal
08/18/2025, 4:26 PMBalkar Lathwal
08/18/2025, 4:26 PMXiang Fu
arraytomv is for multiStageEngine onlyBalkar Lathwal
08/18/2025, 4:29 PMBalkar Lathwal
08/18/2025, 4:30 PMXiang Fu
manager_ids as an array but on the right side, it's just a value not arrayXiang Fu
Xiang Fu
Balkar Lathwal
08/18/2025, 4:36 PMBalkar Lathwal
08/18/2025, 4:37 PMBalkar Lathwal
08/18/2025, 4:38 PMXiang Fu
Balkar Lathwal
08/18/2025, 4:59 PM