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 fca0a6ab7dd Revert "[Branch2.0](Export) add show export regression
testes #27140 (#27160)" (#27217)
fca0a6ab7dd is described below
commit fca0a6ab7dd369e51091977f9dffccf7704dc472
Author: Kang <[email protected]>
AuthorDate: Fri Nov 17 20:17:57 2023 -0600
Revert "[Branch2.0](Export) add show export regression testes #27140
(#27160)" (#27217)
This reverts commit d76581d10c551f0b180b498168db47f2036f28b9, since it
caused test_show_export testcase fail.
---
.../data/export_p0/export/test_show_export.out | 257 ---------------------
.../export_p0/export/test_show_export.groovy | 228 ------------------
2 files changed, 485 deletions(-)
diff --git a/regression-test/data/export_p0/export/test_show_export.out
b/regression-test/data/export_p0/export/test_show_export.out
deleted file mode 100644
index 8432bc86e70..00000000000
--- a/regression-test/data/export_p0/export/test_show_export.out
+++ /dev/null
@@ -1,257 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !select_export1 --
-1 2017-10-01 2017-10-01T00:00 Beijing 1 1 true
1 1 1 1.1 1.1 char1 1
-10 2017-10-01 2017-10-01T00:00 Beijing 10 10 true
10 10 10 10.1 10.1 char10 10
-100 2017-10-01 2017-10-01T00:00 \N \N \N \N
\N \N \N \N \N \N \N
-11 2017-10-01 2017-10-01T00:00 Beijing 11 11 true
11 11 11 11.11 11.11 char11 11
-12 2017-10-01 2017-10-01T00:00 Beijing 12 12 true
12 12 12 12.12 12.12 char12 12
-13 2017-10-01 2017-10-01T00:00 Beijing 13 13 true
13 13 13 13.13 13.13 char13 13
-14 2017-10-01 2017-10-01T00:00 Beijing 14 14 true
14 14 14 14.14 14.14 char14 14
-15 2017-10-01 2017-10-01T00:00 Beijing 15 15 true
15 15 15 15.15 15.15 char15 15
-16 2017-10-01 2017-10-01T00:00 Beijing 16 16 true
16 16 16 16.16 16.16 char16 16
-17 2017-10-01 2017-10-01T00:00 Beijing 17 17 true
17 17 17 17.17 17.17 char17 17
-18 2017-10-01 2017-10-01T00:00 Beijing 18 18 true
18 18 18 18.18 18.18 char18 18
-19 2017-10-01 2017-10-01T00:00 Beijing 19 19 true
19 19 19 19.19 19.19 char19 19
-2 2017-10-01 2017-10-01T00:00 Beijing 2 2 true
2 2 2 2.2 2.2 char2 2
-20 2017-10-01 2017-10-01T00:00 Beijing 20 20 true
20 20 20 20.2 20.2 char20 20
-21 2017-10-01 2017-10-01T00:00 Beijing 21 21 true
21 21 21 21.21 21.21 char21 21
-22 2017-10-01 2017-10-01T00:00 Beijing 22 22 true
22 22 22 22.22 22.22 char22 22
-23 2017-10-01 2017-10-01T00:00 Beijing 23 23 true
23 23 23 23.23 23.23 char23 23
-24 2017-10-01 2017-10-01T00:00 Beijing 24 24 true
24 24 24 24.24 24.24 char24 24
-25 2017-10-01 2017-10-01T00:00 Beijing 25 25 true
25 25 25 25.25 25.25 char25 25
-26 2017-10-01 2017-10-01T00:00 Beijing 26 26 true
26 26 26 26.26 26.26 char26 26
-27 2017-10-01 2017-10-01T00:00 Beijing 27 27 true
27 27 27 27.27 27.27 char27 27
-28 2017-10-01 2017-10-01T00:00 Beijing 28 28 true
28 28 28 28.28 28.28 char28 28
-29 2017-10-01 2017-10-01T00:00 Beijing 29 29 true
29 29 29 29.29 29.29 char29 29
-3 2017-10-01 2017-10-01T00:00 Beijing 3 3 true
3 3 3 3.3 3.3 char3 3
-30 2017-10-01 2017-10-01T00:00 Beijing 30 30 true
30 30 30 30.3 30.3 char30 30
-31 2017-10-01 2017-10-01T00:00 Beijing 31 31 true
31 31 31 31.31 31.31 char31 31
-32 2017-10-01 2017-10-01T00:00 Beijing 32 32 true
32 32 32 32.32 32.32 char32 32
-33 2017-10-01 2017-10-01T00:00 Beijing 33 33 true
33 33 33 33.33 33.33 char33 33
-34 2017-10-01 2017-10-01T00:00 Beijing 34 34 true
34 34 34 34.34 34.34 char34 34
-35 2017-10-01 2017-10-01T00:00 Beijing 35 35 true
35 35 35 35.35 35.35 char35 35
-36 2017-10-01 2017-10-01T00:00 Beijing 36 36 true
36 36 36 36.36 36.36 char36 36
-37 2017-10-01 2017-10-01T00:00 Beijing 37 37 true
37 37 37 37.37 37.37 char37 37
-38 2017-10-01 2017-10-01T00:00 Beijing 38 38 true
38 38 38 38.38 38.38 char38 38
-39 2017-10-01 2017-10-01T00:00 Beijing 39 39 true
39 39 39 39.39 39.39 char39 39
-4 2017-10-01 2017-10-01T00:00 Beijing 4 4 true
4 4 4 4.4 4.4 char4 4
-40 2017-10-01 2017-10-01T00:00 Beijing 40 40 true
40 40 40 40.4 40.4 char40 40
-41 2017-10-01 2017-10-01T00:00 Beijing 41 41 true
41 41 41 41.41 41.41 char41 41
-42 2017-10-01 2017-10-01T00:00 Beijing 42 42 true
42 42 42 42.42 42.42 char42 42
-43 2017-10-01 2017-10-01T00:00 Beijing 43 43 true
43 43 43 43.43 43.43 char43 43
-44 2017-10-01 2017-10-01T00:00 Beijing 44 44 true
44 44 44 44.44 44.44 char44 44
-45 2017-10-01 2017-10-01T00:00 Beijing 45 45 true
45 45 45 45.45 45.45 char45 45
-46 2017-10-01 2017-10-01T00:00 Beijing 46 46 true
46 46 46 46.46 46.46 char46 46
-47 2017-10-01 2017-10-01T00:00 Beijing 47 47 true
47 47 47 47.47 47.47 char47 47
-48 2017-10-01 2017-10-01T00:00 Beijing 48 48 true
48 48 48 48.48 48.48 char48 48
-49 2017-10-01 2017-10-01T00:00 Beijing 49 49 true
49 49 49 49.49 49.49 char49 49
-5 2017-10-01 2017-10-01T00:00 Beijing 5 5 true
5 5 5 5.5 5.5 char5 5
-50 2017-10-01 2017-10-01T00:00 Beijing 50 50 true
50 50 50 50.5 50.5 char50 50
-51 2017-10-01 2017-10-01T00:00 Beijing 51 51 true
51 51 51 51.51 51.51 char51 51
-52 2017-10-01 2017-10-01T00:00 Beijing 52 52 true
52 52 52 52.52 52.52 char52 52
-53 2017-10-01 2017-10-01T00:00 Beijing 53 53 true
53 53 53 53.53 53.53 char53 53
-54 2017-10-01 2017-10-01T00:00 Beijing 54 54 true
54 54 54 54.54 54.54 char54 54
-55 2017-10-01 2017-10-01T00:00 Beijing 55 55 true
55 55 55 55.55 55.55 char55 55
-56 2017-10-01 2017-10-01T00:00 Beijing 56 56 true
56 56 56 56.56 56.56 char56 56
-57 2017-10-01 2017-10-01T00:00 Beijing 57 57 true
57 57 57 57.57 57.57 char57 57
-58 2017-10-01 2017-10-01T00:00 Beijing 58 58 true
58 58 58 58.58 58.58 char58 58
-59 2017-10-01 2017-10-01T00:00 Beijing 59 59 true
59 59 59 59.59 59.59 char59 59
-6 2017-10-01 2017-10-01T00:00 Beijing 6 6 true
6 6 6 6.6 6.6 char6 6
-60 2017-10-01 2017-10-01T00:00 Beijing 60 60 true
60 60 60 60.6 60.6 char60 60
-61 2017-10-01 2017-10-01T00:00 Beijing 61 61 true
61 61 61 61.61 61.61 char61 61
-62 2017-10-01 2017-10-01T00:00 Beijing 62 62 true
62 62 62 62.62 62.62 char62 62
-63 2017-10-01 2017-10-01T00:00 Beijing 63 63 true
63 63 63 63.63 63.63 char63 63
-64 2017-10-01 2017-10-01T00:00 Beijing 64 64 true
64 64 64 64.64 64.64 char64 64
-65 2017-10-01 2017-10-01T00:00 Beijing 65 65 true
65 65 65 65.65 65.65 char65 65
-66 2017-10-01 2017-10-01T00:00 Beijing 66 66 true
66 66 66 66.66 66.66 char66 66
-67 2017-10-01 2017-10-01T00:00 Beijing 67 67 true
67 67 67 67.67 67.67 char67 67
-68 2017-10-01 2017-10-01T00:00 Beijing 68 68 true
68 68 68 68.68 68.68 char68 68
-69 2017-10-01 2017-10-01T00:00 Beijing 69 69 true
69 69 69 69.69 69.69 char69 69
-7 2017-10-01 2017-10-01T00:00 Beijing 7 7 true
7 7 7 7.7 7.7 char7 7
-70 2017-10-01 2017-10-01T00:00 Beijing 70 70 true
70 70 70 70.7 70.7 char70 70
-71 2017-10-01 2017-10-01T00:00 Beijing 71 71 true
71 71 71 71.71 71.71 char71 71
-72 2017-10-01 2017-10-01T00:00 Beijing 72 72 true
72 72 72 72.72 72.72 char72 72
-73 2017-10-01 2017-10-01T00:00 Beijing 73 73 true
73 73 73 73.73 73.73 char73 73
-74 2017-10-01 2017-10-01T00:00 Beijing 74 74 true
74 74 74 74.74 74.74 char74 74
-75 2017-10-01 2017-10-01T00:00 Beijing 75 75 true
75 75 75 75.75 75.75 char75 75
-76 2017-10-01 2017-10-01T00:00 Beijing 76 76 true
76 76 76 76.76 76.76 char76 76
-77 2017-10-01 2017-10-01T00:00 Beijing 77 77 true
77 77 77 77.77 77.77 char77 77
-78 2017-10-01 2017-10-01T00:00 Beijing 78 78 true
78 78 78 78.78 78.78 char78 78
-79 2017-10-01 2017-10-01T00:00 Beijing 79 79 true
79 79 79 79.79 79.79 char79 79
-8 2017-10-01 2017-10-01T00:00 Beijing 8 8 true
8 8 8 8.8 8.8 char8 8
-80 2017-10-01 2017-10-01T00:00 Beijing 80 80 true
80 80 80 80.8 80.8 char80 80
-81 2017-10-01 2017-10-01T00:00 Beijing 81 81 true
81 81 81 81.81 81.81 char81 81
-82 2017-10-01 2017-10-01T00:00 Beijing 82 82 true
82 82 82 82.82 82.82 char82 82
-83 2017-10-01 2017-10-01T00:00 Beijing 83 83 true
83 83 83 83.83 83.83 char83 83
-84 2017-10-01 2017-10-01T00:00 Beijing 84 84 true
84 84 84 84.84 84.84 char84 84
-85 2017-10-01 2017-10-01T00:00 Beijing 85 85 true
85 85 85 85.85 85.85 char85 85
-86 2017-10-01 2017-10-01T00:00 Beijing 86 86 true
86 86 86 86.86 86.86 char86 86
-87 2017-10-01 2017-10-01T00:00 Beijing 87 87 true
87 87 87 87.87 87.87 char87 87
-88 2017-10-01 2017-10-01T00:00 Beijing 88 88 true
88 88 88 88.88 88.88 char88 88
-89 2017-10-01 2017-10-01T00:00 Beijing 89 89 true
89 89 89 89.89 89.89 char89 89
-9 2017-10-01 2017-10-01T00:00 Beijing 9 9 true
9 9 9 9.9 9.9 char9 9
-90 2017-10-01 2017-10-01T00:00 Beijing 90 90 true
90 90 90 90.9 90.9 char90 90
-91 2017-10-01 2017-10-01T00:00 Beijing 91 91 true
91 91 91 91.91 91.91 char91 91
-92 2017-10-01 2017-10-01T00:00 Beijing 92 92 true
92 92 92 92.92 92.92 char92 92
-93 2017-10-01 2017-10-01T00:00 Beijing 93 93 true
93 93 93 93.93 93.93 char93 93
-94 2017-10-01 2017-10-01T00:00 Beijing 94 94 true
94 94 94 94.94 94.94 char94 94
-95 2017-10-01 2017-10-01T00:00 Beijing 95 95 true
95 95 95 95.95 95.95 char95 95
-96 2017-10-01 2017-10-01T00:00 Beijing 96 96 true
96 96 96 96.96 96.96 char96 96
-97 2017-10-01 2017-10-01T00:00 Beijing 97 97 true
97 97 97 97.97 97.97 char97 97
-98 2017-10-01 2017-10-01T00:00 Beijing 98 98 true
98 98 98 98.98 98.98 char98 98
-99 2017-10-01 2017-10-01T00:00 Beijing 99 99 true
99 99 99 99.99 99.99 char99 99
-
--- !select_load1 --
-1 2017-10-01 2017-10-01 00:00:00 Beijing 1 1 true
1 1 1.1 1.1 char1 1 1
-10 2017-10-01 2017-10-01 00:00:00 Beijing 10 10 true
10 10 10.1 10.1 char10 10 10
-100 2017-10-01 2017-10-01 00:00:00 \N \N \N \N
\N \N \N \N \N \N \N
-11 2017-10-01 2017-10-01 00:00:00 Beijing 11 11 true
11 11 11.11 11.11 char11 11 11
-12 2017-10-01 2017-10-01 00:00:00 Beijing 12 12 true
12 12 12.12 12.12 char12 12 12
-13 2017-10-01 2017-10-01 00:00:00 Beijing 13 13 true
13 13 13.13 13.13 char13 13 13
-14 2017-10-01 2017-10-01 00:00:00 Beijing 14 14 true
14 14 14.14 14.14 char14 14 14
-15 2017-10-01 2017-10-01 00:00:00 Beijing 15 15 true
15 15 15.15 15.15 char15 15 15
-16 2017-10-01 2017-10-01 00:00:00 Beijing 16 16 true
16 16 16.16 16.16 char16 16 16
-17 2017-10-01 2017-10-01 00:00:00 Beijing 17 17 true
17 17 17.17 17.17 char17 17 17
-18 2017-10-01 2017-10-01 00:00:00 Beijing 18 18 true
18 18 18.18 18.18 char18 18 18
-19 2017-10-01 2017-10-01 00:00:00 Beijing 19 19 true
19 19 19.19 19.19 char19 19 19
-2 2017-10-01 2017-10-01 00:00:00 Beijing 2 2 true
2 2 2.2 2.2 char2 2 2
-20 2017-10-01 2017-10-01 00:00:00 Beijing 20 20 true
20 20 20.2 20.2 char20 20 20
-21 2017-10-01 2017-10-01 00:00:00 Beijing 21 21 true
21 21 21.21 21.21 char21 21 21
-22 2017-10-01 2017-10-01 00:00:00 Beijing 22 22 true
22 22 22.22 22.22 char22 22 22
-23 2017-10-01 2017-10-01 00:00:00 Beijing 23 23 true
23 23 23.23 23.23 char23 23 23
-24 2017-10-01 2017-10-01 00:00:00 Beijing 24 24 true
24 24 24.24 24.24 char24 24 24
-25 2017-10-01 2017-10-01 00:00:00 Beijing 25 25 true
25 25 25.25 25.25 char25 25 25
-26 2017-10-01 2017-10-01 00:00:00 Beijing 26 26 true
26 26 26.26 26.26 char26 26 26
-27 2017-10-01 2017-10-01 00:00:00 Beijing 27 27 true
27 27 27.27 27.27 char27 27 27
-28 2017-10-01 2017-10-01 00:00:00 Beijing 28 28 true
28 28 28.28 28.28 char28 28 28
-29 2017-10-01 2017-10-01 00:00:00 Beijing 29 29 true
29 29 29.29 29.29 char29 29 29
-3 2017-10-01 2017-10-01 00:00:00 Beijing 3 3 true
3 3 3.3 3.3 char3 3 3
-30 2017-10-01 2017-10-01 00:00:00 Beijing 30 30 true
30 30 30.3 30.3 char30 30 30
-31 2017-10-01 2017-10-01 00:00:00 Beijing 31 31 true
31 31 31.31 31.31 char31 31 31
-32 2017-10-01 2017-10-01 00:00:00 Beijing 32 32 true
32 32 32.32 32.32 char32 32 32
-33 2017-10-01 2017-10-01 00:00:00 Beijing 33 33 true
33 33 33.33 33.33 char33 33 33
-34 2017-10-01 2017-10-01 00:00:00 Beijing 34 34 true
34 34 34.34 34.34 char34 34 34
-35 2017-10-01 2017-10-01 00:00:00 Beijing 35 35 true
35 35 35.35 35.35 char35 35 35
-36 2017-10-01 2017-10-01 00:00:00 Beijing 36 36 true
36 36 36.36 36.36 char36 36 36
-37 2017-10-01 2017-10-01 00:00:00 Beijing 37 37 true
37 37 37.37 37.37 char37 37 37
-38 2017-10-01 2017-10-01 00:00:00 Beijing 38 38 true
38 38 38.38 38.38 char38 38 38
-39 2017-10-01 2017-10-01 00:00:00 Beijing 39 39 true
39 39 39.39 39.39 char39 39 39
-4 2017-10-01 2017-10-01 00:00:00 Beijing 4 4 true
4 4 4.4 4.4 char4 4 4
-40 2017-10-01 2017-10-01 00:00:00 Beijing 40 40 true
40 40 40.4 40.4 char40 40 40
-41 2017-10-01 2017-10-01 00:00:00 Beijing 41 41 true
41 41 41.41 41.41 char41 41 41
-42 2017-10-01 2017-10-01 00:00:00 Beijing 42 42 true
42 42 42.42 42.42 char42 42 42
-43 2017-10-01 2017-10-01 00:00:00 Beijing 43 43 true
43 43 43.43 43.43 char43 43 43
-44 2017-10-01 2017-10-01 00:00:00 Beijing 44 44 true
44 44 44.44 44.44 char44 44 44
-45 2017-10-01 2017-10-01 00:00:00 Beijing 45 45 true
45 45 45.45 45.45 char45 45 45
-46 2017-10-01 2017-10-01 00:00:00 Beijing 46 46 true
46 46 46.46 46.46 char46 46 46
-47 2017-10-01 2017-10-01 00:00:00 Beijing 47 47 true
47 47 47.47 47.47 char47 47 47
-48 2017-10-01 2017-10-01 00:00:00 Beijing 48 48 true
48 48 48.48 48.48 char48 48 48
-49 2017-10-01 2017-10-01 00:00:00 Beijing 49 49 true
49 49 49.49 49.49 char49 49 49
-5 2017-10-01 2017-10-01 00:00:00 Beijing 5 5 true
5 5 5.5 5.5 char5 5 5
-50 2017-10-01 2017-10-01 00:00:00 Beijing 50 50 true
50 50 50.5 50.5 char50 50 50
-51 2017-10-01 2017-10-01 00:00:00 Beijing 51 51 true
51 51 51.51 51.51 char51 51 51
-52 2017-10-01 2017-10-01 00:00:00 Beijing 52 52 true
52 52 52.52 52.52 char52 52 52
-53 2017-10-01 2017-10-01 00:00:00 Beijing 53 53 true
53 53 53.53 53.53 char53 53 53
-54 2017-10-01 2017-10-01 00:00:00 Beijing 54 54 true
54 54 54.54 54.54 char54 54 54
-55 2017-10-01 2017-10-01 00:00:00 Beijing 55 55 true
55 55 55.55 55.55 char55 55 55
-56 2017-10-01 2017-10-01 00:00:00 Beijing 56 56 true
56 56 56.56 56.56 char56 56 56
-57 2017-10-01 2017-10-01 00:00:00 Beijing 57 57 true
57 57 57.57 57.57 char57 57 57
-58 2017-10-01 2017-10-01 00:00:00 Beijing 58 58 true
58 58 58.58 58.58 char58 58 58
-59 2017-10-01 2017-10-01 00:00:00 Beijing 59 59 true
59 59 59.59 59.59 char59 59 59
-6 2017-10-01 2017-10-01 00:00:00 Beijing 6 6 true
6 6 6.6 6.6 char6 6 6
-60 2017-10-01 2017-10-01 00:00:00 Beijing 60 60 true
60 60 60.6 60.6 char60 60 60
-61 2017-10-01 2017-10-01 00:00:00 Beijing 61 61 true
61 61 61.61 61.61 char61 61 61
-62 2017-10-01 2017-10-01 00:00:00 Beijing 62 62 true
62 62 62.62 62.62 char62 62 62
-63 2017-10-01 2017-10-01 00:00:00 Beijing 63 63 true
63 63 63.63 63.63 char63 63 63
-64 2017-10-01 2017-10-01 00:00:00 Beijing 64 64 true
64 64 64.64 64.64 char64 64 64
-65 2017-10-01 2017-10-01 00:00:00 Beijing 65 65 true
65 65 65.65 65.65 char65 65 65
-66 2017-10-01 2017-10-01 00:00:00 Beijing 66 66 true
66 66 66.66 66.66 char66 66 66
-67 2017-10-01 2017-10-01 00:00:00 Beijing 67 67 true
67 67 67.67 67.67 char67 67 67
-68 2017-10-01 2017-10-01 00:00:00 Beijing 68 68 true
68 68 68.68 68.68 char68 68 68
-69 2017-10-01 2017-10-01 00:00:00 Beijing 69 69 true
69 69 69.69 69.69 char69 69 69
-7 2017-10-01 2017-10-01 00:00:00 Beijing 7 7 true
7 7 7.7 7.7 char7 7 7
-70 2017-10-01 2017-10-01 00:00:00 Beijing 70 70 true
70 70 70.7 70.7 char70 70 70
-71 2017-10-01 2017-10-01 00:00:00 Beijing 71 71 true
71 71 71.71 71.71 char71 71 71
-72 2017-10-01 2017-10-01 00:00:00 Beijing 72 72 true
72 72 72.72 72.72 char72 72 72
-73 2017-10-01 2017-10-01 00:00:00 Beijing 73 73 true
73 73 73.73 73.73 char73 73 73
-74 2017-10-01 2017-10-01 00:00:00 Beijing 74 74 true
74 74 74.74 74.74 char74 74 74
-75 2017-10-01 2017-10-01 00:00:00 Beijing 75 75 true
75 75 75.75 75.75 char75 75 75
-76 2017-10-01 2017-10-01 00:00:00 Beijing 76 76 true
76 76 76.76 76.76 char76 76 76
-77 2017-10-01 2017-10-01 00:00:00 Beijing 77 77 true
77 77 77.77 77.77 char77 77 77
-78 2017-10-01 2017-10-01 00:00:00 Beijing 78 78 true
78 78 78.78 78.78 char78 78 78
-79 2017-10-01 2017-10-01 00:00:00 Beijing 79 79 true
79 79 79.79 79.79 char79 79 79
-8 2017-10-01 2017-10-01 00:00:00 Beijing 8 8 true
8 8 8.8 8.8 char8 8 8
-80 2017-10-01 2017-10-01 00:00:00 Beijing 80 80 true
80 80 80.8 80.8 char80 80 80
-81 2017-10-01 2017-10-01 00:00:00 Beijing 81 81 true
81 81 81.81 81.81 char81 81 81
-82 2017-10-01 2017-10-01 00:00:00 Beijing 82 82 true
82 82 82.82 82.82 char82 82 82
-83 2017-10-01 2017-10-01 00:00:00 Beijing 83 83 true
83 83 83.83 83.83 char83 83 83
-84 2017-10-01 2017-10-01 00:00:00 Beijing 84 84 true
84 84 84.84 84.84 char84 84 84
-85 2017-10-01 2017-10-01 00:00:00 Beijing 85 85 true
85 85 85.85 85.85 char85 85 85
-86 2017-10-01 2017-10-01 00:00:00 Beijing 86 86 true
86 86 86.86 86.86 char86 86 86
-87 2017-10-01 2017-10-01 00:00:00 Beijing 87 87 true
87 87 87.87 87.87 char87 87 87
-88 2017-10-01 2017-10-01 00:00:00 Beijing 88 88 true
88 88 88.88 88.88 char88 88 88
-89 2017-10-01 2017-10-01 00:00:00 Beijing 89 89 true
89 89 89.89 89.89 char89 89 89
-9 2017-10-01 2017-10-01 00:00:00 Beijing 9 9 true
9 9 9.9 9.9 char9 9 9
-90 2017-10-01 2017-10-01 00:00:00 Beijing 90 90 true
90 90 90.9 90.9 char90 90 90
-91 2017-10-01 2017-10-01 00:00:00 Beijing 91 91 true
91 91 91.91 91.91 char91 91 91
-92 2017-10-01 2017-10-01 00:00:00 Beijing 92 92 true
92 92 92.92 92.92 char92 92 92
-93 2017-10-01 2017-10-01 00:00:00 Beijing 93 93 true
93 93 93.93 93.93 char93 93 93
-94 2017-10-01 2017-10-01 00:00:00 Beijing 94 94 true
94 94 94.94 94.94 char94 94 94
-95 2017-10-01 2017-10-01 00:00:00 Beijing 95 95 true
95 95 95.95 95.95 char95 95 95
-96 2017-10-01 2017-10-01 00:00:00 Beijing 96 96 true
96 96 96.96 96.96 char96 96 96
-97 2017-10-01 2017-10-01 00:00:00 Beijing 97 97 true
97 97 97.97 97.97 char97 97 97
-98 2017-10-01 2017-10-01 00:00:00 Beijing 98 98 true
98 98 98.98 98.98 char98 98 98
-99 2017-10-01 2017-10-01 00:00:00 Beijing 99 99 true
99 99 99.99 99.99 char99 99 99
-
--- !select_load1 --
-20 2017-10-01 2017-10-01 00:00:00 Beijing 20 20 true
20 20 20.2 20.2 char20 20 20
-21 2017-10-01 2017-10-01 00:00:00 Beijing 21 21 true
21 21 21.21 21.21 char21 21 21
-22 2017-10-01 2017-10-01 00:00:00 Beijing 22 22 true
22 22 22.22 22.22 char22 22 22
-23 2017-10-01 2017-10-01 00:00:00 Beijing 23 23 true
23 23 23.23 23.23 char23 23 23
-24 2017-10-01 2017-10-01 00:00:00 Beijing 24 24 true
24 24 24.24 24.24 char24 24 24
-25 2017-10-01 2017-10-01 00:00:00 Beijing 25 25 true
25 25 25.25 25.25 char25 25 25
-26 2017-10-01 2017-10-01 00:00:00 Beijing 26 26 true
26 26 26.26 26.26 char26 26 26
-27 2017-10-01 2017-10-01 00:00:00 Beijing 27 27 true
27 27 27.27 27.27 char27 27 27
-28 2017-10-01 2017-10-01 00:00:00 Beijing 28 28 true
28 28 28.28 28.28 char28 28 28
-29 2017-10-01 2017-10-01 00:00:00 Beijing 29 29 true
29 29 29.29 29.29 char29 29 29
-30 2017-10-01 2017-10-01 00:00:00 Beijing 30 30 true
30 30 30.3 30.3 char30 30 30
-31 2017-10-01 2017-10-01 00:00:00 Beijing 31 31 true
31 31 31.31 31.31 char31 31 31
-32 2017-10-01 2017-10-01 00:00:00 Beijing 32 32 true
32 32 32.32 32.32 char32 32 32
-33 2017-10-01 2017-10-01 00:00:00 Beijing 33 33 true
33 33 33.33 33.33 char33 33 33
-34 2017-10-01 2017-10-01 00:00:00 Beijing 34 34 true
34 34 34.34 34.34 char34 34 34
-35 2017-10-01 2017-10-01 00:00:00 Beijing 35 35 true
35 35 35.35 35.35 char35 35 35
-36 2017-10-01 2017-10-01 00:00:00 Beijing 36 36 true
36 36 36.36 36.36 char36 36 36
-37 2017-10-01 2017-10-01 00:00:00 Beijing 37 37 true
37 37 37.37 37.37 char37 37 37
-38 2017-10-01 2017-10-01 00:00:00 Beijing 38 38 true
38 38 38.38 38.38 char38 38 38
-39 2017-10-01 2017-10-01 00:00:00 Beijing 39 39 true
39 39 39.39 39.39 char39 39 39
-40 2017-10-01 2017-10-01 00:00:00 Beijing 40 40 true
40 40 40.4 40.4 char40 40 40
-41 2017-10-01 2017-10-01 00:00:00 Beijing 41 41 true
41 41 41.41 41.41 char41 41 41
-42 2017-10-01 2017-10-01 00:00:00 Beijing 42 42 true
42 42 42.42 42.42 char42 42 42
-43 2017-10-01 2017-10-01 00:00:00 Beijing 43 43 true
43 43 43.43 43.43 char43 43 43
-44 2017-10-01 2017-10-01 00:00:00 Beijing 44 44 true
44 44 44.44 44.44 char44 44 44
-45 2017-10-01 2017-10-01 00:00:00 Beijing 45 45 true
45 45 45.45 45.45 char45 45 45
-46 2017-10-01 2017-10-01 00:00:00 Beijing 46 46 true
46 46 46.46 46.46 char46 46 46
-47 2017-10-01 2017-10-01 00:00:00 Beijing 47 47 true
47 47 47.47 47.47 char47 47 47
-48 2017-10-01 2017-10-01 00:00:00 Beijing 48 48 true
48 48 48.48 48.48 char48 48 48
-49 2017-10-01 2017-10-01 00:00:00 Beijing 49 49 true
49 49 49.49 49.49 char49 49 49
-50 2017-10-01 2017-10-01 00:00:00 Beijing 50 50 true
50 50 50.5 50.5 char50 50 50
-51 2017-10-01 2017-10-01 00:00:00 Beijing 51 51 true
51 51 51.51 51.51 char51 51 51
-52 2017-10-01 2017-10-01 00:00:00 Beijing 52 52 true
52 52 52.52 52.52 char52 52 52
-53 2017-10-01 2017-10-01 00:00:00 Beijing 53 53 true
53 53 53.53 53.53 char53 53 53
-54 2017-10-01 2017-10-01 00:00:00 Beijing 54 54 true
54 54 54.54 54.54 char54 54 54
-55 2017-10-01 2017-10-01 00:00:00 Beijing 55 55 true
55 55 55.55 55.55 char55 55 55
-56 2017-10-01 2017-10-01 00:00:00 Beijing 56 56 true
56 56 56.56 56.56 char56 56 56
-57 2017-10-01 2017-10-01 00:00:00 Beijing 57 57 true
57 57 57.57 57.57 char57 57 57
-58 2017-10-01 2017-10-01 00:00:00 Beijing 58 58 true
58 58 58.58 58.58 char58 58 58
-59 2017-10-01 2017-10-01 00:00:00 Beijing 59 59 true
59 59 59.59 59.59 char59 59 59
-60 2017-10-01 2017-10-01 00:00:00 Beijing 60 60 true
60 60 60.6 60.6 char60 60 60
-61 2017-10-01 2017-10-01 00:00:00 Beijing 61 61 true
61 61 61.61 61.61 char61 61 61
-62 2017-10-01 2017-10-01 00:00:00 Beijing 62 62 true
62 62 62.62 62.62 char62 62 62
-63 2017-10-01 2017-10-01 00:00:00 Beijing 63 63 true
63 63 63.63 63.63 char63 63 63
-64 2017-10-01 2017-10-01 00:00:00 Beijing 64 64 true
64 64 64.64 64.64 char64 64 64
-65 2017-10-01 2017-10-01 00:00:00 Beijing 65 65 true
65 65 65.65 65.65 char65 65 65
-66 2017-10-01 2017-10-01 00:00:00 Beijing 66 66 true
66 66 66.66 66.66 char66 66 66
-67 2017-10-01 2017-10-01 00:00:00 Beijing 67 67 true
67 67 67.67 67.67 char67 67 67
-68 2017-10-01 2017-10-01 00:00:00 Beijing 68 68 true
68 68 68.68 68.68 char68 68 68
-69 2017-10-01 2017-10-01 00:00:00 Beijing 69 69 true
69 69 69.69 69.69 char69 69 69
-
diff --git a/regression-test/suites/export_p0/export/test_show_export.groovy
b/regression-test/suites/export_p0/export/test_show_export.groovy
deleted file mode 100644
index 51e186dcb6e..00000000000
--- a/regression-test/suites/export_p0/export/test_show_export.groovy
+++ /dev/null
@@ -1,228 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-import org.codehaus.groovy.runtime.IOGroovyMethods
-
-import java.nio.charset.StandardCharsets
-import java.nio.file.Files
-import java.nio.file.Paths
-
-suite("test_show_export", "p0") {
- // open nereids
- sql """ set enable_nereids_planner=true """
- sql """ set enable_fallback_to_original_planner=false """
-
-
- String ak = getS3AK()
- String sk = getS3SK()
- String s3_endpoint = getS3Endpoint()
- String region = getS3Region()
- String bucket = context.config.otherConfigs.get("s3BucketName");
-
-
- def thisDb = "regression_test_export_p0_export"
- def table_export_name = "test_show_export"
- def table_load_name = "test_show_export_load_back"
- def outfile_path_prefix = """${bucket}/export/test_show_export/exp_"""
-
- // create table and insert
- sql """ DROP TABLE IF EXISTS ${table_export_name} """
- sql """
- CREATE TABLE IF NOT EXISTS ${table_export_name} (
- `user_id` INT NOT NULL COMMENT "用户id",
- `date` DATE NOT NULL COMMENT "数据灌入日期时间",
- `datetime` DATETIME NOT NULL COMMENT "数据灌入日期时间",
- `city` VARCHAR(20) COMMENT "用户所在城市",
- `age` SMALLINT COMMENT "用户年龄",
- `sex` TINYINT COMMENT "用户性别",
- `bool_col` boolean COMMENT "",
- `int_col` int COMMENT "",
- `bigint_col` bigint COMMENT "",
- `largeint_col` largeint COMMENT "",
- `float_col` float COMMENT "",
- `double_col` double COMMENT "",
- `char_col` CHAR(10) COMMENT "",
- `decimal_col` decimal COMMENT ""
- )
- DISTRIBUTED BY HASH(user_id) PROPERTIES("replication_num" = "1");
- """
- StringBuilder sb = new StringBuilder()
- int i = 1
- for (; i < 100; i ++) {
- sb.append("""
- (${i}, '2017-10-01', '2017-10-01 00:00:00', 'Beijing', ${i}, ${i %
128}, true, ${i}, ${i}, ${i}, ${i}.${i}, ${i}.${i}, 'char${i}', ${i}),
- """)
- }
- sb.append("""
- (${i}, '2017-10-01', '2017-10-01 00:00:00', NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
- """)
- sql """ INSERT INTO ${table_export_name} VALUES
- ${sb.toString()}
- """
- def insert_res = sql "show last insert;"
- logger.info("insert result: " + insert_res.toString())
- order_qt_select_export1 """ SELECT * FROM ${table_export_name} t ORDER BY
user_id; """
-
-
- def waiting_export = { export_label ->
- while (true) {
- def res = sql """ show export where label = "${export_label}";"""
- logger.info("export state: " + res[0][2])
- if (res[0][2] == "FINISHED") {
- def json = parseJson(res[0][11])
- assert json instanceof List
- assertEquals("1", json.fileNumber[0][0])
- log.info("outfile_path: ${json.url[0][0]}")
- return json.url[0][0];
- } else if (res[0][2] == "CANCELLED") {
- throw new IllegalStateException("""export failed:
${res[0][10]}""")
- } else {
- sleep(5000)
- }
- }
- }
-
- // 1. exec export
- def uuid = UUID.randomUUID().toString()
- def outFilePath = """${outfile_path_prefix}_${uuid}"""
- def label = "label_${uuid}"
- try {
- // exec export
- sql """
- EXPORT TABLE ${table_export_name} TO "s3://${outFilePath}/"
- PROPERTIES(
- "label" = "${label}",
- "format" = "parquet",
- 'columns' = 'user_id, date, datetime, city, age, sex,
bool_col, int_col, bigint_col, float_col, double_col, char_col, decimal_col,
largeint_col'
- )
- WITH S3(
- "s3.endpoint" = "${s3_endpoint}",
- "s3.region" = "${region}",
- "s3.secret_key"="${sk}",
- "s3.access_key" = "${ak}"
- );
- """
- def outfile_url = waiting_export.call(label)
-
- order_qt_select_load1 """ select * from s3(
- "uri" =
"http://${s3_endpoint}${outfile_url.substring(4)}0.parquet",
- "s3.access_key"= "${ak}",
- "s3.secret_key" = "${sk}",
- "format" = "parquet",
- "region" = "${region}"
- ) ORDER BY user_id;
- """
-
- } finally {
- }
-
-
- // 2. exec export
- uuid = UUID.randomUUID().toString()
- outFilePath = """${outfile_path_prefix}_${uuid}"""
- label = "label_${uuid}"
- try {
- // exec export
- sql """
- EXPORT TABLE ${table_export_name} where user_id < 70 and user_id
>= 20 TO "s3://${outFilePath}/"
- PROPERTIES(
- "label" = "${label}",
- "format" = "parquet",
- 'columns' = 'user_id, date, datetime, city, age, sex,
bool_col, int_col, bigint_col, float_col, double_col, char_col, decimal_col,
largeint_col'
- )
- WITH S3(
- "s3.endpoint" = "${s3_endpoint}",
- "s3.region" = "${region}",
- "s3.secret_key"="${sk}",
- "s3.access_key" = "${ak}"
- );
- """
- def outfile_url = waiting_export.call(label)
-
- order_qt_select_load1 """ select * from s3(
- "uri" =
"http://${s3_endpoint}${outfile_url.substring(4)}0.parquet",
- "s3.access_key"= "${ak}",
- "s3.secret_key" = "${sk}",
- "format" = "parquet",
- "region" = "${region}"
- ) ORDER BY user_id;
- """
-
- } finally {
- }
-
- // test show export
- def show_export_res1 = sql_return_maparray "show export;"
- assertEquals(2, show_export_res1.size())
-
- // test: show proc
- def show_proc_jobs = sql_return_maparray """show proc "/jobs";"""
- def dbId = ""
- for (def row : show_proc_jobs) {
- if (row.DbName == "default_cluster:regression_test_export_p0_export") {
- dbId = row.DbId
- break
- }
- }
- // test: show proc "/jobs/${dbId}""
- def show_proc_jobs_DB = sql_return_maparray """show proc
"/jobs/${dbId}";"""
- for (def row : show_proc_jobs) {
- if (row.JobType == "export") {
- assertEquals(2, row.Finished)
- assertEquals(2, row.Total)
- break
- }
- }
- // test: show proc "/jobs/${dbId}/export"
- def show_proc_jobs_dbid = sql_return_maparray """show proc
"/jobs/${dbId}/export";"""
- assertEquals(2, show_proc_jobs_dbid.size())
-
- def show_export_res2 = sql_return_maparray "show export from ${thisDb};"
- assertEquals(2, show_export_res2.size())
-
- def show_export_res3 = sql_return_maparray "show export from ${thisDb}
order by JobId;"
- assertEquals(2, show_export_res3.size())
-
- def show_export_res4 = sql_return_maparray "show export from ${thisDb}
order by JobId, State;"
- assertEquals(2, show_export_res4.size())
-
- def show_export_res5 = sql_return_maparray "show export from ${thisDb}
order by JobId, State limit 1"
- assertEquals(1, show_export_res5.size())
-
- def show_export_res6 = sql_return_maparray "show export from ${thisDb}
order by JobId, State limit 1"
- assertEquals(1, show_export_res6.size())
-
- def jobId = show_export_res6[0].JobId
- def show_export_res7 = sql_return_maparray "show export from ${thisDb}
where Id = ${jobId} order by JobId, State"
- assertEquals(1, show_export_res7.size())
-
- // test where label like
- def show_export_label_like = sql_return_maparray """show export from
${thisDb} where Label like "%${uuid}" """
- def show_export_label_eq = sql_return_maparray """show export from
${thisDb} where Label = "${label}" """
- assertEquals(show_export_label_like[0].JobId,
show_export_label_eq[0].JobId)
-
- def show_export_res8 = sql_return_maparray """show export from ${thisDb}
where STATE = "FINISHED" """
- assertEquals(2, show_export_res8.size())
-
- // test invalid where
- test {
- sql "show export from ${thisDb} where Progress = 100"
- // check exception
- exception """Where clause should looks like below"""
- }
-
-}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
