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 | Mar 19, 2024 17:29 |
| Duration | 35m 9s |
| 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.3/0a8ac3b092733da37e3e2a0079c486938a36790d/package_release/clickhouse-common-static_23.3.19.34.altinityfips_amd64.deb |
| version | 23.3.19.34.altinityfips |
| user.name | Enmk |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | 6da94b78dc53cb8965ab56c04a89ebf54ed04cbc |
| job.id | 8247806903 |
| job.url | https://github.com/Altinity/ClickHouse/actions/runs/8247806903 |
| arch | x86_64 |
| node | clickhouse1 |
| allow_vfs | False |
| local | True |
| clickhouse_version | None |
| clickhouse_binary_path | https://s3.amazonaws.com/altinity-build-artifacts/23.3/0a8ac3b092733da37e3e2a0079c486938a36790d/package_release/clickhouse-common-static_23.3.19.34.altinityfips_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 12s 400ms 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.3.19.34.altinityfips (altinity build))
(query: INSERT INTO table_c82291b5_e618_11ee_9748_b98437f7250e 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 8s 870ms 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 877, 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 49, 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.3.19):
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_f8a7e49b_e618_11ee_9748_b98437f7250e
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 | 35m 9s |
| /parquet/file | OK | 25m 8s |
| /parquet/file/engine | OK | 25m 8s |
| /parquet/file/function | OK | 13m 12s |
| /parquet/file/engine/insert into engine | OK | 14m 54s |
| /parquet/file/function/insert into function manual cast types | OK | 12m 25s |
| /parquet/file/function/insert into function auto cast types | OK | 13m 12s |
| /parquet/query | OK | 33m 2s |
| /parquet/query/compression type | OK | 33m 2s |
| /parquet/file/engine/select from engine | OK | 6m 56s |
| /parquet/file/function/select from function manual cast types | OK | 7m 20s |
| /parquet/file/function/select from function auto cast types | OK | 6m 48s |
| /parquet/file/engine/engine to file to engine | OK | 18m 58s |
| /parquet/query/compression type/=NONE | OK | 33m 2s |
| /parquet/query/compression type/=NONE /insert into memory table from file | OK | 6m 49s |
| /parquet/file/engine/insert into engine from file | OK | 13m 37s |
| /parquet/query/compression type/=GZIP | OK | 33m 0s |
| /parquet/file/engine/engine select output to file | OK | 25m 7s |
| /parquet/query/compression type/=LZ4 | OK | 32m 55s |
| /parquet/list in multiple chunks | OK | 16s 303ms |
| /parquet/url | OK | 26m 24s |
| /parquet/query/compression type/=GZIP /insert into memory table from file | OK | 6m 48s |
| /parquet/query/compression type/=LZ4 /insert into memory table from file | OK | 6m 48s |
| /parquet/url/engine | OK | 25m 46s |
| /parquet/url/engine/insert into engine | OK | 15m 48s |
| /parquet/url/function | OK | 12m 20s |
| /parquet/url/engine/select from engine | OK | 6m 55s |
| /parquet/url/function/insert into function | OK | 12m 20s |
| /parquet/url/engine/engine to file to engine | OK | 19m 28s |
| /parquet/url/engine/insert into engine from file | OK | 18m 18s |
| /parquet/url/function/select from function manual cast types | OK | 11m 52s |
| /parquet/url/engine/engine select output to file | OK | 25m 46s |
| /parquet/url/function/select from function auto cast types | OK | 11m 15s |
| /parquet/mysql | OK | 31s 931ms |
| /parquet/mysql/compression type | OK | 31s 917ms |
| /parquet/mysql/compression type/=NONE | OK | 31s 731ms |
| /parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine | OK | 18s 5ms |
| /parquet/mysql/compression type/=GZIP | OK | 31s 826ms |
| /parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine | OK | 19s 233ms |
| /parquet/mysql/compression type/=LZ4 | OK | 31s 750ms |
| /parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine | OK | 18s 697ms |
| /parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function | OK | 13s 697ms |
| /parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function | OK | 13s 30ms |
| /parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function | OK | 12s 525ms |
| /parquet/postgresql | OK | 35s 42ms |
| /parquet/postgresql/compression type | OK | 35s 4ms |
| /parquet/postgresql/compression type/=NONE | OK | 34s 756ms |
| /parquet/postgresql/compression type/=GZIP | OK | 34s 977ms |
| /parquet/postgresql/compression type/=LZ4 | OK | 34s 966ms |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | OK | 20s 630ms |
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | OK | 20s 509ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | OK | 21s 167ms |
| /parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function | OK | 14s 143ms |
| /parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function | OK | 14s 206ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function | OK | 13s 679ms |
| /parquet/remote | OK | 15m 33s |
| /parquet/remote/compression type | OK | 15m 33s |
| /parquet/remote/compression type/=NONE | OK | 15m 33s |
| /parquet/remote/compression type/=LZ4 | OK | 15m 33s |
| /parquet/remote/compression type/=GZIP | OK | 15m 32s |
| /parquet/remote/compression type/=LZ4 /outline | OK | 15m 33s |
| /parquet/remote/compression type/=NONE /outline | OK | 15m 33s |
| /parquet/remote/compression type/=GZIP /outline | OK | 15m 32s |
| /parquet/remote/compression type/=GZIP /outline/insert into function | OK | 7m 12s |
| /parquet/remote/compression type/=LZ4 /outline/insert into function | OK | 7m 12s |
| /parquet/remote/compression type/=NONE /outline/insert into function | OK | 7m 11s |
| /parquet/query/compression type/=GZIP /insert into mergetree table from file | OK | 4m 5s |
| /parquet/query/compression type/=LZ4 /insert into mergetree table from file | OK | 4m 5s |
| /parquet/query/compression type/=NONE /insert into mergetree table from file | OK | 4m 6s |
| /parquet/remote/compression type/=NONE /outline/select from function | OK | 8m 21s |
| /parquet/remote/compression type/=GZIP /outline/select from function | OK | 8m 20s |
| /parquet/remote/compression type/=LZ4 /outline/select from function | OK | 8m 20s |
| /parquet/query/compression type/=GZIP /insert into replicated mergetree table from file | OK | 2m 39s |
| /parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file | OK | 2m 39s |
| /parquet/query/compression type/=NONE /insert into replicated mergetree table from file | OK | 2m 41s |
| /parquet/query/compression type/=GZIP /insert into distributed table from file | OK | 1m 55s |
| /parquet/query/compression type/=LZ4 /insert into distributed table from file | OK | 1m 55s |
| /parquet/query/compression type/=NONE /insert into distributed table from file | OK | 1m 53s |
| /parquet/query/compression type/=GZIP /select from memory table into file | OK | 4m 12s |
| /parquet/query/compression type/=LZ4 /select from memory table into file | OK | 4m 11s |
| /parquet/query/compression type/=NONE /select from memory table into file | OK | 4m 11s |
| /parquet/chunked array | XFail | 12s 400ms |
| /parquet/broken | OK | 3s 274ms |
| /parquet/broken/file | OK | 173ms |
| /parquet/broken/read broken bigint | OK | 109ms |
| /parquet/broken/read broken date | OK | 117ms |
| /parquet/broken/read broken int | OK | 172ms |
| /parquet/broken/read broken smallint | OK | 181ms |
| /parquet/broken/read broken timestamp ms | OK | 172ms |
| /parquet/broken/read broken timestamp us | OK | 108ms |
| /parquet/broken/read broken tinyint | OK | 127ms |
| /parquet/broken/read broken ubigint | OK | 98ms |
| /parquet/broken/read broken uint | OK | 87ms |
| /parquet/broken/read broken usmallint | OK | 160ms |
| /parquet/broken/read broken utinyint | OK | 159ms |
| /parquet/broken/string | OK | 1s 578ms |
| /parquet/encoding | OK | 9s 693ms |
| /parquet/encoding/deltabytearray1 | OK | 1s 121ms |
| /parquet/encoding/deltabytearray2 | OK | 1s 398ms |
| /parquet/encoding/deltalengthbytearray | OK | 1s 101ms |
| /parquet/encoding/dictionary | OK | 1s 305ms |
| /parquet/encoding/plain | OK | 1s 548ms |
| /parquet/encoding/plainrlesnappy | OK | 2s 24ms |
| /parquet/encoding/rleboolean | OK | 1s 182ms |
| /parquet/compression | OK | 24s 845ms |
| /parquet/compression/arrow snappy | OK | 1s 82ms |
| /parquet/compression/brotli | OK | 1s 381ms |
| /parquet/compression/gzippages | OK | 2s 115ms |
| /parquet/compression/largegzip | OK | 1s 269ms |
| /parquet/compression/lz4 hadoop | OK | 1s 180ms |
| /parquet/compression/lz4 hadoop large | OK | 1s 112ms |
| /parquet/compression/lz4 non hadoop | OK | 1s 224ms |
| /parquet/compression/lz4 raw | OK | 1s 75ms |
| /parquet/compression/lz4 raw large | OK | 1s 223ms |
| /parquet/compression/lz4pages | OK | 2s 182ms |
| /parquet/compression/nonepages | OK | 2s 232ms |
| /parquet/compression/snappypages | OK | 2s 656ms |
| /parquet/compression/snappyplain | OK | 1s 130ms |
| /parquet/compression/snappyrle | OK | 1s 411ms |
| /parquet/compression/zstd | OK | 1s 179ms |
| /parquet/compression/zstdpages | OK | 2s 361ms |
| /parquet/datatypes | OK | 1m 23s |
| /parquet/datatypes/arrowtimestamp | OK | 1s 457ms |
| /parquet/datatypes/arrowtimestampms | OK | 1s 401ms |
| /parquet/datatypes/binary | OK | 1s 165ms |
| /parquet/datatypes/binary string | OK | 1s 67ms |
| /parquet/datatypes/blob | OK | 1s 285ms |
| /parquet/datatypes/boolean | OK | 1s 104ms |
| /parquet/datatypes/byte array | OK | 1s 194ms |
| /parquet/datatypes/columnname | OK | 1s 325ms |
| /parquet/datatypes/columnwithnull | OK | 1s 270ms |
| /parquet/datatypes/columnwithnull2 | OK | 1s 140ms |
| /parquet/datatypes/date | OK | 1s 349ms |
| /parquet/datatypes/decimal with filter | OK | 1s 74ms |
| /parquet/datatypes/decimalvariousfilters | OK | 1s 62ms |
| /parquet/datatypes/decimalwithfilter2 | OK | 1s 274ms |
| /parquet/datatypes/enum | OK | 1s 182ms |
| /parquet/datatypes/enum2 | OK | 1s 224ms |
| /parquet/datatypes/fixed length decimal | OK | 1s 142ms |
| /parquet/datatypes/fixed length decimal legacy | OK | 1s 189ms |
| /parquet/datatypes/fixedstring | OK | 1s 225ms |
| /parquet/datatypes/h2oai | OK | 1s 205ms |
| /parquet/datatypes/hive | OK | 2s 490ms |
| /parquet/datatypes/int32 | OK | 1s 56ms |
| /parquet/datatypes/int32 decimal | OK | 1s 17ms |
| /parquet/datatypes/int64 | OK | 1s 224ms |
| /parquet/datatypes/int64 decimal | OK | 1s 317ms |
| /parquet/datatypes/json | OK | 1s 328ms |
| /parquet/datatypes/large string map | XFail | 8s 870ms |
| /parquet/datatypes/largedouble | OK | 956ms |
| /parquet/datatypes/manydatatypes | OK | 1s 116ms |
| /parquet/datatypes/manydatatypes2 | OK | 950ms |
| /parquet/datatypes/maps | OK | 1s 179ms |
| /parquet/datatypes/nameswithemoji | OK | 1s 99ms |
| /parquet/datatypes/nandouble | OK | 1s 42ms |
| /parquet/datatypes/negativeint64 | OK | 1s 301ms |
| /parquet/datatypes/nullbyte | OK | 1s 63ms |
| /parquet/datatypes/nullbytemultiple | OK | 936ms |
| /parquet/datatypes/nullsinid | OK | 1s 12ms |
| /parquet/datatypes/pandasdecimal | OK | 1s 164ms |
| /parquet/datatypes/pandasdecimaldate | OK | 1s 7ms |
| /parquet/datatypes/parquetgo | OK | 1s 35ms |
| /parquet/datatypes/selectdatewithfilter | OK | 15s 214ms |
| /parquet/datatypes/singlenull | OK | 1s 217ms |
| /parquet/datatypes/sparkv21 | OK | 888ms |
| /parquet/datatypes/sparkv22 | OK | 876ms |
| /parquet/datatypes/statdecimal | OK | 915ms |
| /parquet/datatypes/string | OK | 906ms |
| /parquet/datatypes/string int list inconsistent offset multiple batches | Skip | 1ms |
| /parquet/datatypes/stringtypes | OK | 1s 77ms |
| /parquet/datatypes/struct | OK | 970ms |
| /parquet/datatypes/supporteduuid | OK | 857ms |
| /parquet/datatypes/timestamp1 | OK | 921ms |
| /parquet/datatypes/timestamp2 | OK | 1s 51ms |
| /parquet/datatypes/timezone | OK | 881ms |
| /parquet/datatypes/unsigned | OK | 1s 798ms |
| /parquet/datatypes/unsupportednull | OK | 177ms |
| /parquet/complex | OK | 19s 494ms |
| /parquet/complex/arraystring | OK | 1s 230ms |
| /parquet/complex/big tuple with nulls | OK | 898ms |
| /parquet/complex/bytearraydictionary | OK | 896ms |
| /parquet/complex/complex null | OK | 852ms |
| /parquet/complex/lagemap | OK | 920ms |
| /parquet/complex/largenestedarray | OK | 1s 20ms |
| /parquet/complex/largestruct | OK | 895ms |
| /parquet/complex/largestruct2 | OK | 1s 144ms |
| /parquet/complex/largestruct3 | OK | 937ms |
| /parquet/complex/list | OK | 1s 159ms |
| /parquet/complex/nested array | OK | 866ms |
| /parquet/complex/nested map | OK | 823ms |
| /parquet/complex/nestedallcomplex | OK | 917ms |
| /parquet/complex/nestedarray2 | OK | 907ms |
| /parquet/complex/nestedstruct | OK | 1s 407ms |
| /parquet/complex/nestedstruct2 | OK | 842ms |
| /parquet/complex/nestedstruct3 | OK | 907ms |
| /parquet/complex/nestedstruct4 | OK | 883ms |
| /parquet/complex/tupleofnulls | OK | 1s 123ms |
| /parquet/complex/tuplewithdatetime | OK | 846ms |
| /parquet/indexing | OK | 947ms |
| /parquet/indexing/bigtuplewithnulls | OK | 946ms |
| /parquet/cache | OK | 1s 641ms |
| /parquet/cache/cache1 | OK | 770ms |
| /parquet/cache/cache2 | OK | 870ms |
| /parquet/glob | OK | 20s 980ms |
| /parquet/glob/fastparquet globs | OK | 848ms |
| /parquet/glob/glob1 | OK | 1s 251ms |
| /parquet/glob/glob2 | OK | 1s 119ms |
| /parquet/glob/glob with multiple elements | Skip | 497us |
| /parquet/glob/million extensions | OK | 17s 757ms |
| /parquet/query/compression type/=LZ4 /select from mergetree table into file | OK | 3m 21s |
| /parquet/query/compression type/=GZIP /select from mergetree table into file | OK | 3m 20s |
| /parquet/query/compression type/=NONE /select from mergetree table into file | OK | 3m 21s |
| /parquet/rowgroups | OK | 1s 456ms |
| /parquet/rowgroups/manyrowgroups | OK | 707ms |
| /parquet/rowgroups/manyrowgroups2 | OK | 747ms |
| /parquet/encrypted | Skip | 547us |
| /parquet/fastparquet | OK | 22s 31ms |
| /parquet/fastparquet/airlines | OK | 921ms |
| /parquet/fastparquet/baz | OK | 712ms |
| /parquet/fastparquet/empty date | OK | 2s 401ms |
| /parquet/fastparquet/evo | OK | 4s 741ms |
| /parquet/fastparquet/fastparquet | OK | 13s 252ms |
| /parquet/read and write | OK | 10m 2s |
| /parquet/read and write/read and write parquet file | OK | 10m 2s |
| /parquet/query/compression type/=GZIP /select from replicated mergetree table into file | OK | 3m 20s |
| /parquet/query/compression type/=LZ4 /select from replicated mergetree table into file | OK | 3m 21s |
| /parquet/query/compression type/=NONE /select from replicated mergetree table into file | OK | 3m 21s |
| /parquet/query/compression type/=GZIP /select from distributed table into file | OK | 3m 25s |
| /parquet/query/compression type/=LZ4 /select from distributed table into file | OK | 3m 23s |
| /parquet/query/compression type/=NONE /select from distributed table into file | OK | 3m 25s |
| /parquet/query/compression type/=LZ4 /select from mat view into file | OK | 2m 37s |
| /parquet/query/compression type/=GZIP /select from mat view into file | OK | 2m 41s |
| /parquet/query/compression type/=NONE /select from mat view into file | OK | 2m 43s |
| /parquet/query/compression type/=LZ4 /insert into table with projection from file | OK | 29s 801ms |
| /parquet/query/compression type/=GZIP /insert into table with projection from file | OK | 30s 281ms |
| /parquet/query/compression type/=NONE /insert into table with projection from file | OK | 27s 712ms |
Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232