This is an automated email from the ASF dual-hosted git repository.
ashingau pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 573f0eaad92 [fix](regression)fix parquet data page v2 unstable case
(#27753)
573f0eaad92 is described below
commit 573f0eaad92fc54500650ccee1219543b64e07d1
Author: daidai <[email protected]>
AuthorDate: Wed Nov 29 18:58:37 2023 +0800
[fix](regression)fix parquet data page v2 unstable case (#27753)
---
.../tvf/test_s3_tvf_parquet_compress.out | 120 ++++++++++----------
.../tvf/test_s3_tvf_parquet_compress.groovy | 124 ++++++++++-----------
2 files changed, 122 insertions(+), 122 deletions(-)
diff --git
a/regression-test/data/external_table_p0/tvf/test_s3_tvf_parquet_compress.out
b/regression-test/data/external_table_p0/tvf/test_s3_tvf_parquet_compress.out
index bdabe4f2b73..3e0cbc3dad9 100644
---
a/regression-test/data/external_table_p0/tvf/test_s3_tvf_parquet_compress.out
+++
b/regression-test/data/external_table_p0/tvf/test_s3_tvf_parquet_compress.out
@@ -6,16 +6,16 @@
-- !gzip_3 --
-- !gzip_4 --
-1564 325 10 143864319215 1.0850098E7 1.8213909835504765E10
false WNimzJ FzUmkpokth rvUeXZDSroGMbmvdAPTWNRwXV 2025-11-05
2023-12-28T05:47:37 44980.17
-1668 491 7 117571775364 9.9940696E7 9.701980510428255E9
false hICAsLLERWs PLyzxBOqLx iAczHecIGIkwPDVzmSDYNIIyo
2024-04-22 2023-12-12T20:16:37 51522.04
-2398 287 1 50023210093 3.3281682E7 1.2771441084116616E9
false GSxpvBtDs uYZxmPFnrD mNnMYQfzuNksmZCDEGMOPJWIo
2021-11-25 2023-12-09T15:39:37 125314.51
-5103 203 5 147767173537 3.2217082E7 1.1398368094759958E10
true DPAJeMetPhaGcLf kCQHOseqxM yFIubHohRHbNtLdTiNQyJLzpX
2024-08-19 2023-12-22T21:16:37 184070.99
-6192 8 4 143947090532 5.5333332E7 1.4477460789058594E10
false NUSfncaPiVPOWoWy yiOZtVUmxn hgFZMFnahwWauiTUDRGcrbHjm
2026-08-10 2023-12-01T10:19:37 86351.44
-6226 75 7 64107996632 2.043812E7 4.68241706778275E9
true YDJUttKPsJPknJgPCCsQ OichDrHpbR JYbDuynhpVcSMMiwklJiHswdS
2027-05-27 2023-12-27T09:59:37 63291.69
-7177 242 10 79143578402 2.1207298E7 3.493073001162331E9
false IoXxoANRdLzi JHGiUNthsU hCmzdYYcmlyEUmUtjKiKpOkHS
2022-03-24 2023-12-13T03:07:37 112661.56
-862 263 1 39973050004 1.9387052E7 4.176116841836267E9
false lXnSrcNHfgYzHURCw cMjrYqCetO XjHjiVpwZskvmqBrRkgcLMTFO
2024-04-30 2023-12-11T04:57:37 5197.78
-9525 387 9 25195785817 5.8421788E7 1.4225957898379774E10
true XHGfSkbzrK ENCcNrCbNp svCnWJvgSCrxXhBJDzqYXfSot
2028-07-24 2023-12-18T12:43:37 139546.08
-9945 163 10 141900020369 3.2400444E7 1.554696451316843E10
true AlzTfwn WpLULspqZK FRufswEdXHiJslGvsBzqppFAb 2024-08-03
2023-12-14T19:02:37 161665.49
+185 193 53 56605217928 5.451878E7 1.9952208284243374E10
false ylOkeCpMZmsAdfMZKU SLWxRpdBGB iqGOSxAYdFcGicLkovFewsIsp
2031-06-05 2023-12-09T04:40:37 94603.01
+295 417 20 148276324771 4.7573584E7 1.606954292368833E10
false McFVbRNqw GWLZYJnSAm JRdtgaVkQFpuQfeShCtmsKQVs
2033-10-21 2023-12-13T14:23:37 103618.10
+352 272 50 132842035948 3.9088484E7 1.4114080886312649E10
false YStkfSPLEW ZjhIqBBkqF VZTwrLVdgfWkfprNXhGgclQKg
2024-05-28 2023-12-24T01:05:37 153759.13
+361 410 73 80944806602 4.0352936E7 1.2128315118429937E10
false OX tnYxueTSNX AYQmNmBAaLGzTfLifPwEQQftT 2020-11-22
2023-12-14T06:01:37 129452.40
+415 215 22 65540407472 3625543.2 1.0412365247547463E9
false OAfCmDFdnjHq SSQXXGOcvi ClHKPGmpfmtJNrapLLvkddEtt
2027-03-27 2023-12-01T06:56:37 152754.22
+49 78 54 26445927221 5.1698004E7 1.4099392773994835E10
false cRIntlcdDaGWbSGEbaFB gxwUYJirCB waWtBfdOtbKMXKaKpbGYEhqFN
2033-08-11 2023-12-15T18:45:37 83181.72
+490 103 54 119509966565 2.4116646E7 1.9869840205733356E10
true dRqNdTPkzDAbqqmzn uSrGbvtVdi QJOncduXQYNfwoMaNDKSnyhcg
2029-07-02 2023-12-25T12:03:37 67311.03
+626 457 47 72797784919 4.8966996E7 2.565888388726609E9
true uT aKNykzWDJs nHrOUfGgcFnnYcKhJbxLhCLIl 2029-02-03
2023-11-29T13:04:37 174501.34
+717 122 27 59784778057 3.564988E7 1.1160980469798027E10
false odeCVHNGbZUGRl TVjEIrOOMu OsRMnfURWsiKKFrQtjyUXmQQn
2020-07-15 2023-12-14T16:51:37 196108.06
+745 325 20 78752727055 1.5183382E7 1.4748467499527681E10
true RhpEbfrQGGxLL dYqOOUfWfh NQQSFeDTyPKGaphBPcUGwlRhm
2021-08-15 2023-12-02T21:28:37 93769.74
-- !gzip_5 --
@@ -26,16 +26,16 @@
-- !lz42_3 --
-- !lz42_4 --
-123 413 41 31256173112 2538895.0 1.210256462227462E10
false FIYhbaoeYKzioDcSIz vAREVcDTxz NaKatTOFKKfeYovtAWbqluYUx
2025-01-09 2023-12-08T05:21:35 555.68
-1542 143 46 108520036928 5.1077408E7 2.0487181788492233E10
false zdVnykLiePDoSj pYmTnloWbn vlTDesIFoKSXWQJmeyErnfwFK
2030-08-08 2023-12-10T00:48:35 148.54
-2266 433 15 105873219227 4.8684736E7 5.265299058631221E9
false apY EWkXLOcGmD DHRGKmaGJWuwwlGIOvclnByns 2033-01-01
2023-12-02T09:51:35 50.23
-2819 271 28 81725301437 9.4405816E7 9.82620901000283E9
true zebrXdGTGMxroIJo rQcxNXPrFr KYvVTfcDEpcmVaQXNZjrJiqvY
2026-11-06 2023-12-06T14:59:35 1384.35
-3268 165 1 142401321962 5.5133996E7 2.5486781033954887E9
false nCUvMFaXKfKT gQcpCbLvQL rRbshNHLVMQfzwQtsZtfaEYHY
2021-02-22 2023-12-06T15:51:35 1327.90
-3926 200 13 30050982563 7862024.5 1.7841214369751728E10
true zHMdgMgWrRUmRUYip wgZSJxVesm LNSmWNNfFPXivwLRNwLnlRCzn
2023-04-09 2023-12-19T09:43:35 409.24
-4203 374 60 122945496780 8.3296E7 1.764882208561375E10
false RmXtfizgsUDyoCE CYIzLVHYvD AEIiIKOATksgORAVpcdSFPBJH
2034-05-31 2023-12-03T17:46:35 326.42
-6529 439 29 73416430566 3.3359424E7 1.949241511173809E10
true myzr WtZMVXtpun pfvgwYcdPwNyqeNjKqphtdXyU 2026-03-31
2023-12-05T20:43:35 872.26
-7888 252 12 144084724700 3.2299228E7 1.8406068854886074E10
false nbVmBNsQuFTmCrpR kXNeJxUWsF aYyEfoELUAQFRlfXJbRrbpcsW
2027-12-02 2023-12-08T01:58:35 714.86
-8850 286 68 31796762044 5.2957636E7 9.745578729562857E9
true FtClyHG LLkLmyPxXG sGGgIBVklPCiupCfQfHNyLiHn 2033-07-05
2023-12-18T11:17:35 1117.50
+12 25 23 37690551367 1739118.0 1.5796150955205643E10
false CRYGKFUJbGBIe hzxdvVhixg dKsFlyxrgmWgUPubvFMiEVAMw
2025-09-25 2023-11-30T09:03:35 191265.80
+13 101 46 114744069847 9.9938768E7 1.4837020807992098E10
false gfCNYXL ZbPnzJwYeK jCbLcczVZCXQLIrWzKLSrzCdP 2021-02-09
2023-12-15T23:15:35 64827.72
+2 185 42 149520919149 3.4833664E7 1.1822608934606503E10
false IcdmGgK cEfdjzUnlR POxVvslyyYrPzvqMnPdIyWsYc 2024-05-12
2023-12-15T17:47:35 142341.23
+26 32 38 60671962182 7531824.5 1.4733848060344421E10
true KOYetyhzellUqvUVqN dikJqNhnFx ndvjDRNIMrJHIvSldXaEvFXLT
2021-09-09 2023-12-10T20:05:35 193323.54
+34 327 13 77750585316 5.2026716E7 1.3565608513727581E10
false wNPvbSoifnwLtHTqoEi YZjfEkKIGV FmUQtlZsMnbGcotsabDCuZzCv
2031-11-30 2023-12-13T19:25:35 66427.85
+34 471 26 135806034349 8076124.0 1.0066063806334663E10
false rKYxkXtBaGerDm GVJmQKDnEG GhZmOjSBgagfERePNKqrfRPZP
2033-02-27 2023-12-09T01:50:35 108043.94
+39 353 62 132230399602 6.4890496E7 1.4364807353729563E10
true VndnuqCCaOtRKUKWopUp VlPHqQRqYm wMidbmfhIEojjzjwECenSMHGs
2027-02-15 2023-12-21T10:23:35 183030.50
+45 26 68 53752579002 8.9017168E7 1.9340340329838943E10
true OINGDCPkvdhkdmcS YkepCHrjOr SZYiGERTakzzzMMKpNQdhqLOc
2030-09-21 2023-12-12T20:08:35 130910.41
+53 72 65 146006164519 6.6903E7 2.0507334388700092E10
false TPJuvqCXK qSHjDEfYui lOZFyOETtUFghsoMcckCdEMcf
2024-06-23 2023-12-13T14:40:35 165043.20
+55 347 32 75539160521 1353359.8 1.2653349834209116E10
false zkaBxLzoya bsAfSUONxQ bdTgPzPbidbAlEaYYKgTckHYn
2030-06-14 2023-11-29T19:10:35 188584.20
-- !no_null_none_1 --
@@ -88,16 +88,16 @@
-- !no_null_snappy_3 --
-- !no_null_snappy_4 --
-1735 271 9 60346027512 7.1809408E7 1.1542596070194454E8
true PQhXcQjEVEcvB GNTURsqQPR uxoVrWvvQpRdURLefjWPqcuym
2031-07-13 2023-12-28T09:29:39 48192.71
-2580 50 58 69249672497 6.85824E7 8.513882709782144E7
false vVnpuJWDJh qLonevGdLz wndtBVgAzlHyCSoEoScfQziYf
2024-12-30 2023-12-10T07:01:39 197543.36
-3763 436 31 107071953533 5.33427E7 9.534465359291871E7
false QFWLOoIYXgLRug KLBTuyZUlR fZIFxGHUYQRikplSkQjZlsqCF
2025-05-30 2023-12-13T00:50:39 26625.70
-5462 472 21 104973629214 9.6762848E7 2.185684504798187E7
false kwkYBLTUsKDw OkUwAMMFya cMhuewGhSxHeoJLQXULzrlCms
2034-06-02 2023-12-02T22:41:39 63617.65
-5474 426 12 42722162752 3.2170124E7 8.804404064844951E7
false cpq zscIVsMewJ ORxiIkBaPyHTMHxlNyfmjChon 2025-08-27
2023-12-21T03:33:39 181825.24
-5857 368 52 40930392551 6.1337756E7 1.023509329427285E8
true UDzC PTMXXZsvyE EMbfwFEmQIbMkfrPKiDVYeHOA 2021-09-19
2023-12-14T15:06:39 43382.62
-6335 247 23 75599898342 9.260008E7 2.7036205338388097E7
true yEThqFnRPj EJwgAOLnsm iLoukKsngncSxxqacAFHnVIqi
2028-09-16 2023-12-09T05:07:39 156419.99
-670 15 14 98662225199 9.1477744E7 6.88714186315456E7
false DuufJxCIGmoVHSLWP LuqwUtKFDW RyCajswEVhOXYIOupVDmJUfqh
2025-12-02 2023-12-22T13:21:39 120131.69
-7733 141 1 52671352949 7.4806392E7 1.110764780477845E7
false QVmPZWSLpRNPWyD wuvRYvaFqt xdvwMENBnAipsOZOBDVgRbLmu
2024-06-03 2023-12-27T17:23:39 118699.19
-9405 409 21 107351298418 1.9931788E7 5.6723663780093096E7
true ADRhycfiHBGBtvlJeVcb NUeaftoSmT HioPrElDQXvaGJJKaBJzOgQxV
2031-04-01 2023-12-24T10:27:39 62226.72
+1 154 47 56558270788 5.4536948E7 1.3217071820869438E10
false XfvMcpmTrBwVVUFBTfv UpvjnTPFYK VCsoIshvMNTdAKzAmrpopbBnR
2025-07-30 2023-12-04T09:05:39 130077.82
+21 279 45 100090340220 5.3739808E7 1.6962735429451965E10
true vau YstuEEpUYl BqDxtlDptzwYLnFbBsHBSyVEj 2031-12-05
2023-12-01T07:26:39 158763.22
+22 147 37 38451482962 5.7348188E7 6.709969882160862E9
false UsMqGSrPdhvPv YKKcbDNgAY XuineFLOuEKDopqiOrRRWFkON
2031-01-08 2023-12-06T01:52:39 62344.33
+26 314 66 48416066859 5.075556E7 1.2613108635303028E10
true HzZTVwGWlDzZ lKrSRRzJEk eLMsGzGoiLirCeHtUkBFTJTJy
2033-03-30 2023-11-28T20:01:39 61085.83
+35 41 6 74116293939 9.5409224E7 3.0375883609755764E9
true iHalWMyJKwcCcnXIZc oRmnkittIB qOoLzOpilUqAOvQBOyYlPoiIr
2034-03-02 2023-12-12T09:21:39 18991.90
+35 96 33 129564598321 5.8018556E7 1.7037885810063845E10
true gjVoXOHOQndHncvaFQC WgMShQxLQL VvyPxLnaEZeOemJbosqSkSvEl
2021-01-31 2023-12-19T08:06:39 152296.20
+36 256 59 34966299569 9.0360968E7 1.6050368291434975E10
false cxDqSdYXQXcUgizXbq mQsNaawIJP pbjcFsDoRAzvmMNphXQoBtmzb
2031-10-27 2023-12-25T21:18:39 140767.55
+4 417 21 32611494638 5.462062E7 2.392456171662606E9
true JPMliq ouZEKYBjoH GNsUsuuGbynVCwJeexZdaQnCl 2027-10-06
2023-12-18T11:43:39 121553.06
+43 179 36 147307082013 3.8981628E7 2.0026077534463943E10
true JPBDURDCLAbeKg lurvLFZwae aVuYHsksMZhapxxdmyfFcDSgd
2020-04-08 2023-12-16T08:12:39 60879.14
+46 281 4 81012784171 5.5589576E7 1.9537200475225827E8
true LTKJwkcwNdKRfpUxxe aSgtpzTLKj ynECHVHsichYRKumIUELddPOl
2031-11-10 2023-12-18T02:30:39 137501.43
-- !none2_1 --
@@ -106,16 +106,16 @@
-- !none2_3 --
-- !none2_4 --
-2900 341 25 10088150880 5.875234E7 1.9284854951681435E10
false MPqcsUwkAhLhIxW YLKXNemlov yqpLcuiwpSwnLpVjFAYvSfNTi
2022-01-07 2023-12-01T21:40:04 190184.28
-4487 495 13 10316747093 1.8574004E7 1.7523820634890663E10
false kjYchCMTsJoauXDU NhsQKtYfMa ljEeEquWuPKYLxlCQCSmyoJBn
2024-12-02 2023-12-08T07:25:04 22883.65
-5013 407 62 10169303340 8.2304232E7 1.3872229599628126E10
true QCrLjklhO NnbYgnqDeO kDVRVqrCjovqAxQrsHGspLJmQ
2020-10-22 2023-12-26T19:59:04 86383.93
-5482 371 36 10287245865 3.3911876E7 9.899660468716501E9
true Ofy RYuzpCqRIc nmoJWtBbOWhSciXIqEkLEtTFS 2022-03-19
2023-12-07T06:53:04 12159.62
-6944 307 35 10118760839 4.9430636E7 8.928666056824632E8
false ApHXeJos icTrKTCPxK RZvXnTYnrYuljysldIRmAcMSC
2023-03-30 2023-12-13T05:17:04 176750.16
-805 425 34 10087075925 3.3842428E7 9.340510350959852E9
false MFeTfBOFrxtpI adpglhhSaH ogFqttOhPHKxDhrPYmQYiHfAu
2033-10-16 2023-12-04T10:43:04 40377.50
-8347 72 45 10263415754 1.7299256E7 1.3399835950398888E8
true qXGHpJcAvL czwVIPKiKo ButfIhNLWrlcBFIoKqHNlgZdN
2022-11-05 2023-12-21T10:56:04 11735.63
-8768 143 35 10146208549 7.8137584E7 8.967516129741959E9
true CyppoJFFmpNoNxnx bmlKHaErTd mWKfQzFZCiAPsJsAKLwWqpEeI
2026-04-05 2023-12-26T19:22:04 165288.57
-9165 340 4 10163157832 3100085.0 2.185136235034098E10
false yelYDBtfnlnJV QVlHPpYVQc DufhLfGcUVjQXtiYZmEjiQrrn
2021-04-07 2023-12-05T22:31:04 185971.87
-9761 110 4 10133304479 3.2209318E7 6.632848353229889E9
false dUtCFGnLMWbtEg IMJlPtaOJp tBDIlqGuEzzXEyVgkYASycvEd
2020-03-05 2023-12-24T15:25:04 79100.17
+10 133 23 110735234104 4.1348184E7 6.724669852415883E9
true qylrxSiSgrKu fXIxvHGluy eklOsykJrnQGIRLaIEelHwdzm
2024-03-02 2023-12-22T05:49:04 176211.72
+11 394 66 99624300897 2.274807E7 4.963466594895596E9
true mVdYGIMifFUBHNatRyM KRqNQRaSDg dylbZDzYyzsqShMkWFpDAYSCU
2021-04-05 2023-12-19T18:30:04 147684.86
+12 477 37 63993096030 5.7643764E7 2.0866619972258877E10
false wNKtMCuCVaDcwu WVFlxBfRpW kwpESPDNaofDFMnOviauLBAIl
2026-12-09 2023-12-08T23:50:04 140885.38
+12 52 50 13187171725 4.328852E7 1.439178560256354E9
false GfUoPlFQvfNaLdk HFpbCrThUT JjjCcBGUUMpkyXRbjrhSYpfSx
2030-06-14 2023-12-26T18:02:04 88542.26
+15 499 46 41312302840 5.216176E7 1.9019488905673557E10
true tahGGPipseDsw bHtFJxGJmZ wQyXJUELxYRbgjbHaVIrUQCks
2029-09-19 2023-11-30T21:09:04 26654.48
+4 160 11 119904143312 6.7974712E7 1.866353471070769E10
true GNJyKlQlBoDlvy agZHVaqlIU SYZxyOTcjCDfaHSksJaoDYxIA
2034-05-15 2023-12-04T18:43:04 130407.15
+41 394 40 49490189808 1.2031474E7 3.1199659364367003E9
false GLUtKxYhrX aPyQlkqHsn KhpRXlHRPHvCbmlRWrpKwYuuX
2024-02-11 2023-12-01T19:02:04 83410.50
+45 439 31 67121611959 3.5429484E7 7.620345797982114E9
false uhSD qHGFMshLLp rONGaSIkJJQPlFBfhBsEwcqMe 2022-02-02
2023-12-04T19:43:04 936.05
+47 290 34 19180961481 2.3980818E7 8.905338300548578E9
false JynKEvLPvFHGKvyDVv mScFpzPIrA BMLACiTfOubXNgJAiVUfhvtVt
2024-06-21 2023-12-16T15:41:04 49807.06
+9 92 36 145734369838 2.6161538E7 1.7063014826469292E10
false yjeyyDOEgViRwbRVArt yGxosmUWEC tqLZwzBiPPltSdbpVChwkWNRF
2025-06-22 2023-12-05T21:26:04 146649.97
-- !none2_5 --
@@ -126,16 +126,16 @@
-- !zstd2_3 --
-- !zstd2_4 --
-1312 340 14 147176897373 6.3653556E7 1.7178218821412378E10
false eXMf SJpBpVYWbs nvxKEbmWqTJFIhCeRHUvRKiGZ 2024-03-02
2023-12-11T18:07:09 123613.01
-2433 340 32 134681184365 1.7680632E7 1.7563484635199E10
false DhFjIB npUzPUDfiY ZrQEgsknIVNRuXbsCtrZxGFSc 2026-03-18
2023-12-22T00:58:09 35433.79
-2491 104 36 112577913121 1834077.0 1.893395865292783E10
false tglGVhSAklagcHqAGTv DaAXlKbnfW AwSQlUAYmxhdISjFjTnZmDTrx
2020-02-29 2023-12-06T20:17:09 29655.53
-3820 157 11 24723365393 2.0236874E7 5.997382284492535E9
false hhFUUD XYXpXoWRon BFrNYOBeYeNxChfVKlfSxFulM 2032-07-15
2023-11-28T14:33:09 64603.31
-5055 336 55 26887547526 6.9563584E7 5.760953396099434E9
false HMrzLVqDTDZOrTAvny uqYYmEBWQQ ZbCUzMghvzBOjdJUutdqppVoD
2034-05-16 2023-12-21T23:56:09 111103.27
-5137 106 43 47754302132 4.8185832E7 1.1526454048268053E10
false NxOuXWyGyg kzQtEEToOb qlNYVnGdYSsrpJzJHrURqzjPg
2027-10-08 2023-12-21T15:41:09 99731.29
-5224 132 41 112455524629 3.3051536E7 9.941947060306278E9
false nIgnvryfvRbar ciRFZTrdUT gnQYthtqWZUhgPHOEGEAuwJlA
2026-03-09 2023-12-09T06:56:09 84164.06
-5793 296 10 52907730760 9.5646328E7 1.1200586288381305E9
false KxKBVpworG DiWOJelnFx xvkUQpaLHqEoXCvpRVgLhCTUu
2034-12-05 2023-12-10T22:23:09 30967.64
-8884 65 74 85010558965 6.6290416E7 1.2063704499794256E10
false pMPAXZGzVknskKmIlDl QlGlscSWGY iqgGtUWNjyliThgZLticgzxqs
2030-12-01 2023-12-04T17:57:09 124538.85
-973 272 63 28184649837 2.170711E7 4.759095368836494E9
false FGwKfBVzugJ NHAvnpmlfq hMglZrwBcMfSXiFLTFVlxjdnD
2024-12-09 2023-12-01T10:29:09 61038.36
+25 108 31 149098682156 4.8272672E7 5.930003546336057E9
true dAtUCcFxXKk sQIGXEgYNT ZPbhiaUnywWcJErUhjWJlTuja
2028-02-17 2023-12-05T13:00:09 104331.10
+25 217 18 114185433037 7.6510376E7 1.0861182565773449E10
false Dfnwto wPnPnVkuVc OxCVhlSZORwnIvoBTUzyZayLF 2019-03-26
2023-12-23T05:47:09 64693.45
+58 331 36 59407318513 1.4188228E7 1.0117605147311861E10
false kflDCVAYbcs ipNFhPgRKv rMRGLlJXRXUnZesnAQboIFmaA
2021-08-17 2023-12-17T15:08:09 183820.26
+65 147 38 21817494173 6070327.5 1.5818161359746944E10
true RFtD BsehDZuGNw QBIDYmMhQvghksPLjTDkXdEvu 2033-08-20
2023-12-17T21:12:09 54614.36
+7 12 47 71342719085 4613431.5 1.3705618365178734E10
true XenTgJvpZFFiriibVE oxAlQKcypL iFNqxDRELyNOWhWEgvhDOUwBs
2033-04-11 2023-12-16T17:33:09 161342.39
+79 95 64 90406816348 8.6113624E7 9.057061555897038E9
true TuEKTQzaZecgnk CnTjiGIdvo KjxJGDlSdpTntCnGgHQWjYeMK
2034-04-14 2023-12-16T18:59:09 176973.77
+81 128 73 25218454317 9.3758232E7 4.90567313620045E9
true scj KRJIgLpBZg xygkYhTRmAmVhXUxSnaseltsb 2028-10-25
2023-11-29T00:41:09 164248.11
+83 52 67 122533885998 3.7610484E7 9.136770151694872E9
true rzKkvolDCKDKhf MyDYVefDpx edPSYNkjtKXmAvqLLLvfhiBzV
2028-09-02 2023-12-20T07:25:09 58108.15
+87 272 39 127196423938 2.3952176E7 7.701823624333466E9
false xvVAbRaqWwGKmr OJakVHUwPp ejlHDXfcoftCkWVyDRsgYmmwi
2030-01-12 2023-12-21T02:11:09 151881.70
+99 252 8 99743310755 5003965.5 1.7335544354242287E10
true SrXh oLATQNrFUt wWrkNwanllbGArJbLtkBtaRRw 2020-12-31
2023-12-16T02:24:09 94944.45
-- !lz4_1 --
@@ -160,16 +160,16 @@
-- !no_null_zstd_4 --
-- !no_null_zstd_5 --
-383 293 51 33044558645 326028.1 2.189678010941299E9
false kVmBt EkkVZYfRZD qCGmOIYzYPxgjqwsygiQuHprk 2020-01-02
2023-12-02T18:56:54 131227.87
-4243 276 48 62445263394 496504.66 1.8498306610117477E10
true SVzhcQpuPkG wyOnICYTPN cwVFEkMXkTftsqiLdVEkWAhLz
2023-12-31 2023-12-11T22:53:54 187918.56
-4840 61 54 26240668018 6438.2705 1.0309399295602386E10
true zQinQW TolZiTvbGZ LivmxkZAvdQKUbIivXtyukcwb 2034-12-29
2023-12-06T00:37:54 5674.70
-5590 139 44 50838994101 422656.72 9.947330937061028E9
false OZjBLJUcJNIQ zAddUBuikL SqnZTmbFrLKJcExUkouadwDZG
2029-12-15 2023-12-23T16:48:54 191558.13
-56 92 48 85501469933 371303.5 1.5374355252136162E10
false gTFiSJNIIVCUQBmgaqEw PEyDSWWZSr IUmVtPmsOzUgGVyBENBEfRAuz
2026-06-02 2023-12-27T06:49:54 76821.40
-8405 166 66 74722925142 415562.88 2.0266805279476093E10
true XHaglMHPkqEpIyrEoW PNdFzeFWmU PvlViKZNwkmhxJYhZEIAABGTM
2029-10-19 2023-12-16T22:38:54 139384.88
-8588 124 57 112514759844 352363.44 8.66651024813605E9
true PzMOcqHjZSTrT vTMntQPtzn WCJZkzWXzyZEqzexQGWVldXGr
2031-03-16 2023-12-27T05:55:54 17153.37
-897 225 67 79324747270 246958.16 1.782671640884806E10
true WEBxgxcg VKppIKbyoT jnzGJxHnxybhJAqGDrwsruRwg
2029-11-18 2023-11-30T12:55:54 5301.50
-9378 239 37 101475897296 597503.9 7.616898174341047E9
false jBMZF mOWgZRkuJE SztNODvhaKzpFYGDpAUwanUgz 2034-04-18
2023-12-23T15:06:54 176903.62
-9960 216 63 16070096189 376901.34 1.195508798637962E10
false LLOnSN eGDMZgazSV hpIzhEgnKeiXEoytKKDIMwmwB 2029-07-15
2023-12-03T14:54:54 180721.58
+15 248 15 21558482213 6487986.5 1.0939869723964705E9
true RJTQHTtGIHlKVlzk FcbxoaqqpI WJucDRirckTPgbZLjsEKplAWn
2024-08-13 2023-11-30T01:25:54 34141.57
+25 83 72 149711605439 6.2890304E7 7.440117092023224E9
false hjXuMtPQ VZqPglUMPk HbNzdUJAHaizFkXxNEYBYPYCf
2019-11-18 2023-12-12T03:05:54 86166.27
+28 462 50 99515493604 1.0113E8 1.5197217619216759E10
true VaRiy RUZwanoIXS wGJmjlsrtktJGzGTvtRleomHv 2020-09-28
2023-12-20T03:23:54 160536.09
+35 72 32 15905879451 8.3402976E7 2.174744968486151E10
false zkd dQkISTxetN gpbemtjhvejdkPDXyDjjrWXrG 2028-02-21
2023-12-21T17:19:54 181969.97
+39 104 67 102858005915 3883196.2 7.698795111611849E9
false oANcFYcWwftK riOYGAuzYa jBrKXHbKuRgqJQUyiorbcVmEc
2028-09-17 2023-12-05T03:11:54 58245.11
+41 102 53 81432267997 8.3292832E7 1.832442879595766E10
false qtwQtWGokDPkkCzfO nwrNOwzvSF qXNCoYVdIEoEdVhMXUsUoXBWf
2024-12-31 2023-12-08T16:26:54 143405.87
+43 66 31 103368561997 4.2050856E7 1.7742240298212337E10
false WxcDOdxJl kXpBppqAlP sSltbkkDZdIRDSzHOxJgsMtOl
2029-04-15 2023-12-20T01:49:54 84059.39
+47 442 43 113416931027 7.6058776E7 4.766215418628829E9
false CFdWIVEcmp TUBoxBcSfR wnbIuqmKRHfZJWzzvmpEnwDic
2033-01-08 2023-11-29T07:52:54 82430.94
+8 181 34 95477376121 7.5397792E7 1.6273298833350899E10
false vkgWftEsKYXEliikl TNwWzMduUG AImvOcOGQjanpfPhWQzNcEfds
2024-04-25 2023-12-28T10:11:54 66374.37
+9 388 37 141886807584 9965839.0 4.2909144426083784E9
true DIvqtxxgyUr SrTKPJUfzO YPfKKFCOPSMQeePQvFCACzeSG
2025-11-22 2023-12-02T22:55:54 189986.54
-- !no_null_zstd_6 --
diff --git
a/regression-test/suites/external_table_p0/tvf/test_s3_tvf_parquet_compress.groovy
b/regression-test/suites/external_table_p0/tvf/test_s3_tvf_parquet_compress.groovy
index 66ad6118a10..e8ca08811f0 100644
---
a/regression-test/suites/external_table_p0/tvf/test_s3_tvf_parquet_compress.groovy
+++
b/regression-test/suites/external_table_p0/tvf/test_s3_tvf_parquet_compress.groovy
@@ -35,7 +35,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_bigint > 607 and col_string = 'CyGmiNdrY' order by
col_bigint , col_string limit 10 ;
+ )where col_bigint > 607 and col_string = 'CyGmiNdrY' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_gzip_2 """
select * from
@@ -45,7 +45,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_bigint > 752 and col_float = 0.3 order by
col_bigint , col_float limit 10 ;
+ )where col_bigint > 752 and col_float = 0.3 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_gzip_3 """
select * from
@@ -55,7 +55,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'TaOCwaPcNfGeNxMqi' and col_boolean = 680
and col_int = 1953 order by col_char , col_boolean , col_int limit 10 ;
+ )where col_char = 'TaOCwaPcNfGeNxMqi' and col_boolean = 680
and col_int = 1953 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_gzip_4 """
select * from
@@ -65,7 +65,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_tinyint < 1423 order by col_tinyint limit 10 ;
+ )where col_tinyint < 1423 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_gzip_5 """
select * from
@@ -75,7 +75,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_float = 2.5 order by col_float limit 10 ;
+ )where col_float = 2.5 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_lz42_1 """
select * from
@@ -85,7 +85,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_decimal = 0.8 order by col_decimal limit 10 ;
+ )where col_decimal = 0.8 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_lz42_2 """
select * from
@@ -95,7 +95,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'MVAhYjsZf' and col_decimal < 2.3 and
col_float = 2.7 order by col_char , col_decimal , col_float limit 10 ;
+ )where col_char = 'MVAhYjsZf' and col_decimal < 2.3 and
col_float = 2.7 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_lz42_3 """
select * from
@@ -105,7 +105,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_tinyint < 32 and col_char = 'Ja' order by
col_tinyint , col_char limit 10 ;
+ )where col_tinyint < 32 and col_char = 'Ja' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_lz42_4 """
select * from
@@ -115,7 +115,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_decimal > 1.6 order by col_decimal limit 10 ;
+ )where col_decimal > 1.6 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_none_1 """
select * from
@@ -125,7 +125,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_varchar = 'gLmEXgvqlm' and col_smallint < 1271
order by col_varchar , col_smallint limit 10 ;
+ )where col_varchar = 'gLmEXgvqlm' and col_smallint < 1271
order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_none_2 """
select * from
@@ -135,7 +135,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_tinyint > 1288 order by col_tinyint limit 10 ;
+ )where col_tinyint > 1288 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_none_3 """
select * from
@@ -145,7 +145,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_string = 'jTFdDLHZK' and year(col_date)=2016 order
by col_string , col_date limit 10 ;
+ )where col_string = 'jTFdDLHZK' and year(col_date)=2016 order
by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_none_4 """
select * from
@@ -155,7 +155,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where year(col_timestamp)=2016 order by col_timestamp limit
10 ;
+ )where year(col_timestamp)=2016 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_none_5 """
select * from
@@ -165,7 +165,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'qHqL' order by col_char limit 10 ;
+ )where col_char = 'qHqL' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none_1 """
select * from
@@ -175,7 +175,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_float = 0.3 order by col_float limit 10 ;
+ )where col_float = 0.3 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none_2 """
select * from
@@ -185,7 +185,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_bigint < 50 and col_float < 1.6 order by
col_bigint , col_float limit 10 ;
+ )where col_bigint < 50 and col_float < 1.6 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none_3 """
select * from
@@ -195,7 +195,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_boolean > 314 order by col_boolean limit 10 ;
+ )where col_boolean > 314 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none_4 """
select * from
@@ -205,7 +205,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_boolean = 1240 and col_decimal < 0.8 and
col_float < 1.4 order by col_boolean , col_decimal , col_float limit 10 ;
+ )where col_boolean = 1240 and col_decimal < 0.8 and
col_float < 1.4 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none_5 """
select * from
@@ -215,7 +215,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'doB' order by col_char limit 10 ;
+ )where col_char = 'doB' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none_6 """
select * from
@@ -225,7 +225,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_double = 2.4 and col_varchar = 'OlykmDCvDpdh' and
col_boolean > 1449 order by col_double , col_varchar , col_boolean limit 10 ;
+ )where col_double = 2.4 and col_varchar = 'OlykmDCvDpdh' and
col_boolean > 1449 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy2_1 """
select * from
@@ -235,7 +235,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where year(col_timestamp)=2016 and col_boolean > 1011 and
col_smallint < 780 order by col_timestamp , col_boolean , col_smallint limit 10
;
+ )where year(col_timestamp)=2016 and col_boolean > 1011 and
col_smallint < 780 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy2_2 """
select * from
@@ -245,7 +245,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_decimal = 1.4 order by col_decimal limit 10 ;
+ )where col_decimal = 1.4 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy2_3 """
select * from
@@ -255,7 +255,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_float > 1.8 and col_double < 2.0 order by
col_float , col_double limit 10 ;
+ )where col_float > 1.8 and col_double < 2.0 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy2_4 """
select * from
@@ -265,7 +265,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_double = 1.0 and col_varchar =
'YpajmCZhNSTaHwOriViw' and col_char = 'Syavtn' order by col_double ,
col_varchar , col_char limit 10 ;
+ )where col_double = 1.0 and col_varchar =
'YpajmCZhNSTaHwOriViw' and col_char = 'Syavtn' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_gzip2_1 """
select * from
@@ -275,7 +275,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_int = 1795 and col_smallint > 1239 order by col_int
, col_smallint limit 10 ;
+ )where col_int = 1795 and col_smallint > 1239 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_gzip2_2 """
select * from
@@ -285,7 +285,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_int = 1812 and col_bigint < 1976 and col_float <
2.2 order by col_int , col_bigint , col_float limit 10 ;
+ )where col_int = 1812 and col_bigint < 1976 and col_float <
2.2 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_gzip2_3 """
select * from
@@ -295,7 +295,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_float > 1.4 and col_tinyint > 1799 and
col_decimal > 0.3 order by col_float , col_tinyint , col_decimal limit 10 ;
+ )where col_float > 1.4 and col_tinyint > 1799 and
col_decimal > 0.3 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_gzip2_4 """
select * from
@@ -305,7 +305,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where year(col_timestamp)=2016 and col_bigint > 1938 order by
col_timestamp , col_bigint limit 10 ;
+ )where year(col_timestamp)=2016 and col_bigint > 1938 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_gzip_1 """
select * from
@@ -315,7 +315,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_bigint = 1426 and col_varchar = 'NcXlcfnRpO' order
by col_bigint , col_varchar limit 10 ;
+ )where col_bigint = 1426 and col_varchar = 'NcXlcfnRpO' order
by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_gzip_2 """
select * from
@@ -325,7 +325,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_float = 1.8 and col_string = 'khbrpZBfNbFP' order
by col_float , col_string limit 10 ;
+ )where col_float = 1.8 and col_string = 'khbrpZBfNbFP' order
by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_gzip_3 """
select * from
@@ -335,7 +335,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_double < 0.3 and col_float < 0.3 and col_bigint <
1642 order by col_double , col_float , col_bigint limit 10 ;
+ )where col_double < 0.3 and col_float < 0.3 and col_bigint <
1642 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_snappy_1 """
select * from
@@ -345,7 +345,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_varchar = 'DdYENcTybQV' and col_boolean < 1004
order by col_varchar , col_boolean limit 10 ;
+ )where col_varchar = 'DdYENcTybQV' and col_boolean < 1004
order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_snappy_2 """
select * from
@@ -355,7 +355,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'bcuSohgIFYKTMVv' and year(col_date)=2016
order by col_char , col_date limit 10 ;
+ )where col_char = 'bcuSohgIFYKTMVv' and year(col_date)=2016
order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_snappy_3 """
select * from
@@ -365,7 +365,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_tinyint = 693 and col_varchar = 'qHnjmUWAaKcpAn'
and year(col_timestamp)=2016 order by col_tinyint , col_varchar , col_timestamp
limit 10 ;
+ )where col_tinyint = 693 and col_varchar = 'qHnjmUWAaKcpAn'
and year(col_timestamp)=2016 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_snappy_4 """
select * from
@@ -375,7 +375,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_double > 2.3 order by col_double limit 10 ;
+ )where col_double > 2.3 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none2_1 """
select * from
@@ -385,7 +385,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_decimal < 0.2 order by col_decimal limit 10 ;
+ )where col_decimal < 0.2 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none2_2 """
select * from
@@ -395,7 +395,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_boolean > 1693 and col_varchar = 'YowzLFscqYmYB'
and col_char = 'CJ' order by col_boolean , col_varchar , col_char limit 10 ;
+ )where col_boolean > 1693 and col_varchar = 'YowzLFscqYmYB'
and col_char = 'CJ' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none2_3 """
select * from
@@ -405,7 +405,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'WGSpFnLYSPVTlyl' and year(col_date)=2016
and col_string = 'fmhUKNb' order by col_char , col_date , col_string limit 10 ;
+ )where col_char = 'WGSpFnLYSPVTlyl' and year(col_date)=2016
and col_string = 'fmhUKNb' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none2_4 """
select * from
@@ -415,7 +415,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_bigint > 1841 order by col_bigint limit 10 ;
+ )where col_bigint > 1841 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_none2_5 """
select * from
@@ -425,7 +425,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where year(col_date)=2016 order by col_date limit 10 ;
+ )where year(col_date)=2016 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_zstd2_1 """
select * from
@@ -435,7 +435,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where year(col_timestamp)=2016 and col_smallint = 130 order
by col_timestamp , col_smallint limit 10 ;
+ )where year(col_timestamp)=2016 and col_smallint = 130 order
by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_zstd2_2 """
select * from
@@ -445,7 +445,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_decimal > 2.0 and col_tinyint = 1662 and
col_bigint < 1224 order by col_decimal , col_tinyint , col_bigint limit 10 ;
+ )where col_decimal > 2.0 and col_tinyint = 1662 and
col_bigint < 1224 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_zstd2_3 """
select * from
@@ -455,7 +455,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_smallint > 615 and col_int > 1410 order by
col_smallint , col_int limit 10 ;
+ )where col_smallint > 615 and col_int > 1410 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_zstd2_4 """
select * from
@@ -465,7 +465,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_boolean < 128 order by col_boolean limit 10 ;
+ )where col_boolean < 128 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_lz4_1 """
select * from
@@ -475,7 +475,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_varchar = 'qirvWjuTAgAPrzjlcU' and col_float < 0.9
order by col_varchar , col_float limit 10 ;
+ )where col_varchar = 'qirvWjuTAgAPrzjlcU' and col_float < 0.9
order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_lz4_2 """
select * from
@@ -485,7 +485,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'YNT' and col_string = 'iLZNgqK' order by
col_char , col_string limit 10 ;
+ )where col_char = 'YNT' and col_string = 'iLZNgqK' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_lz4_3 """
select * from
@@ -495,7 +495,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where year(col_date)=2016 and col_tinyint > 1491 and col_int
> 342 order by col_date , col_tinyint , col_int limit 10 ;
+ )where year(col_date)=2016 and col_tinyint > 1491 and col_int
> 342 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_lz4_1 """
select * from
@@ -505,7 +505,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_decimal > 2.5 and year(col_timestamp)=2016 order
by col_decimal , col_timestamp limit 10 ;
+ )where col_decimal > 2.5 and year(col_timestamp)=2016 order
by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_lz4_2 """
select * from
@@ -515,7 +515,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where year(col_date)=2016 and col_int > 166 order by col_date
, col_int limit 10 ;
+ )where year(col_date)=2016 and col_int > 166 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_lz4_3 """
select * from
@@ -525,7 +525,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'YN' and col_string = 'XBnUNfbPCijQSaxwKLh'
order by col_char , col_string limit 10 ;
+ )where col_char = 'YN' and col_string = 'XBnUNfbPCijQSaxwKLh'
order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_lz4_4 """
select * from
@@ -535,7 +535,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_boolean = 27 and col_string = 'VYDMZZ' and
year(col_date)=2016 order by col_boolean , col_string , col_date limit 10 ;
+ )where col_boolean = 27 and col_string = 'VYDMZZ' and
year(col_date)=2016 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_zstd_1 """
select * from
@@ -545,7 +545,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_int = 1361 order by col_int limit 10 ;
+ )where col_int = 1361 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_zstd_2 """
select * from
@@ -555,7 +555,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_bigint = 516 and col_varchar = 'rxqicLIhJEykBOEmr'
and col_char = 'sioJZDxWfjFkTsO' order by col_bigint , col_varchar , col_char
limit 10 ;
+ )where col_bigint = 516 and col_varchar = 'rxqicLIhJEykBOEmr'
and col_char = 'sioJZDxWfjFkTsO' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_zstd_3 """
select * from
@@ -565,7 +565,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where year(col_timestamp)=2016 and col_char =
'NSKJPkGHUSXVDD' order by col_timestamp , col_char limit 10 ;
+ )where year(col_timestamp)=2016 and col_char =
'NSKJPkGHUSXVDD' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_zstd_4 """
select * from
@@ -575,7 +575,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_bigint < 886 and year(col_timestamp)=2016 order by
col_bigint , col_timestamp limit 10 ;
+ )where col_bigint < 886 and year(col_timestamp)=2016 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_zstd_5 """
select * from
@@ -585,7 +585,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_float > 0.5 order by col_float limit 10 ;
+ )where col_float > 0.5 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_no_null_zstd_6 """
select * from
@@ -595,7 +595,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_char = 'VyUYzxhFtq' and col_varchar = 'OJfigYX' and
col_string = 'EzFjFJEWXuOdG' order by col_char , col_varchar , col_string limit
10 ;
+ )where col_char = 'VyUYzxhFtq' and col_varchar = 'OJfigYX' and
col_string = 'EzFjFJEWXuOdG' order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy_1 """
select * from
@@ -605,7 +605,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_float = 1.0 and year(col_timestamp)=2016 and
col_boolean < 1328 order by col_float , col_timestamp , col_boolean limit 10 ;
+ )where col_float = 1.0 and year(col_timestamp)=2016 and
col_boolean < 1328 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy_2 """
select * from
@@ -615,7 +615,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_float < 1.8 and year(col_date)=2016 order by
col_float , col_date limit 10 ;
+ )where col_float < 1.8 and year(col_date)=2016 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy_3 """
select * from
@@ -625,7 +625,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_bigint = 949 order by col_bigint limit 10 ;
+ )where col_bigint = 949 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy_4 """
select * from
@@ -635,7 +635,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_string = 'rq' and col_varchar = 'pinxLaVk' and
col_decimal < 2.3 order by col_string , col_varchar , col_decimal limit 10 ;
+ )where col_string = 'rq' and col_varchar = 'pinxLaVk' and
col_decimal < 2.3 order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
order_qt_snappy_5 """
select * from
@@ -645,7 +645,7 @@ suite("test_s3_tvf_parquet_compress", "p0") {
"s3.secret_key" = "${sk}",
"REGION" = "${region}",
"FORMAT" = "parquet"
- )where col_tinyint > 628 and col_varchar = 'xQWHzZPhLlCM'
order by col_tinyint , col_varchar limit 10 ;
+ )where col_tinyint > 628 and col_varchar = 'xQWHzZPhLlCM'
order by
col_int,col_smallint,col_tinyint,col_bigint,col_float,col_double,col_boolean,col_string,col_char,col_varchar,col_decimal,col_date,col_timestamp
limit 10;
"""
}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
