COLUMN_NOT_FOUND at occasionally with trino|presto

[marun790]

Hi Team,
when executing a select query using appache superset + presto|trino getting column not found that too occasionally.
the same error is occurring in DBeaver also
but able to see the same column while executing aql > show bins.

Trino Error
trino error: {'message': "line 1:14: Column 'name' cannot be resolved", 'errorCode': 47, 'errorName': 'COLUMN_NOT_FOUND', 'errorType': 'USER_ERROR', 'errorLocation': {'lineNumber': 1, 'columnNumber': 14}, 'failureInfo': {'type': 'io.trino.spi.TrinoException', 'message': "line 1:14: Column 'name' cannot be resolved", 'suppressed': [], 'stack': ['io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:48)', 'io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:43)', 'io.trino.sql.analyzer.SemanticExceptions.missingAttributeException(SemanticExceptions.java:33)'

Please help us on this.

Thanks
Arun M

[reugn]

Hi @marun790. Do you have capital letters in the column/bin name?

[marun790]

Hi @reugn thanks for the reply, yes we do have and we following camel case.
also we enabled 'aerospike.case-insensitive-identifiers' in aerospike trino connector.

[reugn]

Unfortunately, the data browser uses the old Trino (PrestoSQL) connector, which does not support capitalization. We will update here as soon as it is upgraded.

[marun790]

Ohh!! thanks for the finding @reugn
but I am just wondering like we getting these issue irrespective of case sensitive, even we can see camel case bin ex:'bookName' in response and complete lower case bin ex:'name' is giving COLUMN_NOT_FOUND.
Is these also because of lower version of connector.
can you please help me to understand :)

[reugn]

The problem is that you can't query using the upper case in the bin (column) or set (table) name because that's not supported. Also, using the lowercase version of the name will not work due to Aerospike objects being case-sensitive. Yet the auto inferred column names will be displayed in lower case.

[marun790]

ok @reugn , thanks for the explanation. we will wait for the upgrade.