[
https://issues.apache.org/jira/browse/IMPALA-5474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yongjun Zhang resolved IMPALA-5474.
-----------------------------------
Resolution: Fixed
Many thanks to [~tarmstrong] and [~joemcdonnell] for the review/discussion and
commit.
> 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
> Fix For: Impala 3.2.0
>
>
> 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: [email protected]
For additional commands, e-mail: [email protected]