[DRILL-7321] split function doesn't work without from

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.17.0
• Component/s: Functions - Drill
• Assignee: Vova Vysotskyi
• Reporter: benj
• Created: 10/Jul/19 12:37
• Updated: 08/Aug/19 14:10
• Resolved: 08/Aug/19 14:10

Description

SELECT upper('foo') AS a /* OK */;
+-----+
|  a  |
+-----+
| foo |
+-----+

but

SELECT split('foo,bar,buz',',') AS a /* NOK */;
Error: PLAN ERROR: Failure while materializing expression in constant expression evaluator [SPLIT('foo,bar,buz', ',')].  Errors:
Error in expression at index -1.  Error: Only ProjectRecordBatch could have complex writer function. You are using complex writer function split in a non-project operation!.  Full expression: --UNKNOWN EXPRESSION--.

Note that

SELECT split(a,',') AS a FROM (SELECT 'foo,bar,buz' AS a) /* OK */;
+---------------------+
|          a          |
+---------------------+
| ["foo","bar","buz"] |
+---------------------+

 

Issue Links

• is related to: DRILL-7337 Add vararg UDFs support