[jira] [Commented] (DRILL-6962) Function coalesce returns an Error when none of the columns in coalesce exist in a parquet file

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

    [ https://issues.apache.org/jira/browse/DRILL-6962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16740175#comment-16740175 ] 

benj commented on DRILL-6962:
-----------------------------

In 1.15.0 it's not exactly the same error message but the same idea :
{code:java}
SELECT coalesce(fsize3,fsize4) FROM myhdfs.test.`2018_pqt`;
java.lang.IndexOutOfBoundsException: index (0) must be less than size (0)
at org.apache.drill.shaded.guava.com.google.common.base.Preconditions.checkElementIndex(Preconditions.java:1196)
{code}
or
{code:java}
SELECT coalesce(null, null);
Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 27: ELSE clause or at least one THEN clause must be non-NULL
{code}

> Function coalesce returns an Error when none of the columns in coalesce exist in a parquet file
> -----------------------------------------------------------------------------------------------
>
>                 Key: DRILL-6962
>                 URL: https://issues.apache.org/jira/browse/DRILL-6962
>             Project: Apache Drill
>          Issue Type: Improvement
>    Affects Versions: 1.13.0
>            Reporter: Bohdan Kazydub
>            Assignee: Bohdan Kazydub
>            Priority: Major
>
> As Drill is schema-free, COALESCE function is expected to return a result and not error out even if none of the columns being referred to exists in files being queried.
> Here is an example for 2 columns, `unk_col` and `unk_col2`, which do not exist in the parquet files
> {code:java}
> select coalesce(unk_col, unk_col2) from dfs.`/tmp/parquetfiles`;
> Error: SYSTEM ERROR: CompileException: Line 56, Column 27: Assignment conversion not possible from type “org.apache.drill.exec.expr.holders.NullableIntHolder” to type “org.apache.drill.exec.vector.UntypedNullHolder”
> Fragment 1:0
> [Error Id: 7b9193fb-289b-4fbf-a52a-2b93b01f0cd0 on dkvm2c:31010] (state=,code=0)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)