Hello, I'm wondering if it's possible to use ES SQL on custom field mappings for types e.g. long, integer, doubles.
Hi @ES_SQL_HELP Welcome to the community.
Just to be
ES|QL- Elasticsearch Piped Query Language
Or SQL - SQL API
And can you provide an example of what you are trying to do?
Thanks for the response, it's the latter SQL- SQL API.
Investigating into transforming existing term/range queries to SQL type queries but on custom types.
SELECT id FROM index WHERE id > 100
but assuming that the id
field here has a custom type mapping that was generated from a plugin e.g. custom_integer
I do not know what you mean by a custom mapping... you would need to provide example but sure that will work with a long
or integer
Ah sorry, I'm referring to a custom field type that we generate from a plugin.
Such as from this post: Custom field type?.
I don't know the answer to that. I guess you're just going to have to try it
Ohh and welcome to the community!
Let's us know what you find out!
Custom field types are not supported.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.