This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new 7b94cfdba16 Revert "[Fix](tests) add regression tests for
trino-connector (#32552)"
7b94cfdba16 is described below
commit 7b94cfdba16172fef8fd277e7b37810623e85233
Author: yiguolei <yiguo...@gmail.com>
AuthorDate: Mon Mar 25 22:38:21 2024 +0800
Revert "[Fix](tests) add regression tests for trino-connector (#32552)"
This reverts commit 3fc3a4650681cb519405730899a2f22f268b38c1.
---
be/src/runtime/descriptors.cpp | 14 -
be/src/runtime/descriptors.h | 9 -
.../trino_connector/hive/test_trino_hive_orc.out | 155 -----
.../trino_connector/hive/test_trino_hive_other.out | 691 ---------------------
regression-test/pipeline/external/conf/be.conf | 2 -
regression-test/pipeline/external/conf/fe.conf | 2 -
.../pipeline/external/conf/regression-conf.groovy | 2 -
regression-test/pipeline/p0/conf/be.conf | 2 -
.../pipeline/p0/conf/regression-conf.groovy | 1 -
.../hive/test_trino_hive_orc.groovy | 164 -----
.../hive/test_trino_hive_other.groovy | 150 -----
.../trino_connector/test_plugins_download.groovy | 63 --
12 files changed, 1255 deletions(-)
diff --git a/be/src/runtime/descriptors.cpp b/be/src/runtime/descriptors.cpp
index 0fb43631916..e7056dd6001 100644
--- a/be/src/runtime/descriptors.cpp
+++ b/be/src/runtime/descriptors.cpp
@@ -211,17 +211,6 @@ std::string MaxComputeTableDescriptor::debug_string()
const {
return out.str();
}
-TrinoConnectorTableDescriptor::TrinoConnectorTableDescriptor(const
TTableDescriptor& tdesc)
- : TableDescriptor(tdesc) {}
-
-TrinoConnectorTableDescriptor::~TrinoConnectorTableDescriptor() = default;
-
-std::string TrinoConnectorTableDescriptor::debug_string() const {
- std::stringstream out;
- out << "TrinoConnectorTable(" << TableDescriptor::debug_string() << ")";
- return out.str();
-}
-
EsTableDescriptor::EsTableDescriptor(const TTableDescriptor& tdesc) :
TableDescriptor(tdesc) {}
EsTableDescriptor::~EsTableDescriptor() = default;
@@ -628,9 +617,6 @@ Status DescriptorTbl::create(ObjectPool* pool, const
TDescriptorTable& thrift_tb
case TTableType::MAX_COMPUTE_TABLE:
desc = pool->add(new MaxComputeTableDescriptor(tdesc));
break;
- case TTableType::TRINO_CONNECTOR_TABLE:
- desc = pool->add(new TrinoConnectorTableDescriptor(tdesc));
- break;
default:
DCHECK(false) << "invalid table type: " << tdesc.tableType;
}
diff --git a/be/src/runtime/descriptors.h b/be/src/runtime/descriptors.h
index 6f9e19492bd..fff1ed339d5 100644
--- a/be/src/runtime/descriptors.h
+++ b/be/src/runtime/descriptors.h
@@ -255,15 +255,6 @@ private:
std::string _public_access;
};
-class TrinoConnectorTableDescriptor : public TableDescriptor {
-public:
- TrinoConnectorTableDescriptor(const TTableDescriptor& tdesc);
- ~TrinoConnectorTableDescriptor() override;
- std::string debug_string() const override;
-
-private:
-};
-
class EsTableDescriptor : public TableDescriptor {
public:
EsTableDescriptor(const TTableDescriptor& tdesc);
diff --git
a/regression-test/data/external_table_p0/trino_connector/hive/test_trino_hive_orc.out
b/regression-test/data/external_table_p0/trino_connector/hive/test_trino_hive_orc.out
deleted file mode 100644
index d9568e2d2a4..00000000000
---
a/regression-test/data/external_table_p0/trino_connector/hive/test_trino_hive_orc.out
+++ /dev/null
@@ -1,155 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !select_top50 --
-4 55 999742610 400899305488827731 false 6.5976813E8
7.8723304616937395E17 \N base tennis pit vertical friday
2022-08-19T07:29:58 \N tablets smallint_col 2019-02-07
[7.53124931825377e+17] ["NbSSBtwzpxNSkkwga"] tablets smallint_col
-2 49 999613702 105493714032727452 \N 6.3322381E8
9.8642324410240179E17 Unveil bright recruit participate. Suspect impression
camera mathematical revelation. Fault live2 elbow debt west hydrogen current.
how literary 2022-09-03T17:20:21 481707.1065 tablets boolean_col
2020-01-12 [] ["HoMrAnn", "wteEFvIwoZsVpVQdscMb", null, "zcGFmv",
"kGEBBckbMtX", "hrEtCGFdPWZK"] tablets boolean_col
-5 95 998979717 575009259015135910 \N 9.0493901E8
5.4512431766617229E17 Authority assassination annoy skiing. Pleased employ
broad crime fortunate punish apartment. \N \N 453810.9551
desktops bigint_col 2013-03-17 [5.5663403615529414e+17,
6.333050523334227e+16, 3.1009537653752474e+17] ["VDwZhzTah", "AEGcQbFCNyemU",
null, "UfYoRU", "lRNGmphqUUwsVQYVGU", "mVdEZ", "LSzhkkcrAmQxP", "BslhNs"]
desktops bigint_col
-8 99 998719010 603880418542146480 false 2.72213472E8
7.0963347087235728E16 Revival lifelong crawl purpose. Regulator scary elbow.
Economist mine league bone launch. subtle gym farm interval included
2022-09-03T02:00:12 671308.8364 phones tinyint_col 2020-01-18
[] ["irMZIDUiOq", null, "IuDJPPTIGDMdQ", null, "XmxFGOWLc", "ULHMLLulC",
"vqXhvfdFH"] phones tinyint_col
-1 10 998617581 754459379266079664 false 5.08661376E8
3.2850645569567008E17 Born fundraising sharp cult isolated race. Pension1
used opponent edition trustee. \N 2022-08-30T19:28:59 733652.7631
tablets bigint_col 2019-07-11 [3.5693025295728045e+17,
7.171410359014723e+17] ["lEWHB", "nrjkSFzMMSBPLwiT"] tablets bigint_col
-8 32 998442612 636848138056884948 true 9.56856E8
1.3031709761648916E16 Distribute sunday beneath especially crystal mentor.
Enterprise unemployed snow depression green. Sweet screening and habit limited
report. thank issue assassination fork 2022-08-15T21:04:19 170099.5226
desktops float_col 2022-08-14 [662084635579153.1,
9.520250842502856e+17, 6.854787479606774e+17, 2009792464461647,
7.013004456853725e+17] ["vjEpySFbMUMyag", "BZTPdpKLiAbk", "LeRAXjdsgLa",
"ftuYwfHsqPNXpgyTHo", "XzCIkxlu [...]
-1 48 997001325 732069608470626517 \N 5.9623251E8
8.3877805956411546E17 Costume rock extensive wooden placement play. Neutral
roof domain entertainment unveil someone. Beside correctly gallon. Classify
meditation jail complaint please abolish. massive convincing entity
precisely invade 2022-08-26T09:42:16 979252.0764 desktops
float_col 2015-12-06 [8.936408231550495e+17] \N desktops
float_col
-4 58 996952097 768862777706807153 false 3.49622816E8
6.074364826499328E17 Strategy steam branch confer. Outsider radiation click
boot season beach communicate. allegedly evil lovely 2022-08-22T08:11:40
554241.1621 tablets float_col \N [] ["rlYNubjGewb",
"GlibPXItkVXfCqHIzfF", "ifmwTRnYxOiIy", "oVZTvGtkfiCbjh", "HztHxOXyIl"] tablets
float_col
-1 81 996555483 420927942708721583 false 9.0464557E8
5.83945915640288E17 Flood appreciation offering diary. Cake comment
celebrity processor boy recommend. training solidarity similarity
2022-08-10T04:45:43 988855.7929 desktops boolean_col
2018-08-26 [8.14988510525504e+17] ["ZFEqYVLAUjEczpPn", "NVTIw",
"wCnYBqSTiuFozOmxfafI", null] desktops boolean_col
-3 60 995559445 496640756596372260 true 7.7654016E8
8.2488184598939226E17 Opinion soccer regulation sum firm prejudice. Largely
strong educated organize stand. authentic efficiently shake predator \N
719156.1038 phones float_col 2018-12-03
[3.037015494037334e+17, 7.105860014659109e+17, 5.523870697300384e+17,
4.6299085569885766e+17, 6.700151453910924e+17] ["knnkRrThAETWlKDtn", null,
"bhWydMwoQuqgWFyqia", "LmXUNZpGhIOYBZQgz", "DPhGDqtqAHDFJlmCbLAn", "yFghgTlk",
null] phones float_col
-3 \N 995548120 623416117915767990 false 2.83810944E8
8.5693376228360768E17 Library partly argument evaluation pace breast.
Criminal thereafter dense educator arms. \N 2022-09-05T15:00:05
189213.3634 desktops float_col 2021-01-13
[8.13564051647795e+17] [] desktops float_col
-1 67 995547119 39850937084984262 false 2.86086336E8
\N Lane decide illegal banana chamber. Capital pressure medal. gap
investigate instruct can2 2022-09-01T02:09:15 719982.8368 tablets
tinyint_col 2022-07-20 [4.7556700332533555e+17,
3.6441248240169235e+17, 6.92717278190866e+17, 8.506803196924362e+17,
3.8655969043505446e+17] ["rwPIlzMLGzVxezOzg", "CLUplJ", "thXF", "tNPD",
"qxtAZcbONyrVdtSVshf", "mgjKvIBHPTOkpx", "rKrnVxk", "FYbrxCQUGO"] tablets
tinyint_col
-7 55 995328433 676410314096484340 \N 8.2933288E7
5.4213585819745126E17 Comfort allegedly noble equation. Philosophy improve
divide dancer breakdown. clause flee log machine number 2022-09-03T20:36:17
148885.7960 desktops boolean_col 2015-06-25
[7.922908725798776e+17, 8.270365083337956e+17] ["VEAAL", "tMWGSZkSwjzL",
"rBaICQpyFqiEKYAJP", "JIHiNfWZEOZbaijWcoz", "HXUZXapTct", "jUcqSS",
"DWgSFfuDoYvbb"] desktops boolean_col
-8 97 995168790 329139323170285912 true 4.191344E8
2.460622878030516E16 Gift discovery yesterday weather condemn damage. Realm
consume robbery december surprised plan league. Smoking useful viewer delicate
methodology gathering pair. Regardless throughout how port. Pencil swallow
valuable logical adopt maybe statistic. murder rebel such ear front
2022-08-31T18:00:52 \N tablets float_col \N
[5.032260263074834e+17] ["xKlRXvLcsdgEiYEHf"] tablets float_col
-2 37 994976337 64458235379408511 true 2.78464512E8
\N Cost span my garden unity resign. Carve last1 anything brutal
programming whereas plain. Contact plain website language odds drain deadly.
Evening newsletter steel elsewhere long-standing figure methodology. \N
2022-08-16T08:01:21 178924.0501 tablets float_col 2021-12-14
[6.736624459061953e+17, 8.559110717177496e+17, 6.812116691231517e+17]
["OsqHo", "FSsynpWBSaEFQQt", "LNYBxPkA", "mqCnnbNiAUCutU",
"XprhHSwYvKvlmZaQfIgO", "GtHgElaIdmLL [...]
-7 41 994723799 663343287411312115 true 9.9466253E8
4.8859864838042835E17 Regardless old-fashioned penny congregation. Access
palace drain credit neck. Receive middle teens reason number. Check dollar
lung. yet relax \N 371344.1451 desktops int_col
2022-06-19 [5.356923608461192e+17, 9.503022354445399e+17,
3.771872400939907e+17, 1.1026878203904256e+17] ["KCfZsewMFUVBvJZKscU",
"ztIJBHMAA", "hfLz", null, "MSEomldskPu", "pwCR", null, "CwIfrZdWp"]
desktops int_col
-8 82 994639378 \N \N \N \N \N
moreover class 2022-08-26T00:16:25 855610.6494 tablets boolean_col
2015-09-08 [] [null, "LVlPuTu", "BJRcLDsjyPBgiM", "tYXgzGMr",
"mafPcmX", "gXsGcqhqIH", "szFDxBGcvML", "UwVJugQgKURgYchUDx"] tablets
boolean_col
-\N \N 994534648 275056213033724461 false 8.8335142E8
3.9353102442374336E16 Bishop different used. Globalization trio absolute
people smell. arrive access 2022-09-02T08:42:57 252619.5125
desktops boolean_col 2018-10-03 [4.970631327310606e+17,
6.204144468411004e+17, 7.947942835735621e+17, 3.304526942408068e+17,
3.0402739456761965e+17] ["QWm", "MXYZizChOLneBymZSGou", "LqNwFXvZ",
"YKBsSvnhJY", "coUcb", "eLOYYXRSz", "ikWSBjo"] desktops boolean_col
-7 65 994382962 348028031439811917 false 6.8747546E8
4.2382370154214624E17 Many negotiate goodbye have. Associated cruise ban
philosophy reckon inspection. Mature possess treatment mixed. Affordable insert
primary expect rock. Disturb pity accident year cute hatred. consultation
believe 2022-08-07T11:16:09 415339.5028 tablets float_col
2016-08-22 [3.008673467654803e+17, 4.8735516725405146e+17,
9.359653663151608e+17, 9.166381603520818e+17] ["tpiRs", "kKEN",
"wpClDVNjnxwe", "vHGHkxjqXHIpmev [...]
-5 46 994133872 338219472721526956 false 2.59046112E8
7.9466221089006246E17 Disability nevertheless old-fashioned word. Influence
commissioner invent adjust accordance underwear ceiling. Wander comfort disrupt
enquire scholarship breathing reputation. Significant monk dissolve flaw fraud.
\N 2022-08-15T05:28:19 689199.0771 desktops bigint_col
\N [9.007049505667118e+17, 1.7996775601617808e+17,
2.0298765261513864e+16, 180060680264327.75, 2.682574973007382e+17]
["tZIpUDUW", "rrHPe", null, "f [...]
-4 46 993507340 977588954291513457 false 6.9995917E8
1.63251635114689536E17 Heavily decorate profession beloved monster compelling
bedroom. Collective publicity discount copper throat. Analyst constantly
proceedings ultimate advertising. Ambition discovery internal angry dirty
strongly. detention fighting 2022-08-15T00:38:02 817473.6937
phones boolean_col 2021-09-07 [4.946917661433303e+17,
1.3273031316668304e+17, 7.524424042429917e+17, 8.764435473965508e+17]
["LVHOZIzE", "dugMZkZFydCTBh"] [...]
-7 \N 993355824 137993334783196500 \N 1.53571424E8
\N Prosperity printer vitamin equipment vision height twin. Traveller
stereotype circulate personal little cemetery tide. emergency gaming pump
metal slam 2022-08-27T18:50:50 577513.4432 phones bigint_col
2017-02-13 [8.117939047649902e+17, 7.414803779874427e+17,
7938246732863808] ["ErSbGzXmodRzRie", "cHSzuVLhEMAf"] phones
bigint_col
-3 17 993292527 449488952514291370 true 8.0099328E8
8.3623994541438477E17 Isolated coast body. Bridge initiate until
philosophical. factor confuse produce nasty 2022-08-30T06:11:29
560319.8951 desktops int_col 2021-08-10 [7.083063145462272e+17,
7.530386902663574e+17, 5.4587446217583654e+17, 2802338805376948,
6.781150087289848e+17] ["EaUMfRbwPP", "ExFBaRK", null, "duOefOehEXtw",
"OHtYtKEj", "fvgg"] desktops int_col
-2 95 993012822 312372245617770804 true 2.62728E8
9.2371528807596749E17 Passing consultant lecture blast. Let conclude
compelling indirect his. Gear sixteen harbour lost legislature primary
substantially. Aim wear heel coat divert. Enjoyable devise arrest.
formal eight 2022-08-11T12:16:06 842330.4588 desktops
tinyint_col 2021-04-29 [9.83715950101926e+17, 7.529749459101504e+17,
1.31686491596813e+16, 4.803489518329307e+16, 2.1326477477269613e+17] []
desktops tinyint_col
-8 \N 992799913 669369990298511963 true 7.7835168E8
2.85465663177764576E17 Distribute following handle. Arms impress threshold
mild. Export spot connect. Mainstream prosecution fundamental estimate
clinical. Mess ideological advertising museum fish. violence map camping based
2022-08-24T09:18:53 224570.1521 phones bigint_col 2018-05-24
[6.943143080562025e+17, 1.8479449383053016e+16] [null, "sQupQUoYfeq",
"SAkyHKdxXgWZaWac", "dyXYkHocgXXoAh", "TFCuzviyolrwyq", "pKsXHIM"]
phones bigint_col
-9 \N 992668782 326055487254498364 false 5.5347853E8
1.42732445000672288E17 Make-up every apparently addition compute. Long1
official controversy well money devastate lesson. nowadays pass civic
label 2022-08-10T22:14:52 781120.8462 tablets bigint_col
2014-03-07 [] ["nyg"] tablets bigint_col
-9 67 992075287 43139399012470413 true 6.4972723E8
6.0874795006894605E17 Cream feat weekly mystery freedom. Extend absurd beer
sleep athlete project. Enthusiasm unit disorder. Capable whisper hook
communicate. listen tremendous gut 2022-08-11T18:00:29 242771.1208
tablets bigint_col 2014-05-01 [1.4888694889510467e+17,
1.162449687707614e+17, 4.9838309536411174e+17, 9.194486137457747e+17]
["zCWydqSmY", "gzGhWxHbzjvucuRMzq", "GAPMPbYcQIFxS", "hszicJZUzDPUlCWadWtN",
"AOSJfjeJiR", "hfjkZngkLBJx [...]
-7 \N 991827409 911949425639198306 true \N \N
Work revenue chase. Farming suite cut adverse campus. Disposal tune dull
landmark rejection ally. Event grace voluntary acknowledge fit distress.
Delight treasure grocery string evoke born. o’clock sentiment theme drop
2022-08-22T16:00:25 302133.7746 desktops smallint_col
2013-05-05 [] ["TRpHvUaJq", "SnQTsquVURqSDQYctA",
"wyKsKxmeKlbVxpWMQTAw", "cEYG", "cEqMOPrPfg", "PmhostVgjdH", "kFmrCegIrOl",
"XJTNmVfdD", "DZUeOco", "jKKmrbrqnuKheN"] deskto [...]
-3 59 991236722 396070856231408452 true 9.1057043E8
9.979261569945737E17 Rehabilitation percentage pride tender. Benchmark solve
probe crystal architect conflict question. Protocol wipe ancient reference
trail. Exotic traveller identical talented fake load. Entire draw administrator
creation affection. ignorance experience couple crush
2022-09-05T03:28:17 812360.3430 phones tinyint_col 2015-05-13
[6.904385216966372e+17, 1.074495099529511e+17, 9.58145113249252e+17,
1.353462997183208e+17, 5 [...]
-6 54 991074207 887145496628965173 false \N
2.33327143660900224E17 Shake donate therapist scene. Eighteen violence resist
next. Courage sympathy temperature tide kidnap engage. Together estimate hockey
racing mobile. Creative incur feed economic detection greet inherent.
between racist fibre \N \N tablets int_col 2021-11-11
[9.146044424068343e+17, 4.4065851245243014e+17, 2.714994762482793e+17]
["bzrpJOEM", "PsGUTmchpXsszTlPzOaN", "rivXLjIGLuttFR", "dOeeHNOnca", "ZTsPccW",
"zgDNEzdEoTYWJOL [...]
-7 92 990973551 257952123158816158 true 1.24285968E8
7.5205980925500122E17 Lens version fault. Bare estimate live1 journal
demonstrate. Coordinator openly lady without white animation organization.
Drown unhappy basket editorial caution prestigious. treatment music tour ratio
2022-08-15T02:55:27 \N phones bigint_col 2020-06-07
[3.9083767066960326e+17] [] phones bigint_col
-8 13 990055297 264342532771407294 true 9.6825094E8
2.83202945069486848E17 Gang infant consist pull. Pencil aircraft recycle
exceed involve sand diverse. busy exam extremely qualification
2022-08-24T23:20:23 689457.0794 desktops int_col 2020-11-05
[8.774018646671041e+17, 7.369988017539758e+17, 7.289153262294908e+17]
["NNbqHuhMJWqQyJY", "auMcHgSfmcTjPFsWk", "EPLgRynwJtyfbDD", "JXpuIGA",
"hlgBrRXukCJenxEoYnuS", "IHLvsB"] desktops int_col
-3 22 989737678 212691360844244176 false 2.91214592E8
5.5305254019680784E16 Enter line canal typical archive absolutely care. Come
straightforward removal up fix. Weak broad immune lyric publish. Ourselves can2
disabled out permit. Text wedding add being compassion personnel consciousness.
furniture expected conceal duo \N 173936.2991 tablets float_col
2015-10-27 [1.8740700830673674e+17, 8.26144642072196e+17,
7.025435817050907e+17, 7.209072409677582e+17, 8.251378055537222e+17]
["EDAk", "E [...]
-3 33 989556776 861148107399538236 true 8.2829504E8
3.9487522718177128E16 Foot breakfast regular retreat nasty smash other. Self
down high topic practice resignation administrative. steep operate download
framework bean 2022-09-01T14:37:11 \N tablets tinyint_col
2017-09-11 [1.1291426654032322e+17, 1.1282105208845827e+17,
8.610195336847752e+17, 4.4123420285917715e+17, 4.703685500368826e+17]
["TSEojLqfgoUoyYeO", "PmjmvtuoHt", "VYatlwquiRjpqJRiG", "wBWMxkHb", null]
tablets tinyint_col
-3 33 989544553 372415973165915438 false 6.7393088E8
7.7552886519944E17 Kid composer expected rental split end. Emotionally
wonderful counterpart metre. Start division drug gang cope naval supermarket.
Software lean editorial multiple habitat. Side promising gentle her compromise.
tradition badly nurse satellite 2022-08-30T19:31 191555.6732
tablets float_col 2014-07-16 [2.114505290225689e+17,
1.9787310867757923e+17, 2.947838815306637e+17] ["dYaDWpPMCF",
"lOsnKKidKGmJeBdiN", "gCWasnndId", [...]
-4 78 989286745 448462623900311272 true 7.4245421E8
6.2670659738407949E17 Spot sink blame other charge. Cheek have thousand
beautiful. \N 2022-08-15T03:51:42 928095.5454 tablets float_col
2020-02-12 [1.155409471089488e+17, 2.0161022044884957e+17,
7.193497971778424e+17] ["uPmfLkUPP", "AFLoOHT", "pDuBnZAIeiTYNbBOu"] tablets
float_col
-\N \N 988129246 321336188038349244 true 5.05806176E8
\N \N next contemplate compromise 2022-08-20T14:38:27
807203.9008 tablets smallint_col 2013-03-15 [7.473300532087329e+17]
\N tablets smallint_col
-\N 70 987478218 598162529085799203 \N \N
5.977672985795881E17 Occurrence shower double. Interactive duty positive
assess attain circumstance. Regime unhappy genre sheep marketing assert. Flag
persuade district acknowledge regulate encouraging criterion. Voting engage
break multiply. ugly smash 2022-08-10T20:25:03 550275.2557
phones boolean_col 2014-08-20 [7.74535081898372e+17,
1.815794304143369e+17] ["CCWplUlBg", "QWcgjHzWhG", "sWhqlI", "ESGYsWpUCA"]
phones boolean_col
-8 42 987470977 163333247606351459 true 9.1720755E8
5.2763199707000384E17 Pair backing competitor dig. Whenever sketch
programming outlet cease sack standing. Monster response protocol worship
scared. Classical govern female. \N 2022-08-13T23:11:22 829923.8961
tablets tinyint_col 2015-02-02 [5.990977985245774e+17,
7.269291937630604e+17, 3.694134297135498e+17, 5.862745930336576e+17] ["Ilo",
"iyltFdsgVLds", "bNn", "YvENgCixRZVoeWUabk"] tablets tinyint_col
-\N 20 987329394 129268823222240972 false \N
8.6075266796586701E17 Despite bail including. Conventional circumstance fence
story step. Ceremony belt humour reputation. Infrastructure easy toilet my
dollar premise supermarket. Sword mass restaurant yesterday interference spring
exit. mile determination 2022-09-02T01:03:22 604701.7592
tablets boolean_col 2019-01-06 [3.107881041227837e+17,
7.354212731274013e+17] \N tablets boolean_col
-1 79 987289606 840144213771116088 true 2.20893872E8
3.5566725998016077E17 Shore parental powerful. Protection foreign firm
sanction pressure. Current mechanism guilty choose instruction delegation
prepare. Rival sugar kidney hit lab admit proceed. coincidence overall
consideration ingredient 2022-08-20T20:08:01 930874.4553 tablets
int_col 2015-02-07 [6.498773865161129e+17, 4.8237070793227654e+17]
["aOVKyZKSfDIwlYH", "gbNUFCO", "bPEvtAYjXdKXmd"] tablets int_col
-1 46 987241408 868449561086137157 true 5.7386643E8
4.8678626719734816E17 Find careless however invention adoption. Arbitrary
open neglect. Friend embarrassment amid density possess operational qualified.
Angle novel mean. Inflation depth reporting consumption spot poverty.
staff reasonably platform scholar circulate \N 326501.8514
desktops boolean_col 2016-08-28 [2.2132500254258102e+17,
1.6095855062087562e+17, 7.395204232644439e+17, 4.6493367683013286e+17]
["KPKOmTVFMnSbWfx", "YtavgHAkPs [...]
-5 68 987011098 882759368495896161 true 8258863.5
9.1284571965376384E17 \N grace fair hidden trail 2022-08-15T19:05:15
591251.5881 phones tinyint_col 2017-01-08 [3.553412039578169e+17]
["sUBpYeEjXLku", "KoDTVscoRkVO", "qhNYa", "EBXmZ", null, "HCvQtRQRCOzIzjO",
"YnHK", "JAge", "FKlfYoFQzUiZYap"] phones tinyint_col
-8 25 986830519 498867943145833747 false \N
6.8335729823235059E17 Conventional investigate thanks instance rhetoric. Limb
firstly resident fantastic employee tall. transportation absurd warfare
2022-08-09T13:57:55 850871.2292 desktops bigint_col
2017-05-23 [4.226899791754336e+17, 4.709506439908065e+17] ["xNECmu",
"uwyfpikWGfxM", "TVZNMxVfiSXJTWsvZS", "UqXajVrdjqdPzOGz", "RCivZjW",
"vXMVwjkMiO"] desktops bigint_col
-4 12 986812276 518479261183178454 true 1.0965992E7
1.32328604302364368E17 Metaphor brush fraud needle confidence never hook. Test
tent objection connection governance similar born. Threshold superior alarm
aftermath. Poison all laughter. raise cope 2022-08-15T13:41:09
467983.1687 phones int_col \N [6.837595241966916e+17] ["licAlaF"]
phones int_col
-4 72 986681839 966965240896174962 false 3.12841216E8
1.9757531555380768E17 Pack aim rip engage fixture. Broadcast roughly smooth.
Acute establish hurricane architectural correction chairman weather. \N
2022-08-09T05:35:56 753918.3430 phones bigint_col 2015-11-10
[2.253144875372237e+17, 6.893465432640434e+16] ["pPnGKupbrjtZUZMjCB", "ywuw",
"rBhhKpTErtoep", "zswxiCFDXslBJGoG", "VoGkC"] phones bigint_col
-\N 77 986641435 882634950713305211 false 1.8774816E7
7.0741662914685082E17 Guideline religious vice. Ghost excuse county derive.
Glance military panel unveil. Joke lost survival most as. extent gas hint
coordinate 2022-08-08T00:40:09 295070.2219 phones boolean_col
2016-07-14 [8.032186692860812e+17, 7.413723650930266e+17,
1.507311371590714e+17, 7.831349572894866e+17] [] phones boolean_col
-5 72 986349337 86980633188107783 true 6.3851021E8
7.5548400246108992E17 Relation ninety know cloud hate terminal egg. Extreme
ticket detail domain acknowledge complain live1. Dedicated hair escape. email
senator speculate anything swim 2022-08-07T19:11:47 760440.5681
tablets int_col 2015-06-26 [] ["RJGkpBfoNE", "jpQoLfYrI", "gOgkBQUg",
"QBs", "IrHb", "AazarmoPsX", "AAxTPdvLHpP", "JPx"] tablets int_col
-4 71 986333570 88457348565826264 true 3.8514276E7
5.177242499015833E17 Football stumble result taste pleased midst. Mirror
loyal divide. Ultimately injury chip lawyer. Leadership teacher belong. \N
2022-08-26T19:19:31 140717.2626 phones smallint_col 2022-08-22
[] ["PWCCGPfT"] phones smallint_col
-3 21 986131998 683875991736989008 \N 6.0774349E8
\N Weird period none. Assertion coincide college. Subscriber fridge craft.
Poisonous donation ordinary. Explode village debt. split terrify
2022-08-27T01:05:20 390407.1015 tablets tinyint_col 2015-11-04
[6.630172173849485e+17] [null, "lSQFYzUG", "vMVMwfZzpl", "QRFiYUUefBc",
"VdtTHy", "YrPtPPzynqXCCzm", "LfIgQvGimBBzlgn"] tablets tinyint_col
-
--- !count_all --
-desktops bigint_col 188 186 181 193 182 192
180 187 174 180 184 206 206 180 512 936
-desktops boolean_col 192 190 198 194 192 198
187 197 193 194 180 212 212 186 555 932
-desktops float_col 186 189 183 178 188 187
179 186 180 184 186 205 205 188 460 952
-desktops int_col 182 182 182 178 184 171 181
181 175 180 183 200 200 172 465 915
-desktops smallint_col 170 166 177 178 174 181
181 174 166 172 176 195 195 172 508 939
-desktops tinyint_col 191 196 191 184 197 196
191 187 196 198 194 213 213 200 599 964
-phones bigint_col 185 181 176 177 174 180 182
180 173 174 177 196 196 176 535 890
-phones boolean_col 155 160 161 171 166 170 163
168 166 167 160 183 183 164 422 770
-phones float_col 169 169 169 166 172 173 172
166 183 172 180 193 193 177 456 871
-phones int_col 185 193 190 180 188 196 187 186
193 190 194 210 210 182 510 1031
-phones smallint_col 175 167 174 171 172 172 173
172 174 178 178 194 194 175 480 888
-phones tinyint_col 166 162 167 156 167 158 165
163 164 167 165 182 182 156 480 833
-tablets bigint_col 186 188 182 192 178 183
181 191 194 189 188 208 208 187 531 897
-tablets boolean_col 184 181 182 186 182 177
174 183 182 182 182 201 201 182 485 908
-tablets float_col 183 184 177 178 176 181
174 174 179 184 171 196 196 169 514 874
-tablets int_col 178 185 185 172 174 181 183
187 180 182 181 201 201 184 512 931
-tablets smallint_col 180 180 182 182 182 183
175 188 189 181 171 203 203 186 566 927
-tablets tinyint_col 179 182 182 187 183 181
177 183 177 187 183 202 202 186 528 974
-
--- !search_lg_int --
-1
-
--- !search_in_int --
-2
-
--- !search_mix --
-996555483 988855.7929 2018-08-26
-
--- !only_partition_col --
-3600 3600
-
--- !decimals1 --
-1 1.1234 12.123456 123.123456789876 12 1234.123456789
123
-2 1234.1234 123456789123.123456
12345678912345678912345678.123456789876 123456789
123456789123456789.123456780 987654321
-3 1234.0000 123456789123.000000
12345678912345678912345678.000000000000 123456789
123456789123456789.000000000 987654321
-4 0.0000 0.000000 123.123456789876 12 0E-9 123
-5 1.1234 12.123456 0E-12 0 1234.123456789 0
-
--- !decimals2 --
-3 1234.0000 123456789123.000000
12345678912345678912345678.000000000000 123456789
123456789123456789.000000000 987654321
-
--- !decimals3 --
-1 1.1234 12.123456 123.123456789876 12 1234.123456789
123
-2 1234.1234 123456789123.123456
12345678912345678912345678.123456789876 123456789
123456789123456789.123456780 987654321
-
--- !decimals4 --
-4 0.0000 0.000000 123.123456789876 12 0E-9 123
-5 1.1234 12.123456 0E-12 0 1234.123456789 0
-
--- !select_top50 --
-4 55 999742610 400899305488827731 false 6.5976813E8
7.8723304616937395E17 \N base tennis pit vertical friday
2022-08-19T07:29:58 \N tablets smallint_col 2019-02-07
[7.53124931825377e+17] ["NbSSBtwzpxNSkkwga"] tablets smallint_col
-2 49 999613702 105493714032727452 \N 6.3322381E8
9.8642324410240179E17 Unveil bright recruit participate. Suspect impression
camera mathematical revelation. Fault live2 elbow debt west hydrogen current.
how literary 2022-09-03T17:20:21 481707.1065 tablets boolean_col
2020-01-12 [] ["HoMrAnn", "wteEFvIwoZsVpVQdscMb", null, "zcGFmv",
"kGEBBckbMtX", "hrEtCGFdPWZK"] tablets boolean_col
-5 95 998979717 575009259015135910 \N 9.0493901E8
5.4512431766617229E17 Authority assassination annoy skiing. Pleased employ
broad crime fortunate punish apartment. \N \N 453810.9551
desktops bigint_col 2013-03-17 [5.5663403615529414e+17,
6.333050523334227e+16, 3.1009537653752474e+17] ["VDwZhzTah", "AEGcQbFCNyemU",
null, "UfYoRU", "lRNGmphqUUwsVQYVGU", "mVdEZ", "LSzhkkcrAmQxP", "BslhNs"]
desktops bigint_col
-8 99 998719010 603880418542146480 false 2.72213472E8
7.0963347087235728E16 Revival lifelong crawl purpose. Regulator scary elbow.
Economist mine league bone launch. subtle gym farm interval included
2022-09-03T02:00:12 671308.8364 phones tinyint_col 2020-01-18
[] ["irMZIDUiOq", null, "IuDJPPTIGDMdQ", null, "XmxFGOWLc", "ULHMLLulC",
"vqXhvfdFH"] phones tinyint_col
-1 10 998617581 754459379266079664 false 5.08661376E8
3.2850645569567008E17 Born fundraising sharp cult isolated race. Pension1
used opponent edition trustee. \N 2022-08-30T19:28:59 733652.7631
tablets bigint_col 2019-07-11 [3.5693025295728045e+17,
7.171410359014723e+17] ["lEWHB", "nrjkSFzMMSBPLwiT"] tablets bigint_col
-8 32 998442612 636848138056884948 true 9.56856E8
1.3031709761648916E16 Distribute sunday beneath especially crystal mentor.
Enterprise unemployed snow depression green. Sweet screening and habit limited
report. thank issue assassination fork 2022-08-15T21:04:19 170099.5226
desktops float_col 2022-08-14 [662084635579153.1,
9.520250842502856e+17, 6.854787479606774e+17, 2009792464461647,
7.013004456853725e+17] ["vjEpySFbMUMyag", "BZTPdpKLiAbk", "LeRAXjdsgLa",
"ftuYwfHsqPNXpgyTHo", "XzCIkxlu [...]
-1 48 997001325 732069608470626517 \N 5.9623251E8
8.3877805956411546E17 Costume rock extensive wooden placement play. Neutral
roof domain entertainment unveil someone. Beside correctly gallon. Classify
meditation jail complaint please abolish. massive convincing entity
precisely invade 2022-08-26T09:42:16 979252.0764 desktops
float_col 2015-12-06 [8.936408231550495e+17] \N desktops
float_col
-4 58 996952097 768862777706807153 false 3.49622816E8
6.074364826499328E17 Strategy steam branch confer. Outsider radiation click
boot season beach communicate. allegedly evil lovely 2022-08-22T08:11:40
554241.1621 tablets float_col \N [] ["rlYNubjGewb",
"GlibPXItkVXfCqHIzfF", "ifmwTRnYxOiIy", "oVZTvGtkfiCbjh", "HztHxOXyIl"] tablets
float_col
-1 81 996555483 420927942708721583 false 9.0464557E8
5.83945915640288E17 Flood appreciation offering diary. Cake comment
celebrity processor boy recommend. training solidarity similarity
2022-08-10T04:45:43 988855.7929 desktops boolean_col
2018-08-26 [8.14988510525504e+17] ["ZFEqYVLAUjEczpPn", "NVTIw",
"wCnYBqSTiuFozOmxfafI", null] desktops boolean_col
-3 60 995559445 496640756596372260 true 7.7654016E8
8.2488184598939226E17 Opinion soccer regulation sum firm prejudice. Largely
strong educated organize stand. authentic efficiently shake predator \N
719156.1038 phones float_col 2018-12-03
[3.037015494037334e+17, 7.105860014659109e+17, 5.523870697300384e+17,
4.6299085569885766e+17, 6.700151453910924e+17] ["knnkRrThAETWlKDtn", null,
"bhWydMwoQuqgWFyqia", "LmXUNZpGhIOYBZQgz", "DPhGDqtqAHDFJlmCbLAn", "yFghgTlk",
null] phones float_col
-3 \N 995548120 623416117915767990 false 2.83810944E8
8.5693376228360768E17 Library partly argument evaluation pace breast.
Criminal thereafter dense educator arms. \N 2022-09-05T15:00:05
189213.3634 desktops float_col 2021-01-13
[8.13564051647795e+17] [] desktops float_col
-1 67 995547119 39850937084984262 false 2.86086336E8
\N Lane decide illegal banana chamber. Capital pressure medal. gap
investigate instruct can2 2022-09-01T02:09:15 719982.8368 tablets
tinyint_col 2022-07-20 [4.7556700332533555e+17,
3.6441248240169235e+17, 6.92717278190866e+17, 8.506803196924362e+17,
3.8655969043505446e+17] ["rwPIlzMLGzVxezOzg", "CLUplJ", "thXF", "tNPD",
"qxtAZcbONyrVdtSVshf", "mgjKvIBHPTOkpx", "rKrnVxk", "FYbrxCQUGO"] tablets
tinyint_col
-7 55 995328433 676410314096484340 \N 8.2933288E7
5.4213585819745126E17 Comfort allegedly noble equation. Philosophy improve
divide dancer breakdown. clause flee log machine number 2022-09-03T20:36:17
148885.7960 desktops boolean_col 2015-06-25
[7.922908725798776e+17, 8.270365083337956e+17] ["VEAAL", "tMWGSZkSwjzL",
"rBaICQpyFqiEKYAJP", "JIHiNfWZEOZbaijWcoz", "HXUZXapTct", "jUcqSS",
"DWgSFfuDoYvbb"] desktops boolean_col
-8 97 995168790 329139323170285912 true 4.191344E8
2.460622878030516E16 Gift discovery yesterday weather condemn damage. Realm
consume robbery december surprised plan league. Smoking useful viewer delicate
methodology gathering pair. Regardless throughout how port. Pencil swallow
valuable logical adopt maybe statistic. murder rebel such ear front
2022-08-31T18:00:52 \N tablets float_col \N
[5.032260263074834e+17] ["xKlRXvLcsdgEiYEHf"] tablets float_col
-2 37 994976337 64458235379408511 true 2.78464512E8
\N Cost span my garden unity resign. Carve last1 anything brutal
programming whereas plain. Contact plain website language odds drain deadly.
Evening newsletter steel elsewhere long-standing figure methodology. \N
2022-08-16T08:01:21 178924.0501 tablets float_col 2021-12-14
[6.736624459061953e+17, 8.559110717177496e+17, 6.812116691231517e+17]
["OsqHo", "FSsynpWBSaEFQQt", "LNYBxPkA", "mqCnnbNiAUCutU",
"XprhHSwYvKvlmZaQfIgO", "GtHgElaIdmLL [...]
-7 41 994723799 663343287411312115 true 9.9466253E8
4.8859864838042835E17 Regardless old-fashioned penny congregation. Access
palace drain credit neck. Receive middle teens reason number. Check dollar
lung. yet relax \N 371344.1451 desktops int_col
2022-06-19 [5.356923608461192e+17, 9.503022354445399e+17,
3.771872400939907e+17, 1.1026878203904256e+17] ["KCfZsewMFUVBvJZKscU",
"ztIJBHMAA", "hfLz", null, "MSEomldskPu", "pwCR", null, "CwIfrZdWp"]
desktops int_col
-8 82 994639378 \N \N \N \N \N
moreover class 2022-08-26T00:16:25 855610.6494 tablets boolean_col
2015-09-08 [] [null, "LVlPuTu", "BJRcLDsjyPBgiM", "tYXgzGMr",
"mafPcmX", "gXsGcqhqIH", "szFDxBGcvML", "UwVJugQgKURgYchUDx"] tablets
boolean_col
-\N \N 994534648 275056213033724461 false 8.8335142E8
3.9353102442374336E16 Bishop different used. Globalization trio absolute
people smell. arrive access 2022-09-02T08:42:57 252619.5125
desktops boolean_col 2018-10-03 [4.970631327310606e+17,
6.204144468411004e+17, 7.947942835735621e+17, 3.304526942408068e+17,
3.0402739456761965e+17] ["QWm", "MXYZizChOLneBymZSGou", "LqNwFXvZ",
"YKBsSvnhJY", "coUcb", "eLOYYXRSz", "ikWSBjo"] desktops boolean_col
-7 65 994382962 348028031439811917 false 6.8747546E8
4.2382370154214624E17 Many negotiate goodbye have. Associated cruise ban
philosophy reckon inspection. Mature possess treatment mixed. Affordable insert
primary expect rock. Disturb pity accident year cute hatred. consultation
believe 2022-08-07T11:16:09 415339.5028 tablets float_col
2016-08-22 [3.008673467654803e+17, 4.8735516725405146e+17,
9.359653663151608e+17, 9.166381603520818e+17] ["tpiRs", "kKEN",
"wpClDVNjnxwe", "vHGHkxjqXHIpmev [...]
-5 46 994133872 338219472721526956 false 2.59046112E8
7.9466221089006246E17 Disability nevertheless old-fashioned word. Influence
commissioner invent adjust accordance underwear ceiling. Wander comfort disrupt
enquire scholarship breathing reputation. Significant monk dissolve flaw fraud.
\N 2022-08-15T05:28:19 689199.0771 desktops bigint_col
\N [9.007049505667118e+17, 1.7996775601617808e+17,
2.0298765261513864e+16, 180060680264327.75, 2.682574973007382e+17]
["tZIpUDUW", "rrHPe", null, "f [...]
-4 46 993507340 977588954291513457 false 6.9995917E8
1.63251635114689536E17 Heavily decorate profession beloved monster compelling
bedroom. Collective publicity discount copper throat. Analyst constantly
proceedings ultimate advertising. Ambition discovery internal angry dirty
strongly. detention fighting 2022-08-15T00:38:02 817473.6937
phones boolean_col 2021-09-07 [4.946917661433303e+17,
1.3273031316668304e+17, 7.524424042429917e+17, 8.764435473965508e+17]
["LVHOZIzE", "dugMZkZFydCTBh"] [...]
-7 \N 993355824 137993334783196500 \N 1.53571424E8
\N Prosperity printer vitamin equipment vision height twin. Traveller
stereotype circulate personal little cemetery tide. emergency gaming pump
metal slam 2022-08-27T18:50:50 577513.4432 phones bigint_col
2017-02-13 [8.117939047649902e+17, 7.414803779874427e+17,
7938246732863808] ["ErSbGzXmodRzRie", "cHSzuVLhEMAf"] phones
bigint_col
-3 17 993292527 449488952514291370 true 8.0099328E8
8.3623994541438477E17 Isolated coast body. Bridge initiate until
philosophical. factor confuse produce nasty 2022-08-30T06:11:29
560319.8951 desktops int_col 2021-08-10 [7.083063145462272e+17,
7.530386902663574e+17, 5.4587446217583654e+17, 2802338805376948,
6.781150087289848e+17] ["EaUMfRbwPP", "ExFBaRK", null, "duOefOehEXtw",
"OHtYtKEj", "fvgg"] desktops int_col
-2 95 993012822 312372245617770804 true 2.62728E8
9.2371528807596749E17 Passing consultant lecture blast. Let conclude
compelling indirect his. Gear sixteen harbour lost legislature primary
substantially. Aim wear heel coat divert. Enjoyable devise arrest.
formal eight 2022-08-11T12:16:06 842330.4588 desktops
tinyint_col 2021-04-29 [9.83715950101926e+17, 7.529749459101504e+17,
1.31686491596813e+16, 4.803489518329307e+16, 2.1326477477269613e+17] []
desktops tinyint_col
-8 \N 992799913 669369990298511963 true 7.7835168E8
2.85465663177764576E17 Distribute following handle. Arms impress threshold
mild. Export spot connect. Mainstream prosecution fundamental estimate
clinical. Mess ideological advertising museum fish. violence map camping based
2022-08-24T09:18:53 224570.1521 phones bigint_col 2018-05-24
[6.943143080562025e+17, 1.8479449383053016e+16] [null, "sQupQUoYfeq",
"SAkyHKdxXgWZaWac", "dyXYkHocgXXoAh", "TFCuzviyolrwyq", "pKsXHIM"]
phones bigint_col
-9 \N 992668782 326055487254498364 false 5.5347853E8
1.42732445000672288E17 Make-up every apparently addition compute. Long1
official controversy well money devastate lesson. nowadays pass civic
label 2022-08-10T22:14:52 781120.8462 tablets bigint_col
2014-03-07 [] ["nyg"] tablets bigint_col
-9 67 992075287 43139399012470413 true 6.4972723E8
6.0874795006894605E17 Cream feat weekly mystery freedom. Extend absurd beer
sleep athlete project. Enthusiasm unit disorder. Capable whisper hook
communicate. listen tremendous gut 2022-08-11T18:00:29 242771.1208
tablets bigint_col 2014-05-01 [1.4888694889510467e+17,
1.162449687707614e+17, 4.9838309536411174e+17, 9.194486137457747e+17]
["zCWydqSmY", "gzGhWxHbzjvucuRMzq", "GAPMPbYcQIFxS", "hszicJZUzDPUlCWadWtN",
"AOSJfjeJiR", "hfjkZngkLBJx [...]
-7 \N 991827409 911949425639198306 true \N \N
Work revenue chase. Farming suite cut adverse campus. Disposal tune dull
landmark rejection ally. Event grace voluntary acknowledge fit distress.
Delight treasure grocery string evoke born. o’clock sentiment theme drop
2022-08-22T16:00:25 302133.7746 desktops smallint_col
2013-05-05 [] ["TRpHvUaJq", "SnQTsquVURqSDQYctA",
"wyKsKxmeKlbVxpWMQTAw", "cEYG", "cEqMOPrPfg", "PmhostVgjdH", "kFmrCegIrOl",
"XJTNmVfdD", "DZUeOco", "jKKmrbrqnuKheN"] deskto [...]
-3 59 991236722 396070856231408452 true 9.1057043E8
9.979261569945737E17 Rehabilitation percentage pride tender. Benchmark solve
probe crystal architect conflict question. Protocol wipe ancient reference
trail. Exotic traveller identical talented fake load. Entire draw administrator
creation affection. ignorance experience couple crush
2022-09-05T03:28:17 812360.3430 phones tinyint_col 2015-05-13
[6.904385216966372e+17, 1.074495099529511e+17, 9.58145113249252e+17,
1.353462997183208e+17, 5 [...]
-6 54 991074207 887145496628965173 false \N
2.33327143660900224E17 Shake donate therapist scene. Eighteen violence resist
next. Courage sympathy temperature tide kidnap engage. Together estimate hockey
racing mobile. Creative incur feed economic detection greet inherent.
between racist fibre \N \N tablets int_col 2021-11-11
[9.146044424068343e+17, 4.4065851245243014e+17, 2.714994762482793e+17]
["bzrpJOEM", "PsGUTmchpXsszTlPzOaN", "rivXLjIGLuttFR", "dOeeHNOnca", "ZTsPccW",
"zgDNEzdEoTYWJOL [...]
-7 92 990973551 257952123158816158 true 1.24285968E8
7.5205980925500122E17 Lens version fault. Bare estimate live1 journal
demonstrate. Coordinator openly lady without white animation organization.
Drown unhappy basket editorial caution prestigious. treatment music tour ratio
2022-08-15T02:55:27 \N phones bigint_col 2020-06-07
[3.9083767066960326e+17] [] phones bigint_col
-8 13 990055297 264342532771407294 true 9.6825094E8
2.83202945069486848E17 Gang infant consist pull. Pencil aircraft recycle
exceed involve sand diverse. busy exam extremely qualification
2022-08-24T23:20:23 689457.0794 desktops int_col 2020-11-05
[8.774018646671041e+17, 7.369988017539758e+17, 7.289153262294908e+17]
["NNbqHuhMJWqQyJY", "auMcHgSfmcTjPFsWk", "EPLgRynwJtyfbDD", "JXpuIGA",
"hlgBrRXukCJenxEoYnuS", "IHLvsB"] desktops int_col
-3 22 989737678 212691360844244176 false 2.91214592E8
5.5305254019680784E16 Enter line canal typical archive absolutely care. Come
straightforward removal up fix. Weak broad immune lyric publish. Ourselves can2
disabled out permit. Text wedding add being compassion personnel consciousness.
furniture expected conceal duo \N 173936.2991 tablets float_col
2015-10-27 [1.8740700830673674e+17, 8.26144642072196e+17,
7.025435817050907e+17, 7.209072409677582e+17, 8.251378055537222e+17]
["EDAk", "E [...]
-3 33 989556776 861148107399538236 true 8.2829504E8
3.9487522718177128E16 Foot breakfast regular retreat nasty smash other. Self
down high topic practice resignation administrative. steep operate download
framework bean 2022-09-01T14:37:11 \N tablets tinyint_col
2017-09-11 [1.1291426654032322e+17, 1.1282105208845827e+17,
8.610195336847752e+17, 4.4123420285917715e+17, 4.703685500368826e+17]
["TSEojLqfgoUoyYeO", "PmjmvtuoHt", "VYatlwquiRjpqJRiG", "wBWMxkHb", null]
tablets tinyint_col
-3 33 989544553 372415973165915438 false 6.7393088E8
7.7552886519944E17 Kid composer expected rental split end. Emotionally
wonderful counterpart metre. Start division drug gang cope naval supermarket.
Software lean editorial multiple habitat. Side promising gentle her compromise.
tradition badly nurse satellite 2022-08-30T19:31 191555.6732
tablets float_col 2014-07-16 [2.114505290225689e+17,
1.9787310867757923e+17, 2.947838815306637e+17] ["dYaDWpPMCF",
"lOsnKKidKGmJeBdiN", "gCWasnndId", [...]
-4 78 989286745 448462623900311272 true 7.4245421E8
6.2670659738407949E17 Spot sink blame other charge. Cheek have thousand
beautiful. \N 2022-08-15T03:51:42 928095.5454 tablets float_col
2020-02-12 [1.155409471089488e+17, 2.0161022044884957e+17,
7.193497971778424e+17] ["uPmfLkUPP", "AFLoOHT", "pDuBnZAIeiTYNbBOu"] tablets
float_col
-\N \N 988129246 321336188038349244 true 5.05806176E8
\N \N next contemplate compromise 2022-08-20T14:38:27
807203.9008 tablets smallint_col 2013-03-15 [7.473300532087329e+17]
\N tablets smallint_col
-\N 70 987478218 598162529085799203 \N \N
5.977672985795881E17 Occurrence shower double. Interactive duty positive
assess attain circumstance. Regime unhappy genre sheep marketing assert. Flag
persuade district acknowledge regulate encouraging criterion. Voting engage
break multiply. ugly smash 2022-08-10T20:25:03 550275.2557
phones boolean_col 2014-08-20 [7.74535081898372e+17,
1.815794304143369e+17] ["CCWplUlBg", "QWcgjHzWhG", "sWhqlI", "ESGYsWpUCA"]
phones boolean_col
-8 42 987470977 163333247606351459 true 9.1720755E8
5.2763199707000384E17 Pair backing competitor dig. Whenever sketch
programming outlet cease sack standing. Monster response protocol worship
scared. Classical govern female. \N 2022-08-13T23:11:22 829923.8961
tablets tinyint_col 2015-02-02 [5.990977985245774e+17,
7.269291937630604e+17, 3.694134297135498e+17, 5.862745930336576e+17] ["Ilo",
"iyltFdsgVLds", "bNn", "YvENgCixRZVoeWUabk"] tablets tinyint_col
-\N 20 987329394 129268823222240972 false \N
8.6075266796586701E17 Despite bail including. Conventional circumstance fence
story step. Ceremony belt humour reputation. Infrastructure easy toilet my
dollar premise supermarket. Sword mass restaurant yesterday interference spring
exit. mile determination 2022-09-02T01:03:22 604701.7592
tablets boolean_col 2019-01-06 [3.107881041227837e+17,
7.354212731274013e+17] \N tablets boolean_col
-1 79 987289606 840144213771116088 true 2.20893872E8
3.5566725998016077E17 Shore parental powerful. Protection foreign firm
sanction pressure. Current mechanism guilty choose instruction delegation
prepare. Rival sugar kidney hit lab admit proceed. coincidence overall
consideration ingredient 2022-08-20T20:08:01 930874.4553 tablets
int_col 2015-02-07 [6.498773865161129e+17, 4.8237070793227654e+17]
["aOVKyZKSfDIwlYH", "gbNUFCO", "bPEvtAYjXdKXmd"] tablets int_col
-1 46 987241408 868449561086137157 true 5.7386643E8
4.8678626719734816E17 Find careless however invention adoption. Arbitrary
open neglect. Friend embarrassment amid density possess operational qualified.
Angle novel mean. Inflation depth reporting consumption spot poverty.
staff reasonably platform scholar circulate \N 326501.8514
desktops boolean_col 2016-08-28 [2.2132500254258102e+17,
1.6095855062087562e+17, 7.395204232644439e+17, 4.6493367683013286e+17]
["KPKOmTVFMnSbWfx", "YtavgHAkPs [...]
-5 68 987011098 882759368495896161 true 8258863.5
9.1284571965376384E17 \N grace fair hidden trail 2022-08-15T19:05:15
591251.5881 phones tinyint_col 2017-01-08 [3.553412039578169e+17]
["sUBpYeEjXLku", "KoDTVscoRkVO", "qhNYa", "EBXmZ", null, "HCvQtRQRCOzIzjO",
"YnHK", "JAge", "FKlfYoFQzUiZYap"] phones tinyint_col
-8 25 986830519 498867943145833747 false \N
6.8335729823235059E17 Conventional investigate thanks instance rhetoric. Limb
firstly resident fantastic employee tall. transportation absurd warfare
2022-08-09T13:57:55 850871.2292 desktops bigint_col
2017-05-23 [4.226899791754336e+17, 4.709506439908065e+17] ["xNECmu",
"uwyfpikWGfxM", "TVZNMxVfiSXJTWsvZS", "UqXajVrdjqdPzOGz", "RCivZjW",
"vXMVwjkMiO"] desktops bigint_col
-4 12 986812276 518479261183178454 true 1.0965992E7
1.32328604302364368E17 Metaphor brush fraud needle confidence never hook. Test
tent objection connection governance similar born. Threshold superior alarm
aftermath. Poison all laughter. raise cope 2022-08-15T13:41:09
467983.1687 phones int_col \N [6.837595241966916e+17] ["licAlaF"]
phones int_col
-4 72 986681839 966965240896174962 false 3.12841216E8
1.9757531555380768E17 Pack aim rip engage fixture. Broadcast roughly smooth.
Acute establish hurricane architectural correction chairman weather. \N
2022-08-09T05:35:56 753918.3430 phones bigint_col 2015-11-10
[2.253144875372237e+17, 6.893465432640434e+16] ["pPnGKupbrjtZUZMjCB", "ywuw",
"rBhhKpTErtoep", "zswxiCFDXslBJGoG", "VoGkC"] phones bigint_col
-\N 77 986641435 882634950713305211 false 1.8774816E7
7.0741662914685082E17 Guideline religious vice. Ghost excuse county derive.
Glance military panel unveil. Joke lost survival most as. extent gas hint
coordinate 2022-08-08T00:40:09 295070.2219 phones boolean_col
2016-07-14 [8.032186692860812e+17, 7.413723650930266e+17,
1.507311371590714e+17, 7.831349572894866e+17] [] phones boolean_col
-5 72 986349337 86980633188107783 true 6.3851021E8
7.5548400246108992E17 Relation ninety know cloud hate terminal egg. Extreme
ticket detail domain acknowledge complain live1. Dedicated hair escape. email
senator speculate anything swim 2022-08-07T19:11:47 760440.5681
tablets int_col 2015-06-26 [] ["RJGkpBfoNE", "jpQoLfYrI", "gOgkBQUg",
"QBs", "IrHb", "AazarmoPsX", "AAxTPdvLHpP", "JPx"] tablets int_col
-4 71 986333570 88457348565826264 true 3.8514276E7
5.177242499015833E17 Football stumble result taste pleased midst. Mirror
loyal divide. Ultimately injury chip lawyer. Leadership teacher belong. \N
2022-08-26T19:19:31 140717.2626 phones smallint_col 2022-08-22
[] ["PWCCGPfT"] phones smallint_col
-3 21 986131998 683875991736989008 \N 6.0774349E8
\N Weird period none. Assertion coincide college. Subscriber fridge craft.
Poisonous donation ordinary. Explode village debt. split terrify
2022-08-27T01:05:20 390407.1015 tablets tinyint_col 2015-11-04
[6.630172173849485e+17] [null, "lSQFYzUG", "vMVMwfZzpl", "QRFiYUUefBc",
"VdtTHy", "YrPtPPzynqXCCzm", "LfIgQvGimBBzlgn"] tablets tinyint_col
-
diff --git
a/regression-test/data/external_table_p0/trino_connector/hive/test_trino_hive_other.out
b/regression-test/data/external_table_p0/trino_connector/hive/test_trino_hive_other.out
deleted file mode 100644
index 42770a0aa9e..00000000000
---
a/regression-test/data/external_table_p0/trino_connector/hive/test_trino_hive_other.out
+++ /dev/null
@@ -1,691 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q24 --
-zhangsan 1
-lisi 1
-
--- !q25 --
-1 1
-2 1
-3 1
-4 1
-
--- !q26 --
-123 china 4 56 sc
-234 america 5 67 ls
-345 cana 4 56 fy
-567 fre 7 89 pa
-
--- !q27 --
-p_partkey2 p_name2 p_mfgr2 p_brand2 p_type2 p_size2 p_con2
p_r_price2 p_comment2
-p_partkey1 p_name1 p_mfgr1 p_brand1 p_type1 p_size1 p_con1
p_r_price1 p_comment1
-p_partkey0 p_name0 p_mfgr0 p_brand0 p_type0 p_size0 p_con0
p_r_price0 p_comment0
-
--- !q28 --
-batchno appsheet_no filedate t_no tano t_name
chged_no mob_no2 home_no off_no
-off_no home_no mob_no2 chged_no t_name tano t_no filedate
appsheet_no batchno
-
--- !q29 --
-bill_code dates ord_year ord_month ord_quarter on_time
-
--- !q30 --
-2
-
--- !q31 --
-123 zhangsan 12 123.45 2022-01-01
-124 lisi 12 123.45 2022-01-01
-125 lisan 12 123.45 2022-01-02
-
--- !q32 --
-a123 12
-a124 13
-a125 14
-a126 15
-
--- !q33 --
-2022-11-25 zz08Quhrpk zz08Quhrpk m8vknqtybC Eyk5GmwzDJ
eW7R46dTNx 86tM8PWfGQ RU6WOEYEmX eN0Sm0fEjH NwYXON812A
NYzAKjdBVu OQf936VCQv scbCva79DG HAK0HACy2d pbs5ypY6cy
ft54SbxPmW hcVLijY8PL 2022-11-25
-2022-11-25 zvyprEdKlk zvyprEdKlk 6oO1KfWKnS zeNgOLbD5I
o5FEyMNjhJ ACUBOltRRn YJsyP7erIV cZEbgd4Q7J DNzXA9QYKg
wrhu8Heu17 PHerHoPGn0 nSSQLodYNZ zSxZ7eEs1k V4RVLp7h2O
FGlZiPTOkV Yr1zRnrqPE 2022-11-25
-2022-11-25 ztbynIKOAB ztbynIKOAB T0jxzYQdtB sMyKhrS29F
tOKKw4YrnE ND0qk9uKlp f7fMtT4f9A XBKdWFhCc2 0AP0jCcOvc
Be2o2BO7Zf I33L9Tgr7y PG414ZCN0H Wb85Gn6HSE 6Dv3a7gAP1
abfib4AMr1 QX4rLkftjB 2022-11-25
-2022-11-25 zt6cI3WyPZ zt6cI3WyPZ FE3oLtL07b MqkD7rhh9Z
larXyucEGE piaxKcubhh cVUtgHlsly fjumWOXPkM hUNrdq0FYN
tsjzXqGBlN XNVuUkuoxG iyhpIB4SHv PTw9fDpPMm Url7haQqHQ
qWt4vJm87n FScyOLzx8c 2022-11-25
-2022-11-25 zluC6EgPz8 zluC6EgPz8 ufSllWR5MA XIcWrCHYsR
x4TQaY0uON AIRP6WN0PR sJ2hpxX6w4 aA4cNryz5G mAFcXmzyHG
VlVY1J6HSG 3HwdoY0t44 0nCMGUzzew RMsQ4tG9l4 BBKNamSAyP
8kRynkgB2y aqmC8elovV 2022-11-25
-2022-11-25 zjM4h9Jtm2 zjM4h9Jtm2 TgiVg53a5R qUqbrdFemU
0o7oL6FnQw h39e3fhRi2 erJgos6ENS xD8kdyZsIr VJ1GmDyO1F
QVbYI0NQ77 nrYkLCTrgD nQTn0hULEP qSHhNxO9AJ px5lKNCjrE
LyH73bHlJt KZSopyFVMm 2022-11-25
-2022-11-25 zgZ82sWMOE zgZ82sWMOE d3L50SOM47 xtRhjoeVNV
ZEWRyMclGd mE85T2Mg2t exZ7tYRdkr 6U4qNiFxDk VNTnrXhxC7
Rkfbo2rKY7 IoqxH43Iu1 13up4RtCbZ mbJgDA56Ey 9H7UGVuWCn
KvsB4cMCWZ FmICYOQC6Y 2022-11-25
-2022-11-25 zgUDwoe0R0 zgUDwoe0R0 VFqYUAJger Axv5zHQ9Aj
VrZj2oLMHw AFGrr1jQ4T dTaSKfBDyt lx1JgWEnVD Arqdl5tEB0
KSOTAtif2o TYuyIlLcDT 14vUoFChqv NM8pWxCiJL 1yZ7RM8WCs
9lYAarGdHK XsZ9vSH14w 2022-11-25
-2022-11-25 zYco1C1wbA zYco1C1wbA Jg9d1Vz8Nc M0jPS30f17
WRrQGzaqzl wKghuTj9Hf oAbqV68KVL iwT59HVsml X2pfKlSvmV
EtScW6rT7w fgSAM7qInL 7ud6VtTvNq pyP4ZGsJ5O 0mBO3GVgxc
j5ZKwj1MD5 VC7d7CEtco 2022-11-25
-2022-11-25 zUCfrwLP3h zUCfrwLP3h kqwtMmz3PH q1RgmOdoHv
ENU2ipUkUY IviUi4Gmrv R6LXapRkKZ vESQ05cSlQ ICw4lJ4ksT
bv0SQBAllD skdJMJYRKz ozPmYA3bks 3VSTEExqgk O9wf7u00RS
KQcf7rwCg5 K2EMmTiSSz 2022-11-25
-
--- !q34 --
-2022-11-24 zVhHON3m5L
-2022-11-24 zceLX7IpL5
-2022-11-24 zjp4CiDZ8F
-2022-11-24 zpV3iiPrMp
-2022-11-24 zrjCNYBzpb
-2022-11-24 zvbIuF1cg8
-2022-11-24 zyLjAtVdXV
-2022-11-25 zVOQFPxGhP
-2022-11-25 zj9uWRywHa
-2022-11-25 zvs3b72ERY
-
--- !q35 --
-2022-11-24 zyLjAtVdXV
-2022-11-24 zvbIuF1cg8
-2022-11-24 zrjCNYBzpb
-2022-11-24 zpV3iiPrMp
-2022-11-24 zjp4CiDZ8F
-2022-11-24 zceLX7IpL5
-2022-11-24 zVhHON3m5L
-2022-11-24 zTOGIjaaZJ
-2022-11-24 zOeOJwAvfc
-2022-11-24 zNDyH7VSpm
-
--- !q36 --
-zvs3b72ERY zorbigHkYB
-zj9uWRywHa 5F8hzYcY8G
-zVOQFPxGhP V0FTqkqsma
-zJvBmGUvxj oHlH8nOlxp
-zHUd303J4r q000anXrEp
-zGQt4RNefu 7fkTAaRATj
-z5SAncObhE PUl5h9h6iL
-z5AAgk7RGE gSPjanitfl
-z3cvap67Lh 8EfHi4roEB
-ysw8j0x551 IwlRuhywtn
-
--- !q37 --
-2000
-
--- !q38 --
-zvs3b72ERY zorbigHkYB
-zj9uWRywHa 5F8hzYcY8G
-zVOQFPxGhP V0FTqkqsma
-zJvBmGUvxj oHlH8nOlxp
-zHUd303J4r q000anXrEp
-zGQt4RNefu 7fkTAaRATj
-z5SAncObhE PUl5h9h6iL
-z5AAgk7RGE gSPjanitfl
-z3cvap67Lh 8EfHi4roEB
-ysw8j0x551 IwlRuhywtn
-
--- !q39 --
-zyLjAtVdXV GrJRf8WvRR
-zvs3b72ERY zorbigHkYB
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zj9uWRywHa 5F8hzYcY8G
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zVOQFPxGhP V0FTqkqsma
-
--- !q40 --
-2022-11-25 2022-11-25 zvs3b72ERY zorbigHkYB 2022-11-25
-2022-11-25 2022-11-25 zj9uWRywHa 5F8hzYcY8G 2022-11-25
-2022-11-25 2022-11-25 zVOQFPxGhP V0FTqkqsma 2022-11-25
-2022-11-25 2022-11-25 zJvBmGUvxj oHlH8nOlxp 2022-11-25
-2022-11-25 2022-11-25 zHUd303J4r q000anXrEp 2022-11-25
-2022-11-25 2022-11-25 zGQt4RNefu 7fkTAaRATj 2022-11-25
-2022-11-25 2022-11-25 z5SAncObhE PUl5h9h6iL 2022-11-25
-2022-11-25 2022-11-25 z5AAgk7RGE gSPjanitfl 2022-11-25
-2022-11-25 2022-11-25 z3cvap67Lh 8EfHi4roEB 2022-11-25
-2022-11-25 2022-11-25 ysw8j0x551 IwlRuhywtn 2022-11-25
-
--- !q41 --
-
--- !q42 --
-2022-11-24 2022-11-24 zyLjAtVdXV GrJRf8WvRR 2022-11-24
-2022-11-25 2022-11-25 zvs3b72ERY zorbigHkYB 2022-11-25
-2022-11-24 2022-11-24 zvbIuF1cg8 33ZkOc8Fl7 2022-11-24
-2022-11-24 2022-11-24 zrjCNYBzpb FD1Zxm39qk 2022-11-24
-2022-11-24 2022-11-24 zpV3iiPrMp j0XRD1oFXY 2022-11-24
-2022-11-24 2022-11-24 zjp4CiDZ8F ljiRxP16r2 2022-11-24
-2022-11-25 2022-11-25 zj9uWRywHa 5F8hzYcY8G 2022-11-25
-2022-11-24 2022-11-24 zceLX7IpL5 JZtsmIjKGQ 2022-11-24
-2022-11-24 2022-11-24 zVhHON3m5L ecmOZhvo5C 2022-11-24
-2022-11-25 2022-11-25 zVOQFPxGhP V0FTqkqsma 2022-11-25
-
--- !q43 --
-2022-11-10 zzf0Hyy3PP zzf0Hyy3PP kqonrn13oM qMpDJZ3jVG
oQafAQzfpg WprPRT9pxG W6Vfvw6VU3 U2J2db3EcI oa3CXQ51wk
DSfnG13L1h x6pO2DvZXm y6McEKEtPF 6P1xAKaJcI a0WviK01l1
4UxX1EJ4nV FAJyYIGlBN 2022-11-10
-2022-11-10 zwkeNflkF1 zwkeNflkF1 TkWqg6Ix6t Mvg3XCz4KW
xNtobuEiYh 2zfFFtguoD dM0xJvckpt J0KzHbhdQV GzofYnr0OQ
IDej5DPSlV QlzwIZHnDh oTrJx4aX3J Z1fyagW29j giFWZDk1Rd
CMHyNvI6n1 uXoAudfOjF 2022-11-10
-2022-11-10 zw7iBPPTEF zw7iBPPTEF z036dLkobV soKogHEGDn
htmRKThWKo WzPFReXEDF rx1wJaZkHR bGNyBl0jZc 41zilEUfud
fhVJ30rOBV VGgO3KrN3C c9KX0k1gb8 MwR4IXvjCI qrvDKvMD9k
mSqAiJQFEN hVuhJxSlj9 2022-11-10
-2022-11-10 zsLnfKZ51O zsLnfKZ51O wHvRoX5XhH 1lLcmzAVUU
VdRNvndgvg UoqeV9QYiJ pvSwfhZTej rA51Wq2lQN Ljdu8nmKCg
v9EMT2z3mo kKUH8y5N4u XoC9shDIZN GnJ5kOqIU3 ppQBteeHzM
3fn0IUEII1 tnzPWN4kRj 2022-11-10
-2022-11-10 zsEmkJnMdC zsEmkJnMdC Dx6sAB4I7M eCKoLNz9oG
lE3YGayXaN pGOgX608Fz pVo9dletTZ 7XWdPnNlJm seYFng9MgQ
PGD3yh4Wlc PfwzK2ZiuS l8ddKEdG8n AVLIoP9Jha ipjmF2YjKK
qaODuhuFWi AkuaGy0Qqp 2022-11-10
-2022-11-10 zmzCEZlbV5 zmzCEZlbV5 0v2IfWCEIr mdRkZG9LVW
yNR9pzfPna Q7XmH62qSh iYMJPOhApN QuKGOQYa7l XHYEA9oxnq
bU8pbr0KXA vY2O2CSUY6 8NH1vjDoPB SiSpTkuXNc QZOkZ5IjqD
heoOSWTkNX gOU9E6AR3E 2022-11-10
-2022-11-10 zfOtU6uM5Z zfOtU6uM5Z ALpuvTDVnW mjJPYTgWRl
9wPoJuEY4O Fjl0u6YIup i6MJdwoXrc jdEbHX2ciY at0qPGFS9K
BbFvD5pDHn R8j7s2hZHn YYatCMK0Hp R1wiwcfZ7J sgK2ElpSWh
dMjk2u1h2r MkoSLDtORA 2022-11-10
-2022-11-10 zaCKFeMKPl zaCKFeMKPl 2ZTD9DtO1l MHL1vr5tx4
fiE4PbRVGT B0L7bSYqqE HgJcRjMTEb M1Y8ublbIf duEnPcBFIj
N2j62LjxW4 4kaqVUWoPc Fe09FCOcfV chMDNkDdsu rCMCu231Bb
T6QDStOoKf izRqyR2c6v 2022-11-10
-2022-11-10 zYNiE7iX1z zYNiE7iX1z XWoDz1bYcL Bn8QGcPeVi
DJyDWOYpM3 Kv7jHcWKju eSDLJiXt8i 8uiVxsiVBq CtwoNyHZL8
XJeZsXvRzK VeJZUeQuPW UTeKq4u86J G9BRL00Caw qgXkXNw3LN
RFJIwqft7H 73uqYcUHNU 2022-11-10
-2022-11-10 zRZyJdYT6X zRZyJdYT6X r7KeoDNRia erhjhmnbee
8smgVFxgRY 4zsHrL9mmX GdCn844KLZ 6CT2bojzlB P2X7SBkzcy
uBpZ7VtFNj csGSglKMMF hmDxo1NUOg hUwaq7MFvD m8mu7xQZbS
aKhGVtz40x 7OP7GtYURR 2022-11-10
-
--- !q44 --
-2022-11-10 zyLjAtVdXV
-2022-11-10 zvbIuF1cg8
-2022-11-10 zrjCNYBzpb
-2022-11-10 zpV3iiPrMp
-2022-11-10 zjp4CiDZ8F
-2022-11-10 zceLX7IpL5
-2022-11-10 zVhHON3m5L
-2022-11-10 zTOGIjaaZJ
-2022-11-10 zOeOJwAvfc
-2022-11-10 zNDyH7VSpm
-
--- !q45 --
-2022-11-10 zyLjAtVdXV
-2022-11-10 zvbIuF1cg8
-2022-11-10 zrjCNYBzpb
-2022-11-10 zpV3iiPrMp
-2022-11-10 zjp4CiDZ8F
-2022-11-10 zceLX7IpL5
-2022-11-10 zVhHON3m5L
-2022-11-10 zTOGIjaaZJ
-2022-11-10 zOeOJwAvfc
-2022-11-10 zNDyH7VSpm
-
--- !q46 --
-zyLjAtVdXV GrJRf8WvRR
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zTOGIjaaZJ kKS2qRmfG7
-zOeOJwAvfc hQsA8GlyPI
-zNDyH7VSpm x6S8xvWIKO
-
--- !q47 --
-1000
-
--- !q48 --
-
--- !q49 --
-zyLjAtVdXV GrJRf8WvRR
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zTOGIjaaZJ kKS2qRmfG7
-zOeOJwAvfc hQsA8GlyPI
-zNDyH7VSpm x6S8xvWIKO
-
--- !q50 --
-2022-11-10 2022-11-10 zyLjAtVdXV GrJRf8WvRR 2022-11-10
-2022-11-10 2022-11-10 zvbIuF1cg8 33ZkOc8Fl7 2022-11-10
-2022-11-10 2022-11-10 zrjCNYBzpb FD1Zxm39qk 2022-11-10
-2022-11-10 2022-11-10 zpV3iiPrMp j0XRD1oFXY 2022-11-10
-2022-11-10 2022-11-10 zjp4CiDZ8F ljiRxP16r2 2022-11-10
-2022-11-10 2022-11-10 zceLX7IpL5 JZtsmIjKGQ 2022-11-10
-2022-11-10 2022-11-10 zVhHON3m5L ecmOZhvo5C 2022-11-10
-2022-11-10 2022-11-10 zTOGIjaaZJ kKS2qRmfG7 2022-11-10
-2022-11-10 2022-11-10 zOeOJwAvfc hQsA8GlyPI 2022-11-10
-2022-11-10 2022-11-10 zNDyH7VSpm x6S8xvWIKO 2022-11-10
-
--- !q51 --
-china
-america
-cana
-fre
-
--- !q24 --
-zhangsan 1
-lisi 1
-
--- !q25 --
-1 1
-2 1
-3 1
-4 1
-
--- !q26 --
-123 china 4 56 sc
-234 america 5 67 ls
-345 cana 4 56 fy
-567 fre 7 89 pa
-
--- !q27 --
-p_partkey2 p_name2 p_mfgr2 p_brand2 p_type2 p_size2 p_con2
p_r_price2 p_comment2
-p_partkey1 p_name1 p_mfgr1 p_brand1 p_type1 p_size1 p_con1
p_r_price1 p_comment1
-p_partkey0 p_name0 p_mfgr0 p_brand0 p_type0 p_size0 p_con0
p_r_price0 p_comment0
-
--- !q28 --
-batchno appsheet_no filedate t_no tano t_name
chged_no mob_no2 home_no off_no
-off_no home_no mob_no2 chged_no t_name tano t_no filedate
appsheet_no batchno
-
--- !q29 --
-bill_code dates ord_year ord_month ord_quarter on_time
-
--- !q30 --
-2
-
--- !q31 --
-123 zhangsan 12 123.45 2022-01-01
-124 lisi 12 123.45 2022-01-01
-125 lisan 12 123.45 2022-01-02
-
--- !q32 --
-a123 12
-a124 13
-a125 14
-a126 15
-
--- !q33 --
-2022-11-25 zz08Quhrpk zz08Quhrpk m8vknqtybC Eyk5GmwzDJ
eW7R46dTNx 86tM8PWfGQ RU6WOEYEmX eN0Sm0fEjH NwYXON812A
NYzAKjdBVu OQf936VCQv scbCva79DG HAK0HACy2d pbs5ypY6cy
ft54SbxPmW hcVLijY8PL 2022-11-25
-2022-11-25 zvyprEdKlk zvyprEdKlk 6oO1KfWKnS zeNgOLbD5I
o5FEyMNjhJ ACUBOltRRn YJsyP7erIV cZEbgd4Q7J DNzXA9QYKg
wrhu8Heu17 PHerHoPGn0 nSSQLodYNZ zSxZ7eEs1k V4RVLp7h2O
FGlZiPTOkV Yr1zRnrqPE 2022-11-25
-2022-11-25 ztbynIKOAB ztbynIKOAB T0jxzYQdtB sMyKhrS29F
tOKKw4YrnE ND0qk9uKlp f7fMtT4f9A XBKdWFhCc2 0AP0jCcOvc
Be2o2BO7Zf I33L9Tgr7y PG414ZCN0H Wb85Gn6HSE 6Dv3a7gAP1
abfib4AMr1 QX4rLkftjB 2022-11-25
-2022-11-25 zt6cI3WyPZ zt6cI3WyPZ FE3oLtL07b MqkD7rhh9Z
larXyucEGE piaxKcubhh cVUtgHlsly fjumWOXPkM hUNrdq0FYN
tsjzXqGBlN XNVuUkuoxG iyhpIB4SHv PTw9fDpPMm Url7haQqHQ
qWt4vJm87n FScyOLzx8c 2022-11-25
-2022-11-25 zluC6EgPz8 zluC6EgPz8 ufSllWR5MA XIcWrCHYsR
x4TQaY0uON AIRP6WN0PR sJ2hpxX6w4 aA4cNryz5G mAFcXmzyHG
VlVY1J6HSG 3HwdoY0t44 0nCMGUzzew RMsQ4tG9l4 BBKNamSAyP
8kRynkgB2y aqmC8elovV 2022-11-25
-2022-11-25 zjM4h9Jtm2 zjM4h9Jtm2 TgiVg53a5R qUqbrdFemU
0o7oL6FnQw h39e3fhRi2 erJgos6ENS xD8kdyZsIr VJ1GmDyO1F
QVbYI0NQ77 nrYkLCTrgD nQTn0hULEP qSHhNxO9AJ px5lKNCjrE
LyH73bHlJt KZSopyFVMm 2022-11-25
-2022-11-25 zgZ82sWMOE zgZ82sWMOE d3L50SOM47 xtRhjoeVNV
ZEWRyMclGd mE85T2Mg2t exZ7tYRdkr 6U4qNiFxDk VNTnrXhxC7
Rkfbo2rKY7 IoqxH43Iu1 13up4RtCbZ mbJgDA56Ey 9H7UGVuWCn
KvsB4cMCWZ FmICYOQC6Y 2022-11-25
-2022-11-25 zgUDwoe0R0 zgUDwoe0R0 VFqYUAJger Axv5zHQ9Aj
VrZj2oLMHw AFGrr1jQ4T dTaSKfBDyt lx1JgWEnVD Arqdl5tEB0
KSOTAtif2o TYuyIlLcDT 14vUoFChqv NM8pWxCiJL 1yZ7RM8WCs
9lYAarGdHK XsZ9vSH14w 2022-11-25
-2022-11-25 zYco1C1wbA zYco1C1wbA Jg9d1Vz8Nc M0jPS30f17
WRrQGzaqzl wKghuTj9Hf oAbqV68KVL iwT59HVsml X2pfKlSvmV
EtScW6rT7w fgSAM7qInL 7ud6VtTvNq pyP4ZGsJ5O 0mBO3GVgxc
j5ZKwj1MD5 VC7d7CEtco 2022-11-25
-2022-11-25 zUCfrwLP3h zUCfrwLP3h kqwtMmz3PH q1RgmOdoHv
ENU2ipUkUY IviUi4Gmrv R6LXapRkKZ vESQ05cSlQ ICw4lJ4ksT
bv0SQBAllD skdJMJYRKz ozPmYA3bks 3VSTEExqgk O9wf7u00RS
KQcf7rwCg5 K2EMmTiSSz 2022-11-25
-
--- !q34 --
-2022-11-24 zVhHON3m5L
-2022-11-24 zceLX7IpL5
-2022-11-24 zjp4CiDZ8F
-2022-11-24 zpV3iiPrMp
-2022-11-24 zrjCNYBzpb
-2022-11-24 zvbIuF1cg8
-2022-11-24 zyLjAtVdXV
-2022-11-25 zVOQFPxGhP
-2022-11-25 zj9uWRywHa
-2022-11-25 zvs3b72ERY
-
--- !q35 --
-2022-11-24 zyLjAtVdXV
-2022-11-24 zvbIuF1cg8
-2022-11-24 zrjCNYBzpb
-2022-11-24 zpV3iiPrMp
-2022-11-24 zjp4CiDZ8F
-2022-11-24 zceLX7IpL5
-2022-11-24 zVhHON3m5L
-2022-11-24 zTOGIjaaZJ
-2022-11-24 zOeOJwAvfc
-2022-11-24 zNDyH7VSpm
-
--- !q36 --
-zvs3b72ERY zorbigHkYB
-zj9uWRywHa 5F8hzYcY8G
-zVOQFPxGhP V0FTqkqsma
-zJvBmGUvxj oHlH8nOlxp
-zHUd303J4r q000anXrEp
-zGQt4RNefu 7fkTAaRATj
-z5SAncObhE PUl5h9h6iL
-z5AAgk7RGE gSPjanitfl
-z3cvap67Lh 8EfHi4roEB
-ysw8j0x551 IwlRuhywtn
-
--- !q37 --
-2000
-
--- !q38 --
-zvs3b72ERY zorbigHkYB
-zj9uWRywHa 5F8hzYcY8G
-zVOQFPxGhP V0FTqkqsma
-zJvBmGUvxj oHlH8nOlxp
-zHUd303J4r q000anXrEp
-zGQt4RNefu 7fkTAaRATj
-z5SAncObhE PUl5h9h6iL
-z5AAgk7RGE gSPjanitfl
-z3cvap67Lh 8EfHi4roEB
-ysw8j0x551 IwlRuhywtn
-
--- !q39 --
-zyLjAtVdXV GrJRf8WvRR
-zvs3b72ERY zorbigHkYB
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zj9uWRywHa 5F8hzYcY8G
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zVOQFPxGhP V0FTqkqsma
-
--- !q40 --
-2022-11-25 2022-11-25 zvs3b72ERY zorbigHkYB 2022-11-25
-2022-11-25 2022-11-25 zj9uWRywHa 5F8hzYcY8G 2022-11-25
-2022-11-25 2022-11-25 zVOQFPxGhP V0FTqkqsma 2022-11-25
-2022-11-25 2022-11-25 zJvBmGUvxj oHlH8nOlxp 2022-11-25
-2022-11-25 2022-11-25 zHUd303J4r q000anXrEp 2022-11-25
-2022-11-25 2022-11-25 zGQt4RNefu 7fkTAaRATj 2022-11-25
-2022-11-25 2022-11-25 z5SAncObhE PUl5h9h6iL 2022-11-25
-2022-11-25 2022-11-25 z5AAgk7RGE gSPjanitfl 2022-11-25
-2022-11-25 2022-11-25 z3cvap67Lh 8EfHi4roEB 2022-11-25
-2022-11-25 2022-11-25 ysw8j0x551 IwlRuhywtn 2022-11-25
-
--- !q41 --
-
--- !q42 --
-2022-11-24 2022-11-24 zyLjAtVdXV GrJRf8WvRR 2022-11-24
-2022-11-25 2022-11-25 zvs3b72ERY zorbigHkYB 2022-11-25
-2022-11-24 2022-11-24 zvbIuF1cg8 33ZkOc8Fl7 2022-11-24
-2022-11-24 2022-11-24 zrjCNYBzpb FD1Zxm39qk 2022-11-24
-2022-11-24 2022-11-24 zpV3iiPrMp j0XRD1oFXY 2022-11-24
-2022-11-24 2022-11-24 zjp4CiDZ8F ljiRxP16r2 2022-11-24
-2022-11-25 2022-11-25 zj9uWRywHa 5F8hzYcY8G 2022-11-25
-2022-11-24 2022-11-24 zceLX7IpL5 JZtsmIjKGQ 2022-11-24
-2022-11-24 2022-11-24 zVhHON3m5L ecmOZhvo5C 2022-11-24
-2022-11-25 2022-11-25 zVOQFPxGhP V0FTqkqsma 2022-11-25
-
--- !q43 --
-2022-11-10 zzf0Hyy3PP zzf0Hyy3PP kqonrn13oM qMpDJZ3jVG
oQafAQzfpg WprPRT9pxG W6Vfvw6VU3 U2J2db3EcI oa3CXQ51wk
DSfnG13L1h x6pO2DvZXm y6McEKEtPF 6P1xAKaJcI a0WviK01l1
4UxX1EJ4nV FAJyYIGlBN 2022-11-10
-2022-11-10 zwkeNflkF1 zwkeNflkF1 TkWqg6Ix6t Mvg3XCz4KW
xNtobuEiYh 2zfFFtguoD dM0xJvckpt J0KzHbhdQV GzofYnr0OQ
IDej5DPSlV QlzwIZHnDh oTrJx4aX3J Z1fyagW29j giFWZDk1Rd
CMHyNvI6n1 uXoAudfOjF 2022-11-10
-2022-11-10 zw7iBPPTEF zw7iBPPTEF z036dLkobV soKogHEGDn
htmRKThWKo WzPFReXEDF rx1wJaZkHR bGNyBl0jZc 41zilEUfud
fhVJ30rOBV VGgO3KrN3C c9KX0k1gb8 MwR4IXvjCI qrvDKvMD9k
mSqAiJQFEN hVuhJxSlj9 2022-11-10
-2022-11-10 zsLnfKZ51O zsLnfKZ51O wHvRoX5XhH 1lLcmzAVUU
VdRNvndgvg UoqeV9QYiJ pvSwfhZTej rA51Wq2lQN Ljdu8nmKCg
v9EMT2z3mo kKUH8y5N4u XoC9shDIZN GnJ5kOqIU3 ppQBteeHzM
3fn0IUEII1 tnzPWN4kRj 2022-11-10
-2022-11-10 zsEmkJnMdC zsEmkJnMdC Dx6sAB4I7M eCKoLNz9oG
lE3YGayXaN pGOgX608Fz pVo9dletTZ 7XWdPnNlJm seYFng9MgQ
PGD3yh4Wlc PfwzK2ZiuS l8ddKEdG8n AVLIoP9Jha ipjmF2YjKK
qaODuhuFWi AkuaGy0Qqp 2022-11-10
-2022-11-10 zmzCEZlbV5 zmzCEZlbV5 0v2IfWCEIr mdRkZG9LVW
yNR9pzfPna Q7XmH62qSh iYMJPOhApN QuKGOQYa7l XHYEA9oxnq
bU8pbr0KXA vY2O2CSUY6 8NH1vjDoPB SiSpTkuXNc QZOkZ5IjqD
heoOSWTkNX gOU9E6AR3E 2022-11-10
-2022-11-10 zfOtU6uM5Z zfOtU6uM5Z ALpuvTDVnW mjJPYTgWRl
9wPoJuEY4O Fjl0u6YIup i6MJdwoXrc jdEbHX2ciY at0qPGFS9K
BbFvD5pDHn R8j7s2hZHn YYatCMK0Hp R1wiwcfZ7J sgK2ElpSWh
dMjk2u1h2r MkoSLDtORA 2022-11-10
-2022-11-10 zaCKFeMKPl zaCKFeMKPl 2ZTD9DtO1l MHL1vr5tx4
fiE4PbRVGT B0L7bSYqqE HgJcRjMTEb M1Y8ublbIf duEnPcBFIj
N2j62LjxW4 4kaqVUWoPc Fe09FCOcfV chMDNkDdsu rCMCu231Bb
T6QDStOoKf izRqyR2c6v 2022-11-10
-2022-11-10 zYNiE7iX1z zYNiE7iX1z XWoDz1bYcL Bn8QGcPeVi
DJyDWOYpM3 Kv7jHcWKju eSDLJiXt8i 8uiVxsiVBq CtwoNyHZL8
XJeZsXvRzK VeJZUeQuPW UTeKq4u86J G9BRL00Caw qgXkXNw3LN
RFJIwqft7H 73uqYcUHNU 2022-11-10
-2022-11-10 zRZyJdYT6X zRZyJdYT6X r7KeoDNRia erhjhmnbee
8smgVFxgRY 4zsHrL9mmX GdCn844KLZ 6CT2bojzlB P2X7SBkzcy
uBpZ7VtFNj csGSglKMMF hmDxo1NUOg hUwaq7MFvD m8mu7xQZbS
aKhGVtz40x 7OP7GtYURR 2022-11-10
-
--- !q44 --
-2022-11-10 zyLjAtVdXV
-2022-11-10 zvbIuF1cg8
-2022-11-10 zrjCNYBzpb
-2022-11-10 zpV3iiPrMp
-2022-11-10 zjp4CiDZ8F
-2022-11-10 zceLX7IpL5
-2022-11-10 zVhHON3m5L
-2022-11-10 zTOGIjaaZJ
-2022-11-10 zOeOJwAvfc
-2022-11-10 zNDyH7VSpm
-
--- !q45 --
-2022-11-10 zyLjAtVdXV
-2022-11-10 zvbIuF1cg8
-2022-11-10 zrjCNYBzpb
-2022-11-10 zpV3iiPrMp
-2022-11-10 zjp4CiDZ8F
-2022-11-10 zceLX7IpL5
-2022-11-10 zVhHON3m5L
-2022-11-10 zTOGIjaaZJ
-2022-11-10 zOeOJwAvfc
-2022-11-10 zNDyH7VSpm
-
--- !q46 --
-zyLjAtVdXV GrJRf8WvRR
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zTOGIjaaZJ kKS2qRmfG7
-zOeOJwAvfc hQsA8GlyPI
-zNDyH7VSpm x6S8xvWIKO
-
--- !q47 --
-1000
-
--- !q48 --
-
--- !q49 --
-zyLjAtVdXV GrJRf8WvRR
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zTOGIjaaZJ kKS2qRmfG7
-zOeOJwAvfc hQsA8GlyPI
-zNDyH7VSpm x6S8xvWIKO
-
--- !q50 --
-2022-11-10 2022-11-10 zyLjAtVdXV GrJRf8WvRR 2022-11-10
-2022-11-10 2022-11-10 zvbIuF1cg8 33ZkOc8Fl7 2022-11-10
-2022-11-10 2022-11-10 zrjCNYBzpb FD1Zxm39qk 2022-11-10
-2022-11-10 2022-11-10 zpV3iiPrMp j0XRD1oFXY 2022-11-10
-2022-11-10 2022-11-10 zjp4CiDZ8F ljiRxP16r2 2022-11-10
-2022-11-10 2022-11-10 zceLX7IpL5 JZtsmIjKGQ 2022-11-10
-2022-11-10 2022-11-10 zVhHON3m5L ecmOZhvo5C 2022-11-10
-2022-11-10 2022-11-10 zTOGIjaaZJ kKS2qRmfG7 2022-11-10
-2022-11-10 2022-11-10 zOeOJwAvfc hQsA8GlyPI 2022-11-10
-2022-11-10 2022-11-10 zNDyH7VSpm x6S8xvWIKO 2022-11-10
-
--- !q51 --
-china
-america
-cana
-fre
-
--- !q24 --
-zhangsan 1
-lisi 1
-
--- !q25 --
-1 1
-2 1
-3 1
-4 1
-
--- !q26 --
-123 china 4 56 sc
-234 america 5 67 ls
-345 cana 4 56 fy
-567 fre 7 89 pa
-
--- !q27 --
-p_partkey2 p_name2 p_mfgr2 p_brand2 p_type2 p_size2 p_con2
p_r_price2 p_comment2
-p_partkey1 p_name1 p_mfgr1 p_brand1 p_type1 p_size1 p_con1
p_r_price1 p_comment1
-p_partkey0 p_name0 p_mfgr0 p_brand0 p_type0 p_size0 p_con0
p_r_price0 p_comment0
-
--- !q28 --
-batchno appsheet_no filedate t_no tano t_name
chged_no mob_no2 home_no off_no
-off_no home_no mob_no2 chged_no t_name tano t_no filedate
appsheet_no batchno
-
--- !q29 --
-bill_code dates ord_year ord_month ord_quarter on_time
-
--- !q30 --
-2
-
--- !q31 --
-123 zhangsan 12 123.45 2022-01-01
-124 lisi 12 123.45 2022-01-01
-125 lisan 12 123.45 2022-01-02
-
--- !q32 --
-a123 12
-a124 13
-a125 14
-a126 15
-
--- !q33 --
-2022-11-25 zz08Quhrpk zz08Quhrpk m8vknqtybC Eyk5GmwzDJ
eW7R46dTNx 86tM8PWfGQ RU6WOEYEmX eN0Sm0fEjH NwYXON812A
NYzAKjdBVu OQf936VCQv scbCva79DG HAK0HACy2d pbs5ypY6cy
ft54SbxPmW hcVLijY8PL 2022-11-25
-2022-11-25 zvyprEdKlk zvyprEdKlk 6oO1KfWKnS zeNgOLbD5I
o5FEyMNjhJ ACUBOltRRn YJsyP7erIV cZEbgd4Q7J DNzXA9QYKg
wrhu8Heu17 PHerHoPGn0 nSSQLodYNZ zSxZ7eEs1k V4RVLp7h2O
FGlZiPTOkV Yr1zRnrqPE 2022-11-25
-2022-11-25 ztbynIKOAB ztbynIKOAB T0jxzYQdtB sMyKhrS29F
tOKKw4YrnE ND0qk9uKlp f7fMtT4f9A XBKdWFhCc2 0AP0jCcOvc
Be2o2BO7Zf I33L9Tgr7y PG414ZCN0H Wb85Gn6HSE 6Dv3a7gAP1
abfib4AMr1 QX4rLkftjB 2022-11-25
-2022-11-25 zt6cI3WyPZ zt6cI3WyPZ FE3oLtL07b MqkD7rhh9Z
larXyucEGE piaxKcubhh cVUtgHlsly fjumWOXPkM hUNrdq0FYN
tsjzXqGBlN XNVuUkuoxG iyhpIB4SHv PTw9fDpPMm Url7haQqHQ
qWt4vJm87n FScyOLzx8c 2022-11-25
-2022-11-25 zluC6EgPz8 zluC6EgPz8 ufSllWR5MA XIcWrCHYsR
x4TQaY0uON AIRP6WN0PR sJ2hpxX6w4 aA4cNryz5G mAFcXmzyHG
VlVY1J6HSG 3HwdoY0t44 0nCMGUzzew RMsQ4tG9l4 BBKNamSAyP
8kRynkgB2y aqmC8elovV 2022-11-25
-2022-11-25 zjM4h9Jtm2 zjM4h9Jtm2 TgiVg53a5R qUqbrdFemU
0o7oL6FnQw h39e3fhRi2 erJgos6ENS xD8kdyZsIr VJ1GmDyO1F
QVbYI0NQ77 nrYkLCTrgD nQTn0hULEP qSHhNxO9AJ px5lKNCjrE
LyH73bHlJt KZSopyFVMm 2022-11-25
-2022-11-25 zgZ82sWMOE zgZ82sWMOE d3L50SOM47 xtRhjoeVNV
ZEWRyMclGd mE85T2Mg2t exZ7tYRdkr 6U4qNiFxDk VNTnrXhxC7
Rkfbo2rKY7 IoqxH43Iu1 13up4RtCbZ mbJgDA56Ey 9H7UGVuWCn
KvsB4cMCWZ FmICYOQC6Y 2022-11-25
-2022-11-25 zgUDwoe0R0 zgUDwoe0R0 VFqYUAJger Axv5zHQ9Aj
VrZj2oLMHw AFGrr1jQ4T dTaSKfBDyt lx1JgWEnVD Arqdl5tEB0
KSOTAtif2o TYuyIlLcDT 14vUoFChqv NM8pWxCiJL 1yZ7RM8WCs
9lYAarGdHK XsZ9vSH14w 2022-11-25
-2022-11-25 zYco1C1wbA zYco1C1wbA Jg9d1Vz8Nc M0jPS30f17
WRrQGzaqzl wKghuTj9Hf oAbqV68KVL iwT59HVsml X2pfKlSvmV
EtScW6rT7w fgSAM7qInL 7ud6VtTvNq pyP4ZGsJ5O 0mBO3GVgxc
j5ZKwj1MD5 VC7d7CEtco 2022-11-25
-2022-11-25 zUCfrwLP3h zUCfrwLP3h kqwtMmz3PH q1RgmOdoHv
ENU2ipUkUY IviUi4Gmrv R6LXapRkKZ vESQ05cSlQ ICw4lJ4ksT
bv0SQBAllD skdJMJYRKz ozPmYA3bks 3VSTEExqgk O9wf7u00RS
KQcf7rwCg5 K2EMmTiSSz 2022-11-25
-
--- !q34 --
-2022-11-24 zVhHON3m5L
-2022-11-24 zceLX7IpL5
-2022-11-24 zjp4CiDZ8F
-2022-11-24 zpV3iiPrMp
-2022-11-24 zrjCNYBzpb
-2022-11-24 zvbIuF1cg8
-2022-11-24 zyLjAtVdXV
-2022-11-25 zVOQFPxGhP
-2022-11-25 zj9uWRywHa
-2022-11-25 zvs3b72ERY
-
--- !q35 --
-2022-11-24 zyLjAtVdXV
-2022-11-24 zvbIuF1cg8
-2022-11-24 zrjCNYBzpb
-2022-11-24 zpV3iiPrMp
-2022-11-24 zjp4CiDZ8F
-2022-11-24 zceLX7IpL5
-2022-11-24 zVhHON3m5L
-2022-11-24 zTOGIjaaZJ
-2022-11-24 zOeOJwAvfc
-2022-11-24 zNDyH7VSpm
-
--- !q36 --
-zvs3b72ERY zorbigHkYB
-zj9uWRywHa 5F8hzYcY8G
-zVOQFPxGhP V0FTqkqsma
-zJvBmGUvxj oHlH8nOlxp
-zHUd303J4r q000anXrEp
-zGQt4RNefu 7fkTAaRATj
-z5SAncObhE PUl5h9h6iL
-z5AAgk7RGE gSPjanitfl
-z3cvap67Lh 8EfHi4roEB
-ysw8j0x551 IwlRuhywtn
-
--- !q37 --
-2000
-
--- !q38 --
-zvs3b72ERY zorbigHkYB
-zj9uWRywHa 5F8hzYcY8G
-zVOQFPxGhP V0FTqkqsma
-zJvBmGUvxj oHlH8nOlxp
-zHUd303J4r q000anXrEp
-zGQt4RNefu 7fkTAaRATj
-z5SAncObhE PUl5h9h6iL
-z5AAgk7RGE gSPjanitfl
-z3cvap67Lh 8EfHi4roEB
-ysw8j0x551 IwlRuhywtn
-
--- !q39 --
-zyLjAtVdXV GrJRf8WvRR
-zvs3b72ERY zorbigHkYB
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zj9uWRywHa 5F8hzYcY8G
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zVOQFPxGhP V0FTqkqsma
-
--- !q40 --
-2022-11-25 2022-11-25 zvs3b72ERY zorbigHkYB 2022-11-25
-2022-11-25 2022-11-25 zj9uWRywHa 5F8hzYcY8G 2022-11-25
-2022-11-25 2022-11-25 zVOQFPxGhP V0FTqkqsma 2022-11-25
-2022-11-25 2022-11-25 zJvBmGUvxj oHlH8nOlxp 2022-11-25
-2022-11-25 2022-11-25 zHUd303J4r q000anXrEp 2022-11-25
-2022-11-25 2022-11-25 zGQt4RNefu 7fkTAaRATj 2022-11-25
-2022-11-25 2022-11-25 z5SAncObhE PUl5h9h6iL 2022-11-25
-2022-11-25 2022-11-25 z5AAgk7RGE gSPjanitfl 2022-11-25
-2022-11-25 2022-11-25 z3cvap67Lh 8EfHi4roEB 2022-11-25
-2022-11-25 2022-11-25 ysw8j0x551 IwlRuhywtn 2022-11-25
-
--- !q41 --
-
--- !q42 --
-2022-11-24 2022-11-24 zyLjAtVdXV GrJRf8WvRR 2022-11-24
-2022-11-25 2022-11-25 zvs3b72ERY zorbigHkYB 2022-11-25
-2022-11-24 2022-11-24 zvbIuF1cg8 33ZkOc8Fl7 2022-11-24
-2022-11-24 2022-11-24 zrjCNYBzpb FD1Zxm39qk 2022-11-24
-2022-11-24 2022-11-24 zpV3iiPrMp j0XRD1oFXY 2022-11-24
-2022-11-24 2022-11-24 zjp4CiDZ8F ljiRxP16r2 2022-11-24
-2022-11-25 2022-11-25 zj9uWRywHa 5F8hzYcY8G 2022-11-25
-2022-11-24 2022-11-24 zceLX7IpL5 JZtsmIjKGQ 2022-11-24
-2022-11-24 2022-11-24 zVhHON3m5L ecmOZhvo5C 2022-11-24
-2022-11-25 2022-11-25 zVOQFPxGhP V0FTqkqsma 2022-11-25
-
--- !q43 --
-2022-11-10 zzf0Hyy3PP zzf0Hyy3PP kqonrn13oM qMpDJZ3jVG
oQafAQzfpg WprPRT9pxG W6Vfvw6VU3 U2J2db3EcI oa3CXQ51wk
DSfnG13L1h x6pO2DvZXm y6McEKEtPF 6P1xAKaJcI a0WviK01l1
4UxX1EJ4nV FAJyYIGlBN 2022-11-10
-2022-11-10 zwkeNflkF1 zwkeNflkF1 TkWqg6Ix6t Mvg3XCz4KW
xNtobuEiYh 2zfFFtguoD dM0xJvckpt J0KzHbhdQV GzofYnr0OQ
IDej5DPSlV QlzwIZHnDh oTrJx4aX3J Z1fyagW29j giFWZDk1Rd
CMHyNvI6n1 uXoAudfOjF 2022-11-10
-2022-11-10 zw7iBPPTEF zw7iBPPTEF z036dLkobV soKogHEGDn
htmRKThWKo WzPFReXEDF rx1wJaZkHR bGNyBl0jZc 41zilEUfud
fhVJ30rOBV VGgO3KrN3C c9KX0k1gb8 MwR4IXvjCI qrvDKvMD9k
mSqAiJQFEN hVuhJxSlj9 2022-11-10
-2022-11-10 zsLnfKZ51O zsLnfKZ51O wHvRoX5XhH 1lLcmzAVUU
VdRNvndgvg UoqeV9QYiJ pvSwfhZTej rA51Wq2lQN Ljdu8nmKCg
v9EMT2z3mo kKUH8y5N4u XoC9shDIZN GnJ5kOqIU3 ppQBteeHzM
3fn0IUEII1 tnzPWN4kRj 2022-11-10
-2022-11-10 zsEmkJnMdC zsEmkJnMdC Dx6sAB4I7M eCKoLNz9oG
lE3YGayXaN pGOgX608Fz pVo9dletTZ 7XWdPnNlJm seYFng9MgQ
PGD3yh4Wlc PfwzK2ZiuS l8ddKEdG8n AVLIoP9Jha ipjmF2YjKK
qaODuhuFWi AkuaGy0Qqp 2022-11-10
-2022-11-10 zmzCEZlbV5 zmzCEZlbV5 0v2IfWCEIr mdRkZG9LVW
yNR9pzfPna Q7XmH62qSh iYMJPOhApN QuKGOQYa7l XHYEA9oxnq
bU8pbr0KXA vY2O2CSUY6 8NH1vjDoPB SiSpTkuXNc QZOkZ5IjqD
heoOSWTkNX gOU9E6AR3E 2022-11-10
-2022-11-10 zfOtU6uM5Z zfOtU6uM5Z ALpuvTDVnW mjJPYTgWRl
9wPoJuEY4O Fjl0u6YIup i6MJdwoXrc jdEbHX2ciY at0qPGFS9K
BbFvD5pDHn R8j7s2hZHn YYatCMK0Hp R1wiwcfZ7J sgK2ElpSWh
dMjk2u1h2r MkoSLDtORA 2022-11-10
-2022-11-10 zaCKFeMKPl zaCKFeMKPl 2ZTD9DtO1l MHL1vr5tx4
fiE4PbRVGT B0L7bSYqqE HgJcRjMTEb M1Y8ublbIf duEnPcBFIj
N2j62LjxW4 4kaqVUWoPc Fe09FCOcfV chMDNkDdsu rCMCu231Bb
T6QDStOoKf izRqyR2c6v 2022-11-10
-2022-11-10 zYNiE7iX1z zYNiE7iX1z XWoDz1bYcL Bn8QGcPeVi
DJyDWOYpM3 Kv7jHcWKju eSDLJiXt8i 8uiVxsiVBq CtwoNyHZL8
XJeZsXvRzK VeJZUeQuPW UTeKq4u86J G9BRL00Caw qgXkXNw3LN
RFJIwqft7H 73uqYcUHNU 2022-11-10
-2022-11-10 zRZyJdYT6X zRZyJdYT6X r7KeoDNRia erhjhmnbee
8smgVFxgRY 4zsHrL9mmX GdCn844KLZ 6CT2bojzlB P2X7SBkzcy
uBpZ7VtFNj csGSglKMMF hmDxo1NUOg hUwaq7MFvD m8mu7xQZbS
aKhGVtz40x 7OP7GtYURR 2022-11-10
-
--- !q44 --
-2022-11-10 zyLjAtVdXV
-2022-11-10 zvbIuF1cg8
-2022-11-10 zrjCNYBzpb
-2022-11-10 zpV3iiPrMp
-2022-11-10 zjp4CiDZ8F
-2022-11-10 zceLX7IpL5
-2022-11-10 zVhHON3m5L
-2022-11-10 zTOGIjaaZJ
-2022-11-10 zOeOJwAvfc
-2022-11-10 zNDyH7VSpm
-
--- !q45 --
-2022-11-10 zyLjAtVdXV
-2022-11-10 zvbIuF1cg8
-2022-11-10 zrjCNYBzpb
-2022-11-10 zpV3iiPrMp
-2022-11-10 zjp4CiDZ8F
-2022-11-10 zceLX7IpL5
-2022-11-10 zVhHON3m5L
-2022-11-10 zTOGIjaaZJ
-2022-11-10 zOeOJwAvfc
-2022-11-10 zNDyH7VSpm
-
--- !q46 --
-zyLjAtVdXV GrJRf8WvRR
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zTOGIjaaZJ kKS2qRmfG7
-zOeOJwAvfc hQsA8GlyPI
-zNDyH7VSpm x6S8xvWIKO
-
--- !q47 --
-1000
-
--- !q48 --
-
--- !q49 --
-zyLjAtVdXV GrJRf8WvRR
-zvbIuF1cg8 33ZkOc8Fl7
-zrjCNYBzpb FD1Zxm39qk
-zpV3iiPrMp j0XRD1oFXY
-zjp4CiDZ8F ljiRxP16r2
-zceLX7IpL5 JZtsmIjKGQ
-zVhHON3m5L ecmOZhvo5C
-zTOGIjaaZJ kKS2qRmfG7
-zOeOJwAvfc hQsA8GlyPI
-zNDyH7VSpm x6S8xvWIKO
-
--- !q50 --
-2022-11-10 2022-11-10 zyLjAtVdXV GrJRf8WvRR 2022-11-10
-2022-11-10 2022-11-10 zvbIuF1cg8 33ZkOc8Fl7 2022-11-10
-2022-11-10 2022-11-10 zrjCNYBzpb FD1Zxm39qk 2022-11-10
-2022-11-10 2022-11-10 zpV3iiPrMp j0XRD1oFXY 2022-11-10
-2022-11-10 2022-11-10 zjp4CiDZ8F ljiRxP16r2 2022-11-10
-2022-11-10 2022-11-10 zceLX7IpL5 JZtsmIjKGQ 2022-11-10
-2022-11-10 2022-11-10 zVhHON3m5L ecmOZhvo5C 2022-11-10
-2022-11-10 2022-11-10 zTOGIjaaZJ kKS2qRmfG7 2022-11-10
-2022-11-10 2022-11-10 zOeOJwAvfc hQsA8GlyPI 2022-11-10
-2022-11-10 2022-11-10 zNDyH7VSpm x6S8xvWIKO 2022-11-10
-
--- !q51 --
-china
-america
-cana
-fre
-
--- !after_refresh --
-2022-11-24 2022-11-24 zVhHON3m5L ecmOZhvo5C 2022-11-24
-2022-11-24 2022-11-24 zceLX7IpL5 JZtsmIjKGQ 2022-11-24
-2022-11-24 2022-11-24 zjp4CiDZ8F ljiRxP16r2 2022-11-24
-2022-11-24 2022-11-24 zpV3iiPrMp j0XRD1oFXY 2022-11-24
-2022-11-24 2022-11-24 zrjCNYBzpb FD1Zxm39qk 2022-11-24
-2022-11-24 2022-11-24 zvbIuF1cg8 33ZkOc8Fl7 2022-11-24
-2022-11-24 2022-11-24 zyLjAtVdXV GrJRf8WvRR 2022-11-24
-2022-11-25 2022-11-25 zVOQFPxGhP V0FTqkqsma 2022-11-25
-2022-11-25 2022-11-25 zj9uWRywHa 5F8hzYcY8G 2022-11-25
-2022-11-25 2022-11-25 zvs3b72ERY zorbigHkYB 2022-11-25
-
diff --git a/regression-test/pipeline/external/conf/be.conf
b/regression-test/pipeline/external/conf/be.conf
index 85fedf8873f..9a5b3641b84 100644
--- a/regression-test/pipeline/external/conf/be.conf
+++ b/regression-test/pipeline/external/conf/be.conf
@@ -70,5 +70,3 @@ fragment_pool_thread_num_max=5000
enable_fuzzy_mode=true
enable_set_in_bitmap_value=true
enable_feature_binlog=true
-
-trino_connector_plugin_dir=/tmp/trino_connector/connectors
diff --git a/regression-test/pipeline/external/conf/fe.conf
b/regression-test/pipeline/external/conf/fe.conf
index bd069f40c68..6f0cfb79253 100644
--- a/regression-test/pipeline/external/conf/fe.conf
+++ b/regression-test/pipeline/external/conf/fe.conf
@@ -94,5 +94,3 @@ enable_feature_binlog=true
auth_token = 5ff161c3-2c08-4079-b108-26c8850b6598
infodb_support_ext_catalog=true
-
-trino_connector_plugin_dir=/tmp/trino_connector/connectors
diff --git a/regression-test/pipeline/external/conf/regression-conf.groovy
b/regression-test/pipeline/external/conf/regression-conf.groovy
index 02b5c68fd08..3c9071886db 100644
--- a/regression-test/pipeline/external/conf/regression-conf.groovy
+++ b/regression-test/pipeline/external/conf/regression-conf.groovy
@@ -41,8 +41,6 @@ suitePath = "${DORIS_HOME}/regression-test/suites"
dataPath = "${DORIS_HOME}/regression-test/data"
pluginPath = "${DORIS_HOME}/regression-test/plugins"
realDataPath = "${DORIS_HOME}/regression-test/realdata"
-trinoPluginsPath = "/tmp/trino_connector"
-
// sf1DataPath can be url like
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com"; or local
path like "/data"
//sf1DataPath =
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com";
diff --git a/regression-test/pipeline/p0/conf/be.conf
b/regression-test/pipeline/p0/conf/be.conf
index d1ff5fdeb27..15f19ec4f42 100644
--- a/regression-test/pipeline/p0/conf/be.conf
+++ b/regression-test/pipeline/p0/conf/be.conf
@@ -82,5 +82,3 @@ user_files_secure_path=/
enable_debug_points=true
# debug scanner context dead loop
enable_debug_log_timeout_secs=0
-
-trino_connector_plugin_dir=/tmp/trino_connector/connectors
diff --git a/regression-test/pipeline/p0/conf/regression-conf.groovy
b/regression-test/pipeline/p0/conf/regression-conf.groovy
index 50309ed61b6..32f4a6e9f59 100644
--- a/regression-test/pipeline/p0/conf/regression-conf.groovy
+++ b/regression-test/pipeline/p0/conf/regression-conf.groovy
@@ -45,7 +45,6 @@ suitePath = "${DORIS_HOME}/regression-test/suites"
dataPath = "${DORIS_HOME}/regression-test/data"
pluginPath = "${DORIS_HOME}/regression-test/plugins"
realDataPath = "${DORIS_HOME}/regression-test/realdata"
-trinoPluginsPath = "/tmp/trino_connector"
// sf1DataPath can be url like
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com"; or local
path like "/data"
//sf1DataPath =
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com";
diff --git
a/regression-test/suites/external_table_p0/trino_connector/hive/test_trino_hive_orc.groovy
b/regression-test/suites/external_table_p0/trino_connector/hive/test_trino_hive_orc.groovy
deleted file mode 100644
index 0f529b0eeef..00000000000
---
a/regression-test/suites/external_table_p0/trino_connector/hive/test_trino_hive_orc.groovy
+++ /dev/null
@@ -1,164 +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.
-
-suite("test_trino_hive_orc",
"all_types,external,hive,external_docker,external_docker_hive") {
- def trino_connector_download_dir =
context.config.otherConfigs.get("trinoPluginsPath")
-
- // mkdir trino_connector_download_dir
- logger.info("start create dir ${trino_connector_download_dir} ...")
- def mkdir_connectors_tar = "mkdir -p
${trino_connector_download_dir}".execute().getText()
- logger.info("finish create dir, result: ${mkdir_connectors_tar} ...")
-
-
- def plugins_compression =
"${trino_connector_download_dir}/trino-connectors.tar.gz"
- def plugins_dir = "${trino_connector_download_dir}/connectors"
-
- // download trino-connectors.tar.gz
- File path = new File("${plugins_compression}")
- if (path.exists() && path.isFile()) {
- logger.info("${plugins_compression} has been downloaded")
- } else {
- logger.info("start delete trino-connector plugins dir ...")
- def delete_local_connectors_tar = "rm -r ${plugins_dir}".execute()
- logger.info("start download trino-connector plugins ...")
- def s3_url = getS3Url()
-
- logger.info("getS3Url ==== ${s3_url}")
- def download_connectors_tar = "/usr/bin/curl
${s3_url}/regression/trino-connectors.tar.gz --output ${plugins_compression}"
- logger.info("download cmd : ${download_connectors_tar}")
- def run_download_connectors_cmd =
download_connectors_tar.execute().getText()
- logger.info("result: ${run_download_connectors_cmd}")
- logger.info("finish download ${plugins_compression} ...")
- }
-
- // decompression trino-plugins.tar.gz
- File dir = new File("${plugins_dir}")
- if (dir.exists() && dir.isDirectory()) {
- logger.info("${plugins_dir} dir has been decompressed")
- } else {
- if (path.exists() && path.isFile()) {
- def run_cmd = "tar -zxvf ${plugins_compression} -C
${trino_connector_download_dir}"
- logger.info("run_cmd : $run_cmd")
- def run_decompress_cmd = run_cmd.execute().getText()
- logger.info("result: $run_decompress_cmd")
- } else {
- logger.info("${plugins_compression} is not exist or is not a
file.")
- throw exception
- }
- }
-
- // Ensure that all types are parsed correctly
- def select_top50 = {
- qt_select_top50 """select * from orc_all_types order by int_col desc
limit 50;"""
- }
-
-
- // Ensure that the null map of all types are parsed correctly
- def count_all = {
- qt_count_all """
- select p1_col, p2_col,
- count(tinyint_col),
- count(smallint_col),
- count(int_col),
- count(bigint_col),
- count(boolean_col),
- count(float_col),
- count(double_col),
- count(string_col),
- count(binary_col),
- count(timestamp_col),
- count(decimal_col),
- count(char_col),
- count(varchar_col),
- count(date_col),
- sum(size(list_double_col)),
- sum(size(list_string_col))
- from orc_all_types group by p1_col, p2_col
- order by p1_col, p2_col;
- """
- }
-
- // Ensure that the SearchArgument works well: LG
- def search_lg_int = {
- qt_search_lg_int """select count(int_col) from orc_all_types where
int_col > 999613702;"""
- }
-
- // Ensure that the SearchArgument works well: IN
- def search_in_int = {
- qt_search_in_int """select count(int_col) from orc_all_types where
int_col in (999742610, 999613702);"""
- }
-
- // Ensure that the SearchArgument works well: MIX
- def search_mix = {
- qt_search_mix """select int_col, decimal_col, date_col from
orc_all_types where int_col > 995328433 and decimal_col > 988850.7929 and
date_col > date '2018-08-25';"""
- }
-
- // only partition column selected
- def only_partition_col = {
- qt_only_partition_col """select count(p1_col), count(p2_col) from
orc_all_types;"""
- }
-
- // decimals
- def decimals = {
- qt_decimals1 """select * from orc_decimal_table order by id;"""
- qt_decimals2 """select * from orc_decimal_table where id = 3 order by
id;"""
- qt_decimals3 """select * from orc_decimal_table where id < 3 order by
id;"""
- qt_decimals4 """select * from orc_decimal_table where id > 3 order by
id;"""
- }
-
- String enabled = context.config.otherConfigs.get("enableHiveTest")
- if (enabled != null && enabled.equalsIgnoreCase("true")) {
- try {
- String hms_port = context.config.otherConfigs.get("hms_port")
- String catalog_name = "test_trino_hive_orc"
- String externalEnvIp =
context.config.otherConfigs.get("externalEnvIp")
-
- sql """drop catalog if exists ${catalog_name}"""
- sql """
- create catalog if not exists ${catalog_name} properties (
- "type"="trino-connector",
- "connector.name"="hive",
- 'hive.metastore.uri' =
'thrift://${externalEnvIp}:${hms_port}'
- );
- """
-
- sql """use `${catalog_name}`.`default`"""
-
- select_top50()
- count_all()
- search_lg_int()
- search_in_int()
- search_mix()
- only_partition_col()
- decimals()
-
- sql """drop catalog if exists ${catalog_name}"""
- sql """
- create catalog if not exists ${catalog_name} properties (
- "type"="trino-connector",
- "connector.name"="hive",
- 'hive.metastore.uri' =
'thrift://${externalEnvIp}:${hms_port}'
- );
- """
- sql """use `${catalog_name}`.`default`"""
- select_top50()
- sql """drop catalog if exists ${catalog_name}"""
- } finally {
- }
- }
-}
-
diff --git
a/regression-test/suites/external_table_p0/trino_connector/hive/test_trino_hive_other.groovy
b/regression-test/suites/external_table_p0/trino_connector/hive/test_trino_hive_other.groovy
deleted file mode 100644
index 11ca76b0c8f..00000000000
---
a/regression-test/suites/external_table_p0/trino_connector/hive/test_trino_hive_other.groovy
+++ /dev/null
@@ -1,150 +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.
-
-suite("test_trino_hive_other",
"external,hive,external_docker,external_docker_hive") {
- def trino_connector_download_dir =
context.config.otherConfigs.get("trinoPluginsPath")
-
- // mkdir trino_connector_download_dir
- logger.info("start create dir ${trino_connector_download_dir} ...")
- def mkdir_connectors_tar = "mkdir -p
${trino_connector_download_dir}".execute().getText()
- logger.info("finish create dir, result: ${mkdir_connectors_tar} ...")
-
-
- def plugins_compression =
"${trino_connector_download_dir}/trino-connectors.tar.gz"
- def plugins_dir = "${trino_connector_download_dir}/connectors"
-
- // download trino-connectors.tar.gz
- File path = new File("${plugins_compression}")
- if (path.exists() && path.isFile()) {
- logger.info("${plugins_compression} has been downloaded")
- } else {
- logger.info("start delete trino-connector plugins dir ...")
- def delete_local_connectors_tar = "rm -r ${plugins_dir}".execute()
- logger.info("start download trino-connector plugins ...")
- def s3_url = getS3Url()
-
- logger.info("getS3Url ==== ${s3_url}")
- def download_connectors_tar = "/usr/bin/curl
${s3_url}/regression/trino-connectors.tar.gz --output ${plugins_compression}"
- logger.info("download cmd : ${download_connectors_tar}")
- def run_download_connectors_cmd =
download_connectors_tar.execute().getText()
- logger.info("result: ${run_download_connectors_cmd}")
- logger.info("finish download ${plugins_compression} ...")
- }
-
- // decompression trino-plugins.tar.gz
- File dir = new File("${plugins_dir}")
- if (dir.exists() && dir.isDirectory()) {
- logger.info("${plugins_dir} dir has been decompressed")
- } else {
- if (path.exists() && path.isFile()) {
- def run_cmd = "tar -zxvf ${plugins_compression} -C
${trino_connector_download_dir}"
- logger.info("run_cmd : $run_cmd")
- def run_decompress_cmd = run_cmd.execute().getText()
- logger.info("result: $run_decompress_cmd")
- } else {
- logger.info("${plugins_compression} is not exist or is not a
file.")
- throw exception
- }
- }
-
-
- def q01 = {
- qt_q24 """ select name, count(1) as c from student group by name order
by c desc;"""
- qt_q25 """ select lo_orderkey, count(1) as c from lineorder group by
lo_orderkey order by lo_orderkey asc, c desc;"""
- qt_q26 """ select * from test1 order by col_1;"""
- qt_q27 """ select * from string_table order by p_partkey desc;"""
- qt_q28 """ select * from account_fund order by batchno;"""
- qt_q29 """ select * from sale_table order by bill_code limit 01;"""
- order_qt_q30 """ select count(card_cnt) from hive01;"""
- qt_q31 """ select * from test2 order by id;"""
- qt_q32 """ select * from test_hive_doris order by id;"""
-
- qt_q33 """ select dt, k1, * from table_with_vertical_line order by dt
desc, k1 desc limit 10;"""
- order_qt_q34 """ select dt, k2 from table_with_vertical_line order by
k2 desc limit 10;"""
- qt_q35 """ select dt, k2 from table_with_vertical_line where
dt='2022-11-24' order by k2 desc limit 10;"""
- qt_q36 """ select k2, k5 from table_with_vertical_line where
dt='2022-11-25' order by k2 desc limit 10;"""
- order_qt_q37 """ select count(*) from table_with_vertical_line;"""
- qt_q38 """ select k2, k5 from table_with_vertical_line where dt in
('2022-11-25') order by k2 desc limit 10;"""
- qt_q39 """ select k2, k5 from table_with_vertical_line where dt in
('2022-11-25', '2022-11-24') order by k2 desc limit 10;"""
- qt_q40 """ select dt, dt, k2, k5, dt from table_with_vertical_line
where dt in ('2022-11-25') or dt in ('2022-11-25') order by k2 desc limit 10;"""
- qt_q41 """ select dt, dt, k2, k5, dt from table_with_vertical_line
where dt in ('2022-11-25') and dt in ('2022-11-24') order by k2 desc limit
10;"""
- qt_q42 """ select dt, dt, k2, k5, dt from table_with_vertical_line
where dt in ('2022-11-25') or dt in ('2022-11-24') order by k2 desc limit 10;"""
-
- qt_q43 """ select dt, k1, * from table_with_x01 order by dt desc, k1
desc limit 10;"""
- qt_q44 """ select dt, k2 from table_with_x01 order by k2 desc limit
10;"""
- qt_q45 """ select dt, k2 from table_with_x01 where dt='2022-11-10'
order by k2 desc limit 10;"""
- qt_q46 """ select k2, k5 from table_with_x01 where dt='2022-11-10'
order by k2 desc limit 10;"""
- order_qt_q47 """ select count(*) from table_with_x01;"""
- qt_q48 """ select k2, k5 from table_with_x01 where dt in
('2022-11-25') order by k2 desc limit 10;"""
- qt_q49 """ select k2, k5 from table_with_x01 where dt in
('2022-11-10', '2022-11-10') order by k2 desc limit 10;"""
- qt_q50 """ select dt, dt, k2, k5, dt from table_with_x01 where dt in
('2022-11-10') or dt in ('2022-11-10') order by k2 desc limit 10;"""
- qt_q51 """ select col_2 from test1;"""
- }
-
- String enabled = context.config.otherConfigs.get("enableHiveTest")
- if (enabled != null && enabled.equalsIgnoreCase("true")) {
- String hms_port = context.config.otherConfigs.get("hms_port")
- String hdfs_port = context.config.otherConfigs.get("hdfs_port")
- String externalEnvIp = context.config.otherConfigs.get("externalEnvIp")
-
- String catalog_name = "test_trino_hive_other"
-
- sql """drop catalog if exists ${catalog_name}"""
- sql """create catalog if not exists ${catalog_name} properties (
- "type"="trino-connector",
- "connector.name"="hive",
- 'hive.metastore.uri' = 'thrift://${externalEnvIp}:${hms_port}'
- );"""
-
- // test user's grants on external catalog
- sql """drop user if exists ext_catalog_user"""
- sql """create user ext_catalog_user identified by '12345'"""
- sql """grant all on internal.${context.config.defaultDb}.* to
ext_catalog_user"""
- sql """grant all on ${catalog_name}.*.* to ext_catalog_user"""
- connect(user = 'ext_catalog_user', password = '12345', url =
context.config.jdbcUrl) {
- def database_lists = sql """show databases from ${catalog_name}"""
- boolean ok = false;
- for (int i = 0; i < database_lists.size(); ++j) {
- assertEquals(1, database_lists[i].size())
- if (database_lists[i][0].equals("default")) {
- ok = true;
- break;
- }
- }
- if (!ok) {
- throw exception
- }
- }
- sql """drop user ext_catalog_user"""
-
- sql """switch ${catalog_name}"""
- sql """use `default`"""
- // order_qt_show_tables """show tables"""
-
- q01()
-
- sql """refresh catalog ${catalog_name}"""
- q01()
- sql """refresh database `default`"""
- // order_qt_show_tables2 """show tables"""
- q01()
- sql """refresh table `default`.table_with_vertical_line"""
- order_qt_after_refresh """ select dt, dt, k2, k5, dt from
table_with_vertical_line where dt in ('2022-11-25') or dt in ('2022-11-24')
order by k2 desc limit 10;"""
-
- sql """drop catalog if exists ${catalog_name}"""
- }
-}
diff --git
a/regression-test/suites/external_table_p0/trino_connector/test_plugins_download.groovy
b/regression-test/suites/external_table_p0/trino_connector/test_plugins_download.groovy
deleted file mode 100644
index acf9f4558df..00000000000
---
a/regression-test/suites/external_table_p0/trino_connector/test_plugins_download.groovy
+++ /dev/null
@@ -1,63 +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.
-
-suite("test_plugins_download",
"external,hive,external_docker,external_docker_hive") {
- def trino_connector_download_dir =
context.config.otherConfigs.get("trinoPluginsPath")
-
- // mkdir trino_connector_download_dir
- logger.info("start create dir ${trino_connector_download_dir} ...")
- def mkdir_connectors_tar = "mkdir -p
${trino_connector_download_dir}".execute().getText()
- logger.info("finish create dir, result: ${mkdir_connectors_tar} ...")
-
-
- def plugins_compression =
"${trino_connector_download_dir}/trino-connectors.tar.gz"
- def plugins_dir = "${trino_connector_download_dir}/connectors"
-
- // download trino-connectors.tar.gz
- File path = new File("${plugins_compression}")
- if (path.exists() && path.isFile()) {
- logger.info("${plugins_compression} has been downloaded")
- } else {
- logger.info("start delete trino-connector plugins dir ...")
- def delete_local_connectors_tar = "rm -r ${plugins_dir}".execute()
- logger.info("start download trino-connector plugins ...")
- def s3_url = getS3Url()
-
- logger.info("getS3Url ==== ${s3_url}")
- def download_connectors_tar = "/usr/bin/curl
${s3_url}/regression/trino-connectors.tar.gz --output ${plugins_compression}"
- logger.info("download cmd : ${download_connectors_tar}")
- def run_download_connectors_cmd =
download_connectors_tar.execute().getText()
- logger.info("result: ${run_download_connectors_cmd}")
- logger.info("finish download ${plugins_compression} ...")
- }
-
- // decompression trino-plugins.tar.gz
- File dir = new File("${plugins_dir}")
- if (dir.exists() && dir.isDirectory()) {
- logger.info("${plugins_dir} dir has been decompressed")
- } else {
- if (path.exists() && path.isFile()) {
- def run_cmd = "tar -zxvf ${plugins_compression} -C
${trino_connector_download_dir}"
- logger.info("run_cmd : $run_cmd")
- def run_decompress_cmd = run_cmd.execute().getText()
- logger.info("result: $run_decompress_cmd")
- } else {
- logger.info("${plugins_compression} is not exist or is not a
file.")
- throw exception
- }
- }
-}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
