[
https://issues.apache.org/jira/browse/DRILL-7321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Volodymyr Vysotskyi resolved DRILL-7321.
----------------------------------------
Resolution: Fixed
Fix Version/s: 1.17.0
Fixed in the sope of DRILL-7337.
> 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
> Assignee: Volodymyr Vysotskyi
> Priority: Minor
> Fix For: 1.17.0
>
>
> {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.14#76016)
