This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 3f91127854 [fix](regression)Update external Brown test case out file.
#20232
3f91127854 is described below
commit 3f91127854c2f6b516f403e05df791c84b64feff
Author: Jibing-Li <[email protected]>
AuthorDate: Wed May 31 09:21:04 2023 +0800
[fix](regression)Update external Brown test case out file. #20232
Update external Brown test case out file to match the new precision.
---
.../hive/test_external_brown.out | 140 ++++++++++-----------
.../iceberg/test_external_catalog_icebergv2.groovy | 2 +-
2 files changed, 71 insertions(+), 71 deletions(-)
diff --git
a/regression-test/data/external_table_emr_p2/hive/test_external_brown.out
b/regression-test/data/external_table_emr_p2/hive/test_external_brown.out
index 9ce95a0265..fa2efdef55 100644
--- a/regression-test/data/external_table_emr_p2/hive/test_external_brown.out
+++ b/regression-test/data/external_table_emr_p2/hive/test_external_brown.out
@@ -1,8 +1,8 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !01 --
-anansi 0E-9 22.499999744 0.142686086 938.950000640
2355335.637499904 9177.160292675 216.880005120 2354536.236711936
13467.316295748
-aragog 0E-9 31.139999744 0.466084818 1318.689964032
27836488.351744000 328922.023920031 308.950007808
40642403.643686912 825490.561812005
-urd 0E-9 23.493332992 1.499065356 1168.349986816
368025.614155776 22100.285069203 220.950003712 108069.656723456
8129.441452354
+anansi 0.0 22.5 0.14268608779353878 938.95 2355335.8
9177.160319882514 216.88 2354536.2 13467.316303191717
+aragog 0.0 31.14 0.4660848216252758 1318.69 2.7836488E7
328922.0219290647 308.95 4.0642404E7 825490.5598814549
+urd 0.0 23.493334 1.4990653583589646 1168.35 368025.62
22100.285077492692 220.95 108069.66 8129.441453910114
-- !02 --
2017-01-01 0 0.12023027675847213 0.09362472227464119
0.0874438889300412 2170359.9625 8388604.0
@@ -642,7 +642,7 @@ reflect 156
2012-12-31 7824
-- !05 --
-0.0046296999419207785 295.028835936
+0.0046296999419207785 295
-- !06 --
front_right_1 1 64269
@@ -677,16 +677,16 @@ stairs_east_4 4 1093
249.92.17.134 112909
-- !08 --
-2017-01-10 17 87.948585380 71.385253825 159.333839205
-2017-01-10 18 89.649306783 69.156060259 158.805367042
-2017-01-10 19 73.607249260 81.407222077 155.014471337
-2017-01-10 20 68.547946313 85.506676673 154.054622986
-2017-01-11 13 42.000689907 69.613847012 111.614536919
-2017-01-10 16 52.184352597 56.948349728 109.132702325
-2017-01-10 15 58.921870661 47.700976292 106.622846953
-2017-01-10 14 60.980273630 44.448819620 105.429093250
-2017-01-10 21 45.797732305 54.048210813 99.845943118
-2017-01-11 4 48.962175923 48.376258854 97.338434777
+2017-01-10 17 87.9485853909793 71.38525382810978
159.3338392190891
+2017-01-10 18 89.64930667409168 69.15606039008277
158.80536706417445
+2017-01-10 19 73.60724918546498 81.40722212979647
155.01447131526146
+2017-01-10 20 68.5479463209085 85.50667662120546
154.05462294211395
+2017-01-11 13 42.0006899662164 69.61384691644746
111.61453688266386
+2017-01-10 16 52.18435270387559 56.948349744383044
109.13270244825864
+2017-01-10 15 58.921870685606486 47.70097636103654
106.62284704664302
+2017-01-10 14 60.98027370384939 44.44881970374338
105.42909340759277
+2017-01-10 21 45.79773237211905 54.04821079016711
99.84594316228616
+2017-01-11 4 48.962175912416335 48.37625877479395
97.33843468721028
-- !09 --
chimera 2016-11-04 6135.48
@@ -782,9 +782,9 @@ front_right_1 door 1 WINTER
loading_dock_1 door 1 WINTER
-- !01 --
-anansi 0E-9 22.499999744 0.142686086 938.950000640
2355335.637499904 9177.160292675 216.880005120 2354536.236711936
13467.316295748
-aragog 0E-9 31.139999744 0.466084818 1318.689964032
27836488.351744000 328922.023920031 308.950007808
40642403.643686912 825490.561812005
-urd 0E-9 23.493332992 1.499065356 1168.349986816
368025.614155776 22100.285069203 220.950003712 108069.656723456
8129.441452354
+anansi 0.0 22.5 0.14268608779353878 938.95 2355335.8
9177.160319882514 216.88 2354536.2 13467.316303191717
+aragog 0.0 31.14 0.4660848216252758 1318.69 2.7836488E7
328922.0219290647 308.95 4.0642404E7 825490.5598814549
+urd 0.0 23.493334 1.4990653583589646 1168.35 368025.62
22100.285077492692 220.95 108069.66 8129.441453910114
-- !02 --
2017-01-01 0 0.12023027675847213 0.09362472227464119
0.0874438889300412 2170359.9625 8388604.0
@@ -1424,7 +1424,7 @@ reflect 156
2012-12-31 7824
-- !05 --
-0.0046296999419207785 295.028835936
+0.0046296999419207785 295
-- !06 --
front_right_1 1 64269
@@ -1459,16 +1459,16 @@ stairs_east_4 4 1093
249.92.17.134 112909
-- !08 --
-2017-01-10 17 87.948585380 71.385253825 159.333839205
-2017-01-10 18 89.649306783 69.156060259 158.805367042
-2017-01-10 19 73.607249260 81.407222077 155.014471337
-2017-01-10 20 68.547946313 85.506676673 154.054622986
-2017-01-11 13 42.000689907 69.613847012 111.614536919
-2017-01-10 16 52.184352597 56.948349728 109.132702325
-2017-01-10 15 58.921870661 47.700976292 106.622846953
-2017-01-10 14 60.980273630 44.448819620 105.429093250
-2017-01-10 21 45.797732305 54.048210813 99.845943118
-2017-01-11 4 48.962175923 48.376258854 97.338434777
+2017-01-10 17 87.9485853909793 71.38525382810978
159.3338392190891
+2017-01-10 18 89.64930667409168 69.15606039008277
158.80536706417445
+2017-01-10 19 73.60724918546498 81.40722212979647
155.01447131526146
+2017-01-10 20 68.5479463209085 85.50667662120546
154.05462294211395
+2017-01-11 13 42.0006899662164 69.61384691644746
111.61453688266386
+2017-01-10 16 52.18435270387559 56.948349744383044
109.13270244825864
+2017-01-10 15 58.921870685606486 47.70097636103654
106.62284704664302
+2017-01-10 14 60.98027370384939 44.44881970374338
105.42909340759277
+2017-01-10 21 45.79773237211905 54.04821079016711
99.84594316228616
+2017-01-11 4 48.962175912416335 48.37625877479395
97.33843468721028
-- !09 --
chimera 2016-11-04 6135.48
@@ -1564,9 +1564,9 @@ front_right_1 door 1 WINTER
loading_dock_1 door 1 WINTER
-- !01 --
-anansi 0E-9 22.499999744 0.142686086 938.950000640
2355335.637499904 9177.160292675 216.880005120 2354536.236711936
13467.316295748
-aragog 0E-9 31.139999744 0.466084818 1318.689964032
27836488.351744000 328922.023920031 308.950007808
40642403.643686912 825490.561812005
-urd 0E-9 23.493332992 1.499065356 1168.349986816
368025.614155776 22100.285069203 220.950003712 108069.656723456
8129.441452354
+anansi 0.0 22.5 0.14268608779353878 938.95 2355335.8
9177.160319882514 216.88 2354536.2 13467.316303191717
+aragog 0.0 31.14 0.4660848216252758 1318.69 2.7836488E7
328922.0219290647 308.95 4.0642404E7 825490.5598814549
+urd 0.0 23.493334 1.4990653583589646 1168.35 368025.62
22100.285077492692 220.95 108069.66 8129.441453910114
-- !02 --
2017-01-01 0 0.12023027675847213 0.09362472227464119
0.0874438889300412 2170359.9625 8388604.0
@@ -2206,7 +2206,7 @@ reflect 156
2012-12-31 7824
-- !05 --
-0.0046296999419207785 295.028835936
+0.0046296999419207785 295
-- !06 --
front_right_1 1 64269
@@ -2241,16 +2241,16 @@ stairs_east_4 4 1093
249.92.17.134 112909
-- !08 --
-2017-01-10 17 87.948585380 71.385253825 159.333839205
-2017-01-10 18 89.649306783 69.156060259 158.805367042
-2017-01-10 19 73.607249260 81.407222077 155.014471337
-2017-01-10 20 68.547946313 85.506676673 154.054622986
-2017-01-11 13 42.000689907 69.613847012 111.614536919
-2017-01-10 16 52.184352597 56.948349728 109.132702325
-2017-01-10 15 58.921870661 47.700976292 106.622846953
-2017-01-10 14 60.980273630 44.448819620 105.429093250
-2017-01-10 21 45.797732305 54.048210813 99.845943118
-2017-01-11 4 48.962175923 48.376258854 97.338434777
+2017-01-10 17 87.9485853909796 71.38525382810943
159.33383921908904
+2017-01-10 18 89.64930667409163 69.15606039008276
158.8053670641744
+2017-01-10 19 73.60724918546516 81.40722212979558
155.01447131526075
+2017-01-10 20 68.54794632090885 85.50667662120519
154.05462294211404
+2017-01-11 13 42.000689966216626 69.6138469164476
111.61453688266423
+2017-01-10 16 52.18435270387555 56.948349744382995
109.13270244825854
+2017-01-10 15 58.92187068560644 47.700976361036936
106.62284704664339
+2017-01-10 14 60.98027370384923 44.44881970374329
105.42909340759252
+2017-01-10 21 45.79773237211901 54.048210790166976
99.84594316228598
+2017-01-11 4 48.96217591241636 48.376258774794074
97.33843468721044
-- !09 --
chimera 2016-11-04 6135.48
@@ -2295,34 +2295,34 @@ cslab9e 2017-01-10T14:19:45
2012-05-13T20:17:05 201.183.185.11 /?-nd+auto_prepend_file%3D/etc/passwd
200 21809
-- !12 --
-2017 9 721638.3414064784 1252.8443427195807
65268.739191884546 113.31378331924401 174895.77151746236
330.61582517478706 176421.94104524454 388.5945838000981
-2017 10 702508.0664338225 1256.7228379853711
66960.70685831291 120.0012667711701 131314.92843738303
270.75242976780004 212072.42540618256 379.3782207624017
-2017 11 903660.5956517105 1258.580216785112
79376.14433888887 110.55173306251932 178488.04901201368
304.06822659627545 257457.22712476412 358.57552524340406
-2017 12 931357.6830229161 1251.8248427727367
76585.03687197334 102.93687751609319 112836.92815090144
198.65656364595324 241257.5071419922 324.2708429327852
-2018 1 800695.0232504869 1268.9303062606766
52913.861798515994 83.85715023536608 36392.48058457171
83.46899216644888 191628.70119383492 303.69049317564964
-2018 2 788872.057316979 1188.060327284607
85621.32358955599 128.94777649029515 83922.79400835953
176.6795663333885 230227.25133465935 346.7277881546074
-2018 3 896816.2190436661 1205.3981438758954
88325.94803945151 118.71767209603698 114322.79839365494
193.7674549044999 269070.6060912008 361.65404044516237
-2018 4 581954.6102904766 1199.9064129700548
55146.13846078815 113.70337826966629 107909.63419773085
260.65129033268323 172977.5683584702 356.6547801205571
-2018 5 810269.3225697606 1246.5681885688625
69687.03583794396 107.21082436606763 83644.78159173676
143.47303875083492 248284.77976738216 381.97658425751104
-2018 6 824150.0588949074 1252.5076882901328
52047.11873700284 79.09896464590098 61491.79513703263
113.24455826341183 242561.98528653922 368.63523599777994
-2018 7 920527.3411698391 1237.2679316798913
54001.805264369934 72.58307159189508 110136.29401019624
175.655971308128 284977.6805428929 383.034516858727
-2018 8 934028.5503494726 1255.4147182116567
56534.79015953165 75.9876211821662 18440.748190359904
37.25403674820183 281409.0307800985 378.23794459690663
-2018 9 796294.725012032 1201.0478506968807
59750.627903558845 90.12161071426674 123357.51466599084
219.10748608524128 251368.59077414437 379.13814596401863
-2018 10 876930.3483784569 1178.6698230893237
68192.54789305253 91.6566503938878 161682.95582566154
259.9404434496166 285017.3815606405 383.08787844172116
-2018 11 220190.80577936105 1177.4909399965832
17258.73825754189 92.29271795476946 31282.504059750245
215.74140730862237 74832.7243967542 400.17499677408665
-2018 12 600604.6369429257 1213.3427008947995
40572.284658587654 81.96421143149021 45621.901088225226
103.21697078783988 174784.20606314807 353.0994061881779
-2019 1 875861.801519638 1177.2336041930619
62356.908033973945 83.81304843276068 38427.200289164495
68.37580122627135 266395.0245066203 358.0578286379305
-2019 2 766839.505131412 1141.130215969363
58769.95527064854 87.45529058132223 98888.76720553762
174.40699683516334 263572.66875685327 392.22123326912686
-2019 3 875531.8723175367 1176.7901509644312
64134.01856961807 86.20163786238987 137670.795483173
220.9804100853499 307147.8785608931 412.8331701087273
-2019 4 882405.782299407 1225.5635865269542
62498.886241078064 86.80400866816397 118655.91830720665
190.76514197300105 310192.1270515335 430.8223986826854
-2019 5 915804.9453381395 1230.9206254544886
62733.507878054705 84.31923101889073 51908.476725653585
92.36383759013093 333347.07849929924 448.0471485205635
-2019 6 743714.4735556262 1264.8205332578677
47914.3735105059 81.48702977977194 33701.15766617421
99.1210519593359 258663.9435447938 439.90466589250644
-2019 7 936697.9580959913 1259.0026318494506
60426.11789318793 81.2179003940698 10876.808554053552
30.2133570945932 322797.225973342 433.8672392114812
-2019 8 930640.7550409781 1250.8612298937878
60639.0856810021 81.50414742070174 13063.088331067778
44.58391921866136 336075.45302452584 451.7143185813519
-2019 9 862784.431872853 1198.311710934518
63348.64890275075 87.98423458715382 56973.395663266085
126.32681965247468 322162.845310006 447.4483962638972
-2019 10 900170.2429565525 1209.9062405330008
64953.12136266855 87.30258247670504 98168.0280572252
218.6370335350227 310577.09491537116 417.44233187549884
-2019 11 881836.9061517053 1224.7734807662573
61941.828695957716 86.0303176332746 181716.3770488152
294.99411858573893 258322.18736711307 358.78081578765705
-2019 12 45118.354529795746 1253.2876258276597
2884.8668441554055 80.13519011542793 13576.481448950073
377.1244846930576 12249.12485575384 340.25346821538443
+2017 9 721638.3414064784 1252.8443427195807
65268.7391918846 113.3137833192441 174895.77151746245
330.61582517478723 176421.94104524454 388.5945838000981
+2017 10 702508.066433822 1256.7228379853705
66960.70685831291 120.0012667711701 131314.9284373829
270.7524297677998 212072.42540618256 379.3782207624017
+2017 11 903660.5956517108 1258.5802167851125
79376.1443388889 110.55173306251936 178488.04901201383
304.0682265962757 257457.22712476423 358.57552524340423
+2017 12 931357.6830229169 1251.8248427727378
76585.03687197337 102.93687751609323 112836.92815090144
198.65656364595324 241257.5071419923 324.27084293278534
+2018 1 800695.0232504868 1268.9303062606764
52913.86179851606 83.85715023536618 36392.480584571735
83.46899216644893 191628.70119383483 303.69049317564946
+2018 2 788872.0573169794 1188.0603272846074
85621.3235895559 128.94777649029504 83922.79400835956
176.67956633338855 230227.25133465926 346.7277881546073
+2018 3 896816.2190436656 1205.3981438758947
88325.94803945147 118.71767209603692 114322.7983936549
193.76745490449983 269070.60609120084 361.6540404451624
+2018 4 581954.6102904761 1199.906412970054
55146.138460788155 113.7033782696663 107909.63419773089
260.6512903326833 172977.56835847045 356.65478012055763
+2018 5 810269.3225697606 1246.5681885688625
69687.03583794399 107.21082436606767 83644.78159173677
143.47303875083495 248284.77976738225 381.97658425751115
+2018 6 824150.0588949075 1252.507688290133
52047.11873700287 79.09896464590102 61491.79513703262
113.24455826341182 242561.98528653913 368.63523599777983
+2018 7 920527.3411698388 1237.2679316798908
54001.80526436995 72.58307159189509 110136.29401019623
175.65597130812796 284977.6805428937 383.0345168587281
+2018 8 934028.5503494728 1255.414718211657
56534.790159531614 75.98762118216615 18440.748190359896
37.25403674820181 281409.0307800983 378.2379445969063
+2018 9 796294.7250120323 1201.0478506968814
59750.62790355885 90.12161071426675 123357.51466599098
219.10748608524153 251368.5907741442 379.1381459640184
+2018 10 876930.3483784571 1178.6698230893242
68192.54789305246 91.6566503938877 161682.9558256614
259.9404434496164 285017.3815606406 383.0878784417212
+2018 11 220190.80577936105 1177.4909399965832
17258.738257541878 92.2927179547694 31282.504059750234
215.7414073086223 74832.72439675417 400.1749967740865
+2018 12 600604.636942926 1213.3427008948 40572.28465858773
81.96421143149036 45621.901088225226 103.21697078783988
174784.20606314804 353.09940618817785
+2019 1 875861.8015196382 1177.233604193062
62356.908033973945 83.81304843276068 38427.200289164495
68.37580122627135 266395.02450662036 358.0578286379306
+2019 2 766839.5051314115 1141.1302159693623
58769.9552706485 87.45529058132217 98888.76720553763
174.40699683516337 263572.66875685327 392.22123326912686
+2019 3 875531.8723175367 1176.7901509644312
64134.01856961809 86.20163786238992 137670.79548317296
220.98041008534986 307147.87856089324 412.8331701087275
+2019 4 882405.7822994066 1225.5635865269537
62498.886241078115 86.80400866816404 118655.91830720672
190.76514197300116 310192.12705153326 430.8223986826851
+2019 5 915804.9453381405 1230.92062545449
62733.507878054595 84.31923101889059 51908.47672565362
92.363837590131 333347.07849929866 448.0471485205627
+2019 6 743714.4735556248 1264.8205332578655
47914.37351050593 81.48702977977199 33701.157666174215
99.12105195933593 258663.94354479393 439.90466589250667
+2019 7 936697.9580959894 1259.002631849448
60426.11789318796 81.21790039406984 10876.808554053552
30.2133570945932 322797.2259733419 433.86723921148103
+2019 8 930640.7550409787 1250.8612298937885
60639.085681002165 81.50414742070184 13063.088331067776
44.58391921866135 336075.45302452595 451.7143185813521
+2019 9 862784.4318728528 1198.3117109345178
63348.6489027507 87.98423458715375 56973.39566326609
126.32681965247471 322162.84531000606 447.4483962638973
+2019 10 900170.2429565522 1209.9062405330003
64953.12136266857 87.30258247670507 98168.02805722524
218.6370335350228 310577.09491537156 417.4423318754994
+2019 11 881836.9061517067 1224.7734807662594
61941.82869595768 86.03031763327455 181716.37704881505
294.9941185857387 258322.18736711264 358.7808157876564
+2019 12 45118.35452979575 1253.28762582766
2884.8668441554064 80.13519011542796 13576.481448950073
377.1244846930576 12249.124855753844 340.25346821538454
-- !13 --
2012-12-21T16:58 229.50.247.232 //cgi-bin/feedback/ 500 410
diff --git
a/regression-test/suites/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.groovy
b/regression-test/suites/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.groovy
index c4e18d4b99..e2de233386 100644
---
a/regression-test/suites/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.groovy
+++
b/regression-test/suites/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.groovy
@@ -34,7 +34,7 @@ suite("test_external_catalog_icebergv2", "p2") {
// test parquet format format
def q01 = {
qt_q01 """ select count(1) as c from customer_small """
- qt_q02 """ select c_custkey from customer_small group by c_custkey
limit 4 """
+ qt_q02 """ select c_custkey from customer_small group by c_custkey
order by c_custkey limit 4 """
qt_q03 """ select count(1) from orders_small """
qt_q04 """ select count(1) from customer_small where c_name =
'Customer#000000005' or c_name = 'Customer#000000006' """
qt_q05 """ select * from customer_small order by c_custkey limit 3
"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
