[ https://issues.apache.org/jira/browse/IMPALA-5474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16704267#comment-16704267 ]
Yongjun Zhang commented on IMPALA-5474: --------------------------------------- Created IMPALA-7912 for the above mentioned issues. > Adding a trivial subquery turns error into warning > -------------------------------------------------- > > Key: IMPALA-5474 > URL: https://issues.apache.org/jira/browse/IMPALA-5474 > Project: IMPALA > Issue Type: Bug > Components: Backend > Affects Versions: Impala 2.9.0 > Reporter: Lars Volker > Assignee: Yongjun Zhang > Priority: Major > > This query without a subquery results in an error, which is expected. > {noformat} > [localhost:21000] > set abort_on_error=1; > ABORT_ON_ERROR set to 1 > [localhost:21000] > select id from functional_parquet.bad_column_metadata t; > Query: select id from functional_parquet.bad_column_metadata t > Query submitted at: 2017-06-08 15:30:44 (Coordinator: http://lv-desktop:25000) > Query progress can be monitored at: > http://lv-desktop:25000/query_plan?query_id=44e98719ba4c073:dec9e4d00000000 > ERROR: Column metadata states there are 11 values, but read 10 values from > column id. > file=hdfs://localhost:20500/test-warehouse/bad_column_metadata_parquet/bad_column_metadata.parquet > {noformat} > Adding a trivial subquery turns the error into a warning: > {noformat} > [localhost:21000] > set abort_on_error=1; > ABORT_ON_ERROR set to 1 > [localhost:21000] > select id, cnt from > functional_parquet.bad_column_metadata t, (select 1 cnt) u; > Query: select id, cnt from functional_parquet.bad_column_metadata t, (select > 1 cnt) u > Query submitted at: 2017-06-08 15:34:57 (Coordinator: http://lv-desktop:25000) > Query progress can be monitored at: > http://lv-desktop:25000/query_plan?query_id=7a4eb13bf147d0f1:9156b2700000000 > WARNINGS: Column metadata states there are 11 values, but read 10 values from > column id. > file=hdfs://localhost:20500/test-warehouse/bad_column_metadata_parquet/bad_column_metadata.parquet > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org