ES SQL custom mappings

Elastic Stack Elasticsearch
1

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

2

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?

3

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

4

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

5

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

Such as from this post: Custom field type?.

6

I don't know the answer to that. I guess you're just going to have to try it :slight_smile:

Ohh and welcome to the community!

Let's us know what you find out!

7

Custom field types are not supported.