Parquet Test Run Report

DateJul 20, 2023 14:46
Duration1h 20m
Framework TestFlows 1.9.230315.1003122

Artifacts

Test artifacts can be found at https://altinity-test-reports.s3.amazonaws.com/index.html#clickhouse/23.3.8.23.altinityfips/5612444287/testflows/

Attributes

projectAltinity/clickhouse-regression
project.id530821975
user.nameMyroTk
version23.3.8.23.altinityfips
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.3/3a254fe0cc318f5620a5df4043f7c6d322a8ad04/package_release/clickhouse-common-static_23.3.8.23.altinityfips_amd64.deb
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash5b6892cfbca37b70e55a27a9b29eeea730251d4e
job.id5612444287
job.urlhttps://github.com/Altinity/clickhouse-regression/actions/runs/5612444287
archamd64
nodeclickhouse1
localTrue
clickhouse_version23.3.8.23.altinityfips
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/23.3/3a254fe0cc318f5620a5df4043f7c6d322a8ad04/package_release/clickhouse-common-static_23.3.8.23.altinityfips_amd64.deb
stressFalse
collect_service_logsTrue
storagesNone
minio_urihttp://minio1:9001
minio_root_userminio
minio_root_passwordminio123
aws_s3_bucketNone
aws_s3_regionSecret(name='aws_s3_region')
aws_s3_key_idSecret(name='aws_s3_key_id')
aws_s3_access_keySecret(name='aws_s3_access_key')
gcs_uriNone
gcs_key_idNone
gcs_key_secretNone

Summary

99.6%OK
<1%Known

Statistics

Units OK Fail XFail
Modules
1
1
Suites
21
20
1
Features
17
16
1
Scenarios
205
205
Checks
227
227
Examples
24
24
Steps
412525
412479
2
44

Known Fails

Test NameResultMessage
/parquet/chunked arrayXFail 7s 740ms
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: 36. DB::Exception: Invalid: Parquet magic bytes not found in footer. Either the file is corrupted or this is not a parquet file.: While executing ParquetBlockInputFormat: While executing File: data for INSERT was parsed from file. (BAD_ARGUMENTS) (version 23.3.8.23.altinityfips (altinity build))
(query: INSERT INTO table_a15ee9d6_2715_11ee_b3e9_9b73a19de296 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\|

Results

Test Name Result Duration
/parquet OK 1h 20m
/parquet/file OK 37m 37s
/parquet/file/engine OK 25m 10s
/parquet/file/engine/insert into engine OK 3m 33s
/parquet/query OK 55m 42s
/parquet/query/compression_type='NONE' OK 18m 26s
/parquet/query/compression_type='NONE'/insert into memory table from file OK 31s 962ms
/parquet/query/compression_type='NONE'/insert into mergetree table from file OK 29s 903ms
/parquet/query/compression_type='NONE'/insert into replicated mergetree table from file OK 29s 878ms
/parquet/query/compression_type='NONE'/insert into distributed table from file OK 33s 493ms
/parquet/query/compression_type='NONE'/select from memory table into file OK 2m 52s
/parquet/file/engine/select from engine OK 35s 881ms
/parquet/file/engine/engine to file to engine OK 6m 4s
/parquet/query/compression_type='NONE'/select from mergetree table into file OK 3m 7s
/parquet/query/compression_type='NONE'/select from replicated mergetree table into file OK 3m 35s
/parquet/file/engine/insert into engine from file OK 1m 35s
/parquet/query/compression_type='NONE'/select from distributed table into file OK 3m 34s
/parquet/file/engine/engine select output to file OK 13m 21s
/parquet/query/compression_type='NONE'/select from mat view into file OK 2m 43s
/parquet/query/compression_type='NONE'/insert into table with projection from file OK 26s 883ms
/parquet/query/compression_type='GZIP' OK 19m 16s
/parquet/query/compression_type='GZIP'/insert into memory table from file OK 27s 700ms
/parquet/query/compression_type='GZIP'/insert into mergetree table from file OK 28s 744ms
/parquet/query/compression_type='GZIP'/insert into replicated mergetree table from file OK 28s 697ms
/parquet/query/compression_type='GZIP'/insert into distributed table from file OK 31s 754ms
/parquet/query/compression_type='GZIP'/select from memory table into file OK 2m 48s
/parquet/query/compression_type='GZIP'/select from mergetree table into file OK 3m 14s
/parquet/file/function OK 12m 26s
/parquet/file/function/insert into function manual cast types OK 3m 10s
/parquet/query/compression_type='GZIP'/select from replicated mergetree table into file OK 3m 11s
/parquet/file/function/insert into function auto cast types OK 4m 7s
/parquet/query/compression_type='GZIP'/select from distributed table into file OK 3m 42s
/parquet/file/function/select from function manual cast types OK 4m 27s
/parquet/query/compression_type='GZIP'/select from mat view into file OK 3m 45s
/parquet/file/function/select from function auto cast types OK 41s 171ms
/parquet/query/compression_type='GZIP'/insert into table with projection from file OK 37s 563ms
/parquet/list in multiple chunks OK 11s 219ms
/parquet/query/compression_type='LZ4' OK 17m 59s
/parquet/query/compression_type='LZ4'/insert into memory table from file OK 30s 902ms
/parquet/url OK 41m 3s
/parquet/url/engine OK 30m 16s
/parquet/url/engine/insert into engine OK 5m 1s
/parquet/query/compression_type='LZ4'/insert into mergetree table from file OK 27s 963ms
/parquet/query/compression_type='LZ4'/insert into replicated mergetree table from file OK 27s 637ms
/parquet/query/compression_type='LZ4'/insert into distributed table from file OK 30s 968ms
/parquet/query/compression_type='LZ4'/select from memory table into file OK 2m 47s
/parquet/query/compression_type='LZ4'/select from mergetree table into file OK 3m 28s
/parquet/url/engine/select from engine OK 38s 932ms
/parquet/url/engine/engine to file to engine OK 6m 49s
/parquet/query/compression_type='LZ4'/select from replicated mergetree table into file OK 3m 16s
/parquet/query/compression_type='LZ4'/select from distributed table into file OK 3m 22s
/parquet/url/engine/insert into engine from file OK 3m 8s
/parquet/query/compression_type='LZ4'/select from mat view into file OK 2m 39s
/parquet/url/engine/engine select output to file OK 14m 39s
/parquet/query/compression_type='LZ4'/insert into table with projection from file OK 27s 128ms
/parquet/mysql OK 17s 526ms
/parquet/mysql/compression_type='NONE' OK 6s 233ms
/parquet/mysql/compression_type='NONE'/mysql engine to parquet file to mysql engine OK 3s 452ms
/parquet/mysql/compression_type='NONE'/mysql function to parquet file to mysql function OK 2s 779ms
/parquet/mysql/compression_type='GZIP' OK 5s 645ms
/parquet/mysql/compression_type='GZIP'/mysql engine to parquet file to mysql engine OK 2s 910ms
/parquet/mysql/compression_type='GZIP'/mysql function to parquet file to mysql function OK 2s 734ms
/parquet/mysql/compression_type='LZ4' OK 5s 645ms
/parquet/mysql/compression_type='LZ4'/mysql engine to parquet file to mysql engine OK 2s 857ms
/parquet/mysql/compression_type='LZ4'/mysql function to parquet file to mysql function OK 2s 787ms
/parquet/postgresql OK 24s 635ms
/parquet/postgresql/compression_type='NONE' OK 8s 526ms
/parquet/postgresql/compression_type='NONE'/postgresql engine to parquet file to postgresql engine OK 5s 127ms
/parquet/postgresql/compression_type='NONE'/postgresql function to parquet file to postgresql function OK 3s 398ms
/parquet/postgresql/compression_type='GZIP' OK 8s 9ms
/parquet/postgresql/compression_type='GZIP'/postgresql engine to parquet file to postgresql engine OK 4s 546ms
/parquet/postgresql/compression_type='GZIP'/postgresql function to parquet file to postgresql function OK 3s 462ms
/parquet/postgresql/compression_type='LZ4' OK 8s 97ms
/parquet/postgresql/compression_type='LZ4'/postgresql engine to parquet file to postgresql engine OK 4s 752ms
/parquet/postgresql/compression_type='LZ4'/postgresql function to parquet file to postgresql function OK 3s 344ms
/parquet/remote OK 9m 30s
/parquet/remote/compression_type='NONE' OK 3m 13s
/parquet/remote/compression_type='NONE'/insert into function OK 28s 74ms
/parquet/remote/compression_type='NONE'/select from function OK 2m 45s
/parquet/remote/compression_type='GZIP' OK 3m 9s
/parquet/remote/compression_type='GZIP'/insert into function OK 28s 134ms
/parquet/remote/compression_type='GZIP'/select from function OK 2m 41s
/parquet/remote/compression_type='LZ4' OK 3m 7s
/parquet/remote/compression_type='LZ4'/insert into function OK 27s 518ms
/parquet/remote/compression_type='LZ4'/select from function OK 2m 39s
/parquet/chunked array XFail 7s 740ms
/parquet/broken OK 3s 146ms
/parquet/broken/file OK 87ms
/parquet/broken/read broken bigint OK 77ms
/parquet/broken/read broken date OK 49ms
/parquet/broken/read broken int OK 58ms
/parquet/broken/read broken smallint OK 58ms
/parquet/broken/read broken timestamp ms OK 60ms
/parquet/broken/read broken timestamp us OK 52ms
/parquet/broken/read broken tinyint OK 63ms
/parquet/broken/read broken ubigint OK 96ms
/parquet/broken/read broken uint OK 63ms
/parquet/broken/read broken usmallint OK 70ms
/parquet/broken/read broken utinyint OK 56ms
/parquet/broken/string OK 2s 346ms
/parquet/encoding OK 10s 480ms
/parquet/encoding/deltabytearray1 OK 1s 433ms
/parquet/encoding/deltabytearray2 OK 1s 546ms
/parquet/encoding/deltalengthbytearray OK 1s 413ms
/parquet/encoding/dictionary OK 1s 516ms
/parquet/encoding/plain OK 1s 444ms
/parquet/encoding/plainrlesnappy OK 1s 676ms
/parquet/encoding/rleboolean OK 1s 445ms
/parquet/compression OK 31s 706ms
/parquet/compression/arrow snappy OK 1s 499ms
/parquet/compression/brotli OK 1s 488ms
/parquet/compression/gzippages OK 3s 85ms
/parquet/compression/largegzip OK 1s 544ms
/parquet/compression/lz4 hadoop OK 1s 455ms
/parquet/compression/lz4 hadoop large OK 1s 446ms
/parquet/compression/lz4 non hadoop OK 1s 506ms
/parquet/compression/lz4 raw OK 1s 527ms
/parquet/compression/lz4 raw large OK 1s 500ms
/parquet/compression/lz4pages OK 2s 973ms
/parquet/compression/nonepages OK 3s 84ms
/parquet/compression/snappypages OK 3s 74ms
/parquet/compression/snappyplain OK 1s 441ms
/parquet/compression/snappyrle OK 1s 592ms
/parquet/compression/zstd OK 1s 464ms
/parquet/compression/zstdpages OK 3s 17ms
/parquet/datatypes OK 1m 27s
/parquet/datatypes/arrowtimestamp OK 1s 532ms
/parquet/datatypes/arrowtimestampms OK 1s 539ms
/parquet/datatypes/binary OK 1s 442ms
/parquet/datatypes/binary string OK 1s 551ms
/parquet/datatypes/blob OK 1s 466ms
/parquet/datatypes/boolean OK 1s 427ms
/parquet/datatypes/byte array OK 1s 450ms
/parquet/datatypes/columnname OK 1s 514ms
/parquet/datatypes/columnwithnull OK 1s 523ms
/parquet/datatypes/columnwithnull2 OK 1s 492ms
/parquet/datatypes/date OK 1s 496ms
/parquet/datatypes/decimal with filter OK 1s 482ms
/parquet/datatypes/decimalvariousfilters OK 1s 446ms
/parquet/datatypes/decimalwithfilter2 OK 1s 524ms
/parquet/datatypes/enum OK 1s 591ms
/parquet/datatypes/enum2 OK 1s 503ms
/parquet/datatypes/fixed length decimal OK 1s 499ms
/parquet/datatypes/fixed length decimal legacy OK 1s 499ms
/parquet/datatypes/fixedstring OK 1s 473ms
/parquet/datatypes/h2oai OK 1s 529ms
/parquet/datatypes/hive OK 2s 971ms
/parquet/datatypes/int32 OK 1s 445ms
/parquet/datatypes/int32 decimal OK 1s 539ms
/parquet/datatypes/int64 OK 1s 475ms
/parquet/datatypes/int64 decimal OK 1s 477ms
/parquet/datatypes/json OK 1s 557ms
/parquet/datatypes/largedouble OK 1s 754ms
/parquet/datatypes/manydatatypes OK 1s 725ms
/parquet/datatypes/manydatatypes2 OK 1s 716ms
/parquet/datatypes/maps OK 1s 603ms
/parquet/datatypes/nameswithemoji OK 1s 767ms
/parquet/datatypes/nandouble OK 1s 646ms
/parquet/datatypes/negativeint64 OK 1s 755ms
/parquet/datatypes/nullbyte OK 1s 684ms
/parquet/datatypes/nullbytemultiple OK 1s 634ms
/parquet/datatypes/nullsinid OK 1s 675ms
/parquet/datatypes/pandasdecimal OK 1s 627ms
/parquet/datatypes/pandasdecimaldate OK 1s 714ms
/parquet/datatypes/parquetgo OK 1s 718ms
/parquet/datatypes/selectdatewithfilter OK 4s 591ms
/parquet/datatypes/singlenull OK 1s 499ms
/parquet/datatypes/sparkv21 OK 1s 512ms
/parquet/datatypes/sparkv22 OK 1s 535ms
/parquet/datatypes/statdecimal OK 1s 555ms
/parquet/datatypes/string OK 1s 521ms
/parquet/datatypes/stringtypes OK 1s 557ms
/parquet/datatypes/struct OK 1s 544ms
/parquet/url/function OK 10m 12s
/parquet/url/function/insert into function OK 2m 34s
/parquet/datatypes/supporteduuid OK 1s 355ms
/parquet/datatypes/timestamp1 OK 1s 376ms
/parquet/datatypes/timestamp2 OK 2s 398ms
/parquet/datatypes/timezone OK 1s 575ms
/parquet/datatypes/unsigned OK 3s 89ms
/parquet/datatypes/unsupportednull OK 125ms
/parquet/complex OK 31s 594ms
/parquet/complex/arraystring OK 1s 629ms
/parquet/complex/big tuple with nulls OK 1s 561ms
/parquet/complex/bytearraydictionary OK 1s 631ms
/parquet/complex/complex null OK 1s 496ms
/parquet/complex/lagemap OK 1s 581ms
/parquet/complex/largenestedarray OK 1s 490ms
/parquet/complex/largestruct OK 1s 633ms
/parquet/complex/largestruct2 OK 1s 678ms
/parquet/complex/largestruct3 OK 1s 624ms
/parquet/complex/list OK 1s 559ms
/parquet/complex/nested array OK 1s 665ms
/parquet/complex/nested map OK 1s 614ms
/parquet/complex/nestedallcomplex OK 1s 623ms
/parquet/complex/nestedarray2 OK 1s 478ms
/parquet/complex/nestedstruct OK 1s 686ms
/parquet/complex/nestedstruct2 OK 1s 425ms
/parquet/complex/nestedstruct3 OK 1s 542ms
/parquet/complex/nestedstruct4 OK 1s 645ms
/parquet/complex/tupleofnulls OK 1s 496ms
/parquet/complex/tuplewithdatetime OK 1s 522ms
/parquet/indexing OK 1s 538ms
/parquet/indexing/bigtuplewithnulls OK 1s 537ms
/parquet/cache OK 3s 52ms
/parquet/cache/cache1 OK 1s 516ms
/parquet/cache/cache2 OK 1s 535ms
/parquet/glob OK 1s 244ms
/parquet/glob/glob1 OK 532ms
/parquet/glob/glob2 OK 710ms
/parquet/rowgroups OK 3s 155ms
/parquet/rowgroups/manyrowgroups OK 1s 531ms
/parquet/rowgroups/manyrowgroups2 OK 1s 622ms
/parquet/url/function/select from function manual cast types OK 6m 38s
/parquet/url/function/select from function auto cast types OK 59s 578ms

Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122