[ https://issues.apache.org/jira/browse/DRILL-2354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman reopened DRILL-2354: ------------------------------------- > Documentation for Concat Function & Concat Operator > ---------------------------------------------------- > > Key: DRILL-2354 > URL: https://issues.apache.org/jira/browse/DRILL-2354 > Project: Apache Drill > Issue Type: Improvement > Components: Documentation > Reporter: Sean Hsuan-Yi Chu > Assignee: Kristine Hahn > > In Drill, we have two ways to concatenate Strings: > 1. Concat Function: concat(c1, c2, c3, ...) > 2. Concat Operator: c1 || c2 || c3 || ... > They are doing same thing except for dealing with NULL: > 1. For concat function, NULL is treated as empty string > 2. For concat operator: if any input is NULL, output NULL (no matter what > other columns are) > These are subtle difference and would be better to be documented. > -------------------------------------------------------------------- > Some discussion can be found from DRILL-2328 -- This message was sent by Atlassian JIRA (v6.3.4#6332)