[
https://issues.apache.org/jira/browse/HIVE-164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12703308#action_12703308
]
Ashish Thusoo commented on HIVE-164:
------------------------------------
One comment that I want to make by looking at the unit tests is that mysql
allows implicit conversion on the comparison expressions. I know that we did
not go with the AnyType as the return type of the case statement simply because
we do not have the AnyType. However, we should be able to support implicit
conversion the comparison expressions. I am fine with that going in as part of
a separate JIRA/txn as this one is already quite big and it is important to get
this in.
> Support CASE statement using GenericUDF
> ---------------------------------------
>
> Key: HIVE-164
> URL: https://issues.apache.org/jira/browse/HIVE-164
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Zheng Shao
> Assignee: Zheng Shao
> Attachments: HIVE-164.4.patch, HIVE-164.5.patch,
> HIVE-164.6.code-only.patch, HIVE-164.6.patch, HIVE-164.7.code-only.patch,
> HIVE-164.7.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html for
> details.
> Syntax:
> {code}
> CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result
> ...] [<ELSE result] END
> CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE
> result] END
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
