[
https://issues.apache.org/jira/browse/FLINK-6068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15933989#comment-15933989
]
ASF GitHub Bot commented on FLINK-6068:
---------------------------------------
Github user KurtYoung commented on the issue:
https://github.com/apache/flink/pull/3553
Since `IF` is not sql standard, i think we could let java user just use
`case when`
> Support If() as a built-in function of TableAPI
> -----------------------------------------------
>
> Key: FLINK-6068
> URL: https://issues.apache.org/jira/browse/FLINK-6068
> Project: Flink
> Issue Type: Improvement
> Components: Table API & SQL
> Reporter: Zhuoluo Yang
> Assignee: Zhuoluo Yang
>
> Most sql system support if() as a built-in udf. However, we didn't register
> the if() in the function category. A great many of our users use syntax
> 'if(a, b, c)'. Also most sql systems support 'if(a, b, c)' syntax.
> Mysql:
> https://dev.mysql.com/doc/refman/5.7/en/control-flow-functions.html#function_if
> Hive:
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-ConditionalFunctions
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)