Parquet Test Run Report

DateJun 13, 2025 14:25
Duration1h 19m
Framework TestFlows 2.0.250110.1002922

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/25.3/98010fbdcc6c8e06606d6252813a2a2f091516fe/package_aarch64/clickhouse-common-static_25.3.3.20143.altinityantalya_arm64.deb
version25.3.3.20143.altinityantalya
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash88c93f843cd48cd9defc6cec6b98d6b98f94adde
job.nameParquetS3 (minio)
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/15635502934
archaarch64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/25.3/98010fbdcc6c8e06606d6252813a2a2f091516fe/package_aarch64/clickhouse-common-static_25.3.3.20143.altinityantalya_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_readerFalse
stress_bloomFalse

Summary

99.9%OK
<1%Known

Statistics

Units Skip OK Fail Error XFail
Modules
1
1
Suites
8
8
Features
45
2
42
1
Scenarios
241
33
203
5
Checks
67591
67591
Examples
12
12
Steps
410991
31
408810
14
6
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engineXFail 44s 76ms
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 828, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 898, 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 898 in 'execute_query'

890\|                  with values() as that:
891\|                      snapshot_result = snapshot(
892\|                          "\n" + r.output.strip() + "\n",
893\|                          id=snapshot_id,
894\|                          name=snapshot_name,
895\|                          encoder=str,
896\|                          mode=snapshot.CHECK,
897\|                      )
898\|>                     assert that(snapshot_result), error()
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engineXFail 46s 709ms
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 828, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 898, 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 898 in 'execute_query'

890\|                  with values() as that:
891\|                      snapshot_result = snapshot(
892\|                          "\n" + r.output.strip() + "\n",
893\|                          id=snapshot_id,
894\|                          name=snapshot_name,
895\|                          encoder=str,
896\|                          mode=snapshot.CHECK,
897\|                      )
898\|>                     assert that(snapshot_result), error()
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engineXFail 46s 479ms
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 828, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 898, 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 898 in 'execute_query'

890\|                  with values() as that:
891\|                      snapshot_result = snapshot(
892\|                          "\n" + r.output.strip() + "\n",
893\|                          id=snapshot_id,
894\|                          name=snapshot_name,
895\|                          encoder=str,
896\|                          mode=snapshot.CHECK,
897\|                      )
898\|>                     assert that(snapshot_result), error()
/parquet/chunked arrayXFail 17s 866ms
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 25.3.3.20143.altinityantalya (altinity build))
(query: INSERT INTO table_225cb912_4867_11f0_836b_9600045f9237 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 437ms
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 9s 849ms
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 25.3.3):
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_7ebc706c_4868_11f0_b0bd_9600045f9237
            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 1h 19m
/parquet/file OK 41m 31s
/parquet/file/engine OK 41m 31s
/parquet/query OK 54m 52s
/parquet/query/compression type OK 54m 52s
/parquet/file/function OK 21m 7s
/parquet/query/compression type/=NONE OK 54m 52s
/parquet/query/compression type/=NONE /insert into memory table from file OK 11m 33s
/parquet/file/engine/insert into engine OK 25m 36s
/parquet/query/compression type/=GZIP OK 54m 52s
/parquet/query/compression type/=LZ4 OK 54m 51s
/parquet/file/function/insert into function auto cast types OK 21m 7s
/parquet/file/engine/select from engine OK 11m 58s
/parquet/list in multiple chunks OK 1m 21s
/parquet/file/function/select from function auto cast types OK 12m 3s
/parquet/file/engine/engine to file to engine OK 35m 56s
/parquet/file/function/insert into function manual cast types OK 20m 24s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 11m 29s
/parquet/file/engine/insert into engine from file OK 24m 41s
/parquet/file/engine/engine select output to file OK 41m 31s
/parquet/url OK 42m 38s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 11m 29s
/parquet/file/function/select from function manual cast types OK 19m 35s
/parquet/url/engine OK 41m 36s
/parquet/url/function OK 39m 36s
/parquet/url/engine/insert into engine OK 25m 57s
/parquet/url/function/insert into function OK 20m 6s
/parquet/url/function/select from function manual cast types OK 39m 36s
/parquet/url/engine/select from engine OK 11m 35s
/parquet/url/engine/engine to file to engine OK 35m 51s
/parquet/url/engine/insert into engine from file OK 34m 56s
/parquet/url/engine/engine select output to file OK 41m 36s
/parquet/url/function/select from function auto cast types OK 19m 38s
/parquet/mysql OK 2m 21s
/parquet/mysql/compression type OK 2m 21s
/parquet/mysql/compression type/=NONE OK 2m 18s
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 1m 39s
/parquet/mysql/compression type/=GZIP OK 2m 21s
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 1m 41s
/parquet/mysql/compression type/=LZ4 OK 2m 21s
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 1m 42s
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 38s 724ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 40s 342ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 39s 259ms
/parquet/postgresql OK 1m 27s
/parquet/postgresql/compression type OK 1m 27s
/parquet/postgresql/compression type/=NONE OK 1m 27s
/parquet/postgresql/compression type/=GZIP OK 1m 27s
/parquet/postgresql/compression type/=LZ4 OK 1m 25s
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 44s 76ms
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 46s 709ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 46s 479ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 41s 334ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 40s 473ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 40s 346ms
/parquet/remote OK 25m 4s
/parquet/remote/compression type OK 25m 3s
/parquet/remote/compression type/=NONE OK 25m 3s
/parquet/remote/compression type/=GZIP OK 25m 0s
/parquet/remote/compression type/=NONE /outline OK 25m 3s
/parquet/remote/compression type/=LZ4 OK 24m 58s
/parquet/remote/compression type/=GZIP /outline OK 25m 0s
/parquet/remote/compression type/=NONE /outline/insert into function OK 8m 42s
/parquet/remote/compression type/=LZ4 /outline OK 24m 58s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 8m 39s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 8m 37s
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 7m 17s
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 7m 14s
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 7m 22s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 16m 20s
/parquet/remote/compression type/=GZIP /outline/select from function OK 16m 20s
/parquet/remote/compression type/=NONE /outline/select from function OK 16m 21s
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 5m 22s
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 5m 22s
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 5m 14s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 4m 30s
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 4m 30s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 4m 31s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 8m 13s
/parquet/query/compression type/=GZIP /select from memory table into file OK 8m 10s
/parquet/query/compression type/=NONE /select from memory table into file OK 8m 8s
/parquet/chunked array XFail 17s 866ms
/parquet/broken OK 368ms
/parquet/broken/file Skip 9ms
/parquet/broken/read broken bigint Skip 14ms
/parquet/broken/read broken date Skip 9ms
/parquet/broken/read broken int Skip 67ms
/parquet/broken/read broken smallint Skip 18ms
/parquet/broken/read broken timestamp ms Skip 19ms
/parquet/broken/read broken timestamp us Skip 12ms
/parquet/broken/read broken tinyint Skip 20ms
/parquet/broken/read broken ubigint Skip 11ms
/parquet/broken/read broken uint Skip 11ms
/parquet/broken/read broken usmallint Skip 9ms
/parquet/broken/read broken utinyint Skip 44ms
/parquet/broken/string Skip 8ms
/parquet/encoding OK 1m 8s
/parquet/encoding/deltabytearray1 OK 9s 791ms
/parquet/encoding/deltabytearray2 OK 9s 896ms
/parquet/encoding/deltalengthbytearray OK 10s 32ms
/parquet/encoding/dictionary OK 9s 437ms
/parquet/encoding/plain OK 10s 231ms
/parquet/encoding/plainrlesnappy OK 10s 283ms
/parquet/encoding/rleboolean OK 8s 996ms
/parquet/compression OK 3m 56s
/parquet/compression/arrow snappy OK 10s 22ms
/parquet/compression/brotli OK 9s 897ms
/parquet/compression/gzippages OK 18s 543ms
/parquet/compression/largegzip OK 13s 460ms
/parquet/compression/lz4 hadoop OK 10s 473ms
/parquet/compression/lz4 hadoop large OK 11s 811ms
/parquet/compression/lz4 non hadoop OK 11s 294ms
/parquet/compression/lz4 raw OK 10s 876ms
/parquet/compression/lz4 raw large OK 13s 466ms
/parquet/compression/lz4pages OK 23s 673ms
/parquet/compression/nonepages OK 24s 673ms
/parquet/compression/snappypages OK 24s 806ms
/parquet/compression/snappyplain OK 11s 422ms
/parquet/compression/snappyrle OK 11s 180ms
/parquet/compression/zstd OK 9s 317ms
/parquet/compression/zstdpages OK 21s 751ms
/parquet/datatypes OK 8m 58s
/parquet/datatypes/arrowtimestamp OK 9s 638ms
/parquet/datatypes/arrowtimestampms OK 9s 594ms
/parquet/datatypes/binary OK 9s 885ms
/parquet/datatypes/binary string OK 9s 421ms
/parquet/datatypes/blob OK 8s 790ms
/parquet/datatypes/boolean OK 13s 156ms
/parquet/datatypes/byte array OK 12s 243ms
/parquet/query/compression type/=NONE /select from mergetree table into file OK 4m 29s
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 4m 27s
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 4m 28s
/parquet/datatypes/columnname OK 9s 151ms
/parquet/datatypes/columnwithnull OK 16s 584ms
/parquet/datatypes/columnwithnull2 OK 9s 486ms
/parquet/datatypes/date OK 8s 467ms
/parquet/datatypes/decimal with filter OK 8s 753ms
/parquet/datatypes/decimalvariousfilters OK 9s 10ms
/parquet/datatypes/decimalwithfilter2 OK 9s 977ms
/parquet/datatypes/enum OK 8s 954ms
/parquet/datatypes/enum2 OK 8s 21ms
/parquet/datatypes/fixed length decimal OK 8s 503ms
/parquet/datatypes/fixed length decimal legacy OK 9s 421ms
/parquet/datatypes/fixedstring OK 8s 159ms
/parquet/datatypes/float16 XFail 437ms
/parquet/datatypes/h2oai OK 9s 979ms
/parquet/datatypes/hive OK 18s 835ms
/parquet/datatypes/int32 OK 8s 990ms
/parquet/datatypes/int32 decimal OK 9s 559ms
/parquet/datatypes/int64 OK 8s 558ms
/parquet/datatypes/int64 decimal OK 8s 3ms
/parquet/datatypes/json OK 8s 820ms
/parquet/datatypes/large string map XFail 9s 849ms
/parquet/datatypes/largedouble OK 8s 593ms
/parquet/datatypes/manydatatypes OK 8s 55ms
/parquet/datatypes/manydatatypes2 OK 10s 67ms
/parquet/datatypes/maps OK 8s 934ms
/parquet/datatypes/nameswithemoji OK 8s 89ms
/parquet/datatypes/nandouble OK 9s 611ms
/parquet/datatypes/negativeint64 OK 9s 929ms
/parquet/datatypes/nullbyte OK 7s 912ms
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 3m 47s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 3m 48s
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 3m 47s
/parquet/datatypes/nullbytemultiple OK 9s 270ms
/parquet/datatypes/nullsinid OK 17s 477ms
/parquet/complex OK 2m 59s
/parquet/complex/arraystring OK 17s 268ms
/parquet/datatypes/pandasdecimal OK 8s 42ms
/parquet/complex/big tuple with nulls OK 7s 954ms
/parquet/datatypes/pandasdecimaldate OK 9s 839ms
/parquet/complex/bytearraydictionary OK 9s 977ms
/parquet/datatypes/parquetgo OK 9s 521ms
/parquet/complex/complex null OK 9s 718ms
/parquet/datatypes/selectdatewithfilter OK 20s 527ms
/parquet/complex/lagemap OK 9s 640ms
/parquet/complex/largenestedarray OK 9s 478ms
/parquet/datatypes/singlenull OK 8s 773ms
/parquet/complex/largestruct OK 7s 921ms
/parquet/cache OK 17s 74ms
/parquet/cache/cache1 OK 9s 457ms
/parquet/complex/largestruct2 OK 7s 564ms
/parquet/datatypes/sparkv21 OK 7s 596ms
/parquet/cache/cache2 OK 7s 607ms
/parquet/complex/largestruct3 OK 7s 877ms
/parquet/datatypes/sparkv22 OK 8s 5ms
/parquet/glob OK 46s 516ms
/parquet/glob/fastparquet globs OK 1s 553ms
/parquet/glob/glob1 OK 1s 730ms
/parquet/glob/glob2 OK 2s 883ms
/parquet/complex/list OK 8s 639ms
/parquet/datatypes/statdecimal OK 8s 635ms
/parquet/glob/glob with multiple elements OK 406ms
/parquet/glob/million extensions OK 39s 938ms
/parquet/complex/nested array OK 8s 13ms
/parquet/datatypes/string OK 8s 52ms
/parquet/complex/nested map OK 7s 641ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 14s 206ms
/parquet/complex/nestedallcomplex OK 8s 827ms
/parquet/datatypes/stringtypes OK 8s 927ms
/parquet/complex/nestedarray2 OK 8s 522ms
/parquet/datatypes/struct OK 7s 878ms
/parquet/complex/nestedstruct OK 7s 708ms
/parquet/rowgroups OK 17s 243ms
/parquet/rowgroups/manyrowgroups OK 8s 51ms
/parquet/datatypes/supporteduuid OK 8s 985ms
/parquet/complex/nestedstruct2 OK 9s 391ms
/parquet/rowgroups/manyrowgroups2 OK 9s 188ms
/parquet/datatypes/timestamp1 OK 8s 414ms
/parquet/complex/nestedstruct3 OK 8s 744ms
/parquet/encrypted Skip 4ms
/parquet/fastparquet OK 25ms
/parquet/fastparquet/airlines Skip 2ms
/parquet/fastparquet/baz Skip 3ms
/parquet/fastparquet/empty date Skip 2ms
/parquet/fastparquet/evo Skip 1ms
/parquet/fastparquet/fastparquet Skip 1ms
/parquet/read and write OK 17m 41s
/parquet/read and write/read and write parquet file OK 17m 41s
/parquet/datatypes/timestamp2 OK 8s 550ms
/parquet/complex/nestedstruct4 OK 8s 195ms
/parquet/datatypes/timezone OK 7s 596ms
/parquet/complex/tupleofnulls OK 7s 575ms
/parquet/datatypes/unsigned OK 16s 138ms
/parquet/complex/tuplewithdatetime OK 8s 976ms
/parquet/column related errors OK 2s 347ms
/parquet/column related errors/check error with 500 columns OK 2s 342ms
/parquet/multi chunk upload Skip 1ms
/parquet/datatypes/unsupportednull OK 305ms
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 4m 10s
/parquet/query/compression type/=GZIP /select from distributed table into file OK 4m 11s
/parquet/query/compression type/=NONE /select from distributed table into file OK 4m 9s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 3m 43s
/parquet/query/compression type/=NONE /select from mat view into file OK 3m 43s
/parquet/query/compression type/=GZIP /select from mat view into file OK 3m 42s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 1m 52s
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 1m 52s
/parquet/query/compression type/=NONE /insert into table with projection from file OK 1m 52s
/parquet/minio OK 11m 28s
/parquet/minio/s3 OK 11m 28s
/parquet/minio/s3/compression type OK 11m 28s
/parquet/minio/s3/compression type/=NONE OK 11m 28s
/parquet/minio/s3/compression type/=NONE /outline OK 11m 28s
/parquet/minio/s3/compression type/=NONE /outline/engine OK 89ms
/parquet/minio/s3/compression type/=GZIP OK 11m 27s
/parquet/minio/s3/compression type/=GZIP /outline OK 11m 27s
/parquet/minio/s3/compression type/=GZIP /outline/engine OK 49ms
/parquet/minio/s3/compression type/=LZ4 OK 11m 26s
/parquet/minio/s3/compression type/=LZ4 /outline OK 11m 26s
/parquet/minio/s3/compression type/=LZ4 /outline/engine OK 189ms
/parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine Skip 1ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine Skip 4ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine Skip 2ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/select from engine Skip 1ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/engine to file to engine Skip 1ms
/parquet/minio/s3/compression type/=NONE /outline/engine/select from engine Skip 1ms
/parquet/minio/s3/compression type/=NONE /outline/engine/engine to file to engine Skip 1ms
/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/=LZ4 /outline/engine/select from engine Skip 2ms
/parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine from file Skip 1ms
/parquet/minio/s3/compression type/=NONE /outline/engine/engine select output to file Skip 2ms
/parquet/minio/s3/compression type/=GZIP /outline/function OK 11m 27s
/parquet/minio/s3/compression type/=GZIP /outline/function/insert into function OK 6m 37s
/parquet/minio/s3/compression type/=GZIP /outline/function/select from function manual cast types OK 11m 27s
/parquet/minio/s3/compression type/=LZ4 /outline/engine/engine to file to engine Skip 2ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine from file Skip 57ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/engine select output to file Skip 2ms
/parquet/minio/s3/compression type/=NONE /outline/function OK 11m 28s
/parquet/minio/s3/compression type/=NONE /outline/function/insert into function OK 6m 36s
/parquet/minio/s3/compression type/=GZIP /outline/function/select from function auto cast types OK 5m 36s
/parquet/minio/s3/compression type/=NONE /outline/function/select from function manual cast types OK 11m 28s
/parquet/minio/s3/compression type/=NONE /outline/function/select from function auto cast types OK 5m 36s
/parquet/minio/s3/compression type/=LZ4 /outline/function OK 11m 26s
/parquet/minio/s3/compression type/=LZ4 /outline/function/insert into function OK 6m 38s
/parquet/minio/s3/compression type/=LZ4 /outline/function/select from function manual cast types OK 11m 26s
/parquet/minio/s3/compression type/=LZ4 /outline/function/select from function auto cast types OK 5m 36s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922