Parquet Test Run Report

DateOct 21, 2025 14:07
Duration1h 4m
Framework TestFlows 2.0.250110.1002922

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#PRs/1085/d724ede7ff9b90c8c55d6dcee8bc923b91b54292/regression/aarch64/with_analyzer/zookeeper/without_thread_fuzzer/parquetminio/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/PRs/1085/d724ede7ff9b90c8c55d6dcee8bc923b91b54292/package_aarch64/clickhouse-common-static_24.8.14.10538.altinitytest_arm64.deb
version24.8.14.10538.altinitytest
user.namezvonand
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashfc19ce3a7322a10ab791de755c950a56744a12e7
job.nameParquetS3 (minio)
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/18684445545
archaarch64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/PRs/1085/d724ede7ff9b90c8c55d6dcee8bc923b91b54292/package_aarch64/clickhouse-common-static_24.8.14.10538.altinitytest_arm64.deb
as_binaryFalse
base_osNone
keeper_pathNone
zookeeper_versionNone
use_keeperFalse
stressFalse
collect_service_logsTrue
thread_fuzzerFalse
with_analyzerTrue
reuse_envFalse
storages['minio']
minio_uriSecret(name='minio_uri')
minio_root_userSecret(name='minio_root_user')
minio_root_passwordSecret(name='minio_root_password')
aws_s3_bucketSecret(name='aws_s3_bucket')
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_reader_v2False
native_parquet_reader_v3False
stress_bloomFalse

Summary

99.9%OK
<1%Known

Statistics

Units Skip OK Fail XFail
Modules
1
1
Suites
8
8
Features
45
2
42
1
Scenarios
241
34
203
4
Checks
67591
67591
Examples
12
12
Steps
411177
40
408984
23
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engineXFail 7s 832ms
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 834, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 904, 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_nullable_datetime_
    snapshot_value="""

        {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
    """,
    actual_value="""

        {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(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 @@

         {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        -{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        +{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
    """)
  assert that(snapshot_result), error()
  ^ is False

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

896\|                  with values() as that:
897\|                      snapshot_result = snapshot(
898\|                          "\n" + r.output.strip() + "\n",
899\|                          id=snapshot_id,
900\|                          name=snapshot_name,
901\|                          encoder=str,
902\|                          mode=snapshot.CHECK,
903\|                      )
904\|>                     assert that(snapshot_result), error()
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engineXFail 6s 246ms
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 834, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 904, 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_nullable_datetime_
    snapshot_value="""

        {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
    """,
    actual_value="""

        {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(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 @@

         {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        -{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        +{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
    """)
  assert that(snapshot_result), error()
  ^ is False

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

896\|                  with values() as that:
897\|                      snapshot_result = snapshot(
898\|                          "\n" + r.output.strip() + "\n",
899\|                          id=snapshot_id,
900\|                          name=snapshot_name,
901\|                          encoder=str,
902\|                          mode=snapshot.CHECK,
903\|                      )
904\|>                     assert that(snapshot_result), error()
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engineXFail 6s 316ms
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 834, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 904, 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_nullable_datetime_
    snapshot_value="""

        {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
    """,
    actual_value="""

        {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        {"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(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 @@

         {"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        -{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
        +{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
         {"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
    """)
  assert that(snapshot_result), error()
  ^ is False

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

896\|                  with values() as that:
897\|                      snapshot_result = snapshot(
898\|                          "\n" + r.output.strip() + "\n",
899\|                          id=snapshot_id,
900\|                          name=snapshot_name,
901\|                          encoder=str,
902\|                          mode=snapshot.CHECK,
903\|                      )
904\|>                     assert that(snapshot_result), error()
/parquet/chunked arrayXFail 14s 539ms
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 1195, 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.8.14.10538.altinitytest (altinity build))
(query: INSERT INTO table_890af8bd_ae8d_11f0_a9f8_920006a1c883 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 1195 in 'query'

1187\|                  assert message in r.output, error(r.output)
1188\|  
1189\|          if not ignore_exception:
1190\|              if message is None or "Exception:" not in message:
1191\|                  with Then("check if output has exception") if steps else NullStep():
1192\|                      if "Exception:" in r.output:
1193\|                          if raise_on_exception:
1194\|                              raise QueryRuntimeException(r.output)
1195\|>                         assert False, error(r.output)
1196\|  
1197\|          return r
1198\|
/parquet/datatypes/large string mapXFail 5s 764ms
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 1195, 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.8.14):
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_b1cf9b9d_ae8d_11f0_b56d_920006a1c883
            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 1195 in 'query'

1187\|                  assert message in r.output, error(r.output)
1188\|  
1189\|          if not ignore_exception:
1190\|              if message is None or "Exception:" not in message:
1191\|                  with Then("check if output has exception") if steps else NullStep():
1192\|                      if "Exception:" in r.output:
1193\|                          if raise_on_exception:
1194\|                              raise QueryRuntimeException(r.output)
1195\|>                         assert False, error(r.output)
1196\|  
1197\|          return r
1198\|

Results

Test Name Result Duration
/parquet OK 1h 4m
/parquet/file OK 10m 10s
/parquet/file/engine OK 10m 10s
/parquet/file/function OK 4m 55s
/parquet/file/engine/insert into engine OK 5m 12s
/parquet/file/engine/select from engine OK 2m 34s
/parquet/file/function/insert into function manual cast types OK 4m 36s
/parquet/file/engine/engine to file to engine OK 7m 51s
/parquet/file/function/insert into function auto cast types OK 4m 55s
/parquet/file/function/select from function manual cast types OK 3m 5s
/parquet/file/function/select from function auto cast types OK 2m 35s
/parquet/file/engine/insert into engine from file OK 4m 58s
/parquet/file/engine/engine select output to file OK 10m 10s
/parquet/query OK 17m 24s
/parquet/query/compression type OK 17m 24s
/parquet/query/compression type/=NONE OK 17m 23s
/parquet/query/compression type/=NONE /insert into memory table from file OK 56s 171ms
/parquet/query/compression type/=GZIP OK 17m 24s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 56s 430ms
/parquet/query/compression type/=LZ4 OK 17m 23s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 56s 840ms
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 56s 755ms
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 56s 907ms
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 56s 723ms
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 57s 160ms
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 56s 535ms
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 56s 363ms
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 1m 0s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 1m 0s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 1m 0s
/parquet/query/compression type/=GZIP /select from memory table into file OK 2m 22s
/parquet/query/compression type/=NONE /select from memory table into file OK 2m 22s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 2m 22s
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 2m 25s
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 2m 24s
/parquet/query/compression type/=NONE /select from mergetree table into file OK 2m 24s
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 2m 26s
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 2m 25s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 2m 25s
/parquet/query/compression type/=NONE /select from distributed table into file OK 3m 6s
/parquet/query/compression type/=GZIP /select from distributed table into file OK 3m 6s
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 3m 4s
/parquet/query/compression type/=NONE /select from mat view into file OK 2m 21s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 2m 21s
/parquet/query/compression type/=GZIP /select from mat view into file OK 2m 25s
/parquet/query/compression type/=NONE /insert into table with projection from file OK 53s 57ms
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 52s 742ms
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 49s 426ms
/parquet/list in multiple chunks OK 18s 78ms
/parquet/url OK 9m 57s
/parquet/url/engine OK 9m 23s
/parquet/url/engine/insert into engine OK 3m 54s
/parquet/url/function OK 4m 29s
/parquet/url/function/insert into function OK 2m 55s
/parquet/url/engine/select from engine OK 1m 10s
/parquet/url/engine/engine to file to engine OK 6m 55s
/parquet/url/engine/insert into engine from file OK 6m 7s
/parquet/url/engine/engine select output to file OK 9m 23s
/parquet/url/function/select from function manual cast types OK 4m 29s
/parquet/url/function/select from function auto cast types OK 2m 55s
/parquet/mysql OK 9s 820ms
/parquet/mysql/compression type OK 9s 819ms
/parquet/mysql/compression type/=NONE OK 9s 816ms
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 5s 766ms
/parquet/mysql/compression type/=GZIP OK 9s 806ms
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 5s 752ms
/parquet/mysql/compression type/=LZ4 OK 9s 794ms
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 5s 739ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 4s 53ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 4s 53ms
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 4s 48ms
/parquet/postgresql OK 11s 258ms
/parquet/postgresql/compression type OK 11s 257ms
/parquet/postgresql/compression type/=NONE OK 11s 254ms
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 7s 832ms
/parquet/postgresql/compression type/=GZIP OK 10s 693ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 6s 246ms
/parquet/postgresql/compression type/=LZ4 OK 10s 694ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 6s 316ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 4s 444ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 4s 375ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 3s 419ms
/parquet/remote OK 3m 42s
/parquet/remote/compression type OK 3m 42s
/parquet/remote/compression type/=NONE OK 3m 42s
/parquet/remote/compression type/=NONE /outline OK 3m 42s
/parquet/remote/compression type/=NONE /outline/insert into function OK 1m 20s
/parquet/remote/compression type/=GZIP OK 3m 41s
/parquet/remote/compression type/=GZIP /outline OK 3m 41s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 1m 20s
/parquet/remote/compression type/=LZ4 OK 3m 42s
/parquet/remote/compression type/=LZ4 /outline OK 3m 42s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 1m 20s
/parquet/remote/compression type/=GZIP /outline/select from function OK 2m 21s
/parquet/remote/compression type/=NONE /outline/select from function OK 2m 21s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 2m 21s
/parquet/chunked array XFail 14s 539ms
/parquet/broken OK 17ms
/parquet/broken/file Skip 1ms
/parquet/broken/read broken bigint Skip 853us
/parquet/broken/read broken date Skip 830us
/parquet/broken/read broken int Skip 1ms
/parquet/broken/read broken smallint Skip 817us
/parquet/broken/read broken timestamp ms Skip 860us
/parquet/broken/read broken timestamp us Skip 819us
/parquet/broken/read broken tinyint Skip 824us
/parquet/broken/read broken ubigint Skip 855us
/parquet/broken/read broken uint Skip 828us
/parquet/broken/read broken usmallint Skip 789us
/parquet/broken/read broken utinyint Skip 791us
/parquet/broken/string Skip 1ms
/parquet/encoding OK 7s 362ms
/parquet/encoding/deltabytearray1 OK 1s 435ms
/parquet/encoding/deltabytearray2 OK 1s 71ms
/parquet/encoding/deltalengthbytearray OK 975ms
/parquet/encoding/dictionary OK 909ms
/parquet/encoding/plain OK 911ms
/parquet/encoding/plainrlesnappy OK 1s 104ms
/parquet/encoding/rleboolean OK 950ms
/parquet/compression OK 20s 331ms
/parquet/compression/arrow snappy OK 963ms
/parquet/compression/brotli OK 995ms
/parquet/compression/gzippages OK 1s 935ms
/parquet/compression/largegzip OK 961ms
/parquet/compression/lz4 hadoop OK 969ms
/parquet/compression/lz4 hadoop large OK 963ms
/parquet/compression/lz4 non hadoop OK 959ms
/parquet/compression/lz4 raw OK 976ms
/parquet/compression/lz4 raw large OK 966ms
/parquet/compression/lz4pages OK 1s 934ms
/parquet/compression/nonepages OK 1s 981ms
/parquet/compression/snappypages OK 1s 913ms
/parquet/compression/snappyplain OK 902ms
/parquet/compression/snappyrle OK 960ms
/parquet/compression/zstd OK 990ms
/parquet/compression/zstdpages OK 1s 949ms
/parquet/datatypes OK 1m 8s
/parquet/datatypes/arrowtimestamp OK 908ms
/parquet/datatypes/arrowtimestampms OK 905ms
/parquet/datatypes/binary OK 976ms
/parquet/datatypes/binary string OK 978ms
/parquet/datatypes/blob OK 996ms
/parquet/datatypes/boolean OK 960ms
/parquet/datatypes/byte array OK 971ms
/parquet/datatypes/columnname OK 956ms
/parquet/datatypes/columnwithnull OK 985ms
/parquet/datatypes/columnwithnull2 OK 962ms
/parquet/datatypes/date OK 1s 42ms
/parquet/datatypes/decimal with filter OK 965ms
/parquet/datatypes/decimalvariousfilters OK 961ms
/parquet/datatypes/decimalwithfilter2 OK 957ms
/parquet/datatypes/enum OK 1s 14ms
/parquet/datatypes/enum2 OK 957ms
/parquet/datatypes/fixed length decimal OK 975ms
/parquet/datatypes/fixed length decimal legacy OK 967ms
/parquet/datatypes/fixedstring OK 977ms
/parquet/datatypes/float16 Skip 2ms
/parquet/datatypes/h2oai OK 975ms
/parquet/datatypes/hive OK 1s 909ms
/parquet/datatypes/int32 OK 964ms
/parquet/datatypes/int32 decimal OK 961ms
/parquet/datatypes/int64 OK 964ms
/parquet/datatypes/int64 decimal OK 962ms
/parquet/datatypes/json OK 965ms
/parquet/datatypes/large string map XFail 5s 764ms
/parquet/datatypes/largedouble OK 1s 34ms
/parquet/datatypes/manydatatypes OK 918ms
/parquet/datatypes/manydatatypes2 OK 1s 16ms
/parquet/datatypes/maps OK 966ms
/parquet/datatypes/nameswithemoji OK 983ms
/parquet/datatypes/nandouble OK 978ms
/parquet/datatypes/negativeint64 OK 945ms
/parquet/datatypes/nullbyte OK 974ms
/parquet/datatypes/nullbytemultiple OK 970ms
/parquet/datatypes/nullsinid OK 993ms
/parquet/datatypes/pandasdecimal OK 961ms
/parquet/datatypes/pandasdecimaldate OK 952ms
/parquet/datatypes/parquetgo OK 942ms
/parquet/datatypes/selectdatewithfilter OK 6s 20ms
/parquet/datatypes/singlenull OK 969ms
/parquet/datatypes/sparkv21 OK 1s 13ms
/parquet/datatypes/sparkv22 OK 1s 19ms
/parquet/datatypes/statdecimal OK 960ms
/parquet/datatypes/string OK 949ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 5s 56ms
/parquet/datatypes/stringtypes OK 949ms
/parquet/datatypes/struct OK 969ms
/parquet/datatypes/supporteduuid OK 962ms
/parquet/datatypes/timestamp1 OK 915ms
/parquet/datatypes/timestamp2 OK 923ms
/parquet/datatypes/timezone OK 922ms
/parquet/datatypes/unsigned OK 1s 948ms
/parquet/datatypes/unsupportednull OK 139ms
/parquet/complex OK 19s 838ms
/parquet/complex/arraystring OK 971ms
/parquet/complex/big tuple with nulls OK 970ms
/parquet/complex/bytearraydictionary OK 1s 21ms
/parquet/complex/complex null OK 1s 2ms
/parquet/complex/lagemap OK 940ms
/parquet/complex/largenestedarray OK 996ms
/parquet/complex/largestruct OK 977ms
/parquet/complex/largestruct2 OK 1s 164ms
/parquet/complex/largestruct3 OK 939ms
/parquet/complex/list OK 952ms
/parquet/complex/nested array OK 950ms
/parquet/complex/nested map OK 975ms
/parquet/complex/nestedallcomplex OK 1s 85ms
/parquet/complex/nestedarray2 OK 980ms
/parquet/complex/nestedstruct OK 993ms
/parquet/complex/nestedstruct2 OK 972ms
/parquet/complex/nestedstruct3 OK 937ms
/parquet/complex/nestedstruct4 OK 1s 136ms
/parquet/complex/tupleofnulls OK 949ms
/parquet/complex/tuplewithdatetime OK 910ms
/parquet/cache OK 1s 938ms
/parquet/cache/cache1 OK 966ms
/parquet/cache/cache2 OK 971ms
/parquet/glob OK 38s 746ms
/parquet/glob/fastparquet globs OK 819ms
/parquet/glob/glob1 OK 960ms
/parquet/glob/glob2 OK 1s 170ms
/parquet/glob/glob with multiple elements OK 222ms
/parquet/glob/million extensions OK 35s 569ms
/parquet/rowgroups OK 1s 981ms
/parquet/rowgroups/manyrowgroups OK 984ms
/parquet/rowgroups/manyrowgroups2 OK 995ms
/parquet/encrypted Skip 1ms
/parquet/fastparquet OK 7ms
/parquet/fastparquet/airlines Skip 934us
/parquet/fastparquet/baz Skip 1ms
/parquet/fastparquet/empty date Skip 757us
/parquet/fastparquet/evo Skip 777us
/parquet/fastparquet/fastparquet Skip 815us
/parquet/read and write OK 10m 31s
/parquet/read and write/read and write parquet file OK 10m 31s
/parquet/column related errors OK 582ms
/parquet/column related errors/check error with 500 columns OK 581ms
/parquet/multi chunk upload Skip 1ms
/parquet/minio OK 5m 29s
/parquet/minio/s3 OK 5m 29s
/parquet/minio/s3/compression type OK 5m 29s
/parquet/minio/s3/compression type/=NONE OK 5m 29s
/parquet/minio/s3/compression type/=NONE /outline OK 5m 29s
/parquet/minio/s3/compression type/=NONE /outline/engine OK 55ms
/parquet/minio/s3/compression type/=GZIP OK 5m 29s
/parquet/minio/s3/compression type/=GZIP /outline OK 5m 29s
/parquet/minio/s3/compression type/=GZIP /outline/engine OK 103ms
/parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine Skip 1ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine Skip 1ms
/parquet/minio/s3/compression type/=NONE /outline/engine/select from engine Skip 3ms
/parquet/minio/s3/compression type/=NONE /outline/engine/engine to file to engine Skip 6ms
/parquet/minio/s3/compression type/=LZ4 OK 5m 28s
/parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine from file Skip 13ms
/parquet/minio/s3/compression type/=NONE /outline/engine/engine select output to file Skip 14ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/select from engine Skip 15ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/engine to file to engine Skip 6ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine from file Skip 16ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/engine select output to file Skip 17ms
/parquet/minio/s3/compression type/=LZ4 /outline OK 5m 28s
/parquet/minio/s3/compression type/=LZ4 /outline/engine OK 157ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine Skip 1ms
/parquet/minio/s3/compression type/=NONE /outline/function OK 5m 29s
/parquet/minio/s3/compression type/=NONE /outline/function/insert into function OK 5m 29s
/parquet/minio/s3/compression type/=NONE /outline/function/select from function manual cast types OK 5m 8s
/parquet/minio/s3/compression type/=NONE /outline/function/select from function auto cast types OK 4m 45s
/parquet/minio/s3/compression type/=LZ4 /outline/engine/select from engine Skip 49ms
/parquet/minio/s3/compression type/=GZIP /outline/function OK 5m 29s
/parquet/minio/s3/compression type/=LZ4 /outline/engine/engine to file to engine Skip 1ms
/parquet/minio/s3/compression type/=GZIP /outline/function/insert into function OK 5m 29s
/parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine from file Skip 2ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/engine select output to file Skip 2ms
/parquet/minio/s3/compression type/=GZIP /outline/function/select from function manual cast types OK 5m 9s
/parquet/minio/s3/compression type/=GZIP /outline/function/select from function auto cast types OK 4m 45s
/parquet/minio/s3/compression type/=LZ4 /outline/function OK 5m 28s
/parquet/minio/s3/compression type/=LZ4 /outline/function/insert into function OK 5m 28s
/parquet/minio/s3/compression type/=LZ4 /outline/function/select from function manual cast types OK 5m 7s
/parquet/minio/s3/compression type/=LZ4 /outline/function/select from function auto cast types OK 4m 43s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922