Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Tue, 3 Feb 2015 20:28:35 +0000 (UTC)
From: "Sean Hsuan-Yi Chu (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12769169.1421889266000.245768.1422995315396@Atlassian.JIRA>
In-Reply-To: <JIRA.12769169.1421889266000@Atlassian.JIRA>
References: <JIRA.12769169.1421889266000@Atlassian.JIRA>
 <JIRA.12769169.1421889266781@arcas>
Subject: [jira] [Commented] (DRILL-2054) Support `||` as "concat operator"
 for varchar inputs
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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 commented on DRILL-2054:
------------------------------------------

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)