[
https://issues.apache.org/jira/browse/IMPALA-13756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Laszlo Gaal updated IMPALA-13756:
---------------------------------
Affects Version/s: Impala 5.0.0
CR: https://gerrit.cloudera.org/c/23705/
> Impala query returning wrong results
> ------------------------------------
>
> Key: IMPALA-13756
> URL: https://issues.apache.org/jira/browse/IMPALA-13756
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 5.0.0
> Reporter: vamshi kolanu
> Assignee: Zoltán Borók-Nagy
> Priority: Blocker
> Labels: correctness
> Attachments: repro.sql
>
>
> How to reproduce this issue.
> {code:java}
> create table merge_exclude_columns
> STORED BY ICEBERG
> as
> select CAST(1 AS INT) as id, 'hello' as msg, 'blue' as color
> union all
> select CAST(2 AS INT) as id, 'goodbye' as msg, 'green' as color
> union all
> select CAST(3 AS INT) as id, 'anyway' as msg, 'purple' as color;{code}
>
> {code:java}
> create table expected_merge_exclude_columns as select * from
> merge_exclude_columns; {code}
> This query is supposed to find the row count difference and records
> difference between both the tables. Since both the tables are same, we expect
> row_count_difference and num_mismatched to be 0 but currently num_mismatched
> is being computed as 3.
> {code:java}
> with diff_count as (
> SELECT
> 1 as id,
> COUNT(*) as num_missing FROM (
> (SELECT color, id, msg FROM expected_merge_exclude_columns EXCEPT
> SELECT color, id, msg FROM merge_exclude_columns)
> UNION ALL
> (SELECT color, id, msg FROM merge_exclude_columns EXCEPT
> SELECT color, id, msg FROM expected_merge_exclude_columns)
> ) as a
> ), table_a as (
> SELECT COUNT(*) as num_rows FROM expected_merge_exclude_columns
> ), table_b as (
> SELECT COUNT(*) as num_rows FROM merge_exclude_columns
> ), row_count_diff as (
> select
> 1 as id,
> table_a.num_rows - table_b.num_rows as difference
> from table_a, table_b
> )
> select
> row_count_diff.difference as row_count_difference,
> diff_count.num_missing as num_mismatched
> from row_count_diff
> join diff_count using (id);{code}
> Any help to resolve this issue is appreciated.
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
