You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/03/02 18:38:05 UTC
[jira] [Created] (DRILL-2354) Documentation for Concat Function &
Concat Operator
Sean Hsuan-Yi Chu created DRILL-2354:
----------------------------------------
Summary: 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: Bridget Bevens
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)