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 7730a9025ea [Fix](Regression-test) add test for tvf (#26322)
7730a9025ea is described below
commit 7730a9025ea5268f20563d72970f60a1298a6d30
Author: Tiewei Fang <43782773+bepppo...@users.noreply.github.com>
AuthorDate: Fri Nov 3 19:07:07 2023 +0800
[Fix](Regression-test) add test for tvf (#26322)
---
.../data/external_table_p0/tvf/test_hdfs_tvf.out | 259 +++++++++++++++++++++
.../external_table_p0/tvf/test_backends_tvf.groovy | 9 +
.../external_table_p0/tvf/test_catalogs_tvf.groovy | 8 +
.../tvf}/test_frontends_disks_tvf.groovy | 9 +
.../tvf/test_frontends_tvf.groovy | 8 +
.../external_table_p0/tvf/test_hdfs_tvf.groovy | 86 +++++++
.../external_table_p0/tvf/test_numbers.groovy | 15 ++
7 files changed, 394 insertions(+)
diff --git a/regression-test/data/external_table_p0/tvf/test_hdfs_tvf.out
b/regression-test/data/external_table_p0/tvf/test_hdfs_tvf.out
index 3b92df238be..98a1324abd7 100644
--- a/regression-test/data/external_table_p0/tvf/test_hdfs_tvf.out
+++ b/regression-test/data/external_table_p0/tvf/test_hdfs_tvf.out
@@ -357,3 +357,262 @@ s_phone TEXT Yes false \N NONE
s_acctbal DECIMAL(12, 2) Yes false \N NONE
s_comment TEXT Yes false \N NONE
+-- !hdfs_compatible --
+0 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+1 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+10 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+100 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+101 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+102 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+103 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+104 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+105 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+106 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+107 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+108 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+109 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+11 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+110 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+111 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+112 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+113 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+114 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+115 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+116 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+117 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+118 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+119 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+12 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+13 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+14 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+15 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+16 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+17 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+18 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+19 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+2 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+20 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+21 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+22 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+23 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+24 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+25 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+26 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+27 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+28 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+29 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+3 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+30 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+31 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+32 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+33 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+34 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+35 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+36 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+37 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+38 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+39 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+4 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+40 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+41 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+42 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+43 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+44 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+45 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+46 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+47 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+48 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+49 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+5 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+50 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+51 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+52 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+53 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+54 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+55 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+56 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+57 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+58 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+59 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+6 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+60 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+61 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+62 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+63 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+64 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+65 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+66 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+67 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+68 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+69 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+7 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+70 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+71 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+72 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+73 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+74 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+75 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+76 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+77 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+78 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+79 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+8 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+80 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+81 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+82 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+83 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+84 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+85 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+86 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+87 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+88 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+89 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+9 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+90 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+91 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+92 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+93 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+94 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+95 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+96 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+97 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+98 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+99 2 3 4 5 6.6 7.7 8.8 abc def
ghiaaaaaa 2020-10-10 2020-10-10 11:12:59
+
+-- !hdfs_csv_schema --
+0 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+1 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+10 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+100 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+101 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+102 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+103 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+104 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+105 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+106 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+107 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+108 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+109 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+11 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+110 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+111 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+112 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+113 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+114 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+115 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+116 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+117 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+118 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+119 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+12 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+13 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+14 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+15 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+16 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+17 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+18 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+19 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+2 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+20 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+21 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+22 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+23 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+24 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+25 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+26 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+27 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+28 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+29 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+3 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+30 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+31 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+32 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+33 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+34 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+35 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+36 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+37 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+38 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+39 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+4 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+40 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+41 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+42 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+43 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+44 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+45 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+46 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+47 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+48 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+49 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+5 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+50 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+51 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+52 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+53 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+54 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+55 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+56 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+57 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+58 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+59 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+6 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+60 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+61 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+62 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+63 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+64 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+65 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+66 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+67 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+68 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+69 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+7 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+70 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+71 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+72 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+73 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+74 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+75 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+76 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+77 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+78 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+79 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+8 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+80 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+81 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+82 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+83 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+84 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+85 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+86 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+87 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+88 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+89 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+9 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+90 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+91 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+92 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+93 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+94 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+95 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+96 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+97 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+98 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+99 2 3 4 5 6.6 7.7 8.80000 abc abc
abc 2020-10-10 2020-10-10T11:12:59
+
+-- !hdfs_desc_csv_schema --
+bigint_col BIGINT Yes false \N NONE
+date_col DATE Yes false \N NONE
+datetime_col DATETIME(3) Yes false \N NONE
+decimal_col DECIMAL(10, 5) Yes false \N NONE
+double_col DOUBLE Yes false \N NONE
+float_col FLOAT Yes false \N NONE
+id INT Yes false \N NONE
+largeint_col LARGEINT Yes false \N NONE
+smallint_col SMALLINT Yes false \N NONE
+string_col TEXT Yes false \N NONE
+string_col TEXT Yes false \N NONE
+string_col TEXT Yes false \N NONE
+tinyint_col TINYINT Yes false \N NONE
+
diff --git
a/regression-test/suites/external_table_p0/tvf/test_backends_tvf.groovy
b/regression-test/suites/external_table_p0/tvf/test_backends_tvf.groovy
index 2f6f774ad85..b06d0868eae 100644
--- a/regression-test/suites/external_table_p0/tvf/test_backends_tvf.groovy
+++ b/regression-test/suites/external_table_p0/tvf/test_backends_tvf.groovy
@@ -58,4 +58,13 @@ suite("test_backends_tvf","p0,external,tvf,external_docker")
{
MaxDiskUsedPct, RemoteUsedCapacity, Tag, ErrMsg, Version, Status
HeartbeatFailureCounter, NodeRole from backends();
"""
+
+
+ // test exception
+ test {
+ sql """ select * from backends("backendId" = "10003"); """
+
+ // check exception
+ exception "backends table-valued-function does not support any params"
+ }
}
diff --git
a/regression-test/suites/external_table_p0/tvf/test_catalogs_tvf.groovy
b/regression-test/suites/external_table_p0/tvf/test_catalogs_tvf.groovy
index aec1a3ccc26..a59953cf567 100644
--- a/regression-test/suites/external_table_p0/tvf/test_catalogs_tvf.groovy
+++ b/regression-test/suites/external_table_p0/tvf/test_catalogs_tvf.groovy
@@ -68,4 +68,12 @@ suite("test_catalogs_tvf","p0,external,tvf,external_docker")
{
qt_create """ select CatalogName,CatalogType,Property,Value from
catalogs() where CatalogName in ("catalog_test_es00","catalog_test_hive00") and
Property="type" order by Value"""
sql """ drop catalog catalog_test_es00 """
+
+ // test exception
+ test {
+ sql """ select * from catalogs("Host" = "127.0.0.1"); """
+
+ // check exception
+ exception "catalogs table-valued-function does not support any params"
+ }
}
diff --git
a/regression-test/suites/correctness_p0/table_valued_function/test_frontends_disks_tvf.groovy
b/regression-test/suites/external_table_p0/tvf/test_frontends_disks_tvf.groovy
similarity index 89%
rename from
regression-test/suites/correctness_p0/table_valued_function/test_frontends_disks_tvf.groovy
rename to
regression-test/suites/external_table_p0/tvf/test_frontends_disks_tvf.groovy
index dae09a9cf6a..0cb28253908 100644
---
a/regression-test/suites/correctness_p0/table_valued_function/test_frontends_disks_tvf.groovy
+++
b/regression-test/suites/external_table_p0/tvf/test_frontends_disks_tvf.groovy
@@ -46,4 +46,13 @@ suite("test_frontends_disks_tvf") {
DirType, Dir, Filesystem, Capacity, Used
Available, UseRate, MountOn from frontends_disks();
"""
+
+ // test exception
+ test {
+ sql """ select * from frontends_disks("Host" = "127.0.0.1"); """
+
+ // check exception
+ exception "frontends_disks table-valued-function does not support any
params"
+ }
+
}
diff --git
a/regression-test/suites/external_table_p0/tvf/test_frontends_tvf.groovy
b/regression-test/suites/external_table_p0/tvf/test_frontends_tvf.groovy
index 3618b80660c..0f0e4450cef 100644
--- a/regression-test/suites/external_table_p0/tvf/test_frontends_tvf.groovy
+++ b/regression-test/suites/external_table_p0/tvf/test_frontends_tvf.groovy
@@ -47,4 +47,12 @@
suite("test_frontends_tvf","p0,external,tvf,external_docker") {
`Join`, Alive, ReplayedJournalId, LastHeartbeat
IsHelper, ErrMsg, Version, CurrentConnected from frontends();
"""
+
+ // test exception
+ test {
+ sql """ select * from frontends("Host" = "127.0.0.1"); """
+
+ // check exception
+ exception "frontends table-valued-function does not support any params"
+ }
}
diff --git a/regression-test/suites/external_table_p0/tvf/test_hdfs_tvf.groovy
b/regression-test/suites/external_table_p0/tvf/test_hdfs_tvf.groovy
index 61c049a0a04..2c2754739a5 100644
--- a/regression-test/suites/external_table_p0/tvf/test_hdfs_tvf.groovy
+++ b/regression-test/suites/external_table_p0/tvf/test_hdfs_tvf.groovy
@@ -246,7 +246,93 @@ suite("test_hdfs_tvf","external,hive,tvf,external_docker")
{
"uri" = "${uri}",
"hadoop.username" = "${hdfsUserName}",
"format" = "${format}"); """
+
+
+ // test hdfs function compatible
+ // because the property `fs.defaultFS` has been delete by pr
https://github.com/apache/doris/pull/24706
+ // we should test the compatible of `fs.defaultFS`
+ uri = "${defaultFS}" +
"/user/doris/preinstalled_data/csv_format_test/all_types.csv"
+ format = "csv"
+ order_qt_hdfs_compatible """ select * from HDFS(
+ "uri" = "${uri}",
+ "fs.defaultFS"= "${defaultFS}",
+ "hadoop.username" = "${hdfsUserName}",
+ "column_separator" = ",",
+ "format" = "${format}") order by c1; """
+
+ // test csv_schema property
+ uri = "${defaultFS}" +
"/user/doris/preinstalled_data/csv_format_test/all_types.csv"
+ format = "csv"
+ order_qt_hdfs_csv_schema """ select * from HDFS(
+ "uri" = "${uri}",
+ "csv_schema" =
"id:int;tinyint_col:tinyint;smallint_col:smallint;bigint_col:bigint;largeint_col:largeint;float_col:float;double_col:double;decimal_col:decimal(10,5);string_col:string;string_col:string;string_col:string;date_col:date;datetime_col:datetime(3)",
+ "hadoop.username" = "${hdfsUserName}",
+ "column_separator" = ",",
+ "format" = "${format}") order by id; """
+
+ order_qt_hdfs_desc_csv_schema """ desc function HDFS(
+ "uri" = "${uri}",
+ "csv_schema" =
"id:int;tinyint_col:tinyint;smallint_col:smallint;bigint_col:bigint;largeint_col:largeint;float_col:float;double_col:double;decimal_col:decimal(10,5);string_col:string;string_col:string;string_col:string;date_col:date;datetime_col:datetime(3)",
+ "hadoop.username" = "${hdfsUserName}",
+ "column_separator" = ",",
+ "format" = "${format}"); """
+
} finally {
}
}
+
+ // test exception
+ test {
+ sql """ select * from HDFS(
+ "uri" = "",
+ "hadoop.username" = "${hdfsUserName}",
+ "column_separator" = ",",
+ "format" = "csv") order by c1;
+ """
+
+ // check exception
+ exception """Properties 'uri' is required"""
+ }
+
+ // test exception
+ test {
+ sql """ select * from HDFS(
+ "uri" = "xx",
+ "hadoop.username" = "${hdfsUserName}",
+ "column_separator" = ",",
+ "format" = "csv") order by c1;
+ """
+
+ // check exception
+ exception """Invalid export path, there is no schema of URI found.
please check your path"""
+ }
+
+ // test exception
+ test {
+ sql """ select * from HDFS(
+ "uri" = "xx",
+ "hadoop.username" = "${hdfsUserName}",
+ "column_separator" = "",
+ "format" = "csv") order by c1;
+ """
+
+ // check exception
+ exception """column_separator can not be empty"""
+ }
+
+
+ // test exception
+ test {
+ sql """ select * from HDFS(
+ "uri" = "xx",
+ "hadoop.username" = "${hdfsUserName}",
+ "line_delimiter" = "",
+ "format" = "csv") order by c1;
+ """
+
+ // check exception
+ exception """line_delimiter can not be empty"""
+ }
+
+
}
diff --git a/regression-test/suites/external_table_p0/tvf/test_numbers.groovy
b/regression-test/suites/external_table_p0/tvf/test_numbers.groovy
index 1262d61acc7..0bad88ecc99 100644
--- a/regression-test/suites/external_table_p0/tvf/test_numbers.groovy
+++ b/regression-test/suites/external_table_p0/tvf/test_numbers.groovy
@@ -123,4 +123,19 @@
// test subquery
order_qt_subquery_1 """ with a as (select number from
numbers("number"="3")) select * from a; """
order_qt_subquery_2 """ select * from (select number from
numbers("number"="3")) a join (select * from (select number from
numbers("number"="1")) a join (select 1) b) b; """
+
+ // test exception
+ test {
+ sql """ select * from numbers('number' = 'abc'); """
+
+ // check exception
+ exception "can not parse `number` param to natural number"
+ }
+
+ test {
+ sql """ select * from numbers(); """
+
+ // check exception
+ exception """can not find `number` param, please specify `number`,
like: numbers("number" = "10")"""
+ }
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
