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 01, 2025 22:12
Duration49m 59s
Framework TestFlows 2.0.250110.1002922

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/PRs/708/12fb72fa077bd3f529f48fabb290d280d46348de/package_aarch64/clickhouse-common-static_24.12.2.20221.altinityantalya_arm64.deb
version24.12.2.20221.altinityantalya
user.nameianton-ru
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashbd31e738c0cedaca253d15a05ed245c41b6e0b6a
job.nameParquet
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/14205957338
archaarch64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/PRs/708/12fb72fa077bd3f529f48fabb290d280d46348de/package_aarch64/clickhouse-common-static_24.12.2.20221.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
379187
40
376997
14
6
2130

Known Fails

Test NameResultMessage
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engineXFail 37s 645ms
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 37s 973ms
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 295ms
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 193ms
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.20221.altinityantalya (altinity build))
(query: INSERT INTO table_1714866c_0f4a_11f0_9d5c_9600042fe642 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 457ms
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 32ms
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_1052925e_0f4b_11f0_adc5_9600042fe642
            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 49m 59s
/parquet/file OK 30m 17s
/parquet/file/engine OK 30m 17s
/parquet/file/function OK 15m 39s
/parquet/file/engine/insert into engine OK 19m 5s
/parquet/file/function/insert into function manual cast types OK 15m 13s
/parquet/query OK 40m 42s
/parquet/query/compression type OK 40m 42s
/parquet/file/engine/select from engine OK 9m 18s
/parquet/query/compression type/=NONE OK 40m 42s
/parquet/query/compression type/=NONE /insert into memory table from file OK 8m 56s
/parquet/file/function/insert into function auto cast types OK 15m 39s
/parquet/file/function/select from function manual cast types OK 14m 59s
/parquet/query/compression type/=GZIP OK 40m 42s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 8m 52s
/parquet/file/engine/engine to file to engine OK 26m 3s
/parquet/query/compression type/=LZ4 OK 40m 42s
/parquet/file/function/select from function auto cast types OK 9m 17s
/parquet/file/engine/engine select output to file OK 30m 17s
/parquet/list in multiple chunks OK 1m 15s
/parquet/url OK 31m 6s
/parquet/file/engine/insert into engine from file OK 18m 28s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 8m 52s
/parquet/url/engine OK 30m 15s
/parquet/url/function OK 29m 43s
/parquet/url/engine/insert into engine OK 19m 16s
/parquet/url/engine/select from engine OK 9m 9s
/parquet/url/function/insert into function OK 14m 54s
/parquet/url/function/select from function manual cast types OK 29m 43s
/parquet/url/function/select from function auto cast types OK 14m 36s
/parquet/url/engine/engine to file to engine OK 25m 56s
/parquet/url/engine/insert into engine from file OK 25m 6s
/parquet/url/engine/engine select output to file OK 30m 14s
/parquet/mysql OK 1m 32s
/parquet/mysql/compression type OK 1m 32s
/parquet/mysql/compression type/=NONE OK 1m 31s
/parquet/mysql/compression type/=GZIP OK 1m 32s
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 1m 1s
/parquet/mysql/compression type/=LZ4 OK 1m 32s
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 1m 1s
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 1m 1s
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 29s 761ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 30s 700ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 31s 3ms
/parquet/postgresql OK 1m 10s
/parquet/postgresql/compression type OK 1m 10s
/parquet/postgresql/compression type/=NONE OK 1m 9s
/parquet/postgresql/compression type/=GZIP OK 1m 9s
/parquet/postgresql/compression type/=LZ4 OK 1m 7s
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 37s 645ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 37s 973ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 36s 295ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 30s 983ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 31s 914ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 31s 816ms
/parquet/remote OK 18m 33s
/parquet/remote/compression type OK 18m 33s
/parquet/remote/compression type/=NONE OK 18m 33s
/parquet/remote/compression type/=GZIP OK 18m 32s
/parquet/remote/compression type/=LZ4 OK 18m 33s
/parquet/remote/compression type/=LZ4 /outline OK 18m 32s
/parquet/remote/compression type/=GZIP /outline OK 18m 32s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 6m 41s
/parquet/remote/compression type/=NONE /outline OK 18m 33s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 6m 43s
/parquet/remote/compression type/=NONE /outline/insert into function OK 6m 40s
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 5m 17s
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 5m 19s
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 5m 15s
/parquet/remote/compression type/=NONE /outline/select from function OK 11m 52s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 11m 51s
/parquet/remote/compression type/=GZIP /outline/select from function OK 11m 48s
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 3m 55s
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 3m 54s
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 3m 53s
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 3m 18s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 3m 18s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 3m 17s
/parquet/query/compression type/=GZIP /select from memory table into file OK 5m 15s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 5m 16s
/parquet/query/compression type/=NONE /select from memory table into file OK 5m 16s
/parquet/chunked array XFail 15s 193ms
/parquet/broken OK 401ms
/parquet/broken/file Skip 15ms
/parquet/broken/read broken bigint Skip 27ms
/parquet/broken/read broken date Skip 15ms
/parquet/broken/read broken int Skip 19ms
/parquet/broken/read broken smallint Skip 8ms
/parquet/broken/read broken timestamp ms Skip 11ms
/parquet/broken/read broken timestamp us Skip 16ms
/parquet/broken/read broken tinyint Skip 17ms
/parquet/broken/read broken ubigint Skip 23ms
/parquet/broken/read broken uint Skip 19ms
/parquet/broken/read broken usmallint Skip 54ms
/parquet/broken/read broken utinyint Skip 12ms
/parquet/broken/string Skip 16ms
/parquet/encoding OK 52s 375ms
/parquet/encoding/deltabytearray1 OK 7s 773ms
/parquet/encoding/deltabytearray2 OK 7s 117ms
/parquet/encoding/deltalengthbytearray OK 7s 282ms
/parquet/encoding/dictionary OK 7s 70ms
/parquet/encoding/plain OK 7s 290ms
/parquet/encoding/plainrlesnappy OK 8s 301ms
/parquet/encoding/rleboolean OK 7s 471ms
/parquet/compression OK 2m 32s
/parquet/compression/arrow snappy OK 7s 295ms
/parquet/compression/brotli OK 7s 376ms
/parquet/compression/gzippages OK 14s 791ms
/parquet/compression/largegzip OK 7s 474ms
/parquet/compression/lz4 hadoop OK 7s 321ms
/parquet/compression/lz4 hadoop large OK 7s 226ms
/parquet/compression/lz4 non hadoop OK 7s 586ms
/parquet/compression/lz4 raw OK 7s 230ms
/parquet/compression/lz4 raw large OK 7s 412ms
/parquet/compression/lz4pages OK 14s 402ms
/parquet/compression/nonepages OK 14s 524ms
/parquet/compression/snappypages OK 14s 424ms
/parquet/compression/snappyplain OK 7s 38ms
/parquet/compression/snappyrle OK 7s 179ms
/parquet/compression/zstd OK 7s 213ms
/parquet/compression/zstdpages OK 14s 120ms
/parquet/datatypes OK 6m 47s
/parquet/datatypes/arrowtimestamp OK 7s 364ms
/parquet/datatypes/arrowtimestampms OK 6s 703ms
/parquet/datatypes/binary OK 12s 733ms
/parquet/datatypes/binary string OK 6s 515ms
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 3m 20s
/parquet/query/compression type/=NONE /select from mergetree table into file OK 3m 20s
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 3m 19s
/parquet/datatypes/blob OK 9s 118ms
/parquet/datatypes/boolean OK 11s 314ms
/parquet/datatypes/byte array OK 6s 845ms
/parquet/datatypes/columnname OK 6s 909ms
/parquet/datatypes/columnwithnull OK 6s 633ms
/parquet/datatypes/columnwithnull2 OK 6s 787ms
/parquet/datatypes/date OK 6s 808ms
/parquet/datatypes/decimal with filter OK 7s 16ms
/parquet/datatypes/decimalvariousfilters OK 6s 786ms
/parquet/datatypes/decimalwithfilter2 OK 6s 944ms
/parquet/datatypes/enum OK 6s 839ms
/parquet/datatypes/enum2 OK 6s 912ms
/parquet/datatypes/fixed length decimal OK 6s 770ms
/parquet/datatypes/fixed length decimal legacy OK 6s 704ms
/parquet/datatypes/fixedstring OK 6s 678ms
/parquet/datatypes/float16 XFail 457ms
/parquet/datatypes/h2oai OK 6s 916ms
/parquet/datatypes/hive OK 13s 232ms
/parquet/datatypes/int32 OK 6s 868ms
/parquet/datatypes/int32 decimal OK 6s 826ms
/parquet/datatypes/int64 OK 6s 939ms
/parquet/datatypes/int64 decimal OK 6s 875ms
/parquet/datatypes/json OK 6s 856ms
/parquet/datatypes/large string map XFail 7s 32ms
/parquet/datatypes/largedouble OK 7s 0ms
/parquet/datatypes/manydatatypes OK 6s 564ms
/parquet/datatypes/manydatatypes2 OK 6s 901ms
/parquet/datatypes/maps OK 6s 458ms
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 3m 0s
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 3m 1s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 2m 58s
/parquet/datatypes/nameswithemoji OK 6s 465ms
/parquet/datatypes/nandouble OK 11s 865ms
/parquet/complex OK 2m 19s
/parquet/complex/arraystring OK 9s 808ms
/parquet/datatypes/negativeint64 OK 6s 774ms
/parquet/complex/big tuple with nulls OK 6s 664ms
/parquet/datatypes/nullbyte OK 8s 334ms
/parquet/complex/bytearraydictionary OK 8s 328ms
/parquet/datatypes/nullbytemultiple OK 6s 426ms
/parquet/complex/complex null OK 6s 357ms
/parquet/datatypes/nullsinid OK 6s 377ms
/parquet/complex/lagemap OK 6s 653ms
/parquet/datatypes/pandasdecimal OK 6s 647ms
/parquet/complex/largenestedarray OK 6s 543ms
/parquet/datatypes/pandasdecimaldate OK 6s 498ms
/parquet/complex/largestruct OK 6s 955ms
/parquet/datatypes/parquetgo OK 6s 874ms
/parquet/cache OK 17s 866ms
/parquet/cache/cache1 OK 9s 856ms
/parquet/complex/largestruct2 OK 8s 309ms
/parquet/datatypes/selectdatewithfilter OK 12s 941ms
/parquet/cache/cache2 OK 7s 997ms
/parquet/complex/largestruct3 OK 7s 877ms
/parquet/datatypes/singlenull OK 6s 565ms
/parquet/complex/list OK 6s 656ms
/parquet/glob OK 35s 320ms
/parquet/glob/fastparquet globs OK 1s 385ms
/parquet/glob/glob1 OK 1s 431ms
/parquet/glob/glob2 OK 1s 695ms
/parquet/glob/glob with multiple elements OK 345ms
/parquet/glob/million extensions OK 30s 455ms
/parquet/datatypes/sparkv21 OK 6s 594ms
/parquet/complex/nested array OK 6s 446ms
/parquet/datatypes/sparkv22 OK 6s 446ms
/parquet/complex/nested map OK 6s 396ms
/parquet/datatypes/statdecimal OK 6s 459ms
/parquet/complex/nestedallcomplex OK 6s 709ms
/parquet/datatypes/string OK 6s 430ms
/parquet/complex/nestedarray2 OK 6s 426ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 12s 179ms
/parquet/complex/nestedstruct OK 6s 310ms
/parquet/rowgroups OK 12s 929ms
/parquet/rowgroups/manyrowgroups OK 6s 548ms
/parquet/complex/nestedstruct2 OK 6s 453ms
/parquet/rowgroups/manyrowgroups2 OK 6s 377ms
/parquet/datatypes/stringtypes OK 6s 438ms
/parquet/complex/nestedstruct3 OK 6s 466ms
/parquet/encrypted Skip 1ms
/parquet/fastparquet OK 47ms
/parquet/fastparquet/airlines Skip 29ms
/parquet/fastparquet/baz Skip 1ms
/parquet/fastparquet/empty date Skip 1ms
/parquet/fastparquet/evo Skip 1ms
/parquet/fastparquet/fastparquet Skip 4ms
/parquet/read and write OK 13m 26s
/parquet/read and write/read and write parquet file OK 13m 26s
/parquet/datatypes/struct OK 6s 796ms
/parquet/complex/nestedstruct4 OK 6s 794ms
/parquet/datatypes/supporteduuid OK 6s 679ms
/parquet/complex/tupleofnulls OK 6s 488ms
/parquet/datatypes/timestamp1 OK 6s 550ms
/parquet/complex/tuplewithdatetime OK 6s 362ms
/parquet/datatypes/timestamp2 OK 6s 424ms
/parquet/column related errors OK 1s 971ms
/parquet/column related errors/check error with 500 columns OK 1s 970ms
/parquet/multi chunk upload Skip 2ms
/parquet/datatypes/timezone OK 6s 462ms
/parquet/datatypes/unsigned OK 12s 703ms
/parquet/query/compression type/=NONE /select from distributed table into file OK 3m 32s
/parquet/datatypes/unsupportednull OK 114ms
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 3m 31s
/parquet/query/compression type/=GZIP /select from distributed table into file OK 3m 30s
/parquet/query/compression type/=NONE /select from mat view into file OK 2m 48s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 2m 49s
/parquet/query/compression type/=GZIP /select from mat view into file OK 2m 48s
/parquet/query/compression type/=NONE /insert into table with projection from file OK 1m 21s
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 1m 21s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 1m 20s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922