Copyright 2024, 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 28, 2024 16:57 |
| Duration | 52m 23s |
| Framework | TestFlows 2.0.231215.1221232 |
Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#0/false/regression/
| project | Altinity/ClickHouse |
| project.id | 159717931 |
| package | https://s3.amazonaws.com/altinity-build-artifacts/23.8/8e9be16153250c8307730c9b88c8517181f494ce/package_release/clickhouse-common-static_23.8.11.29.altinitystable_amd64.deb |
| version | 23.8.11.29.altinitystable |
| user.name | Enmk |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | 17a81c07fc1f41fbee651e0ef0ca4b44e537e5b1 |
| job.id | 8868426423 |
| job.url | https://github.com/Altinity/ClickHouse/actions/runs/8868426423 |
| arch | x86_64 |
| node | clickhouse1 |
| allow_vfs | False |
| allow_experimental_analyzer | False |
| local | True |
| clickhouse_version | None |
| clickhouse_binary_path | https://s3.amazonaws.com/altinity-build-artifacts/23.8/8e9be16153250c8307730c9b88c8517181f494ce/package_release/clickhouse-common-static_23.8.11.29.altinitystable_amd64.deb |
| stress | False |
| collect_service_logs | True |
| storages | None |
| minio_uri | http://minio1:9001 |
| minio_root_user | minio |
| minio_root_password | minio123 |
| aws_s3_bucket | None |
| 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 |
| Units | Skip | OK | Fail | XFail | |
|---|---|---|---|---|---|
| Modules | |||||
| Suites | |||||
| Features | |||||
| Scenarios | |||||
| Checks | |||||
| Examples | |||||
| Steps |
| Test Name | Result | Message |
|---|---|---|
| /parquet/chunked array | XFail 15s 265ms Not supported | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.10/threading.py", line 973, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
self.run()
File "/usr/lib/python3.10/threading.py", line 953, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.10/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 844, 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::ParsingException: Error while reading Parquet data: NotImplemented: Nested data conversions not implemented for chunked array outputs: While executing ParquetBlockInputFormat: While executing File: data for INSERT was parsed from file. (CANNOT_READ_ALL_DATA) (version 23.8.11.29.altinitystable (altinity build))
(query: INSERT INTO table_7215eaf3_0583_11ef_a9c4_217a3d74aae3 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 844 in 'query'
836\| assert message in r.output, error(r.output)
837\|
838\| if not ignore_exception:
839\| if message is None or "Exception:" not in message:
840\| with Then("check if output has exception") if steps else NullStep():
841\| if "Exception:" in r.output:
842\| if raise_on_exception:
843\| raise QueryRuntimeException(r.output)
844\|> assert False, error(r.output)
845\|
846\| return r
847\| |
| /parquet/datatypes/large string map | XFail 11s 249ms Will fail until the, https://github.com/apache/arrow/pull/35825, gets merged. | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.10/threading.py", line 973, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
self.run()
File "/usr/lib/python3.10/threading.py", line 953, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.10/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 884, in feature
scenario()
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../parquet/tests/datatypes.py", line 762, 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 34, in import_export
node.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py", line 844, 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 23.8.11):
Code: 33. DB::Exception: Received from localhost:9000. DB::ParsingException. DB::ParsingException: Error while reading Parquet data: NotImplemented: Nested data conversions not implemented for chunked array outputs: While executing ParquetBlockInputFormat: While executing File. (CANNOT_READ_ALL_DATA)
(query: CREATE TABLE table_acd291ab_0583_11ef_a9c4_217a3d74aae3
ENGINE = MergeTree
ORDER BY tuple() AS SELECT * FROM file('arrow/large_string_map.brotli.parquet', Parquet) LIMIT 100
)
Assertion values
assert False, error(r.output)
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/parquet/../helpers/cluster.py', line 844 in 'query'
836\| assert message in r.output, error(r.output)
837\|
838\| if not ignore_exception:
839\| if message is None or "Exception:" not in message:
840\| with Then("check if output has exception") if steps else NullStep():
841\| if "Exception:" in r.output:
842\| if raise_on_exception:
843\| raise QueryRuntimeException(r.output)
844\|> assert False, error(r.output)
845\|
846\| return r
847\| |
| Test Name | Result | Duration |
|---|---|---|
| /parquet | OK | 52m 23s |
| /parquet/file | OK | 48m 41s |
| /parquet/file/engine | OK | 48m 41s |
| /parquet/file/engine/insert into engine | OK | 17m 34s |
| /parquet/file/function | OK | 19m 8s |
| /parquet/file/engine/select from engine | OK | 6m 53s |
| /parquet/file/function/insert into function manual cast types | OK | 13m 53s |
| /parquet/query | OK | 45m 40s |
| /parquet/query/compression type | OK | 45m 40s |
| /parquet/file/function/insert into function auto cast types | OK | 19m 7s |
| /parquet/file/engine/engine to file to engine | OK | 25m 32s |
| /parquet/file/function/select from function manual cast types | OK | 7m 28s |
| /parquet/file/function/select from function auto cast types | OK | 6m 57s |
| /parquet/file/engine/insert into engine from file | OK | 15m 30s |
| /parquet/query/compression type/=NONE | OK | 45m 17s |
| /parquet/query/compression type/=GZIP | OK | 45m 37s |
| /parquet/file/engine/engine select output to file | OK | 48m 41s |
| /parquet/query/compression type/=LZ4 | OK | 45m 40s |
| /parquet/list in multiple chunks | OK | 27s 657ms |
| /parquet/url | OK | 49m 56s |
| /parquet/query/compression type/=NONE /insert into memory table from file | OK | 6m 46s |
| /parquet/query/compression type/=GZIP /insert into memory table from file | OK | 6m 45s |
| /parquet/query/compression type/=LZ4 /insert into memory table from file | OK | 6m 52s |
| /parquet/url/engine | OK | 49m 20s |
| /parquet/url/function | OK | 13m 54s |
| /parquet/url/engine/insert into engine | OK | 21m 55s |
| /parquet/url/engine/select from engine | OK | 6m 57s |
| /parquet/url/function/insert into function | OK | 13m 54s |
| /parquet/url/engine/engine to file to engine | OK | 25m 54s |
| /parquet/url/engine/insert into engine from file | OK | 22m 14s |
| /parquet/url/function/select from function manual cast types | OK | 13m 16s |
| /parquet/url/engine/engine select output to file | OK | 49m 20s |
| /parquet/url/function/select from function auto cast types | OK | 12m 11s |
| /parquet/mysql | OK | 43s 391ms |
| /parquet/mysql/compression type | OK | 43s 197ms |
| /parquet/mysql/compression type/=GZIP | OK | 42s 27ms |
| /parquet/mysql/compression type/=NONE | OK | 43s 148ms |
| /parquet/mysql/compression type/=LZ4 | OK | 42s 307ms |
| /parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine | OK | 23s 450ms |
| /parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine | OK | 24s 909ms |
| /parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine | OK | 24s 563ms |
| /parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function | OK | 18s 285ms |
| /parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function | OK | 17s 339ms |
| /parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function | OK | 17s 871ms |
| /parquet/postgresql | OK | 49s 362ms |
| /parquet/postgresql/compression type | OK | 49s 307ms |
| /parquet/postgresql/compression type/=NONE | OK | 48s 760ms |
| /parquet/postgresql/compression type/=GZIP | OK | 48s 791ms |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | OK | 28s 424ms |
| /parquet/postgresql/compression type/=LZ4 | OK | 49s 58ms |
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | OK | 28s 427ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | OK | 28s 952ms |
| /parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function | OK | 20s 272ms |
| /parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function | OK | 20s 139ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function | OK | 19s 879ms |
| /parquet/remote | OK | 18m 34s |
| /parquet/remote/compression type | OK | 18m 34s |
| /parquet/remote/compression type/=NONE | OK | 18m 30s |
| /parquet/remote/compression type/=GZIP | OK | 18m 31s |
| /parquet/remote/compression type/=LZ4 | OK | 18m 34s |
| /parquet/remote/compression type/=NONE /outline | OK | 18m 30s |
| /parquet/remote/compression type/=GZIP /outline | OK | 18m 31s |
| /parquet/remote/compression type/=LZ4 /outline | OK | 18m 34s |
| /parquet/remote/compression type/=NONE /outline/insert into function | OK | 6m 16s |
| /parquet/remote/compression type/=GZIP /outline/insert into function | OK | 6m 15s |
| /parquet/remote/compression type/=LZ4 /outline/insert into function | OK | 6m 17s |
| /parquet/query/compression type/=GZIP /insert into mergetree table from file | OK | 4m 42s |
| /parquet/query/compression type/=NONE /insert into mergetree table from file | OK | 4m 43s |
| /parquet/query/compression type/=LZ4 /insert into mergetree table from file | OK | 4m 39s |
| /parquet/remote/compression type/=GZIP /outline/select from function | OK | 12m 16s |
| /parquet/remote/compression type/=NONE /outline/select from function | OK | 12m 13s |
| /parquet/remote/compression type/=LZ4 /outline/select from function | OK | 12m 16s |
| /parquet/query/compression type/=GZIP /insert into replicated mergetree table from file | OK | 3m 50s |
| /parquet/query/compression type/=NONE /insert into replicated mergetree table from file | OK | 3m 49s |
| /parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file | OK | 3m 49s |
| /parquet/query/compression type/=GZIP /insert into distributed table from file | OK | 3m 0s |
| /parquet/query/compression type/=NONE /insert into distributed table from file | OK | 3m 0s |
| /parquet/query/compression type/=LZ4 /insert into distributed table from file | OK | 2m 59s |
| /parquet/query/compression type/=GZIP /select from memory table into file | OK | 6m 2s |
| /parquet/query/compression type/=NONE /select from memory table into file | OK | 6m 1s |
| /parquet/query/compression type/=LZ4 /select from memory table into file | OK | 6m 3s |
| /parquet/chunked array | XFail | 15s 265ms |
| /parquet/broken | OK | 16ms |
| /parquet/broken/file | Skip | 704us |
| /parquet/broken/read broken bigint | Skip | 575us |
| /parquet/broken/read broken date | Skip | 559us |
| /parquet/broken/read broken int | Skip | 782us |
| /parquet/broken/read broken smallint | Skip | 539us |
| /parquet/broken/read broken timestamp ms | Skip | 640us |
| /parquet/broken/read broken timestamp us | Skip | 719us |
| /parquet/broken/read broken tinyint | Skip | 540us |
| /parquet/broken/read broken ubigint | Skip | 512us |
| /parquet/broken/read broken uint | Skip | 533us |
| /parquet/broken/read broken usmallint | Skip | 4ms |
| /parquet/broken/read broken utinyint | Skip | 700us |
| /parquet/broken/string | Skip | 769us |
| /parquet/encoding | OK | 10s 761ms |
| /parquet/encoding/deltabytearray1 | OK | 1s 722ms |
| /parquet/encoding/deltabytearray2 | OK | 1s 295ms |
| /parquet/encoding/deltalengthbytearray | OK | 1s 875ms |
| /parquet/encoding/dictionary | OK | 1s 381ms |
| /parquet/encoding/plain | OK | 1s 626ms |
| /parquet/encoding/plainrlesnappy | OK | 1s 538ms |
| /parquet/encoding/rleboolean | OK | 1s 315ms |
| /parquet/compression | OK | 29s 356ms |
| /parquet/compression/arrow snappy | OK | 1s 630ms |
| /parquet/compression/brotli | OK | 1s 397ms |
| /parquet/compression/gzippages | OK | 2s 608ms |
| /parquet/compression/largegzip | OK | 1s 452ms |
| /parquet/compression/lz4 hadoop | OK | 1s 599ms |
| /parquet/compression/lz4 hadoop large | OK | 1s 237ms |
| /parquet/compression/lz4 non hadoop | OK | 1s 286ms |
| /parquet/compression/lz4 raw | OK | 1s 294ms |
| /parquet/compression/lz4 raw large | OK | 1s 271ms |
| /parquet/compression/lz4pages | OK | 2s 640ms |
| /parquet/compression/nonepages | OK | 3s 122ms |
| /parquet/compression/snappypages | OK | 3s 77ms |
| /parquet/compression/snappyplain | OK | 1s 394ms |
| /parquet/compression/snappyrle | OK | 1s 222ms |
| /parquet/compression/zstd | OK | 1s 471ms |
| /parquet/compression/zstdpages | OK | 2s 633ms |
| /parquet/datatypes | OK | 2m 11s |
| /parquet/datatypes/arrowtimestamp | OK | 1s 738ms |
| /parquet/datatypes/arrowtimestampms | OK | 1s 418ms |
| /parquet/datatypes/binary | OK | 1s 419ms |
| /parquet/datatypes/binary string | OK | 1s 219ms |
| /parquet/datatypes/blob | OK | 1s 380ms |
| /parquet/datatypes/boolean | OK | 1s 721ms |
| /parquet/datatypes/byte array | OK | 1s 385ms |
| /parquet/datatypes/columnname | OK | 1s 343ms |
| /parquet/datatypes/columnwithnull | OK | 1s 311ms |
| /parquet/datatypes/columnwithnull2 | OK | 1s 563ms |
| /parquet/datatypes/date | OK | 1s 721ms |
| /parquet/datatypes/decimal with filter | OK | 1s 661ms |
| /parquet/datatypes/decimalvariousfilters | OK | 1s 720ms |
| /parquet/datatypes/decimalwithfilter2 | OK | 1s 718ms |
| /parquet/datatypes/enum | OK | 1s 838ms |
| /parquet/datatypes/enum2 | OK | 1s 305ms |
| /parquet/datatypes/fixed length decimal | OK | 1s 304ms |
| /parquet/datatypes/fixed length decimal legacy | OK | 1s 634ms |
| /parquet/datatypes/fixedstring | OK | 2s 462ms |
| /parquet/datatypes/h2oai | OK | 1s 797ms |
| /parquet/datatypes/hive | OK | 3s 733ms |
| /parquet/datatypes/int32 | OK | 1s 232ms |
| /parquet/datatypes/int32 decimal | OK | 1s 623ms |
| /parquet/datatypes/int64 | OK | 1s 551ms |
| /parquet/datatypes/int64 decimal | OK | 1s 786ms |
| /parquet/datatypes/json | OK | 1s 902ms |
| /parquet/datatypes/large string map | XFail | 11s 249ms |
| /parquet/datatypes/largedouble | OK | 1s 470ms |
| /parquet/datatypes/manydatatypes | OK | 1s 312ms |
| /parquet/datatypes/manydatatypes2 | OK | 1s 378ms |
| /parquet/datatypes/maps | OK | 1s 795ms |
| /parquet/datatypes/nameswithemoji | OK | 1s 282ms |
| /parquet/datatypes/nandouble | OK | 1s 515ms |
| /parquet/datatypes/negativeint64 | OK | 1s 536ms |
| /parquet/datatypes/nullbyte | OK | 1s 293ms |
| /parquet/datatypes/nullbytemultiple | OK | 1s 378ms |
| /parquet/datatypes/nullsinid | OK | 1s 447ms |
| /parquet/datatypes/pandasdecimal | OK | 1s 484ms |
| /parquet/datatypes/pandasdecimaldate | OK | 1s 290ms |
| /parquet/datatypes/parquetgo | OK | 1s 23ms |
| /parquet/datatypes/selectdatewithfilter | OK | 38s 589ms |
| /parquet/datatypes/singlenull | OK | 1s 249ms |
| /parquet/datatypes/sparkv21 | OK | 1s 298ms |
| /parquet/datatypes/sparkv22 | OK | 1s 500ms |
| /parquet/datatypes/statdecimal | OK | 1s 646ms |
| /parquet/datatypes/string | OK | 1s 402ms |
| /parquet/datatypes/string int list inconsistent offset multiple batches | Skip | 919us |
| /parquet/datatypes/stringtypes | OK | 1s 357ms |
| /parquet/datatypes/struct | OK | 1s 618ms |
| /parquet/datatypes/supporteduuid | OK | 1s 342ms |
| /parquet/datatypes/timestamp1 | OK | 1s 598ms |
| /parquet/datatypes/timestamp2 | OK | 1s 416ms |
| /parquet/datatypes/timezone | OK | 1s 517ms |
| /parquet/datatypes/unsigned | OK | 3s 13ms |
| /parquet/datatypes/unsupportednull | OK | 466ms |
| /parquet/complex | OK | 29s 899ms |
| /parquet/complex/arraystring | OK | 1s 331ms |
| /parquet/complex/big tuple with nulls | OK | 1s 856ms |
| /parquet/complex/bytearraydictionary | OK | 1s 231ms |
| /parquet/complex/complex null | OK | 1s 196ms |
| /parquet/complex/lagemap | OK | 1s 628ms |
| /parquet/complex/largenestedarray | OK | 1s 291ms |
| /parquet/complex/largestruct | OK | 1s 477ms |
| /parquet/complex/largestruct2 | OK | 1s 600ms |
| /parquet/complex/largestruct3 | OK | 2s 9ms |
| /parquet/complex/list | OK | 1s 399ms |
| /parquet/complex/nested array | OK | 1s 278ms |
| /parquet/complex/nested map | OK | 1s 657ms |
| /parquet/complex/nestedallcomplex | OK | 1s 572ms |
| /parquet/complex/nestedarray2 | OK | 1s 197ms |
| /parquet/complex/nestedstruct | OK | 1s 746ms |
| /parquet/complex/nestedstruct2 | OK | 1s 689ms |
| /parquet/complex/nestedstruct3 | OK | 1s 293ms |
| /parquet/complex/nestedstruct4 | OK | 1s 482ms |
| /parquet/complex/tupleofnulls | OK | 1s 391ms |
| /parquet/complex/tuplewithdatetime | OK | 1s 524ms |
| /parquet/indexing | OK | 1s 511ms |
| /parquet/indexing/bigtuplewithnulls | OK | 1s 505ms |
| /parquet/cache | OK | 3s 41ms |
| /parquet/cache/cache1 | OK | 1s 620ms |
| /parquet/cache/cache2 | OK | 1s 406ms |
| /parquet/glob | OK | 38s 523ms |
| /parquet/glob/fastparquet globs | OK | 2s 598ms |
| /parquet/glob/glob1 | OK | 2s 134ms |
| /parquet/glob/glob2 | OK | 1s 994ms |
| /parquet/query/compression type/=NONE /select from mergetree table into file | OK | 5m 14s |
| /parquet/query/compression type/=GZIP /select from mergetree table into file | OK | 5m 10s |
| /parquet/glob/glob with multiple elements | OK | 287ms |
| /parquet/glob/million extensions | OK | 31s 506ms |
| /parquet/query/compression type/=LZ4 /select from mergetree table into file | OK | 5m 11s |
| /parquet/rowgroups | OK | 2s 939ms |
| /parquet/rowgroups/manyrowgroups | OK | 1s 644ms |
| /parquet/rowgroups/manyrowgroups2 | OK | 1s 292ms |
| /parquet/encrypted | Skip | 895us |
| /parquet/fastparquet | OK | 41s 132ms |
| /parquet/fastparquet/airlines | OK | 1s 928ms |
| /parquet/fastparquet/baz | OK | 1s 629ms |
| /parquet/fastparquet/empty date | OK | 4s 756ms |
| /parquet/fastparquet/evo | OK | 9s 52ms |
| /parquet/fastparquet/fastparquet | OK | 23s 744ms |
| /parquet/read and write | OK | 11m 47s |
| /parquet/read and write/read and write parquet file | OK | 11m 47s |
| /parquet/query/compression type/=GZIP /select from replicated mergetree table into file | OK | 5m 3s |
| /parquet/query/compression type/=NONE /select from replicated mergetree table into file | OK | 5m 4s |
| /parquet/query/compression type/=LZ4 /select from replicated mergetree table into file | OK | 5m 0s |
| /parquet/query/compression type/=GZIP /select from distributed table into file | OK | 5m 51s |
| /parquet/query/compression type/=LZ4 /select from distributed table into file | OK | 5m 51s |
| /parquet/query/compression type/=NONE /select from distributed table into file | OK | 5m 39s |
| /parquet/query/compression type/=NONE /select from mat view into file | OK | 4m 9s |
| /parquet/query/compression type/=LZ4 /select from mat view into file | OK | 4m 23s |
| /parquet/query/compression type/=GZIP /select from mat view into file | OK | 4m 15s |
| /parquet/query/compression type/=NONE /insert into table with projection from file | OK | 48s 403ms |
| /parquet/query/compression type/=GZIP /insert into table with projection from file | OK | 55s 40ms |
| /parquet/query/compression type/=LZ4 /insert into table with projection from file | OK | 49s 529ms |
Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232