This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 7f2ea35b63 [enhancement](test) add brown cases to p2 (#12694)
7f2ea35b63 is described below
commit 7f2ea35b63d601fcea4bd68126a34256d098b9fd
Author: Yongqiang YANG <[email protected]>
AuthorDate: Sun Sep 25 23:46:45 2022 +0800
[enhancement](test) add brown cases to p2 (#12694)
---
.../brown_p2/sql/CPUNetworkUtilization_order.out | 6 +
.../data/brown_p2/sql/averageMetrics.out | 258 ++++++++++++++
.../data/brown_p2/sql/blockedIOServer.out | 13 +
regression-test/data/brown_p2/sql/dailyUV.out | 369 +++++++++++++++++++++
.../data/brown_p2/sql/dataTransferRate.out | 4 +
regression-test/data/brown_p2/sql/doorOpen.out | 23 ++
.../data/brown_p2/sql/excessiveRequests.out | 11 +
.../data/brown_p2/sql/hourlyNetworkTraffic.out | 13 +
regression-test/data/brown_p2/sql/lowMemory.out | 19 ++
.../data/brown_p2/sql/offlineMachine.out | 21 ++
.../data/brown_p2/sql/passwordLeaked.out | 5 +
.../data/brown_p2/sql/powerConsumptionMetrics.out | 31 ++
regression-test/data/brown_p2/sql/serverError.out | 5 +
.../data/brown_p2/sql/temperatureReachFreezing.out | 5 +
.../brown_p2/sql/temperatureVariation_order.out | 14 +
regression-test/suites/brown_p2/ddl/logs1.sql | 27 ++
regression-test/suites/brown_p2/ddl/logs2.sql | 11 +
regression-test/suites/brown_p2/ddl/logs3.sql | 14 +
regression-test/suites/brown_p2/load.groovy | 76 +++++
.../brown_p2/sql/CPUNetworkUtilization_order.sql | 20 ++
.../suites/brown_p2/sql/averageMetrics.sql | 28 ++
.../suites/brown_p2/sql/blockedIOServer.sql | 10 +
regression-test/suites/brown_p2/sql/dailyUV.sql | 9 +
.../suites/brown_p2/sql/dataTransferRate.sql | 8 +
regression-test/suites/brown_p2/sql/doorOpen.sql | 9 +
.../suites/brown_p2/sql/excessiveRequests.sql | 7 +
.../suites/brown_p2/sql/hourlyNetworkTraffic.sql | 21 ++
regression-test/suites/brown_p2/sql/lowMemory.sql | 16 +
.../suites/brown_p2/sql/offlineMachine.sql | 9 +
.../suites/brown_p2/sql/passwordLeaked.sql | 7 +
.../brown_p2/sql/powerConsumptionMetrics.sql | 40 +++
.../suites/brown_p2/sql/serverError.sql | 5 +
.../brown_p2/sql/temperatureReachFreezing.sql | 5 +
.../brown_p2/sql/temperatureVariation_order.sql | 49 +++
34 files changed, 1168 insertions(+)
diff --git a/regression-test/data/brown_p2/sql/CPUNetworkUtilization_order.out
b/regression-test/data/brown_p2/sql/CPUNetworkUtilization_order.out
new file mode 100644
index 0000000000..8721bed5d8
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/CPUNetworkUtilization_order.out
@@ -0,0 +1,6 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !CPUNetworkUtilization_order --
+anansi 0 22.499999744 0.142686086 938.95000064
2355335.637499904 9177.160292675 216.88000512 2354536.236711936
13467.316295748
+aragog 0 31.139999744 0.466084818 1318.689964032 27836488.351744
328922.023920031 308.950007808 40642403.643686912 825490.561812005
+urd 0 23.493332992 1.499065356 1168.349986816
368025.614155776 22100.285069203 220.950003712 108069.656723456
8129.441452354
+
diff --git a/regression-test/data/brown_p2/sql/averageMetrics.out
b/regression-test/data/brown_p2/sql/averageMetrics.out
new file mode 100644
index 0000000000..c563c279ac
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/averageMetrics.out
@@ -0,0 +1,258 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !averageMetrics --
+2017-01-01 0 0.12023027675847213 0.09362472227464119
0.0874438889300412 2170359.9625 8388604.0
+2017-01-01 1 0.06573361170788607 0.0625577774674942
0.056119999939498184 2170050.0541666667 8388604.0
+2017-01-01 2 0.0640669446438551 0.08363861156006654
0.07870277819068482 2170090.845833333 8388604.0
+2017-01-01 3 0.09865416679531336 0.10061388906712333
0.1035800002515316 2169553.683333333 8388604.0
+2017-01-01 4 0.09523666687309743 0.09710055502752463
0.0957255561351 2167171.0 8388604.0
+2017-01-01 5 0.07341333335886399 0.08771055564284325
0.09117277674959041 2169601.075 8388604.0
+2017-01-01 6 0.12499666611353556 0.12358194390932718
0.14162249937653543 2169959.2041666666 8388604.0
+2017-01-01 7 0.11430861018598079 0.09302722246696551
0.08682444394410899 2170149.683333333 8388604.0
+2017-01-01 8 0.10646722217400868 0.09895083370308082
0.10322805638425052 2167045.4833333334 8388604.0
+2017-01-01 9 0.12251555447777113 0.10479388938595852
0.11136138871467362 2162012.7875 8388604.0
+2017-01-01 10 0.11412361015876134 0.0965374997506539
0.09687638870964292 2161791.529166667 8388604.0
+2017-01-01 11 0.11665944419801236 0.1013836105975012
0.1008749992067654 2162073.875 8388604.0
+2017-01-01 12 0.13202694319188596 0.12223999947309494
0.1293141655837341 2161852.1416666666 8388604.0
+2017-01-01 13 0.13301833334068458 0.12085999964425961
0.12991249958674114 2161914.9833333334 8388604.0
+2017-01-01 14 0.13185360990464687 0.12042166665196419
0.12537749847009158 2161910.5083333333 8388604.0
+2017-01-01 15 0.12312361064056555 0.1071613892291983
0.11218249985928802 2161943.1625 8388604.0
+2017-01-01 16 0.12113694337507089 0.09912972232947746
0.10122527798327306 2162018.1166666667 8388604.0
+2017-01-01 17 0.11475583215554555 0.09416805543005466
0.07953444474066297 2161867.325 8388604.0
+2017-01-01 18 0.11836805505057175 0.09412694449226061
0.09295555571249375 2161808.3541666665 8388604.0
+2017-01-01 19 0.12196722105145455 0.09792555570602417
0.10160416682774667 2161681.9125 8388604.0
+2017-01-01 20 0.09463472279409567 0.09313277794669071
0.09773722252769707 2161829.683333333 8388604.0
+2017-01-01 21 0.10291055515408516 0.09544166680425406
0.09454444425258164 2161906.2 8388604.0
+2017-01-01 22 0.07539472244679928 0.06954305566226443
0.0663477773196064 2161942.8291666666 8388604.0
+2017-01-01 23 0.09157972224056721 0.09328861112395923
0.08586444450969187 2161994.05 8388604.0
+2017-01-02 0 0.11643944419920445 0.1134722225368023
0.11106166699707197 2161844.6416666666 8388604.0
+2017-01-02 1 0.11753805540502071 0.09894166635349393
0.0991397222969681 2161888.5208333335 8388604.0
+2017-01-02 2 0.10927694452305635 0.09175833308448395
0.09419027830590494 2161895.933333333 8388604.0
+2017-01-02 3 0.11750833193461101 0.10710861037174861
0.09911694461188744 2160943.004166667 8388604.0
+2017-01-02 4 0.16006777683893839 0.15108305470397074
0.15381611017025232 2159976.3375 8388604.0
+2017-01-02 5 0.12559138784805934 0.11111666653305292
0.1124097219047447 2160101.933333333 8388604.0
+2017-01-02 6 0.12220388799905776 0.09916305541992188
0.08808777770900633 2160372.5 8388604.0
+2017-01-02 7 0.09964111087222895 0.09401000011712313
0.0919058339476275 2160514.6 8388604.0
+2017-01-02 8 0.10217888851960501 0.08666555558641752
0.08541472238333275 2160668.1 8388604.0
+2017-01-02 9 0.08228083352247874 0.0942005558560292
0.1027352773885165 2160456.091666667 8388604.0
+2017-01-02 10 0.08421888947486877 0.09449861086905002
0.08481555470692305 2160655.85 8388604.0
+2017-01-02 11 0.12303055475155512 0.11588388836632173
0.12435083231733492 2160461.720833333 8388604.0
+2017-01-02 12 0.11161638864626487 0.1100330556742847
0.11490638894028962 2160493.2333333334 8388604.0
+2017-01-02 13 0.12921444289386272 0.11345722203453382
0.11001138850891341 2160430.4125 8388604.0
+2017-01-02 14 0.11105805598199367 0.09359888865922888
0.08493416655886298 2160381.591666667 8388604.0
+2017-01-02 15 0.11183222153534492 0.10292472159489989
0.0906275008067799 2160393.1333333333 8388604.0
+2017-01-02 16 0.08617916715641817 0.0910433333987991
0.10536333332420326 2160193.808333333 8388604.0
+2017-01-02 17 0.0878711111843586 0.08413500000412265
0.07315277799886341 2160329.4875 8388604.0
+2017-01-02 18 0.0967963883653283 0.09547444383303325
0.08687333262447888 2160225.154166667 8388604.0
+2017-01-02 19 0.06433361110587915 0.08074055571729938
0.06748694431929228 2160357.2416666667 8388604.0
+2017-01-02 20 0.08769361103574434 0.09626222280785442
0.09008638854041541 2160311.7875 8388604.0
+2017-01-02 21 0.11698249901334444 0.10602944449832043
0.105711667672828 2160373.0708333333 8388604.0
+2017-01-02 22 0.08861805585523447 0.080060277475665
0.09200138879241422 2160149.3833333333 8388604.0
+2017-01-02 23 0.09397055556376775 0.0953636114175121
0.08649277772832041 2160389.875 8388604.0
+2017-01-03 0 0.08480277775476376 0.0881111114906768
0.1002250003288888 2160202.345833333 8388604.0
+2017-01-03 1 0.08412027824670076 0.08960694453368584
0.08068527791086429 2160146.933333333 8388604.0
+2017-01-03 2 0.07765083350241184 0.09546111101905505
0.09552611066416526 2160108.6666666665 8388604.0
+2017-01-03 3 0.11927249878644944 0.09875499984870355
0.09649555630118509 2160172.004166667 8388604.0
+2017-01-03 4 0.1416475004206101 0.14051166692127784
0.1379869445692748 2158355.8854166665 8388604.0
+2017-01-03 5 0.11167611107230187 0.09206805570671955
0.10099944511118035 2160156.725 8388604.0
+2017-01-03 6 0.12186638774971167 0.11450888911883036
0.10943611183514197 2160072.970833333 8388604.0
+2017-01-03 7 0.12645916591087977 0.11633722229550282
0.12031111099446813 2159854.4541666666 8388604.0
+2017-01-03 8 0.12138416655361653 0.10111111116906008
0.10423249863088131 2159847.154166667 8388604.0
+2017-01-03 9 0.09084388942768176 0.09078694476435582
0.08977777708011368 2159932.2708333335 8388604.0
+2017-01-03 10 0.11166749981542429 0.0992622218405207
0.10057527786896875 2159912.379166667 8388604.0
+2017-01-03 11 0.10902583400408426 0.10831500006218751
0.10890444340184331 2159957.9375 8388604.0
+2017-01-03 12 0.11022166566302379 0.08308555521070957
0.07808333370679368 2159977.825 8388604.0
+2017-01-03 13 0.09131916643430789 0.10051250047981738
0.09484805539250374 2159764.154166667 8388604.0
+2017-01-03 14 0.10627000058690707 0.10664000002046427
0.12761138857846768 2159925.5791666666 8388604.0
+2017-01-03 15 0.1186027771482865 0.09735888863603274
0.09518999961825708 2160024.1708333334 8388604.0
+2017-01-03 16 0.09364305542161068 0.09928194458285967
0.10330888799314077 2159767.808333333 8388604.0
+2017-01-03 17 0.08179833373675743 0.07355138879890243
0.06907388894663503 2159958.6666666665 8388604.0
+2017-01-03 18 0.11627833272020022 0.11544333299001058
0.11665305566663543 2159795.4166666665 8388604.0
+2017-01-03 19 0.08969527818262577 0.0845941667134563
0.09310777739156037 2159725.275 8388604.0
+2017-01-03 20 0.11439222258826097 0.11282916689912478
0.11416083332927277 2159704.8125 8388604.0
+2017-01-03 21 0.11115861137708029 0.09447166634102662
0.10062500031975409 2159820.35 8388604.0
+2017-01-03 22 0.0789297226195534 0.09867638933161894
0.11645444434058543 2159670.7125 8388604.0
+2017-01-03 23 0.09039777809133133 0.07828999987492959
0.0749988882103935 2159820.475 8388604.0
+2017-01-04 0 0.09144805576652289 0.1059711108294626
0.09972944387312357 2159546.966666667 8388604.0
+2017-01-04 1 0.14011888777216275 0.1392694445947806
0.14483611073810607 2159838.1375 8388604.0
+2017-01-04 2 0.12267083252469699 0.09988777774075668
0.10562166729941964 2159638.3625 8388604.0
+2017-01-04 3 0.08219250037024418 0.08414944382384419
0.08401111128429571 2159485.908333333 8388604.0
+2017-01-04 4 0.10787166642645994 0.12027194499969482
0.11356499836159249 2158027.8208333333 8388604.0
+2017-01-04 5 0.1191363883515199 0.09875972252339124
0.10850583375043546 2159512.029166667 8388604.0
+2017-01-04 6 0.09163138878842195 0.09442500015720726
0.09266166568074065 2159091.2125 8388604.0
+2017-01-04 7 0.09982722153266271 0.08437194420645634
0.08015055571837972 2158777.3916666666 8388604.0
+2017-01-04 8 0.10133777769903342 0.09118944387882948
0.08264638890589898 2158855.4916666667 8388604.0
+2017-01-04 9 0.08981722226987282 0.10164055532465378
0.09779472219524905 2158757.125 8388604.0
+2017-01-04 10 0.11853444452087085 0.09684166616449753
0.0965783328594019 2158859.191666667 8388604.0
+2017-01-04 11 0.11727194388707479 0.09830833400289217
0.09789777753564219 2158554.4791666665 8388604.0
+2017-01-04 12 0.10132972213129203 0.09658222198486328
0.0999491670615195 2158896.575 8388604.0
+2017-01-04 13 0.11128361038863659 0.10659083351492882
0.10543388822115958 2158737.845833333 8388604.0
+2017-01-04 14 0.09594555577884117 0.08428166648373007
0.08276361142052338 2158608.025 8388604.0
+2017-01-04 15 0.10805555457870165 0.10575361143176755
0.10401194412067222 2158767.058333333 8388604.0
+2017-01-04 16 0.11955472143987815 0.11092999953155716
0.10593249983697509 2158746.0416666665 8388604.0
+2017-01-04 17 0.1199708325167497 0.10015722208966811
0.09378666628035717 2158559.3625 8388604.0
+2017-01-04 18 0.10466527709116538 0.11163638783618808
0.11287583271429563 2158610.966666667 8388604.0
+2017-01-04 19 0.1041152777771155 0.08298000056917469
0.07214083339107068 2158338.6083333334 8388604.0
+2017-01-04 20 0.08938333292802175 0.11257583300272624
0.1211222217263033 2158588.6666666665 8388604.0
+2017-01-04 21 0.08806083338956038 0.0801861109988143
0.06615805615001591 2158472.183333333 8388604.0
+2017-01-04 22 0.09270361165205637 0.09680277754863104
0.10423916654156831 2158592.875 8388604.0
+2017-01-04 23 0.08201500028371811 0.08325611098359029
0.08631694439439647 2158481.433333333 8388604.0
+2017-01-05 0 0.0717125004157424 0.08324749997506539
0.08501305555158373 2158695.9583333335 8388604.0
+2017-01-05 1 0.11306388825178146 0.1021972224737207
0.0872533325649177 2158628.3958333335 8388604.0
+2017-01-05 2 0.13312555551528932 0.12725722243388493
0.12862388936434097 2158665.6375 8388604.0
+2017-01-05 3 0.13934444412589073 0.1324788889537255
0.13653222215361893 2157396.7125 8388604.0
+2017-01-05 4 0.14370694421231747 0.12981777663032215
0.14072833293078776 2155651.216666667 8388604.0
+2017-01-05 5 0.1403319432089726 0.13922999979307255
0.14209944442845882 2156797.2875 8388604.0
+2017-01-05 6 0.12512749855717023 0.10534750067939361
0.10296472245778811 2157300.9375 8388604.0
+2017-01-05 7 0.13472472143669922 0.12085194494575262
0.11856944411896014 2157813.65 8388604.0
+2017-01-05 8 0.10596499977012476 0.08730222253749768
0.09061055544298142 2157630.7916666665 8388604.0
+2017-01-05 9 0.09839194479087988 0.08596749994903803
0.07934388877668729 2157551.466666667 8388604.0
+2017-01-05 10 0.09058222187062105 0.10841277812918028
0.11727638838735098 2157664.95 8388604.0
+2017-01-05 11 0.11202916651964187 0.09312694423521559
0.0871952785179019 2157377.9125 8388604.0
+2017-01-05 12 0.12679055494566757 0.11457722214981914
0.12212222265273644 2157558.1458333335 8388604.0
+2017-01-05 13 0.07202888894826173 0.07222666672120491
0.08037555555735404 2157626.95 8388604.0
+2017-01-05 14 0.10506222229450941 0.11781222249070804
0.12231833232751038 2157781.783333333 8388604.0
+2017-01-05 15 0.10378055541465679 0.09676000062997142
0.10480055537385245 2157442.65 8388604.0
+2017-01-05 16 0.1224249995003144 0.10287333379189173
0.1042575004665802 2157471.3375 8388604.0
+2017-01-05 17 0.11276777721941471 0.09595166662087043
0.09540694400202483 2157592.2083333335 8388604.0
+2017-01-05 18 0.10727083310484886 0.09358222257966796
0.09164000028201068 2157496.558333333 8388604.0
+2017-01-05 19 0.12457777708768844 0.11393722270925839
0.09907527711087218 2157470.220833333 8388604.0
+2017-01-05 20 0.12004749998450279 0.10250833251823982
0.09964777772159626 2157689.183333333 8388604.0
+2017-01-05 21 0.09280749969184399 0.08252055554961164
0.07384833312050129 2157615.966666667 8388604.0
+2017-01-05 22 0.12193222126613061 0.1165772213290135
0.13440000043871503 2157412.325 8388604.0
+2017-01-05 23 0.12363944388926029 0.10315083401898544
0.09123750037979335 2157480.425 8388604.0
+2017-01-06 0 0.14606888890266417 0.14045694426943858
0.14151888871371435 2157526.8916666666 8388604.0
+2017-01-06 1 0.11137166656553746 0.08777305539697408
0.07703472280797238 2157528.0708333333 8388604.0
+2017-01-06 2 0.09189194391171138 0.08420805508891742
0.08945388836630931 2157556.9791666665 8388604.0
+2017-01-06 3 0.11062361095100641 0.1174763890914619
0.12368166734231636 2156442.5833333335 8388604.0
+2017-01-06 4 0.15077444252868494 0.1336122221002976
0.14231250034257148 2154126.595833333 8388604.0
+2017-01-06 5 0.08335222204526266 0.08269611115877827
0.09117472184589133 2155150.8375 8388604.0
+2017-01-06 6 0.08438222203403711 0.08668333354095618
0.07395861129819727 2155560.65 8388604.0
+2017-01-06 7 0.10765249965091546 0.10485277759532134
0.10753749987731377 2156069.004166667 8388604.0
+2017-01-06 8 0.11446972172707319 0.09703583338608344
0.08741638879291713 2156031.075 8388604.0
+2017-01-06 9 0.06034638875474532 0.07753249984234571
0.08067666665301658 2155965.375 8388604.0
+2017-01-06 10 0.09297333341091871 0.10178500022739172
0.10280888836520413 2155782.495833333 8388604.0
+2017-01-06 11 0.09418888924022516 0.07414861085514228
0.06712055572813067 2155963.316666667 8388604.0
+2017-01-06 12 0.08447166650245587 0.08856000021720926
0.08750777832853297 2155933.2375 8388604.0
+2017-01-06 13 0.10033833322425684 0.09205083319296439
0.10012944373496187 2156056.5083333333 8388604.0
+2017-01-06 14 0.12480916579564412 0.11884888854498664
0.11095666622277349 2155958.2 8388604.0
+2017-01-06 15 0.10974416583776474 0.09111055533091227
0.09935527763833912 2156070.2875 8388604.0
+2017-01-06 16 0.09751916670550903 0.08861972233280539
0.0855072219739668 2155921.0375 8388604.0
+2017-01-06 17 0.07831722212334474 0.08212027785678705
0.07779611045261844 2155709.754166667 8388604.0
+2017-01-06 18 0.05849805548787117 0.0752005553804338
0.06946805582071344 2155935.3125 8388604.0
+2017-01-06 19 0.10868555543323358 0.11651527745028337
0.1208350005482013 2155951.129166667 8388604.0
+2017-01-06 20 0.12161388831833998 0.10482305486996969
0.09871472232431794 2155670.2041666666 8388604.0
+2017-01-06 21 0.12383972133199374 0.10861527801801761
0.09750805590689803 2155606.879166667 8388604.0
+2017-01-06 22 0.11690166592597961 0.10696944442267219
0.11853694523839901 2155773.7708333335 8388604.0
+2017-01-06 23 0.1241477768868208 0.10161472236116727
0.10429055508575402 2155512.175 8388604.0
+2017-01-07 0 0.13435361062486967 0.127694444420437
0.13321777830521267 2155834.0875 8388604.0
+2017-01-07 1 0.11266194432973861 0.09735861128817001
0.09657888838555664 2155860.3041666667 8388604.0
+2017-01-07 2 0.11044749952852725 0.09410805537675818
0.09852555607018681 2155723.025 8388604.0
+2017-01-07 3 0.08386305558184783 0.08519916646182538
0.08837527875051213 2154415.5541666667 8388604.0
+2017-01-07 4 0.1288394436240196 0.1224238890533646
0.12212777726623851 2153784.0416666665 8388604.0
+2017-01-07 5 0.11153138789037863 0.09476888900001844
0.10457305494540682 2155218.7666666666 8388604.0
+2017-01-07 6 0.13171166591346264 0.12011250002930561
0.12435944453657916 2154716.6375 8388604.0
+2017-01-07 7 0.1250991656134526 0.10306833405047655
0.09455527810302253 2154865.1625 8388604.0
+2017-01-07 8 0.08763083343704542 0.07407583314925432
0.075451945020662 2154932.4791666665 8388604.0
+2017-01-07 9 0.10922749992460012 0.11359805551668008
0.1197013890525947 2154903.966666667 8388604.0
+2017-01-07 10 0.10072972203294436 0.08804055557896694
0.07780888887355104 2154806.4541666666 8388604.0
+2017-01-07 11 0.10521750040352344 0.10553583341340224
0.11668888939311728 2154747.404166667 8388604.0
+2017-01-07 12 0.12571166617174942 0.10943888947367668
0.10949555593542755 2154755.6 8388604.0
+2017-01-07 13 0.1249544436732928 0.10555499953528245
0.09935222254037702 2154928.1791666667 8388604.0
+2017-01-07 14 0.12590833206971486 0.11718000036974748
0.11581166570928568 2154793.3208333333 8388604.0
+2017-01-07 15 0.09265305530279874 0.09002861107389132
0.10350138941187954 2154600.504166667 8388604.0
+2017-01-07 16 0.09222888884445031 0.08801750003670653
0.09472444411367179 2154554.7958333334 8388604.0
+2017-01-07 17 0.10075027775019407 0.08458694421375791
0.0766372220115348 2154598.1041666665 8388604.0
+2017-01-07 18 0.10147361134489377 0.1008458336815238
0.10167166577884927 2154738.029166667 8388604.0
+2017-01-07 19 0.09666888838013013 0.10691555549080173
0.11004722161063303 2154661.1041666665 8388604.0
+2017-01-07 20 0.10799333316584428 0.08293166682124138
0.07982333340575375 2154369.4291666667 8388604.0
+2017-01-07 21 0.10198527785638968 0.0947680555904905
0.09041472262082001 2154595.566666667 8388604.0
+2017-01-07 22 0.06630444433540106 0.07041638844336072
0.06661194454839764 2154370.2666666666 8388604.0
+2017-01-07 23 0.10210361083348592 0.11088194443533818
0.10942583287833259 2150071.5416666665 8388604.0
+2017-01-08 0 0.07928777808944384 0.06945944475010038
0.06329444413422607 2146417.066666667 8388604.0
+2017-01-08 1 0.07957833347221216 0.09387944480404257
0.10099555531342048 2146481.654166667 8388604.0
+2017-01-08 2 0.10864666601022084 0.08729694460829099
0.07111861132240543 2146330.325 8388604.0
+2017-01-08 3 0.11374444402754307 0.10025749920556942
0.10012444289168343 2145088.841666667 8388604.0
+2017-01-08 4 0.11595472171902657 0.12547527768959602
0.1329413877557575 2144110.78125 8388604.0
+2017-01-08 5 0.11365055528779824 0.09868472249557575
0.09432444457391588 2146392.85 8388604.0
+2017-01-08 6 0.1237236101180315 0.10569250031063954
0.09282444434308369 2145716.6375 8388604.0
+2017-01-08 7 0.1273477764179309 0.11354888814191023
0.11857166656603416 2145075.995833333 8388604.0
+2017-01-08 8 0.1365463883926471 0.12374055478721857
0.11750666686906092 2145025.8916666666 8388604.0
+2017-01-08 9 0.10061083336671194 0.08410111144185066
0.08406888877119248 2145091.4 8388604.0
+2017-01-08 10 0.07494166692097982 0.08576333324114481
0.08346583335951437 2145428.2416666667 8388604.0
+2017-01-08 11 0.11485749942560991 0.10503555536270141
0.11680527763868061 2145330.1625 8388604.0
+2017-01-08 12 0.1283133325477441 0.11136361124614874
0.10050805536253998 2145388.3125 8388604.0
+2017-01-08 13 0.10609694384038448 0.08837166621039311
0.09538111087458674 2145153.216666667 8388604.0
+2017-01-08 14 0.11839194459219773 0.1052236121147871
0.10144666717969812 2145024.7125 8388604.0
+2017-01-08 15 0.09263500006248554 0.0926441668222348
0.09044222203083337 2145151.970833333 8388604.0
+2017-01-08 16 0.09664055556058884 0.0930036108319958
0.09533194417017513 2145103.2416666667 8388604.0
+2017-01-08 17 0.06105749998241663 0.06733222197120388
0.06546500023202194 2144911.6166666667 8388604.0
+2017-01-08 18 0.074573610847195 0.09279388897120952
0.08531583284493535 2145046.2375 8388604.0
+2017-01-08 19 0.11674749925732612 0.09787583397701383
0.08649083361863935 2144829.9875 8388604.0
+2017-01-08 20 0.08550277824203173 0.08478749990463257
0.08639666639452723 2144794.4291666667 8388604.0
+2017-01-08 21 0.07088916655629873 0.0892022222901384
0.09048222200556968 2144966.25 8388604.0
+2017-01-08 22 0.067472777950267 0.07679611078153054
0.06936250049620866 2145056.4458333333 8388604.0
+2017-01-08 23 0.1028036108861367 0.10487194489687682
0.0997247223785962 2144932.4 8388604.0
+2017-01-09 0 0.08686416670680046 0.07989500022182862
0.0797291667414053 2144815.933333333 8388604.0
+2017-01-09 1 0.09337972303231558 0.10032694392527143
0.09999194341459466 2144916.1 8388604.0
+2017-01-09 2 0.1429738877962033 0.14393972226728996
0.14694749957561726 2144887.275 8388604.0
+2017-01-09 3 0.12775055555005868 0.10705388899271687
0.09926499930443242 2144506.3041666667 8388604.0
+2017-01-09 4 0.11586888867119947 0.10868083300689856
0.10546805601916276 2142843.5416666665 8388604.0
+2017-01-09 5 0.12128638811409473 0.10324638883272806
0.09664888834959129 2144009.7291666665 8388604.0
+2017-01-09 6 0.10399999978641669 0.09181944423665603
0.1055166674220042 2144019.120833333 8388604.0
+2017-01-09 7 0.10574999985595544 0.0880688891435663
0.08677805519352357 2144813.45 8388604.0
+2017-01-09 8 0.08093388881534339 0.08687000007679065
0.08736222253792221 2144926.254166667 8388604.0
+2017-01-09 9 0.07157888878136873 0.08808944430202245
0.08809166579352071 2144657.225 8388604.0
+2017-01-09 10 0.08930805536607901 0.10994416624307632
0.11131361009708295 2144612.625 8388604.0
+2017-01-09 11 0.13514194438854854 0.1260155559827884
0.11910888880180816 2144762.529166667 8388604.0
+2017-01-09 12 0.11260611079633236 0.10002361045529445
0.08598333332144345 2144622.7291666665 8388604.0
+2017-01-09 13 0.1237541655699412 0.11025777760272225
0.10604361070436426 2144595.8333333335 8388604.0
+2017-01-09 14 0.1211983331789573 0.10637722300986449
0.09917222214862705 2144751.6875 8388604.0
+2017-01-09 15 0.11224861070513725 0.10060722194612026
0.10282222194655333 2144647.95 8388604.0
+2017-01-09 16 0.07829361117134491 0.07683305572718382
0.0706611111954165 2144523.5875 8388604.0
+2017-01-09 17 0.09476111127684514 0.10311888922005892
0.09811972212628461 2144522.0 8388604.0
+2017-01-09 18 0.11918777724107106 0.10715472232550383
0.10485555498550335 2144547.3375 8388604.0
+2017-01-09 19 0.13063638806343078 0.115411944873631
0.12053555569533879 2144669.3375 8388604.0
+2017-01-09 20 0.10678861116369566 0.0969991664091746
0.0955752778487901 2144548.1416666666 8388604.0
+2017-01-09 21 0.13010999796291192 0.12142499970893066
0.12543805516712989 2144554.683333333 8388604.0
+2017-01-09 22 0.11708944427470366 0.1015227776641647
0.08944388832896948 2144577.120833333 8388604.0
+2017-01-09 23 0.09211972200622161 0.08930694479495287
0.09782361215135703 2144540.6625 8388604.0
+2017-01-10 0 0.09406444436560074 0.09819472230349978
0.09566749897785484 2144636.4916666667 8388604.0
+2017-01-10 1 0.12067027712861697 0.10580361181249222
0.09652722170188402 2144368.9833333334 8388604.0
+2017-01-10 2 0.11325999970237415 0.09469277715931336
0.1030455559414501 2144448.5166666666 8388604.0
+2017-01-10 3 0.12430611078937849 0.12068416643887758
0.1323119441512972 2143543.4 8388604.0
+2017-01-10 4 0.16184916533529758 0.15386027805507183
0.1606997221087416 2142588.7354166666 8388604.0
+2017-01-10 5 0.11823138830562432 0.09743527763833602
0.08917388876434415 2144151.308333333 8388604.0
+2017-01-10 6 0.11151333327094713 0.09798611116906007
0.0899802777528142 2144240.925 8388604.0
+2017-01-10 7 0.11213833279907703 0.09176611105600993
0.07756277737983813 2144293.566666667 8388604.0
+2017-01-10 8 0.10404833319286505 0.08997944385434191
0.10099055465931693 2144211.2125 8388604.0
+2017-01-10 9 0.1256466665615638 0.12132472206527987
0.11302694410357314 2144566.1791666667 8388604.0
+2017-01-10 10 0.11986666607360046 0.10056249996026358
0.10170555556154189 2144418.9583333335 8388604.0
+2017-01-10 11 0.09797444393237432 0.08230277765542268
0.0863263887775247 2144463.3291666666 8388604.0
+2017-01-10 12 0.08722222186625003 0.09509111071626346
0.09908944451550876 2144219.1 8388604.0
+2017-01-10 13 0.09324222225695848 0.08891638843342661
0.09115111070180622 2144258.7583333333 8388604.0
+2017-01-10 14 0.10688805505633354 0.10064546348940995
0.09340509343310259 2144284.191666667 8388604.0
+2017-01-10 15 0.11199437437268595 0.11553569488072148
0.11783152756919056 2144295.975 8388604.0
+2017-01-10 16 0.1355276377250751 0.12841388882758717
0.12610298692816285 2144386.622916667 8388604.0
+2017-01-10 17 0.10659680521736542 0.0840172913701584
0.09128215299375976 2144285.4614583333 8388604.0
+2017-01-10 18 0.11573840187241634 0.10678500034846365
0.118531527951806 2144309.767708333 8388604.0
+2017-01-10 19 0.11204027704273661 0.09901951358187944
0.09587777826818637 2144150.75625 8388604.0
+2017-01-10 20 0.09373222224724789 0.08531534740856538
0.08557562555312567 2144084.2427083333 8388604.0
+2017-01-10 21 0.11311305497462551 0.09948694425014158
0.09770791523963757 2144066.480208333 8388604.0
+2017-01-10 22 0.07009770831403633 0.07559298606744656
0.07958479082590202 2144082.528125 8388604.0
+2017-01-10 23 0.10556617993861436 0.10134374992921949
0.09745208402697851 2144062.035416667 8388604.0
+2017-01-11 0 0.14252777686342596 0.1363573615749677
0.13698284631536808 2144168.9166666665 8388604.0
+2017-01-11 1 0.10343902761427065 0.09217958309842894
0.09731041602305292 2144060.439583333 8388604.0
+2017-01-11 2 0.07343770829029381 0.07530659704934806
0.06305951394606382 2144201.1010416667 8388604.0
+2017-01-11 3 0.0733546530517439 0.08935868052455286
0.10009062532917597 2143860.642708333 8388604.0
+2017-01-11 4 0.12063319447139899 0.11820798648210863
0.11340687386376279 2141860.246354167 8388604.0
+2017-01-11 5 0.11260131830349565 0.0981630556130161
0.10159437572813962 2143301.4010416665 8388604.0
+2017-01-11 6 0.08494430592594047 0.09440993017827472
0.10841118015329508 2143227.73125 8388604.0
+2017-01-11 7 0.09903027790909012 0.09638819481090953
0.08026854081448012 2143370.44375 8388604.0
+2017-01-11 8 0.12056861041734616 0.10728958272375166
0.10302326365223659 2143393.1177083333 8388604.0
+2017-01-11 9 0.12784069332604606 0.11582201357620457
0.12336562562001442 2143220.683333333 8388604.0
+2017-01-11 10 0.12128131886323293 0.10299875005924454
0.09292083322628363 2143246.6770833335 8388604.0
+2017-01-11 11 0.11190687436610461 0.09209749967170258
0.09161652755865361 2143272.5614583334 8388604.0
+2017-01-11 12 0.12043069284409284 0.09808347254681091
0.09894513917291382 2143276.6302083335 8388604.0
+2017-01-11 13 0.10197715247049928 0.0913445135888954
0.08603423684689915 2143382.40625 8388604.0
+2017-01-11 14 0.11532607750268653 0.08677697146777064
0.07936718878045212 2143348.34765625 8388604.0
+
diff --git a/regression-test/data/brown_p2/sql/blockedIOServer.out
b/regression-test/data/brown_p2/sql/blockedIOServer.out
new file mode 100644
index 0000000000..d4fea034bb
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/blockedIOServer.out
@@ -0,0 +1,13 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !blockedIOServer --
+sourpatch 8861
+louie 581
+zotz 555
+pieces 498
+reeces 453
+thing 438
+adminhost 366
+cadbury 357
+york 194
+reflect 156
+
diff --git a/regression-test/data/brown_p2/sql/dailyUV.out
b/regression-test/data/brown_p2/sql/dailyUV.out
new file mode 100644
index 0000000000..78dbe0ec8f
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/dailyUV.out
@@ -0,0 +1,369 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !dailyUV --
+2012-01-01 9464
+2012-01-02 11382
+2012-01-03 11413
+2012-01-04 11876
+2012-01-05 11610
+2012-01-06 10522
+2012-01-07 9056
+2012-01-08 9483
+2012-01-09 12149
+2012-01-10 12500
+2012-01-11 12331
+2012-01-12 11607
+2012-01-13 10145
+2012-01-14 8233
+2012-01-15 9138
+2012-01-16 11413
+2012-01-17 11865
+2012-01-18 12318
+2012-01-19 12319
+2012-01-20 11442
+2012-01-21 9093
+2012-01-22 9241
+2012-01-23 12055
+2012-01-24 13160
+2012-01-25 12735
+2012-01-26 13173
+2012-01-27 12410
+2012-01-28 9534
+2012-01-29 10628
+2012-01-30 13892
+2012-01-31 13681
+2012-02-01 14566
+2012-02-02 13999
+2012-02-03 12531
+2012-02-04 10471
+2012-02-05 11131
+2012-02-06 14995
+2012-02-07 14781
+2012-02-08 14615
+2012-02-09 13589
+2012-02-10 11967
+2012-02-11 9552
+2012-02-12 10457
+2012-02-13 14533
+2012-02-14 13200
+2012-02-15 13575
+2012-02-16 13269
+2012-02-17 11919
+2012-02-18 9294
+2012-02-19 10368
+2012-02-20 12920
+2012-02-21 3298
+2012-02-22 13412
+2012-02-23 13353
+2012-02-24 11744
+2012-02-25 10341
+2012-02-26 11355
+2012-02-27 14205
+2012-02-28 14691
+2012-02-29 14590
+2012-03-01 13439
+2012-03-02 11875
+2012-03-03 9900
+2012-03-04 12420
+2012-03-05 15147
+2012-03-06 14205
+2012-03-07 13766
+2012-03-08 13193
+2012-03-09 11939
+2012-03-10 9954
+2012-03-11 10457
+2012-03-12 13528
+2012-03-13 13540
+2012-03-14 13250
+2012-03-15 12861
+2012-03-16 11208
+2012-03-17 9257
+2012-03-18 9941
+2012-03-19 12940
+2012-03-20 13158
+2012-03-21 12266
+2012-03-22 11877
+2012-03-23 10186
+2012-03-24 8098
+2012-03-25 8791
+2012-03-26 11994
+2012-03-27 11630
+2012-03-28 11552
+2012-03-29 11022
+2012-03-30 10237
+2012-03-31 8493
+2012-04-01 9869
+2012-04-02 12315
+2012-04-03 12065
+2012-04-04 11836
+2012-04-05 11188
+2012-04-06 9761
+2012-04-07 8852
+2012-04-08 9271
+2012-04-09 11611
+2012-04-10 12256
+2012-04-11 11936
+2012-04-12 11692
+2012-04-13 13339
+2012-04-14 30046
+2012-04-15 10236
+2012-04-16 13208
+2012-04-17 12856
+2012-04-18 12781
+2012-04-19 11944
+2012-04-20 10763
+2012-04-21 8479
+2012-04-22 10192
+2012-04-23 12908
+2012-04-24 12588
+2012-04-25 13535
+2012-04-26 12538
+2012-04-27 10702
+2012-04-28 8283
+2012-04-29 8993
+2012-04-30 11582
+2012-05-01 11469
+2012-05-02 11958
+2012-05-03 11523
+2012-05-04 10460
+2012-05-05 8238
+2012-05-06 9251
+2012-05-07 12342
+2012-05-08 12194
+2012-05-09 12179
+2012-05-10 11738
+2012-05-11 10725
+2012-05-12 8508
+2012-05-13 9220
+2012-05-14 12960
+2012-05-15 12011
+2012-05-16 11788
+2012-05-17 11198
+2012-05-18 9339
+2012-05-19 7373
+2012-05-20 8505
+2012-05-21 11283
+2012-05-22 11776
+2012-05-23 11445
+2012-05-24 11229
+2012-05-25 10334
+2012-05-26 8966
+2012-05-27 8701
+2012-05-28 10714
+2012-05-29 11916
+2012-05-30 11940
+2012-05-31 11386
+2012-06-01 10153
+2012-06-02 8810
+2012-06-03 9025
+2012-06-04 20195
+2012-06-05 14711
+2012-06-06 11617
+2012-06-07 10607
+2012-06-08 9604
+2012-06-09 8028
+2012-06-10 8256
+2012-06-11 10914
+2012-06-12 10558
+2012-06-13 10633
+2012-06-14 10349
+2012-06-15 9443
+2012-06-16 7607
+2012-06-17 8375
+2012-06-18 11686
+2012-06-19 12042
+2012-06-20 10871
+2012-06-21 10461
+2012-06-22 10466
+2012-06-23 7605
+2012-06-24 8195
+2012-06-25 11002
+2012-06-26 11185
+2012-06-27 10802
+2012-06-28 10281
+2012-06-29 9126
+2012-06-30 7269
+2012-07-01 7623
+2012-07-02 9949
+2012-07-03 10692
+2012-07-04 9158
+2012-07-05 9778
+2012-07-06 9085
+2012-07-07 7551
+2012-07-08 8140
+2012-07-09 10787
+2012-07-10 10434
+2012-07-11 10173
+2012-07-12 9896
+2012-07-13 9134
+2012-07-14 7417
+2012-07-15 7702
+2012-07-16 10235
+2012-07-17 10885
+2012-07-18 10523
+2012-07-19 10458
+2012-07-20 9131
+2012-07-21 6962
+2012-07-22 7347
+2012-07-23 9808
+2012-07-24 10157
+2012-07-25 13455
+2012-07-26 12637
+2012-07-27 9487
+2012-07-28 6958
+2012-07-29 8134
+2012-07-30 12233
+2012-07-31 10179
+2012-08-01 9489
+2012-08-02 9706
+2012-08-03 8889
+2012-08-04 6963
+2012-08-05 7701
+2012-08-06 11219
+2012-08-07 8976
+2012-08-08 11288
+2012-08-09 10165
+2012-08-10 9211
+2012-08-11 7621
+2012-08-12 8274
+2012-08-13 11478
+2012-08-14 11230
+2012-08-15 10820
+2012-08-16 10991
+2012-08-17 10694
+2012-08-18 8628
+2012-08-19 8884
+2012-08-20 11310
+2012-08-21 12103
+2012-08-22 12548
+2012-08-23 15555
+2012-08-24 12083
+2012-08-25 9601
+2012-08-26 9974
+2012-08-27 12052
+2012-08-28 9880
+2012-08-29 11600
+2012-08-30 11680
+2012-08-31 10422
+2012-09-01 8537
+2012-09-02 9255
+2012-09-03 12090
+2012-09-04 13570
+2012-09-05 13997
+2012-09-06 13798
+2012-09-07 12636
+2012-09-08 9995
+2012-09-09 11256
+2012-09-10 15346
+2012-09-11 15427
+2012-09-12 15573
+2012-09-13 14694
+2012-09-14 13139
+2012-09-15 10435
+2012-09-16 11707
+2012-09-17 14855
+2012-09-18 15282
+2012-09-19 14402
+2012-09-20 14837
+2012-09-21 13607
+2012-09-22 10750
+2012-09-23 12386
+2012-09-24 15462
+2012-09-25 15638
+2012-09-26 16064
+2012-09-27 15045
+2012-09-28 13698
+2012-09-29 11729
+2012-09-30 12957
+2012-10-01 14258
+2012-10-02 15351
+2012-10-03 14714
+2012-10-04 15203
+2012-10-05 13435
+2012-10-06 11231
+2012-10-07 12674
+2012-10-08 15389
+2012-10-09 15715
+2012-10-10 15579
+2012-10-11 15084
+2012-10-12 13615
+2012-10-13 12777
+2012-10-14 12870
+2012-10-15 18302
+2012-10-16 16586
+2012-10-17 15063
+2012-10-18 14492
+2012-10-19 13505
+2012-10-20 11501
+2012-10-21 13148
+2012-10-22 17130
+2012-10-23 15826
+2012-10-24 15068
+2012-10-25 15063
+2012-10-26 15787
+2012-10-27 11350
+2012-10-28 13272
+2012-10-29 15407
+2012-10-30 15709
+2012-10-31 15700
+2012-11-01 15375
+2012-11-02 14998
+2012-11-03 13348
+2012-11-04 14345
+2012-11-05 16714
+2012-11-06 16522
+2012-11-07 16424
+2012-11-08 16168
+2012-11-09 14432
+2012-11-10 12671
+2012-11-11 13620
+2012-11-12 16696
+2012-11-13 16493
+2012-11-14 17225
+2012-11-15 17355
+2012-11-16 15011
+2012-11-17 12901
+2012-11-18 14518
+2012-11-19 27613
+2012-11-20 23275
+2012-11-21 17657
+2012-11-22 14317
+2012-11-23 12899
+2012-11-24 12089
+2012-11-25 10838
+2012-11-26 16263
+2012-11-27 16530
+2012-11-28 16253
+2012-11-29 15525
+2012-11-30 13233
+2012-12-01 11266
+2012-12-02 12816
+2012-12-03 17287
+2012-12-04 17340
+2012-12-05 15726
+2012-12-06 15408
+2012-12-07 508
+2012-12-08 11204
+2012-12-09 12924
+2012-12-10 15325
+2012-12-11 15117
+2012-12-12 14005
+2012-12-13 13310
+2012-12-14 11731
+2012-12-15 10734
+2012-12-16 11355
+2012-12-17 13305
+2012-12-18 13160
+2012-12-19 12329
+2012-12-20 9592
+2012-12-21 863
+2012-12-22 816
+2012-12-23 794
+2012-12-24 727
+2012-12-25 8062
+2012-12-26 8799
+2012-12-27 9435
+2012-12-28 9185
+2012-12-29 8247
+2012-12-30 8328
+2012-12-31 7824
+
diff --git a/regression-test/data/brown_p2/sql/dataTransferRate.out
b/regression-test/data/brown_p2/sql/dataTransferRate.out
new file mode 100644
index 0000000000..8ef4a0ec76
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/dataTransferRate.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !dataTransferRate --
+0.0046296999419207785 295.028835936
+
diff --git a/regression-test/data/brown_p2/sql/doorOpen.out
b/regression-test/data/brown_p2/sql/doorOpen.out
new file mode 100644
index 0000000000..f47bfbda56
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/doorOpen.out
@@ -0,0 +1,23 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !doorOpen --
+front_right_1 1 64269
+front_center_1 1 37054
+loading_dock_1 1 27284
+lobby_center_2 2 19123
+front_left_1 1 14679
+stairs_east_3 3 12773
+stairs_north_2 2 11208
+stairs_north_1 1 9874
+balcony_5 5 5284
+stairs_east_left_2 2 4646
+stairs_north_4 4 4086
+lobby_left_2 2 4029
+stairs_east_right_2 2 3140
+lobby_right_2 2 3108
+lobby_left_1 1 2944
+stairs_north_5 5 1731
+lobby_right_1 1 1641
+stairs_east_5 5 1637
+balcony_3 3 1619
+stairs_east_4 4 1093
+
diff --git a/regression-test/data/brown_p2/sql/excessiveRequests.out
b/regression-test/data/brown_p2/sql/excessiveRequests.out
new file mode 100644
index 0000000000..f163843e7d
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/excessiveRequests.out
@@ -0,0 +1,11 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !excessiveRequests --
+219.63.173.93 1540391
+229.50.247.232 743801
+97.211.80.244 733261
+152.149.228.251 492221
+198.156.249.133 370834
+70.86.124.37 273057
+67.153.111.239 167287
+249.92.17.134 112909
+
diff --git a/regression-test/data/brown_p2/sql/hourlyNetworkTraffic.out
b/regression-test/data/brown_p2/sql/hourlyNetworkTraffic.out
new file mode 100644
index 0000000000..de8e36c6b9
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/hourlyNetworkTraffic.out
@@ -0,0 +1,13 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !hourlyNetworkTraffic --
+2017-01-10 17 87.94858538 71.385253825 159.333839205
+2017-01-10 18 89.649306783 69.156060259 158.805367042
+2017-01-10 19 73.60724926 81.407222077 155.014471337
+2017-01-10 20 68.547946313 85.506676673 154.054622986
+2017-01-11 13 42.000689907 69.613847012 111.614536919
+2017-01-10 16 52.184352597 56.948349728 109.132702325
+2017-01-10 15 58.921870661 47.700976292 106.622846953
+2017-01-10 14 60.98027363 44.44881962 105.42909325
+2017-01-10 21 45.797732305 54.048210813 99.845943118
+2017-01-11 4 48.962175923 48.376258854 97.338434777
+
diff --git a/regression-test/data/brown_p2/sql/lowMemory.out
b/regression-test/data/brown_p2/sql/lowMemory.out
new file mode 100644
index 0000000000..b0712933d4
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/lowMemory.out
@@ -0,0 +1,19 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !lowMemory --
+chimera 2016-11-04 6135.48
+chimera 2016-11-26 6045.8667
+chimera 2016-11-27 9374.526
+chimera 2016-11-30 6933.56
+chimera 2016-12-01 6535.8135
+chimera 2016-12-02 6393.74
+chimera 2016-12-11 8010.5
+chimera 2016-12-30 8167.6665
+chimera 2016-12-31 6324.6665
+chimera 2017-01-01 5972.0
+chimera 2017-01-03 5948.0
+chimera 2017-01-04 7320.0
+chimera 2017-01-05 8144.0
+chimera 2017-01-07 6308.467
+chimera 2017-01-09 9370.0
+chimera 2017-01-10 7147.467
+
diff --git a/regression-test/data/brown_p2/sql/offlineMachine.out
b/regression-test/data/brown_p2/sql/offlineMachine.out
new file mode 100644
index 0000000000..75e57ec428
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/offlineMachine.out
@@ -0,0 +1,21 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !offlineMachine --
+cslab9e 2017-01-10T14:14:15
+cslab9e 2017-01-10T14:14:30
+cslab9e 2017-01-10T14:14:45
+cslab9e 2017-01-10T14:15:15
+cslab9e 2017-01-10T14:15:30
+cslab9e 2017-01-10T14:15:45
+cslab9e 2017-01-10T14:16:15
+cslab9e 2017-01-10T14:16:30
+cslab9e 2017-01-10T14:16:45
+cslab9e 2017-01-10T14:17:15
+cslab9e 2017-01-10T14:17:30
+cslab9e 2017-01-10T14:17:45
+cslab9e 2017-01-10T14:18:15
+cslab9e 2017-01-10T14:18:30
+cslab9e 2017-01-10T14:18:45
+cslab9e 2017-01-10T14:19:15
+cslab9e 2017-01-10T14:19:30
+cslab9e 2017-01-10T14:19:45
+
diff --git a/regression-test/data/brown_p2/sql/passwordLeaked.out
b/regression-test/data/brown_p2/sql/passwordLeaked.out
new file mode 100644
index 0000000000..e86f120f27
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/passwordLeaked.out
@@ -0,0 +1,5 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !passwordLeaked --
+2012-05-09T14:46:58 201.183.185.11 /?-nd+auto_prepend_file%3D/etc/passwd
200 21173
+2012-05-13T20:17:05 201.183.185.11 /?-nd+auto_prepend_file%3D/etc/passwd
200 21809
+
diff --git a/regression-test/data/brown_p2/sql/powerConsumptionMetrics.out
b/regression-test/data/brown_p2/sql/powerConsumptionMetrics.out
new file mode 100644
index 0000000000..46fde47fd6
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/powerConsumptionMetrics.out
@@ -0,0 +1,31 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !powerConsumptionMetrics --
+2017 9 721638.3414064787 1252.844342719581
65268.73919188455 113.31378331924401 174895.7715174624
330.6158251747871 176421.94104524452 388.59458380009806
+2017 10 702508.0664338227 1256.7228379853716
66960.70685831291 120.0012667711701 131314.92843738294
270.75242976779987 212072.4254061825 379.3782207624016
+2017 11 903660.5956517102 1258.5802167851116
79376.14433888887 110.55173306251932 178488.04901201383
304.0682265962757 257457.2271247641 358.575525243404
+2017 12 931357.6830229171 1251.824842772738
76585.03687197335 102.93687751609322 112836.92815090143
198.6565636459532 241257.5071419921 324.27084293278506
+2018 1 800695.0232504867 1268.9303062606762
52913.86179851603 83.85715023536613 36392.480584571706
83.46899216644887 191628.70119383492 303.69049317564964
+2018 2 788872.0573169803 1188.060327284609
85621.32358955592 128.94777649029507 83922.79400835952
176.67956633338846 230227.25133465914 346.72778815460714
+2018 3 896816.2190436656 1205.3981438758947
88325.94803945153 118.71767209603699 114322.79839365481
193.7674549044997 269070.60609120084 361.6540404451624
+2018 4 581954.6102904761 1199.906412970054
55146.13846078817 113.70337826966633 107909.63419773092
260.6512903326834 172977.56835847028 356.6547801205573
+2018 5 810269.3225697614 1246.5681885688637 69687.035837944
107.2108243660677 83644.78159173671 143.47303875083483
248284.77976738196 381.9765842575107
+2018 6 824150.0588949085 1252.5076882901346
52047.1187370029 79.09896464590106 61491.795137032634
113.24455826341185 242561.98528653942 368.6352359977803
+2018 7 920527.3411698388 1237.2679316798908
54001.805264369934 72.58307159189508 110136.29401019627
175.65597130812802 284977.68054289324 383.0345168587275
+2018 8 934028.550349473 1255.4147182116574
56534.79015953162 75.98762118216615 18440.748190359896
37.25403674820181 281409.03078009834 378.2379445969064
+2018 9 796294.7250120316 1201.0478506968802
59750.627903558845 90.12161071426674 123357.51466599095
219.10748608524148 251368.5907741444 379.1381459640187
+2018 10 876930.3483784574 1178.6698230893244
68192.5478930525 91.65665039388777 161682.95582566154
259.9404434496166 285017.3815606403 383.0878784417208
+2018 11 220190.80577936105 1177.4909399965832
17258.73825754189 92.29271795476946 31282.50405975023
215.74140730862229 74832.72439675414 400.1749967740863
+2018 12 600604.6369429263 1213.3427008948006
40572.28465858767 81.96421143149024 45621.90108822518
103.21697078783978 174784.206063148 353.0994061881778
+2019 1 875861.8015196377 1177.2336041930614
62356.90803397391 83.81304843276062 38427.20028916451
68.37580122627136 266395.02450662036 358.0578286379306
+2019 2 766839.5051314121 1141.1302159693632
58769.955270648505 87.45529058132217 98888.76720553763
174.40699683516337 263572.6687568533 392.22123326912697
+2019 3 875531.8723175363 1176.7901509644305
64134.01856961813 86.20163786238996 137670.7954831731
220.9804100853501 307147.8785608933 412.83317010872753
+2019 4 882405.7822994066 1225.5635865269537
62498.886241078144 86.80400866816409 118655.91830720665
190.76514197300105 310192.1270515335 430.8223986826854
+2019 5 915804.9453381407 1230.9206254544902
62733.50787805465 84.31923101889065 51908.47672565358
92.36383759013093 333347.078499299 448.04714852056316
+2019 6 743714.4735556258 1264.820533257867
47914.37351050589 81.48702977977192 33701.157666174215
99.12105195933593 258663.94354479376 439.9046658925064
+2019 7 936697.9580959906 1259.0026318494497
60426.11789318785 81.2179003940697 10876.808554053554
30.213357094593206 322797.2259733417 433.86723921148075
+2019 8 930640.7550409792 1250.8612298937894
60639.08568100215 81.50414742070181 13063.088331067775
44.58391921866134 336075.4530245256 451.7143185813516
+2019 9 862784.4318728526 1198.3117109345176
63348.64890275067 87.98423458715371 56973.39566326607
126.32681965247465 322162.8453100057 447.4483962638968
+2019 10 900170.2429565527 1209.906240533001
64953.12136266855 87.30258247670504 98168.02805722516
218.63703353502265 310577.09491537133 417.4423318754991
+2019 11 881836.9061517069 1224.7734807662596
61941.828695957716 86.0303176332746 181716.37704881508
294.99411858573876 258322.18736711278 358.78081578765665
+2019 12 45118.354529795746 1253.2876258276597
2884.8668441554064 80.13519011542796 13576.481448950075
377.12448469305764 12249.124855753847 340.25346821538466
+
diff --git a/regression-test/data/brown_p2/sql/serverError.out
b/regression-test/data/brown_p2/sql/serverError.out
new file mode 100644
index 0000000000..20914216c0
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/serverError.out
@@ -0,0 +1,5 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !serverError --
+2012-12-21T16:58 229.50.247.232 //cgi-bin/feedback/ 500 410
+2012-12-23T23:28:02 229.50.247.232 //cgi-bin/feedback/ 500 410
+
diff --git a/regression-test/data/brown_p2/sql/temperatureReachFreezing.out
b/regression-test/data/brown_p2/sql/temperatureReachFreezing.out
new file mode 100644
index 0000000000..7998e75444
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/temperatureReachFreezing.out
@@ -0,0 +1,5 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !temperatureReachFreezing --
+2019-12-01T09:30:13 temperature 16C448031108ABA balcony_5 door
5 F 32.0
+2019-12-01T09:59:58 temperature 16C448031108ABA balcony_5 door
5 F 32.0
+
diff --git a/regression-test/data/brown_p2/sql/temperatureVariation_order.out
b/regression-test/data/brown_p2/sql/temperatureVariation_order.out
new file mode 100644
index 0000000000..d85e271ac1
--- /dev/null
+++ b/regression-test/data/brown_p2/sql/temperatureVariation_order.out
@@ -0,0 +1,14 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !temperatureVariation_order --
+balcony_3 door 3 SUMMER
+balcony_3 door 3 WINTER
+balcony_5 door 5 SUMMER
+balcony_5 door 5 WINTER
+front_center_1 door 1 SUMMER
+front_center_1 door 1 WINTER
+front_left_1 door 1 SUMMER
+front_left_1 door 1 WINTER
+front_right_1 door 1 SUMMER
+front_right_1 door 1 WINTER
+loading_dock_1 door 1 WINTER
+
diff --git a/regression-test/suites/brown_p2/ddl/logs1.sql
b/regression-test/suites/brown_p2/ddl/logs1.sql
new file mode 100644
index 0000000000..a6b3401ce5
--- /dev/null
+++ b/regression-test/suites/brown_p2/ddl/logs1.sql
@@ -0,0 +1,27 @@
+CREATE TABLE IF NOT EXISTS logs1 (
+ `log_time` DATETIME NOT NULL,
+ `machine_name` VARCHAR(128) NOT NULL,
+ `machine_group` VARCHAR(128) NOT NULL,
+ `cpu_idle` FLOAT,
+ `cpu_nice` FLOAT,
+ `cpu_system` FLOAT,
+ `cpu_user` FLOAT,
+ `cpu_wio` FLOAT,
+ `disk_free` FLOAT,
+ `disk_total` FLOAT,
+ `part_max_used` FLOAT,
+ `load_fifteen` FLOAT,
+ `load_five` FLOAT,
+ `load_one` FLOAT,
+ `mem_buffers` FLOAT,
+ `mem_cached` FLOAT,
+ `mem_free` FLOAT,
+ `mem_shared` FLOAT,
+ `swap_free` FLOAT,
+ `bytes_in` FLOAT,
+ `bytes_out` FLOAT
+)
+ENGINE = olap
+DUPLICATE KEY( `log_time`, `machine_name`, `machine_group`)
+DISTRIBUTED BY HASH(machine_name) BUCKETS 10
+PROPERTIES("replication_num" = "1");
diff --git a/regression-test/suites/brown_p2/ddl/logs2.sql
b/regression-test/suites/brown_p2/ddl/logs2.sql
new file mode 100644
index 0000000000..9d61e6e117
--- /dev/null
+++ b/regression-test/suites/brown_p2/ddl/logs2.sql
@@ -0,0 +1,11 @@
+CREATE TABLE IF NOT EXISTS logs2 (
+ `log_time` DATETIME NOT NULL,
+ `client_ip` VARCHAR(128),
+ `request` STRING,
+ `status_code` SMALLINT,
+ `object_size` BIGINT
+)
+ENGINE = olap
+DUPLICATE KEY(`log_time`)
+DISTRIBUTED BY HASH(client_ip) BUCKETS 10
+PROPERTIES("replication_num" = "1");
diff --git a/regression-test/suites/brown_p2/ddl/logs3.sql
b/regression-test/suites/brown_p2/ddl/logs3.sql
new file mode 100644
index 0000000000..c1a0bc86a9
--- /dev/null
+++ b/regression-test/suites/brown_p2/ddl/logs3.sql
@@ -0,0 +1,14 @@
+CREATE TABLE IF NOT EXISTS logs3 (
+ `log_time` DATETIME NOT NULL,
+ `event_type` VARCHAR(128),
+ `device_id` CHAR(15),
+ `device_name` STRING,
+ `device_type` STRING,
+ `device_floor` TINYINT,
+ `event_unit` CHAR(1),
+ `event_value` FLOAT
+)
+ENGINE = olap
+DUPLICATE KEY(`log_time`, `event_type`)
+DISTRIBUTED BY HASH(device_id) BUCKETS 10
+PROPERTIES("replication_num" = "1");
diff --git a/regression-test/suites/brown_p2/load.groovy
b/regression-test/suites/brown_p2/load.groovy
new file mode 100644
index 0000000000..f74a1244ce
--- /dev/null
+++ b/regression-test/suites/brown_p2/load.groovy
@@ -0,0 +1,76 @@
+// 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.
+
+// The cases is copied from https://github.com/trinodb/trino/tree/master
+// /testing/trino-product-tests/src/main/resources/sql-tests/testcases/tpcds
+// and modified by Doris.
+
+suite("load") {
+ def tables = ["logs1","logs2","logs3"]
+ def columnsMap = [
+
"logs1":"log_time,machine_name,machine_group,cpu_idle,cpu_nice,cpu_system,cpu_user,cpu_wio,disk_free,disk_total,part_max_used,load_fifteen,load_five,load_one,mem_buffers,mem_cached,mem_free,mem_shared,swap_free,bytes_in,bytes_out",
+ "logs2":"log_time,client_ip,request,status_code,object_size",
+
"logs3":"log_time,device_id,device_name,device_type,device_floor,event_type,event_unit,event_value"
+ ]
+
+ for (String table in tables) {
+ sql """ DROP TABLE IF EXISTS $table """
+ }
+
+ for (String table in tables) {
+ sql new File("""${context.file.parent}/ddl/${table}.sql""").text
+ }
+
+ for (String tableName in tables) {
+ streamLoad {
+ // you can skip declare db, because a default db already specify
in ${DORIS_HOME}/conf/regression-conf.groovy
+ // db 'regression_test'
+ table tableName
+
+ // default label is UUID:
+ // set 'label' UUID.randomUUID().toString()
+
+ // default column_separator is specify in doris fe config, usually
is '\t'.
+ // this line change to ','
+ set 'column_separator', ','
+ set 'compress_type', 'GZ'
+ set "columns", columnsMap[tableName]
+ set 'timeout', '72000'
+ // relate to
${DORIS_HOME}/regression-test/data/demo/streamload_input.csv.
+ // also, you can stream load a http stream, e.g.
http://xxx/some.csv
+ file """${getS3Url() + '/regression/clickhouse/brown/' +
tableName}.gz"""
+
+ time 0
+
+
+ // stream load action will check result, include Success status,
and NumberTotalRows == NumberLoadedRows
+
+ // if declared a check callback, the default check condition will
ignore.
+ // So you must check all condition
+ check { result, exception, startTime, endTime ->
+ if (exception != null) {
+ throw exception
+ }
+ log.info("Stream load result: ${result}".toString())
+ def json = parseJson(result)
+ assertEquals("success", json.Status.toLowerCase())
+ assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
+ assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
+ }
+ }
+ }
+}
diff --git
a/regression-test/suites/brown_p2/sql/CPUNetworkUtilization_order.sql
b/regression-test/suites/brown_p2/sql/CPUNetworkUtilization_order.sql
new file mode 100644
index 0000000000..338a44f814
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/CPUNetworkUtilization_order.sql
@@ -0,0 +1,20 @@
+SELECT machine_name,
+ MIN(cpu) AS cpu_min,
+ MAX(cpu) AS cpu_max,
+ AVG(cpu) AS cpu_avg,
+ MIN(net_in) AS net_in_min,
+ MAX(net_in) AS net_in_max,
+ AVG(net_in) AS net_in_avg,
+ MIN(net_out) AS net_out_min,
+ MAX(net_out) AS net_out_max,
+ AVG(net_out) AS net_out_avg
+FROM (
+ SELECT machine_name,
+ COALESCE(cpu_user, 0.0) AS cpu,
+ COALESCE(bytes_in, 0.0) AS net_in,
+ COALESCE(bytes_out, 0.0) AS net_out
+ FROM logs1
+ WHERE machine_name IN ('anansi','aragog','urd')
+ AND log_time >= TIMESTAMP '2017-01-11 00:00:00'
+) AS r
+GROUP BY machine_name;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/averageMetrics.sql
b/regression-test/suites/brown_p2/sql/averageMetrics.sql
new file mode 100644
index 0000000000..c222b06ce7
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/averageMetrics.sql
@@ -0,0 +1,28 @@
+SELECT dt,
+ hr,
+ AVG(load_fifteen) AS load_fifteen_avg,
+ AVG(load_five) AS load_five_avg,
+ AVG(load_one) AS load_one_avg,
+ AVG(mem_free) AS mem_free_avg,
+ AVG(swap_free) AS swap_free_avg
+FROM (
+ SELECT CAST(log_time AS DATE) AS dt,
+ EXTRACT(HOUR FROM log_time) AS hr,
+ load_fifteen,
+ load_five,
+ load_one,
+ mem_free,
+ swap_free
+ FROM logs1
+ WHERE machine_name = 'babbage'
+ AND load_fifteen IS NOT NULL
+ AND load_five IS NOT NULL
+ AND load_one IS NOT NULL
+ AND mem_free IS NOT NULL
+ AND swap_free IS NOT NULL
+ AND log_time >= TIMESTAMP '2017-01-01 00:00:00'
+) AS r
+GROUP BY dt,
+ hr
+ORDER BY dt,
+ hr;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/blockedIOServer.sql
b/regression-test/suites/brown_p2/sql/blockedIOServer.sql
new file mode 100644
index 0000000000..a45e6b8d6d
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/blockedIOServer.sql
@@ -0,0 +1,10 @@
+SELECT machine_name,
+ COUNT(*) AS spikes
+FROM logs1
+WHERE machine_group = 'Servers'
+ AND cpu_wio > 0.99
+ AND log_time >= TIMESTAMP '2016-12-01 00:00:00'
+ AND log_time < TIMESTAMP '2017-01-01 00:00:00'
+GROUP BY machine_name
+ORDER BY spikes DESC
+LIMIT 10;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/dailyUV.sql
b/regression-test/suites/brown_p2/sql/dailyUV.sql
new file mode 100644
index 0000000000..979d171887
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/dailyUV.sql
@@ -0,0 +1,9 @@
+SELECT dt,
+ COUNT(DISTINCT client_ip)
+FROM (
+ SELECT CAST(log_time AS DATE) AS dt,
+ client_ip
+ FROM logs2
+) AS r
+GROUP BY dt
+ORDER BY dt;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/dataTransferRate.sql
b/regression-test/suites/brown_p2/sql/dataTransferRate.sql
new file mode 100644
index 0000000000..f9fa76b284
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/dataTransferRate.sql
@@ -0,0 +1,8 @@
+SELECT AVG(transfer) / 125000000.0 AS transfer_avg,
+ MAX(transfer) / 125000000.0 AS transfer_max
+FROM (
+ SELECT log_time,
+ SUM(object_size) AS transfer
+ FROM logs2
+ GROUP BY log_time
+) AS r;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/doorOpen.sql
b/regression-test/suites/brown_p2/sql/doorOpen.sql
new file mode 100644
index 0000000000..1875266871
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/doorOpen.sql
@@ -0,0 +1,9 @@
+SELECT device_name,
+ device_floor,
+ COUNT(*) AS ct
+FROM logs3
+WHERE event_type = 'door_open'
+ AND log_time >= '2019-06-01 00:00:00.000'
+GROUP BY device_name,
+ device_floor
+ORDER BY ct DESC;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/excessiveRequests.sql
b/regression-test/suites/brown_p2/sql/excessiveRequests.sql
new file mode 100644
index 0000000000..7a40fee86b
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/excessiveRequests.sql
@@ -0,0 +1,7 @@
+SELECT client_ip,
+ COUNT(*) AS num_requests
+FROM logs2
+WHERE log_time >= TIMESTAMP '2012-10-01 00:00:00'
+GROUP BY client_ip
+HAVING COUNT(*) >= 100000
+ORDER BY num_requests DESC;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/hourlyNetworkTraffic.sql
b/regression-test/suites/brown_p2/sql/hourlyNetworkTraffic.sql
new file mode 100644
index 0000000000..b129b42157
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/hourlyNetworkTraffic.sql
@@ -0,0 +1,21 @@
+SELECT dt,
+ hr,
+ SUM(net_in) AS net_in_sum,
+ SUM(net_out) AS net_out_sum,
+ SUM(net_in) + SUM(net_out) AS both_sum
+FROM (
+ SELECT CAST(log_time AS DATE) AS dt,
+ EXTRACT(HOUR FROM log_time) AS hr,
+ COALESCE(bytes_in, 0.0) / 1000000000.0 AS net_in,
+ COALESCE(bytes_out, 0.0) / 1000000000.0 AS net_out
+ FROM logs1
+ WHERE machine_name IN ('allsorts','andes','bigred','blackjack','bonbon',
+ 'cadbury','chiclets','cotton','crows','dove','fireball','hearts','huey',
+ 'lindt','milkduds','milkyway','mnm','necco','nerds','orbit','peeps',
+ 'poprocks','razzles','runts','smarties','smuggler','spree','stride',
+ 'tootsie','trident','wrigley','york')
+) AS r
+GROUP BY dt,
+ hr
+ORDER BY both_sum DESC
+LIMIT 10;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/lowMemory.sql
b/regression-test/suites/brown_p2/sql/lowMemory.sql
new file mode 100644
index 0000000000..c46d617e17
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/lowMemory.sql
@@ -0,0 +1,16 @@
+SELECT machine_name,
+ dt,
+ MIN(mem_free) AS mem_free_min
+FROM (
+ SELECT machine_name,
+ CAST(log_time AS DATE) AS dt,
+ mem_free
+ FROM logs1
+ WHERE machine_group = 'DMZ'
+ AND mem_free IS NOT NULL
+) AS r
+GROUP BY machine_name,
+ dt
+HAVING MIN(mem_free) < 10000
+ORDER BY machine_name,
+ dt;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/offlineMachine.sql
b/regression-test/suites/brown_p2/sql/offlineMachine.sql
new file mode 100644
index 0000000000..979525c14f
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/offlineMachine.sql
@@ -0,0 +1,9 @@
+SELECT machine_name,
+ log_time
+FROM logs1
+WHERE (machine_name LIKE 'cslab%' OR
+ machine_name LIKE 'mslab%')
+ AND load_one IS NULL
+ AND log_time >= TIMESTAMP '2017-01-10 00:00:00'
+ORDER BY machine_name,
+ log_time;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/passwordLeaked.sql
b/regression-test/suites/brown_p2/sql/passwordLeaked.sql
new file mode 100644
index 0000000000..4f25b9c99f
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/passwordLeaked.sql
@@ -0,0 +1,7 @@
+SELECT *
+FROM logs2
+WHERE status_code >= 200
+ AND status_code < 300
+ AND request LIKE '%/etc/passwd%'
+ AND log_time >= TIMESTAMP '2012-05-06 00:00:00'
+ AND log_time < TIMESTAMP '2012-05-20 00:00:00';
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/powerConsumptionMetrics.sql
b/regression-test/suites/brown_p2/sql/powerConsumptionMetrics.sql
new file mode 100644
index 0000000000..966a879a3d
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/powerConsumptionMetrics.sql
@@ -0,0 +1,40 @@
+SELECT yr,
+ mo,
+ SUM(coffee_hourly_avg) AS coffee_monthly_sum,
+ AVG(coffee_hourly_avg) AS coffee_monthly_avg,
+ SUM(printer_hourly_avg) AS printer_monthly_sum,
+ AVG(printer_hourly_avg) AS printer_monthly_avg,
+ SUM(projector_hourly_avg) AS projector_monthly_sum,
+ AVG(projector_hourly_avg) AS projector_monthly_avg,
+ SUM(vending_hourly_avg) AS vending_monthly_sum,
+ AVG(vending_hourly_avg) AS vending_monthly_avg
+FROM (
+ SELECT dt,
+ yr,
+ mo,
+ hr,
+ AVG(coffee) AS coffee_hourly_avg,
+ AVG(printer) AS printer_hourly_avg,
+ AVG(projector) AS projector_hourly_avg,
+ AVG(vending) AS vending_hourly_avg
+ FROM (
+ SELECT CAST(log_time AS DATE) AS dt,
+ EXTRACT(YEAR FROM log_time) AS yr,
+ EXTRACT(MONTH FROM log_time) AS mo,
+ EXTRACT(HOUR FROM log_time) AS hr,
+ CASE WHEN device_name LIKE 'coffee%' THEN event_value END AS coffee,
+ CASE WHEN device_name LIKE 'printer%' THEN event_value END AS
printer,
+ CASE WHEN device_name LIKE 'projector%' THEN event_value END AS
projector,
+ CASE WHEN device_name LIKE 'vending%' THEN event_value END AS
vending
+ FROM logs3
+ WHERE device_type = 'meter'
+ ) AS r
+ GROUP BY dt,
+ yr,
+ mo,
+ hr
+) AS s
+GROUP BY yr,
+ mo
+ORDER BY yr,
+ mo;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/serverError.sql
b/regression-test/suites/brown_p2/sql/serverError.sql
new file mode 100644
index 0000000000..d97051d1ad
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/serverError.sql
@@ -0,0 +1,5 @@
+SELECT *
+FROM logs2
+WHERE status_code >= 500
+ AND log_time >= TIMESTAMP '2012-12-18 00:00:00'
+ORDER BY log_time;
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/temperatureReachFreezing.sql
b/regression-test/suites/brown_p2/sql/temperatureReachFreezing.sql
new file mode 100644
index 0000000000..32446da5d1
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/temperatureReachFreezing.sql
@@ -0,0 +1,5 @@
+SELECT *
+FROM logs3
+WHERE event_type = 'temperature'
+ AND event_value <= 32.0
+ AND log_time >= '2019-11-29 17:00:00.000';
\ No newline at end of file
diff --git a/regression-test/suites/brown_p2/sql/temperatureVariation_order.sql
b/regression-test/suites/brown_p2/sql/temperatureVariation_order.sql
new file mode 100644
index 0000000000..3e4e743269
--- /dev/null
+++ b/regression-test/suites/brown_p2/sql/temperatureVariation_order.sql
@@ -0,0 +1,49 @@
+WITH temperature AS (
+ SELECT dt,
+ device_name,
+ device_type,
+ device_floor
+ FROM (
+ SELECT dt,
+ hr,
+ device_name,
+ device_type,
+ device_floor,
+ AVG(event_value) AS temperature_hourly_avg
+ FROM (
+ SELECT CAST(log_time AS DATE) AS dt,
+ EXTRACT(HOUR FROM log_time) AS hr,
+ device_name,
+ device_type,
+ device_floor,
+ event_value
+ FROM logs3
+ WHERE event_type = 'temperature'
+ ) AS r
+ GROUP BY dt,
+ hr,
+ device_name,
+ device_type,
+ device_floor
+ ) AS s
+ GROUP BY dt,
+ device_name,
+ device_type,
+ device_floor
+ HAVING MAX(temperature_hourly_avg) - MIN(temperature_hourly_avg) >= 25.0
+)
+SELECT DISTINCT device_name,
+ device_type,
+ device_floor,
+ 'WINTER'
+FROM temperature
+WHERE dt >= DATE '2018-12-01'
+ AND dt < DATE '2019-03-01'
+UNION
+SELECT DISTINCT device_name,
+ device_type,
+ device_floor,
+ 'SUMMER'
+FROM temperature
+WHERE dt >= DATE '2019-06-01'
+ AND dt < DATE '2019-09-01';
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
