You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2023/11/15 10:05:57 UTC
(doris) branch branch-2.0 updated: [test](tvf) append tvf read hive_text file regression case. (#26790) (#26989)
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 <20...@qq.com>
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: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org