[jira] [Commented] (PIG-2929) CONCAT returns null when 1 items is null

["Nicholas Verbeck (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PIG-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13464885#comment-13464885 ] 

Nicholas Verbeck commented on PIG-2929:
---------------------------------------

This all makes since. The addition of comments was more the main goal I was looking for. Just to prevent anyone else from having the assumptions I had.

However I did managed to solve the issue without a UDF by leveraging the ternary operations. ie. CONCAT(domain is null?"":domain, path is null?"":path). The case I had was concating parts of a URL back together. Where the Query String might be null if there wasn't one.
                
> CONCAT returns null when 1 items is null
> ----------------------------------------
>
>                 Key: PIG-2929
>                 URL: https://issues.apache.org/jira/browse/PIG-2929
>             Project: Pig
>          Issue Type: Bug
>          Components: documentation, internal-udfs
>    Affects Versions: 0.9.0, 0.9.1, 0.9.2
>            Reporter: Nicholas Verbeck
>            Assignee: Cheolsoo Park
>             Fix For: 0.11
>
>         Attachments: PIG-2929.patch
>
>
> Just stumbled upon this issue over the weekend. It appears the built-in CONCAT function will return null in the advent of 1 item in the Tuple being null. If this is as intended it would be nice if the docs made note of this. Otherwise it would be nice if nulls where just skipped and a proper string of what was left was returned. If all items are null then just return null in that case.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira