[ https://issues.apache.org/jira/browse/DRILL-2054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14302818#comment-14302818 ]
Mehant Baid commented on DRILL-2054: ------------------------------------ You can make '||' work as both boolean OR and as concat operator. In DrillOptiq you can transform Optiq's '||' into a Drill function say for example 'new_polymorphic_function'. You can add the new function name to existing implementation of boolean OR and concat functions as an alias. When we materialize this new function we should bind to the correct type based on the input. > 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-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)