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..
| Date | Jul 13, 2025 0:04 |
| Duration | 40m 19s |
| Framework | TestFlows 2.0.250110.1002922 |
Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#0/143c05fcd433555c6563408d8c622fb757f91dfe/regression/x86_64/with_analyzer/zookeeper/without_thread_fuzzer/parquetminio/
| project | Altinity/ClickHouse |
| project.id | 159717931 |
| package | https://s3.amazonaws.com/altinity-build-artifacts/25.3/143c05fcd433555c6563408d8c622fb757f91dfe/package_release/clickhouse-common-static_25.3.3.20186.altinityantalya_amd64.deb |
| version | 25.3.3.20186.altinityantalya |
| user.name | Enmk |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | 88c93f843cd48cd9defc6cec6b98d6b98f94adde |
| job.name | ParquetS3 (minio) |
| job.retry | 1 |
| job.url | https://github.com/Altinity/ClickHouse/actions/runs/16242745619 |
| arch | x86_64 |
| local | True |
| clickhouse_version | None |
| clickhouse_path | https://s3.amazonaws.com/altinity-build-artifacts/25.3/143c05fcd433555c6563408d8c622fb757f91dfe/package_release/clickhouse-common-static_25.3.3.20186.altinityantalya_amd64.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 |
| 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 |
| native_parquet_reader | False |
| 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 14s 306ms 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 828, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 898, 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 898 in 'execute_query'
890\| with values() as that:
891\| snapshot_result = snapshot(
892\| "\n" + r.output.strip() + "\n",
893\| id=snapshot_id,
894\| name=snapshot_name,
895\| encoder=str,
896\| mode=snapshot.CHECK,
897\| )
898\|> assert that(snapshot_result), error() |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | XFail 13s 957ms 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 828, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 898, 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 898 in 'execute_query'
890\| with values() as that:
891\| snapshot_result = snapshot(
892\| "\n" + r.output.strip() + "\n",
893\| id=snapshot_id,
894\| name=snapshot_name,
895\| encoder=str,
896\| mode=snapshot.CHECK,
897\| )
898\|> assert that(snapshot_result), error() |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | XFail 14s 389ms 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 828, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 898, 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 898 in 'execute_query'
890\| with values() as that:
891\| snapshot_result = snapshot(
892\| "\n" + r.output.strip() + "\n",
893\| id=snapshot_id,
894\| name=snapshot_name,
895\| encoder=str,
896\| mode=snapshot.CHECK,
897\| )
898\|> assert that(snapshot_result), error() |
| /parquet/chunked array | XFail 24s 481ms 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.3.3.20186.altinityantalya (altinity build))
(query: INSERT INTO table_665aa734_5f7f_11f0_aec9_9200062cc293 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/float16 | XFail 572ms 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 map | XFail 9s 89ms 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.3.3):
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_ae20bf23_5f7f_11f0_a773_9200062cc293
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\| |
| Test Name | Result | Duration |
|---|---|---|
| /parquet | OK | 40m 19s |
| /parquet/file | OK | 21m 22s |
| /parquet/file/engine | OK | 21m 22s |
| /parquet/file/function | OK | 10m 17s |
| /parquet/file/engine/insert into engine | OK | 12m 56s |
| /parquet/file/engine/select from engine | OK | 5m 45s |
| /parquet/file/function/insert into function manual cast types | OK | 10m 0s |
| /parquet/query | OK | 28m 46s |
| /parquet/query/compression type | OK | 28m 46s |
| /parquet/file/engine/engine to file to engine | OK | 18m 12s |
| /parquet/file/function/insert into function auto cast types | OK | 10m 17s |
| /parquet/query/compression type/=NONE | OK | 28m 45s |
| /parquet/query/compression type/=NONE /insert into memory table from file | OK | 5m 38s |
| /parquet/file/function/select from function manual cast types | OK | 6m 14s |
| /parquet/query/compression type/=GZIP | OK | 28m 41s |
| /parquet/query/compression type/=GZIP /insert into memory table from file | OK | 5m 38s |
| /parquet/file/engine/insert into engine from file | OK | 12m 31s |
| /parquet/file/engine/engine select output to file | OK | 21m 22s |
| /parquet/query/compression type/=LZ4 | OK | 28m 45s |
| /parquet/query/compression type/=LZ4 /insert into memory table from file | OK | 5m 38s |
| /parquet/list in multiple chunks | OK | 20s 265ms |
| /parquet/file/function/select from function auto cast types | OK | 5m 47s |
| /parquet/url | OK | 22m 20s |
| /parquet/url/engine | OK | 21m 40s |
| /parquet/url/engine/insert into engine | OK | 13m 18s |
| /parquet/url/function | OK | 10m 52s |
| /parquet/url/engine/select from engine | OK | 5m 46s |
| /parquet/url/function/insert into function | OK | 9m 57s |
| /parquet/url/engine/engine to file to engine | OK | 18m 17s |
| /parquet/url/function/select from function manual cast types | OK | 10m 52s |
| /parquet/url/engine/insert into engine from file | OK | 17m 35s |
| /parquet/url/function/select from function auto cast types | OK | 9m 41s |
| /parquet/url/engine/engine select output to file | OK | 21m 39s |
| /parquet/mysql | OK | 36s 69ms |
| /parquet/mysql/compression type | OK | 35s 988ms |
| /parquet/mysql/compression type/=NONE | OK | 35s 449ms |
| /parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine | OK | 21s 130ms |
| /parquet/mysql/compression type/=GZIP | OK | 35s 926ms |
| /parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine | OK | 20s 877ms |
| /parquet/mysql/compression type/=LZ4 | OK | 35s 413ms |
| /parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine | OK | 20s 657ms |
| /parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function | OK | 14s 675ms |
| /parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function | OK | 14s 944ms |
| /parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function | OK | 14s 265ms |
| /parquet/postgresql | OK | 30s 367ms |
| /parquet/postgresql/compression type | OK | 30s 325ms |
| /parquet/postgresql/compression type/=NONE | OK | 29s 500ms |
| /parquet/postgresql/compression type/=GZIP | OK | 30s 268ms |
| /parquet/postgresql/compression type/=LZ4 | OK | 29s 638ms |
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | XFail | 14s 306ms |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | XFail | 13s 957ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | XFail | 14s 389ms |
| /parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function | OK | 16s 226ms |
| /parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function | OK | 15s 101ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function | OK | 15s 151ms |
| /parquet/remote | OK | 13m 56s |
| /parquet/remote/compression type | OK | 13m 56s |
| /parquet/remote/compression type/=NONE | OK | 13m 56s |
| /parquet/remote/compression type/=GZIP | OK | 13m 56s |
| /parquet/remote/compression type/=LZ4 | OK | 13m 53s |
| /parquet/remote/compression type/=NONE /outline | OK | 13m 56s |
| /parquet/remote/compression type/=GZIP /outline | OK | 13m 56s |
| /parquet/remote/compression type/=LZ4 /outline | OK | 13m 53s |
| /parquet/remote/compression type/=NONE /outline/insert into function | OK | 5m 19s |
| /parquet/remote/compression type/=GZIP /outline/insert into function | OK | 5m 18s |
| /parquet/remote/compression type/=LZ4 /outline/insert into function | OK | 5m 19s |
| /parquet/query/compression type/=LZ4 /insert into mergetree table from file | OK | 3m 52s |
| /parquet/query/compression type/=NONE /insert into mergetree table from file | OK | 3m 51s |
| /parquet/query/compression type/=GZIP /insert into mergetree table from file | OK | 3m 51s |
| /parquet/remote/compression type/=GZIP /outline/select from function | OK | 8m 37s |
| /parquet/remote/compression type/=LZ4 /outline/select from function | OK | 8m 34s |
| /parquet/remote/compression type/=NONE /outline/select from function | OK | 8m 36s |
| /parquet/query/compression type/=NONE /insert into replicated mergetree table from file | OK | 2m 53s |
| /parquet/query/compression type/=GZIP /insert into replicated mergetree table from file | OK | 2m 53s |
| /parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file | OK | 2m 52s |
| /parquet/query/compression type/=NONE /insert into distributed table from file | OK | 2m 15s |
| /parquet/query/compression type/=GZIP /insert into distributed table from file | OK | 2m 14s |
| /parquet/query/compression type/=LZ4 /insert into distributed table from file | OK | 2m 16s |
| /parquet/query/compression type/=GZIP /select from memory table into file | OK | 4m 1s |
| /parquet/query/compression type/=NONE /select from memory table into file | OK | 4m 2s |
| /parquet/query/compression type/=LZ4 /select from memory table into file | OK | 4m 1s |
| /parquet/chunked array | XFail | 24s 481ms |
| /parquet/broken | OK | 242ms |
| /parquet/broken/file | Skip | 7ms |
| /parquet/broken/read broken bigint | Skip | 12ms |
| /parquet/broken/read broken date | Skip | 14ms |
| /parquet/broken/read broken int | Skip | 17ms |
| /parquet/broken/read broken smallint | Skip | 9ms |
| /parquet/broken/read broken timestamp ms | Skip | 1ms |
| /parquet/broken/read broken timestamp us | Skip | 4ms |
| /parquet/broken/read broken tinyint | Skip | 7ms |
| /parquet/broken/read broken ubigint | Skip | 53ms |
| /parquet/broken/read broken uint | Skip | 7ms |
| /parquet/broken/read broken usmallint | Skip | 9ms |
| /parquet/broken/read broken utinyint | Skip | 9ms |
| /parquet/broken/string | Skip | 8ms |
| /parquet/encoding | OK | 13s 252ms |
| /parquet/encoding/deltabytearray1 | OK | 2s 254ms |
| /parquet/encoding/deltabytearray2 | OK | 1s 711ms |
| /parquet/encoding/deltalengthbytearray | OK | 1s 683ms |
| /parquet/encoding/dictionary | OK | 1s 601ms |
| /parquet/encoding/plain | OK | 1s 781ms |
| /parquet/encoding/plainrlesnappy | OK | 2s 479ms |
| /parquet/encoding/rleboolean | OK | 1s 640ms |
| /parquet/compression | OK | 35s 544ms |
| /parquet/compression/arrow snappy | OK | 1s 838ms |
| /parquet/compression/brotli | OK | 1s 602ms |
| /parquet/compression/gzippages | OK | 3s 526ms |
| /parquet/compression/largegzip | OK | 1s 779ms |
| /parquet/compression/lz4 hadoop | OK | 1s 664ms |
| /parquet/compression/lz4 hadoop large | OK | 1s 854ms |
| /parquet/compression/lz4 non hadoop | OK | 1s 611ms |
| /parquet/compression/lz4 raw | OK | 1s 733ms |
| /parquet/compression/lz4 raw large | OK | 1s 463ms |
| /parquet/compression/lz4pages | OK | 3s 289ms |
| /parquet/compression/nonepages | OK | 3s 404ms |
| /parquet/compression/snappypages | OK | 3s 470ms |
| /parquet/compression/snappyplain | OK | 1s 608ms |
| /parquet/compression/snappyrle | OK | 1s 647ms |
| /parquet/compression/zstd | OK | 1s 682ms |
| /parquet/compression/zstdpages | OK | 3s 268ms |
| /parquet/datatypes | OK | 2m 9s |
| /parquet/datatypes/arrowtimestamp | OK | 1s 502ms |
| /parquet/datatypes/arrowtimestampms | OK | 1s 625ms |
| /parquet/datatypes/binary | OK | 1s 642ms |
| /parquet/datatypes/binary string | OK | 1s 753ms |
| /parquet/datatypes/blob | OK | 1s 558ms |
| /parquet/datatypes/boolean | OK | 1s 763ms |
| /parquet/datatypes/byte array | OK | 1s 557ms |
| /parquet/datatypes/columnname | OK | 1s 560ms |
| /parquet/datatypes/columnwithnull | OK | 1s 834ms |
| /parquet/datatypes/columnwithnull2 | OK | 1s 504ms |
| /parquet/datatypes/date | OK | 1s 795ms |
| /parquet/datatypes/decimal with filter | OK | 1s 831ms |
| /parquet/datatypes/decimalvariousfilters | OK | 1s 788ms |
| /parquet/datatypes/decimalwithfilter2 | OK | 1s 659ms |
| /parquet/datatypes/enum | OK | 2s 129ms |
| /parquet/datatypes/enum2 | OK | 1s 712ms |
| /parquet/datatypes/fixed length decimal | OK | 1s 896ms |
| /parquet/datatypes/fixed length decimal legacy | OK | 1s 684ms |
| /parquet/datatypes/fixedstring | OK | 1s 879ms |
| /parquet/datatypes/float16 | XFail | 572ms |
| /parquet/datatypes/h2oai | OK | 1s 805ms |
| /parquet/datatypes/hive | OK | 3s 321ms |
| /parquet/datatypes/int32 | OK | 1s 728ms |
| /parquet/datatypes/int32 decimal | OK | 1s 597ms |
| /parquet/datatypes/int64 | OK | 1s 693ms |
| /parquet/datatypes/int64 decimal | OK | 1s 698ms |
| /parquet/datatypes/json | OK | 1s 590ms |
| /parquet/datatypes/large string map | XFail | 9s 89ms |
| /parquet/datatypes/largedouble | OK | 1s 968ms |
| /parquet/datatypes/manydatatypes | OK | 1s 916ms |
| /parquet/datatypes/manydatatypes2 | OK | 2s 154ms |
| /parquet/datatypes/maps | OK | 1s 869ms |
| /parquet/datatypes/nameswithemoji | OK | 1s 552ms |
| /parquet/datatypes/nandouble | OK | 1s 495ms |
| /parquet/datatypes/negativeint64 | OK | 2s 633ms |
| /parquet/datatypes/nullbyte | OK | 1s 642ms |
| /parquet/datatypes/nullbytemultiple | OK | 1s 785ms |
| /parquet/datatypes/nullsinid | OK | 1s 626ms |
| /parquet/datatypes/pandasdecimal | OK | 1s 841ms |
| /parquet/datatypes/pandasdecimaldate | OK | 1s 573ms |
| /parquet/datatypes/parquetgo | OK | 1s 390ms |
| /parquet/datatypes/selectdatewithfilter | OK | 23s 211ms |
| /parquet/datatypes/singlenull | OK | 1s 522ms |
| /parquet/datatypes/sparkv21 | OK | 1s 377ms |
| /parquet/datatypes/sparkv22 | OK | 1s 634ms |
| /parquet/datatypes/statdecimal | OK | 1s 175ms |
| /parquet/datatypes/string | OK | 1s 424ms |
| /parquet/datatypes/string int list inconsistent offset multiple batches | OK | 9s 184ms |
| /parquet/datatypes/stringtypes | OK | 1s 227ms |
| /parquet/datatypes/struct | OK | 1s 535ms |
| /parquet/datatypes/supporteduuid | OK | 1s 874ms |
| /parquet/query/compression type/=GZIP /select from mergetree table into file | OK | 2m 35s |
| /parquet/datatypes/timestamp1 | OK | 1s 91ms |
| /parquet/query/compression type/=LZ4 /select from mergetree table into file | OK | 2m 36s |
| /parquet/query/compression type/=NONE /select from mergetree table into file | OK | 2m 37s |
| /parquet/datatypes/timestamp2 | OK | 851ms |
| /parquet/datatypes/timezone | OK | 797ms |
| /parquet/datatypes/unsigned | OK | 2s 566ms |
| /parquet/datatypes/unsupportednull | OK | 337ms |
| /parquet/complex | OK | 25s 221ms |
| /parquet/complex/arraystring | OK | 1s 820ms |
| /parquet/complex/big tuple with nulls | OK | 1s 446ms |
| /parquet/complex/bytearraydictionary | OK | 1s 256ms |
| /parquet/complex/complex null | OK | 1s 197ms |
| /parquet/complex/lagemap | OK | 1s 0ms |
| /parquet/complex/largenestedarray | OK | 1s 308ms |
| /parquet/complex/largestruct | OK | 1s 316ms |
| /parquet/complex/largestruct2 | OK | 1s 200ms |
| /parquet/complex/largestruct3 | OK | 1s 190ms |
| /parquet/complex/list | OK | 1s 116ms |
| /parquet/complex/nested array | OK | 1s 279ms |
| /parquet/complex/nested map | OK | 1s 189ms |
| /parquet/complex/nestedallcomplex | OK | 1s 306ms |
| /parquet/complex/nestedarray2 | OK | 1s 138ms |
| /parquet/complex/nestedstruct | OK | 1s 206ms |
| /parquet/complex/nestedstruct2 | OK | 1s 252ms |
| /parquet/complex/nestedstruct3 | OK | 1s 301ms |
| /parquet/complex/nestedstruct4 | OK | 1s 261ms |
| /parquet/complex/tupleofnulls | OK | 1s 304ms |
| /parquet/complex/tuplewithdatetime | OK | 1s 81ms |
| /parquet/cache | OK | 2s 231ms |
| /parquet/cache/cache1 | OK | 1s 106ms |
| /parquet/cache/cache2 | OK | 1s 118ms |
| /parquet/glob | OK | 33s 666ms |
| /parquet/glob/fastparquet globs | OK | 1s 790ms |
| /parquet/glob/glob1 | OK | 1s 619ms |
| /parquet/glob/glob2 | OK | 1s 913ms |
| /parquet/glob/glob with multiple elements | OK | 371ms |
| /parquet/glob/million extensions | OK | 27s 959ms |
| /parquet/rowgroups | OK | 2s 251ms |
| /parquet/rowgroups/manyrowgroups | OK | 1s 127ms |
| /parquet/rowgroups/manyrowgroups2 | OK | 1s 122ms |
| /parquet/encrypted | Skip | 1ms |
| /parquet/fastparquet | OK | 10ms |
| /parquet/fastparquet/airlines | Skip | 1ms |
| /parquet/fastparquet/baz | Skip | 1ms |
| /parquet/fastparquet/empty date | Skip | 2ms |
| /parquet/fastparquet/evo | Skip | 933us |
| /parquet/fastparquet/fastparquet | Skip | 911us |
| /parquet/read and write | OK | 12m 32s |
| /parquet/read and write/read and write parquet file | OK | 12m 32s |
| /parquet/query/compression type/=GZIP /select from replicated mergetree table into file | OK | 2m 12s |
| /parquet/query/compression type/=LZ4 /select from replicated mergetree table into file | OK | 2m 12s |
| /parquet/query/compression type/=NONE /select from replicated mergetree table into file | OK | 2m 11s |
| /parquet/column related errors | OK | 1s 647ms |
| /parquet/column related errors/check error with 500 columns | OK | 1s 646ms |
| /parquet/multi chunk upload | Skip | 1ms |
| /parquet/query/compression type/=GZIP /select from distributed table into file | OK | 2m 30s |
| /parquet/query/compression type/=LZ4 /select from distributed table into file | OK | 2m 30s |
| /parquet/query/compression type/=NONE /select from distributed table into file | OK | 2m 30s |
| /parquet/query/compression type/=GZIP /select from mat view into file | OK | 2m 4s |
| /parquet/query/compression type/=LZ4 /select from mat view into file | OK | 2m 9s |
| /parquet/query/compression type/=NONE /select from mat view into file | OK | 2m 6s |
| /parquet/query/compression type/=GZIP /insert into table with projection from file | OK | 38s 972ms |
| /parquet/query/compression type/=NONE /insert into table with projection from file | OK | 37s 719ms |
| /parquet/query/compression type/=LZ4 /insert into table with projection from file | OK | 35s 569ms |
| /parquet/minio | OK | 4m 14s |
| /parquet/minio/s3 | OK | 4m 14s |
| /parquet/minio/s3/compression type | OK | 4m 14s |
| /parquet/minio/s3/compression type/=NONE | OK | 4m 12s |
| /parquet/minio/s3/compression type/=NONE /outline | OK | 4m 12s |
| /parquet/minio/s3/compression type/=NONE /outline/engine | OK | 29ms |
| /parquet/minio/s3/compression type/=GZIP | OK | 4m 14s |
| /parquet/minio/s3/compression type/=GZIP /outline | OK | 4m 14s |
| /parquet/minio/s3/compression type/=GZIP /outline/engine | OK | 117ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine | Skip | 1ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/select from engine | Skip | 875us |
| /parquet/minio/s3/compression type/=NONE /outline/engine/engine to file to engine | Skip | 777us |
| /parquet/minio/s3/compression type/=LZ4 | OK | 4m 13s |
| /parquet/minio/s3/compression type/=LZ4 /outline | OK | 4m 13s |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine | OK | 111ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine | Skip | 1ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/insert into engine from file | Skip | 1ms |
| /parquet/minio/s3/compression type/=NONE /outline/engine/engine select output to file | Skip | 1ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/select from engine | Skip | 1ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/engine to file to engine | Skip | 1ms |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into 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 | 964us |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/insert into engine from file | Skip | 1ms |
| /parquet/minio/s3/compression type/=GZIP /outline/engine/engine select output to file | Skip | 1ms |
| /parquet/minio/s3/compression type/=NONE /outline/function | OK | 4m 12s |
| /parquet/minio/s3/compression type/=NONE /outline/function/insert into function | OK | 4m 12s |
| /parquet/minio/s3/compression type/=NONE /outline/function/select from function manual cast types | OK | 3m 56s |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine/insert into engine from file | Skip | 3ms |
| /parquet/minio/s3/compression type/=LZ4 /outline/engine/engine select output to file | Skip | 1ms |
| /parquet/minio/s3/compression type/=NONE /outline/function/select from function auto cast types | OK | 3m 38s |
| /parquet/minio/s3/compression type/=GZIP /outline/function | OK | 4m 13s |
| /parquet/minio/s3/compression type/=LZ4 /outline/function | OK | 4m 13s |
| /parquet/minio/s3/compression type/=GZIP /outline/function/insert into function | OK | 4m 13s |
| /parquet/minio/s3/compression type/=LZ4 /outline/function/insert into function | OK | 4m 13s |
| /parquet/minio/s3/compression type/=GZIP /outline/function/select from function manual cast types | OK | 3m 56s |
| /parquet/minio/s3/compression type/=GZIP /outline/function/select from function auto cast types | OK | 3m 37s |
| /parquet/minio/s3/compression type/=LZ4 /outline/function/select from function manual cast types | OK | 3m 56s |
| /parquet/minio/s3/compression type/=LZ4 /outline/function/select from function auto cast types | OK | 3m 39s |
Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922