Trino stored Iceberg column in lower case #24977
Unanswered
Zeev-Shavit
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi,
We ingest data into an Iceberg tables from Kafka topic.
The fields names in the topic coming in camel case, but the column names from those fields are written in lower case.
The ROW type column and ARRAY[ROW] column still consists nested fields as camel case.
When trying to query referencing the nested field, we got an error as follows:
Column '.'providerid'' cannot be resolved when the column providerid actually is ProviderId:
Select
<column_name>.ProviderId
from my_table
I tried using double-qouets:
Select
<column_name>."ProviderId"
from my_table
And single-quotes:
Select
<column_name>.'ProviderId'
from my_table
Beta Was this translation helpful? Give feedback.
All reactions