You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Volodymyr Vysotskyi (JIRA)" <ji...@apache.org> on 2017/08/31 14:51:00 UTC

[jira] [Updated] (DRILL-5756) CONVERT_FROM_JSON on a non-existent column throws NullPointerException

     [ https://issues.apache.org/jira/browse/DRILL-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Volodymyr Vysotskyi updated DRILL-5756:
---------------------------------------
    Summary: CONVERT_FROM_JSON on a non-existent column throws NullPointerException  (was: CONVERT_FROM_JSON on an file with space throws NullPointerException)

> CONVERT_FROM_JSON on a non-existent column throws NullPointerException
> ----------------------------------------------------------------------
>
>                 Key: DRILL-5756
>                 URL: https://issues.apache.org/jira/browse/DRILL-5756
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>            Reporter: Volodymyr Vysotskyi
>
> Query
> {code:sql}
> SELECT CONVERT_FROM(columns[1], 'JSON') as col1 FROM dfs.`file1.tbl`;
> {code}
> where file1.tbl is a file with single column returns error
> {noformat}
> Error: SYSTEM ERROR: NullPointerException
> Fragment 0:0
> [Error Id: 85b7fa7f-2049-4c8b-8c96-805af218f118 on node1:31010] (state=,code=0)
> {noformat}
> It should return single row with null value since CONVERT_FROM is executed on the column that does not exists.
> *Problem description*
> convert_fromJSON function considers only non-nullable VarCharHolder, but for this case we receives NullableVarCharHolder which has null value. So convert_fromJSON function that takes NullableVarCharHolder as an input parameter should be added.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)