prestodb/presto · error · IllegalArgumentException

Unexpected column for table '%s$query': %s

Error message

Unexpected column for table '%s$query': %s

What it means

Column-handle consistency check for passthrough-query ($query) tables: getColumnMetadata received a column handle whose name is not the expected query column, meaning the handle does not belong to this virtual table.

Source

Thrown at presto-elasticsearch/src/main/java/com/facebook/presto/elasticsearch/ElasticsearchMetadata.java:397

            return queryTableColumns;
        }

        InternalTableMetadata tableMetadata = makeInternalTableMetadata(session, tableHandle);
        return tableMetadata.getColumnHandles();
    }

    @Override
    public ColumnMetadata getColumnMetadata(ConnectorSession session, ConnectorTableHandle tableHandle, ColumnHandle columnHandle)
    {
        ElasticsearchTableHandle table = (ElasticsearchTableHandle) tableHandle;
        ElasticsearchColumnHandle column = (ElasticsearchColumnHandle) columnHandle;

        if (isPassthroughQuery(table)) {
            if (column.getName().equals(queryResultColumnMetadata.getName())) {
                return queryResultColumnMetadata;
            }

            throw new IllegalArgumentException(format("Unexpected column for table '%s$query': %s", table.getIndex(), column.getName()));
        }

        return ColumnMetadata.builder()
                .setName(column.getName())
                .setType(column.getType())
                .build();
    }

    private static boolean isPassthroughQuery(ElasticsearchTableHandle table)
    {
        return table.getType().equals(QUERY);
    }

    @Override
    public Map<SchemaTableName, List<ColumnMetadata>> listTableColumns(ConnectorSession session, SchemaTablePrefix prefix)
    {
        if (prefix.getSchemaName() != null && !prefix.getSchemaName().equals(schemaName)) {
            return ImmutableMap.of();

View on GitHub (pinned to 55bb57d202)

Solutions

1. Refresh metadata so column handles match the current $query table
2. Avoid mixing column handles from different table handles

When it happens

Trigger: Thrown at presto-elasticsearch/src/main/java/com/facebook/presto/elasticsearch/ElasticsearchMetadata.java:397 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of prestodb/presto@55bb57d202 (2026-09-04). Data as JSON: /api/errors/b71243166fb726f9. Report an issue: GitHub.