[DRILL-2054] Support `||` as "concat operator" for varchar inputs

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Future
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Sean Hsuan-Yi Chu
• Created: 22/Jan/15 01:14
• Updated: 24/Apr/15 21:13
• Resolved: 18/Feb/15 19:49

Description

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)

Issue Links

• duplicates: DRILL-2008 select a || b from ... fails while select cast(a as varchar) || cast(b as varchar) from ...
• duplicates: DRILL-1876 Implement concatenation operator ( || )
• duplicates: DRILL-1877 Throw unsupported error message for || operator early in the parsing stage
• duplicates: DRILL-779 Add support for pipes Concat "||" operator
• is depended upon by: DRILL-1877 Throw unsupported error message for || operator early in the parsing stage
• relates to: DRILL-2009 booleanOr should recognize "true" in string/varchar form