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 | Apr 04, 2025 12:43 |
| Duration | 1h 3m |
| Framework | TestFlows 2.0.250110.1002922 |
Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#712/e61e67ac3bb5ac74ba8cf868764defd70e08f8d8/regression/aarch64/with_analyzer/zookeeper/without_thread_fuzzer/parquetaws_s3/
| project | Altinity/ClickHouse |
| project.id | 159717931 |
| package | https://s3.amazonaws.com/altinity-build-artifacts/PRs/712/e61e67ac3bb5ac74ba8cf868764defd70e08f8d8/package_aarch64/clickhouse-common-static_24.12.2.20230.altinityantalya_arm64.deb |
| version | 24.12.2.20230.altinityantalya |
| user.name | ianton-ru |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | bd31e738c0cedaca253d15a05ed245c41b6e0b6a |
| job.name | ParquetS3 |
| job.retry | 1 |
| job.url | https://github.com/Altinity/ClickHouse/actions/runs/14264141153 |
| arch | aarch64 |
| local | True |
| clickhouse_version | None |
| clickhouse_path | https://s3.amazonaws.com/altinity-build-artifacts/PRs/712/e61e67ac3bb5ac74ba8cf868764defd70e08f8d8/package_aarch64/clickhouse-common-static_24.12.2.20230.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/=LZ4 /postgresql engine to parquet file to postgresql engine | XFail 38s 742ms This fails because of the difference in snapshot values. We used to capture the datetime value `0` be converted as 2106-02-07 06:28:16 instead of the correct 1970-01-01 01:00:00. But when steps are repeated manually, we can not reproduce it | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 827, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 897, in execute_query
assert that(snapshot_result), error()
^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert that(snapshot_result), error()
Assertion values
assert that(snapshot_result), error()
^ is = SnapshotError(
filename=/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
name=_parquet_postgresql_compression_type__LZ4__postgresql_engine_to_parquet_file_to_postgresql_engine_I_check_the_data_on_the_table_datetime
snapshot_value="""
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
{"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
{"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
{"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
{"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
{"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
""",
actual_value="""
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
{"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
{"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
{"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
{"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
{"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
""",
diff="""
--- /home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
+++
@@ -1,6 +1,6 @@
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
-{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
+{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
""")
assert that(snapshot_result), error()
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 897 in 'execute_query'
889\| with values() as that:
890\| snapshot_result = snapshot(
891\| "\n" + r.output.strip() + "\n",
892\| id=snapshot_id,
893\| name=snapshot_name,
894\| encoder=str,
895\| mode=snapshot.CHECK,
896\| )
897\|> assert that(snapshot_result), error() |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | XFail 39s 395ms This fails because of the difference in snapshot values. We used to capture the datetime value `0` be converted as 2106-02-07 06:28:16 instead of the correct 1970-01-01 01:00:00. But when steps are repeated manually, we can not reproduce it | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 827, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 897, in execute_query
assert that(snapshot_result), error()
^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert that(snapshot_result), error()
Assertion values
assert that(snapshot_result), error()
^ is = SnapshotError(
filename=/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
name=_parquet_postgresql_compression_type__GZIP__postgresql_engine_to_parquet_file_to_postgresql_engine_I_check_the_data_on_the_table_datetime
snapshot_value="""
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
{"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
{"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
{"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
{"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
{"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
""",
actual_value="""
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
{"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
{"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
{"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
{"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
{"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
""",
diff="""
--- /home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
+++
@@ -1,6 +1,6 @@
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
-{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
+{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
""")
assert that(snapshot_result), error()
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 897 in 'execute_query'
889\| with values() as that:
890\| snapshot_result = snapshot(
891\| "\n" + r.output.strip() + "\n",
892\| id=snapshot_id,
893\| name=snapshot_name,
894\| encoder=str,
895\| mode=snapshot.CHECK,
896\| )
897\|> assert that(snapshot_result), error() |
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | XFail 40s 52ms This fails because of the difference in snapshot values. We used to capture the datetime value `0` be converted as 2106-02-07 06:28:16 instead of the correct 1970-01-01 01:00:00. But when steps are repeated manually, we can not reproduce it | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 827, in execute_query_step
execute_query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py", line 897, in execute_query
assert that(snapshot_result), error()
^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert that(snapshot_result), error()
Assertion values
assert that(snapshot_result), error()
^ is = SnapshotError(
filename=/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
name=_parquet_postgresql_compression_type__NONE__postgresql_engine_to_parquet_file_to_postgresql_engine_I_check_the_data_on_the_table_datetime
snapshot_value="""
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
{"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
{"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
{"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
{"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
{"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
""",
actual_value="""
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
{"datetime":"2011-09-30 02:34:30","toTypeName(datetime)":"DateTime"}
{"datetime":"2019-04-27 02:01:34","toTypeName(datetime)":"DateTime"}
{"datetime":"2017-02-11 09:09:25","toTypeName(datetime)":"DateTime"}
{"datetime":"2009-06-14 11:12:39","toTypeName(datetime)":"DateTime"}
{"datetime":"2020-01-24 15:10:50","toTypeName(datetime)":"DateTime"}
""",
diff="""
--- /home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/snapshots/common.py.postgresql engine to parquet file to postgresql engine.snapshot
+++
@@ -1,6 +1,6 @@
{"datetime":"2106-02-07 06:28:15","toTypeName(datetime)":"DateTime"}
-{"datetime":"2106-02-07 06:28:16","toTypeName(datetime)":"DateTime"}
+{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"1970-01-01 01:00:00","toTypeName(datetime)":"DateTime"}
{"datetime":"2006-11-27 02:50:49","toTypeName(datetime)":"DateTime"}
{"datetime":"2015-06-29 09:43:07","toTypeName(datetime)":"DateTime"}
""")
assert that(snapshot_result), error()
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/common.py', line 897 in 'execute_query'
889\| with values() as that:
890\| snapshot_result = snapshot(
891\| "\n" + r.output.strip() + "\n",
892\| id=snapshot_id,
893\| name=snapshot_name,
894\| encoder=str,
895\| mode=snapshot.CHECK,
896\| )
897\|> assert that(snapshot_result), error() |
| /parquet/chunked array | XFail 16s 148ms Not supported | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/chunked_array.py", line 30, in feature
node.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py", line 1188, in query
assert False, error(r.output)
^^^^^
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert False, error(r.output)
Description
Error on processing query: Code: 33. DB::Exception: Error while reading Parquet data: NotImplemented: Nested data conversions not implemented for chunked array outputs: (in file/uri /var/lib/clickhouse/user_files/chunked_array_test_file.parquet): While executing ParquetBlockInputFormat: While executing File: data for INSERT was parsed from file. (CANNOT_READ_ALL_DATA) (version 24.12.2.20230.altinityantalya (altinity build))
(query: INSERT INTO table_57a7a07f_1156_11f0_a7b2_96000431c4a4 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 480ms ClickHouse does not import FLOAT16 properly | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 929, in feature
scenario()
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 113, in float16
assert output == expected, error()
^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert output == expected, error()
Assertion values
assert output == expected, error()
^ is '[-0,0,32,2052,32838,0,0,0,0,0,0]'
assert output == expected, error()
^ is '[-2,-1,0,1,2,3,4,5,6,7,8,9]'
assert output == expected, error()
^ is = False
@@ -1 +1 @@
-[-0,0,32,2052,32838,0,0,0,0,0,0]
+[-2,-1,0,1,2,3,4,5,6,7,8,9]
assert output == expected, error()
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py', line 113 in 'float16'
105\| ORDER BY tuple() AS SELECT floatfield FROM file('{import_file}', Parquet)
106\| """
107\| )
108\|
109\| with Then("I read the contents of the created table"):
110\| output = node.query(
111\| f"SELECT groupArray(round(*)) FROM {table_name} FORMAT TSV"
112\| ).output
113\|> assert output == expected, error()
114\|
115\| finally:
116\| with Finally("I drop the table"): |
| /parquet/datatypes/large string map | XFail 7s 916ms Will fail until the, https://github.com/apache/arrow/pull/35825, gets merged. | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 929, in feature
scenario()
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 801, in large_string_map
import_export(snapshot_name="large_string_map_structure", import_file=import_file)
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/outline.py", line 36, in import_export
node.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py", line 1188, in query
assert False, error(r.output)
^^^^^
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert False, error(r.output)
Description
Received exception from server (version 24.12.2):
Code: 33. DB::Exception: Received from localhost:9000. DB::Exception: Error while reading Parquet data: NotImplemented: Nested data conversions not implemented for chunked array outputs: (in file/uri /var/lib/clickhouse/user_files/arrow/large_string_map.brotli.parquet): While executing ParquetBlockInputFormat: While executing File. (CANNOT_READ_ALL_DATA)
(query: CREATE TABLE table_5e394970_1157_11f0_89ef_96000431c4a4
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 3m |
| /parquet/file | OK | 32m 51s |
| /parquet/file/engine | OK | 32m 51s |
| /parquet/file/function | OK | 17m 6s |
| /parquet/file/engine/insert into engine | OK | 20m 55s |
| /parquet/file/engine/select from engine | OK | 10m 10s |
| /parquet/query | OK | 44m 25s |
| /parquet/file/engine/engine to file to engine | OK | 28m 32s |
| /parquet/file/engine/insert into engine from file | OK | 20m 14s |
| /parquet/file/engine/engine select output to file | OK | 32m 51s |
| /parquet/list in multiple chunks | OK | 1m 6s |
| /parquet/url | OK | 33m 35s |
| /parquet/query/compression type | OK | 44m 25s |
| /parquet/file/function/insert into function manual cast types | OK | 16m 42s |
| /parquet/file/function/insert into function auto cast types | OK | 17m 6s |
| /parquet/file/function/select from function manual cast types | OK | 16m 14s |
| /parquet/query/compression type/=NONE | OK | 44m 24s |
| /parquet/query/compression type/=GZIP | OK | 44m 24s |
| /parquet/file/function/select from function auto cast types | OK | 10m 10s |
| /parquet/query/compression type/=LZ4 | OK | 44m 25s |
| /parquet/query/compression type/=NONE /insert into memory table from file | OK | 9m 45s |
| /parquet/query/compression type/=GZIP /insert into memory table from file | OK | 9m 44s |
| /parquet/query/compression type/=LZ4 /insert into memory table from file | OK | 9m 43s |
| /parquet/url/engine | OK | 32m 43s |
| /parquet/url/function | OK | 31m 56s |
| /parquet/url/engine/insert into engine | OK | 21m 4s |
| /parquet/url/function/insert into function | OK | 16m 21s |
| /parquet/url/function/select from function manual cast types | OK | 31m 56s |
| /parquet/url/engine/select from engine | OK | 9m 59s |
| /parquet/url/engine/engine to file to engine | OK | 28m 22s |
| /parquet/url/engine/insert into engine from file | OK | 27m 31s |
| /parquet/url/engine/engine select output to file | OK | 32m 43s |
| /parquet/url/function/select from function auto cast types | OK | 16m 5s |
| /parquet/mysql | OK | 1m 57s |
| /parquet/mysql/compression type | OK | 1m 57s |
| /parquet/mysql/compression type/=NONE | OK | 1m 56s |
| /parquet/mysql/compression type/=GZIP | OK | 1m 57s |
| /parquet/mysql/compression type/=LZ4 | OK | 1m 55s |
| /parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine | OK | 1m 21s |
| /parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine | OK | 1m 21s |
| /parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine | OK | 1m 21s |
| /parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function | OK | 34s 332ms |
| /parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function | OK | 35s 948ms |
| /parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function | OK | 34s 669ms |
| /parquet/postgresql | OK | 1m 12s |
| /parquet/postgresql/compression type | OK | 1m 12s |
| /parquet/postgresql/compression type/=NONE | OK | 1m 12s |
| /parquet/postgresql/compression type/=GZIP | OK | 1m 11s |
| /parquet/postgresql/compression type/=LZ4 | OK | 1m 11s |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | XFail | 38s 742ms |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | XFail | 39s 395ms |
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | XFail | 40s 52ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function | OK | 32s 219ms |
| /parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function | OK | 31s 989ms |
| /parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function | OK | 32s 64ms |
| /parquet/remote | OK | 20m 21s |
| /parquet/remote/compression type | OK | 20m 21s |
| /parquet/remote/compression type/=NONE | OK | 20m 21s |
| /parquet/remote/compression type/=GZIP | OK | 20m 21s |
| /parquet/remote/compression type/=LZ4 | OK | 20m 21s |
| /parquet/remote/compression type/=NONE /outline | OK | 20m 20s |
| /parquet/remote/compression type/=GZIP /outline | OK | 20m 21s |
| /parquet/remote/compression type/=LZ4 /outline | OK | 20m 21s |
| /parquet/remote/compression type/=NONE /outline/insert into function | OK | 7m 22s |
| /parquet/remote/compression type/=GZIP /outline/insert into function | OK | 7m 20s |
| /parquet/remote/compression type/=LZ4 /outline/insert into function | OK | 7m 18s |
| /parquet/query/compression type/=LZ4 /insert into mergetree table from file | OK | 5m 49s |
| /parquet/query/compression type/=GZIP /insert into mergetree table from file | OK | 5m 46s |
| /parquet/query/compression type/=NONE /insert into mergetree table from file | OK | 5m 47s |
| /parquet/remote/compression type/=LZ4 /outline/select from function | OK | 13m 2s |
| /parquet/remote/compression type/=GZIP /outline/select from function | OK | 13m 0s |
| /parquet/remote/compression type/=NONE /outline/select from function | OK | 12m 58s |
| /parquet/query/compression type/=GZIP /insert into replicated mergetree table from file | OK | 4m 16s |
| /parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file | OK | 4m 15s |
| /parquet/query/compression type/=NONE /insert into replicated mergetree table from file | OK | 4m 16s |
| /parquet/query/compression type/=GZIP /insert into distributed table from file | OK | 3m 38s |
| /parquet/query/compression type/=LZ4 /insert into distributed table from file | OK | 3m 38s |
| /parquet/query/compression type/=NONE /insert into distributed table from file | OK | 3m 37s |
| /parquet/query/compression type/=NONE /select from memory table into file | OK | 5m 48s |
| /parquet/query/compression type/=GZIP /select from memory table into file | OK | 5m 48s |
| /parquet/query/compression type/=LZ4 /select from memory table into file | OK | 5m 46s |
| /parquet/chunked array | XFail | 16s 148ms |
| /parquet/broken | OK | 410ms |
| /parquet/broken/file | Skip | 9ms |
| /parquet/broken/read broken bigint | Skip | 24ms |
| /parquet/broken/read broken date | Skip | 11ms |
| /parquet/broken/read broken int | Skip | 16ms |
| /parquet/broken/read broken smallint | Skip | 19ms |
| /parquet/broken/read broken timestamp ms | Skip | 57ms |
| /parquet/broken/read broken timestamp us | Skip | 12ms |
| /parquet/broken/read broken tinyint | Skip | 13ms |
| /parquet/broken/read broken ubigint | Skip | 18ms |
| /parquet/broken/read broken uint | Skip | 20ms |
| /parquet/broken/read broken usmallint | Skip | 12ms |
| /parquet/broken/read broken utinyint | Skip | 32ms |
| /parquet/broken/string | Skip | 16ms |
| /parquet/encoding | OK | 57s 82ms |
| /parquet/encoding/deltabytearray1 | OK | 8s 855ms |
| /parquet/encoding/deltabytearray2 | OK | 8s 165ms |
| /parquet/encoding/deltalengthbytearray | OK | 8s 14ms |
| /parquet/encoding/dictionary | OK | 7s 715ms |
| /parquet/encoding/plain | OK | 7s 737ms |
| /parquet/encoding/plainrlesnappy | OK | 8s 762ms |
| /parquet/encoding/rleboolean | OK | 7s 776ms |
| /parquet/compression | OK | 2m 42s |
| /parquet/compression/arrow snappy | OK | 7s 930ms |
| /parquet/compression/brotli | OK | 8s 11ms |
| /parquet/compression/gzippages | OK | 15s 316ms |
| /parquet/compression/largegzip | OK | 7s 837ms |
| /parquet/compression/lz4 hadoop | OK | 7s 675ms |
| /parquet/compression/lz4 hadoop large | OK | 7s 724ms |
| /parquet/compression/lz4 non hadoop | OK | 7s 925ms |
| /parquet/compression/lz4 raw | OK | 7s 721ms |
| /parquet/compression/lz4 raw large | OK | 7s 962ms |
| /parquet/compression/lz4pages | OK | 15s 338ms |
| /parquet/compression/nonepages | OK | 15s 173ms |
| /parquet/compression/snappypages | OK | 15s 177ms |
| /parquet/compression/snappyplain | OK | 7s 409ms |
| /parquet/compression/snappyrle | OK | 7s 819ms |
| /parquet/compression/zstd | OK | 7s 713ms |
| /parquet/compression/zstdpages | OK | 15s 311ms |
| /parquet/datatypes | OK | 7m 19s |
| /parquet/datatypes/arrowtimestamp | OK | 7s 186ms |
| /parquet/datatypes/arrowtimestampms | OK | 6s 929ms |
| /parquet/datatypes/binary | OK | 9s 503ms |
| /parquet/datatypes/binary string | OK | 9s 87ms |
| /parquet/datatypes/blob | OK | 7s 187ms |
| /parquet/query/compression type/=LZ4 /select from mergetree table into file | OK | 3m 37s |
| /parquet/datatypes/boolean | OK | 6s 818ms |
| /parquet/query/compression type/=NONE /select from mergetree table into file | OK | 3m 36s |
| /parquet/query/compression type/=GZIP /select from mergetree table into file | OK | 3m 39s |
| /parquet/datatypes/byte array | OK | 8s 942ms |
| /parquet/datatypes/columnname | OK | 12s 9ms |
| /parquet/datatypes/columnwithnull | OK | 7s 558ms |
| /parquet/datatypes/columnwithnull2 | OK | 7s 94ms |
| /parquet/datatypes/date | OK | 7s 87ms |
| /parquet/datatypes/decimal with filter | OK | 7s 594ms |
| /parquet/datatypes/decimalvariousfilters | OK | 7s 66ms |
| /parquet/datatypes/decimalwithfilter2 | OK | 7s 254ms |
| /parquet/datatypes/enum | OK | 6s 954ms |
| /parquet/datatypes/enum2 | OK | 7s 80ms |
| /parquet/datatypes/fixed length decimal | OK | 7s 240ms |
| /parquet/datatypes/fixed length decimal legacy | OK | 7s 68ms |
| /parquet/datatypes/fixedstring | OK | 7s 467ms |
| /parquet/datatypes/float16 | XFail | 480ms |
| /parquet/datatypes/h2oai | OK | 7s 241ms |
| /parquet/datatypes/hive | OK | 14s 106ms |
| /parquet/datatypes/int32 | OK | 7s 218ms |
| /parquet/datatypes/int32 decimal | OK | 7s 29ms |
| /parquet/datatypes/int64 | OK | 7s 85ms |
| /parquet/datatypes/int64 decimal | OK | 7s 243ms |
| /parquet/datatypes/json | OK | 7s 69ms |
| /parquet/datatypes/large string map | XFail | 7s 916ms |
| /parquet/datatypes/largedouble | OK | 7s 489ms |
| /parquet/datatypes/manydatatypes | OK | 7s 791ms |
| /parquet/datatypes/manydatatypes2 | OK | 7s 585ms |
| /parquet/datatypes/maps | OK | 6s 994ms |
| /parquet/datatypes/nameswithemoji | OK | 7s 73ms |
| /parquet/datatypes/nandouble | OK | 7s 98ms |
| /parquet/query/compression type/=LZ4 /select from replicated mergetree table into file | OK | 3m 19s |
| /parquet/datatypes/negativeint64 | OK | 7s 666ms |
| /parquet/query/compression type/=NONE /select from replicated mergetree table into file | OK | 3m 20s |
| /parquet/complex | OK | 2m 34s |
| /parquet/complex/arraystring | OK | 9s 465ms |
| /parquet/query/compression type/=GZIP /select from replicated mergetree table into file | OK | 3m 18s |
| /parquet/datatypes/nullbyte | OK | 13s 10ms |
| /parquet/complex/big tuple with nulls | OK | 16s 111ms |
| /parquet/datatypes/nullbytemultiple | OK | 8s 588ms |
| /parquet/complex/bytearraydictionary | OK | 6s 853ms |
| /parquet/datatypes/nullsinid | OK | 6s 860ms |
| /parquet/complex/complex null | OK | 7s 8ms |
| /parquet/datatypes/pandasdecimal | OK | 7s 688ms |
| /parquet/complex/lagemap | OK | 8s 686ms |
| /parquet/datatypes/pandasdecimaldate | OK | 8s 49ms |
| /parquet/cache | OK | 15s 969ms |
| /parquet/cache/cache1 | OK | 8s 744ms |
| /parquet/complex/largenestedarray | OK | 6s 925ms |
| /parquet/datatypes/parquetgo | OK | 6s 843ms |
| /parquet/cache/cache2 | OK | 7s 223ms |
| /parquet/complex/largestruct | OK | 7s 46ms |
| /parquet/datatypes/selectdatewithfilter | OK | 22s 394ms |
| /parquet/glob | OK | 49s 28ms |
| /parquet/glob/fastparquet globs | OK | 9s 249ms |
| /parquet/complex/largestruct2 | OK | 7s 222ms |
| /parquet/complex/largestruct3 | OK | 7s 252ms |
| /parquet/glob/glob1 | OK | 2s 587ms |
| /parquet/glob/glob2 | OK | 3s 455ms |
| /parquet/glob/glob with multiple elements | OK | 541ms |
| /parquet/glob/million extensions | OK | 33s 163ms |
| /parquet/complex/list | OK | 7s 107ms |
| /parquet/datatypes/singlenull | OK | 6s 862ms |
| /parquet/complex/nested array | OK | 6s 777ms |
| /parquet/datatypes/sparkv21 | OK | 6s 781ms |
| /parquet/complex/nested map | OK | 6s 889ms |
| /parquet/datatypes/sparkv22 | OK | 6s 794ms |
| /parquet/complex/nestedallcomplex | OK | 7s 208ms |
| /parquet/datatypes/statdecimal | OK | 6s 788ms |
| /parquet/complex/nestedarray2 | OK | 6s 897ms |
| /parquet/datatypes/string | OK | 6s 988ms |
| /parquet/rowgroups | OK | 13s 815ms |
| /parquet/rowgroups/manyrowgroups | OK | 6s 865ms |
| /parquet/complex/nestedstruct | OK | 6s 948ms |
| /parquet/datatypes/string int list inconsistent offset multiple batches | OK | 13s 29ms |
| /parquet/rowgroups/manyrowgroups2 | OK | 6s 940ms |
| /parquet/complex/nestedstruct2 | OK | 7s 834ms |
| /parquet/encrypted | Skip | 1ms |
| /parquet/fastparquet | OK | 16ms |
| /parquet/fastparquet/airlines | Skip | 1ms |
| /parquet/fastparquet/baz | Skip | 6ms |
| /parquet/fastparquet/empty date | Skip | 2ms |
| /parquet/fastparquet/evo | Skip | 1ms |
| /parquet/fastparquet/fastparquet | Skip | 1ms |
| /parquet/read and write | OK | 14m 47s |
| /parquet/read and write/read and write parquet file | OK | 14m 47s |
| /parquet/complex/nestedstruct3 | OK | 6s 954ms |
| /parquet/datatypes/stringtypes | OK | 6s 904ms |
| /parquet/complex/nestedstruct4 | OK | 7s 203ms |
| /parquet/datatypes/struct | OK | 7s 110ms |
| /parquet/complex/tupleofnulls | OK | 7s 61ms |
| /parquet/datatypes/supporteduuid | OK | 6s 910ms |
| /parquet/complex/tuplewithdatetime | OK | 7s 132ms |
| /parquet/datatypes/timestamp1 | OK | 6s 620ms |
| /parquet/column related errors | OK | 2s 84ms |
| /parquet/column related errors/check error with 500 columns | OK | 2s 81ms |
| /parquet/datatypes/timestamp2 | OK | 6s 626ms |
| /parquet/multi chunk upload | Skip | 15ms |
| /parquet/datatypes/timezone | OK | 6s 796ms |
| /parquet/datatypes/unsigned | OK | 13s 599ms |
| /parquet/datatypes/unsupportednull | OK | 372ms |
| /parquet/query/compression type/=LZ4 /select from distributed table into file | OK | 3m 38s |
| /parquet/query/compression type/=NONE /select from distributed table into file | OK | 3m 38s |
| /parquet/query/compression type/=GZIP /select from distributed table into file | OK | 3m 37s |
| /parquet/query/compression type/=LZ4 /select from mat view into file | OK | 3m 10s |
| /parquet/query/compression type/=GZIP /select from mat view into file | OK | 3m 8s |
| /parquet/query/compression type/=NONE /select from mat view into file | OK | 3m 8s |
| /parquet/query/compression type/=GZIP /insert into table with projection from file | OK | 1m 26s |
| /parquet/query/compression type/=NONE /insert into table with projection from file | OK | 1m 26s |
| /parquet/query/compression type/=LZ4 /insert into table with projection from file | OK | 1m 25s |
| /parquet/aws s3 | OK | 9m 40s |
| /parquet/aws s3/s3 | OK | 9m 40s |
| /parquet/aws s3/s3/compression type | OK | 9m 40s |
| /parquet/aws s3/s3/compression type/=NONE | OK | 9m 40s |
| /parquet/aws s3/s3/compression type/=NONE /outline | OK | 9m 40s |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine | OK | 171ms |
| /parquet/aws s3/s3/compression type/=GZIP | OK | 9m 39s |
| /parquet/aws s3/s3/compression type/=GZIP /outline | OK | 9m 39s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine | OK | 65ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/insert into engine | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/select from engine | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/engine to file to engine | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine/insert into engine | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=LZ4 | OK | 9m 39s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline | OK | 9m 39s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine | OK | 27ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/engine/insert into engine from file | Skip | 1ms |
| /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 | Skip | 2ms |
| /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/=NONE /outline/engine/select from engine | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=NONE /outline/engine/engine to file to engine | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine/insert into engine from file | Skip | 2ms |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/engine/engine select output to file | Skip | 1ms |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/function | OK | 9m 39s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/function/insert into function | OK | 5m 18s |
| /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 | 21ms |
| /parquet/aws s3/s3/compression type/=GZIP /outline/function | OK | 9m 39s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/function/select from function manual cast types | OK | 9m 39s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/function/insert into function | OK | 5m 18s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/function/select from function manual cast types | OK | 9m 39s |
| /parquet/aws s3/s3/compression type/=LZ4 /outline/function/select from function auto cast types | OK | 4m 59s |
| /parquet/aws s3/s3/compression type/=GZIP /outline/function/select from function auto cast types | OK | 4m 59s |
| /parquet/aws s3/s3/compression type/=NONE /outline/function | OK | 9m 40s |
| /parquet/aws s3/s3/compression type/=NONE /outline/function/insert into function | OK | 5m 18s |
| /parquet/aws s3/s3/compression type/=NONE /outline/function/select from function manual cast types | OK | 9m 40s |
| /parquet/aws s3/s3/compression type/=NONE /outline/function/select from function auto cast types | OK | 4m 57s |
Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922