[jira] [Resolved] (IMPALA-7679) Improve error message and add test for creating table with NULL column

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

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

Fredy Wijaya resolved IMPALA-7679.
----------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.2.0

> Improve error message and add test for creating table with NULL column
> ----------------------------------------------------------------------
>
>                 Key: IMPALA-7679
>                 URL: https://issues.apache.org/jira/browse/IMPALA-7679
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Frontend
>    Affects Versions: Impala 2.12.0
>            Reporter: Tim Armstrong
>            Assignee: Fredy Wijaya
>            Priority: Major
>              Labels: newbie, ramp-up
>             Fix For: Impala 3.2.0
>
>
> [~alanj_impala_5a78] reports that the error message was a little confusing here:
> {noformat}
> [localhost:21000] default> create table test_null_field as select null as null_field;
> Query: create table test_null_field as select null as null_field
> Query submitted at: 2018-10-08 12:18:40 (Coordinator: http://tarmstrong-box:25000)
> ERROR: AnalysisException: Unsupported type 'null_type' in column 'null_field' of table 'test_null_field'
> CAUSED BY: TableLoadingException: Unsupported type 'null_type' in column 'null_field' of table 'test_null_field'
> {noformat}
> The error message should be a little clearer about what the problem is (we can't infer the type for a NULL column without a cast) and maybe suggest a solution.
> I grepped the code and it doesn't look like we actually have a targeted test, so we should add the coverage too.



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