opensearch-project / sql

Query your data using familiar SQL or intuitive Piped Processing Language (PPL)

https://opensearch.org/docs/latest/search-plugins/sql/index/

Apache License 2.0

116 stars 134 forks source link

[FEATURE] Support more opensearch data types, like ranges #895

Open Yury-Fridlyand opened 1 year ago

Yury-Fridlyand commented 1 year ago

Is your feature request related to a problem?

Some of OpenSearch data types are not supported. V2 just ignores columns with them.

Range types:
- integer_range
- long_range
- double_range
- float_range
- date_range
- ip_range
String
- token_count
Geographic
- `geo_shape

Other types (TBD how to interpret them):

alias
Object
- join
Autocomplete - interpret as strings TBD
- completion
- search_as_you_type
Rank - interpret as numbers/nested TBD
- rank_feature
- rank_features

What solution would you like?

SQL plugin should support querying on these types.

What alternatives have you considered?

First stage of implementation should support types from the first list above.
All these types could be processed as strings

Do you have any additional context?

465

891

dai-chen commented 1 year ago

Old tracking issue for reference: https://github.com/opensearch-project/sql/issues/44