You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2019/01/18 16:54:00 UTC
[jira] [Commented] (IMPALA-7679) Improve error message and add test
for creating table with NULL column
[ https://issues.apache.org/jira/browse/IMPALA-7679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16746472#comment-16746472 ]
ASF subversion and git services commented on IMPALA-7679:
---------------------------------------------------------
Commit 663e9ccc9e4b5167d73c5e28ac4becbd0813afca in impala's branch refs/heads/master from Fredy Wijaya
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=663e9cc ]
IMPALA-7679: Improve error message when adding NULL column in CTAS, CREATE VIEW and ALTER VIEW
This patch improves the error message to be more helpful when inserting
a NULL column in CTAS, CREATE VIEW, and ALTER VIEW without an explicit
cast due to the inability to infer the column type.
Testing:
- Added new FE tests
- Ran all FE tests
Change-Id: Ia2fe1fc96f0650477c0e897c010be3fadabfaf82
Reviewed-on: http://gerrit.cloudera.org:8080/12217
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org