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/14 07:03:28 UTC
(doris) branch master updated: [test](tvf) append tvf read hive_text file regression case. (#26790)
This is an automated email from the ASF dual-hosted git repository.
morningman 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 a16517a061a [test](tvf) append tvf read hive_text file regression case. (#26790)
a16517a061a is described below
commit a16517a061a2b37133d0bdf0fd09458c063bb22b
Author: daidai <20...@qq.com>
AuthorDate: Tue Nov 14 15:03:19 2023 +0800
[test](tvf) append tvf read hive_text file regression case. (#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 273b61a716d..424aa9dcc29 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