SQL: support CASE (WHEN) expression #36200
Comments
|
Pinging @elastic/es-search |
|
Hello, in our use case it is vital to have the CASE (WHEN), is there an estimated date when this functionality would come into production? |
|
Hi. This is on our roadmap and once we clarify the schedule we'll update the issue. Rest assured, we created the issue because we want to have this functionality addressed as we'll ship it as soon as possible. Once we have concrete dates, we'll update the ticket. |
Implement the ANSI SQL CASE expression which provides the if/else functionality common to most programming languages. The CASE expression can have multiple WHEN branches and becomes a powerful tool for SQL queries as it can be used in SELECT, WHERE, GROUP BY, HAVING and ORDER BY clauses. Closes: elastic#36200
Implement the ANSI SQL CASE expression which provides the if/else functionality common to most programming languages. The CASE expression can have multiple WHEN branches and becomes a powerful tool for SQL queries as it can be used in SELECT, WHERE, GROUP BY, HAVING and ORDER BY clauses. Closes: #36200
Implement the ANSI SQL CASE expression which provides the if/else functionality common to most programming languages. The CASE expression can have multiple WHEN branches and becomes a powerful tool for SQL queries as it can be used in SELECT, WHERE, GROUP BY, HAVING and ORDER BY clauses. Closes: #36200 (cherry picked from commit 8b25774)
|
Backported to |
Implement the ANSI SQL CASE expression which provides the if/else functionality common to most programming languages. The CASE expression can have multiple WHEN branches and becomes a powerful tool for SQL queries as it can be used in SELECT, WHERE, GROUP BY, HAVING and ORDER BY clauses. Closes: elastic#36200
|
Despite improvements I'm unable to make this query work, SELECT Are there plans to add this functionality? Thanks |
|
Hi new here for elastic search ; please go through this link and help Thanks |
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-2017
Simples use case:
SELECT (CASE WHEN (value = 1) THEN 'yes' ELSE 'no' END) AS decision FROM testThe text was updated successfully, but these errors were encountered: