-
Notifications
You must be signed in to change notification settings - Fork 186
Distinct * returns empty result #860
Comments
I ran into this today as well, it seems like a browser-side JavaScript issue to me. The failing code is: |
After investigating a bit more, i found that in the above code Elasticsearch returned this error: After changing my query to use the ".keyword" field of the desired field, DISTINCT now works correctly, so this is probably not a bug. |
@mj84 Thanks for your info! But I didn't get why |
My index is nothing special, just some syslog messages with specific parts of the message extracted into separate fields using logstash and grok. The reason is actually explained in the error message from Elasticsearch :) Nonetheless, it would be quite helpful to pass on errors from Elasticsearch like this one to the user. |
In SQL,
DISTINCT *
is used to get distinct row in result set. Currently an empty result is returned for queries as below:The text was updated successfully, but these errors were encountered: