Copyright 2023, Altinity Inc.. All Rights Reserved. All information contained herein is, and remains the property of Altinity Inc.. Any dissemination of this information or reproduction of this material is strictly forbidden unless prior written permission is obtained from Altinity Inc..
| Date | Jul 14, 2023 14:27 |
| Duration | 58m 13s |
| Framework | TestFlows 1.9.230315.1003122 |
Test artifacts can be found at https://altinity-test-reports.s3.amazonaws.com/index.html#clickhouse/23.3.8.22.altinitystable/5555121278/testflows/
| project | Altinity/clickhouse-regression |
| project.id | 530821975 |
| user.name | MyroTk |
| version | 23.3.8.22.altinitystable |
| package | https://s3.amazonaws.com/altinity-build-artifacts/23.3/b2217a3881bc514b436b6e2c0e21eb899b4d4aee/package_release/clickhouse-common-static_23.3.8.22.altinitystable_amd64.deb |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | 8dc5b1c9b71df38e57fab8b4ab2fc208770292e1 |
| job.id | 5555121278 |
| job.url | https://github.com/Altinity/clickhouse-regression/actions/runs/5555121278 |
| arch | amd64 |
| node | clickhouse1 |
| local | True |
| clickhouse_version | 23.3.8.22.altinitystable |
| clickhouse_binary_path | https://s3.amazonaws.com/altinity-build-artifacts/23.3/b2217a3881bc514b436b6e2c0e21eb899b4d4aee/package_release/clickhouse-common-static_23.3.8.22.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 | OK | Fail | XFail | |
|---|---|---|---|---|
| Modules | ||||
| Suites | ||||
| Features | ||||
| Scenarios | ||||
| Checks | ||||
| Examples | ||||
| Steps |
| Test Name | Result | Message |
|---|---|---|
| /parquet/chunked array | XFail 8s 763ms 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 "/opt/actions-runner/_work/clickhouse-regression/clickhouse-regression/parquet/../parquet/tests/chunked_array.py", line 30, in feature
node.query(
File "/opt/actions-runner/_work/clickhouse-regression/clickhouse-regression/parquet/../helpers/cluster.py", line 777, 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.3.8.22.altinitystable (altinity build))
(query: INSERT INTO table_00b69650_2259_11ee_a57f_17acbd519539 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 '/opt/actions-runner/_work/clickhouse-regression/clickhouse-regression/parquet/../helpers/cluster.py', line 777 in 'query'
769\| assert message in r.output, error(r.output)
770\|
771\| if not ignore_exception:
772\| if message is None or "Exception:" not in message:
773\| with Then("check if output has exception") if steps else NullStep():
774\| if "Exception:" in r.output:
775\| if raise_on_exception:
776\| raise QueryRuntimeException(r.output)
777\|> assert False, error(r.output)
778\|
779\| return r
780\| |
| Test Name | Result | Duration |
|---|---|---|
| /parquet | OK | 58m 13s |
| /parquet/file | OK | 25m 30s |
| /parquet/file/engine | OK | 17m 10s |
| /parquet/file/engine/insert into engine | OK | 2m 21s |
| /parquet/query | OK | 37m 49s |
| /parquet/query/compression_type='NONE' | OK | 12m 32s |
| /parquet/query/compression_type='NONE'/insert into memory table from file | OK | 21s 567ms |
| /parquet/query/compression_type='NONE'/insert into mergetree table from file | OK | 19s 549ms |
| /parquet/query/compression_type='NONE'/insert into replicated mergetree table from file | OK | 19s 887ms |
| /parquet/query/compression_type='NONE'/insert into distributed table from file | OK | 21s 927ms |
| /parquet/query/compression_type='NONE'/select from memory table into file | OK | 1m 55s |
| /parquet/file/engine/select from engine | OK | 22s 637ms |
| /parquet/file/engine/engine to file to engine | OK | 4m 12s |
| /parquet/query/compression_type='NONE'/select from mergetree table into file | OK | 2m 11s |
| /parquet/query/compression_type='NONE'/select from replicated mergetree table into file | OK | 2m 23s |
| /parquet/file/engine/insert into engine from file | OK | 1m 1s |
| /parquet/query/compression_type='NONE'/select from distributed table into file | OK | 2m 27s |
| /parquet/file/engine/engine select output to file | OK | 9m 12s |
| /parquet/query/compression_type='NONE'/select from mat view into file | OK | 1m 52s |
| /parquet/query/compression_type='NONE'/insert into table with projection from file | OK | 18s 314ms |
| /parquet/query/compression_type='GZIP' | OK | 12m 46s |
| /parquet/query/compression_type='GZIP'/insert into memory table from file | OK | 19s 602ms |
| /parquet/query/compression_type='GZIP'/insert into mergetree table from file | OK | 19s 774ms |
| /parquet/query/compression_type='GZIP'/insert into replicated mergetree table from file | OK | 19s 915ms |
| /parquet/query/compression_type='GZIP'/insert into distributed table from file | OK | 21s 811ms |
| /parquet/query/compression_type='GZIP'/select from memory table into file | OK | 1m 52s |
| /parquet/query/compression_type='GZIP'/select from mergetree table into file | OK | 2m 13s |
| /parquet/file/function | OK | 8m 20s |
| /parquet/file/function/insert into function manual cast types | OK | 2m 10s |
| /parquet/query/compression_type='GZIP'/select from replicated mergetree table into file | OK | 2m 12s |
| /parquet/file/function/insert into function auto cast types | OK | 2m 56s |
| /parquet/query/compression_type='GZIP'/select from distributed table into file | OK | 2m 32s |
| /parquet/file/function/select from function manual cast types | OK | 2m 47s |
| /parquet/query/compression_type='GZIP'/select from mat view into file | OK | 2m 12s |
| /parquet/query/compression_type='GZIP'/insert into table with projection from file | OK | 22s 3ms |
| /parquet/file/function/select from function auto cast types | OK | 26s 16ms |
| /parquet/query/compression_type='LZ4' | OK | 12m 30s |
| /parquet/query/compression_type='LZ4'/insert into memory table from file | OK | 29s 736ms |
| /parquet/list in multiple chunks | OK | 10s 342ms |
| /parquet/url | OK | 30m 53s |
| /parquet/url/engine | OK | 21m 3s |
| /parquet/url/engine/insert into engine | OK | 3m 20s |
| /parquet/query/compression_type='LZ4'/insert into mergetree table from file | OK | 19s 730ms |
| /parquet/query/compression_type='LZ4'/insert into replicated mergetree table from file | OK | 19s 645ms |
| /parquet/query/compression_type='LZ4'/insert into distributed table from file | OK | 22s 6ms |
| /parquet/query/compression_type='LZ4'/select from memory table into file | OK | 1m 52s |
| /parquet/query/compression_type='LZ4'/select from mergetree table into file | OK | 2m 15s |
| /parquet/url/engine/select from engine | OK | 23s 879ms |
| /parquet/url/engine/engine to file to engine | OK | 4m 42s |
| /parquet/query/compression_type='LZ4'/select from replicated mergetree table into file | OK | 2m 14s |
| /parquet/query/compression_type='LZ4'/select from distributed table into file | OK | 2m 26s |
| /parquet/url/engine/insert into engine from file | OK | 2m 27s |
| /parquet/query/compression_type='LZ4'/select from mat view into file | OK | 1m 52s |
| /parquet/url/engine/engine select output to file | OK | 10m 8s |
| /parquet/query/compression_type='LZ4'/insert into table with projection from file | OK | 18s 129ms |
| /parquet/mysql | OK | 14s 551ms |
| /parquet/mysql/compression_type='NONE' | OK | 5s 220ms |
| /parquet/mysql/compression_type='NONE'/mysql engine to parquet file to mysql engine | OK | 2s 990ms |
| /parquet/mysql/compression_type='NONE'/mysql function to parquet file to mysql function | OK | 2s 229ms |
| /parquet/mysql/compression_type='GZIP' | OK | 4s 667ms |
| /parquet/mysql/compression_type='GZIP'/mysql engine to parquet file to mysql engine | OK | 2s 426ms |
| /parquet/mysql/compression_type='GZIP'/mysql function to parquet file to mysql function | OK | 2s 240ms |
| /parquet/mysql/compression_type='LZ4' | OK | 4s 661ms |
| /parquet/mysql/compression_type='LZ4'/mysql engine to parquet file to mysql engine | OK | 2s 430ms |
| /parquet/mysql/compression_type='LZ4'/mysql function to parquet file to mysql function | OK | 2s 229ms |
| /parquet/postgresql | OK | 20s 269ms |
| /parquet/postgresql/compression_type='NONE' | OK | 7s 67ms |
| /parquet/postgresql/compression_type='NONE'/postgresql engine to parquet file to postgresql engine | OK | 4s 309ms |
| /parquet/postgresql/compression_type='NONE'/postgresql function to parquet file to postgresql function | OK | 2s 757ms |
| /parquet/postgresql/compression_type='GZIP' | OK | 6s 619ms |
| /parquet/postgresql/compression_type='GZIP'/postgresql engine to parquet file to postgresql engine | OK | 3s 880ms |
| /parquet/postgresql/compression_type='GZIP'/postgresql function to parquet file to postgresql function | OK | 2s 739ms |
| /parquet/postgresql/compression_type='LZ4' | OK | 6s 580ms |
| /parquet/postgresql/compression_type='LZ4'/postgresql engine to parquet file to postgresql engine | OK | 3s 806ms |
| /parquet/postgresql/compression_type='LZ4'/postgresql function to parquet file to postgresql function | OK | 2s 773ms |
| /parquet/remote | OK | 6m 38s |
| /parquet/remote/compression_type='NONE' | OK | 2m 12s |
| /parquet/remote/compression_type='NONE'/insert into function | OK | 19s 412ms |
| /parquet/remote/compression_type='NONE'/select from function | OK | 1m 53s |
| /parquet/remote/compression_type='GZIP' | OK | 2m 13s |
| /parquet/remote/compression_type='GZIP'/insert into function | OK | 19s 928ms |
| /parquet/remote/compression_type='GZIP'/select from function | OK | 1m 53s |
| /parquet/remote/compression_type='LZ4' | OK | 2m 12s |
| /parquet/remote/compression_type='LZ4'/insert into function | OK | 19s 672ms |
| /parquet/remote/compression_type='LZ4'/select from function | OK | 1m 53s |
| /parquet/chunked array | XFail | 8s 763ms |
| /parquet/broken | OK | 1s 707ms |
| /parquet/broken/file | OK | 55ms |
| /parquet/broken/read broken bigint | OK | 41ms |
| /parquet/broken/read broken date | OK | 42ms |
| /parquet/broken/read broken int | OK | 48ms |
| /parquet/broken/read broken smallint | OK | 42ms |
| /parquet/broken/read broken timestamp ms | OK | 42ms |
| /parquet/broken/read broken timestamp us | OK | 46ms |
| /parquet/broken/read broken tinyint | OK | 43ms |
| /parquet/broken/read broken ubigint | OK | 42ms |
| /parquet/broken/read broken uint | OK | 43ms |
| /parquet/broken/read broken usmallint | OK | 42ms |
| /parquet/broken/read broken utinyint | OK | 53ms |
| /parquet/broken/string | OK | 1s 159ms |
| /parquet/encoding | OK | 8s 608ms |
| /parquet/encoding/deltabytearray1 | OK | 1s 206ms |
| /parquet/encoding/deltabytearray2 | OK | 1s 204ms |
| /parquet/encoding/deltalengthbytearray | OK | 1s 231ms |
| /parquet/encoding/dictionary | OK | 1s 164ms |
| /parquet/encoding/plain | OK | 1s 234ms |
| /parquet/encoding/plainrlesnappy | OK | 1s 254ms |
| /parquet/encoding/rleboolean | OK | 1s 309ms |
| /parquet/compression | OK | 25s 60ms |
| /parquet/compression/arrow snappy | OK | 1s 206ms |
| /parquet/compression/brotli | OK | 1s 198ms |
| /parquet/compression/gzippages | OK | 2s 381ms |
| /parquet/compression/largegzip | OK | 1s 200ms |
| /parquet/compression/lz4 hadoop | OK | 1s 201ms |
| /parquet/compression/lz4 hadoop large | OK | 1s 223ms |
| /parquet/compression/lz4 non hadoop | OK | 1s 238ms |
| /parquet/compression/lz4 raw | OK | 1s 185ms |
| /parquet/compression/lz4 raw large | OK | 1s 190ms |
| /parquet/compression/lz4pages | OK | 2s 379ms |
| /parquet/compression/nonepages | OK | 2s 360ms |
| /parquet/compression/snappypages | OK | 2s 360ms |
| /parquet/compression/snappyplain | OK | 1s 169ms |
| /parquet/compression/snappyrle | OK | 1s 239ms |
| /parquet/compression/zstd | OK | 1s 147ms |
| /parquet/compression/zstdpages | OK | 2s 372ms |
| /parquet/datatypes | OK | 1m 9s |
| /parquet/datatypes/arrowtimestamp | OK | 1s 210ms |
| /parquet/datatypes/arrowtimestampms | OK | 1s 244ms |
| /parquet/datatypes/binary | OK | 1s 277ms |
| /parquet/datatypes/binary string | OK | 1s 233ms |
| /parquet/datatypes/blob | OK | 1s 312ms |
| /parquet/datatypes/boolean | OK | 1s 191ms |
| /parquet/datatypes/byte array | OK | 1s 265ms |
| /parquet/datatypes/columnname | OK | 1s 208ms |
| /parquet/datatypes/columnwithnull | OK | 1s 219ms |
| /parquet/datatypes/columnwithnull2 | OK | 1s 174ms |
| /parquet/datatypes/date | OK | 1s 195ms |
| /parquet/datatypes/decimal with filter | OK | 1s 192ms |
| /parquet/datatypes/decimalvariousfilters | OK | 1s 210ms |
| /parquet/datatypes/decimalwithfilter2 | OK | 1s 222ms |
| /parquet/datatypes/enum | OK | 1s 255ms |
| /parquet/datatypes/enum2 | OK | 1s 250ms |
| /parquet/datatypes/fixed length decimal | OK | 1s 192ms |
| /parquet/datatypes/fixed length decimal legacy | OK | 1s 217ms |
| /parquet/datatypes/fixedstring | OK | 1s 212ms |
| /parquet/datatypes/h2oai | OK | 1s 233ms |
| /parquet/datatypes/hive | OK | 2s 346ms |
| /parquet/datatypes/int32 | OK | 1s 163ms |
| /parquet/datatypes/int32 decimal | OK | 1s 174ms |
| /parquet/datatypes/int64 | OK | 1s 199ms |
| /parquet/datatypes/int64 decimal | OK | 1s 202ms |
| /parquet/datatypes/json | OK | 1s 198ms |
| /parquet/datatypes/largedouble | OK | 1s 229ms |
| /parquet/datatypes/manydatatypes | OK | 1s 150ms |
| /parquet/datatypes/manydatatypes2 | OK | 1s 241ms |
| /parquet/datatypes/maps | OK | 1s 317ms |
| /parquet/datatypes/nameswithemoji | OK | 1s 299ms |
| /parquet/datatypes/nandouble | OK | 1s 211ms |
| /parquet/datatypes/negativeint64 | OK | 1s 245ms |
| /parquet/datatypes/nullbyte | OK | 1s 199ms |
| /parquet/datatypes/nullbytemultiple | OK | 1s 183ms |
| /parquet/datatypes/nullsinid | OK | 1s 191ms |
| /parquet/datatypes/pandasdecimal | OK | 1s 274ms |
| /parquet/datatypes/pandasdecimaldate | OK | 1s 230ms |
| /parquet/datatypes/parquetgo | OK | 1s 310ms |
| /parquet/datatypes/selectdatewithfilter | OK | 3s 452ms |
| /parquet/datatypes/singlenull | OK | 1s 192ms |
| /parquet/datatypes/sparkv21 | OK | 1s 219ms |
| /parquet/datatypes/sparkv22 | OK | 1s 242ms |
| /parquet/datatypes/statdecimal | OK | 1s 262ms |
| /parquet/datatypes/string | OK | 1s 243ms |
| /parquet/url/function | OK | 9m 16s |
| /parquet/url/function/insert into function | OK | 2m 1s |
| /parquet/datatypes/stringtypes | OK | 1s 236ms |
| /parquet/datatypes/struct | OK | 1s 878ms |
| /parquet/datatypes/supporteduuid | OK | 1s 244ms |
| /parquet/datatypes/timestamp1 | OK | 1s 261ms |
| /parquet/datatypes/timestamp2 | OK | 1s 220ms |
| /parquet/datatypes/timezone | OK | 1s 243ms |
| /parquet/datatypes/unsigned | OK | 2s 431ms |
| /parquet/datatypes/unsupportednull | OK | 158ms |
| /parquet/complex | OK | 24s 981ms |
| /parquet/complex/arraystring | OK | 1s 239ms |
| /parquet/complex/big tuple with nulls | OK | 1s 222ms |
| /parquet/complex/bytearraydictionary | OK | 1s 220ms |
| /parquet/complex/complex null | OK | 1s 262ms |
| /parquet/complex/lagemap | OK | 1s 222ms |
| /parquet/complex/largenestedarray | OK | 1s 257ms |
| /parquet/complex/largestruct | OK | 1s 234ms |
| /parquet/complex/largestruct2 | OK | 1s 401ms |
| /parquet/complex/largestruct3 | OK | 1s 272ms |
| /parquet/complex/list | OK | 1s 203ms |
| /parquet/complex/nested array | OK | 1s 215ms |
| /parquet/complex/nested map | OK | 1s 186ms |
| /parquet/complex/nestedallcomplex | OK | 1s 312ms |
| /parquet/complex/nestedarray2 | OK | 1s 212ms |
| /parquet/complex/nestedstruct | OK | 1s 267ms |
| /parquet/complex/nestedstruct2 | OK | 1s 254ms |
| /parquet/complex/nestedstruct3 | OK | 1s 234ms |
| /parquet/complex/nestedstruct4 | OK | 1s 281ms |
| /parquet/complex/tupleofnulls | OK | 1s 230ms |
| /parquet/complex/tuplewithdatetime | OK | 1s 242ms |
| /parquet/indexing | OK | 1s 207ms |
| /parquet/indexing/bigtuplewithnulls | OK | 1s 206ms |
| /parquet/cache | OK | 2s 446ms |
| /parquet/cache/cache1 | OK | 1s 201ms |
| /parquet/cache/cache2 | OK | 1s 243ms |
| /parquet/glob | OK | 934ms |
| /parquet/glob/glob1 | OK | 396ms |
| /parquet/glob/glob2 | OK | 536ms |
| /parquet/rowgroups | OK | 2s 506ms |
| /parquet/rowgroups/manyrowgroups | OK | 1s 278ms |
| /parquet/rowgroups/manyrowgroups2 | OK | 1s 226ms |
| /parquet/url/function/select from function manual cast types | OK | 6m 21s |
| /parquet/url/function/select from function auto cast types | OK | 53s 700ms |
Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122