[jira] [Resolved] (DRILL-7321) split function doesn't work without from

["Volodymyr Vysotskyi (JIRA)" <ji...@apache.org>]

     [ 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)