[ 
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

Reply via email to