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

DateApr 03, 2025 14:17
Duration53m 42s
Framework TestFlows 2.0.250110.1002922

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#675/9d1a3c4614a11dbfe0e4063c587980b974b4ccb1/regression/aarch64/with_analyzer/zookeeper/without_thread_fuzzer/parquet/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/PRs/675/9d1a3c4614a11dbfe0e4063c587980b974b4ccb1/package_aarch64/clickhouse-common-static_24.12.2.20231.altinityantalya_arm64.deb
version24.12.2.20231.altinityantalya
user.nameianton-ru
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashbd31e738c0cedaca253d15a05ed245c41b6e0b6a
job.nameParquet
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/14243842779
archaarch64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/PRs/675/9d1a3c4614a11dbfe0e4063c587980b974b4ccb1/package_aarch64/clickhouse-common-static_24.12.2.20231.altinityantalya_arm64.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 Error XFail
Modules
1
1
Suites
2
2
Features
39
2
36
1
Scenarios
217
18
194
5
Checks
59674
59674
Examples
12
12
Steps
379175
35
376990
14
6
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engineXFail 39s 745ms
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 827, in execute_query_step
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 897, 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 897 in 'execute_query'

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

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

889\|                  with values() as that:
890\|                      snapshot_result = snapshot(
891\|                          "\n" + r.output.strip() + "\n",
892\|                          id=snapshot_id,
893\|                          name=snapshot_name,
894\|                          encoder=str,
895\|                          mode=snapshot.CHECK,
896\|                      )
897\|>                     assert that(snapshot_result), error()
/parquet/chunked arrayXFail 16s 551ms
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 24.12.2.20231.altinityantalya (altinity build))
(query: INSERT INTO table_5d5d050b_109a_11f0_b11e_960004311c3d 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 403ms
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 '[-0,0,32,2052,32838,0,0,0,0,0,0]'
  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 @@
    -[-0,0,32,2052,32838,0,0,0,0,0,0]
    +[-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 765ms
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 24.12.2):
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_65037607_109b_11f0_8054_960004311c3d
            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 53m 42s
/parquet/file OK 32m 56s
/parquet/file/engine OK 32m 56s
/parquet/file/function OK 17m 16s
/parquet/file/engine/insert into engine OK 21m 2s
/parquet/file/engine/select from engine OK 10m 24s
/parquet/file/function/insert into function manual cast types OK 16m 46s
/parquet/query OK 44m 12s
/parquet/query/compression type OK 44m 12s
/parquet/file/engine/engine to file to engine OK 28m 40s
/parquet/query/compression type/=NONE OK 44m 11s
/parquet/query/compression type/=NONE /insert into memory table from file OK 9m 57s
/parquet/file/function/insert into function auto cast types OK 17m 16s
/parquet/file/engine/insert into engine from file OK 20m 26s
/parquet/query/compression type/=GZIP OK 44m 12s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 9m 55s
/parquet/query/compression type/=LZ4 OK 44m 12s
/parquet/file/engine/engine select output to file OK 32m 56s
/parquet/file/function/select from function manual cast types OK 16m 23s
/parquet/list in multiple chunks OK 1m 15s
/parquet/url OK 33m 55s
/parquet/file/function/select from function auto cast types OK 10m 22s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 9m 58s
/parquet/url/engine OK 32m 51s
/parquet/url/function OK 31m 49s
/parquet/url/engine/insert into engine OK 21m 1s
/parquet/url/function/insert into function OK 16m 21s
/parquet/url/function/select from function manual cast types OK 31m 49s
/parquet/url/function/select from function auto cast types OK 16m 0s
/parquet/url/engine/select from engine OK 10m 2s
/parquet/url/engine/engine to file to engine OK 28m 20s
/parquet/url/engine/insert into engine from file OK 27m 27s
/parquet/url/engine/engine select output to file OK 32m 51s
/parquet/mysql OK 2m 1s
/parquet/mysql/compression type OK 2m 0s
/parquet/mysql/compression type/=NONE OK 2m 0s
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 1m 27s
/parquet/mysql/compression type/=GZIP OK 2m 0s
/parquet/mysql/compression type/=LZ4 OK 1m 59s
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 1m 27s
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 1m 27s
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 33s 279ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 32s 479ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 32s 215ms
/parquet/postgresql OK 1m 13s
/parquet/postgresql/compression type OK 1m 13s
/parquet/postgresql/compression type/=NONE OK 1m 13s
/parquet/postgresql/compression type/=GZIP OK 1m 13s
/parquet/postgresql/compression type/=LZ4 OK 1m 12s
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 39s 745ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 40s 38ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 37s 837ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 34s 934ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 33s 369ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 32s 866ms
/parquet/remote OK 20m 18s
/parquet/remote/compression type OK 20m 17s
/parquet/remote/compression type/=NONE OK 20m 17s
/parquet/remote/compression type/=GZIP OK 20m 15s
/parquet/remote/compression type/=LZ4 OK 20m 11s
/parquet/remote/compression type/=GZIP /outline OK 20m 15s
/parquet/remote/compression type/=LZ4 /outline OK 20m 11s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 7m 15s
/parquet/remote/compression type/=NONE /outline OK 20m 17s
/parquet/remote/compression type/=NONE /outline/insert into function OK 7m 16s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 7m 14s
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 5m 46s
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 5m 47s
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 5m 46s
/parquet/remote/compression type/=GZIP /outline/select from function OK 13m 0s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 12m 55s
/parquet/remote/compression type/=NONE /outline/select from function OK 13m 1s
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 4m 14s
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 4m 14s
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 4m 13s
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 3m 35s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 3m 34s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 3m 33s
/parquet/query/compression type/=GZIP /select from memory table into file OK 5m 45s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 5m 46s
/parquet/query/compression type/=NONE /select from memory table into file OK 5m 45s
/parquet/chunked array XFail 16s 551ms
/parquet/broken OK 440ms
/parquet/broken/file Skip 18ms
/parquet/broken/read broken bigint Skip 32ms
/parquet/broken/read broken date Skip 48ms
/parquet/broken/read broken int Skip 11ms
/parquet/broken/read broken smallint Skip 13ms
/parquet/broken/read broken timestamp ms Skip 14ms
/parquet/broken/read broken timestamp us Skip 7ms
/parquet/broken/read broken tinyint Skip 36ms
/parquet/broken/read broken ubigint Skip 50ms
/parquet/broken/read broken uint Skip 21ms
/parquet/broken/read broken usmallint Skip 18ms
/parquet/broken/read broken utinyint Skip 15ms
/parquet/broken/string Skip 11ms
/parquet/encoding OK 56s 353ms
/parquet/encoding/deltabytearray1 OK 8s 716ms
/parquet/encoding/deltabytearray2 OK 7s 663ms
/parquet/encoding/deltalengthbytearray OK 7s 685ms
/parquet/encoding/dictionary OK 7s 793ms
/parquet/encoding/plain OK 7s 755ms
/parquet/encoding/plainrlesnappy OK 8s 615ms
/parquet/encoding/rleboolean OK 8s 64ms
/parquet/compression OK 2m 41s
/parquet/compression/arrow snappy OK 7s 623ms
/parquet/compression/brotli OK 7s 739ms
/parquet/compression/gzippages OK 15s 324ms
/parquet/compression/largegzip OK 7s 908ms
/parquet/compression/lz4 hadoop OK 7s 752ms
/parquet/compression/lz4 hadoop large OK 7s 767ms
/parquet/compression/lz4 non hadoop OK 7s 559ms
/parquet/compression/lz4 raw OK 7s 613ms
/parquet/compression/lz4 raw large OK 7s 814ms
/parquet/compression/lz4pages OK 15s 297ms
/parquet/compression/nonepages OK 15s 504ms
/parquet/compression/snappypages OK 15s 183ms
/parquet/compression/snappyplain OK 7s 608ms
/parquet/compression/snappyrle OK 7s 957ms
/parquet/compression/zstd OK 7s 589ms
/parquet/compression/zstdpages OK 14s 912ms
/parquet/datatypes OK 7m 19s
/parquet/datatypes/arrowtimestamp OK 7s 796ms
/parquet/datatypes/arrowtimestampms OK 7s 324ms
/parquet/datatypes/binary OK 10s 169ms
/parquet/datatypes/binary string OK 8s 892ms
/parquet/datatypes/blob OK 7s 224ms
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 3m 30s
/parquet/query/compression type/=NONE /select from mergetree table into file OK 3m 31s
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 3m 30s
/parquet/datatypes/boolean OK 9s 440ms
/parquet/datatypes/byte array OK 13s 188ms
/parquet/datatypes/columnname OK 7s 100ms
/parquet/datatypes/columnwithnull OK 7s 113ms
/parquet/datatypes/columnwithnull2 OK 7s 85ms
/parquet/datatypes/date OK 7s 26ms
/parquet/datatypes/decimal with filter OK 8s 337ms
/parquet/datatypes/decimalvariousfilters OK 7s 98ms
/parquet/datatypes/decimalwithfilter2 OK 7s 193ms
/parquet/datatypes/enum OK 7s 98ms
/parquet/datatypes/enum2 OK 7s 126ms
/parquet/datatypes/fixed length decimal OK 7s 411ms
/parquet/datatypes/fixed length decimal legacy OK 7s 241ms
/parquet/datatypes/fixedstring OK 7s 145ms
/parquet/datatypes/float16 XFail 403ms
/parquet/datatypes/h2oai OK 7s 69ms
/parquet/datatypes/hive OK 14s 218ms
/parquet/datatypes/int32 OK 7s 95ms
/parquet/datatypes/int32 decimal OK 7s 0ms
/parquet/datatypes/int64 OK 6s 938ms
/parquet/datatypes/int64 decimal OK 7s 18ms
/parquet/datatypes/json OK 6s 792ms
/parquet/datatypes/large string map XFail 7s 765ms
/parquet/datatypes/largedouble OK 8s 32ms
/parquet/datatypes/manydatatypes OK 7s 102ms
/parquet/datatypes/manydatatypes2 OK 6s 979ms
/parquet/datatypes/maps OK 6s 807ms
/parquet/datatypes/nameswithemoji OK 6s 538ms
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 3m 13s
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 3m 11s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 3m 12s
/parquet/datatypes/nandouble OK 15s 96ms
/parquet/complex OK 2m 29s
/parquet/complex/arraystring OK 17s 409ms
/parquet/datatypes/negativeint64 OK 9s 717ms
/parquet/complex/big tuple with nulls OK 7s 12ms
/parquet/datatypes/nullbyte OK 8s 668ms
/parquet/complex/bytearraydictionary OK 7s 897ms
/parquet/datatypes/nullbytemultiple OK 6s 688ms
/parquet/complex/complex null OK 6s 706ms
/parquet/datatypes/nullsinid OK 6s 563ms
/parquet/complex/lagemap OK 6s 668ms
/parquet/datatypes/pandasdecimal OK 6s 654ms
/parquet/complex/largenestedarray OK 6s 742ms
/parquet/datatypes/pandasdecimaldate OK 6s 787ms
/parquet/complex/largestruct OK 6s 719ms
/parquet/datatypes/parquetgo OK 7s 96ms
/parquet/complex/largestruct2 OK 7s 375ms
/parquet/cache OK 15s 942ms
/parquet/cache/cache1 OK 8s 730ms
/parquet/datatypes/selectdatewithfilter OK 20s 570ms
/parquet/complex/largestruct3 OK 7s 101ms
/parquet/cache/cache2 OK 7s 201ms
/parquet/complex/list OK 7s 86ms
/parquet/glob OK 46s 375ms
/parquet/glob/fastparquet globs OK 9s 633ms
/parquet/complex/nested array OK 6s 867ms
/parquet/glob/glob1 OK 1s 638ms
/parquet/datatypes/singlenull OK 6s 750ms
/parquet/glob/glob2 OK 1s 696ms
/parquet/complex/nested map OK 6s 835ms
/parquet/glob/glob with multiple elements OK 328ms
/parquet/glob/million extensions OK 33s 63ms
/parquet/datatypes/sparkv21 OK 6s 916ms
/parquet/complex/nestedallcomplex OK 6s 900ms
/parquet/datatypes/sparkv22 OK 6s 760ms
/parquet/complex/nestedarray2 OK 6s 951ms
/parquet/datatypes/statdecimal OK 6s 886ms
/parquet/complex/nestedstruct OK 6s 835ms
/parquet/datatypes/string OK 6s 855ms
/parquet/complex/nestedstruct2 OK 6s 825ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 11s 742ms
/parquet/rowgroups OK 13s 923ms
/parquet/rowgroups/manyrowgroups OK 7s 81ms
/parquet/complex/nestedstruct3 OK 6s 819ms
/parquet/complex/nestedstruct4 OK 7s 57ms
/parquet/rowgroups/manyrowgroups2 OK 6s 827ms
/parquet/datatypes/stringtypes OK 6s 925ms
/parquet/encrypted Skip 14ms
/parquet/fastparquet OK 72ms
/parquet/fastparquet/airlines Skip 12ms
/parquet/fastparquet/baz Skip 6ms
/parquet/fastparquet/empty date Skip 3ms
/parquet/complex/tupleofnulls OK 6s 921ms
/parquet/fastparquet/evo Skip 3ms
/parquet/fastparquet/fastparquet Skip 5ms
/parquet/read and write OK 14m 12s
/parquet/read and write/read and write parquet file OK 14m 12s
/parquet/datatypes/struct OK 6s 792ms
/parquet/complex/tuplewithdatetime OK 6s 598ms
/parquet/datatypes/supporteduuid OK 6s 794ms
/parquet/column related errors OK 2s 132ms
/parquet/column related errors/check error with 500 columns OK 2s 129ms
/parquet/multi chunk upload Skip 16ms
/parquet/datatypes/timestamp1 OK 6s 807ms
/parquet/datatypes/timestamp2 OK 6s 732ms
/parquet/datatypes/timezone OK 6s 531ms
/parquet/datatypes/unsigned OK 13s 674ms
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 3m 38s
/parquet/datatypes/unsupportednull OK 127ms
/parquet/query/compression type/=NONE /select from distributed table into file OK 3m 37s
/parquet/query/compression type/=GZIP /select from distributed table into file OK 3m 36s
/parquet/query/compression type/=GZIP /select from mat view into file OK 3m 9s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 3m 8s
/parquet/query/compression type/=NONE /select from mat view into file OK 3m 7s
/parquet/query/compression type/=NONE /insert into table with projection from file OK 1m 23s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 1m 23s
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 1m 22s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922