benj created DRILL-7321:
---------------------------
Summary: split function doesn't work without from
Key: DRILL-7321
URL: https://issues.apache.org/jira/browse/DRILL-7321
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Affects Versions: 1.16.0
Reporter: benj
{code:java}
SELECT upper('foo') AS a /* OK */;
+-----+
| a |
+-----+
| foo |
+-----+
{code}
but
{code:java}
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--.{code}
Note that
{code:java}
SELECT split(a,',') AS a FROM (SELECT 'foo,bar,buz' AS a) /* OK */;
+---------------------+
| a |
+---------------------+
| ["foo","bar","buz"] |
+---------------------+
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
