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 | Jun 13, 2025 14:26 |
| Duration | 1h 13m |
| Framework | TestFlows 2.0.250110.1002922 |
Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#0/98010fbdcc6c8e06606d6252813a2a2f091516fe/regression/aarch64/with_analyzer/zookeeper/without_thread_fuzzer/parquetaws_s3/
| project | Altinity/ClickHouse |
| project.id | 159717931 |
| package | https://s3.amazonaws.com/altinity-build-artifacts/25.3/98010fbdcc6c8e06606d6252813a2a2f091516fe/package_aarch64/clickhouse-common-static_25.3.3.20143.altinityantalya_arm64.deb |
| version | 25.3.3.20143.altinityantalya |
| user.name | Enmk |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | 88c93f843cd48cd9defc6cec6b98d6b98f94adde |
| job.name | ParquetS3 (aws_s3) |
| job.retry | 1 |
| job.url | https://github.com/Altinity/ClickHouse/actions/runs/15635502934 |
| arch | aarch64 |
| local | True |
| clickhouse_version | None |
| clickhouse_path | https://s3.amazonaws.com/altinity-build-artifacts/25.3/98010fbdcc6c8e06606d6252813a2a2f091516fe/package_aarch64/clickhouse-common-static_25.3.3.20143.altinityantalya_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 |
| storages | ['aws_s3'] |
| 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 | Error | 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 43s 514ms 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/=LZ4 /postgresql engine to parquet file to postgresql engine | XFail 41s 980ms 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/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | XFail 43s 783ms 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/chunked array | XFail 17s 960ms 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.20143.altinityantalya (altinity build))
(query: INSERT INTO table_cc5a76e8_4866_11f0_a279_9600045f923a 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 607ms 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 8s 121ms 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_fbf13020_4867_11f0_b893_9600045f923a
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 | 1h 13m |
| /parquet/file | OK | 37m 10s |
| /parquet/file/engine | OK | 37m 10s |
| /parquet/file/function | OK | 19m 30s |
| /parquet/file/function/insert into function manual cast types | OK | 19m 5s |
| /parquet/file/function/insert into function auto cast types | OK | 19m 30s |
| /parquet/file/engine/insert into engine | OK | 23m 38s |
| /parquet/file/engine/select from engine | OK | 11m 35s |
| /parquet/file/engine/engine to file to engine | OK | 32m 24s |
| /parquet/file/engine/insert into engine from file | OK | 22m 54s |
| /parquet/file/engine/engine select output to file | OK | 37m 10s |
| /parquet/query | OK | 50m 7s |
| /parquet/query/compression type | OK | 50m 7s |
| /parquet/query/compression type/=NONE | OK | 50m 6s |
| /parquet/query/compression type/=NONE /insert into memory table from file | OK | 11m 7s |
| /parquet/file/function/select from function manual cast types | OK | 18m 45s |
| /parquet/query/compression type/=GZIP | OK | 50m 7s |
| /parquet/query/compression type/=GZIP /insert into memory table from file | OK | 11m 9s |
| /parquet/file/function/select from function auto cast types | OK | 11m 37s |
| /parquet/query/compression type/=LZ4 | OK | 50m 6s |
| /parquet/list in multiple chunks | OK | 1m 23s |
| /parquet/url | OK | 38m 24s |
| /parquet/query/compression type/=LZ4 /insert into memory table from file | OK | 11m 10s |
| /parquet/url/engine | OK | 37m 14s |
| /parquet/url/function | OK | 36m 43s |
| /parquet/url/engine/insert into engine | OK | 23m 40s |
| /parquet/url/function/insert into function | OK | 18m 32s |
| /parquet/url/engine/select from engine | OK | 11m 13s |
| /parquet/url/function/select from function manual cast types | OK | 36m 43s |
| /parquet/url/function/select from function auto cast types | OK | 18m 1s |
| /parquet/url/engine/engine to file to engine | OK | 31m 59s |
| /parquet/url/engine/insert into engine from file | OK | 31m 8s |
| /parquet/url/engine/engine select output to file | OK | 37m 14s |
| /parquet/mysql | OK | 2m 21s |
| /parquet/mysql/compression type | OK | 2m 21s |
| /parquet/mysql/compression type/=NONE | OK | 2m 20s |
| /parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine | OK | 1m 40s |
| /parquet/mysql/compression type/=GZIP | OK | 2m 21s |
| /parquet/mysql/compression type/=LZ4 | OK | 2m 19s |
| /parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine | OK | 1m 39s |
| /parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine | OK | 1m 40s |
| /parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function | OK | 39s 749ms |
| /parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function | OK | 40s 197ms |
| /parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function | OK | 39s 523ms |
| /parquet/postgresql | OK | 1m 19s |
| /parquet/postgresql/compression type | OK | 1m 19s |
| /parquet/postgresql/compression type/=GZIP | OK | 1m 19s |
| /parquet/postgresql/compression type/=LZ4 | OK | 1m 18s |
| /parquet/postgresql/compression type/=NONE | OK | 1m 17s |
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | XFail | 43s 514ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | XFail | 41s 980ms |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | XFail | 43s 783ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function | OK | 35s 883ms |
| /parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function | OK | 34s 310ms |
| /parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function | OK | 35s 583ms |
| /parquet/remote | OK | 22m 56s |
| /parquet/remote/compression type | OK | 22m 55s |
| /parquet/remote/compression type/=NONE | OK | 22m 55s |
| /parquet/remote/compression type/=GZIP | OK | 22m 52s |
| /parquet/remote/compression type/=LZ4 | OK | 22m 55s |
| /parquet/remote/compression type/=NONE /outline | OK | 22m 55s |
| /parquet/remote/compression type/=NONE /outline/insert into function | OK | 8m 5s |
| /parquet/remote/compression type/=GZIP /outline | OK | 22m 52s |
| /parquet/remote/compression type/=LZ4 /outline | OK | 22m 55s |
| /parquet/remote/compression type/=GZIP /outline/insert into function | OK | 8m 5s |
| /parquet/remote/compression type/=LZ4 /outline/insert into function | OK | 8m 6s |
| /parquet/query/compression type/=NONE /insert into mergetree table from file | OK | 6m 27s |
| /parquet/query/compression type/=GZIP /insert into mergetree table from file | OK | 6m 28s |
| /parquet/query/compression type/=LZ4 /insert into mergetree table from file | OK | 6m 24s |
| /parquet/remote/compression type/=GZIP /outline/select from function | OK | 14m 46s |
| /parquet/remote/compression type/=NONE /outline/select from function | OK | 14m 49s |
| /parquet/remote/compression type/=LZ4 /outline/select from function | OK | 14m 49s |
| /parquet/query/compression type/=NONE /insert into replicated mergetree table from file | OK | 4m 46s |
| /parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file | OK | 4m 47s |
| /parquet/query/compression type/=GZIP /insert into replicated mergetree table from file | OK | 4m 44s |
| /parquet/query/compression type/=NONE /insert into distributed table from file | OK | 4m 6s |
| /parquet/query/compression type/=LZ4 /insert into distributed table from file | OK | 4m 5s |
| /parquet/query/compression type/=GZIP /insert into distributed table from file | OK | 4m 5s |
| /parquet/query/compression type/=NONE /select from memory table into file | OK | 6m 37s |
| /parquet/query/compression type/=LZ4 /select from memory table into file | OK | 6m 36s |
| /parquet/query/compression type/=GZIP /select from memory table into file | OK | 6m 36s |
| /parquet/chunked array | XFail | 17s 960ms |
| /parquet/broken | OK | 548ms |
| /parquet/broken/file | Skip | 48ms |
| /parquet/broken/read broken bigint | Skip | 47ms |
| /parquet/broken/read broken date | Skip | 21ms |
| /parquet/broken/read broken int | Skip | 18ms |
| /parquet/broken/read broken smallint | Skip | 17ms |
| /parquet/broken/read broken timestamp ms | Skip | 18ms |
| /parquet/broken/read broken timestamp us | Skip | 37ms |
| /parquet/broken/read broken tinyint | Skip | 18ms |
| /parquet/broken/read broken ubigint | Skip | 13ms |
| /parquet/broken/read broken uint | Skip | 19ms |
| /parquet/broken/read broken usmallint | Skip | 45ms |
| /parquet/broken/read broken utinyint | Skip | 6ms |
| /parquet/broken/string | Skip | 27ms |
| /parquet/encoding | OK | 1m 3s |
| /parquet/encoding/deltabytearray1 | OK | 9s 328ms |
| /parquet/encoding/deltabytearray2 | OK | 8s 891ms |
| /parquet/encoding/deltalengthbytearray | OK | 8s 647ms |
| /parquet/encoding/dictionary | OK | 9s 59ms |
| /parquet/encoding/plain | OK | 8s 734ms |
| /parquet/encoding/plainrlesnappy | OK | 9s 952ms |
| /parquet/encoding/rleboolean | OK | 8s 661ms |
| /parquet/compression | OK | 3m 8s |
| /parquet/compression/arrow snappy | OK | 8s 770ms |
| /parquet/compression/brotli | OK | 9s 251ms |
| /parquet/compression/gzippages | OK | 18s 581ms |
| /parquet/compression/largegzip | OK | 9s 786ms |
| /parquet/compression/lz4 hadoop | OK | 9s 71ms |
| /parquet/compression/lz4 hadoop large | OK | 9s 325ms |
| /parquet/compression/lz4 non hadoop | OK | 9s 40ms |
| /parquet/compression/lz4 raw | OK | 9s 207ms |
| /parquet/compression/lz4 raw large | OK | 9s 77ms |
| /parquet/compression/lz4pages | OK | 17s 776ms |
| /parquet/compression/nonepages | OK | 17s 431ms |
| /parquet/compression/snappypages | OK | 17s 757ms |
| /parquet/compression/snappyplain | OK | 8s 297ms |
| /parquet/compression/snappyrle | OK | 8s 686ms |
| /parquet/compression/zstd | OK | 8s 775ms |
| /parquet/compression/zstdpages | OK | 17s 193ms |
| /parquet/datatypes | OK | 8m 26s |
| /parquet/datatypes/arrowtimestamp | OK | 7s 771ms |
| /parquet/datatypes/arrowtimestampms | OK | 10s 245ms |
| /parquet/datatypes/binary | OK | 7s 875ms |
| /parquet/datatypes/binary string | OK | 10s 946ms |
| /parquet/query/compression type/=GZIP /select from mergetree table into file | OK | 4m 2s |
| /parquet/query/compression type/=LZ4 /select from mergetree table into file | OK | 4m 0s |
| /parquet/query/compression type/=NONE /select from mergetree table into file | OK | 4m 1s |
| /parquet/datatypes/blob | OK | 7s 796ms |
| /parquet/datatypes/boolean | OK | 16s 647ms |
| /parquet/datatypes/byte array | OK | 8s 493ms |
| /parquet/datatypes/columnname | OK | 8s 334ms |
| /parquet/datatypes/columnwithnull | OK | 8s 641ms |
| /parquet/datatypes/columnwithnull2 | OK | 8s 724ms |
| /parquet/datatypes/date | OK | 8s 829ms |
| /parquet/datatypes/decimal with filter | OK | 8s 700ms |
| /parquet/datatypes/decimalvariousfilters | OK | 8s 334ms |
| /parquet/datatypes/decimalwithfilter2 | OK | 10s 279ms |
| /parquet/datatypes/enum | OK | 8s 204ms |
| /parquet/datatypes/enum2 | OK | 8s 42ms |
| /parquet/datatypes/fixed length decimal | OK | 8s 199ms |
| /parquet/datatypes/fixed length decimal legacy | OK | 8s 95ms |
| /parquet/datatypes/fixedstring | OK | 8s 315ms |
| /parquet/datatypes/float16 | XFail | 607ms |
| /parquet/datatypes/h2oai | OK | 8s 381ms |
| /parquet/datatypes/hive | OK | 16s 538ms |
| /parquet/datatypes/int32 | OK | 8s 366ms |
| /parquet/datatypes/int32 decimal | OK | 8s 175ms |
| /parquet/datatypes/int64 | OK | 8s 80ms |
| /parquet/datatypes/int64 decimal | OK | 7s 966ms |
| /parquet/datatypes/json | OK | 8s 622ms |
| /parquet/datatypes/large string map | XFail | 8s 121ms |
| /parquet/datatypes/largedouble | OK | 8s 123ms |
| /parquet/datatypes/manydatatypes | OK | 8s 509ms |
| /parquet/datatypes/manydatatypes2 | OK | 8s 625ms |
| /parquet/datatypes/maps | OK | 9s 314ms |
| /parquet/query/compression type/=LZ4 /select from replicated mergetree table into file | OK | 3m 40s |
| /parquet/query/compression type/=NONE /select from replicated mergetree table into file | OK | 3m 41s |
| /parquet/query/compression type/=GZIP /select from replicated mergetree table into file | OK | 3m 40s |
| /parquet/complex | OK | 2m 56s |
| /parquet/complex/arraystring | OK | 15s 301ms |
| /parquet/datatypes/nameswithemoji | OK | 12s 730ms |
| /parquet/datatypes/nandouble | OK | 11s 666ms |
| /parquet/complex/big tuple with nulls | OK | 11s 668ms |
| /parquet/datatypes/negativeint64 | OK | 8s 541ms |
| /parquet/complex/bytearraydictionary | OK | 8s 649ms |
| /parquet/datatypes/nullbyte | OK | 9s 975ms |
| /parquet/complex/complex null | OK | 9s 819ms |
| /parquet/datatypes/nullbytemultiple | OK | 8s 161ms |
| /parquet/complex/lagemap | OK | 8s 216ms |
| /parquet/datatypes/nullsinid | OK | 7s 723ms |
| /parquet/complex/largenestedarray | OK | 7s 834ms |
| /parquet/datatypes/pandasdecimal | OK | 7s 859ms |
| /parquet/complex/largestruct | OK | 7s 767ms |
| /parquet/datatypes/pandasdecimaldate | OK | 9s 55ms |
| /parquet/complex/largestruct2 | OK | 9s 21ms |
| /parquet/cache | OK | 20s 596ms |
| /parquet/cache/cache1 | OK | 10s 759ms |
| /parquet/datatypes/parquetgo | OK | 8s 278ms |
| /parquet/complex/largestruct3 | OK | 8s 353ms |
| /parquet/cache/cache2 | OK | 9s 833ms |
| /parquet/datatypes/selectdatewithfilter | OK | 23s 455ms |
| /parquet/complex/list | OK | 9s 799ms |
| /parquet/glob | OK | 56s 251ms |
| /parquet/glob/fastparquet globs | OK | 12s 745ms |
| /parquet/complex/nested array | OK | 7s 844ms |
| /parquet/complex/nested map | OK | 7s 928ms |
| /parquet/glob/glob1 | OK | 2s 527ms |
| /parquet/glob/glob2 | OK | 2s 297ms |
| /parquet/datatypes/singlenull | OK | 8s 11ms |
| /parquet/glob/glob with multiple elements | OK | 414ms |
| /parquet/complex/nestedallcomplex | OK | 8s 508ms |
| /parquet/glob/million extensions | OK | 38s 261ms |
| /parquet/datatypes/sparkv21 | OK | 8s 602ms |
| /parquet/complex/nestedarray2 | OK | 8s 721ms |
| /parquet/datatypes/sparkv22 | OK | 8s 620ms |
| /parquet/complex/nestedstruct | OK | 8s 4ms |
| /parquet/datatypes/statdecimal | OK | 7s 934ms |
| /parquet/complex/nestedstruct2 | OK | 7s 725ms |
| /parquet/datatypes/string | OK | 7s 584ms |
| /parquet/complex/nestedstruct3 | OK | 7s 831ms |
| /parquet/datatypes/string int list inconsistent offset multiple batches | OK | 11s 951ms |
| /parquet/rowgroups | OK | 16s 67ms |
| /parquet/rowgroups/manyrowgroups | OK | 7s 973ms |
| /parquet/complex/nestedstruct4 | OK | 8s 345ms |
| /parquet/rowgroups/manyrowgroups2 | OK | 8s 91ms |
| /parquet/complex/tupleofnulls | OK | 7s 829ms |
| /parquet/datatypes/stringtypes | OK | 7s 652ms |
| /parquet/encrypted | Skip | 2ms |
| /parquet/fastparquet | OK | 13ms |
| /parquet/fastparquet/airlines | Skip | 1ms |
| /parquet/fastparquet/baz | Skip | 1ms |
| /parquet/fastparquet/empty date | Skip | 1ms |
| /parquet/fastparquet/evo | Skip | 4ms |
| /parquet/fastparquet/fastparquet | Skip | 1ms |
| /parquet/read and write | OK | 16m 55s |
| /parquet/read and write/read and write parquet file | OK | 16m 55s |
| /parquet/complex/tuplewithdatetime | OK | 7s 766ms |
| /parquet/datatypes/struct | OK | 7s 980ms |
| /parquet/column related errors | OK | 2s 481ms |
| /parquet/column related errors/check error with 500 columns | OK | 2s 479ms |
| /parquet/datatypes/supporteduuid | OK | 8s 259ms |
| /parquet/multi chunk upload | Skip | 29ms |
| /parquet/datatypes/timestamp1 | OK | 8s 91ms |
| /parquet/datatypes/timestamp2 | OK | 7s 910ms |
| /parquet/datatypes/timezone | OK | 8s 28ms |
| /parquet/datatypes/unsigned | OK | 15s 834ms |
| /parquet/query/compression type/=LZ4 /select from distributed table into file | OK | 3m 57s |
| /parquet/query/compression type/=NONE /select from distributed table into file | OK | 3m 56s |
| /parquet/query/compression type/=GZIP /select from distributed table into file | OK | 3m 57s |
| /parquet/datatypes/unsupportednull | OK | 154ms |
| /parquet/query/compression type/=LZ4 /select from mat view into file | OK | 3m 46s |
| /parquet/query/compression type/=NONE /select from mat view into file | OK | 3m 45s |
| /parquet/query/compression type/=GZIP /select from mat view into file | OK | 3m 44s |
| /parquet/query/compression type/=LZ4 /insert into table with projection from file | OK | 1m 37s |
| /parquet/query/compression type/=NONE /insert into table with projection from file | OK | 1m 37s |
| /parquet/query/compression type/=GZIP /insert into table with projection from file | OK | 1m 37s |
| /parquet/aws s3 | OK | 10m 49s |
| /parquet/aws s3/s3 | OK | 10m 49s |
| /parquet/aws s3/s3/compression type | OK | 10m 49s |
| /parquet/aws s3/s3/compression type/=NONE | OK | 10m 45s |
| /parquet/aws s3/s3/compression type/=NONE /outline | OK | 10m 45s |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine | OK | 58ms |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine/insert into engine | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine/select from engine | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine/engine to file to engine | Skip | 7ms |
| /parquet/aws s3/s3/compression type/=GZIP | OK | 10m 49s |
| /parquet/aws s3/s3/compression type/=GZIP /outline | OK | 10m 49s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine | OK | 127ms |
| /parquet/aws s3/s3/compression type/=LZ4 | OK | 10m 46s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline | OK | 10m 46s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine | OK | 67ms |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine/insert into engine | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine/insert into engine from file | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine/engine select output to file | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/insert into engine | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine/select from engine | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine/engine to file to engine | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/select from engine | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/engine to file to engine | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/insert into engine from file | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/engine select output to file | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine/insert into engine from file | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine/engine select output to file | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=NONE /outline/function | OK | 10m 45s |
| /parquet/aws s3/s3/compression type/=NONE /outline/function/insert into function | OK | 5m 44s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/function | OK | 10m 46s |
| /parquet/aws s3/s3/compression type/=NONE /outline/function/select from function manual cast types | OK | 10m 45s |
| /parquet/aws s3/s3/compression type/=NONE /outline/function/select from function auto cast types | OK | 5m 23s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/function | OK | 10m 48s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/function/insert into function | OK | 5m 43s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/function/insert into function | OK | 5m 43s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/function/select from function manual cast types | OK | 10m 48s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/function/select from function auto cast types | OK | 5m 20s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/function/select from function manual cast types | OK | 10m 46s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/function/select from function auto cast types | OK | 5m 22s |
Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922