[IMPALA-5474] Adding a trivial subquery turns error into warning

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.9.0
• Fix Version/s: Impala 3.2.0
• Component/s: Backend
• Epic Color: ghx-label-1
• Assignee: Yongjun Zhang
• Reporter: Lars Volker
• Created: 08/Jun/17 22:35
• Updated: 16/Sep/19 22:43
• Resolved: 04/Jan/19 22:30

Description

This query without a subquery results in an error, which is expected.

[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

Adding a trivial subquery turns the error into a warning:

[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

Issue Links

• is duplicated by: IMPALA-725 "errors" printed to the shell are sometimes warnings
• relates to: IMPALA-7912 Inconsistent and intermittent behavior of queries