hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasad Chakka (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-470) Support COALESCE using GenericUDF
Date Thu, 11 Jun 2009 17:03:07 GMT

    [ https://issues.apache.org/jira/browse/HIVE-470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718557#action_12718557

Prasad Chakka commented on HIVE-470:

I don't see the new test case for COALESCE(NULL, NULL).

how does mysql support it? does it type NULL to whatever type the rest of query expects it
to be there in that column?

> Support COALESCE using GenericUDF
> ---------------------------------
>                 Key: HIVE-470
>                 URL: https://issues.apache.org/jira/browse/HIVE-470
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.4.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>         Attachments: HIVE-470.1.patch, HIVE-470.2.patch
> See HIVE-164 for details. We should support COALESCE which is defined in SQL-92. This
is kind of a syntax sugar, but it is used very frequently in full outer joins.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message