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 2:48
Duration1h 6m
Framework TestFlows 2.0.250110.1002922

Artifacts

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

Attributes

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

Summary

100%OK
<1%Known

Statistics

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

Known Fails

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

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

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

888\|                  with values() as that:
889\|                      snapshot_result = snapshot(
890\|                          "\n" + r.output.strip() + "\n",
891\|                          id=snapshot_id,
892\|                          name=snapshot_name,
893\|                          encoder=str,
894\|                          mode=snapshot.CHECK,
895\|                      )
896\|>                     assert that(snapshot_result), error()
/parquet/chunked arrayXFail 38s 454ms
Not supported
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/chunked_array.py", line 30, in feature
    node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Error on processing query: Code: 33. DB::Exception: Error while reading Parquet data: NotImplemented: Nested data conversions not implemented for chunked array outputs: (in file/uri /var/lib/clickhouse/user_files/chunked_array_test_file.parquet): While executing ParquetBlockInputFormat: While executing File: data for INSERT was parsed from file. (CANNOT_READ_ALL_DATA) (version 25.2.2.96963.altinityantalya.96963 (official build))
(query: INSERT INTO table_dbfdb26b_0f71_11f0_8288_9600043002c1 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 827ms
ClickHouse does not import FLOAT16 properly
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 929, in feature
    scenario()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 113, in float16
    assert output == expected, error()
           ^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert output == expected, error()

Assertion values
  assert output == expected, error()
         ^ is '[-2,-1,0,1,2,3,4,5,6,7,8]'
  assert output == expected, error()
                   ^ is '[-2,-1,0,1,2,3,4,5,6,7,8,9]'
  assert output == expected, error()
                ^ is = False
    @@ -1 +1 @@
    -[-2,-1,0,1,2,3,4,5,6,7,8]
    +[-2,-1,0,1,2,3,4,5,6,7,8,9]
  assert output == expected, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py', line 113 in 'float16'

105\|                  ORDER BY tuple() AS SELECT floatfield FROM file('{import_file}', Parquet)
106\|                  """
107\|              )
108\|  
109\|          with Then("I read the contents of the created table"):
110\|              output = node.query(
111\|                  f"SELECT groupArray(round(*)) FROM {table_name} FORMAT TSV"
112\|              ).output
113\|>             assert output == expected, error()
114\|  
115\|      finally:
116\|          with Finally("I drop the table"):
/parquet/datatypes/large string mapXFail 13s 717ms
Will fail until the, https://github.com/apache/arrow/pull/35825, gets merged.
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.12/threading.py", line 1010, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 929, in feature
    scenario()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 801, in large_string_map
    import_export(snapshot_name="large_string_map_structure", import_file=import_file)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/outline.py", line 36, in import_export
    node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 25.2.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_56e472c0_0f72_11f0_97e8_9600043002c1
            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 1h 6m
/parquet/file OK 42m 5s
/parquet/query OK 56m 12s
/parquet/list in multiple chunks OK 51s 591ms
/parquet/url OK 43m 36s
/parquet/query/compression type OK 56m 12s
/parquet/query/compression type/=NONE OK 56m 9s
/parquet/file/engine OK 42m 5s
/parquet/query/compression type/=GZIP OK 56m 12s
/parquet/file/function OK 19m 57s
/parquet/query/compression type/=LZ4 OK 56m 9s
/parquet/query/compression type/=NONE /insert into memory table from file OK 11m 3s
/parquet/query/compression type/=GZIP /insert into memory table from file OK 11m 2s
/parquet/file/engine/insert into engine OK 25m 29s
/parquet/file/engine/select from engine OK 11m 22s
/parquet/query/compression type/=LZ4 /insert into memory table from file OK 11m 3s
/parquet/file/function/insert into function manual cast types OK 19m 19s
/parquet/file/engine/engine to file to engine OK 35m 55s
/parquet/file/engine/insert into engine from file OK 24m 40s
/parquet/file/function/insert into function auto cast types OK 19m 57s
/parquet/file/function/select from function manual cast types OK 12m 14s
/parquet/file/engine/engine select output to file OK 42m 5s
/parquet/file/function/select from function auto cast types OK 11m 19s
/parquet/url/engine OK 42m 35s
/parquet/url/engine/insert into engine OK 26m 13s
/parquet/url/function OK 21m 8s
/parquet/url/engine/select from engine OK 11m 23s
/parquet/url/function/insert into function OK 19m 18s
/parquet/url/engine/engine to file to engine OK 36m 15s
/parquet/url/function/select from function auto cast types OK 19m 1s
/parquet/url/engine/insert into engine from file OK 34m 42s
/parquet/url/function/select from function manual cast types OK 21m 8s
/parquet/url/engine/engine select output to file OK 42m 35s
/parquet/mysql OK 1m 3s
/parquet/mysql/compression type OK 1m 2s
/parquet/mysql/compression type/=NONE OK 1m 2s
/parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine OK 36s 536ms
/parquet/mysql/compression type/=GZIP OK 1m 1s
/parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine OK 34s 484ms
/parquet/mysql/compression type/=LZ4 OK 1m 1s
/parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine OK 34s 709ms
/parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function OK 27s 198ms
/parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function OK 26s 902ms
/parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function OK 26s 151ms
/parquet/postgresql OK 57s 110ms
/parquet/postgresql/compression type OK 56s 967ms
/parquet/postgresql/compression type/=NONE OK 52s 389ms
/parquet/postgresql/compression type/=GZIP OK 55s 810ms
/parquet/postgresql/compression type/=LZ4 OK 56s 914ms
/parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine XFail 23s 138ms
/parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine XFail 24s 971ms
/parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine XFail 25s 395ms
/parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function OK 28s 965ms
/parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function OK 30s 534ms
/parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function OK 31s 191ms
/parquet/remote OK 27m 26s
/parquet/remote/compression type OK 27m 26s
/parquet/remote/compression type/=NONE OK 27m 25s
/parquet/remote/compression type/=GZIP OK 27m 26s
/parquet/remote/compression type/=LZ4 OK 27m 25s
/parquet/remote/compression type/=NONE /outline OK 27m 24s
/parquet/remote/compression type/=GZIP /outline OK 27m 26s
/parquet/remote/compression type/=LZ4 /outline OK 27m 25s
/parquet/remote/compression type/=NONE /outline/insert into function OK 10m 18s
/parquet/remote/compression type/=GZIP /outline/insert into function OK 10m 20s
/parquet/remote/compression type/=LZ4 /outline/insert into function OK 10m 20s
/parquet/query/compression type/=GZIP /insert into mergetree table from file OK 7m 30s
/parquet/query/compression type/=NONE /insert into mergetree table from file OK 7m 28s
/parquet/query/compression type/=LZ4 /insert into mergetree table from file OK 7m 29s
/parquet/remote/compression type/=NONE /outline/select from function OK 17m 6s
/parquet/remote/compression type/=GZIP /outline/select from function OK 17m 5s
/parquet/remote/compression type/=LZ4 /outline/select from function OK 17m 4s
/parquet/query/compression type/=NONE /insert into replicated mergetree table from file OK 5m 49s
/parquet/query/compression type/=GZIP /insert into replicated mergetree table from file OK 5m 47s
/parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file OK 5m 48s
/parquet/query/compression type/=GZIP /insert into distributed table from file OK 4m 35s
/parquet/query/compression type/=NONE /insert into distributed table from file OK 4m 33s
/parquet/query/compression type/=LZ4 /insert into distributed table from file OK 4m 34s
/parquet/query/compression type/=NONE /select from memory table into file OK 7m 57s
/parquet/query/compression type/=GZIP /select from memory table into file OK 7m 59s
/parquet/query/compression type/=LZ4 /select from memory table into file OK 7m 59s
/parquet/chunked array XFail 38s 454ms
/parquet/broken OK 668ms
/parquet/broken/file Skip 21ms
/parquet/broken/read broken bigint Skip 20ms
/parquet/broken/read broken date Skip 76ms
/parquet/broken/read broken int Skip 47ms
/parquet/broken/read broken smallint Skip 20ms
/parquet/broken/read broken timestamp ms Skip 25ms
/parquet/broken/read broken timestamp us Skip 50ms
/parquet/broken/read broken tinyint Skip 35ms
/parquet/broken/read broken ubigint Skip 25ms
/parquet/broken/read broken uint Skip 42ms
/parquet/broken/read broken usmallint Skip 20ms
/parquet/broken/read broken utinyint Skip 62ms
/parquet/broken/string Skip 31ms
/parquet/encoding OK 23s 520ms
/parquet/encoding/deltabytearray1 OK 3s 787ms
/parquet/encoding/deltabytearray2 OK 2s 902ms
/parquet/encoding/deltalengthbytearray OK 2s 781ms
/parquet/encoding/dictionary OK 3s 27ms
/parquet/encoding/plain OK 3s 38ms
/parquet/encoding/plainrlesnappy OK 4s 641ms
/parquet/encoding/rleboolean OK 3s 222ms
/parquet/compression OK 1m 2s
/parquet/compression/arrow snappy OK 3s 43ms
/parquet/compression/brotli OK 2s 896ms
/parquet/compression/gzippages OK 5s 838ms
/parquet/compression/largegzip OK 3s 369ms
/parquet/compression/lz4 hadoop OK 2s 764ms
/parquet/compression/lz4 hadoop large OK 3s 26ms
/parquet/compression/lz4 non hadoop OK 3s 61ms
/parquet/compression/lz4 raw OK 2s 950ms
/parquet/compression/lz4 raw large OK 2s 716ms
/parquet/compression/lz4pages OK 5s 871ms
/parquet/compression/nonepages OK 6s 172ms
/parquet/compression/snappypages OK 5s 656ms
/parquet/compression/snappyplain OK 2s 839ms
/parquet/compression/snappyrle OK 3s 230ms
/parquet/compression/zstd OK 2s 863ms
/parquet/compression/zstdpages OK 5s 877ms
/parquet/datatypes OK 4m 49s
/parquet/datatypes/arrowtimestamp OK 2s 870ms
/parquet/datatypes/arrowtimestampms OK 2s 664ms
/parquet/datatypes/binary OK 3s 90ms
/parquet/datatypes/binary string OK 2s 759ms
/parquet/datatypes/blob OK 2s 832ms
/parquet/datatypes/boolean OK 2s 973ms
/parquet/datatypes/byte array OK 2s 868ms
/parquet/datatypes/columnname OK 3s 137ms
/parquet/datatypes/columnwithnull OK 2s 940ms
/parquet/datatypes/columnwithnull2 OK 2s 823ms
/parquet/datatypes/date OK 2s 707ms
/parquet/datatypes/decimal with filter OK 3s 702ms
/parquet/datatypes/decimalvariousfilters OK 2s 813ms
/parquet/datatypes/decimalwithfilter2 OK 3s 18ms
/parquet/datatypes/enum OK 3s 600ms
/parquet/datatypes/enum2 OK 3s 83ms
/parquet/datatypes/fixed length decimal OK 2s 775ms
/parquet/datatypes/fixed length decimal legacy OK 2s 726ms
/parquet/datatypes/fixedstring OK 3s 86ms
/parquet/datatypes/float16 XFail 827ms
/parquet/datatypes/h2oai OK 3s 51ms
/parquet/datatypes/hive OK 5s 859ms
/parquet/datatypes/int32 OK 3s 49ms
/parquet/datatypes/int32 decimal OK 2s 781ms
/parquet/datatypes/int64 OK 2s 833ms
/parquet/datatypes/int64 decimal OK 2s 975ms
/parquet/datatypes/json OK 2s 745ms
/parquet/datatypes/large string map XFail 13s 717ms
/parquet/datatypes/largedouble OK 3s 853ms
/parquet/datatypes/manydatatypes OK 2s 852ms
/parquet/datatypes/manydatatypes2 OK 3s 871ms
/parquet/datatypes/maps OK 3s 283ms
/parquet/datatypes/nameswithemoji OK 2s 798ms
/parquet/datatypes/nandouble OK 3s 257ms
/parquet/datatypes/negativeint64 OK 4s 752ms
/parquet/datatypes/nullbyte OK 2s 935ms
/parquet/datatypes/nullbytemultiple OK 2s 988ms
/parquet/datatypes/nullsinid OK 3s 230ms
/parquet/datatypes/pandasdecimal OK 2s 693ms
/parquet/datatypes/pandasdecimaldate OK 2s 863ms
/parquet/datatypes/parquetgo OK 3s 92ms
/parquet/datatypes/selectdatewithfilter OK 1m 46s
/parquet/datatypes/singlenull OK 2s 415ms
/parquet/datatypes/sparkv21 OK 2s 495ms
/parquet/datatypes/sparkv22 OK 2s 177ms
/parquet/datatypes/statdecimal OK 2s 667ms
/parquet/datatypes/string OK 2s 405ms
/parquet/datatypes/string int list inconsistent offset multiple batches OK 15s 980ms
/parquet/query/compression type/=NONE /select from mergetree table into file OK 4m 56s
/parquet/query/compression type/=GZIP /select from mergetree table into file OK 4m 58s
/parquet/query/compression type/=LZ4 /select from mergetree table into file OK 4m 58s
/parquet/datatypes/stringtypes OK 1s 842ms
/parquet/datatypes/struct OK 1s 635ms
/parquet/datatypes/supporteduuid OK 1s 552ms
/parquet/datatypes/timestamp1 OK 1s 636ms
/parquet/datatypes/timestamp2 OK 2s 225ms
/parquet/datatypes/timezone OK 2s 275ms
/parquet/datatypes/unsigned OK 5s 431ms
/parquet/datatypes/unsupportednull OK 452ms
/parquet/complex OK 46s 197ms
/parquet/complex/arraystring OK 2s 120ms
/parquet/complex/big tuple with nulls OK 2s 746ms
/parquet/complex/bytearraydictionary OK 2s 105ms
/parquet/complex/complex null OK 2s 350ms
/parquet/complex/lagemap OK 2s 157ms
/parquet/complex/largenestedarray OK 2s 335ms
/parquet/complex/largestruct OK 2s 221ms
/parquet/complex/largestruct2 OK 2s 871ms
/parquet/complex/largestruct3 OK 2s 388ms
/parquet/complex/list OK 2s 298ms
/parquet/complex/nested array OK 2s 92ms
/parquet/complex/nested map OK 2s 86ms
/parquet/complex/nestedallcomplex OK 2s 713ms
/parquet/complex/nestedarray2 OK 2s 119ms
/parquet/complex/nestedstruct OK 2s 340ms
/parquet/complex/nestedstruct2 OK 2s 313ms
/parquet/complex/nestedstruct3 OK 2s 175ms
/parquet/complex/nestedstruct4 OK 2s 509ms
/parquet/complex/tupleofnulls OK 2s 84ms
/parquet/complex/tuplewithdatetime OK 2s 29ms
/parquet/cache OK 4s 315ms
/parquet/cache/cache1 OK 2s 351ms
/parquet/cache/cache2 OK 1s 951ms
/parquet/glob OK 1m 15s
/parquet/glob/fastparquet globs OK 21s 546ms
/parquet/glob/glob1 OK 2s 568ms
/parquet/glob/glob2 OK 3s 720ms
/parquet/glob/glob with multiple elements OK 593ms
/parquet/glob/million extensions OK 46s 967ms
/parquet/rowgroups OK 4s 226ms
/parquet/rowgroups/manyrowgroups OK 2s 142ms
/parquet/rowgroups/manyrowgroups2 OK 2s 47ms
/parquet/encrypted Skip 15ms
/parquet/fastparquet OK 145ms
/parquet/fastparquet/airlines Skip 7ms
/parquet/fastparquet/baz Skip 19ms
/parquet/fastparquet/empty date Skip 5ms
/parquet/fastparquet/evo Skip 55ms
/parquet/fastparquet/fastparquet Skip 6ms
/parquet/read and write OK 22m 53s
/parquet/read and write/read and write parquet file OK 22m 53s
/parquet/query/compression type/=NONE /select from replicated mergetree table into file OK 4m 9s
/parquet/query/compression type/=GZIP /select from replicated mergetree table into file OK 4m 8s
/parquet/query/compression type/=LZ4 /select from replicated mergetree table into file OK 4m 9s
/parquet/column related errors OK 2s 865ms
/parquet/column related errors/check error with 500 columns OK 2s 862ms
/parquet/multi chunk upload Skip 5ms
/parquet/query/compression type/=NONE /select from distributed table into file OK 4m 47s
/parquet/query/compression type/=GZIP /select from distributed table into file OK 4m 47s
/parquet/query/compression type/=LZ4 /select from distributed table into file OK 4m 45s
/parquet/query/compression type/=NONE /select from mat view into file OK 3m 54s
/parquet/query/compression type/=LZ4 /select from mat view into file OK 3m 51s
/parquet/query/compression type/=GZIP /select from mat view into file OK 4m 0s
/parquet/query/compression type/=NONE /insert into table with projection from file OK 1m 28s
/parquet/query/compression type/=LZ4 /insert into table with projection from file OK 1m 28s
/parquet/query/compression type/=GZIP /insert into table with projection from file OK 1m 21s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922