drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristine Hahn (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-2354) Documentation for Concat Function & Concat Operator
Date Tue, 07 Apr 2015 01:54:13 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kristine Hahn resolved DRILL-2354.
----------------------------------
    Resolution: Fixed

Thanks for the info. The following sections are ready for review:

The [CONCAT function|http://drill.apache.org/docs/string-manipulation/#concat] on the String
Manipulation page: http://drill.apache.org/docs/string-manipulation, which points to the string
concatenation operator section: http://drill.apache.org/docs/operators/#string-concatenate-operator

> 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)

Mime
View raw message