This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new e08360f9ebf [fix](case)Fix cases for to_quantile_state (#25616)
e08360f9ebf is described below
commit e08360f9ebf94b92c6d1ce15a5eb3e4a68ae1372
Author: amory <wangqian...@selectdb.com>
AuthorDate: Thu Oct 19 12:13:36 2023 +0800
[fix](case)Fix cases for to_quantile_state (#25616)
---
.../load_p0/stream_load/test_stream_load_properties.out | 16 ++++++++++++++--
.../stream_load/test_stream_load_properties.groovy | 4 ++--
2 files changed, 16 insertions(+), 4 deletions(-)
diff --git
a/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
b/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
index ed37827d02d..9712ab1951d 100644
--- a/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
+++ b/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
@@ -266,23 +266,35 @@
85 2023-08-11 true -7 24304 -2043877415
-2024144417867729183 \N 5363.0244 -5.78615669042831E8
-99999999.9 -99999999.9 2023-07-15T01:07:41 2023-08-13
2023-01-20T11:57:48 i WQ9dh9ajPu0y
{"country":"France","capital":"Paris","population":67081000} \N \N
\N true 1 2 3 4 5 6.0 7.0
888888888 999999999 2023-08-24 2023-08-24T12:00
2023-08-24 2023-08-24T12:00 我能吞下玻璃而不伤身体 我能吞下玻璃而不伤身体
我能吞下玻璃而不伤身体 \N \N \N \N
-- !sql_max_filter_ratio --
+2 [0, 0, 0, 0, 0, 0] [117, 117, 117, 117, 117, 117] [-4744, -4744,
-4744, -4744, -4744, -4744] [-1593211961, -1593211961, -1593211961,
-1593211961, -1593211961, -1593211961] [-3869640069299678780,
-3869640069299678780, -3869640069299678780, -3869640069299678780,
-3869640069299678780, -3869640069299678780] [8491817458398170567,
8491817458398170567, 8491817458398170567, 8491817458398170567,
8491817458398170567, 8491817458398170567] [-30948.857, -30948.857, -30948.857,
-30948.857, -30948.85 [...]
3 [0, 0, 0, 0, 0, 0] [65, 65, 65, 65, 65, 65] [-4963, -4963,
-4963, -4963, -4963, -4963] [-1415431954, -1415431954, -1415431954,
-1415431954, -1415431954, -1415431954] [-3804309860450207000,
-3804309860450207000, -3804309860450207000, -3804309860450207000,
-3804309860450207000, -3804309860450207000] [8209240008557215376,
8209240008557215376, 8209240008557215376, 8209240008557215376,
8209240008557215376, 8209240008557215376] [-5058.13, -5058.13, -5058.13,
-5058.13, -5058.13] [1034763010.6 [...]
+4 [0, 0, 0, 0, 0, 0] [-67, -67, -67, -67, -67, -67] [-30372,
-30372, -30372, -30372, -30372, -30372] [181502941, 181502941,
181502941, 181502941, 181502941, 181502941] [-2062236823576972800,
-2062236823576972800, -2062236823576972800, -2062236823576972800,
-2062236823576972800, -2062236823576972800] [6357002962400127842,
6357002962400127842, 6357002962400127842, 6357002962400127842,
6357002962400127842, 6357002962400127842] [21235.783, 21235.783, 21235.783,
21235.783, 21235.783] [-110169 [...]
4 [0, 0, 0, 0, 0, 0] [63, 63, 63, 63, 63, 63] [11399, 11399,
11399, 11399, 11399, 11399] [-583523026, -583523026, -583523026,
-583523026, -583523026, -583523026] [8801164674137231293,
8801164674137231293, 8801164674137231293, 8801164674137231293,
8801164674137231293, 8801164674137231293] [-8287675635310193906,
-8287675635310193906, -8287675635310193906, -8287675635310193906,
-8287675635310193906, -8287675635310193906] [23243.16, 23243.16, 23243.16,
23243.16, 23243.16] [716719993.249115, [...]
8 [1, 1, 1, 1, 1, 1] [-11, -11, -11, -11, -11, -11] [-9648, -9648,
-9648, -9648, -9648, -9648] [-505356927, -505356927, -505356927,
-505356927, -505356927, -505356927] [7604760670442035037,
7604760670442035037, 7604760670442035037, 7604760670442035037,
7604760670442035037, 7604760670442035037] [1634770507625165798,
1634770507625165798, 1634770507625165798, 1634770507625165798,
1634770507625165798, 1634770507625165798] [10822.962, 10822.962, 10822.962,
10822.962, 10822.962] [1987551048.86 [...]
+16 [0, 0, 0, 0, 0, 0] [-43, -43, -43, -43, -43, -43] [13560, 13560,
13560, 13560, 13560, 13560] [-1743686513, -1743686513, -1743686513,
-1743686513, -1743686513, -1743686513] [7234719406392208769,
7234719406392208769, 7234719406392208769, 7234719406392208769,
7234719406392208769, 7234719406392208769] [-3871745630024229413,
-3871745630024229413, -3871745630024229413, -3871745630024229413,
-3871745630024229413, -3871745630024229413] [12225.427, 12225.427,
12225.427, 12225.427, 12225.427] [ [...]
16 [1, 1, 1, 1, 1, 1] [-7, -7, -7, -7, -7, -7] [18655, 18655,
18655, 18655, 18655, 18655] [6240356, 6240356, 6240356, 6240356, 6240356,
6240356] [4552179257266841393, 4552179257266841393, 4552179257266841393,
4552179257266841393, 4552179257266841393, 4552179257266841393]
[323868824766329978, 323868824766329978, 323868824766329978,
323868824766329978, 323868824766329978, 323868824766329978] [2972.2478,
2972.2478, 2972.2478, 2972.2478, 2972.2478] [-1177167334.995008,
-1177167334.995008, -1 [...]
+17 [1, 1, 1, 1, 1, 1] [126, 126, 126, 126, 126, 126] [28165, 28165,
28165, 28165, 28165, 28165] [2032059721, 2032059721, 2032059721,
2032059721, 2032059721, 2032059721] [-2686776977990574879,
-2686776977990574879, -2686776977990574879, -2686776977990574879,
-2686776977990574879, -2686776977990574879] [-8498149444423102876,
-8498149444423102876, -8498149444423102876, -8498149444423102876,
-8498149444423102876, -8498149444423102876] [-21681.223, -21681.223,
-21681.223, -21681.223, -21681.2 [...]
+41 [0, 0, 0, 0, 0, 0] [-25, -25, -25, -25, -25, -25] [28704, 28704,
28704, 28704, 28704, 28704] [-437867812, -437867812, -437867812,
-437867812, -437867812, -437867812] [5508042206505207079,
5508042206505207079, 5508042206505207079, 5508042206505207079,
5508042206505207079, 5508042206505207079] [462527544684407597,
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597,
462527544684407597] [13629.614, 13629.614, 13629.614, 13629.614,
13629.614] [213722401.337962, [...]
44 [0, 0, 0, 0, 0, 0] [61, 61, 61, 61, 61, NULL] [-23419,
-23419, -23419, -23419, -23419, -23419] [378600280, 378600280,
378600280, 378600280, 378600280, 378600280] [6788166268039991679,
6788166268039991679, 6788166268039991679, 6788166268039991679,
6788166268039991679, 6788166268039991679] [-2814786606977504852,
-2814786606977504852, -2814786606977504852, -2814786606977504852,
-2814786606977504852, -2814786606977504852] [-20151.432, -20151.432,
-20151.432, -20151.432, -20151.432] [-1248 [...]
48 [0, 0, 0, 0, 0, NULL] [88, 88, 88, 88, 88, 88] [-18899,
-18899, -18899, -18899, -18899, -18899] [1953750640, 1953750640,
1953750640, 1953750640, 1953750640, 1953750640] [-6083034186246180312,
-6083034186246180312, -6083034186246180312, -6083034186246180312,
-6083034186246180312, -6083034186246180312] [7861718260607212662,
7861718260607212662, 7861718260607212662, 7861718260607212662,
7861718260607212662, 7861718260607212662] [20562.791, 20562.791, 20562.791,
20562.791, 20562.791] [-15 [...]
49 [0, 0, 0, 0, 0, 0] [126, 126, 126, 126, 126, 126] [31661, 31661,
31661, 31661, 31661, 31661] [359703581, 359703581, 359703581, 359703581,
359703581, 359703581] [-2399575246807057939, -2399575246807057939,
-2399575246807057939, -2399575246807057939, -2399575246807057939,
-2399575246807057939] [7684667782059034391, 7684667782059034391,
7684667782059034391, 7684667782059034391, 7684667782059034391,
7684667782059034391] [-504.68152, -504.68152, -504.68152, -504.68152,
-504.68152] [2121528 [...]
+52 [0, 0, 0, 0, 0, 0] [-7, -7, -7, -7, -7, -7] [-6985, -6985,
-6985, -6985, -6985, -6985] [826683531, 826683531, 826683531, 826683531,
826683531, 826683531] [-8966681855246736361, -8966681855246736361,
-8966681855246736361, -8966681855246736361, -8966681855246736361,
-8966681855246736361] [4814686163176635446, 4814686163176635446,
4814686163176635446, 4814686163176635446, 4814686163176635446,
4814686163176635446] [-6490.2471, -6490.2471, -6490.2471, -6490.2471,
-6490.2471] [1076976372.03 [...]
+61 [1, 1, 1, 1, 1, 1] [121, 121, 121, 121, 121, 121] [31806, 31806,
31806, 31806, 31806, 31806] [-1410915562, -1410915562, -1410915562,
-1410915562, -1410915562, -1410915562] [-250403393155768717,
-250403393155768717, -250403393155768717, -250403393155768717,
-250403393155768717, -250403393155768717] [4301573778529723431,
4301573778529723431, 4301573778529723431, 4301573778529723431,
4301573778529723431, 4301573778529723431] [10719.892, 10719.892, 10719.892,
10719.892, 10719.892] [107378 [...]
76 [1, 1, 1, 1, 1, 1] [-63, -63, -63, -63, -63, -63] [25799, 25799,
25799, 25799, 25799, 25799] [-1387912656, -1387912656, -1387912656,
-1387912656, -1387912656, -1387912656] [8967926767558546181,
8967926767558546181, 8967926767558546181, 8967926767558546181,
8967926767558546181, 8967926767558546181] [-3537865898119184476,
-3537865898119184476, -3537865898119184476, -3537865898119184476,
-3537865898119184476, -3537865898119184476] [5311.188, 5311.188, 5311.188,
5311.188, 5311.188] [17362 [...]
-- !sql_max_filter_ratio --
+2 [0, 0, 0, 0, 0, 0] [117, 117, 117, 117, 117, 117] [-4744, -4744,
-4744, -4744, -4744, -4744] [-1593211961, -1593211961, -1593211961,
-1593211961, -1593211961, -1593211961] [-3869640069299678780,
-3869640069299678780, -3869640069299678780, -3869640069299678780,
-3869640069299678780, -3869640069299678780] [8491817458398170567,
8491817458398170567, 8491817458398170567, 8491817458398170567,
8491817458398170567, 8491817458398170567] [-30948.857, -30948.857, -30948.857,
-30948.857, -30948.85 [...]
3 [0, 0, 0, 0, 0, 0] [65, 65, 65, 65, 65, 65] [-4963, -4963,
-4963, -4963, -4963, -4963] [-1415431954, -1415431954, -1415431954,
-1415431954, -1415431954, -1415431954] [-3804309860450207000,
-3804309860450207000, -3804309860450207000, -3804309860450207000,
-3804309860450207000, -3804309860450207000] [8209240008557215376,
8209240008557215376, 8209240008557215376, 8209240008557215376,
8209240008557215376, 8209240008557215376] [-5058.13, -5058.13, -5058.13,
-5058.13, -5058.13] [1034763010.6 [...]
-4 [0, 0, 0, 0, 0, 0] [63, 63, 63, 63, 63, 63] [11399, 11399,
11399, 11399, 11399, 11399] [-583523026, -583523026, -583523026,
-583523026, -583523026, -583523026] [8801164674137231293,
8801164674137231293, 8801164674137231293, 8801164674137231293,
8801164674137231293, 8801164674137231293] [-8287675635310193906,
-8287675635310193906, -8287675635310193906, -8287675635310193906,
-8287675635310193906, -8287675635310193906] [23243.16, 23243.16, 23243.16,
23243.16, 23243.16] [716719993.249115, [...]
+4 [0, 0, 0, 0, 0, 0] [-67, -67, -67, -67, -67, -67] [-30372,
-30372, -30372, -30372, -30372, -30372] [181502941, 181502941,
181502941, 181502941, 181502941, 181502941] [-2062236823576972800,
-2062236823576972800, -2062236823576972800, -2062236823576972800,
-2062236823576972800, -2062236823576972800] [6357002962400127842,
6357002962400127842, 6357002962400127842, 6357002962400127842,
6357002962400127842, 6357002962400127842] [21235.783, 21235.783, 21235.783,
21235.783, 21235.783] [-110169 [...]
8 [1, 1, 1, 1, 1, 1] [-11, -11, -11, -11, -11, -11] [-9648, -9648,
-9648, -9648, -9648, -9648] [-505356927, -505356927, -505356927,
-505356927, -505356927, -505356927] [7604760670442035037,
7604760670442035037, 7604760670442035037, 7604760670442035037,
7604760670442035037, 7604760670442035037] [1634770507625165798,
1634770507625165798, 1634770507625165798, 1634770507625165798,
1634770507625165798, 1634770507625165798] [10822.962, 10822.962, 10822.962,
10822.962, 10822.962] [1987551048.86 [...]
-16 [1, 1, 1, 1, 1, 1] [-7, -7, -7, -7, -7, -7] [18655, 18655,
18655, 18655, 18655, 18655] [6240356, 6240356, 6240356, 6240356, 6240356,
6240356] [4552179257266841393, 4552179257266841393, 4552179257266841393,
4552179257266841393, 4552179257266841393, 4552179257266841393]
[323868824766329978, 323868824766329978, 323868824766329978,
323868824766329978, 323868824766329978, 323868824766329978] [2972.2478,
2972.2478, 2972.2478, 2972.2478, 2972.2478] [-1177167334.995008,
-1177167334.995008, -1 [...]
+16 [0, 0, 0, 0, 0, 0] [-43, -43, -43, -43, -43, -43] [13560, 13560,
13560, 13560, 13560, 13560] [-1743686513, -1743686513, -1743686513,
-1743686513, -1743686513, -1743686513] [7234719406392208769,
7234719406392208769, 7234719406392208769, 7234719406392208769,
7234719406392208769, 7234719406392208769] [-3871745630024229413,
-3871745630024229413, -3871745630024229413, -3871745630024229413,
-3871745630024229413, -3871745630024229413] [12225.427, 12225.427,
12225.427, 12225.427, 12225.427] [ [...]
+17 [1, 1, 1, 1, 1, 1] [126, 126, 126, 126, 126, 126] [28165, 28165,
28165, 28165, 28165, 28165] [2032059721, 2032059721, 2032059721,
2032059721, 2032059721, 2032059721] [-2686776977990574879,
-2686776977990574879, -2686776977990574879, -2686776977990574879,
-2686776977990574879, -2686776977990574879] [-8498149444423102876,
-8498149444423102876, -8498149444423102876, -8498149444423102876,
-8498149444423102876, -8498149444423102876] [-21681.223, -21681.223,
-21681.223, -21681.223, -21681.2 [...]
+41 [0, 0, 0, 0, 0, 0] [-25, -25, -25, -25, -25, -25] [28704, 28704,
28704, 28704, 28704, 28704] [-437867812, -437867812, -437867812,
-437867812, -437867812, -437867812] [5508042206505207079,
5508042206505207079, 5508042206505207079, 5508042206505207079,
5508042206505207079, 5508042206505207079] [462527544684407597,
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597,
462527544684407597] [13629.614, 13629.614, 13629.614, 13629.614,
13629.614] [213722401.337962, [...]
44 [0, 0, 0, 0, 0, 0] [61, 61, 61, 61, 61, NULL] [-23419,
-23419, -23419, -23419, -23419, -23419] [378600280, 378600280,
378600280, 378600280, 378600280, 378600280] [6788166268039991679,
6788166268039991679, 6788166268039991679, 6788166268039991679,
6788166268039991679, 6788166268039991679] [-2814786606977504852,
-2814786606977504852, -2814786606977504852, -2814786606977504852,
-2814786606977504852, -2814786606977504852] [-20151.432, -20151.432,
-20151.432, -20151.432, -20151.432] [-1248 [...]
48 [0, 0, 0, 0, 0, NULL] [88, 88, 88, 88, 88, 88] [-18899,
-18899, -18899, -18899, -18899, -18899] [1953750640, 1953750640,
1953750640, 1953750640, 1953750640, 1953750640] [-6083034186246180312,
-6083034186246180312, -6083034186246180312, -6083034186246180312,
-6083034186246180312, -6083034186246180312] [7861718260607212662,
7861718260607212662, 7861718260607212662, 7861718260607212662,
7861718260607212662, 7861718260607212662] [20562.791, 20562.791, 20562.791,
20562.791, 20562.791] [-15 [...]
49 [0, 0, 0, 0, 0, 0] [126, 126, 126, 126, 126, 126] [31661, 31661,
31661, 31661, 31661, 31661] [359703581, 359703581, 359703581, 359703581,
359703581, 359703581] [-2399575246807057939, -2399575246807057939,
-2399575246807057939, -2399575246807057939, -2399575246807057939,
-2399575246807057939] [7684667782059034391, 7684667782059034391,
7684667782059034391, 7684667782059034391, 7684667782059034391,
7684667782059034391] [-504.68152, -504.68152, -504.68152, -504.68152,
-504.68152] [2121528 [...]
+52 [0, 0, 0, 0, 0, 0] [-7, -7, -7, -7, -7, -7] [-6985, -6985,
-6985, -6985, -6985, -6985] [826683531, 826683531, 826683531, 826683531,
826683531, 826683531] [-8966681855246736361, -8966681855246736361,
-8966681855246736361, -8966681855246736361, -8966681855246736361,
-8966681855246736361] [4814686163176635446, 4814686163176635446,
4814686163176635446, 4814686163176635446, 4814686163176635446,
4814686163176635446] [-6490.2471, -6490.2471, -6490.2471, -6490.2471,
-6490.2471] [1076976372.03 [...]
+61 [1, 1, 1, 1, 1, 1] [121, 121, 121, 121, 121, 121] [31806, 31806,
31806, 31806, 31806, 31806] [-1410915562, -1410915562, -1410915562,
-1410915562, -1410915562, -1410915562] [-250403393155768717,
-250403393155768717, -250403393155768717, -250403393155768717,
-250403393155768717, -250403393155768717] [4301573778529723431,
4301573778529723431, 4301573778529723431, 4301573778529723431,
4301573778529723431, 4301573778529723431] [10719.892, 10719.892, 10719.892,
10719.892, 10719.892] [107378 [...]
76 [1, 1, 1, 1, 1, 1] [-63, -63, -63, -63, -63, -63] [25799, 25799,
25799, 25799, 25799, 25799] [-1387912656, -1387912656, -1387912656,
-1387912656, -1387912656, -1387912656] [8967926767558546181,
8967926767558546181, 8967926767558546181, 8967926767558546181,
8967926767558546181, 8967926767558546181] [-3537865898119184476,
-3537865898119184476, -3537865898119184476, -3537865898119184476,
-3537865898119184476, -3537865898119184476] [5311.188, 5311.188, 5311.188,
5311.188, 5311.188] [17362 [...]
-- !sql_max_filter_ratio --
diff --git
a/regression-test/suites/load_p0/stream_load/test_stream_load_properties.groovy
b/regression-test/suites/load_p0/stream_load/test_stream_load_properties.groovy
index 3d7ca2e9e92..63c23bdf17e 100644
---
a/regression-test/suites/load_p0/stream_load/test_stream_load_properties.groovy
+++
b/regression-test/suites/load_p0/stream_load/test_stream_load_properties.groovy
@@ -46,7 +46,7 @@ suite("test_stream_load_properties", "p0") {
"k00,k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18",
"k00,k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18",
"k00,k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18",
-
"k00,k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18,k19=to_bitmap(k04),k20=HLL_HASH(k04),k21=TO_QUANTILE_STATE(k04,1.0),kd19=to_bitmap(k05),kd20=HLL_HASH(k05),kd21=TO_QUANTILE_STATE(k05,1.0)",
+
"k00,k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18,k19=to_bitmap(k04),k20=HLL_HASH(k04),k21=TO_QUANTILE_STATE(k04,1.0),kd19=to_bitmap(k05),kd20=HLL_HASH(k05),kd21=TO_QUANTILE_STATE(k04,1.0)",
"k00,k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17",
"k00,k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17",
"k00,k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17",
@@ -57,7 +57,7 @@ suite("test_stream_load_properties", "p0") {
"k00=unix_timestamp('2007-11-30
10:30:19'),k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18",
"k00=unix_timestamp('2007-11-30
10:30:19'),k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18",
"k00=unix_timestamp('2007-11-30
10:30:19'),k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18",
- "k00=unix_timestamp('2007-11-30
10:30:19'),k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18,k19=to_bitmap(k04),k20=HLL_HASH(k04),k21=TO_QUANTILE_STATE(k04,1.0),kd19=to_bitmap(k05),kd20=HLL_HASH(k05),kd21=TO_QUANTILE_STATE(k05,1.0)",
+ "k00=unix_timestamp('2007-11-30
10:30:19'),k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17,k18,k19=to_bitmap(k04),k20=HLL_HASH(k04),k21=TO_QUANTILE_STATE(k04,1.0),kd19=to_bitmap(k05),kd20=HLL_HASH(k05),kd21=TO_QUANTILE_STATE(k04,1.0)",
"k00=unix_timestamp('2007-11-30
10:30:19'),k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17",
"k00=unix_timestamp('2007-11-30
10:30:19'),k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17",
"k00=unix_timestamp('2007-11-30
10:30:19'),k01,k02,k03,k04,k05,k06,k07,k08,k09,k10,k11,k12,k13,k14,k15,k16,k17",
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
