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 02, 2025 16:39
Duration50m 20s
Framework TestFlows 2.0.250110.1002922

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/PRs/711/b4ea76ee0ee067975b3943ba13d654c5832bbe7c/package_aarch64/clickhouse-common-static_24.12.2.20224.altinityantalya_arm64.deb
version24.12.2.20224.altinityantalya
user.namearthurpassos
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashbd31e738c0cedaca253d15a05ed245c41b6e0b6a
job.nameParquet
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/14221757734
archaarch64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/PRs/711/b4ea76ee0ee067975b3943ba13d654c5832bbe7c/package_aarch64/clickhouse-common-static_24.12.2.20224.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
42
376983
14
6
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engineXFail 35s 587ms
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 38s 654ms
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 36s 610ms
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 15s 93ms
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.20224.altinityantalya (altinity build))
(query: INSERT INTO table_c79ce4e3_0fe4_11f0_b7b2_960004307126 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 471ms
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 114ms
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_c2cd68a0_0fe5_11f0_83cb_960004307126
            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 50m 20s
/parquet/file OK 30m 23s
/parquet/file/engine OK 30m 23s
/parquet/file/function OK 15m 51s
/parquet/file/engine/insert into engine OK 19m 16s
/parquet/file/engine/select from engine OK 9m 38s
/parquet/file/function/insert into function manual cast types OK 15m 28s
/parquet/query OK 41m 2s
/parquet/file/engine/engine to file to engine OK 26m 15s
/parquet/file/function/insert into function auto cast types OK 15m 50s
/parquet/file/function/select from function manual cast types OK 15m 19s
/parquet/file/engine/insert into engine from file OK 18m 42s
/parquet/file/function/select from function auto cast types OK 9m 30s
/parquet/file/engine/engine select output to file OK 30m 23s
/parquet/query/compression type OK 41m 2s
/parquet/list in multiple chunks OK 59s 436ms
/parquet/url OK 31m 21s
/parquet/query/compression type/=NONE OK 41m 2s
/parquet/query/compression type/=GZIP OK 41m 1s
/parquet/query/compression type/=LZ4 OK 41m 1s
/parquet/query/compression type/=NONE /insert into memory table from file OK 9m 6s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 9m 6s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 9m 8s
/parquet/url/engine OK 30m 28s
/parquet/url/function OK 30m 2s
/parquet/url/engine/insert into engine OK 19m 32s
/parquet/url/function/insert into function OK 15m 9s
/parquet/url/function/select from function manual cast types OK 30m 2s
/parquet/url/function/select from function auto cast types OK 14m 56s
/parquet/url/engine/select from engine OK 9m 13s
/parquet/url/engine/engine to file to engine OK 26m 12s
/parquet/url/engine/insert into engine from file OK 25m 21s
/parquet/url/engine/engine select output to file OK 30m 28s
/parquet/mysql OK 1m 51s
/parquet/mysql/compression type OK 1m 51s
/parquet/mysql/compression type/=NONE OK 1m 49s
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 1m 19s
/parquet/mysql/compression type/=GZIP OK 1m 50s
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 1m 19s
/parquet/mysql/compression type/=LZ4 OK 1m 51s
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 1m 20s
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 29s 859ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 30s 437ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 30s 711ms
/parquet/postgresql OK 1m 8s
/parquet/postgresql/compression type OK 1m 8s
/parquet/postgresql/compression type/=NONE OK 1m 4s
/parquet/postgresql/compression type/=GZIP OK 1m 8s
/parquet/postgresql/compression type/=LZ4 OK 1m 7s
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 35s 587ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 38s 654ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 36s 610ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 28s 953ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 30s 338ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 29s 503ms
/parquet/remote OK 18m 47s
/parquet/remote/compression type OK 18m 47s
/parquet/remote/compression type/=NONE OK 18m 44s
/parquet/remote/compression type/=GZIP OK 18m 47s
/parquet/remote/compression type/=LZ4 OK 18m 45s
/parquet/remote/compression type/=NONE /outline OK 18m 44s
/parquet/remote/compression type/=GZIP /outline OK 18m 47s
/parquet/remote/compression type/=LZ4 /outline OK 18m 45s
/parquet/remote/compression type/=NONE /outline/insert into function OK 6m 49s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 6m 51s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 6m 50s
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 5m 19s
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 5m 19s
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 5m 18s
/parquet/remote/compression type/=NONE /outline/select from function OK 11m 55s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 11m 55s
/parquet/remote/compression type/=GZIP /outline/select from function OK 11m 56s
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 3m 53s
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 3m 53s
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 3m 52s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 3m 19s
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 3m 17s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 3m 18s
/parquet/query/compression type/=GZIP /select from memory table into file OK 5m 16s
/parquet/query/compression type/=NONE /select from memory table into file OK 5m 16s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 5m 16s
/parquet/chunked array XFail 15s 93ms
/parquet/broken OK 405ms
/parquet/broken/file Skip 18ms
/parquet/broken/read broken bigint Skip 14ms
/parquet/broken/read broken date Skip 48ms
/parquet/broken/read broken int Skip 11ms
/parquet/broken/read broken smallint Skip 16ms
/parquet/broken/read broken timestamp ms Skip 15ms
/parquet/broken/read broken timestamp us Skip 18ms
/parquet/broken/read broken tinyint Skip 13ms
/parquet/broken/read broken ubigint Skip 18ms
/parquet/broken/read broken uint Skip 51ms
/parquet/broken/read broken usmallint Skip 16ms
/parquet/broken/read broken utinyint Skip 10ms
/parquet/broken/string Skip 24ms
/parquet/encoding OK 53s 327ms
/parquet/encoding/deltabytearray1 OK 8s 168ms
/parquet/encoding/deltabytearray2 OK 7s 585ms
/parquet/encoding/deltalengthbytearray OK 7s 485ms
/parquet/encoding/dictionary OK 7s 99ms
/parquet/encoding/plain OK 7s 315ms
/parquet/encoding/plainrlesnappy OK 8s 314ms
/parquet/encoding/rleboolean OK 7s 276ms
/parquet/compression OK 2m 34s
/parquet/compression/arrow snappy OK 7s 439ms
/parquet/compression/brotli OK 7s 78ms
/parquet/compression/gzippages OK 14s 668ms
/parquet/compression/largegzip OK 7s 397ms
/parquet/compression/lz4 hadoop OK 7s 792ms
/parquet/compression/lz4 hadoop large OK 7s 353ms
/parquet/compression/lz4 non hadoop OK 7s 256ms
/parquet/compression/lz4 raw OK 7s 212ms
/parquet/compression/lz4 raw large OK 7s 290ms
/parquet/compression/lz4pages OK 14s 943ms
/parquet/compression/nonepages OK 14s 811ms
/parquet/compression/snappypages OK 14s 975ms
/parquet/compression/snappyplain OK 7s 301ms
/parquet/compression/snappyrle OK 7s 413ms
/parquet/compression/zstd OK 7s 502ms
/parquet/compression/zstdpages OK 14s 314ms
/parquet/datatypes OK 6m 57s
/parquet/datatypes/arrowtimestamp OK 6s 859ms
/parquet/datatypes/arrowtimestampms OK 8s 324ms
/parquet/datatypes/binary OK 8s 707ms
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 3m 22s
/parquet/query/compression type/=NONE /select from mergetree table into file OK 3m 23s
/parquet/datatypes/binary string OK 6s 533ms
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 3m 21s
/parquet/datatypes/blob OK 11s 836ms
/parquet/datatypes/boolean OK 11s 164ms
/parquet/datatypes/byte array OK 6s 742ms
/parquet/datatypes/columnname OK 6s 760ms
/parquet/datatypes/columnwithnull OK 6s 850ms
/parquet/datatypes/columnwithnull2 OK 6s 679ms
/parquet/datatypes/date OK 6s 753ms
/parquet/datatypes/decimal with filter OK 6s 663ms
/parquet/datatypes/decimalvariousfilters OK 6s 658ms
/parquet/datatypes/decimalwithfilter2 OK 6s 688ms
/parquet/datatypes/enum OK 8s 373ms
/parquet/datatypes/enum2 OK 7s 170ms
/parquet/datatypes/fixed length decimal OK 6s 899ms
/parquet/datatypes/fixed length decimal legacy OK 6s 978ms
/parquet/datatypes/fixedstring OK 6s 787ms
/parquet/datatypes/float16 XFail 471ms
/parquet/datatypes/h2oai OK 6s 929ms
/parquet/datatypes/hive OK 13s 547ms
/parquet/datatypes/int32 OK 6s 702ms
/parquet/datatypes/int32 decimal OK 6s 571ms
/parquet/datatypes/int64 OK 6s 642ms
/parquet/datatypes/int64 decimal OK 6s 695ms
/parquet/datatypes/json OK 6s 684ms
/parquet/datatypes/large string map XFail 7s 114ms
/parquet/datatypes/largedouble OK 6s 917ms
/parquet/datatypes/manydatatypes OK 6s 681ms
/parquet/datatypes/manydatatypes2 OK 7s 274ms
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 3m 4s
/parquet/datatypes/maps OK 6s 511ms
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 3m 1s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 3m 0s
/parquet/datatypes/nameswithemoji OK 15s 593ms
/parquet/complex OK 2m 23s
/parquet/complex/arraystring OK 15s 553ms
/parquet/datatypes/nandouble OK 6s 481ms
/parquet/complex/big tuple with nulls OK 6s 794ms
/parquet/datatypes/negativeint64 OK 7s 713ms
/parquet/complex/bytearraydictionary OK 7s 529ms
/parquet/datatypes/nullbyte OK 6s 570ms
/parquet/complex/complex null OK 6s 596ms
/parquet/datatypes/nullbytemultiple OK 6s 530ms
/parquet/complex/lagemap OK 6s 479ms
/parquet/datatypes/nullsinid OK 6s 494ms
/parquet/complex/largenestedarray OK 6s 389ms
/parquet/datatypes/pandasdecimal OK 6s 437ms
/parquet/complex/largestruct OK 6s 613ms
/parquet/datatypes/pandasdecimaldate OK 7s 309ms
/parquet/complex/largestruct2 OK 7s 292ms
/parquet/cache OK 14s 810ms
/parquet/cache/cache1 OK 8s 254ms
/parquet/datatypes/parquetgo OK 6s 442ms
/parquet/complex/largestruct3 OK 6s 347ms
/parquet/cache/cache2 OK 6s 546ms
/parquet/datatypes/selectdatewithfilter OK 18s 91ms
/parquet/complex/list OK 6s 694ms
/parquet/glob OK 45s 483ms
/parquet/glob/fastparquet globs OK 7s 952ms
/parquet/complex/nested array OK 6s 769ms
/parquet/glob/glob1 OK 2s 507ms
/parquet/complex/nested map OK 6s 667ms
/parquet/glob/glob2 OK 3s 177ms
/parquet/glob/glob with multiple elements OK 779ms
/parquet/glob/million extensions OK 31s 52ms
/parquet/datatypes/singlenull OK 8s 62ms
/parquet/complex/nestedallcomplex OK 7s 572ms
/parquet/datatypes/sparkv21 OK 6s 470ms
/parquet/complex/nestedarray2 OK 6s 510ms
/parquet/datatypes/sparkv22 OK 6s 481ms
/parquet/complex/nestedstruct OK 6s 539ms
/parquet/datatypes/statdecimal OK 6s 532ms
/parquet/complex/nestedstruct2 OK 6s 660ms
/parquet/datatypes/string OK 6s 599ms
/parquet/complex/nestedstruct3 OK 6s 748ms
/parquet/rowgroups OK 13s 279ms
/parquet/rowgroups/manyrowgroups OK 6s 749ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 11s 51ms
/parquet/complex/nestedstruct4 OK 6s 742ms
/parquet/rowgroups/manyrowgroups2 OK 6s 528ms
/parquet/complex/tupleofnulls OK 6s 590ms
/parquet/encrypted Skip 1ms
/parquet/fastparquet OK 14ms
/parquet/fastparquet/airlines Skip 3ms
/parquet/fastparquet/baz Skip 1ms
/parquet/fastparquet/empty date Skip 1ms
/parquet/fastparquet/evo Skip 1ms
/parquet/fastparquet/fastparquet Skip 1ms
/parquet/read and write OK 13m 27s
/parquet/read and write/read and write parquet file OK 13m 27s
/parquet/datatypes/stringtypes OK 6s 838ms
/parquet/complex/tuplewithdatetime OK 6s 482ms
/parquet/datatypes/struct OK 6s 695ms
/parquet/column related errors OK 2s 11ms
/parquet/column related errors/check error with 500 columns OK 2s 10ms
/parquet/multi chunk upload Skip 2ms
/parquet/datatypes/supporteduuid OK 6s 535ms
/parquet/datatypes/timestamp1 OK 6s 402ms
/parquet/datatypes/timestamp2 OK 6s 618ms
/parquet/datatypes/timezone OK 6s 285ms
/parquet/datatypes/unsigned OK 12s 990ms
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 3m 31s
/parquet/query/compression type/=NONE /select from distributed table into file OK 3m 32s
/parquet/query/compression type/=GZIP /select from distributed table into file OK 3m 31s
/parquet/datatypes/unsupportednull OK 132ms
/parquet/query/compression type/=LZ4 /select from mat view into file OK 2m 50s
/parquet/query/compression type/=NONE /select from mat view into file OK 2m 50s
/parquet/query/compression type/=GZIP /select from mat view into file OK 2m 48s
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 1m 20s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 1m 20s
/parquet/query/compression type/=NONE /insert into table with projection from file OK 1m 20s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922