Case statements doesn't work in kibana canvas. I am using Kibana 6.8.3. Does it support case? For instance the below query giving me weird errors. Like below:
Expression failed with the message:
[essql] Couldnt parse Elasticsearch SQL query. You may need to add double quotes to names containing special characters etc.
Select case when 0>1 then 'hi' end.