Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2354

Documentation for Concat Function & Concat Operator

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                krishahn Kris Hahn
                Reporter:
                seanhychu Sean Hsuan-Yi Chu
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: