[ https://issues.apache.org/jira/browse/HIVE-14918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15560739#comment-15560739 ]
Xiaowei Wang commented on HIVE-14918: ------------------------------------- I mean, concat_ws('.',NULL) should return NULL not a empty string "" .What do you think? > Function concat_ws get a wrong value > -------------------------------------- > > Key: HIVE-14918 > URL: https://issues.apache.org/jira/browse/HIVE-14918 > Project: Hive > Issue Type: Bug > Components: UDF > Affects Versions: 1.1.1, 2.0.0, 2.1.0, 2.0.1 > Reporter: Xiaowei Wang > Assignee: Xiaowei Wang > Priority: Critical > Fix For: 2.1.0 > > Attachments: HIVE-14918.0.patch > > > FROM src INSERT OVERWRITE TABLE dest1 SELECT 'abc', 'xyz', '8675309' WHERE > src.key = 86; > SELECT concat_ws('.',NULL) FROM dest1 ; > The result is a empty string "",but I think it should be return NULL . -- This message was sent by Atlassian JIRA (v6.3.4#6332)