# CASE WHEN THEN

**URL:** <https://discuss.elastic.co/t/case-when-then/192756>\
**Category:** Elasticsearch\
**Created:** [July 29, 2019, 6:15pm UTC](https://discuss.elastic.co/t/case-when-then/192756 "2019-07-29T18:15:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Farouk6072](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farouk6072/32/50492_2.png) [@Farouk6072](https://discuss.elastic.co/u/Farouk6072)\
**Post date:** [July 29, 2019, 6:15pm UTC](https://discuss.elastic.co/t/case-when-then/192756/1 "2019-07-29T18:15:14Z")

</div>

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'}

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [July 30, 2019, 10:02am UTC](https://discuss.elastic.co/t/case-when-then/192756/2 "2019-07-30T10:02:35Z")

</div>

@Farouk6072 what Elasticsearch version is this?

---

<div class="post-metadata">

**Author:** ![Farouk6072](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farouk6072/32/50492_2.png) [@Farouk6072](https://discuss.elastic.co/u/Farouk6072)\
**Post date:** [July 30, 2019, 12:36pm UTC](https://discuss.elastic.co/t/case-when-then/192756/3 "2019-07-30T12:36:37Z")

</div>

v6.6.1 cloud version

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [July 30, 2019, 12:50pm UTC](https://discuss.elastic.co/t/case-when-then/192756/4 "2019-07-30T12:50:00Z")

</div>

`CASE WHEN` has been added in 7.2.0 and the error you get is the expected one. That feature is simply not available in 6.x. [https://github.com/elastic/elasticsearch/issues/36200](https://github.com/elastic/elasticsearch/issues/36200)

---

<div class="post-metadata">

**Author:** ![Farouk6072](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farouk6072/32/50492_2.png) [@Farouk6072](https://discuss.elastic.co/u/Farouk6072)\
**Post date:** [July 30, 2019, 1:42pm UTC](https://discuss.elastic.co/t/case-when-then/192756/5 "2019-07-30T13:42:23Z")

</div>

Thank you very much

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 27, 2019, 1:42pm UTC](https://discuss.elastic.co/t/case-when-then/192756/6 "2019-08-27T13:42:30Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.