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

Jinfeng Ni updated DRILL-2054:
------------------------------
    Assignee: Sean Hsuan-Yi Chu  (was: Jinfeng Ni)

> Support `||` as "concat operator" for varchar inputs
> ----------------------------------------------------
>
>                 Key: DRILL-2054
>                 URL: https://issues.apache.org/jira/browse/DRILL-2054
>             Project: Apache Drill
>          Issue Type: New Feature
>            Reporter: Sean Hsuan-Yi Chu
>            Assignee: Sean Hsuan-Yi Chu
>             Fix For: Future
>
>         Attachments: DRILL-2054.1.patch
>
>
> For example, the query:
> select n_nationkey || ' + ' || n_name || ' = ' as CONCAT, n_nationkey, ' + ' 
> as PLUS, n_name from cp.`tpch/nation.parquet`
> should print out 
> CONCAT        n_nationkey     PLUS    n_name
> 0 + ALGERIA =         0        +      ALGERIA
> 1 + ARGENTINA =       1        +      ARGENTINA
> 2 + BRAZIL =  2        +      BRAZIL
> 3 + CANADA =  3        +      CANADA
> ... ... ... (rows/records are omitted due to space limitation)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to