Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
opensearch 2.10
Describe the issue:
Is there a where clause that can be used for ip type in opensearch query workbench (plugin/_sql)?
is null and is not null seem to work, but =, !=, in, and not in do not.
Subquery, group by, and having do not work.
Is there anyone who is solving this problem?
opensearch field type is ip
This is how to use the where clause in the _sql plugin.
It’s not a rdbms query issue