I have put this Query on Canva Elasticsearch SQL query :
SELECT CASE sexe
WHEN 1 THEN 'Male'
WHEN 2 THEN 'Female'
END
FROM "test*"
WHERE sexe IS NOT NULL
I have this error message :
Whoops! Expression failed
Expression failed with the message:
[essql] > Couldn't parse Elasticsearch SQL query. You may need to add double quotes to names containing special characters. Check your query and try again. Error: [parsing_exception] line 2:1: mismatched input 'WHEN' expecting {, ',', 'FROM', 'GROUP', 'HAVING', 'LIMIT', 'ORDER', 'WHERE', '{LIMIT'}