Copyright 2025, Altinity Inc.. All Rights Reserved. All information contained herein is, and remains the property of Altinity Inc.. Any dissemination of this information or reproduction of this material is strictly forbidden unless prior written permission is obtained from Altinity Inc..

Parquet Test Run Report

DateApr 03, 2025 15:49
Duration54m 12s
Framework TestFlows 2.0.250110.1002922

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#683/485c050b9eebde39c0497e5f66e1f969576e2271/regression/aarch64/with_analyzer/zookeeper/without_thread_fuzzer/parquet/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/PRs/683/485c050b9eebde39c0497e5f66e1f969576e2271/package_aarch64/clickhouse-common-static_24.12.2.20228.altinityantalya_arm64.deb
version24.12.2.20228.altinityantalya
user.nameianton-ru
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashbd31e738c0cedaca253d15a05ed245c41b6e0b6a
job.nameParquet
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/14243856895
archaarch64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/PRs/683/485c050b9eebde39c0497e5f66e1f969576e2271/package_aarch64/clickhouse-common-static_24.12.2.20228.altinityantalya_arm64.deb
as_binaryFalse
base_osNone
keeper_pathNone
zookeeper_versionNone
use_keeperFalse
stressFalse
collect_service_logsTrue
thread_fuzzerFalse
with_analyzerTrue
reuse_envFalse
storagesNone
minio_uriSecret(name='minio_uri')
minio_root_userSecret(name='minio_root_user')
minio_root_passwordSecret(name='minio_root_password')
aws_s3_bucketNone
aws_s3_regionSecret(name='aws_s3_region')
aws_s3_key_idSecret(name='aws_s3_key_id')
aws_s3_access_keySecret(name='aws_s3_access_key')
gcs_uriNone
gcs_key_idNone
gcs_key_secretNone
azure_account_nameNone
azure_storage_keyNone
azure_containerNone
native_parquet_readerFalse
stress_bloomFalse

Summary

100%OK
<1%Known

Statistics

Units Skip OK Fail Error XFail
Modules
1
1
Suites
2
2
Features
39
2
36
1
Scenarios
217
18
194
5
Checks
59674
59674
Examples
12
12
Steps
379200
32
377018
14
6
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engineXFail 41s 433ms
This fails because of the difference in snapshot values. We used to capture the datetime value `0` be converted as 2106-02-07 06:28:16 instead of the correct 1970-01-01 01:00:00. But when steps are repeated manually, we can not reproduce it
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 827, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 897, in execute_query
    assert that(snapshot_result), error()
           ^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(snapshot_result), error()

Assertion values
  assert that(snapshot_result), error()
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
    name=_parquet_postgresql_compression_type__NONE__postgresql_engine_to_parquet_file_to_postgresql_engine_I_check_the_data_on_the_table_datetime
    snapshot_value="""

        {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        {"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
        {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
        {"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
        {"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
        {"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
        {"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
        {"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
    """,
    actual_value="""

        {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
        {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
        {"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
        {"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
        {"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
        {"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
        {"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
        +++ 
        @@ -1,6 +1,6 @@

         {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        -{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
        +{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
         {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
         {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
         {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
    """)
  assert that(snapshot_result), error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 897 in 'execute_query'

889\|                  with values() as that:
890\|                      snapshot_result = snapshot(
891\|                          "\n" + r.output.strip() + "\n",
892\|                          id=snapshot_id,
893\|                          name=snapshot_name,
894\|                          encoder=str,
895\|                          mode=snapshot.CHECK,
896\|                      )
897\|>                     assert that(snapshot_result), error()
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engineXFail 41s 147ms
This fails because of the difference in snapshot values. We used to capture the datetime value `0` be converted as 2106-02-07 06:28:16 instead of the correct 1970-01-01 01:00:00. But when steps are repeated manually, we can not reproduce it
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 827, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 897, in execute_query
    assert that(snapshot_result), error()
           ^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(snapshot_result), error()

Assertion values
  assert that(snapshot_result), error()
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
    name=_parquet_postgresql_compression_type__GZIP__postgresql_engine_to_parquet_file_to_postgresql_engine_I_check_the_data_on_the_table_datetime
    snapshot_value="""

        {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        {"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
        {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
        {"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
        {"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
        {"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
        {"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
        {"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
    """,
    actual_value="""

        {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
        {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
        {"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
        {"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
        {"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
        {"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
        {"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
        +++ 
        @@ -1,6 +1,6 @@

         {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        -{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
        +{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
         {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
         {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
         {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
    """)
  assert that(snapshot_result), error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 897 in 'execute_query'

889\|                  with values() as that:
890\|                      snapshot_result = snapshot(
891\|                          "\n" + r.output.strip() + "\n",
892\|                          id=snapshot_id,
893\|                          name=snapshot_name,
894\|                          encoder=str,
895\|                          mode=snapshot.CHECK,
896\|                      )
897\|>                     assert that(snapshot_result), error()
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engineXFail 40s 548ms
This fails because of the difference in snapshot values. We used to capture the datetime value `0` be converted as 2106-02-07 06:28:16 instead of the correct 1970-01-01 01:00:00. But when steps are repeated manually, we can not reproduce it
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 827, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 897, in execute_query
    assert that(snapshot_result), error()
           ^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(snapshot_result), error()

Assertion values
  assert that(snapshot_result), error()
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
    name=_parquet_postgresql_compression_type__LZ4__postgresql_engine_to_parquet_file_to_postgresql_engine_I_check_the_data_on_the_table_datetime
    snapshot_value="""

        {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        {"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
        {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
        {"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
        {"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
        {"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
        {"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
        {"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
    """,
    actual_value="""

        {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
        {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
        {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
        {"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
        {"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
        {"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
        {"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
        {"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
        +++ 
        @@ -1,6 +1,6 @@

         {"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
        -{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
        +{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
         {"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
         {"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
         {"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
    """)
  assert that(snapshot_result), error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 897 in 'execute_query'

889\|                  with values() as that:
890\|                      snapshot_result = snapshot(
891\|                          "\n" + r.output.strip() + "\n",
892\|                          id=snapshot_id,
893\|                          name=snapshot_name,
894\|                          encoder=str,
895\|                          mode=snapshot.CHECK,
896\|                      )
897\|>                     assert that(snapshot_result), error()
/parquet/chunked arrayXFail 16s 552ms
Not supported
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/chunked_array.py", line 30, in feature
    node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Error on processing query: Code: 33. DB::Exception: Error while reading Parquet data: NotImplemented: Nested data conversions not implemented for chunked array outputs: (in file/uri /var/lib/clickhouse/user_files/chunked_array_test_file.parquet): While executing ParquetBlockInputFormat: While executing File: data for INSERT was parsed from file. (CANNOT_READ_ALL_DATA) (version 24.12.2.20228.altinityantalya (altinity build))
(query: INSERT INTO table_516ff236_10a7_11f0_b290_960004311d03 FROM INFILE '/var/lib/clickhouse/user_files/chunked_array_test_file.parquet' FORMAT Parquet
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py', line 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/parquet/datatypes/float16XFail 492ms
ClickHouse does not import FLOAT16 properly
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 929, in feature
    scenario()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 113, in float16
    assert output == expected, error()
           ^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert output == expected, error()

Assertion values
  assert output == expected, error()
         ^ is '[-0,0,32,2052,32838,0,0,0,0,0,0]'
  assert output == expected, error()
                   ^ is '[-2,-1,0,1,2,3,4,5,6,7,8,9]'
  assert output == expected, error()
                ^ is = False
    @@ -1 +1 @@
    -[-0,0,32,2052,32838,0,0,0,0,0,0]
    +[-2,-1,0,1,2,3,4,5,6,7,8,9]
  assert output == expected, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py', line 113 in 'float16'

105\|                  ORDER BY tuple() AS SELECT floatfield FROM file('{import_file}', Parquet)
106\|                  """
107\|              )
108\|  
109\|          with Then("I read the contents of the created table"):
110\|              output = node.query(
111\|                  f"SELECT groupArray(round(*)) FROM {table_name} FORMAT TSV"
112\|              ).output
113\|>             assert output == expected, error()
114\|  
115\|      finally:
116\|          with Finally("I drop the table"):
/parquet/datatypes/large string mapXFail 8s 391ms
Will fail until the, https://github.com/apache/arrow/pull/35825, gets merged.
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 929, in feature
    scenario()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 801, in large_string_map
    import_export(snapshot_name="large_string_map_structure", import_file=import_file)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/outline.py", line 36, in import_export
    node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 24.12.2):
Code: 33. DB::Exception: Received from localhost:9000. DB::Exception: Error while reading Parquet data: NotImplemented: Nested data conversions not implemented for chunked array outputs: (in file/uri /var/lib/clickhouse/user_files/arrow/large_string_map.brotli.parquet): While executing ParquetBlockInputFormat: While executing File. (CANNOT_READ_ALL_DATA)
(query: CREATE TABLE table_571341ec_10a8_11f0_9e64_960004311d03
            ENGINE = MergeTree
            ORDER BY tuple() AS SELECT * FROM file('arrow/large_string_map.brotli.parquet', Parquet) LIMIT 100 FORMAT TabSeparated
            )

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py', line 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

Results

Test Name Result Duration
/parquet OK 54m 12s
/parquet/file OK 33m 37s
/parquet/file/engine OK 33m 37s
/parquet/file/function OK 17m 45s
/parquet/file/engine/insert into engine OK 21m 48s
/parquet/query OK 44m 35s
/parquet/query/compression type OK 44m 35s
/parquet/query/compression type/=NONE OK 44m 35s
/parquet/query/compression type/=NONE /insert into memory table from file OK 9m 53s
/parquet/file/function/insert into function manual cast types OK 17m 16s
/parquet/query/compression type/=GZIP OK 44m 33s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 9m 51s
/parquet/query/compression type/=LZ4 OK 44m 35s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 9m 52s
/parquet/file/function/insert into function auto cast types OK 17m 45s
/parquet/file/function/select from function manual cast types OK 16m 54s
/parquet/file/engine/select from engine OK 10m 28s
/parquet/file/engine/engine to file to engine OK 29m 20s
/parquet/file/engine/insert into engine from file OK 21m 2s
/parquet/list in multiple chunks OK 1m 11s
/parquet/file/function/select from function auto cast types OK 10m 26s
/parquet/file/engine/engine select output to file OK 33m 37s
/parquet/url OK 34m 36s
/parquet/url/engine OK 33m 31s
/parquet/url/function OK 32m 37s
/parquet/url/engine/insert into engine OK 21m 57s
/parquet/url/engine/select from engine OK 10m 2s
/parquet/url/engine/engine to file to engine OK 29m 6s
/parquet/url/function/insert into function OK 16m 57s
/parquet/url/function/select from function manual cast types OK 32m 37s
/parquet/url/engine/insert into engine from file OK 28m 13s
/parquet/url/function/select from function auto cast types OK 16m 33s
/parquet/url/engine/engine select output to file OK 33m 31s
/parquet/mysql OK 1m 50s
/parquet/mysql/compression type OK 1m 50s
/parquet/mysql/compression type/=NONE OK 1m 49s
/parquet/mysql/compression type/=GZIP OK 1m 49s
/parquet/mysql/compression type/=LZ4 OK 1m 50s
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 1m 17s
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 1m 17s
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 1m 20s
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 32s 150ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 31s 954ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 29s 966ms
/parquet/postgresql OK 1m 15s
/parquet/postgresql/compression type OK 1m 15s
/parquet/postgresql/compression type/=NONE OK 1m 14s
/parquet/postgresql/compression type/=GZIP OK 1m 15s
/parquet/postgresql/compression type/=LZ4 OK 1m 13s
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 41s 433ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 41s 147ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 40s 548ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 32s 921ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 33s 771ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 32s 812ms
/parquet/remote OK 21m 17s
/parquet/remote/compression type OK 21m 17s
/parquet/remote/compression type/=NONE OK 21m 17s
/parquet/remote/compression type/=GZIP OK 21m 16s
/parquet/remote/compression type/=LZ4 OK 21m 17s
/parquet/remote/compression type/=NONE /outline OK 21m 17s
/parquet/remote/compression type/=GZIP /outline OK 21m 16s
/parquet/remote/compression type/=NONE /outline/insert into function OK 7m 36s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 7m 33s
/parquet/remote/compression type/=LZ4 /outline OK 21m 17s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 7m 39s
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 6m 15s
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 6m 14s
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 6m 13s
/parquet/remote/compression type/=GZIP /outline/select from function OK 13m 43s
/parquet/remote/compression type/=NONE /outline/select from function OK 13m 40s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 13m 37s
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 4m 30s
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 4m 31s
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 4m 30s
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 3m 42s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 3m 42s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 3m 42s
/parquet/query/compression type/=NONE /select from memory table into file OK 5m 39s
/parquet/query/compression type/=GZIP /select from memory table into file OK 5m 36s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 5m 35s
/parquet/chunked array XFail 16s 552ms
/parquet/broken OK 407ms
/parquet/broken/file Skip 10ms
/parquet/broken/read broken bigint Skip 23ms
/parquet/broken/read broken date Skip 17ms
/parquet/broken/read broken int Skip 19ms
/parquet/broken/read broken smallint Skip 16ms
/parquet/broken/read broken timestamp ms Skip 11ms
/parquet/broken/read broken timestamp us Skip 14ms
/parquet/broken/read broken tinyint Skip 20ms
/parquet/broken/read broken ubigint Skip 24ms
/parquet/broken/read broken uint Skip 57ms
/parquet/broken/read broken usmallint Skip 11ms
/parquet/broken/read broken utinyint Skip 13ms
/parquet/broken/string Skip 15ms
/parquet/encoding OK 54s 984ms
/parquet/encoding/deltabytearray1 OK 7s 983ms
/parquet/encoding/deltabytearray2 OK 7s 612ms
/parquet/encoding/deltalengthbytearray OK 7s 800ms
/parquet/encoding/dictionary OK 7s 574ms
/parquet/encoding/plain OK 7s 712ms
/parquet/encoding/plainrlesnappy OK 8s 520ms
/parquet/encoding/rleboolean OK 7s 695ms
/parquet/compression OK 2m 40s
/parquet/compression/arrow snappy OK 7s 587ms
/parquet/compression/brotli OK 7s 840ms
/parquet/compression/gzippages OK 15s 269ms
/parquet/compression/largegzip OK 7s 586ms
/parquet/compression/lz4 hadoop OK 7s 692ms
/parquet/compression/lz4 hadoop large OK 7s 639ms
/parquet/compression/lz4 non hadoop OK 7s 620ms
/parquet/compression/lz4 raw OK 7s 637ms
/parquet/compression/lz4 raw large OK 7s 565ms
/parquet/compression/lz4pages OK 15s 261ms
/parquet/compression/nonepages OK 15s 110ms
/parquet/compression/snappypages OK 15s 779ms
/parquet/compression/snappyplain OK 7s 481ms
/parquet/compression/snappyrle OK 7s 864ms
/parquet/compression/zstd OK 7s 342ms
/parquet/compression/zstdpages OK 14s 909ms
/parquet/datatypes OK 7m 16s
/parquet/datatypes/arrowtimestamp OK 7s 66ms
/parquet/datatypes/arrowtimestampms OK 6s 686ms
/parquet/datatypes/binary OK 9s 785ms
/parquet/datatypes/binary string OK 9s 151ms
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 3m 33s
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 3m 32s
/parquet/query/compression type/=NONE /select from mergetree table into file OK 3m 30s
/parquet/datatypes/blob OK 6s 654ms
/parquet/datatypes/boolean OK 14s 454ms
/parquet/datatypes/byte array OK 8s 723ms
/parquet/datatypes/columnname OK 6s 993ms
/parquet/datatypes/columnwithnull OK 7s 380ms
/parquet/datatypes/columnwithnull2 OK 7s 86ms
/parquet/datatypes/date OK 7s 126ms
/parquet/datatypes/decimal with filter OK 7s 284ms
/parquet/datatypes/decimalvariousfilters OK 6s 946ms
/parquet/datatypes/decimalwithfilter2 OK 7s 71ms
/parquet/datatypes/enum OK 7s 134ms
/parquet/datatypes/enum2 OK 7s 68ms
/parquet/datatypes/fixed length decimal OK 7s 78ms
/parquet/datatypes/fixed length decimal legacy OK 7s 245ms
/parquet/datatypes/fixedstring OK 7s 284ms
/parquet/datatypes/float16 XFail 492ms
/parquet/datatypes/h2oai OK 7s 221ms
/parquet/datatypes/hive OK 14s 837ms
/parquet/datatypes/int32 OK 7s 138ms
/parquet/datatypes/int32 decimal OK 7s 112ms
/parquet/datatypes/int64 OK 7s 119ms
/parquet/datatypes/int64 decimal OK 7s 462ms
/parquet/datatypes/json OK 6s 971ms
/parquet/datatypes/large string map XFail 8s 391ms
/parquet/datatypes/largedouble OK 7s 528ms
/parquet/datatypes/manydatatypes OK 6s 741ms
/parquet/datatypes/manydatatypes2 OK 8s 117ms
/parquet/datatypes/maps OK 7s 267ms
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 3m 7s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 3m 8s
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 3m 9s
/parquet/datatypes/nameswithemoji OK 7s 708ms
/parquet/complex OK 2m 27s
/parquet/complex/arraystring OK 16s 397ms
/parquet/datatypes/nandouble OK 14s 261ms
/parquet/complex/big tuple with nulls OK 7s 128ms
/parquet/datatypes/negativeint64 OK 7s 516ms
/parquet/complex/bytearraydictionary OK 6s 870ms
/parquet/datatypes/nullbyte OK 7s 188ms
/parquet/complex/complex null OK 6s 764ms
/parquet/datatypes/nullbytemultiple OK 6s 728ms
/parquet/complex/lagemap OK 6s 921ms
/parquet/datatypes/nullsinid OK 6s 624ms
/parquet/complex/largenestedarray OK 6s 698ms
/parquet/datatypes/pandasdecimal OK 6s 614ms
/parquet/complex/largestruct OK 6s 694ms
/parquet/datatypes/pandasdecimaldate OK 6s 635ms
/parquet/complex/largestruct2 OK 8s 370ms
/parquet/datatypes/parquetgo OK 8s 30ms
/parquet/cache OK 16s 293ms
/parquet/cache/cache1 OK 9s 187ms
/parquet/datatypes/selectdatewithfilter OK 19s 342ms
/parquet/complex/largestruct3 OK 7s 71ms
/parquet/cache/cache2 OK 7s 95ms
/parquet/complex/list OK 6s 962ms
/parquet/glob OK 45s 33ms
/parquet/glob/fastparquet globs OK 8s 366ms
/parquet/complex/nested array OK 6s 865ms
/parquet/glob/glob1 OK 2s 341ms
/parquet/datatypes/singlenull OK 6s 816ms
/parquet/glob/glob2 OK 1s 760ms
/parquet/complex/nested map OK 6s 848ms
/parquet/glob/glob with multiple elements OK 331ms
/parquet/glob/million extensions OK 32s 215ms
/parquet/datatypes/sparkv21 OK 6s 793ms
/parquet/complex/nestedallcomplex OK 6s 853ms
/parquet/datatypes/sparkv22 OK 6s 836ms
/parquet/complex/nestedarray2 OK 6s 723ms
/parquet/datatypes/statdecimal OK 6s 780ms
/parquet/complex/nestedstruct OK 6s 795ms
/parquet/datatypes/string OK 6s 841ms
/parquet/complex/nestedstruct2 OK 6s 862ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 11s 605ms
/parquet/rowgroups OK 13s 480ms
/parquet/rowgroups/manyrowgroups OK 6s 673ms
/parquet/complex/nestedstruct3 OK 6s 653ms
/parquet/rowgroups/manyrowgroups2 OK 6s 804ms
/parquet/complex/nestedstruct4 OK 6s 907ms
/parquet/datatypes/stringtypes OK 6s 650ms
/parquet/encrypted Skip 1ms
/parquet/fastparquet OK 19ms
/parquet/fastparquet/airlines Skip 7ms
/parquet/fastparquet/baz Skip 1ms
/parquet/fastparquet/empty date Skip 2ms
/parquet/fastparquet/evo Skip 1ms
/parquet/fastparquet/fastparquet Skip 4ms
/parquet/read and write OK 14m 7s
/parquet/read and write/read and write parquet file OK 14m 7s
/parquet/complex/tupleofnulls OK 6s 812ms
/parquet/datatypes/struct OK 6s 611ms
/parquet/complex/tuplewithdatetime OK 6s 689ms
/parquet/datatypes/supporteduuid OK 7s 703ms
/parquet/column related errors OK 2s 539ms
/parquet/column related errors/check error with 500 columns OK 2s 534ms
/parquet/multi chunk upload Skip 2ms
/parquet/datatypes/timestamp1 OK 7s 761ms
/parquet/datatypes/timestamp2 OK 6s 637ms
/parquet/datatypes/timezone OK 6s 540ms
/parquet/datatypes/unsigned OK 13s 253ms
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 3m 35s
/parquet/query/compression type/=NONE /select from distributed table into file OK 3m 34s
/parquet/query/compression type/=GZIP /select from distributed table into file OK 3m 33s
/parquet/datatypes/unsupportednull OK 151ms
/parquet/query/compression type/=NONE /select from mat view into file OK 2m 57s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 2m 57s
/parquet/query/compression type/=GZIP /select from mat view into file OK 2m 56s
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 1m 22s
/parquet/query/compression type/=NONE /insert into table with projection from file OK 1m 23s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 1m 23s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922