This is an automated email from the ASF dual-hosted git repository.
morningman 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 432e6c99edf [test](tvf) append tvf read hive_text file regression
case. (#26790) (#26989)
432e6c99edf is described below
commit 432e6c99edf51f19b57d7e3d41d44e619df2b20a
Author: daidai <[email protected]>
AuthorDate: Wed Nov 15 18:05:46 2023 +0800
[test](tvf) append tvf read hive_text file regression case. (#26790)
(#26989)
backport #26790
---
.../data/external_table_p0/tvf/test_s3_tvf.out | 41 ++++++++++++++++
.../external_table_p0/tvf/test_s3_tvf.groovy | 56 ++++++++++++++++++++++
2 files changed, 97 insertions(+)
diff --git a/regression-test/data/external_table_p0/tvf/test_s3_tvf.out
b/regression-test/data/external_table_p0/tvf/test_s3_tvf.out
index 3128c590bc8..e7ed7f6af85 100644
--- a/regression-test/data/external_table_p0/tvf/test_s3_tvf.out
+++ b/regression-test/data/external_table_p0/tvf/test_s3_tvf.out
@@ -27,3 +27,44 @@
4 doris4 \N
5 doris5 15
+-- !select_4 --
+12 abcdef 1.23
+12313 kkkkkk 5.77
+123456 abcdef 1.2
+126 abcdef 1.25
+13 abcdef 1.24
+156 ahef 1.26
+323456 oooodef 1.27
+5456 abadsasf 1.28
+723456 text 1.3
+823456 hive 1.32
+923456 helloworld 1.89
+
+-- !select_5 --
+12 abcdef 1.23
+12313 kkkkkk 5.77
+123456 abcdef 1.2
+126 abcdef 1.25
+13 abcdef 1.24
+156 ahef 1.26
+323456 oooodef 1.27
+5456 abadsasf 1.28
+723456 text 1.3
+823456 hive 1.32
+923456 helloworld 1.89
+
+-- !select_6 --
+12313 kkkkkk 5.77
+923456 helloworld 1.89
+
+-- !select_7 --
+12313 kkkkkk 5.77
+123456 abcdef 1.2
+126 abcdef 1.25
+156 ahef 1.26
+323456 oooodef 1.27
+5456 abadsasf 1.28
+723456 text 1.3
+823456 hive 1.32
+923456 helloworld 1.89
+
diff --git a/regression-test/suites/external_table_p0/tvf/test_s3_tvf.groovy
b/regression-test/suites/external_table_p0/tvf/test_s3_tvf.groovy
index 0a4110d0472..546e5a1ac06 100644
--- a/regression-test/suites/external_table_p0/tvf/test_s3_tvf.groovy
+++ b/regression-test/suites/external_table_p0/tvf/test_s3_tvf.groovy
@@ -117,4 +117,60 @@ suite("test_s3_tvf", "p0") {
"""
} finally {
}
+
+ try {
+ order_qt_select_4 """ SELECT * FROM S3 (
+ "uri" =
"https://${bucket}.${s3_endpoint}/regression/tvf/test_hive_text.text";,
+ "s3.access_key"= "${ak}",
+ "s3.secret_key" = "${sk}",
+ "format" = "hive_text",
+ "use_path_style" = "true",
+ "region" = "${region}"
+ ) order by c1,c2,c3;
+ """
+ } finally {
+ }
+
+ try {
+ order_qt_select_5 """ SELECT * FROM S3 (
+ "uri" =
"https://${bucket}.${s3_endpoint}/regression/tvf/test_hive_text.text";,
+ "s3.access_key"= "${ak}",
+ "s3.secret_key" = "${sk}",
+ "format" = "hive_text",
+ "use_path_style" = "true",
+ "region" = "${region}",
+ "csv_schema"="k1:int;k2:string;k3:double"
+ ) order by k1,k2,k3;
+ """
+ } finally {
+ }
+
+ try {
+ order_qt_select_6 """ SELECT * FROM S3 (
+ "uri" =
"https://${bucket}.${s3_endpoint}/regression/tvf/test_hive_text.text";,
+ "s3.access_key"= "${ak}",
+ "s3.secret_key" = "${sk}",
+ "format" = "hive_text",
+ "use_path_style" = "true",
+ "region" = "${region}",
+ "csv_schema"="k1:int;k2:string;k3:double"
+ ) where k3 > 1.5 order by k3,k2,k1;
+ """
+ } finally {
+ }
+
+ try {
+ order_qt_select_7 """ SELECT * FROM S3 (
+ "uri" =
"https://${bucket}.${s3_endpoint}/regression/tvf/test_hive_text.text";,
+ "s3.access_key"= "${ak}",
+ "s3.secret_key" = "${sk}",
+ "format" = "hive_text",
+ "use_path_style" = "true",
+ "region" = "${region}",
+ "csv_schema"="k1:int;k2:string;k3:double"
+ ) where k1 > 100 order by k3,k2,k1;
+ """
+ } finally {
+ }
+
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
