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

DateNov 13, 2025 8:49
Duration1h 8m
Framework TestFlows 2.0.250110.1002922

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#REFs/v25.3.8.10041.altinitystable/cfe75cb0ba14d5c72cc045c534cc618d82a22665/regression/aarch64/with_analyzer/zookeeper/without_thread_fuzzer/parquetminio/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/25.3/cfe75cb0ba14d5c72cc045c534cc618d82a22665/package_aarch64/clickhouse-common-static_25.3.8.10041.altinitystable_arm64.deb
version25.3.8.10041.altinitystable
user.namezvonand
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash8d18b5f6fe8f7c6a53b4363ff27dbefca8f4e004
job.nameParquetS3 (minio)
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/19324403725
archaarch64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/25.3/cfe75cb0ba14d5c72cc045c534cc618d82a22665/package_aarch64/clickhouse-common-static_25.3.8.10041.altinitystable_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
33
203
5
Checks
67591
67591
Examples
12
12
Steps
411131
44
408937
20
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engineXFail 7s 688ms
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 7s 408ms
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 7s 699ms
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 15s 322ms
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 25.3.8.10041.altinitystable (altinity build))
(query: INSERT INTO table_333fe2f9_c074_11f0_b63f_920006bcb597 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/float16XFail 237ms
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 '[-2,-1,0,1,2,3,4,5,6,7,8]'
  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 @@
    -[-2,-1,0,1,2,3,4,5,6,7,8]
    +[-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 5s 871ms
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 25.3.8):
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_5eda96b8_c074_11f0_96e5_920006bcb597
            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 8m
/parquet/file OK 10m 32s
/parquet/file/engine OK 10m 32s
/parquet/file/function OK 4m 58s
/parquet/file/engine/insert into engine OK 5m 8s
/parquet/file/function/insert into function manual cast types OK 4m 33s
/parquet/file/function/insert into function auto cast types OK 4m 58s
/parquet/file/engine/select from engine OK 2m 27s
/parquet/file/function/select from function manual cast types OK 3m 1s
/parquet/file/engine/engine to file to engine OK 8m 0s
/parquet/file/function/select from function auto cast types OK 2m 31s
/parquet/file/engine/insert into engine from file OK 4m 48s
/parquet/file/engine/engine select output to file OK 10m 32s
/parquet/query OK 17m 56s
/parquet/query/compression type OK 17m 56s
/parquet/query/compression type/=NONE OK 17m 55s
/parquet/query/compression type/=NONE /insert into memory table from file OK 57s 419ms
/parquet/query/compression type/=GZIP OK 17m 56s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 57s 302ms
/parquet/query/compression type/=LZ4 OK 17m 55s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 57s 242ms
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 57s 614ms
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 57s 236ms
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 57s 719ms
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 57s 873ms
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 57s 637ms
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 57s 296ms
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 59s 225ms
/parquet/query/compression type/=NONE /insert into distributed table from file OK 59s 413ms
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 59s 101ms
/parquet/query/compression type/=LZ4 /select from memory table into file OK 2m 28s
/parquet/query/compression type/=GZIP /select from memory table into file OK 2m 30s
/parquet/query/compression type/=NONE /select from memory table into file OK 2m 29s
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 2m 31s
/parquet/query/compression type/=NONE /select from mergetree table into file OK 2m 31s
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 2m 31s
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 2m 33s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 2m 31s
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 2m 32s
/parquet/query/compression type/=NONE /select from distributed table into file OK 3m 6s
/parquet/query/compression type/=LZ4 /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/=NONE /select from mat view into file OK 2m 30s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 2m 29s
/parquet/query/compression type/=GZIP /select from mat view into file OK 2m 33s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 53s 884ms
/parquet/query/compression type/=NONE /insert into table with projection from file OK 53s 665ms
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 50s 60ms
/parquet/list in multiple chunks OK 19s 64ms
/parquet/url OK 10m 22s
/parquet/url/engine OK 9m 49s
/parquet/url/engine/insert into engine OK 4m 0s
/parquet/url/function OK 4m 32s
/parquet/url/function/insert into function OK 3m 1s
/parquet/url/engine/select from engine OK 1m 12s
/parquet/url/function/select from function manual cast types OK 4m 32s
/parquet/url/engine/engine to file to engine OK 7m 5s
/parquet/url/engine/insert into engine from file OK 6m 24s
/parquet/url/function/select from function auto cast types OK 2m 59s
/parquet/url/engine/engine select output to file OK 9m 49s
/parquet/mysql OK 10s 513ms
/parquet/mysql/compression type OK 10s 512ms
/parquet/mysql/compression type/=NONE OK 10s 245ms
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 5s 942ms
/parquet/mysql/compression type/=GZIP OK 10s 411ms
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 6s 57ms
/parquet/mysql/compression type/=LZ4 OK 10s 497ms
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 6s 59ms
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 4s 299ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 4s 351ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 4s 437ms
/parquet/postgresql OK 12s 264ms
/parquet/postgresql/compression type OK 12s 263ms
/parquet/postgresql/compression type/=NONE OK 12s 253ms
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 7s 688ms
/parquet/postgresql/compression type/=GZIP OK 11s 971ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 7s 408ms
/parquet/postgresql/compression type/=LZ4 OK 12s 247ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 7s 699ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 4s 561ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 4s 562ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 4s 545ms
/parquet/remote OK 4m 13s
/parquet/remote/compression type OK 4m 13s
/parquet/remote/compression type/=NONE OK 4m 13s
/parquet/remote/compression type/=NONE /outline OK 4m 13s
/parquet/remote/compression type/=NONE /outline/insert into function OK 1m 30s
/parquet/remote/compression type/=GZIP OK 4m 11s
/parquet/remote/compression type/=GZIP /outline OK 4m 11s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 1m 30s
/parquet/remote/compression type/=LZ4 OK 4m 11s
/parquet/remote/compression type/=LZ4 /outline OK 4m 11s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 1m 30s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 2m 41s
/parquet/remote/compression type/=NONE /outline/select from function OK 2m 42s
/parquet/remote/compression type/=GZIP /outline/select from function OK 2m 40s
/parquet/chunked array XFail 15s 322ms
/parquet/broken OK 22ms
/parquet/broken/file Skip 3ms
/parquet/broken/read broken bigint Skip 1ms
/parquet/broken/read broken date Skip 1ms
/parquet/broken/read broken int Skip 1ms
/parquet/broken/read broken smallint Skip 892us
/parquet/broken/read broken timestamp ms Skip 883us
/parquet/broken/read broken timestamp us Skip 930us
/parquet/broken/read broken tinyint Skip 1ms
/parquet/broken/read broken ubigint Skip 844us
/parquet/broken/read broken uint Skip 844us
/parquet/broken/read broken usmallint Skip 879us
/parquet/broken/read broken utinyint Skip 1ms
/parquet/broken/string Skip 787us
/parquet/encoding OK 7s 587ms
/parquet/encoding/deltabytearray1 OK 1s 441ms
/parquet/encoding/deltabytearray2 OK 1s 48ms
/parquet/encoding/deltalengthbytearray OK 1s 29ms
/parquet/encoding/dictionary OK 977ms
/parquet/encoding/plain OK 991ms
/parquet/encoding/plainrlesnappy OK 1s 44ms
/parquet/encoding/rleboolean OK 1s 51ms
/parquet/compression OK 21s 867ms
/parquet/compression/arrow snappy OK 1s 39ms
/parquet/compression/brotli OK 1s 25ms
/parquet/compression/gzippages OK 2s 90ms
/parquet/compression/largegzip OK 1s 59ms
/parquet/compression/lz4 hadoop OK 1s 7ms
/parquet/compression/lz4 hadoop large OK 1s 18ms
/parquet/compression/lz4 non hadoop OK 1s 27ms
/parquet/compression/lz4 raw OK 1s 38ms
/parquet/compression/lz4 raw large OK 1s 45ms
/parquet/compression/lz4pages OK 2s 118ms
/parquet/compression/nonepages OK 2s 104ms
/parquet/compression/snappypages OK 2s 108ms
/parquet/compression/snappyplain OK 985ms
/parquet/compression/snappyrle OK 1s 74ms
/parquet/compression/zstd OK 1s 30ms
/parquet/compression/zstdpages OK 2s 86ms
/parquet/datatypes OK 1m 13s
/parquet/datatypes/arrowtimestamp OK 953ms
/parquet/datatypes/arrowtimestampms OK 954ms
/parquet/datatypes/binary OK 1s 32ms
/parquet/datatypes/binary string OK 1s 57ms
/parquet/datatypes/blob OK 1s 47ms
/parquet/datatypes/boolean OK 1s 24ms
/parquet/datatypes/byte array OK 1s 75ms
/parquet/datatypes/columnname OK 1s 19ms
/parquet/datatypes/columnwithnull OK 1s 81ms
/parquet/datatypes/columnwithnull2 OK 1s 97ms
/parquet/datatypes/date OK 1s 95ms
/parquet/datatypes/decimal with filter OK 1s 55ms
/parquet/datatypes/decimalvariousfilters OK 1s 64ms
/parquet/datatypes/decimalwithfilter2 OK 1s 59ms
/parquet/datatypes/enum OK 1s 80ms
/parquet/datatypes/enum2 OK 1s 34ms
/parquet/datatypes/fixed length decimal OK 1s 31ms
/parquet/datatypes/fixed length decimal legacy OK 1s 37ms
/parquet/datatypes/fixedstring OK 1s 50ms
/parquet/datatypes/float16 XFail 237ms
/parquet/datatypes/h2oai OK 1s 55ms
/parquet/datatypes/hive OK 2s 57ms
/parquet/datatypes/int32 OK 1s 27ms
/parquet/datatypes/int32 decimal OK 1s 34ms
/parquet/datatypes/int64 OK 1s 32ms
/parquet/datatypes/int64 decimal OK 1s 42ms
/parquet/datatypes/json OK 998ms
/parquet/datatypes/large string map XFail 5s 871ms
/parquet/datatypes/largedouble OK 1s 166ms
/parquet/datatypes/manydatatypes OK 959ms
/parquet/datatypes/manydatatypes2 OK 1s 80ms
/parquet/datatypes/maps OK 1s 44ms
/parquet/datatypes/nameswithemoji OK 1s 31ms
/parquet/datatypes/nandouble OK 1s 48ms
/parquet/datatypes/negativeint64 OK 969ms
/parquet/datatypes/nullbyte OK 1s 54ms
/parquet/datatypes/nullbytemultiple OK 1s 31ms
/parquet/datatypes/nullsinid OK 1s 57ms
/parquet/datatypes/pandasdecimal OK 1s 51ms
/parquet/datatypes/pandasdecimaldate OK 1s 47ms
/parquet/datatypes/parquetgo OK 1s 31ms
/parquet/datatypes/selectdatewithfilter OK 6s 630ms
/parquet/datatypes/singlenull OK 1s 42ms
/parquet/datatypes/sparkv21 OK 1s 93ms
/parquet/datatypes/sparkv22 OK 1s 70ms
/parquet/datatypes/statdecimal OK 1s 53ms
/parquet/datatypes/string OK 1s 39ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 5s 411ms
/parquet/datatypes/stringtypes OK 1s 16ms
/parquet/datatypes/struct OK 1s 25ms
/parquet/datatypes/supporteduuid OK 1s 45ms
/parquet/datatypes/timestamp1 OK 967ms
/parquet/datatypes/timestamp2 OK 987ms
/parquet/datatypes/timezone OK 934ms
/parquet/datatypes/unsigned OK 2s 123ms
/parquet/datatypes/unsupportednull OK 147ms
/parquet/complex OK 21s 409ms
/parquet/complex/arraystring OK 1s 44ms
/parquet/complex/big tuple with nulls OK 1s 45ms
/parquet/complex/bytearraydictionary OK 1s 78ms
/parquet/complex/complex null OK 1s 50ms
/parquet/complex/lagemap OK 1s 66ms
/parquet/complex/largenestedarray OK 1s 56ms
/parquet/complex/largestruct OK 992ms
/parquet/complex/largestruct2 OK 1s 278ms
/parquet/complex/largestruct3 OK 997ms
/parquet/complex/list OK 1s 39ms
/parquet/complex/nested array OK 1s 66ms
/parquet/complex/nested map OK 1s 108ms
/parquet/complex/nestedallcomplex OK 1s 197ms
/parquet/complex/nestedarray2 OK 1s 37ms
/parquet/complex/nestedstruct OK 1s 85ms
/parquet/complex/nestedstruct2 OK 1s 32ms
/parquet/complex/nestedstruct3 OK 1s 32ms
/parquet/complex/nestedstruct4 OK 1s 191ms
/parquet/complex/tupleofnulls OK 1s 16ms
/parquet/complex/tuplewithdatetime OK 982ms
/parquet/cache OK 2s 88ms
/parquet/cache/cache1 OK 1s 57ms
/parquet/cache/cache2 OK 1s 29ms
/parquet/glob OK 38s 959ms
/parquet/glob/fastparquet globs OK 774ms
/parquet/glob/glob1 OK 1s 43ms
/parquet/glob/glob2 OK 1s 268ms
/parquet/glob/glob with multiple elements OK 252ms
/parquet/glob/million extensions OK 35s 616ms
/parquet/rowgroups OK 2s 132ms
/parquet/rowgroups/manyrowgroups OK 1s 78ms
/parquet/rowgroups/manyrowgroups2 OK 1s 52ms
/parquet/encrypted Skip 2ms
/parquet/fastparquet OK 7ms
/parquet/fastparquet/airlines Skip 1ms
/parquet/fastparquet/baz Skip 911us
/parquet/fastparquet/empty date Skip 824us
/parquet/fastparquet/evo Skip 1ms
/parquet/fastparquet/fastparquet Skip 837us
/parquet/read and write OK 11m 50s
/parquet/read and write/read and write parquet file OK 11m 50s
/parquet/column related errors OK 641ms
/parquet/column related errors/check error with 500 columns OK 640ms
/parquet/multi chunk upload Skip 1ms
/parquet/minio OK 5m 48s
/parquet/minio/s3 OK 5m 48s
/parquet/minio/s3/compression type OK 5m 48s
/parquet/minio/s3/compression type/=NONE OK 5m 48s
/parquet/minio/s3/compression type/=NONE /outline OK 5m 48s
/parquet/minio/s3/compression type/=NONE /outline/engine OK 49ms
/parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine Skip 2ms
/parquet/minio/s3/compression type/=GZIP OK 5m 48s
/parquet/minio/s3/compression type/=GZIP /outline OK 5m 48s
/parquet/minio/s3/compression type/=GZIP /outline/engine OK 276ms
/parquet/minio/s3/compression type/=LZ4 OK 5m 48s
/parquet/minio/s3/compression type/=LZ4 /outline OK 5m 48s
/parquet/minio/s3/compression type/=LZ4 /outline/engine OK 66ms
/parquet/minio/s3/compression type/=NONE /outline/engine/select from engine Skip 2ms
/parquet/minio/s3/compression type/=NONE /outline/engine/engine to file to engine Skip 2ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine Skip 2ms
/parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine from file Skip 2ms
/parquet/minio/s3/compression type/=NONE /outline/engine/engine select output to file Skip 1ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/select from engine Skip 1ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/engine to file to engine Skip 14ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine from file Skip 3ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine Skip 1ms
/parquet/minio/s3/compression type/=NONE /outline/function OK 5m 48s
/parquet/minio/s3/compression type/=LZ4 /outline/engine/engine select output to file Skip 10ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/select from engine Skip 2ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/engine to file to engine Skip 12ms
/parquet/minio/s3/compression type/=NONE /outline/function/insert into function OK 5m 48s
/parquet/minio/s3/compression type/=NONE /outline/function/select from function manual cast types OK 5m 25s
/parquet/minio/s3/compression type/=LZ4 /outline/function OK 5m 48s
/parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine from file Skip 1ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/engine select output to file Skip 1ms
/parquet/minio/s3/compression type/=NONE /outline/function/select from function auto cast types OK 5m 1s
/parquet/minio/s3/compression type/=LZ4 /outline/function/insert into function OK 5m 48s
/parquet/minio/s3/compression type/=LZ4 /outline/function/select from function manual cast types OK 5m 24s
/parquet/minio/s3/compression type/=LZ4 /outline/function/select from function auto cast types OK 5m 0s
/parquet/minio/s3/compression type/=GZIP /outline/function OK 5m 47s
/parquet/minio/s3/compression type/=GZIP /outline/function/insert into function OK 5m 47s
/parquet/minio/s3/compression type/=GZIP /outline/function/select from function manual cast types OK 5m 24s
/parquet/minio/s3/compression type/=GZIP /outline/function/select from function auto cast types OK 5m 1s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922