Arnab Karmakar created IMPALA-15478:
---------------------------------------
Summary: TestHBO.test_count_star_scan_cardinality seems to be flaky
Key: IMPALA-15478
URL: https://issues.apache.org/jira/browse/IMPALA-15478
Project: IMPALA
Issue Type: Bug
Reporter: Arnab Karmakar
Assignee: Aleksandr Efimov
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)
