Parquet Test Run Report

DateJul 28, 2025 10:06
Duration54m 5s
Framework TestFlows 2.0.250110.1002922

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/25.3/d32d0074004db61e346611c777e26532a456fe2f/package_release/clickhouse-common-static_25.3.6.10034.altinitystable_amd64.deb
version25.3.6.10034.altinitystable
user.namezvonand
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash5723e20cbc49b347114c7b90c7316a44dafa5328
job.nameParquetS3 (minio)
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/16564498156
archx86_64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/25.3/d32d0074004db61e346611c777e26532a456fe2f/package_release/clickhouse-common-static_25.3.6.10034.altinitystable_amd64.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 XFail
Modules
1
1
Suites
8
8
Features
45
2
42
1
Scenarios
241
33
203
5
Checks
67591
67591
Examples
12
12
Steps
411009
42
408823
14
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engineXFail 18s 391ms
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 18s 335ms
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/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engineXFail 19s 619ms
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/chunked arrayXFail 13s 596ms
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.6.10034.altinitystable (altinity build))
(query: INSERT INTO table_3496b8c8_6b9e_11f0_9657_920006481f42 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 584ms
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 7s 485ms
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.6):
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_7f40d4ae_6b9e_11f0_9850_920006481f42
            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 54m 5s
/parquet/file OK 28m 4s
/parquet/file/engine OK 28m 4s
/parquet/file/function OK 13m 6s
/parquet/file/engine/insert into engine OK 16m 52s
/parquet/file/engine/select from engine OK 6m 15s
/parquet/query OK 38m 15s
/parquet/query/compression type OK 38m 15s
/parquet/file/function/insert into function manual cast types OK 12m 40s
/parquet/file/function/insert into function auto cast types OK 13m 6s
/parquet/query/compression type/=NONE OK 38m 14s
/parquet/file/function/select from function manual cast types OK 7m 1s
/parquet/file/engine/engine to file to engine OK 24m 1s
/parquet/file/engine/insert into engine from file OK 16m 16s
/parquet/query/compression type/=GZIP OK 38m 14s
/parquet/list in multiple chunks OK 5m 23s
/parquet/file/function/select from function auto cast types OK 6m 14s
/parquet/file/engine/engine select output to file OK 28m 4s
/parquet/query/compression type/=LZ4 OK 38m 15s
/parquet/url OK 29m 7s
/parquet/query/compression type/=NONE /insert into memory table from file OK 5m 59s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 6m 0s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 6m 3s
/parquet/url/engine OK 28m 21s
/parquet/url/function OK 13m 58s
/parquet/url/engine/insert into engine OK 17m 16s
/parquet/url/function/insert into function OK 12m 31s
/parquet/url/engine/select from engine OK 6m 16s
/parquet/url/function/select from function manual cast types OK 13m 58s
/parquet/url/function/select from function auto cast types OK 12m 20s
/parquet/url/engine/engine to file to engine OK 24m 9s
/parquet/url/engine/insert into engine from file OK 23m 11s
/parquet/url/engine/engine select output to file OK 28m 20s
/parquet/mysql OK 44s 129ms
/parquet/mysql/compression type OK 44s 101ms
/parquet/mysql/compression type/=NONE OK 41s 261ms
/parquet/mysql/compression type/=GZIP OK 40s 622ms
/parquet/mysql/compression type/=LZ4 OK 44s 56ms
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 22s 69ms
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 20s 872ms
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 22s 905ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 19s 567ms
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 19s 63ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 20s 955ms
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 6m 1s
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 6m 4s
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 6m 2s
/parquet/postgresql OK 38s 513ms
/parquet/postgresql/compression type OK 38s 463ms
/parquet/postgresql/compression type/=NONE OK 37s 156ms
/parquet/postgresql/compression type/=GZIP OK 37s 40ms
/parquet/postgresql/compression type/=LZ4 OK 38s 432ms
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 18s 391ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 18s 335ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 19s 619ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 18s 645ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 18s 670ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 18s 738ms
/parquet/remote OK 15m 12s
/parquet/remote/compression type OK 15m 12s
/parquet/remote/compression type/=NONE OK 15m 12s
/parquet/remote/compression type/=GZIP OK 15m 8s
/parquet/remote/compression type/=LZ4 OK 15m 10s
/parquet/remote/compression type/=GZIP /outline OK 15m 7s
/parquet/remote/compression type/=NONE /outline OK 15m 11s
/parquet/remote/compression type/=LZ4 /outline OK 15m 10s
/parquet/remote/compression type/=NONE /outline/insert into function OK 5m 59s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 5m 59s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 5m 58s
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 4m 2s
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 3m 59s
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 3m 58s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 9m 11s
/parquet/remote/compression type/=NONE /outline/select from function OK 9m 12s
/parquet/remote/compression type/=GZIP /outline/select from function OK 9m 8s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 3m 1s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 3m 1s
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 3m 0s
/parquet/query/compression type/=NONE /select from memory table into file OK 5m 38s
/parquet/query/compression type/=GZIP /select from memory table into file OK 5m 34s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 5m 37s
/parquet/chunked array XFail 13s 596ms
/parquet/broken OK 436ms
/parquet/broken/file Skip 27ms
/parquet/broken/read broken bigint Skip 17ms
/parquet/broken/read broken date Skip 14ms
/parquet/broken/read broken int Skip 10ms
/parquet/broken/read broken smallint Skip 14ms
/parquet/broken/read broken timestamp ms Skip 34ms
/parquet/broken/read broken timestamp us Skip 13ms
/parquet/broken/read broken tinyint Skip 12ms
/parquet/broken/read broken ubigint Skip 11ms
/parquet/broken/read broken uint Skip 10ms
/parquet/broken/read broken usmallint Skip 15ms
/parquet/broken/read broken utinyint Skip 25ms
/parquet/broken/string Skip 18ms
/parquet/encoding OK 16s 123ms
/parquet/encoding/deltabytearray1 OK 2s 976ms
/parquet/encoding/deltabytearray2 OK 1s 949ms
/parquet/encoding/deltalengthbytearray OK 2s 199ms
/parquet/encoding/dictionary OK 1s 780ms
/parquet/encoding/plain OK 2s 203ms
/parquet/encoding/plainrlesnappy OK 2s 973ms
/parquet/encoding/rleboolean OK 1s 962ms
/parquet/compression OK 41s 351ms
/parquet/compression/arrow snappy OK 1s 735ms
/parquet/compression/brotli OK 1s 786ms
/parquet/compression/gzippages OK 3s 743ms
/parquet/compression/largegzip OK 2s 84ms
/parquet/compression/lz4 hadoop OK 1s 752ms
/parquet/compression/lz4 hadoop large OK 2s 61ms
/parquet/compression/lz4 non hadoop OK 1s 915ms
/parquet/compression/lz4 raw OK 1s 994ms
/parquet/compression/lz4 raw large OK 1s 867ms
/parquet/compression/lz4pages OK 4s 156ms
/parquet/compression/nonepages OK 3s 809ms
/parquet/compression/snappypages OK 4s 187ms
/parquet/compression/snappyplain OK 1s 998ms
/parquet/compression/snappyrle OK 1s 852ms
/parquet/compression/zstd OK 2s 176ms
/parquet/compression/zstdpages OK 4s 100ms
/parquet/datatypes OK 2m 0s
/parquet/datatypes/arrowtimestamp OK 1s 770ms
/parquet/datatypes/arrowtimestampms OK 1s 701ms
/parquet/datatypes/binary OK 2s 206ms
/parquet/datatypes/binary string OK 1s 965ms
/parquet/datatypes/blob OK 1s 748ms
/parquet/datatypes/boolean OK 1s 851ms
/parquet/datatypes/byte array OK 1s 860ms
/parquet/datatypes/columnname OK 2s 238ms
/parquet/datatypes/columnwithnull OK 1s 702ms
/parquet/datatypes/columnwithnull2 OK 1s 968ms
/parquet/datatypes/date OK 1s 979ms
/parquet/datatypes/decimal with filter OK 2s 162ms
/parquet/datatypes/decimalvariousfilters OK 2s 280ms
/parquet/datatypes/decimalwithfilter2 OK 1s 973ms
/parquet/datatypes/enum OK 2s 194ms
/parquet/datatypes/enum2 OK 2s 192ms
/parquet/datatypes/fixed length decimal OK 1s 939ms
/parquet/datatypes/fixed length decimal legacy OK 2s 51ms
/parquet/datatypes/fixedstring OK 1s 867ms
/parquet/datatypes/float16 XFail 584ms
/parquet/datatypes/h2oai OK 1s 831ms
/parquet/datatypes/hive OK 3s 757ms
/parquet/datatypes/int32 OK 1s 790ms
/parquet/datatypes/int32 decimal OK 1s 846ms
/parquet/datatypes/int64 OK 1s 778ms
/parquet/datatypes/int64 decimal OK 2s 147ms
/parquet/datatypes/json OK 1s 827ms
/parquet/datatypes/large string map XFail 7s 485ms
/parquet/datatypes/largedouble OK 2s 64ms
/parquet/datatypes/manydatatypes OK 1s 196ms
/parquet/datatypes/manydatatypes2 OK 2s 116ms
/parquet/datatypes/maps OK 1s 897ms
/parquet/datatypes/nameswithemoji OK 1s 516ms
/parquet/datatypes/nandouble OK 1s 367ms
/parquet/datatypes/negativeint64 OK 1s 556ms
/parquet/datatypes/nullbyte OK 1s 850ms
/parquet/datatypes/nullbytemultiple OK 1s 172ms
/parquet/datatypes/nullsinid OK 1s 354ms
/parquet/datatypes/pandasdecimal OK 1s 508ms
/parquet/datatypes/pandasdecimaldate OK 1s 350ms
/parquet/datatypes/parquetgo OK 1s 950ms
/parquet/datatypes/selectdatewithfilter OK 11s 324ms
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 3m 14s
/parquet/query/compression type/=NONE /select from mergetree table into file OK 3m 11s
/parquet/datatypes/singlenull OK 1s 234ms
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 3m 12s
/parquet/datatypes/sparkv21 OK 1s 273ms
/parquet/datatypes/sparkv22 OK 1s 226ms
/parquet/datatypes/statdecimal OK 1s 253ms
/parquet/datatypes/string OK 2s 850ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 6s 812ms
/parquet/datatypes/stringtypes OK 2s 205ms
/parquet/datatypes/struct OK 1s 482ms
/parquet/datatypes/supporteduuid OK 1s 310ms
/parquet/datatypes/timestamp1 OK 1s 424ms
/parquet/datatypes/timestamp2 OK 1s 384ms
/parquet/datatypes/timezone OK 1s 66ms
/parquet/datatypes/unsigned OK 3s 7ms
/parquet/datatypes/unsupportednull OK 505ms
/parquet/complex OK 30s 631ms
/parquet/complex/arraystring OK 1s 465ms
/parquet/complex/big tuple with nulls OK 1s 413ms
/parquet/complex/bytearraydictionary OK 1s 417ms
/parquet/complex/complex null OK 1s 736ms
/parquet/complex/lagemap OK 1s 351ms
/parquet/complex/largenestedarray OK 1s 345ms
/parquet/complex/largestruct OK 1s 495ms
/parquet/complex/largestruct2 OK 1s 646ms
/parquet/complex/largestruct3 OK 1s 506ms
/parquet/complex/list OK 1s 498ms
/parquet/complex/nested array OK 1s 386ms
/parquet/complex/nested map OK 1s 399ms
/parquet/complex/nestedallcomplex OK 1s 819ms
/parquet/complex/nestedarray2 OK 1s 680ms
/parquet/complex/nestedstruct OK 1s 652ms
/parquet/complex/nestedstruct2 OK 1s 498ms
/parquet/complex/nestedstruct3 OK 1s 556ms
/parquet/complex/nestedstruct4 OK 1s 797ms
/parquet/complex/tupleofnulls OK 1s 509ms
/parquet/complex/tuplewithdatetime OK 1s 347ms
/parquet/cache OK 3s 30ms
/parquet/cache/cache1 OK 1s 375ms
/parquet/cache/cache2 OK 1s 649ms
/parquet/glob OK 41s 259ms
/parquet/glob/fastparquet globs OK 9s 466ms
/parquet/glob/glob1 OK 1s 644ms
/parquet/glob/glob2 OK 2s 604ms
/parquet/glob/glob with multiple elements OK 440ms
/parquet/glob/million extensions OK 27s 95ms
/parquet/rowgroups OK 3s 228ms
/parquet/rowgroups/manyrowgroups OK 1s 771ms
/parquet/rowgroups/manyrowgroups2 OK 1s 447ms
/parquet/encrypted Skip 18ms
/parquet/fastparquet OK 42ms
/parquet/fastparquet/airlines Skip 3ms
/parquet/fastparquet/baz Skip 3ms
/parquet/fastparquet/empty date Skip 2ms
/parquet/fastparquet/evo Skip 4ms
/parquet/fastparquet/fastparquet Skip 4ms
/parquet/read and write OK 16m 26s
/parquet/read and write/read and write parquet file OK 16m 26s
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 3m 0s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 3m 1s
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 3m 1s
/parquet/column related errors OK 1s 849ms
/parquet/column related errors/check error with 500 columns OK 1s 841ms
/parquet/multi chunk upload Skip 24ms
/parquet/query/compression type/=GZIP /select from distributed table into file OK 3m 21s
/parquet/query/compression type/=NONE /select from distributed table into file OK 3m 21s
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 3m 20s
/parquet/query/compression type/=GZIP /select from mat view into file OK 2m 56s
/parquet/query/compression type/=NONE /select from mat view into file OK 2m 55s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 2m 56s
/parquet/query/compression type/=NONE /insert into table with projection from file OK 1m 1s
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 1m 1s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 1m 0s
/parquet/minio OK 6m 12s
/parquet/minio/s3 OK 6m 12s
/parquet/minio/s3/compression type OK 6m 12s
/parquet/minio/s3/compression type/=NONE OK 6m 12s
/parquet/minio/s3/compression type/=NONE /outline OK 6m 12s
/parquet/minio/s3/compression type/=NONE /outline/engine OK 65ms
/parquet/minio/s3/compression type/=GZIP OK 6m 12s
/parquet/minio/s3/compression type/=GZIP /outline OK 6m 12s
/parquet/minio/s3/compression type/=GZIP /outline/engine OK 157ms
/parquet/minio/s3/compression type/=LZ4 OK 6m 12s
/parquet/minio/s3/compression type/=LZ4 /outline OK 6m 12s
/parquet/minio/s3/compression type/=LZ4 /outline/engine OK 65ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine Skip 2ms
/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 1ms
/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/=LZ4 /outline/engine/select from engine Skip 2ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/engine to file to engine Skip 1ms
/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 1ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine from file Skip 16ms
/parquet/minio/s3/compression type/=LZ4 /outline/engine/engine select output to file Skip 16ms
/parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine from file Skip 17ms
/parquet/minio/s3/compression type/=NONE /outline/engine/engine select output to file Skip 18ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine from file Skip 19ms
/parquet/minio/s3/compression type/=GZIP /outline/engine/engine select output to file Skip 19ms
/parquet/minio/s3/compression type/=NONE /outline/function OK 6m 12s
/parquet/minio/s3/compression type/=NONE /outline/function/insert into function OK 6m 12s
/parquet/minio/s3/compression type/=LZ4 /outline/function OK 6m 12s
/parquet/minio/s3/compression type/=LZ4 /outline/function/insert into function OK 6m 12s
/parquet/minio/s3/compression type/=NONE /outline/function/select from function manual cast types OK 5m 49s
/parquet/minio/s3/compression type/=LZ4 /outline/function/select from function manual cast types OK 5m 48s
/parquet/minio/s3/compression type/=NONE /outline/function/select from function auto cast types OK 5m 19s
/parquet/minio/s3/compression type/=LZ4 /outline/function/select from function auto cast types OK 5m 20s
/parquet/minio/s3/compression type/=GZIP /outline/function OK 6m 11s
/parquet/minio/s3/compression type/=GZIP /outline/function/insert into function OK 6m 11s
/parquet/minio/s3/compression type/=GZIP /outline/function/select from function manual cast types OK 5m 48s
/parquet/minio/s3/compression type/=GZIP /outline/function/select from function auto cast types OK 5m 19s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922