IFS to simplify CASE WHEN

[wangsimo0]

In StarRocks, we can only use case when. However, ifs is a more simple way to express case when and widely used in excel, it's very easy to use.

so here is a proposal:

IFS(condition1, then [,condition2, then2, ....], else)

[srikker]

Hi @wangsimo0 , please assign this to me. Thanks!

[happut]

Hi @kateshaowanjou @wangsimo0 , Has this issue been assigned? Could you please assign this to me?
Thanks!

[kateshaowanjou]

@happut Sorry, I just found out @srikker also wants to take this issue. Since he asked first, I assigned this one to him. Can you pick another one? 🙏🏻

[srikker]

This function just make a grammatical transformation or need reImplement? It looks exactly like the "case when" expression.

[LiShuMing]

Yep. I think this can be covered by CaseWhenExpr totally. So just transform to CaseExprr in FE?

[srikker]

Yep. I think this can be covered by CaseWhenExpr totally. So just transform to CaseExprr in FE?

ok

[github-actions]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!