[ 
https://issues.apache.org/jira/browse/IMPALA-15478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Arnab Karmakar resolved IMPALA-15478.
-------------------------------------
    Fix Version/s: Impala 5.0.0
       Resolution: Fixed

> TestHBO.test_count_star_scan_cardinality failing on EC cluster
> --------------------------------------------------------------
>
>                 Key: IMPALA-15478
>                 URL: https://issues.apache.org/jira/browse/IMPALA-15478
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Arnab Karmakar
>            Assignee: Aleksandr Efimov
>            Priority: Major
>             Fix For: Impala 5.0.0
>
>
> The TestHBO.test_count_star_scan_cardinality test is failing with the error 
> “AssertionError: EXPLAIN output mismatch for QueryTest/hbo-count-star-scan”.
> Stack Trace:
> {code:java}
> query_test/test_hbo.py:248: in test_count_star_scan_cardinality
>     self._run_hbo_explains('QueryTest/hbo-count-star-scan')
>         self       = <test_hbo.TestHBO object at 0x7f1e4dff3050>
> query_test/test_hbo.py:71: in _run_hbo_explains
>     assert actual_cardinality_lines == expected_cardinality_lines, (
> E   AssertionError: EXPLAIN output mismatch for QueryTest/hbo-count-star-scan.
> E     Expected:
> E     PLAN-ROOT SINK
> E     |
> E     01:AGGREGATE [FINALIZE]
> E     |  output: sum_init_zero(tpch_parquet.orders.stats: num_rows)
> E     |  row-size=8B cardinality=1 (from HBO)
> E     |
> E     00:SCAN HDFS [tpch_parquet.orders]
> E        HDFS partitions=1/1 files=2 size=54.21MB
> E        row-size=8B cardinality=2 (from HBO)
> E     
> E     
> E     Actual:
> E     PLAN-ROOT SINK
> E     |
> E     01:AGGREGATE [FINALIZE]
> E     |  output: sum_init_zero(tpch_parquet.orders.stats: num_rows)
> E     |  row-size=8B cardinality=1 (from HBO)
> E     |
> E     00:SCAN HDFS [tpch_parquet.orders]
> E        HDFS partitions=1/1 files=1 size=53.93MB
> E        erasure coded: files=1 size=53.93MB
> E        row-size=8B cardinality=1 (from HBO)
> E   assert ['|  row-size...1 (from HBO)'] == ['|  row-size...2 (from HBO)']
> E     At index 1 diff: '   row-size=8B cardinality=1 (from HBO)' != '   
> row-size=8B cardinality=2 (from HBO)'
> E     Full diff:
> E       [
> E        '|  row-size=8B cardinality=1 (from HBO)',
> E     -  '   row-size=8B cardinality=2 (from HBO)',
> E     ?                              ^
> E     +  '   row-size=8B cardinality=1 (from HBO)',
> E     ?                              ^
> E       ]
>         actual_cardinality_lines = ['|  row-size=8B cardinality=1 (from 
> HBO)', '   row-size=8B cardinality=1 (from HBO)']
>         actual_plan_lines = ['PLAN-ROOT SINK', '|', '01:AGGREGATE 
> [FINALIZE]', '|  output: sum_init_zero(tpch_parquet.orders.stats: num_rows)', 
> '|  row-size=8B cardinality=1 (from HBO)', '|', ...]
>         expected_cardinality_lines = ['|  row-size=8B cardinality=1 (from 
> HBO)', '   row-size=8B cardinality=2 (from HBO)']
>         expected_plan_lines = ['PLAN-ROOT SINK', '|', '01:AGGREGATE 
> [FINALIZE]', '|  output: sum_init_zero(tpch_parquet.orders.stats: num_rows)', 
> '|  row-size=8B cardinality=1 (from HBO)', '|', ...]
>         plan_section_name = 'PLAN'
>         query      = 'EXPLAIN SELECT count(*) FROM tpch_parquet.orders'
>         result     = <tests.common.impala_connection.ImpylaHS2ResultSet 
> object at 0x7f1e4dff1e50>
>         section    = defaultdict(<class 'str'>, {'QUERY': 'EXPLAIN SELECT 
> count(*) FROM tpch_parquet.orders\n', 'PLAN': 'PLAN-ROOT SINK\n|\...N HDFS 
> [tpch_parquet.orders]\n   HDFS partitions=1/1 files=2 size=54.21MB\n   
> row-size=8B cardinality=2 (from HBO)\n'})
>         self       = <test_hbo.TestHBO object at 0x7f1e4dff3050>
>         test_cases = [defaultdict(<class 'str'>, {'QUERY': 'EXPLAIN SELECT 
> count(*) FROM tpch_parquet.orders\n', 'PLAN': 'PLAN-ROOT SINK\n|...00:SCAN 
> HDFS [tpch_parquet.orders]\n   HDFS partitions=1/1 files=2 size=54.21MB\n   
> row-size=8B cardinality=1.50M\n'})]
>         test_file  = 'QueryTest/hbo-count-star-scan'{code}
>  
> Stderr:
> {code:java}
> --------------------------------- Captured Err 
> ---------------------------------
> -- 2026-10-03 19:18:33,786 INFO     MainThread: hs2: 
> set 
> client_identifier=query_test/test_hbo.py::TestHBO::test_count_star_scan_cardinality;
> -- 2026-10-03 19:18:33,786 INFO     MainThread: hs2-http: 
> set 
> client_identifier=query_test/test_hbo.py::TestHBO::test_count_star_scan_cardinality;
> -- 2026-10-03 19:18:33,787 INFO     MainThread: hs2: 
> set 
> client_identifier=query_test/test_hbo.py::TestHBO::test_count_star_scan_cardinality;
> -- 2026-10-03 19:18:33,787 INFO     MainThread: hs2: set_configuration:
> set use_hbo_stats=True;
> set store_hbo_stats=True;
> -- 2026-10-03 19:18:33,787 INFO     MainThread: hs2: executing against Impala 
> at localhost:21050. session: 754da1b023347afe:8421a686b13cd98b main_cursor: 
> True user: None
> SELECT count(*) FROM tpch_parquet.orders;
> -- 2026-10-03 19:18:33,795 INFO     MainThread: 
> 9b460d6db5f345db:d7763eca00000000: query started
> -- 2026-10-03 19:18:33,797 INFO     MainThread: 
> 9b460d6db5f345db:d7763eca00000000: getting log for operation
> -- 2026-10-03 19:18:33,797 INFO     MainThread: 
> 9b460d6db5f345db:d7763eca00000000: getting runtime profile operation
> -- 2026-10-03 19:18:33,798 INFO     MainThread: 
> 9b460d6db5f345db:d7763eca00000000: closing query for operation
> -- 2026-10-03 19:18:34,801 INFO     MainThread: Loading query test file: 
> /data/jenkins/workspace/impala-asf-master-core-erasure-coding/repos/Impala/testdata/workloads/functional-query/queries/QueryTest/hbo-count-star-scan.test
> -- 2026-10-03 19:18:34,807 INFO     MainThread: hs2: 
> set 
> client_identifier=query_test/test_hbo.py::TestHBO::test_count_star_scan_cardinality;
> -- 2026-10-03 19:18:34,807 INFO     MainThread: hs2: set_configuration:
> set use_hbo_stats=True;
> -- 2026-10-03 19:18:34,807 INFO     MainThread: hs2: executing against Impala 
> at localhost:21050. session: 754da1b023347afe:8421a686b13cd98b main_cursor: 
> True user: None
> EXPLAIN SELECT count(*) FROM tpch_parquet.orders;
> -- 2026-10-03 19:18:34,846 INFO     MainThread: 
> d74ff74451122076:5a8d0d3e00000000: query started
> -- 2026-10-03 19:18:34,847 INFO     MainThread: 
> d74ff74451122076:5a8d0d3e00000000: getting log for operation
> -- 2026-10-03 19:18:34,847 INFO     MainThread: 
> d74ff74451122076:5a8d0d3e00000000: getting runtime profile operation
> -- 2026-10-03 19:18:34,847 INFO     MainThread: 
> d74ff74451122076:5a8d0d3e00000000: closing query for operation{code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to