[
https://issues.apache.org/jira/browse/DRILL-2054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14303917#comment-14303917
]
Sean Hsuan-Yi Chu edited comment on DRILL-2054 at 2/3/15 8:28 PM:
------------------------------------------------------------------
Sounds good! But for now, we treat || as concat, which seems more common
around. Thanks anyway!
was (Author: seanhychu):
Hi, Right!!! But for now, we treat || as concat, which seems more common
around. Thanks anyway!
> 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, DRILL-2054.2.patch,
> DRILL-2054ForOptiq.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)
