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 01, 2024 21:02 |
| Duration | 1h 2m |
| 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/19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c/package_aarch64/clickhouse-common-static_23.3.19.33.altinitystable_arm64.deb |
| version | 23.3.19.33.altinitystable |
| user.name | Enmk |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | 6da94b78dc53cb8965ab56c04a89ebf54ed04cbc |
| job.id | 8115174679 |
| job.url | https://github.com/Altinity/ClickHouse/actions/runs/8115174679 |
| arch | aarch64 |
| node | clickhouse1 |
| allow_vfs | False |
| local | True |
| clickhouse_version | None |
| clickhouse_binary_path | https://s3.amazonaws.com/altinity-build-artifacts/23.3/19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c/package_aarch64/clickhouse-common-static_23.3.19.33.altinitystable_arm64.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 13s 941ms 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.33.altinitystable (altinity build))
(query: INSERT INTO table_7163c02d_d813_11ee_84d3_3f99ccac2672 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 6s 817ms 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_4f9645be_d814_11ee_84d3_3f99ccac2672
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 | 1h 2m |
| /parquet/file | OK | 42m 8s |
| /parquet/file/engine | OK | 42m 8s |
| /parquet/file/engine/insert into engine | OK | 26m 9s |
| /parquet/file/function | OK | 22m 29s |
| /parquet/file/engine/select from engine | OK | 12m 7s |
| /parquet/file/engine/engine to file to engine | OK | 33m 36s |
| /parquet/query | OK | 55m 43s |
| /parquet/query/compression type | OK | 55m 43s |
| /parquet/file/function/insert into function manual cast types | OK | 21m 26s |
| /parquet/file/function/insert into function auto cast types | OK | 22m 29s |
| /parquet/file/engine/insert into engine from file | OK | 23m 53s |
| /parquet/file/function/select from function manual cast types | OK | 16m 53s |
| /parquet/file/engine/engine select output to file | OK | 42m 7s |
| /parquet/query/compression type/=NONE | OK | 55m 43s |
| /parquet/query/compression type/=NONE /insert into memory table from file | OK | 12m 3s |
| /parquet/query/compression type/=GZIP | OK | 55m 43s |
| /parquet/file/function/select from function auto cast types | OK | 12m 5s |
| /parquet/query/compression type/=LZ4 | OK | 55m 42s |
| /parquet/list in multiple chunks | OK | 1m 15s |
| /parquet/query/compression type/=GZIP /insert into memory table from file | OK | 12m 5s |
| /parquet/query/compression type/=LZ4 /insert into memory table from file | OK | 12m 5s |
| /parquet/url | OK | 43m 43s |
| /parquet/url/engine | OK | 42m 44s |
| /parquet/url/function | OK | 30m 38s |
| /parquet/url/engine/insert into engine | OK | 27m 5s |
| /parquet/url/engine/select from engine | OK | 12m 21s |
| /parquet/url/engine/engine to file to engine | OK | 33m 42s |
| /parquet/url/function/insert into function | OK | 21m 18s |
| /parquet/url/function/select from function manual cast types | OK | 30m 37s |
| /parquet/url/engine/insert into engine from file | OK | 32m 13s |
| /parquet/url/function/select from function auto cast types | OK | 19m 37s |
| /parquet/url/engine/engine select output to file | OK | 42m 44s |
| /parquet/mysql | OK | 1m 30s |
| /parquet/mysql/compression type | OK | 1m 30s |
| /parquet/mysql/compression type/=NONE | OK | 1m 29s |
| /parquet/mysql/compression type/=NONE /mysql engine to parquet file to mysql engine | OK | 59s 328ms |
| /parquet/mysql/compression type/=GZIP | OK | 1m 29s |
| /parquet/mysql/compression type/=GZIP /mysql engine to parquet file to mysql engine | OK | 59s 54ms |
| /parquet/mysql/compression type/=LZ4 | OK | 1m 30s |
| /parquet/mysql/compression type/=LZ4 /mysql engine to parquet file to mysql engine | OK | 58s 979ms |
| /parquet/mysql/compression type/=GZIP /mysql function to parquet file to mysql function | OK | 30s 461ms |
| /parquet/mysql/compression type/=LZ4 /mysql function to parquet file to mysql function | OK | 31s 225ms |
| /parquet/mysql/compression type/=NONE /mysql function to parquet file to mysql function | OK | 30s 361ms |
| /parquet/postgresql | OK | 1m 26s |
| /parquet/postgresql/compression type | OK | 1m 26s |
| /parquet/postgresql/compression type/=NONE | OK | 1m 25s |
| /parquet/postgresql/compression type/=GZIP | OK | 1m 22s |
| /parquet/postgresql/compression type/=LZ4 | OK | 1m 23s |
| /parquet/postgresql/compression type/=NONE /postgresql engine to parquet file to postgresql engine | OK | 53s 130ms |
| /parquet/postgresql/compression type/=GZIP /postgresql engine to parquet file to postgresql engine | OK | 49s 271ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql engine to parquet file to postgresql engine | OK | 49s 844ms |
| /parquet/postgresql/compression type/=GZIP /postgresql function to parquet file to postgresql function | OK | 33s 395ms |
| /parquet/postgresql/compression type/=LZ4 /postgresql function to parquet file to postgresql function | OK | 33s 105ms |
| /parquet/postgresql/compression type/=NONE /postgresql function to parquet file to postgresql function | OK | 32s 635ms |
| /parquet/remote | OK | 25m 51s |
| /parquet/remote/compression type | OK | 25m 51s |
| /parquet/remote/compression type/=GZIP | OK | 25m 51s |
| /parquet/remote/compression type/=LZ4 | OK | 25m 51s |
| /parquet/remote/compression type/=NONE | OK | 25m 51s |
| /parquet/remote/compression type/=GZIP /outline | OK | 25m 50s |
| /parquet/remote/compression type/=LZ4 /outline | OK | 25m 51s |
| /parquet/remote/compression type/=NONE /outline | OK | 25m 51s |
| /parquet/remote/compression type/=GZIP /outline/insert into function | OK | 11m 9s |
| /parquet/remote/compression type/=LZ4 /outline/insert into function | OK | 11m 8s |
| /parquet/remote/compression type/=NONE /outline/insert into function | OK | 11m 10s |
| /parquet/query/compression type/=NONE /insert into mergetree table from file | OK | 7m 13s |
| /parquet/query/compression type/=LZ4 /insert into mergetree table from file | OK | 7m 2s |
| /parquet/query/compression type/=GZIP /insert into mergetree table from file | OK | 7m 10s |
| /parquet/remote/compression type/=LZ4 /outline/select from function | OK | 14m 42s |
| /parquet/remote/compression type/=GZIP /outline/select from function | OK | 14m 41s |
| /parquet/remote/compression type/=NONE /outline/select from function | OK | 14m 40s |
| /parquet/query/compression type/=LZ4 /insert into replicated mergetree table from file | OK | 4m 40s |
| /parquet/query/compression type/=GZIP /insert into replicated mergetree table from file | OK | 4m 37s |
| /parquet/query/compression type/=NONE /insert into replicated mergetree table from file | OK | 4m 35s |
| /parquet/query/compression type/=LZ4 /insert into distributed table from file | OK | 3m 43s |
| /parquet/query/compression type/=NONE /insert into distributed table from file | OK | 3m 42s |
| /parquet/query/compression type/=GZIP /insert into distributed table from file | OK | 3m 42s |
| /parquet/query/compression type/=LZ4 /select from memory table into file | OK | 7m 4s |
| /parquet/query/compression type/=NONE /select from memory table into file | OK | 7m 0s |
| /parquet/query/compression type/=GZIP /select from memory table into file | OK | 7m 2s |
| /parquet/chunked array | XFail | 13s 941ms |
| /parquet/broken | OK | 12s 545ms |
| /parquet/broken/file | OK | 482ms |
| /parquet/broken/read broken bigint | OK | 479ms |
| /parquet/broken/read broken date | OK | 383ms |
| /parquet/broken/read broken int | OK | 431ms |
| /parquet/broken/read broken smallint | OK | 462ms |
| /parquet/broken/read broken timestamp ms | OK | 329ms |
| /parquet/broken/read broken timestamp us | OK | 329ms |
| /parquet/broken/read broken tinyint | OK | 411ms |
| /parquet/broken/read broken ubigint | OK | 327ms |
| /parquet/broken/read broken uint | OK | 668ms |
| /parquet/broken/read broken usmallint | OK | 388ms |
| /parquet/broken/read broken utinyint | OK | 454ms |
| /parquet/broken/string | OK | 7s 246ms |
| /parquet/encoding | OK | 48s 930ms |
| /parquet/encoding/deltabytearray1 | OK | 6s 572ms |
| /parquet/encoding/deltabytearray2 | OK | 6s 669ms |
| /parquet/encoding/deltalengthbytearray | OK | 6s 338ms |
| /parquet/encoding/dictionary | OK | 6s 638ms |
| /parquet/encoding/plain | OK | 6s 516ms |
| /parquet/encoding/plainrlesnappy | OK | 9s 787ms |
| /parquet/encoding/rleboolean | OK | 6s 332ms |
| /parquet/compression | OK | 2m 14s |
| /parquet/compression/arrow snappy | OK | 6s 206ms |
| /parquet/compression/brotli | OK | 6s 310ms |
| /parquet/compression/gzippages | OK | 12s 659ms |
| /parquet/compression/largegzip | OK | 6s 473ms |
| /parquet/compression/lz4 hadoop | OK | 6s 456ms |
| /parquet/compression/lz4 hadoop large | OK | 6s 120ms |
| /parquet/compression/lz4 non hadoop | OK | 6s 256ms |
| /parquet/compression/lz4 raw | OK | 6s 527ms |
| /parquet/compression/lz4 raw large | OK | 6s 427ms |
| /parquet/compression/lz4pages | OK | 12s 670ms |
| /parquet/compression/nonepages | OK | 12s 704ms |
| /parquet/compression/snappypages | OK | 13s 372ms |
| /parquet/compression/snappyplain | OK | 6s 915ms |
| /parquet/compression/snappyrle | OK | 6s 540ms |
| /parquet/compression/zstd | OK | 6s 255ms |
| /parquet/compression/zstdpages | OK | 12s 687ms |
| /parquet/datatypes | OK | 5m 35s |
| /parquet/datatypes/arrowtimestamp | OK | 5s 840ms |
| /parquet/datatypes/arrowtimestampms | OK | 6s 600ms |
| /parquet/datatypes/binary | OK | 5s 823ms |
| /parquet/datatypes/binary string | OK | 6s 200ms |
| /parquet/datatypes/blob | OK | 6s 479ms |
| /parquet/datatypes/boolean | OK | 5s 815ms |
| /parquet/datatypes/byte array | OK | 5s 806ms |
| /parquet/datatypes/columnname | OK | 5s 946ms |
| /parquet/datatypes/columnwithnull | OK | 5s 735ms |
| /parquet/datatypes/columnwithnull2 | OK | 5s 638ms |
| /parquet/datatypes/date | OK | 5s 660ms |
| /parquet/query/compression type/=NONE /select from mergetree table into file | OK | 5m 12s |
| /parquet/query/compression type/=LZ4 /select from mergetree table into file | OK | 5m 13s |
| /parquet/query/compression type/=GZIP /select from mergetree table into file | OK | 5m 10s |
| /parquet/datatypes/decimal with filter | OK | 5s 564ms |
| /parquet/datatypes/decimalvariousfilters | OK | 12s 502ms |
| /parquet/datatypes/decimalwithfilter2 | OK | 5s 947ms |
| /parquet/datatypes/enum | OK | 5s 664ms |
| /parquet/datatypes/enum2 | OK | 5s 641ms |
| /parquet/datatypes/fixed length decimal | OK | 5s 654ms |
| /parquet/datatypes/fixed length decimal legacy | OK | 5s 550ms |
| /parquet/datatypes/fixedstring | OK | 5s 961ms |
| /parquet/datatypes/h2oai | OK | 5s 737ms |
| /parquet/datatypes/hive | OK | 11s 87ms |
| /parquet/datatypes/int32 | OK | 5s 674ms |
| /parquet/datatypes/int32 decimal | OK | 5s 684ms |
| /parquet/datatypes/int64 | OK | 6s 913ms |
| /parquet/datatypes/int64 decimal | OK | 5s 449ms |
| /parquet/datatypes/json | OK | 5s 688ms |
| /parquet/datatypes/large string map | XFail | 6s 817ms |
| /parquet/datatypes/largedouble | OK | 5s 778ms |
| /parquet/datatypes/manydatatypes | OK | 7s 37ms |
| /parquet/datatypes/manydatatypes2 | OK | 5s 590ms |
| /parquet/datatypes/maps | OK | 5s 633ms |
| /parquet/datatypes/nameswithemoji | OK | 5s 623ms |
| /parquet/datatypes/nandouble | OK | 5s 631ms |
| /parquet/datatypes/negativeint64 | OK | 5s 751ms |
| /parquet/datatypes/nullbyte | OK | 5s 591ms |
| /parquet/datatypes/nullbytemultiple | OK | 5s 461ms |
| /parquet/datatypes/nullsinid | OK | 5s 652ms |
| /parquet/datatypes/pandasdecimal | OK | 5s 499ms |
| /parquet/datatypes/pandasdecimaldate | OK | 5s 732ms |
| /parquet/datatypes/parquetgo | OK | 5s 595ms |
| /parquet/datatypes/selectdatewithfilter | OK | 16s 812ms |
| /parquet/datatypes/singlenull | OK | 5s 639ms |
| /parquet/datatypes/sparkv21 | OK | 5s 737ms |
| /parquet/datatypes/sparkv22 | OK | 5s 584ms |
| /parquet/datatypes/statdecimal | OK | 5s 570ms |
| /parquet/datatypes/string | OK | 5s 502ms |
| /parquet/datatypes/string int list inconsistent offset multiple batches | Skip | 1ms |
| /parquet/datatypes/stringtypes | OK | 5s 696ms |
| /parquet/datatypes/struct | OK | 5s 436ms |
| /parquet/datatypes/supporteduuid | OK | 5s 588ms |
| /parquet/datatypes/timestamp1 | OK | 5s 642ms |
| /parquet/datatypes/timestamp2 | OK | 5s 538ms |
| /parquet/datatypes/timezone | OK | 5s 501ms |
| /parquet/datatypes/unsigned | OK | 11s 18ms |
| /parquet/datatypes/unsupportednull | OK | 294ms |
| /parquet/complex | OK | 1m 58s |
| /parquet/complex/arraystring | OK | 5s 759ms |
| /parquet/complex/big tuple with nulls | OK | 5s 458ms |
| /parquet/complex/bytearraydictionary | OK | 5s 483ms |
| /parquet/complex/complex null | OK | 5s 518ms |
| /parquet/complex/lagemap | OK | 5s 619ms |
| /parquet/complex/largenestedarray | OK | 5s 595ms |
| /parquet/complex/largestruct | OK | 5s 415ms |
| /parquet/complex/largestruct2 | OK | 5s 564ms |
| /parquet/query/compression type/=NONE /select from replicated mergetree table into file | OK | 5m 6s |
| /parquet/query/compression type/=GZIP /select from replicated mergetree table into file | OK | 5m 1s |
| /parquet/query/compression type/=LZ4 /select from replicated mergetree table into file | OK | 5m 2s |
| /parquet/complex/largestruct3 | OK | 9s 186ms |
| /parquet/complex/list | OK | 8s 731ms |
| /parquet/complex/nested array | OK | 5s 667ms |
| /parquet/complex/nested map | OK | 5s 551ms |
| /parquet/complex/nestedallcomplex | OK | 5s 725ms |
| /parquet/complex/nestedarray2 | OK | 5s 658ms |
| /parquet/complex/nestedstruct | OK | 5s 592ms |
| /parquet/complex/nestedstruct2 | OK | 5s 540ms |
| /parquet/complex/nestedstruct3 | OK | 5s 813ms |
| /parquet/complex/nestedstruct4 | OK | 5s 854ms |
| /parquet/complex/tupleofnulls | OK | 5s 558ms |
| /parquet/complex/tuplewithdatetime | OK | 5s 573ms |
| /parquet/indexing | OK | 5s 837ms |
| /parquet/indexing/bigtuplewithnulls | OK | 5s 834ms |
| /parquet/cache | OK | 11s 103ms |
| /parquet/cache/cache1 | OK | 5s 606ms |
| /parquet/cache/cache2 | OK | 5s 494ms |
| /parquet/glob | OK | 38s 963ms |
| /parquet/glob/fastparquet globs | OK | 1s 805ms |
| /parquet/glob/glob1 | OK | 1s 689ms |
| /parquet/glob/glob2 | OK | 1s 765ms |
| /parquet/glob/glob with multiple elements | Skip | 1ms |
| /parquet/glob/million extensions | OK | 33s 698ms |
| /parquet/rowgroups | OK | 12s 803ms |
| /parquet/rowgroups/manyrowgroups | OK | 7s 211ms |
| /parquet/encrypted | Skip | 1ms |
| /parquet/fastparquet | OK | 2m 37s |
| /parquet/fastparquet/airlines | OK | 7s 171ms |
| /parquet/rowgroups/manyrowgroups2 | OK | 5s 589ms |
| /parquet/fastparquet/baz | OK | 5s 446ms |
| /parquet/read and write | OK | 17m 9s |
| /parquet/read and write/read and write parquet file | OK | 17m 9s |
| /parquet/fastparquet/empty date | OK | 16s 699ms |
| /parquet/fastparquet/evo | OK | 34s 578ms |
| /parquet/fastparquet/fastparquet | OK | 1m 33s |
| /parquet/query/compression type/=GZIP /select from distributed table into file | OK | 5m 10s |
| /parquet/query/compression type/=LZ4 /select from distributed table into file | OK | 5m 10s |
| /parquet/query/compression type/=NONE /select from distributed table into file | OK | 5m 7s |
| /parquet/query/compression type/=GZIP /select from mat view into file | OK | 4m 19s |
| /parquet/query/compression type/=NONE /select from mat view into file | OK | 4m 19s |
| /parquet/query/compression type/=LZ4 /select from mat view into file | OK | 4m 17s |
| /parquet/query/compression type/=LZ4 /insert into table with projection from file | OK | 1m 21s |
| /parquet/query/compression type/=GZIP /insert into table with projection from file | OK | 1m 22s |
| /parquet/query/compression type/=NONE /insert into table with projection from file | OK | 1m 22s |
Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232