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

DateJul 13, 2025 0:03
Duration35m 35s
Framework TestFlows 2.0.250110.1002922

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/25.3/143c05fcd433555c6563408d8c622fb757f91dfe/package_release/clickhouse-common-static_25.3.3.20186.altinityantalya_amd64.deb
version25.3.3.20186.altinityantalya
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash88c93f843cd48cd9defc6cec6b98d6b98f94adde
job.nameParquet
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/16242745619
archx86_64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/25.3/143c05fcd433555c6563408d8c622fb757f91dfe/package_release/clickhouse-common-static_25.3.3.20186.altinityantalya_amd64.deb
as_binaryFalse
base_osNone
keeper_pathNone
zookeeper_versionNone
use_keeperFalse
stressFalse
collect_service_logsTrue
thread_fuzzerFalse
with_analyzerTrue
reuse_envFalse
storagesNone
minio_uriSecret(name='minio_uri')
minio_root_userSecret(name='minio_root_user')
minio_root_passwordSecret(name='minio_root_password')
aws_s3_bucketNone
aws_s3_regionSecret(name='aws_s3_region')
aws_s3_key_idSecret(name='aws_s3_key_id')
aws_s3_access_keySecret(name='aws_s3_access_key')
gcs_uriNone
gcs_key_idNone
gcs_key_secretNone
azure_account_nameNone
azure_storage_keyNone
azure_containerNone
native_parquet_readerFalse
stress_bloomFalse

Summary

100%OK
<1%Known

Statistics

Units Skip OK Fail XFail
Modules
1
1
Suites
2
2
Features
39
2
36
1
Scenarios
217
18
194
5
Checks
59674
59674
Examples
12
12
Steps
379204
37
377023
14
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engineXFail 13s 700ms
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 15s 300ms
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 11s 784ms
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/chunked arrayXFail 25s 104ms
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.20186.altinityantalya (altinity build))
(query: INSERT INTO table_5801a17a_5f7f_11f0_99c9_9200062cc2a6 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 532ms
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 8s 560ms
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_9f033fa9_5f7f_11f0_859f_9200062cc2a6
            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 35m 35s
/parquet/file OK 20m 56s
/parquet/query OK 28m 8s
/parquet/list in multiple chunks OK 20s 478ms
/parquet/url OK 21m 55s
/parquet/query/compression type OK 28m 8s
/parquet/query/compression type/=NONE OK 28m 8s
/parquet/file/engine OK 20m 56s
/parquet/query/compression type/=GZIP OK 28m 8s
/parquet/file/function OK 10m 1s
/parquet/query/compression type/=LZ4 OK 28m 7s
/parquet/query/compression type/=NONE /insert into memory table from file OK 5m 27s
/parquet/file/engine/insert into engine OK 12m 36s
/parquet/file/engine/select from engine OK 5m 39s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 5m 27s
/parquet/file/engine/engine to file to engine OK 17m 43s
/parquet/file/engine/insert into engine from file OK 12m 12s
/parquet/file/function/insert into function manual cast types OK 9m 39s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 5m 28s
/parquet/file/engine/engine select output to file OK 20m 56s
/parquet/file/function/insert into function auto cast types OK 10m 1s
/parquet/file/function/select from function manual cast types OK 6m 5s
/parquet/file/function/select from function auto cast types OK 5m 39s
/parquet/url/engine OK 21m 16s
/parquet/url/function OK 10m 32s
/parquet/url/engine/insert into engine OK 12m 54s
/parquet/url/engine/select from engine OK 5m 37s
/parquet/url/function/insert into function OK 9m 40s
/parquet/url/engine/engine to file to engine OK 17m 53s
/parquet/url/function/select from function manual cast types OK 10m 32s
/parquet/url/function/select from function auto cast types OK 9m 26s
/parquet/url/engine/insert into engine from file OK 17m 14s
/parquet/url/engine/engine select output to file OK 21m 16s
/parquet/mysql OK 35s 591ms
/parquet/mysql/compression type OK 35s 567ms
/parquet/mysql/compression type/=NONE OK 35s 255ms
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 20s 676ms
/parquet/mysql/compression type/=GZIP OK 35s 532ms
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 20s 672ms
/parquet/mysql/compression type/=LZ4 OK 35s 477ms
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 20s 712ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 14s 820ms
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 14s 460ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 14s 699ms
/parquet/postgresql OK 30s 447ms
/parquet/postgresql/compression type OK 30s 409ms
/parquet/postgresql/compression type/=NONE OK 26s 195ms
/parquet/postgresql/compression type/=GZIP OK 28s 795ms
/parquet/postgresql/compression type/=LZ4 OK 30s 367ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 13s 700ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 15s 300ms
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 11s 784ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 14s 294ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 14s 972ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 14s 958ms
/parquet/remote OK 13m 33s
/parquet/remote/compression type OK 13m 32s
/parquet/remote/compression type/=NONE OK 13m 32s
/parquet/remote/compression type/=GZIP OK 13m 32s
/parquet/remote/compression type/=LZ4 OK 13m 32s
/parquet/remote/compression type/=NONE /outline OK 13m 32s
/parquet/remote/compression type/=GZIP /outline OK 13m 32s
/parquet/remote/compression type/=LZ4 /outline OK 13m 32s
/parquet/remote/compression type/=NONE /outline/insert into function OK 5m 6s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 5m 7s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 5m 6s
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 3m 43s
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 3m 44s
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 3m 43s
/parquet/remote/compression type/=NONE /outline/select from function OK 8m 26s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 8m 25s
/parquet/remote/compression type/=GZIP /outline/select from function OK 8m 24s
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 2m 48s
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 2m 48s
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 2m 47s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 2m 14s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 2m 13s
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 2m 13s
/parquet/query/compression type/=NONE /select from memory table into file OK 4m 0s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 4m 0s
/parquet/query/compression type/=GZIP /select from memory table into file OK 4m 0s
/parquet/chunked array XFail 25s 104ms
/parquet/broken OK 241ms
/parquet/broken/file Skip 9ms
/parquet/broken/read broken bigint Skip 14ms
/parquet/broken/read broken date Skip 16ms
/parquet/broken/read broken int Skip 8ms
/parquet/broken/read broken smallint Skip 4ms
/parquet/broken/read broken timestamp ms Skip 8ms
/parquet/broken/read broken timestamp us Skip 45ms
/parquet/broken/read broken tinyint Skip 8ms
/parquet/broken/read broken ubigint Skip 17ms
/parquet/broken/read broken uint Skip 8ms
/parquet/broken/read broken usmallint Skip 6ms
/parquet/broken/read broken utinyint Skip 10ms
/parquet/broken/string Skip 8ms
/parquet/encoding OK 13s 16ms
/parquet/encoding/deltabytearray1 OK 2s 361ms
/parquet/encoding/deltabytearray2 OK 1s 684ms
/parquet/encoding/deltalengthbytearray OK 1s 648ms
/parquet/encoding/dictionary OK 1s 672ms
/parquet/encoding/plain OK 1s 406ms
/parquet/encoding/plainrlesnappy OK 2s 370ms
/parquet/encoding/rleboolean OK 1s 783ms
/parquet/compression OK 34s 942ms
/parquet/compression/arrow snappy OK 1s 601ms
/parquet/compression/brotli OK 1s 667ms
/parquet/compression/gzippages OK 3s 214ms
/parquet/compression/largegzip OK 1s 726ms
/parquet/compression/lz4 hadoop OK 1s 668ms
/parquet/compression/lz4 hadoop large OK 1s 635ms
/parquet/compression/lz4 non hadoop OK 1s 705ms
/parquet/compression/lz4 raw OK 1s 622ms
/parquet/compression/lz4 raw large OK 1s 638ms
/parquet/compression/lz4pages OK 3s 395ms
/parquet/compression/nonepages OK 3s 345ms
/parquet/compression/snappypages OK 3s 458ms
/parquet/compression/snappyplain OK 1s 519ms
/parquet/compression/snappyrle OK 1s 837ms
/parquet/compression/zstd OK 1s 601ms
/parquet/compression/zstdpages OK 3s 220ms
/parquet/datatypes OK 2m 5s
/parquet/datatypes/arrowtimestamp OK 1s 487ms
/parquet/datatypes/arrowtimestampms OK 1s 524ms
/parquet/datatypes/binary OK 1s 703ms
/parquet/datatypes/binary string OK 1s 548ms
/parquet/datatypes/blob OK 1s 768ms
/parquet/datatypes/boolean OK 1s 545ms
/parquet/datatypes/byte array OK 1s 768ms
/parquet/datatypes/columnname OK 1s 571ms
/parquet/datatypes/columnwithnull OK 1s 805ms
/parquet/datatypes/columnwithnull2 OK 1s 657ms
/parquet/datatypes/date OK 1s 744ms
/parquet/datatypes/decimal with filter OK 1s 630ms
/parquet/datatypes/decimalvariousfilters OK 1s 635ms
/parquet/datatypes/decimalwithfilter2 OK 1s 750ms
/parquet/datatypes/enum OK 1s 947ms
/parquet/datatypes/enum2 OK 1s 710ms
/parquet/datatypes/fixed length decimal OK 1s 608ms
/parquet/datatypes/fixed length decimal legacy OK 1s 693ms
/parquet/datatypes/fixedstring OK 1s 514ms
/parquet/datatypes/float16 XFail 532ms
/parquet/datatypes/h2oai OK 1s 764ms
/parquet/datatypes/hive OK 3s 375ms
/parquet/datatypes/int32 OK 1s 613ms
/parquet/datatypes/int32 decimal OK 1s 810ms
/parquet/datatypes/int64 OK 1s 495ms
/parquet/datatypes/int64 decimal OK 1s 725ms
/parquet/datatypes/json OK 1s 624ms
/parquet/datatypes/large string map XFail 8s 560ms
/parquet/datatypes/largedouble OK 1s 980ms
/parquet/datatypes/manydatatypes OK 1s 709ms
/parquet/datatypes/manydatatypes2 OK 2s 151ms
/parquet/datatypes/maps OK 1s 725ms
/parquet/datatypes/nameswithemoji OK 1s 590ms
/parquet/datatypes/nandouble OK 1s 833ms
/parquet/datatypes/negativeint64 OK 2s 244ms
/parquet/datatypes/nullbyte OK 1s 704ms
/parquet/datatypes/nullbytemultiple OK 1s 473ms
/parquet/datatypes/nullsinid OK 1s 850ms
/parquet/datatypes/pandasdecimal OK 1s 578ms
/parquet/datatypes/pandasdecimaldate OK 1s 645ms
/parquet/datatypes/parquetgo OK 1s 599ms
/parquet/datatypes/selectdatewithfilter OK 22s 803ms
/parquet/datatypes/singlenull OK 1s 391ms
/parquet/datatypes/sparkv21 OK 1s 626ms
/parquet/datatypes/sparkv22 OK 1s 435ms
/parquet/datatypes/statdecimal OK 1s 122ms
/parquet/datatypes/string OK 1s 617ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 9s 487ms
/parquet/datatypes/stringtypes OK 1s 8ms
/parquet/datatypes/struct OK 1s 530ms
/parquet/datatypes/supporteduuid OK 1s 159ms
/parquet/datatypes/timestamp1 OK 1s 602ms
/parquet/query/compression type/=NONE /select from mergetree table into file OK 2m 36s
/parquet/datatypes/timestamp2 OK 838ms
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 2m 36s
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 2m 36s
/parquet/datatypes/timezone OK 814ms
/parquet/datatypes/unsigned OK 1s 923ms
/parquet/datatypes/unsupportednull OK 135ms
/parquet/complex OK 25s 632ms
/parquet/complex/arraystring OK 972ms
/parquet/complex/big tuple with nulls OK 2s 427ms
/parquet/complex/bytearraydictionary OK 1s 493ms
/parquet/complex/complex null OK 1s 134ms
/parquet/complex/lagemap OK 1s 102ms
/parquet/complex/largenestedarray OK 1s 201ms
/parquet/complex/largestruct OK 1s 169ms
/parquet/complex/largestruct2 OK 1s 469ms
/parquet/complex/largestruct3 OK 1s 51ms
/parquet/complex/list OK 990ms
/parquet/complex/nested array OK 1s 128ms
/parquet/complex/nested map OK 1s 147ms
/parquet/complex/nestedallcomplex OK 1s 599ms
/parquet/complex/nestedarray2 OK 1s 426ms
/parquet/complex/nestedstruct OK 1s 186ms
/parquet/complex/nestedstruct2 OK 1s 246ms
/parquet/complex/nestedstruct3 OK 1s 297ms
/parquet/complex/nestedstruct4 OK 1s 522ms
/parquet/complex/tupleofnulls OK 1s 166ms
/parquet/complex/tuplewithdatetime OK 846ms
/parquet/cache OK 2s 378ms
/parquet/cache/cache1 OK 1s 12ms
/parquet/cache/cache2 OK 1s 360ms
/parquet/glob OK 32s 413ms
/parquet/glob/fastparquet globs OK 1s 686ms
/parquet/glob/glob1 OK 1s 486ms
/parquet/glob/glob2 OK 1s 903ms
/parquet/glob/glob with multiple elements OK 361ms
/parquet/glob/million extensions OK 26s 971ms
/parquet/rowgroups OK 2s 632ms
/parquet/rowgroups/manyrowgroups OK 1s 307ms
/parquet/rowgroups/manyrowgroups2 OK 1s 320ms
/parquet/encrypted Skip 10ms
/parquet/fastparquet OK 44ms
/parquet/fastparquet/airlines Skip 4ms
/parquet/fastparquet/baz Skip 2ms
/parquet/fastparquet/empty date Skip 4ms
/parquet/fastparquet/evo Skip 4ms
/parquet/fastparquet/fastparquet Skip 5ms
/parquet/read and write OK 12m 25s
/parquet/read and write/read and write parquet file OK 12m 25s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 2m 9s
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 2m 10s
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 2m 9s
/parquet/column related errors OK 1s 569ms
/parquet/column related errors/check error with 500 columns OK 1s 568ms
/parquet/multi chunk upload Skip 2ms
/parquet/query/compression type/=NONE /select from distributed table into file OK 2m 24s
/parquet/query/compression type/=GZIP /select from distributed table into file OK 2m 25s
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 2m 23s
/parquet/query/compression type/=NONE /select from mat view into file OK 2m 1s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 2m 0s
/parquet/query/compression type/=GZIP /select from mat view into file OK 2m 0s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 42s 4ms
/parquet/query/compression type/=NONE /insert into table with projection from file OK 41s 660ms
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 41s 447ms

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922