Copyright 2026, 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..
| Date | Apr 30, 2026 15:20 |
| Duration | 1h 11m |
| Framework | TestFlows 2.0.250110.1002922 |
Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#PRs/1707/6cf63348df35afa0e9f04087a1c30105b29d56e3/regression/
| project | Altinity/ClickHouse |
| project.id | 159717931 |
| package | https://s3.amazonaws.com/altinity-build-artifacts/PRs/1707/6cf63348df35afa0e9f04087a1c30105b29d56e3/package_aarch64/clickhouse-common-static_24.8.14.10545.altinitytest_arm64.deb |
| version | 24.8.14.10545.altinitytest |
| user.name | zvonand |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | b72ac10337ea9d7a0f764b86a40f4bb7dc0f81ff |
| job.name | ParquetS3 (minio) |
| job.retry | 1 |
| job.url | https://github.com/Altinity/ClickHouse/actions/runs/25169774826 |
| arch | aarch64 |
| local | True |
| clickhouse_version | None |
| clickhouse_path | https://s3.amazonaws.com/altinity-build-artifacts/PRs/1707/6cf63348df35afa0e9f04087a1c30105b29d56e3/package_aarch64/clickhouse-common-static_24.8.14.10545.altinitytest_arm64.deb |
| as_binary | False |
| base_os | None |
| keeper_path | None |
| zookeeper_version | None |
| use_keeper | False |
| stress | False |
| collect_service_logs | True |
| thread_fuzzer | False |
| with_analyzer | True |
| reuse_env | False |
| cicd | False |
| storages | ['minio'] |
| minio_uri | Secret(name='minio_uri') |
| minio_root_user | Secret(name='minio_root_user') |
| minio_root_password | Secret(name='minio_root_password') |
| aws_s3_bucket | Secret(name='aws_s3_bucket') |
| aws_s3_region | Secret(name='aws_s3_region') |
| aws_s3_key_id | Secret(name='aws_s3_key_id') |
| aws_s3_access_key | Secret(name='aws_s3_access_key') |
| gcs_uri | None |
| gcs_key_id | None |
| gcs_key_secret | None |
| azure_account_name | None |
| azure_storage_key | None |
| azure_container | None |
| stress_bloom | False |
| Units | Skip | OK | Fail | XFail | |
|---|---|---|---|---|---|
| Modules | |||||
| Suites | |||||
| Features | |||||
| Scenarios | |||||
| Checks | |||||
| Examples | |||||
| Steps |
| Test Name | Result | Message |
|---|---|---|
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | XFail 7s 784ms This fails because of the difference in snapshot values. We used to capture the datetime value `0` be converted as 2106-02-07 06:28:16 instead of the correct 1970-01-01 01:00:00. But when steps are repeated manually, we can not reproduce it | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 834, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 904, 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_nullable_datetime_
snapshot_value="""
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
""",
actual_value="""
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(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 @@
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
-{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
+{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
""")
assert that(snapshot_result), error()
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 904 in 'execute_query'
896\| with values() as that:
897\| snapshot_result = snapshot(
898\| "\n" + r.output.strip() + "\n",
899\| id=snapshot_id,
900\| name=snapshot_name,
901\| encoder=str,
902\| mode=snapshot.CHECK,
903\| )
904\|> assert that(snapshot_result), error() |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | XFail 7s 838ms 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 834, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 904, 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_nullable_datetime_
snapshot_value="""
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
""",
actual_value="""
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(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 @@
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
-{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
+{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
""")
assert that(snapshot_result), error()
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 904 in 'execute_query'
896\| with values() as that:
897\| snapshot_result = snapshot(
898\| "\n" + r.output.strip() + "\n",
899\| id=snapshot_id,
900\| name=snapshot_name,
901\| encoder=str,
902\| mode=snapshot.CHECK,
903\| )
904\|> assert that(snapshot_result), error() |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | XFail 7s 525ms 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 834, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 904, 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_nullable_datetime_
snapshot_value="""
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
""",
actual_value="""
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-08-10 21:14:26","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2006-01-25 20:44:12","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2009-05-30 23:43:18","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2015-12-28 10:07:33","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2017-06-27 03:09:51","toTypeName(nullable_datetime_)":"Nullable(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 @@
{"nullable_datetime_":"2106-02-07 06:28:15","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
-{"nullable_datetime_":"2106-02-07 06:28:16","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
+{"nullable_datetime_":"1970-01-01 01:00:00","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":null,"toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2014-04-10 09:39:46","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
{"nullable_datetime_":"2004-04-05 13:18:38","toTypeName(nullable_datetime_)":"Nullable(DateTime)"}
""")
assert that(snapshot_result), error()
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 904 in 'execute_query'
896\| with values() as that:
897\| snapshot_result = snapshot(
898\| "\n" + r.output.strip() + "\n",
899\| id=snapshot_id,
900\| name=snapshot_name,
901\| encoder=str,
902\| mode=snapshot.CHECK,
903\| )
904\|> assert that(snapshot_result), error() |
| /parquet/chunked array | XFail 16s 51ms 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 1163, 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.8.14.10545.altinitytest (altinity build))
(query: INSERT INTO table_f07d50ee_44ae_11f1_938a_920007aaf7d0 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 1163 in 'query'
1155\| assert message in r.output, error(r.output)
1156\|
1157\| if not ignore_exception:
1158\| if message is None or "Exception:" not in message:
1159\| with Then("check if output has exception") if steps else NullStep():
1160\| if "Exception:" in r.output:
1161\| if raise_on_exception:
1162\| raise QueryRuntimeException(r.output)
1163\|> assert False, error(r.output)
1164\|
1165\| return r
1166\| |
| /parquet/datatypes/large string map | XFail 5s 867ms 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 37, in import_export
node.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py", line 1163, 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.8.14):
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_1d0e4b69_44af_11f1_b4d9_920007aaf7d0
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 1163 in 'query'
1155\| assert message in r.output, error(r.output)
1156\|
1157\| if not ignore_exception:
1158\| if message is None or "Exception:" not in message:
1159\| with Then("check if output has exception") if steps else NullStep():
1160\| if "Exception:" in r.output:
1161\| if raise_on_exception:
1162\| raise QueryRuntimeException(r.output)
1163\|> assert False, error(r.output)
1164\|
1165\| return r
1166\| |
| Test Name | Result | Duration |
|---|---|---|
| /parquet | OK | 1h 11m |
| /parquet/file | OK | 11m 4s |
| /parquet/file/engine | OK | 11m 4s |
| /parquet/file/function | OK | 5m 45s |
| /parquet/file/engine/insert into engine | OK | 5m 22s |
| /parquet/file/function/insert into function manual cast types | OK | 5m 8s |
| /parquet/file/engine/select from engine | OK | 2m 37s |
| /parquet/file/function/insert into function auto cast types | OK | 5m 45s |
| /parquet/file/engine/engine to file to engine | OK | 8m 32s |
| /parquet/file/function/select from function manual cast types | OK | 3m 12s |
| /parquet/file/function/select from function auto cast types | OK | 2m 43s |
| /parquet/file/engine/insert into engine from file | OK | 5m 5s |
| /parquet/file/function/date as uint16 | Skip | 184ms |
| /parquet/file/engine/engine select output to file | OK | 11m 4s |
| /parquet/file/function/date as uint16 multiple dates | Skip | 15ms |
| /parquet/file/function/date as uint16 nullable | Skip | 18ms |
| /parquet/file/function/date as uint16 round trip | Skip | 46ms |
| /parquet/file/function/date as uint16 edge cases | Skip | 98ms |
| /parquet/file/function/date as uint16 with other columns | Skip | 15ms |
| /parquet/query | OK | 18m 39s |
| /parquet/query/compression type | OK | 18m 39s |
| /parquet/query/compression type/=NONE | OK | 18m 37s |
| /parquet/query/compression type/=NONE /insert into memory table from file | OK | 1m 5s |
| /parquet/query/compression type/=GZIP | OK | 18m 39s |
| /parquet/query/compression type/=GZIP /insert into memory table from file | OK | 1m 5s |
| /parquet/query/compression type/=LZ4 | OK | 18m 36s |
| /parquet/query/compression type/=LZ4 /insert into memory table from file | OK | 1m 4s |
| /parquet/query/compression type/=LZ4 /insert into mergetree table from file | OK | 1m 3s |
| /parquet/query/compression type/=NONE /insert into mergetree table from file | OK | 1m 3s |
| /parquet/query/compression type/=GZIP /insert into mergetree table from file | OK | 1m 3s |
| /parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file | OK | 1m 4s |
| /parquet/query/compression type/=NONE /insert into replicated mergetree table from file | OK | 1m 4s |
| /parquet/query/compression type/=GZIP /insert into replicated mergetree table from file | OK | 1m 4s |
| /parquet/query/compression type/=LZ4 /insert into distributed table from file | OK | 1m 8s |
| /parquet/query/compression type/=NONE /insert into distributed table from file | OK | 1m 8s |
| /parquet/query/compression type/=GZIP /insert into distributed table from file | OK | 1m 9s |
| /parquet/query/compression type/=NONE /select from memory table into file | OK | 2m 30s |
| /parquet/query/compression type/=LZ4 /select from memory table into file | OK | 2m 29s |
| /parquet/query/compression type/=GZIP /select from memory table into file | OK | 2m 29s |
| /parquet/query/compression type/=LZ4 /select from mergetree table into file | OK | 2m 30s |
| /parquet/query/compression type/=NONE /select from mergetree table into file | OK | 2m 31s |
| /parquet/query/compression type/=GZIP /select from mergetree table into file | OK | 2m 31s |
| /parquet/query/compression type/=LZ4 /select from replicated mergetree table into file | OK | 2m 33s |
| /parquet/query/compression type/=GZIP /select from replicated mergetree table into file | OK | 2m 33s |
| /parquet/query/compression type/=NONE /select from replicated mergetree table into file | OK | 2m 32s |
| /parquet/query/compression type/=NONE /select from distributed table into file | OK | 3m 16s |
| /parquet/query/compression type/=LZ4 /select from distributed table into file | OK | 3m 16s |
| /parquet/query/compression type/=GZIP /select from distributed table into file | OK | 3m 16s |
| /parquet/query/compression type/=NONE /select from mat view into file | OK | 2m 31s |
| /parquet/query/compression type/=LZ4 /select from mat view into file | OK | 2m 30s |
| /parquet/query/compression type/=GZIP /select from mat view into file | OK | 2m 35s |
| /parquet/query/compression type/=LZ4 /insert into table with projection from file | OK | 53s 879ms |
| /parquet/query/compression type/=NONE /insert into table with projection from file | OK | 54s 535ms |
| /parquet/query/compression type/=GZIP /insert into table with projection from file | OK | 50s 680ms |
| /parquet/list in multiple chunks | OK | 19s 913ms |
| /parquet/url | OK | 11m 10s |
| /parquet/url/engine | OK | 10m 36s |
| /parquet/url/function | OK | 5m 16s |
| /parquet/url/engine/insert into engine | OK | 4m 39s |
| /parquet/url/function/insert into function | OK | 3m 37s |
| /parquet/url/function/select from function manual cast types | OK | 5m 16s |
| /parquet/url/engine/select from engine | OK | 1m 22s |
| /parquet/url/function/select from function auto cast types | OK | 3m 40s |
| /parquet/url/engine/engine to file to engine | OK | 7m 49s |
| /parquet/url/engine/insert into engine from file | OK | 7m 15s |
| /parquet/url/engine/engine select output to file | OK | 10m 36s |
| /parquet/mysql | OK | 10s 415ms |
| /parquet/mysql/compression type | OK | 10s 413ms |
| /parquet/mysql/compression type/=NONE | OK | 10s 327ms |
| /parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine | OK | 6s 40ms |
| /parquet/mysql/compression type/=GZIP | OK | 10s 322ms |
| /parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine | OK | 6s 76ms |
| /parquet/mysql/compression type/=LZ4 | OK | 10s 394ms |
| /parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine | OK | 6s 150ms |
| /parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function | OK | 4s 285ms |
| /parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function | OK | 4s 243ms |
| /parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function | OK | 4s 241ms |
| /parquet/postgresql | OK | 12s 524ms |
| /parquet/postgresql/compression type | OK | 12s 523ms |
| /parquet/postgresql/compression type/=NONE | OK | 12s 517ms |
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | XFail | 7s 784ms |
| /parquet/postgresql/compression type/=GZIP | OK | 12s 512ms |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | XFail | 7s 838ms |
| /parquet/postgresql/compression type/=LZ4 | OK | 12s 157ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | XFail | 7s 525ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function | OK | 4s 630ms |
| /parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function | OK | 4s 730ms |
| /parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function | OK | 4s 672ms |
| /parquet/remote | OK | 4m 5s |
| /parquet/remote/compression type | OK | 4m 5s |
| /parquet/remote/compression type/=NONE | OK | 4m 5s |
| /parquet/remote/compression type/=NONE /outline | OK | 4m 5s |
| /parquet/remote/compression type/=NONE /outline/insert into function | OK | 1m 33s |
| /parquet/remote/compression type/=GZIP | OK | 4m 5s |
| /parquet/remote/compression type/=GZIP /outline | OK | 4m 5s |
| /parquet/remote/compression type/=GZIP /outline/insert into function | OK | 1m 34s |
| /parquet/remote/compression type/=LZ4 | OK | 4m 5s |
| /parquet/remote/compression type/=LZ4 /outline | OK | 4m 5s |
| /parquet/remote/compression type/=LZ4 /outline/insert into function | OK | 1m 33s |
| /parquet/remote/compression type/=LZ4 /outline/select from function | OK | 2m 32s |
| /parquet/remote/compression type/=NONE /outline/select from function | OK | 2m 32s |
| /parquet/remote/compression type/=GZIP /outline/select from function | OK | 2m 30s |
| /parquet/chunked array | XFail | 16s 51ms |
| /parquet/broken | OK | 20ms |
| /parquet/broken/file | Skip | 1ms |
| /parquet/broken/read broken bigint | Skip | 1ms |
| /parquet/broken/read broken date | Skip | 982us |
| /parquet/broken/read broken int | Skip | 1ms |
| /parquet/broken/read broken smallint | Skip | 970us |
| /parquet/broken/read broken timestamp ms | Skip | 888us |
| /parquet/broken/read broken timestamp us | Skip | 874us |
| /parquet/broken/read broken tinyint | Skip | 1ms |
| /parquet/broken/read broken ubigint | Skip | 1ms |
| /parquet/broken/read broken uint | Skip | 1ms |
| /parquet/broken/read broken usmallint | Skip | 886us |
| /parquet/broken/read broken utinyint | Skip | 1ms |
| /parquet/broken/string | Skip | 1ms |
| /parquet/encoding | OK | 7s 949ms |
| /parquet/encoding/deltabytearray1 | OK | 1s 458ms |
| /parquet/encoding/deltabytearray2 | OK | 1s 45ms |
| /parquet/encoding/deltalengthbytearray | OK | 1s 170ms |
| /parquet/encoding/dictionary | OK | 1s 8ms |
| /parquet/encoding/plain | OK | 974ms |
| /parquet/encoding/plainrlesnappy | OK | 1s 190ms |
| /parquet/encoding/rleboolean | OK | 1s 97ms |
| /parquet/compression | OK | 22s 202ms |
| /parquet/compression/arrow snappy | OK | 1s 13ms |
| /parquet/compression/brotli | OK | 1s 12ms |
| /parquet/compression/gzippages | OK | 2s 143ms |
| /parquet/compression/largegzip | OK | 1s 51ms |
| /parquet/compression/lz4 hadoop | OK | 1s 21ms |
| /parquet/compression/lz4 hadoop large | OK | 1s 28ms |
| /parquet/compression/lz4 non hadoop | OK | 1s 25ms |
| /parquet/compression/lz4 raw | OK | 1s 69ms |
| /parquet/compression/lz4 raw large | OK | 1s 65ms |
| /parquet/compression/lz4pages | OK | 2s 94ms |
| /parquet/compression/nonepages | OK | 2s 60ms |
| /parquet/compression/snappypages | OK | 2s 122ms |
| /parquet/compression/snappyplain | OK | 994ms |
| /parquet/compression/snappyrle | OK | 1s 70ms |
| /parquet/compression/zstd | OK | 1s 110ms |
| /parquet/compression/zstdpages | OK | 2s 311ms |
| /parquet/datatypes | OK | 1m 13s |
| /parquet/datatypes/arrowtimestamp | OK | 1s 24ms |
| /parquet/datatypes/arrowtimestampms | OK | 1s 3ms |
| /parquet/datatypes/binary | OK | 1s 57ms |
| /parquet/datatypes/binary string | OK | 1s 68ms |
| /parquet/datatypes/blob | OK | 1s 39ms |
| /parquet/datatypes/boolean | OK | 1s 64ms |
| /parquet/datatypes/byte array | OK | 1s 83ms |
| /parquet/datatypes/columnname | OK | 1s 56ms |
| /parquet/datatypes/columnwithnull | OK | 1s 58ms |
| /parquet/datatypes/columnwithnull2 | OK | 1s 78ms |
| /parquet/datatypes/date | OK | 1s 42ms |
| /parquet/datatypes/decimal with filter | OK | 1s 174ms |
| /parquet/datatypes/decimalvariousfilters | OK | 1s 78ms |
| /parquet/datatypes/decimalwithfilter2 | OK | 1s 65ms |
| /parquet/datatypes/enum | OK | 1s 102ms |
| /parquet/datatypes/enum2 | OK | 1s 41ms |
| /parquet/datatypes/fixed length decimal | OK | 1s 55ms |
| /parquet/datatypes/fixed length decimal legacy | OK | 1s 100ms |
| /parquet/datatypes/fixedstring | OK | 1s 2ms |
| /parquet/datatypes/float16 | Skip | 1ms |
| /parquet/datatypes/h2oai | OK | 1s 78ms |
| /parquet/datatypes/hive | OK | 2s 102ms |
| /parquet/datatypes/int32 | OK | 1s 44ms |
| /parquet/datatypes/int32 decimal | OK | 1s 9ms |
| /parquet/datatypes/int64 | OK | 1s 24ms |
| /parquet/datatypes/int64 decimal | OK | 1s 27ms |
| /parquet/datatypes/json | OK | 1s 45ms |
| /parquet/datatypes/large string map | XFail | 5s 867ms |
| /parquet/datatypes/largedouble | OK | 1s 208ms |
| /parquet/datatypes/manydatatypes | OK | 951ms |
| /parquet/datatypes/manydatatypes2 | OK | 1s 104ms |
| /parquet/datatypes/maps | OK | 1s 48ms |
| /parquet/datatypes/nameswithemoji | OK | 1s 80ms |
| /parquet/datatypes/nandouble | OK | 1s 33ms |
| /parquet/datatypes/negativeint64 | OK | 1s 3ms |
| /parquet/datatypes/nullbyte | OK | 1s 39ms |
| /parquet/datatypes/nullbytemultiple | OK | 1s 73ms |
| /parquet/datatypes/nullsinid | OK | 1s 12ms |
| /parquet/datatypes/pandasdecimal | OK | 1s 84ms |
| /parquet/datatypes/pandasdecimaldate | OK | 1s 26ms |
| /parquet/datatypes/parquetgo | OK | 1s 46ms |
| /parquet/datatypes/selectdatewithfilter | OK | 6s 674ms |
| /parquet/datatypes/singlenull | OK | 1s 62ms |
| /parquet/datatypes/sparkv21 | OK | 1s 75ms |
| /parquet/datatypes/sparkv22 | OK | 1s 109ms |
| /parquet/datatypes/statdecimal | OK | 1s 82ms |
| /parquet/datatypes/string | OK | 1s 8ms |
| /parquet/datatypes/string int list inconsistent offset multiple batches | OK | 4s 993ms |
| /parquet/datatypes/stringtypes | OK | 979ms |
| /parquet/datatypes/struct | OK | 1s 41ms |
| /parquet/datatypes/supporteduuid | OK | 1s 74ms |
| /parquet/datatypes/timestamp1 | OK | 1s 11ms |
| /parquet/datatypes/timestamp2 | OK | 985ms |
| /parquet/datatypes/timezone | OK | 993ms |
| /parquet/datatypes/unsigned | OK | 2s 160ms |
| /parquet/datatypes/unsupportednull | OK | 158ms |
| /parquet/complex | OK | 21s 884ms |
| /parquet/complex/arraystring | OK | 1s 70ms |
| /parquet/complex/big tuple with nulls | OK | 1s 75ms |
| /parquet/complex/bytearraydictionary | OK | 1s 75ms |
| /parquet/complex/complex null | OK | 1s 88ms |
| /parquet/complex/lagemap | OK | 1s 66ms |
| /parquet/complex/largenestedarray | OK | 1s 119ms |
| /parquet/complex/largestruct | OK | 1s 56ms |
| /parquet/complex/largestruct2 | OK | 1s 321ms |
| /parquet/complex/largestruct3 | OK | 1s 4ms |
| /parquet/complex/list | OK | 1s 108ms |
| /parquet/complex/nested array | OK | 1s 88ms |
| /parquet/complex/nested map | OK | 1s 33ms |
| /parquet/complex/nestedallcomplex | OK | 1s 175ms |
| /parquet/complex/nestedarray2 | OK | 1s 83ms |
| /parquet/complex/nestedstruct | OK | 1s 69ms |
| /parquet/complex/nestedstruct2 | OK | 1s 22ms |
| /parquet/complex/nestedstruct3 | OK | 1s 101ms |
| /parquet/complex/nestedstruct4 | OK | 1s 185ms |
| /parquet/complex/tupleofnulls | OK | 1s 15ms |
| /parquet/complex/tuplewithdatetime | OK | 1s 114ms |
| /parquet/cache | OK | 2s 61ms |
| /parquet/cache/cache1 | OK | 1s 14ms |
| /parquet/cache/cache2 | OK | 1s 44ms |
| /parquet/glob | OK | 39s 595ms |
| /parquet/glob/fastparquet globs | OK | 789ms |
| /parquet/glob/glob1 | OK | 1s 69ms |
| /parquet/glob/glob2 | OK | 1s 266ms |
| /parquet/glob/glob with multiple elements | OK | 265ms |
| /parquet/glob/million extensions | OK | 36s 201ms |
| /parquet/rowgroups | OK | 2s 153ms |
| /parquet/rowgroups/manyrowgroups | OK | 1s 95ms |
| /parquet/rowgroups/manyrowgroups2 | OK | 1s 55ms |
| /parquet/encrypted | Skip | 1ms |
| /parquet/fastparquet | OK | 23ms |
| /parquet/fastparquet/airlines | Skip | 1ms |
| /parquet/fastparquet/baz | Skip | 1ms |
| /parquet/fastparquet/empty date | Skip | 896us |
| /parquet/fastparquet/evo | Skip | 14ms |
| /parquet/fastparquet/fastparquet | Skip | 1ms |
| /parquet/read and write | OK | 11m 46s |
| /parquet/read and write/read and write parquet file | OK | 11m 46s |
| /parquet/column related errors | OK | 626ms |
| /parquet/column related errors/check error with 500 columns | OK | 624ms |
| /parquet/multi chunk upload | Skip | 1ms |
| /parquet/minio | OK | 6m 59s |
| /parquet/minio/s3 | OK | 6m 59s |
| /parquet/minio/s3/compression type | OK | 6m 14s |
| /parquet/minio/s3/compression type/=NONE | OK | 6m 13s |
| /parquet/minio/s3/compression type/=NONE /outline | OK | 6m 13s |
| /parquet/minio/s3/compression type/=NONE /outline/engine | OK | 68ms |
| /parquet/minio/s3/compression type/=GZIP | OK | 6m 14s |
| /parquet/minio/s3/compression type/=GZIP /outline | OK | 6m 14s |
| /parquet/minio/s3/compression type/=GZIP /outline/engine | OK | 55ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine | Skip | 2ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/select from engine | Skip | 2ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/engine to file to engine | Skip | 1ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine from file | Skip | 2ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/engine select output to file | Skip | 9ms |
| /parquet/minio/s3/compression type/=LZ4 | OK | 6m 13s |
| /parquet/minio/s3/compression type/=LZ4 /outline | OK | 6m 13s |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine | OK | 115ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine | Skip | 2ms |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine | Skip | 2ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/select from engine | Skip | 2ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/engine to file to engine | Skip | 1ms |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine/select from engine | Skip | 1ms |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine/engine to file to engine | Skip | 2ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine from file | Skip | 2ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/engine select output to file | Skip | 1ms |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine from file | Skip | 2ms |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine/engine select output to file | Skip | 1ms |
| /parquet/minio/s3/compression type/=GZIP /outline/function | OK | 6m 14s |
| /parquet/minio/s3/compression type/=GZIP /outline/function/insert into function | OK | 6m 14s |
| /parquet/minio/s3/compression type/=NONE /outline/function | OK | 6m 13s |
| /parquet/minio/s3/compression type/=GZIP /outline/function/select from function manual cast types | OK | 5m 52s |
| /parquet/minio/s3/compression type/=NONE /outline/function/insert into function | OK | 6m 13s |
| /parquet/minio/s3/compression type/=NONE /outline/function/select from function manual cast types | OK | 5m 50s |
| /parquet/minio/s3/compression type/=NONE /outline/function/select from function auto cast types | OK | 5m 22s |
| /parquet/minio/s3/compression type/=GZIP /outline/function/select from function auto cast types | OK | 5m 23s |
| /parquet/minio/s3/compression type/=LZ4 /outline/function | OK | 6m 13s |
| /parquet/minio/s3/compression type/=LZ4 /outline/function/insert into function | OK | 6m 13s |
| /parquet/minio/s3/compression type/=LZ4 /outline/function/select from function manual cast types | OK | 5m 52s |
| /parquet/minio/s3/compression type/=LZ4 /outline/function/select from function auto cast types | OK | 5m 22s |
Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922