hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Thusoo (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-164) Support CASE statement using GenericUDF
Date Mon, 27 Apr 2009 19:24:30 GMT

    [ 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.


Mime
View raw message