ES SQL custom mappings

[ES_SQL_HELP]

Hello, I'm wondering if it's possible to use ES SQL on custom field mappings for types e.g. long, integer, doubles.

[stephenb (Stephen Brown)]

Hi @ES_SQL_HELP Welcome to the community.

Just to be

ES|QL- Elasticsearch Piped Query Language

ES|QL | Elasticsearch Guide [8.11] | Elastic

Or SQL - SQL API

SQL | Elasticsearch Guide [8.11] | Elastic

And can you provide an example of what you are trying to do?

[ES_SQL_HELP]

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

[stephenb (Stephen Brown)]

@ES_SQL_HELP

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

[ES_SQL_HELP]

Ah sorry, I'm referring to a custom field type that we generate from a plugin.

Such as from this post: Custom field type?.

[stephenb (Stephen Brown)]

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!

[Andrei_Stefan]

Custom field types are not supported.