Skip to content

Elasticsearch array fields cause query failure even though array property is NOT selected #25905

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
StephenOTT opened this issue Jun 2, 2025 · 0 comments

Comments

@StephenOTT
Copy link

StephenOTT commented Jun 2, 2025

Working on trino 453.

Consider a query such as:

select "@timestamp", "labels".some_prop from my_catalog.default.".apm.somelogs*" limit 5

the labels is an object.

One of the properties is the labels.process_command_args which is populated by OpenTelemetry and APM is an ArrayList.

But when the query above is run i get an error such as:

"Expect a string or numeric value for field 'labels.process_command_args` of type VARCHAR....".

My expectation is i would only need to set the array list support in the _meta when i actually need the property.

my some_prop is just a varchar.

Are we seeing that if a document contains an array list then you MUST apply the _meta configs even though we do NOT use the values in the query and response?

Thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant