You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by mc...@apache.org on 2022/04/14 02:18:04 UTC
[pinot] branch master updated: Add new compat test cases and data (#7235) (#8036)
This is an automated email from the ASF dual-hosted git repository.
mcvsubbu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/pinot.git
The following commit(s) were added to refs/heads/master by this push:
new 5ae960d0de Add new compat test cases and data (#7235) (#8036)
5ae960d0de is described below
commit 5ae960d0de383d12e9e8dbc34204b0654c87b7a9
Author: Jia Guo <ji...@linkedin.com>
AuthorDate: Wed Apr 13 19:17:58 2022 -0700
Add new compat test cases and data (#7235) (#8036)
* Add new compat test cases and data. (#7235)
* Add new compat test cases and data. (#7235)
* Add new compat test cases and data. (#7235)
* Add new compat test cases and data. (#7235)
* Add new compat test cases and data. (#7235)
---
.../config/FeatureTest3-schema.json | 55 ++++
...ta-00.csv => FeatureTest2-data-realtime-00.csv} | 0
.../config/data/FeatureTest3-data-realtime-00.csv | 307 +++++++++++++++++++++
.../data/recordReaderConfig-FeatureTest3.json | 5 +
.../sample-test-suite/config/dataGenerator.py | 93 +++++++
.../sample-test-suite/config/feature-test-1.json | 2 +-
.../feature-test-3-realtime-stream-config.json | 8 +
.../config/feature-test-3-realtime.json | 59 ++++
.../queries/feature-test-3-sql-realtime.queries | 47 ++++
.../query-results/feature-test-1-rest-sql.results | 126 ++++-----
.../feature-test-2-sql-realtime.results | 62 ++---
.../feature-test-3-sql-realtime.results | 47 ++++
.../sample-test-suite/post-broker-rollback.yaml | 16 +-
.../post-controller-rollback.yaml | 14 +-
.../sample-test-suite/post-server-rollback.yaml | 16 +-
.../sample-test-suite/post-server-upgrade.yaml | 16 +-
.../sample-test-suite/pre-broker-upgrade.yaml | 15 +-
.../sample-test-suite/pre-controller-upgrade.yaml | 26 +-
.../sample-test-suite/pre-server-upgrade.yaml | 15 +-
.../pinot/common/utils/SqlResultComparator.java | 14 +
.../main/java/org/apache/pinot/compat/QueryOp.java | 3 +-
21 files changed, 843 insertions(+), 103 deletions(-)
diff --git a/compatibility-verifier/sample-test-suite/config/FeatureTest3-schema.json b/compatibility-verifier/sample-test-suite/config/FeatureTest3-schema.json
new file mode 100644
index 0000000000..34e147eec0
--- /dev/null
+++ b/compatibility-verifier/sample-test-suite/config/FeatureTest3-schema.json
@@ -0,0 +1,55 @@
+{
+ "dimensionFieldSpecs": [
+ {
+ "dataType": "INT",
+ "name": "generationNumber"
+ },
+ {
+ "dataType": "STRING",
+ "name": "stringDimSV1"
+ },
+ {
+ "dataType": "STRING",
+ "name": "stringDimSV2"
+ },
+ {
+ "dataType": "LONG",
+ "name": "longDimSV1"
+ },
+ {
+ "dataType": "DOUBLE",
+ "name": "doubleDimSV1"
+ }
+ ],
+ "metricFieldSpecs": [
+ {
+ "dataType": "INT",
+ "name": "intMetric1"
+ },
+ {
+ "dataType": "LONG",
+ "name": "longMetric1"
+ },
+ {
+ "dataType": "FLOAT",
+ "name": "floatMetric1"
+ },
+ {
+ "dataType": "DOUBLE",
+ "name": "doubleMetric1"
+ },
+ {
+ "dataType": "BYTES",
+ "name": "bytesMetric1"
+ }
+ ],
+ "dateTimeFieldSpecs" : [
+ {
+ "name" : "HoursSinceEpoch",
+ "dataType" : "INT",
+ "format" : "1:HOURS:EPOCH",
+ "granularity": "1:HOURS"
+ }
+ ],
+ "schemaName": "FeatureTest3"
+}
diff --git a/compatibility-verifier/sample-test-suite/config/data/RealtimeFeatureTest1-data-00.csv b/compatibility-verifier/sample-test-suite/config/data/FeatureTest2-data-realtime-00.csv
similarity index 100%
rename from compatibility-verifier/sample-test-suite/config/data/RealtimeFeatureTest1-data-00.csv
rename to compatibility-verifier/sample-test-suite/config/data/FeatureTest2-data-realtime-00.csv
diff --git a/compatibility-verifier/sample-test-suite/config/data/FeatureTest3-data-realtime-00.csv b/compatibility-verifier/sample-test-suite/config/data/FeatureTest3-data-realtime-00.csv
new file mode 100644
index 0000000000..0d517e02a7
--- /dev/null
+++ b/compatibility-verifier/sample-test-suite/config/data/FeatureTest3-data-realtime-00.csv
@@ -0,0 +1,307 @@
+# This table includes test cases for:
+# 1.No dictionary column ["stringDimSV2","intMetric1", "longMetric1", "floatMetric1", "doubleMetric1", "bytesMetric1"]
+# 2.Bloom filter (functional tests only) [stringDimSV1]
+# 3.Range index: [doubleDimSV1]
+# 4.Var length dictionary [stringDimSV1]
+# 5.Partition column [longDimSV1]
+# HoursSinceEpoch generationNumber stringDimSV1 stringDimSV2 longDimSV1 doubleDimSV1 intMetric1 longMetric1 floatMetric1 doubleMetric1 bytesMetric1
+123456,__GENERATION_NUMBER__,jkxftqwgzszefw,lvfwsewnj,300,43.73,2824,281474976716411,61.71,7.199999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,mvbprcfsljhkclt,quzbozdgxhyzd,299,48.14,6314,281474976712191,70.1,4.0999999999999995e+45,deadbeef
+123456,__GENERATION_NUMBER__,otrfcluhre,hcjaxekilj,298,51.45,8888,281474976719670,32.3,9.1e+45,01a0bc
+123456,__GENERATION_NUMBER__,sxvjftsrj,unsamzlmse,297,2.32,8855,281474976710712,99.11,1.18e+46,deadbeef
+123456,__GENERATION_NUMBER__,jljidtubieqa,tzemiwnhuaqnh,296,3.36,494,281474976718193,69.42,1.06e+46,01a0bc
+123456,__GENERATION_NUMBER__,xcicskjr,wpcmujmwrrfurrm,295,68.6,9046,281474976715907,33.71,1.16e+46,d54d0507
+123456,__GENERATION_NUMBER__,rvvazctyuhm,jzouegxpuqaeod,294,79.58,3575,281474976717622,46.08,1.3299999999999999e+46,d54d0507
+123456,__GENERATION_NUMBER__,kszqyhkjkzda,ccbwyvgknb,293,37.4,9309,281474976716357,6.67,5.1e+45,deadbeef
+123456,__GENERATION_NUMBER__,opjglqxae,vfrrcsrqy,292,8.49,8876,281474976717204,59.65,4e+45,01a0bc
+123456,__GENERATION_NUMBER__,vdruugnn,kimtclvgqivzuech,291,84.27,9127,281474976713320,2.24,1.07e+46,deed0507
+123456,__GENERATION_NUMBER__,mtexbkamte,ljjshyallnii,290,60.66,8670,281474976715315,34.05,1.02e+46,d54d0507
+123456,__GENERATION_NUMBER__,bqvxiltzudafwo,pbeporbrdeznaos,289,74.05,3515,281474976712540,88.96,5.9e+45,deed0507
+123456,__GENERATION_NUMBER__,msfgrovpl,banrlvfymru,288,90.63,1783,281474976717839,19.21,1.25e+46,deed0507
+123456,__GENERATION_NUMBER__,oupfrufytjrccbo,kvzmwjnitjz,287,55.81,7159,281474976711874,85.42,1.0399999999999999e+46,01a0bc
+123456,__GENERATION_NUMBER__,xoqkybveefof,cwhqhvflrynj,286,99.1,3670,281474976713574,1.49,9.799999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,kdacajhepx,nzxhmkriexyxjztk,285,10.58,3583,281474976711595,70.32,1.28e+46,d54d0507
+123456,__GENERATION_NUMBER__,qrjkfarpbsrejhql,qnzdsmodavgxwnj,284,34.79,2928,281474976720525,65.95,1.01e+46,deadbeef
+123456,__GENERATION_NUMBER__,wzslvfcyx,hyxybzvwn,283,48.46,4183,281474976715446,33.07,8.3e+45,01a0bc
+123456,__GENERATION_NUMBER__,gjssquedphhq,qylesyidk,282,39.74,1694,281474976716629,31.36,8e+45,deadbeef
+123456,__GENERATION_NUMBER__,vzzomndo,criawraelhlkn,281,24.96,8894,281474976716266,53.19,1.34e+46,01a0bc
+123456,__GENERATION_NUMBER__,pteqobnqd,rrdvxfajfiufq,280,46.17,3611,281474976715237,62.32,1.06e+46,01a0bc
+123456,__GENERATION_NUMBER__,vydwhrcnhiupymqb,cuhwuhzuhapzrycz,279,68.66,9193,281474976713392,27.88,9.699999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,fahaiajjelxuunij,elukbyamryl,278,98.6,5517,281474976711933,26.34,6.1e+45,01a0bc
+123456,__GENERATION_NUMBER__,amnuaxutmppnc,ipcmcoff,277,53.1,3532,281474976711448,85.51,8.599999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,whppiaojrnxxn,gmzrwjbivdgbge,276,3.49,3462,281474976719049,27.87,1.3099999999999997e+46,deed0507
+123456,__GENERATION_NUMBER__,diakwgtkwcszaem,spqraccbbczmk,275,72.06,3198,281474976717043,17.5,8e+45,01a0bc
+123456,__GENERATION_NUMBER__,qidtrpdixchug,smwluvuqbhyev,274,77.85,4864,281474976712679,2.1,1.0299999999999999e+46,01a0bc
+123456,__GENERATION_NUMBER__,spkjawebfgjcoc,jmzijknsnnjupe,273,43.95,5831,281474976711360,69.99,1.22e+46,deadbeef
+123456,__GENERATION_NUMBER__,idkhbuubgxrajy,rzlbkqscuhdckuv,272,86.05,2893,281474976718665,22.61,8.1e+45,01a0bc
+123456,__GENERATION_NUMBER__,prvaprptby,imoyhfzhlgme,271,65.72,7173,281474976711153,67.24,5.6e+45,deed0507
+123456,__GENERATION_NUMBER__,zgwzjzvqwmklghen,nmyqnfezviw,270,99.62,1822,281474976715443,83.69,9.499999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,gkevvztnsbljzk,sohzhmgiqr,269,68.4,33,281474976717719,53.29,4.5999999999999996e+45,01a0bc
+123456,__GENERATION_NUMBER__,fxbscsfmoxo,nkvprsmr,268,99.08,3635,281474976719426,89.52,8e+45,deadbeef
+123456,__GENERATION_NUMBER__,oailmeltjbyoopwm,ohadevrmsv,267,30.01,673,281474976719309,36.86,5.6999999999999996e+45,deed0507
+123456,__GENERATION_NUMBER__,bxcanrqh,nzmfxdaurcuu,266,28.76,3223,281474976712284,9.79,8.8e+45,deed0507
+123456,__GENERATION_NUMBER__,zhpaoiiticvijf,dgmtmnusjvirnj,265,62.76,4238,281474976713475,93.47,9.899999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,ylsqjvgfotb,xpcjamatfvy,264,29.79,7020,281474976713889,30.39,5.4e+45,01a0bc
+123456,__GENERATION_NUMBER__,ojuzsrqgpi,brjtrorgb,263,43.42,305,281474976716315,71.11,1.06e+46,01a0bc
+123456,__GENERATION_NUMBER__,dyqjzwut,nbfjwgpxi,262,43.63,6687,281474976718999,61.89,9.899999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,iijrogfi,xexambadazzub,261,19.59,1129,281474976711822,47.67,1.26e+46,01a0bc
+123456,__GENERATION_NUMBER__,yljywdsyfqfg,xkxvlebpyugen,260,76.89,3543,281474976716915,6.29,5.6999999999999996e+45,01a0bc
+123456,__GENERATION_NUMBER__,knwavinmfdtk,qgqjfymoh,259,91.1,3822,281474976717037,17.32,7.3e+45,deed0507
+123456,__GENERATION_NUMBER__,kogzpboe,omdkjbheomkqrb,258,57.54,7327,281474976718054,39.39,1.13e+46,deed0507
+123456,__GENERATION_NUMBER__,qzjqjyygroiqrabq,qaxkenetljmuili,257,94.67,5494,281474976716107,60.88,7.4e+45,deed0507
+123456,__GENERATION_NUMBER__,szmszjgqt,pqulqzpc,256,35.59,4316,281474976714969,21.39,1.11e+46,01a0bc
+123456,__GENERATION_NUMBER__,nsknerim,pjofwzrdm,255,20.7,3408,281474976716897,65.45,4e+45,01a0bc
+123456,__GENERATION_NUMBER__,igfjglhxuv,gbfljycltv,254,28.46,6832,281474976718952,66.66,4.8e+45,d54d0507
+123456,__GENERATION_NUMBER__,gnbvavwgl,mtqoswxsrc,253,97.08,450,281474976713121,31.24,9.799999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,agkvypzdpqyap,gpvtpszh,252,48.4,740,281474976715170,36.11,1.25e+46,deed0507
+123456,__GENERATION_NUMBER__,xnoeknkfyvmzmnnz,xrrjmxvjrjtdqvo,251,13.9,8291,281474976714756,43.84,9.899999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,tvzfrshvdjmpbcas,wxlisronbauftswu,250,31.53,5965,281474976711329,0.89,8.5e+45,d54d0507
+123456,__GENERATION_NUMBER__,asetrfjrtm,etftghavfwsd,249,25.47,2922,281474976718244,14.88,8.899999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,rwbhykbjul,kvujmjfoqeiaano,248,55.11,6273,281474976716700,93.1,9.799999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,oonycyxstpbck,knqumycuuwooxajz,247,90.84,4286,281474976711128,8.44,7.6e+45,d54d0507
+123456,__GENERATION_NUMBER__,qmxauaacotyezcqw,knurucwrydcufd,246,81.61,6563,281474976717652,62.72,6.2e+45,deadbeef
+123456,__GENERATION_NUMBER__,srcapnyr,twlanqwwmwl,245,11.53,5330,281474976713351,60.47,8.5e+45,deed0507
+123456,__GENERATION_NUMBER__,qndigjvy,webnzrlalgdyhd,244,0.57,3535,281474976716934,79.52,6.399999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,ortzaoayfojbkux,ydfzpzccgsjigbb,243,91.92,8269,281474976714220,59.95,4e+45,01a0bc
+123456,__GENERATION_NUMBER__,bqolbxrwcqhpo,tchfqlgyrjqcmm,242,75.15,1149,281474976720356,26.31,3.7e+45,deadbeef
+123456,__GENERATION_NUMBER__,asdplmihcmovg,lboawtii,241,50.1,8773,281474976715378,72.96,7.699999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,tpnclozkhfblvte,uzrhwnmowqpqicii,240,52.83,792,281474976719834,54.17,4.2999999999999997e+45,deadbeef
+123456,__GENERATION_NUMBER__,wggzvqpfaokhklnf,uvgqmdvabqc,239,80.26,5795,281474976711690,62.67,1.15e+46,d54d0507
+123456,__GENERATION_NUMBER__,ruyybmoudheuch,gwceqhmu,238,20.93,419,281474976719032,50.81,9.3e+45,deadbeef
+123456,__GENERATION_NUMBER__,ygoeswdahhoxj,espvuzqidbhep,237,14.4,2455,281474976711943,69.54,3.4e+45,d54d0507
+123456,__GENERATION_NUMBER__,lyljrcgxf,gzojqtbnkmktkc,236,81.31,868,281474976720410,87.01,1.32e+46,01a0bc
+123456,__GENERATION_NUMBER__,evzbbvopht,mowfibxbbhkrdjx,235,14.13,9571,281474976712201,19.02,1.27e+46,deed0507
+123456,__GENERATION_NUMBER__,dxasepfpl,jpttghkvsukppf,234,1.51,2247,281474976716555,97.15,4.2999999999999997e+45,d54d0507
+123456,__GENERATION_NUMBER__,hzlmtgpgprkbk,jdtyupndeyymvh,233,6.78,5982,281474976713644,58.09,5.9e+45,01a0bc
+123456,__GENERATION_NUMBER__,njrzxlrcxuxzy,oeitrqkx,232,39.84,3624,281474976718101,95.58,4.5e+45,01a0bc
+123456,__GENERATION_NUMBER__,tfdpflrbuu,wpkirglvoyqghpo,231,91.73,5462,281474976719426,33.88,1.02e+46,deadbeef
+123456,__GENERATION_NUMBER__,smeoyewfl,hrowlhpggs,230,1.42,3893,281474976720506,80.79,1.22e+46,deadbeef
+123456,__GENERATION_NUMBER__,udejwywyefcghys,rjbddxgcpy,229,3.05,9548,281474976712828,79.82,3.9e+45,deadbeef
+123456,__GENERATION_NUMBER__,nuzdkcmo,chtgkwqwlohjpg,228,41.56,9335,281474976710796,93.44,8.599999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,izchwncoqjufylqh,scxyekrsztjmn,227,26.64,365,281474976719435,98.14,4.0999999999999995e+45,deed0507
+123456,__GENERATION_NUMBER__,uynfvxopkpdpf,bjjpqefqbakglgm,226,26.0,6416,281474976715098,36.56,1.25e+46,d54d0507
+123456,__GENERATION_NUMBER__,qtketzxxeg,woliyzszjlwd,225,35.17,174,281474976716659,20.35,7.699999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,rjxssaskjaw,zfjznedfptkwpk,224,27.27,5007,281474976719579,86.63,1.0399999999999999e+46,d54d0507
+123456,__GENERATION_NUMBER__,qdibfrurmd,duvexqikjp,223,4.91,4793,281474976720345,87.21,4.6999999999999994e+45,deed0507
+123456,__GENERATION_NUMBER__,shihgolxw,ynmlkfwn,222,67.84,9690,281474976717449,64.07,7.8e+45,d54d0507
+123456,__GENERATION_NUMBER__,zqbznxpnhuosge,llsanggyjlog,221,46.9,4809,281474976720305,37.47,8.8e+45,deadbeef
+123456,__GENERATION_NUMBER__,mgvozqnhktttt,owyrdperpk,220,85.65,6173,281474976719574,56.89,6.3e+45,01a0bc
+123456,__GENERATION_NUMBER__,yqblknurwd,ntrsulwm,219,7.23,5484,281474976718407,51.79,8e+45,deed0507
+123456,__GENERATION_NUMBER__,irnlgaetmoouy,yjzoydzig,218,61.3,5934,281474976720624,42.46,4.2e+45,01a0bc
+123456,__GENERATION_NUMBER__,mszjrgkyitp,qtdzusmhs,217,88.29,691,281474976715974,64.75,6.399999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,khiwdgxzkqhivc,krbkseuytp,216,66.93,643,281474976718867,39.77,1.27e+46,deadbeef
+123456,__GENERATION_NUMBER__,ecmfbfeqxqet,cpvuolbvfzjppgc,215,87.8,2456,281474976711257,3.5,6.6e+45,deadbeef
+123456,__GENERATION_NUMBER__,ekoymfbgxu,kylloanlrm,214,10.08,7789,281474976718343,46.85,5.9e+45,d54d0507
+123456,__GENERATION_NUMBER__,jiiiiahbfon,zoosgjqfwp,213,79.39,1750,281474976715242,63.91,1.34e+46,deadbeef
+123456,__GENERATION_NUMBER__,msflbwjmzowej,dijryzsxxera,212,60.14,7850,281474976718591,89.12,9.6e+45,deadbeef
+123456,__GENERATION_NUMBER__,oruvpinjcjniihhx,oyxhncsfoz,211,7.83,6857,281474976718370,45.97,1.3099999999999997e+46,d54d0507
+123456,__GENERATION_NUMBER__,pbbeecjjabupkrf,kjuhobuoynryay,210,95.98,188,281474976710683,72.21,1.24e+46,d54d0507
+123456,__GENERATION_NUMBER__,jnitwdqo,gksxbzfsdjqfe,209,30.62,1552,281474976720026,3.15,5.299999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,snpbtvxaqwb,zmvnwwlc,208,30.79,8514,281474976714773,31.21,6.2e+45,01a0bc
+123456,__GENERATION_NUMBER__,wdbpenqbvnpioho,zppopgadpjav,207,27.69,4146,281474976710931,72.74,9.3e+45,01a0bc
+123456,__GENERATION_NUMBER__,tkqkmerzbvbjmkrj,yaycsexgbmyboqtu,206,17.88,280,281474976711172,93.45,1.0299999999999999e+46,d54d0507
+123456,__GENERATION_NUMBER__,gpigissolzba,bgsxgxntigj,205,74.31,3761,281474976712054,6.22,9.699999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,pkxvtudsywaqb,flcxcmga,204,75.06,9611,281474976710793,95.99,1.16e+46,deadbeef
+123456,__GENERATION_NUMBER__,qnjhwzmbougftkhx,zftuxrcg,203,90.46,891,281474976720542,46.28,5.299999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,glilpuldcmew,hvedzxizwux,202,39.97,2475,281474976718786,98.21,1.2299999999999998e+46,01a0bc
+123456,__GENERATION_NUMBER__,wfojvxrvztnvmln,tnxzempxkhg,201,42.33,6698,281474976713147,3.9,1.3299999999999999e+46,deadbeef
+123456,__GENERATION_NUMBER__,vjevbarkamxfcttu,aggfouts,200,6.55,2503,281474976714189,94.49,1.1999999999999998e+46,d54d0507
+123456,__GENERATION_NUMBER__,bjshpccmkvir,lhvhwmebisfl,199,80.31,1914,281474976712688,38.24,1.34e+46,d54d0507
+123456,__GENERATION_NUMBER__,vcenrqviezeub,ywkekcwyslqnzbq,198,83.42,812,281474976710814,52.19,8e+45,deed0507
+123456,__GENERATION_NUMBER__,vtebgdyvci,otpbcpegnthoyp,197,50.2,769,281474976714996,56.83,1.27e+46,01a0bc
+123456,__GENERATION_NUMBER__,udctjsrly,lpohfschirslji,196,26.91,5439,281474976718271,83.99,9.699999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,ctmtjabb,ravpajtmmsgedb,195,80.03,9309,281474976715602,12.18,8.899999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,ojorgpbwyqmcztez,ufmifunhtvro,194,88.43,5770,281474976710851,53.25,9.899999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,wbvsfbgmena,nrhkjduruyiel,193,98.22,6517,281474976715957,14.39,3.4999999999999996e+45,deed0507
+123456,__GENERATION_NUMBER__,xhcgrazcxloqb,kfrkbuoxlstoemp,192,20.72,4576,281474976716620,67.88,1.06e+46,d54d0507
+123456,__GENERATION_NUMBER__,tswfhvagldj,jypiovffmwoi,191,34.9,4834,281474976713955,95.96,5e+45,deadbeef
+123456,__GENERATION_NUMBER__,kopknnpefdxko,zdhkkfjihjsj,190,51.27,2254,281474976716939,12.27,1.02e+46,deadbeef
+123456,__GENERATION_NUMBER__,zqbpyyhdbxsawfbq,gvvijkuvbl,189,29.75,6611,281474976713369,95.4,1.11e+46,deadbeef
+123456,__GENERATION_NUMBER__,czwgmovxct,svjevvolho,188,5.88,4315,281474976715110,43.94,9e+45,01a0bc
+123456,__GENERATION_NUMBER__,asydzumcecxqe,qgicuarpoah,187,83.27,2731,281474976711856,97.43,1.3299999999999999e+46,d54d0507
+123456,__GENERATION_NUMBER__,rvaxcdblcw,mduavqytfw,186,3.35,6163,281474976716719,84.16,6.699999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,vdbhknnnrrs,hvucafmbutwto,185,70.57,629,281474976711636,22.78,7.3e+45,deed0507
+123456,__GENERATION_NUMBER__,yvruppkueyngmw,fjjratjtismn,184,72.92,8689,281474976717739,8.71,4.0999999999999995e+45,d54d0507
+123456,__GENERATION_NUMBER__,twwlgjegrt,vshukhqocvmymmur,183,99.11,1469,281474976712689,80.21,8.8e+45,d54d0507
+123456,__GENERATION_NUMBER__,rvmzttbtywsdd,qwrilhzyapv,182,79.65,750,281474976714790,16.24,4.8e+45,01a0bc
+123456,__GENERATION_NUMBER__,tupiyqpmpixewcko,vsxgpbkisfszap,181,55.44,7097,281474976720474,40.53,1.21e+46,deed0507
+123456,__GENERATION_NUMBER__,ydqpzpexvjate,cbuhdccjb,180,18.87,4806,281474976714771,27.14,6.2e+45,d54d0507
+123456,__GENERATION_NUMBER__,wmwxikmztrzr,mwlpyfkgdtcmv,179,97.93,1349,281474976713106,43.29,9.6e+45,d54d0507
+123456,__GENERATION_NUMBER__,ticwljpchgx,nphjipwtsqbwkba,178,4.3,3778,281474976712732,16.38,5.6e+45,deed0507
+123456,__GENERATION_NUMBER__,rzzljdkngiktswsk,pafivujooim,177,51.1,5306,281474976719440,54.96,1.1999999999999998e+46,d54d0507
+123456,__GENERATION_NUMBER__,svufckmowlsqitca,iaqlkptyuzylesc,176,24.33,7948,281474976712874,57.2,8.8e+45,01a0bc
+123456,__GENERATION_NUMBER__,stjjqekvyrwdfxq,rbzkhbylwpb,175,93.76,294,281474976719976,2.98,9.1e+45,01a0bc
+123456,__GENERATION_NUMBER__,rvxdrfqjy,qfbsolzixi,174,28.7,8914,281474976720304,35.14,1.19e+46,deadbeef
+123456,__GENERATION_NUMBER__,qaspktnjvxrhsd,kbukuobo,173,46.13,9799,281474976712217,12.13,5.4e+45,deadbeef
+123456,__GENERATION_NUMBER__,unfdwyrfzqgce,ookuapnfoa,172,70.71,9386,281474976718267,5.56,1.13e+46,deed0507
+123456,__GENERATION_NUMBER__,uzvzvepsb,tjiexwqqlkro,171,81.13,6290,281474976718195,46.19,1.24e+46,01a0bc
+123456,__GENERATION_NUMBER__,ofaxmgbmwcxbvwdx,bclfvzlalmaqyqp,170,19.98,5451,281474976718351,11.25,7.6e+45,01a0bc
+123456,__GENERATION_NUMBER__,fdwsntgsjtnncp,uuqctcaybkmg,169,96.07,1666,281474976718474,92.21,6.3e+45,d54d0507
+123456,__GENERATION_NUMBER__,nseolkzauvcr,npulthtuqgce,168,26.12,9832,281474976719248,61.99,1.2999999999999998e+46,deed0507
+123456,__GENERATION_NUMBER__,vkzujszpwjlq,tchaxepynpzbup,167,45.82,1951,281474976713596,58.47,1.3299999999999999e+46,deadbeef
+123456,__GENERATION_NUMBER__,dolggywlnz,tmjploienlhpa,166,2.25,4483,281474976717298,92.23,9.1e+45,deadbeef
+123456,__GENERATION_NUMBER__,ykzimpbkig,qjektkulhrhkc,165,70.21,9482,281474976719017,33.36,8.8e+45,deadbeef
+123456,__GENERATION_NUMBER__,bnpobkvdmiluyucb,mnwsacprtbvqd,164,33.74,6808,281474976717383,5.91,4.5e+45,01a0bc
+123456,__GENERATION_NUMBER__,sclmlhwopdc,oreymfedia,163,12.75,9110,281474976715077,72.97,3.4e+45,d54d0507
+123456,__GENERATION_NUMBER__,azrqfkdtninttjl,sawshnffooarhrd,162,61.66,2482,281474976711599,85.25,5.1e+45,01a0bc
+123456,__GENERATION_NUMBER__,ejvmjazd,ydvucqgjcxhobb,161,23.26,9862,281474976711623,8.02,4.5999999999999996e+45,deadbeef
+123456,__GENERATION_NUMBER__,vzlwigjfpbmpdz,yqtpexersxrrbrv,160,23.48,7174,281474976720163,48.09,5.299999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,motuxyius,dfxkvmhxno,159,54.69,2736,281474976719320,94.41,1.1399999999999999e+46,deadbeef
+123456,__GENERATION_NUMBER__,enmepmxog,cxdvphnhy,158,12.29,3594,281474976720270,10.78,3.6e+45,d54d0507
+123456,__GENERATION_NUMBER__,arcqijjwiryd,ibihrkjetodxx,157,43.6,3845,281474976716823,82.17,6.2e+45,deadbeef
+123456,__GENERATION_NUMBER__,jyjbskss,ktzbslhqxociw,156,22.79,5655,281474976710734,36.66,6.3e+45,01a0bc
+123456,__GENERATION_NUMBER__,rgitlxyuwudikl,ixbnwcnvfl,155,45.03,4264,281474976719401,91.14,4.5e+45,01a0bc
+123456,__GENERATION_NUMBER__,giuotoqduldoeur,dhdibgkasmmphqn,154,45.28,978,281474976719054,66.75,4.2999999999999997e+45,d54d0507
+123456,__GENERATION_NUMBER__,ytdhswvrujrhlu,kljynwcigrbwvjas,153,48.87,2537,281474976713189,85.2,1.22e+46,01a0bc
+123456,__GENERATION_NUMBER__,rkoutvhyxiyabvf,olcqnezapdibpg,152,75.15,5939,281474976717872,93.17,8.899999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,msorwptgxprkrulq,einldovtcza,151,67.93,7533,281474976712906,71.38,9.699999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,kjokwtkmuqz,ynefztocmqdr,150,46.02,4797,281474976713019,45.1,5.8e+45,deadbeef
+123456,__GENERATION_NUMBER__,buympgyn,sjusmkrcptzk,149,14.85,6951,281474976715188,74.96,1.0999999999999999e+46,01a0bc
+123456,__GENERATION_NUMBER__,piyzvmxcxxkl,ptaylperlonfwrz,148,94.78,8085,281474976711034,81.15,8e+45,01a0bc
+123456,__GENERATION_NUMBER__,pdfpbqfjffikvdr,yfqmwbtbwoanemv,147,21.28,4356,281474976711293,49.75,6.8e+45,01a0bc
+123456,__GENERATION_NUMBER__,dpqmaxalngkrcnq,nksyycpsex,146,50.13,526,281474976712053,59.46,3.4999999999999996e+45,deadbeef
+123456,__GENERATION_NUMBER__,jgakvezwhne,ajbfxeyrnqjge,145,26.97,5405,281474976718983,76.93,9.6e+45,d54d0507
+123456,__GENERATION_NUMBER__,rxtghsxd,dxyxhjpa,144,59.24,896,281474976715547,47.46,6.6e+45,deadbeef
+123456,__GENERATION_NUMBER__,auiudjupjx,jbicqtqggldaqyo,143,54.71,853,281474976712964,54.44,1.12e+46,deadbeef
+123456,__GENERATION_NUMBER__,hsooearhbacr,gjlrfxjm,142,5.89,1736,281474976711387,66.81,4.8e+45,deed0507
+123456,__GENERATION_NUMBER__,esuocnwrvefyj,ugprnmxsankpvs,141,14.62,7598,281474976719755,71.98,1.26e+46,deed0507
+123456,__GENERATION_NUMBER__,vnyesszikrkorcen,swqrgznsyihfsoi,140,98.77,6485,281474976711061,1.19,1.29e+46,deed0507
+123456,__GENERATION_NUMBER__,gyyjtxrkto,pvvcmtrxrgtici,139,72.58,391,281474976716770,49.35,4.8e+45,deadbeef
+123456,__GENERATION_NUMBER__,pqrmyarusiajqr,qpnxkitqoqgikvyk,138,69.47,9347,281474976719891,15.79,8.199999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,nvzclyghwjzp,pavzmcnjuoz,137,23.12,748,281474976717027,61.05,1.25e+46,01a0bc
+123456,__GENERATION_NUMBER__,zukqdrfxakt,fiaywtelmcqab,136,6.44,1932,281474976720244,76.53,4.2e+45,d54d0507
+123456,__GENERATION_NUMBER__,jbhxqunndiszivbr,dalnaroe,135,91.54,6819,281474976712503,68.57,5.1999999999999995e+45,01a0bc
+123456,__GENERATION_NUMBER__,qhdtkqdojosuiub,uflqmekbvtopsc,134,86.33,2004,281474976720162,88.15,5.1e+45,d54d0507
+123456,__GENERATION_NUMBER__,pqonfeumqzqminst,enkmquzlaljhvfbr,133,9.69,7733,281474976714495,0.15,6.499999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,auixokcoo,sihhqrcxgmxz,132,86.1,1030,281474976716921,76.25,8.3e+45,01a0bc
+123456,__GENERATION_NUMBER__,atavfhcuea,wgrwhmir,131,48.94,3691,281474976713887,96.6,1.22e+46,deadbeef
+123456,__GENERATION_NUMBER__,owiiaihlura,xfqnvuotwvb,130,93.86,9414,281474976718934,12.76,1.22e+46,01a0bc
+123456,__GENERATION_NUMBER__,bnxblvru,diwybdvwssmggy,129,33.68,2659,281474976714721,45.21,6.6e+45,deadbeef
+123456,__GENERATION_NUMBER__,dvobeharxybchwik,maubxsrsqnciz,128,84.77,4515,281474976715158,28.72,1.21e+46,d54d0507
+123456,__GENERATION_NUMBER__,nhonrwzgoznle,eqhivpkx,127,64.62,6091,281474976713658,0.83,3.9e+45,d54d0507
+123456,__GENERATION_NUMBER__,jtfabrmuakarp,spvtsqxfybt,126,27.21,3418,281474976718169,62.26,9.1e+45,01a0bc
+123456,__GENERATION_NUMBER__,vefoavmixgsnyt,zuiyaydwowiurfg,125,66.84,3028,281474976712064,80.65,5.8e+45,01a0bc
+123456,__GENERATION_NUMBER__,lrhsoeqp,urczflye,124,62.69,1520,281474976720427,64.29,5.6999999999999996e+45,01a0bc
+123456,__GENERATION_NUMBER__,gghdsaqtgc,rkbnorovxhrtpc,123,26.92,9736,281474976712047,7.49,5.8e+45,01a0bc
+123456,__GENERATION_NUMBER__,bckshwnxxig,bmpjqdzpimjlla,122,89.27,1968,281474976713185,83.55,8.3e+45,d54d0507
+123456,__GENERATION_NUMBER__,tkhkxqltshfb,rtgkcvmqufxjic,121,66.75,1665,281474976715484,73.67,4.8e+45,deed0507
+123456,__GENERATION_NUMBER__,ppzdnzwmrvtqqoyf,umqhynsctfr,120,92.2,1817,281474976716148,50.86,9.399999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,fkqkpvxbflf,tagnzfoql,119,33.65,4891,281474976716545,66.11,5.6999999999999996e+45,d54d0507
+123456,__GENERATION_NUMBER__,eoyghxgfrjzplgou,hdlzfknqxbosx,118,46.43,6552,281474976716081,75.52,4.8e+45,deed0507
+123456,__GENERATION_NUMBER__,xslcarktnyv,fwmxnkxzpecxynd,117,68.26,6707,281474976717764,3.65,9.199999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,eunfqsmgeqsuq,nhfylfsydtljq,116,11.17,5931,281474976717653,45.39,6.699999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,duknmggq,szqxtchvlyapj,115,81.34,7619,281474976718848,45.77,5.9e+45,d54d0507
+123456,__GENERATION_NUMBER__,eznyibdxymlxxjpe,vflhrryakxljgk,114,4.83,3226,281474976711603,63.02,3.4999999999999996e+45,d54d0507
+123456,__GENERATION_NUMBER__,ljuwlnaailbvukpk,dqybtowfjeam,113,48.9,8046,281474976718276,77.92,1.27e+46,01a0bc
+123456,__GENERATION_NUMBER__,lxeryvtla,tfleqgytj,112,0.84,5699,281474976719505,19.4,1.16e+46,deadbeef
+123456,__GENERATION_NUMBER__,qqauxdouqsqi,wgdgbyxnelh,111,63.87,4890,281474976712848,86.99,5.999999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,veployfylfvmeef,kjlnmvknhor,110,50.91,6046,281474976715809,70.37,1.11e+46,deed0507
+123456,__GENERATION_NUMBER__,vhlkvbxnvlx,bmsbxsnyjaxw,109,77.76,6559,281474976711761,59.18,4.0999999999999995e+45,deadbeef
+123456,__GENERATION_NUMBER__,zlbwmgxnnz,yodgfkgrql,108,22.46,5053,281474976712088,34.22,9.399999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,rfsxapvt,nxpnrplbpgjoeu,107,95.67,5095,281474976715480,40.78,4.8999999999999996e+45,deed0507
+123456,__GENERATION_NUMBER__,hgvejbstq,tkilvcqhitbpj,106,70.72,4215,281474976720008,42.46,9.899999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,apzzvfuqjf,ucaijysfzjfye,105,12.42,3516,281474976714220,61.98,1.22e+46,deed0507
+123456,__GENERATION_NUMBER__,afbgttatyupxdo,ojbcwqlbuzitj,104,39.21,9849,281474976711538,37.3,5.1e+45,deadbeef
+123456,__GENERATION_NUMBER__,xufkwmmkjkncpqz,kqvyiazjk,103,45.1,6796,281474976714242,85.86,7.3e+45,deed0507
+123456,__GENERATION_NUMBER__,ajhgllnsxwod,lulylxsufszzdm,102,82.2,3431,281474976716098,44.9,4.4e+45,01a0bc
+123456,__GENERATION_NUMBER__,sbgqnjoai,fvfhwytrgo,101,62.57,9243,281474976710754,2.49,6.9e+45,01a0bc
+123456,__GENERATION_NUMBER__,cnbtaeopmxqpsj,ecxnlhiwhwwwda,100,54.03,8934,281474976718020,12.94,1.17e+46,d54d0507
+123456,__GENERATION_NUMBER__,nfkfbfsrllgrgdly,xnrbjgjvxrqyjpj,99,2.91,2500,281474976710752,47.53,9.699999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,whbrxwjivanye,vxhypzzamnzezy,98,20.4,4331,281474976713230,43.78,1.08e+46,deed0507
+123456,__GENERATION_NUMBER__,fkukjxsndoxnj,sgrcbjrny,97,87.6,4437,281474976713680,67.25,1.28e+46,d54d0507
+123456,__GENERATION_NUMBER__,dxxhgbyosnvwqho,txzlhlmcoaal,96,19.0,3713,281474976718603,37.38,4.8999999999999996e+45,01a0bc
+123456,__GENERATION_NUMBER__,elufxggt,sngwivfd,95,82.07,9018,281474976716090,42.92,6.699999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,wwmfcdozhvws,ktngdbjyoxw,94,4.52,6739,281474976718102,7.62,4e+45,01a0bc
+123456,__GENERATION_NUMBER__,usxafwbxf,dznokellvbsfruz,93,5.03,2298,281474976720352,15.43,1.0999999999999999e+46,deadbeef
+123456,__GENERATION_NUMBER__,fjskvxqa,bbdezcpmzuwigxf,92,82.95,9275,281474976718572,39.92,4.5e+45,01a0bc
+123456,__GENERATION_NUMBER__,fjyuopezztxabod,uyelfedlpytqxo,91,55.12,4297,281474976716016,66.13,1.19e+46,d54d0507
+123456,__GENERATION_NUMBER__,alsnkwmxytgrp,ecgkfpvj,90,86.58,4387,281474976719019,63.47,4.4e+45,deed0507
+123456,__GENERATION_NUMBER__,mcpilzfivcfwci,wldocwdhaqyl,89,62.05,8033,281474976712017,91.08,3.9e+45,01a0bc
+123456,__GENERATION_NUMBER__,pigrefok,lvuziytyuftibms,88,70.65,2084,281474976716587,14.59,3.4999999999999996e+45,d54d0507
+123456,__GENERATION_NUMBER__,wasoxmrfuqgvgjdb,qzpznmueyjca,87,25.18,2917,281474976712269,17.0,3.4e+45,d54d0507
+123456,__GENERATION_NUMBER__,rxlrrpir,iftuxggozntq,86,77.49,2434,281474976712200,69.96,8.1e+45,deed0507
+123456,__GENERATION_NUMBER__,mamolamidbvno,hhgcgpjvwlmmtyz,85,84.24,1690,281474976716943,36.0,1.1999999999999998e+46,deed0507
+123456,__GENERATION_NUMBER__,uconvhdlljpwh,psnonjsnrrfwhb,84,6.82,4399,281474976711009,18.06,8.4e+45,01a0bc
+123456,__GENERATION_NUMBER__,gxpoqveim,tnlrqofla,83,91.27,8631,281474976716228,47.72,8.3e+45,01a0bc
+123456,__GENERATION_NUMBER__,tetkixxoommkevkq,grjxkobxecce,82,56.97,5610,281474976717725,0.8,5.299999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,kjudccdjg,tikqzudyjgd,81,66.64,5666,281474976718621,17.32,9.199999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,xplhyuqx,ykapjdkmhyxlby,80,91.65,6306,281474976715943,29.3,3.4999999999999996e+45,01a0bc
+123456,__GENERATION_NUMBER__,oafkigezjhm,tonilqulap,79,20.99,1935,281474976711738,7.49,4.8e+45,deed0507
+123456,__GENERATION_NUMBER__,pxmdoyhphvnlfjdh,qpxkdqfac,78,16.54,3864,281474976717401,28.1,1.1999999999999998e+46,deadbeef
+123456,__GENERATION_NUMBER__,vvecucowgd,yweiimgh,77,3.61,7925,281474976719082,12.76,9e+45,01a0bc
+123456,__GENERATION_NUMBER__,kfrxgulnsjlhbtce,ujrxijmciqstooxx,76,50.17,2694,281474976719923,10.33,8.4e+45,d54d0507
+123456,__GENERATION_NUMBER__,ubnxsupgwmohkrxt,zvnweyamhkpb,75,80.54,4568,281474976716512,66.91,6.999999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,zbyktggaxnwygkty,zinrhhxpm,74,91.66,1003,281474976717357,64.39,8.199999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,kvtinbruhwtpcr,gmtspcspsufvnjn,73,31.38,1173,281474976714548,52.83,1.24e+46,deadbeef
+123456,__GENERATION_NUMBER__,rhfskvioaeleaqbk,pbtfrwmftji,72,10.78,428,281474976714449,62.58,1.3299999999999999e+46,01a0bc
+123456,__GENERATION_NUMBER__,vwbwxjzsbhov,aqaubqnmzr,71,96.88,8421,281474976716673,0.85,4.0999999999999995e+45,deadbeef
+123456,__GENERATION_NUMBER__,ttptrmhx,ckztddqtjeasc,70,75.62,5997,281474976718553,83.72,6.699999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,uwmgdemic,hkuujhrvr,69,98.18,955,281474976718409,97.41,1.12e+46,d54d0507
+123456,__GENERATION_NUMBER__,teqmgxpbbnzc,vitikeglkovnyog,68,54.37,2294,281474976715298,15.11,4.5999999999999996e+45,deadbeef
+123456,__GENERATION_NUMBER__,jngmurmg,lhekaatc,67,27.37,3009,281474976720326,97.07,7.499999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,rrfwflpvdaqqgtl,lmgxsucivssg,66,92.25,9831,281474976714034,41.82,5.8e+45,deadbeef
+123456,__GENERATION_NUMBER__,dpabhowvzoyu,hraoftht,65,54.67,8208,281474976718286,88.55,1.24e+46,deadbeef
+123456,__GENERATION_NUMBER__,ayiiojerajhqujxr,dnvdlgsfsmcrq,64,93.3,4720,281474976717358,72.85,4e+45,01a0bc
+123456,__GENERATION_NUMBER__,ckvtzhbf,owsdsmkovzh,63,38.05,3764,281474976717803,45.12,5.299999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,nmtjpfrt,pnfzovfuha,62,72.46,321,281474976713434,23.97,6.999999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,cjenybnmxm,pkbfrfghvq,61,82.69,8265,281474976712369,6.34,9.799999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,rhocysed,jvjgtvtgcfvgzwl,60,22.12,3860,281474976719805,33.67,4.8999999999999996e+45,deed0507
+123456,__GENERATION_NUMBER__,eaokyguj,jlhiyveqriu,59,61.45,270,281474976715066,55.53,7.3e+45,01a0bc
+123456,__GENERATION_NUMBER__,weamzfkqpgce,axajapjx,58,24.01,2020,281474976718741,5.95,3.7e+45,deadbeef
+123456,__GENERATION_NUMBER__,xbixgtxk,fmgxlnxqlunnon,57,46.19,8511,281474976712881,81.65,7.1e+45,d54d0507
+123456,__GENERATION_NUMBER__,fnuzzqgppk,aotfnteykzpigb,56,24.74,3841,281474976718093,82.99,5e+45,deed0507
+123456,__GENERATION_NUMBER__,xnjlvkjgkbnkomj,ejejuntgtxcthj,55,90.62,4234,281474976715953,76.98,5.8e+45,deadbeef
+123456,__GENERATION_NUMBER__,ugfmuxtpuq,jwpizvipgslvwevw,54,66.24,9549,281474976712332,83.01,1.3299999999999999e+46,deadbeef
+123456,__GENERATION_NUMBER__,ricxbfulbkkgpl,usptnwylzyb,53,17.61,3825,281474976710747,47.34,1.0299999999999999e+46,deadbeef
+123456,__GENERATION_NUMBER__,bvtktlpx,zccwswyuzjkut,52,96.87,7425,281474976713542,49.62,1.0299999999999999e+46,deadbeef
+123456,__GENERATION_NUMBER__,zuxdwycbhjawnj,trxqsneswgrfvve,51,32.04,3765,281474976713704,49.89,7.8e+45,deed0507
+123456,__GENERATION_NUMBER__,cqylxgsahcd,tufyuwkhch,50,48.4,7911,281474976713726,47.67,4.5e+45,deed0507
+123456,__GENERATION_NUMBER__,vnmcfwgo,xihksstzymn,49,37.55,2970,281474976712080,67.72,8e+45,deadbeef
+123456,__GENERATION_NUMBER__,xsnpecgi,fwqisuyk,48,96.68,1592,281474976712841,18.06,1.17e+46,deed0507
+123456,__GENERATION_NUMBER__,hkfpcoid,hmmoaqpotomibfzo,47,64.1,199,281474976717164,98.31,8.1e+45,01a0bc
+123456,__GENERATION_NUMBER__,yqpggqrcvbw,bafwbemnwvh,46,72.83,2848,281474976717809,18.38,6.8e+45,01a0bc
+123456,__GENERATION_NUMBER__,lwkwlggjheerjlg,uihfoyuxhxu,45,25.97,7087,281474976719346,38.77,7.1e+45,deadbeef
+123456,__GENERATION_NUMBER__,zfqflcterfs,ufwwcujrhcvkrpy,44,64.27,4065,281474976713510,50.22,1.13e+46,01a0bc
+123456,__GENERATION_NUMBER__,eumshameyw,rhjkwlxzdhgmzn,43,20.31,7248,281474976717506,65.01,5.5e+45,d54d0507
+123456,__GENERATION_NUMBER__,roxuocru,yullwywdfyhlt,42,27.17,1823,281474976712006,25.99,1.08e+46,deed0507
+123456,__GENERATION_NUMBER__,zttimwlcqcvm,obkohidgfprefiz,41,39.16,8578,281474976717271,45.49,4.8e+45,deadbeef
+123456,__GENERATION_NUMBER__,umsmfqhnoffu,dlfgxybnhlrqt,40,89.06,8817,281474976715987,87.47,9.999999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,ecomeufjsypnhohg,jzvlyacbo,39,43.75,1596,281474976716076,13.27,1.22e+46,01a0bc
+123456,__GENERATION_NUMBER__,nklzlsmfv,egltxnwjvzk,38,87.69,9389,281474976716045,99.25,1.02e+46,d54d0507
+123456,__GENERATION_NUMBER__,wjdmjubfcqgw,vrthjjjdbtx,37,75.71,186,281474976712194,97.88,1.01e+46,deadbeef
+123456,__GENERATION_NUMBER__,xppviuuvjnk,eqmhxrdgmwwke,36,9.57,1575,281474976712280,82.55,7.699999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,tvnavohmxmp,iiwfxrgacg,35,23.76,6292,281474976716413,29.94,4.0999999999999995e+45,01a0bc
+123456,__GENERATION_NUMBER__,vagvdedlzpz,ctflwygdnpxpw,34,25.76,778,281474976716966,85.37,6.999999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,kqbvqbimrcr,xvpbwjqoiuquvvax,33,9.42,3254,281474976713035,98.07,1.27e+46,deadbeef
+123456,__GENERATION_NUMBER__,qweynwdvyzdodc,szjvopztwyzqrcp,32,73.17,526,281474976714171,23.71,1.25e+46,01a0bc
+123456,__GENERATION_NUMBER__,vhfclcfg,meztanii,31,75.1,1538,281474976717551,0.83,4.0999999999999995e+45,01a0bc
+123456,__GENERATION_NUMBER__,xlmgmrjwaxleibcs,lagskjltqu,30,12.64,5941,281474976718491,7.58,1.22e+46,deadbeef
+123456,__GENERATION_NUMBER__,zejixznpakypdygo,gtsgiaouxmeeo,29,83.79,6655,281474976717947,78.95,9.699999999999999e+45,d54d0507
+123456,__GENERATION_NUMBER__,qhxhpljzabto,ojiqtavap,28,45.71,6362,281474976713146,41.49,6.9e+45,deadbeef
+123456,__GENERATION_NUMBER__,jjdinaqqna,vridqoqxbxichca,27,55.52,4200,281474976714638,40.1,8.1e+45,deadbeef
+123456,__GENERATION_NUMBER__,nmmsoreqysdk,bqjtpozs,26,36.92,9789,281474976713113,77.47,9.199999999999999e+45,deed0507
+123456,__GENERATION_NUMBER__,wejliowjuxgko,xrxjxoufzwg,25,12.83,19,281474976711657,35.02,7.4e+45,deadbeef
+123456,__GENERATION_NUMBER__,jlfzjxzdtpzm,axfzihwxrrk,24,97.12,585,281474976715502,89.05,6.8e+45,deed0507
+123456,__GENERATION_NUMBER__,miklxwhxxcgukhd,oilejrgore,23,89.18,9044,281474976719956,51.64,5.299999999999999e+45,01a0bc
+123456,__GENERATION_NUMBER__,udlezddrpcq,hnjycyrs,22,18.23,2072,281474976713202,70.92,6.9e+45,01a0bc
+123456,__GENERATION_NUMBER__,mwbchioitdcbcpz,utjtowoqxz,21,24.77,920,281474976720481,55.63,4.5999999999999996e+45,01a0bc
+123456,__GENERATION_NUMBER__,ssktofrva,erpsllhnquiz,20,39.72,2749,281474976713155,28.1,1.0499999999999999e+46,01a0bc
+123456,__GENERATION_NUMBER__,qvhpsnoulqxdcmbr,fjrwoxufgleggvlc,19,92.92,3267,281474976711695,3.29,1.27e+46,d54d0507
+123456,__GENERATION_NUMBER__,rnpejlea,ncwczezrpyxbpom,18,2.73,4831,281474976715918,42.61,1.01e+46,d54d0507
+123456,__GENERATION_NUMBER__,exuzwdvgzodhtk,kaeypxeghd,17,17.61,2209,281474976712077,21.22,7.9e+45,deed0507
+123456,__GENERATION_NUMBER__,kmoojiwuplmfach,ypxnalqzxxmso,16,43.55,5217,281474976713394,5.62,4.0999999999999995e+45,deed0507
+123456,__GENERATION_NUMBER__,btoacpgils,lxmzsvlinokim,15,89.53,6069,281474976717300,29.01,3.7999999999999995e+45,d54d0507
+123456,__GENERATION_NUMBER__,vamxyquxwugo,tgqqyvmivowuwm,14,87.69,1191,281474976718056,43.11,9.6e+45,deed0507
+123456,__GENERATION_NUMBER__,uvzrwmtycpkye,njvuxhvlnuwowllj,13,46.15,9005,281474976713458,81.42,7.8e+45,deed0507
+123456,__GENERATION_NUMBER__,fevthysr,xjuxfwioegtp,12,73.19,873,281474976712030,91.71,4.8999999999999996e+45,deadbeef
+123456,__GENERATION_NUMBER__,wvouwhhlkbkhzlsl,gdmbgwoebiu,11,18.99,4119,281474976719097,57.08,4.6999999999999994e+45,d54d0507
+123456,__GENERATION_NUMBER__,ukjlpvsqjbakvwgq,fygcvkauspczcvxg,10,95.01,4224,281474976719894,49.63,6.1e+45,deed0507
+123456,__GENERATION_NUMBER__,hcqapafepmu,xhjeavrutltde,9,22.44,1397,281474976715751,90.35,1.0299999999999999e+46,d54d0507
+123456,__GENERATION_NUMBER__,xaoqldkhnqeslf,hquvdmomblsdgk,8,77.99,2348,281474976717334,82.13,6.1e+45,d54d0507
+123456,__GENERATION_NUMBER__,oerfxfdpqgr,eebimdxgtx,7,24.7,1802,281474976719813,54.11,7.199999999999999e+45,deadbeef
+123456,__GENERATION_NUMBER__,aicamshbktymth,fsmfgyhjjohw,6,20.52,9767,281474976716841,50.86,1.21e+46,d54d0507
+123456,__GENERATION_NUMBER__,rgudsxzvn,gusdcmkdej,5,4.57,6313,281474976714696,80.47,8.5e+45,01a0bc
+123456,__GENERATION_NUMBER__,jkuhidefpqry,nxnjlzdrtnwpwvu,4,98.57,2064,281474976714265,60.0,3.7e+45,deed0507
+123456,__GENERATION_NUMBER__,tsvknmxua,hkfviagqwaodjs,3,0.88,5881,281474976720355,54.82,1.07e+46,deed0507
+123456,__GENERATION_NUMBER__,udiyszdw,ezxcchzpb,2,63.57,2805,281474976717544,5.44,4.0999999999999995e+45,deadbeef
+123456,__GENERATION_NUMBER__,bhxpgexg,oydnfucyiov,1,30.83,5590,281474976718795,44.23,1.11e+46,d54d0507
diff --git a/compatibility-verifier/sample-test-suite/config/data/recordReaderConfig-FeatureTest3.json b/compatibility-verifier/sample-test-suite/config/data/recordReaderConfig-FeatureTest3.json
new file mode 100644
index 0000000000..b2c552379a
--- /dev/null
+++ b/compatibility-verifier/sample-test-suite/config/data/recordReaderConfig-FeatureTest3.json
@@ -0,0 +1,5 @@
+{
+ "commentMarker" : "#",
+ "header" :
+ "HoursSinceEpoch,generationNumber,stringDimSV1,stringDimSV2,longDimSV1,doubleDimSV1,intMetric1,longMetric1,floatMetric1,doubleMetric1,bytesMetric1"
+}
diff --git a/compatibility-verifier/sample-test-suite/config/dataGenerator.py b/compatibility-verifier/sample-test-suite/config/dataGenerator.py
new file mode 100644
index 0000000000..346f2ad7b2
--- /dev/null
+++ b/compatibility-verifier/sample-test-suite/config/dataGenerator.py
@@ -0,0 +1,93 @@
+#
+# 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.
+#
+
+import random
+import csv
+import string
+
+'''Script used for one time random generation of test data FeatureTest3-data-realtime-00.csv,
+ do not use for adding new columns in existing dataset. Left this here for future reference. '''
+
+class DataGenerator:
+
+ def __init__(self):
+ self.__NUMBER_OF_LINES = 300
+ self.__RANGE_OF_LONG_IDX = 100
+ self.__RANGE_OF_DOUBLE_IDX = 100
+ self.__VAR_LEN_STRING_LOWER = 8
+ self.__VAR_LEN_STRING_UPPER = 16
+ return
+
+ def generateLine(self, longDimSV2Prev):
+ line = []
+
+ # hours since epoch
+ line.append("123456")
+
+ # generationNumber
+ line.append("__GENERATION_NUMBER__")
+
+ # stringDimSV1 varlen,bloom
+ letters = string.ascii_lowercase
+ num_letters = random.randint(self.__VAR_LEN_STRING_LOWER, self.__VAR_LEN_STRING_UPPER)
+ line.append(''.join(random.choice(letters) for _ in range(num_letters)))
+
+ # stringDimSV2 noDict
+ letters = string.ascii_lowercase
+ num_letters = random.randint(self.__VAR_LEN_STRING_LOWER, self.__VAR_LEN_STRING_UPPER)
+ line.append(''.join(random.choice(letters) for _ in range(num_letters)))
+
+ # longDimSV1 sorted
+ line.append(longDimSV2Prev[0])
+ longDimSV2Prev[0] -= 1
+
+ # doubleDimSV1 range
+ line.append(random.randint(0, self.__RANGE_OF_DOUBLE_IDX * 100) / 100)
+
+ # SV intMetric1 noDict
+ line.append(random.randint(0, 10000))
+
+ # SV longMetric1 noDict
+ line.append(2**48+random.randint(0, 10000))
+
+ # SV floatMetric1 noDict
+ line.append(random.randint(0, 10000) / 100)
+
+ # SV doubleMetric1 noDict
+ line.append(3.4E45+random.randint(0, 100) / 10 * (10**45))
+
+ # SV bytesMetric1 noDict
+ line.append(random.choice(["deadbeef", "deed0507", "01a0bc", "d54d0507"]))
+
+ return line
+
+ def generateLines(self):
+ ret = []
+ longDimSV2 = [self.__NUMBER_OF_LINES]
+ for _ in range(self.__NUMBER_OF_LINES):
+ ret.append(self.generateLine(longDimSV2))
+
+ return ret
+
+
+if __name__ == '__main__':
+ dataGenerator = DataGenerator()
+ with open('FeatureTest3-data-realtime-00.csv', 'w', newline='') as csvfile:
+ writer = csv.writer(csvfile, quotechar='\'', delimiter=',')
+ writer.writerows(dataGenerator.generateLines())
diff --git a/compatibility-verifier/sample-test-suite/config/feature-test-1.json b/compatibility-verifier/sample-test-suite/config/feature-test-1.json
index 77ce7ff976..381e6885d1 100644
--- a/compatibility-verifier/sample-test-suite/config/feature-test-1.json
+++ b/compatibility-verifier/sample-test-suite/config/feature-test-1.json
@@ -32,7 +32,7 @@
"enableDefaultStarTree": false,
"enableDynamicStarTreeCreation": false,
"loadMode": "MMAP",
- "noDictionaryColumns": [],
+ "noDictionaryColumns": ["textDim1"],
"nullHandlingEnabled": false,
"sortedColumn": [],
"streamConfigs": {}
diff --git a/compatibility-verifier/sample-test-suite/config/feature-test-3-realtime-stream-config.json b/compatibility-verifier/sample-test-suite/config/feature-test-3-realtime-stream-config.json
new file mode 100644
index 0000000000..f08b58afe5
--- /dev/null
+++ b/compatibility-verifier/sample-test-suite/config/feature-test-3-realtime-stream-config.json
@@ -0,0 +1,8 @@
+{
+ "streamType": "kafka",
+ "stream.kafka.consumer.type": "simple",
+ "topicName": "PinotRealtimeFeatureTest3Event",
+ "partitionColumn": "longDimSV1",
+ "numPartitions": "3",
+ "stream.kafka.consumer.prop.auto.offset.reset": "smallest"
+}
diff --git a/compatibility-verifier/sample-test-suite/config/feature-test-3-realtime.json b/compatibility-verifier/sample-test-suite/config/feature-test-3-realtime.json
new file mode 100644
index 0000000000..ee281b7d35
--- /dev/null
+++ b/compatibility-verifier/sample-test-suite/config/feature-test-3-realtime.json
@@ -0,0 +1,59 @@
+{
+ "tableIndexConfig": {
+ "aggregateMetrics": false,
+ "autoGeneratedInvertedIndex": false,
+ "createInvertedIndexDuringSegmentGeneration": false,
+ "enableDefaultStarTree": false,
+ "enableDynamicStarTreeCreation": false,
+ "loadMode": "MMAP",
+ "noDictionaryColumns": ["stringDimSV2","intMetric1", "longMetric1", "floatMetric1", "doubleMetric1", "bytesMetric1"],
+ "nullHandlingEnabled": false,
+ "segmentFormatVersion": "v3",
+ "bloomFilterColumns": ["stringDimSV1"],
+ "rangeIndexColumns": ["doubleDimSV1"],
+ "varLengthDictionaryColumns": ["stringDimSV1"],
+ "segmentPartitionConfig": {
+ "columnPartitionMap": {
+ "longDimSV1": {
+ "functionName": "Modulo",
+ "numPartitions": 3
+ }
+ }
+ },
+ "streamConfigs": {
+ "realtime.segment.flush.threshold.size": "63",
+ "realtime.segment.flush.threshold.time": "1h",
+ "streamType": "kafka",
+ "stream.kafka.topic.name": "PinotRealtimeFeatureTest3Event",
+ "stream.kafka.consumer.type": "simple",
+ "stream.kafka.decoder.class.name": "org.apache.pinot.plugin.stream.kafka.KafkaJSONMessageDecoder",
+ "stream.kafka.consumer.factory.class.name": "org.apache.pinot.plugin.stream.kafka20.KafkaConsumerFactory",
+ "stream.kafka.broker.list": "localhost:19092",
+ "stream.kafka.zk.broker.url": "localhost:2181/kafka",
+ "stream.kafka.consumer.prop.auto.offset.reset": "largest"
+ }
+ },
+ "metadata": {
+ "customConfigs": {
+ "d2Name": ""
+ }
+ },
+ "segmentsConfig": {
+ "replicasPerPartition": "1",
+ "replication": "1",
+ "retentionTimeUnit": "",
+ "retentionTimeValue": "",
+ "schemaName": "FeatureTest3",
+ "segmentAssignmentStrategy": "BalanceNumSegmentAssignmentStrategy",
+ "segmentPushFrequency": "daily",
+ "segmentPushType": "APPEND",
+ "timeColumnName": "HoursSinceEpoch",
+ "timeType": "HOURS"
+ },
+ "tableName": "FeatureTest3",
+ "tableType": "REALTIME",
+ "tenants": {
+ "broker": "DefaultTenant",
+ "server": "DefaultTenant"
+ }
+}
diff --git a/compatibility-verifier/sample-test-suite/config/queries/feature-test-3-sql-realtime.queries b/compatibility-verifier/sample-test-suite/config/queries/feature-test-3-sql-realtime.queries
new file mode 100644
index 0000000000..d3168b780a
--- /dev/null
+++ b/compatibility-verifier/sample-test-suite/config/queries/feature-test-3-sql-realtime.queries
@@ -0,0 +1,47 @@
+#
+# 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.
+#
+
+# rangeIndex[doubleDimSV1]
+SELECT longDimSV1, doubleDimSV1 from FeatureTest3 WHERE doubleDimSV1 > 90 and generationNumber = __GENERATION_NUMBER__ LIMIT 1000
+SELECT longDimSV1, doubleDimSV1 from FeatureTest3 WHERE doubleDimSV1 > 10 AND doubleDimSV1 < 20 AND generationNumber = __GENERATION_NUMBER__ LIMIT 1000
+SELECT longDimSV1, doubleDimSV1 from FeatureTest3 WHERE doubleDimSV1 > 99 AND generationNumber = __GENERATION_NUMBER__ LIMIT 1000
+SELECT longDimSV1, doubleDimSV1 from FeatureTest3 WHERE doubleDimSV1 < 0 AND generationNumber = __GENERATION_NUMBER__ LIMIT 1000
+SELECT longDimSV1, doubleDimSV1 from FeatureTest3 WHERE doubleDimSV1 < 20 AND generationNumber = __GENERATION_NUMBER__ LIMIT 1000
+SELECT longDimSV1, doubleDimSV1 from FeatureTest3 WHERE doubleDimSV1 > 45 AND doubleDimSV1 < 55 AND generationNumber = __GENERATION_NUMBER__ LIMIT 1000
+
+# bloomFilterColumns[stringDimSV1]; varLengthDictionaryColumns[stringDimSV1]; noDictionaryColumns["stringDimSV2","intMetric1", "longMetric1", "floatMetric1", "doubleMetric1", "bytesMetric1"]
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE stringDimSV1='qmxauaacotyezcqw' AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE stringDimSV1='qndigjvg' AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE stringDimSV1='pbbeecjjabupkrf' AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE stringDimSV1='wmwxikmztrzrb' AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE stringDimSV1='ljuwlnaailbvukpk' AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE stringDimSV1='mcpilzfivcfwci' AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE stringDimSV1='pigrefok' AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE stringDimSV1='mamolamidbvmo' AND generationNumber = __GENERATION_NUMBER__
+
+# partitionedColumn[longDimSV1]; varLengthDictionaryColumns[stringDimSV1]; noDictionaryColumns["stringDimSV2","intMetric1", "longMetric1", "floatMetric1", "doubleMetric1", "bytesMetric1"]
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 IN (1, 2, 3) AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 IN (1, 4, 7) AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 IN (298, 299, 300) AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 IN (294, 297, 300) AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 IN (150, 153, 156) AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 IN (149, 152, 155) AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 = 7 AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 = 8 AND generationNumber = __GENERATION_NUMBER__
+SELECT stringDimSV1, stringDimSV2, intMetric1, longMetric1, floatMetric1, doubleMetric1, bytesMetric1 FROM FeatureTest3 WHERE longDimSV1 = 9 AND generationNumber = __GENERATION_NUMBER__
diff --git a/compatibility-verifier/sample-test-suite/config/query-results/feature-test-1-rest-sql.results b/compatibility-verifier/sample-test-suite/config/query-results/feature-test-1-rest-sql.results
index 52cc78c3c6..83ae247116 100644
--- a/compatibility-verifier/sample-test-suite/config/query-results/feature-test-1-rest-sql.results
+++ b/compatibility-verifier/sample-test-suite/config/query-results/feature-test-1-rest-sql.results
@@ -18,86 +18,86 @@
#
# Aggregation
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG"],"columnNames":["count(*)"]},"rows":[[10]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":4,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
-{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"]},"rows":[[4.294967536E9,-2.147479976E9,0.0,6.0,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesSc [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"]},"rows":[[10,19,114.09000263214111,1516.9,250.00000000000003,6656.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScann [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"],"columnNames":["percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"]},"rows":[[7611.0,462.0,7611,462,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegme [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["INT","INT","LONG","LONG"],"columnNames":["distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"]},"rows":[[6,8,6,8]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":20,"numGroupsL [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG"],"columnNames":["count(*)"]},"rows":[[10]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":4,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
+{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"]},"rows":[[4.294967536E9,-2.147479976E9,0.0,6.0,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":40,"numGroupsLi [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"]},"rows":[[10,19,114.09000263214111,1516.9,250.00000000000003,6656.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFil [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"],"columnNames":["percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"]},"rows":[[7611.0,462.0,7611,462,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegme [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["INT","INT","LONG","LONG"],"columnNames":["distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"]},"rows":[[6,8,6,8]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":20,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":6,"segmentStati [...]
# Selection
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","STRING","STRING","BYTES"],"columnNames":["longDimSV2","stringDimSV1","textDim1","bytesDimSV1"]},"rows":[[2,"s1-0","Java C++ Python","4877625602"],[2,"s1-0","Java C++ Python","01a0bc"],[21,"s1-2","Java C++ golang","13225573e3f5"],[21,"s1-2","Java C++ golang","deadbeef"],[22,"s1-4","Java C++ golang","deed0507"],[32,"s1-5","golang shell bash",""],[6777,"s1-7","golang Java","d54d0507"],[7621,"s1-6","C++ golang python","deed0507"],[7621 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","STRING","STRING","BYTES"],"columnNames":["longDimSV2","stringDimSV1","textDim1","bytesDimSV1"]},"rows":[[7621,"s1-6","C++ golang python","deed0507"],[7621,"s1-6","C++ golang python","deed0507"],[7621,"s1-6","C++ golang python","deed0507"],[6777,"s1-7","golang Java","d54d0507"],[32,"s1-5","golang shell bash",""],[22,"s1-4","Java C++ golang","deed0507"],[21,"s1-2","Java C++ golang","13225573e3f5"],[21,"s1-2","Java C++ golang","deadbe [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","STRING","STRING","BYTES"],"columnNames":["longDimSV2","stringDimSV1","textDim1","bytesDimSV1"]},"rows":[[7621,"s1-6","C++ golang python","deed0507"],[7621,"s1-6","C++ golang python","deed0507"],[7621,"s1-6","C++ golang python","deed0507"],[6777,"s1-7","golang Java","d54d0507"],[32,"s1-5","golang shell bash",""],[22,"s1-4","Java C++ golang","deed0507"],[21,"s1-2","Java C++ golang","13225573e3f5"],[21,"s1-2","Java C++ golang","deadbe [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","STRING","STRING","BYTES"],"columnNames":["longDimSV2","stringDimSV1","textDim1","bytesDimSV1"]},"rows":[[2,"s1-0","Java C++ Python","4877625602"],[2,"s1-0","Java C++ Python","01a0bc"],[21,"s1-2","Java C++ golang","13225573e3f5"],[21,"s1-2","Java C++ golang","deadbeef"],[22,"s1-4","Java C++ golang","deed0507"],[32,"s1-5","golang shell bash",""],[6777,"s1-7","golang Java","d54d0507"],[7621,"s1-6","C++ golang python","deed0507"],[7621 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","STRING","STRING","BYTES"],"columnNames":["longDimSV2","stringDimSV1","textDim1","bytesDimSV1"]},"rows":[[7621,"s1-6","C++ golang python","deed0507"],[7621,"s1-6","C++ golang python","deed0507"],[7621,"s1-6","C++ golang python","deed0507"],[6777,"s1-7","golang Java","d54d0507"],[32,"s1-5","golang shell bash",""],[22,"s1-4","Java C++ golang","deed0507"],[21,"s1-2","Java C++ golang","13225573e3f5"],[21,"s1-2","Java C++ golang","deadbe [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","STRING","STRING","BYTES"],"columnNames":["longDimSV2","stringDimSV1","textDim1","bytesDimSV1"]},"rows":[[7621,"s1-6","C++ golang python","deed0507"],[7621,"s1-6","C++ golang python","deed0507"],[7621,"s1-6","C++ golang python","deed0507"],[6777,"s1-7","golang Java","d54d0507"],[32,"s1-5","golang shell bash",""],[22,"s1-4","Java C++ golang","deed0507"],[21,"s1-2","Java C++ golang","13225573e3f5"],[21,"s1-2","Java C++ golang","deadbe [...]
# Selection & Filtering
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","DOUBLE"],"columnNames":["textDim1","longDimSV2","doubleMetric1"]},"rows":[["Java C++ golang",22,24.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":4,"numEntriesScannedInFilter":10,"numEntr [...]
-{"isSuperset":true,"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","DOUBLE"],"columnNames":["textDim1","longDimSV2","doubleMetric1"]},"rows":[["Java C++ golang",22,24.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":4,"numEntriesScannedInF [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","DOUBLE"],"columnNames":["textDim1","longDimSV2","doubleMetric1"]},"rows":[["Java C++ golang",22,24.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":4,"numEntriesScannedInFilter":10,"numEntr [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY","INT_ARRAY","STRING_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1","intDimMV2","stringDimMV2"]},"rows":[["s1-5",-9223372036854775808,[-2147483648],[92,22],["m2-2-0"]],["s1-2",11,[32,42],[62,72],["m2-2-0","m2-2-1"]],["s1-2",11,[32,42],[62,72],["m2-3-0","m2-3-1"]],["s1-4",41,[42,52],[72,82],["m2-2-0","m2-2-1"]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1," [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY","INT_ARRAY","STRING_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1","intDimMV2","stringDimMV2"]},"rows":[["s1-4",41,[42,52],[72,82],["m2-2-0","m2-2-1"]],["s1-2",11,[32,42],[62,72],["m2-2-0","m2-2-1"]],["s1-2",11,[32,42],[62,72],["m2-3-0","m2-3-1"]],["s1-5",-9223372036854775808,[-2147483648],[92,22],["m2-2-0"]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1," [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY","INT_ARRAY","STRING_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1","intDimMV2","stringDimMV2"]},"rows":[["s1-4",41,[42,52],[72,82],["m2-2-0","m2-2-1"]],["s1-2",11,[32,42],[62,72],["m2-3-0","m2-3-1"]],["s1-2",11,[32,42],[62,72],["m2-2-0","m2-2-1"]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSeg [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","DOUBLE"],"columnNames":["textDim1","longDimSV2","doubleMetric1"]},"rows":[["Java C++ golang",22,24.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":4,"numEntriesScannedPostFilter":12,"numGroupsLimitReached":false,"totalDo [...]
+{"isSuperset":true,"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","DOUBLE"],"columnNames":["textDim1","longDimSV2","doubleMetric1"]},"rows":[["Java C++ golang",22,24.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":4,"numEntriesScannedPostFilter":12,"numGroupsLimitReach [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","DOUBLE"],"columnNames":["textDim1","longDimSV2","doubleMetric1"]},"rows":[["Java C++ golang",22,24.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1],["C++ golang python",7621,263.1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":4,"numEntriesScannedPostFilter":12,"numGroupsLimitReached":false,"totalDo [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY","INT_ARRAY","STRING_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1","intDimMV2","stringDimMV2"]},"rows":[["s1-5",-9223372036854775808,[-2147483648],[92,22],["m2-2-0"]],["s1-2",11,[32,42],[62,72],["m2-2-0","m2-2-1"]],["s1-2",11,[32,42],[62,72],["m2-3-0","m2-3-1"]],["s1-4",41,[42,52],[72,82],["m2-2-0","m2-2-1"]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1," [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY","INT_ARRAY","STRING_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1","intDimMV2","stringDimMV2"]},"rows":[["s1-4",41,[42,52],[72,82],["m2-2-0","m2-2-1"]],["s1-2",11,[32,42],[62,72],["m2-2-0","m2-2-1"]],["s1-2",11,[32,42],[62,72],["m2-3-0","m2-3-1"]],["s1-5",-9223372036854775808,[-2147483648],[92,22],["m2-2-0"]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1," [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY","INT_ARRAY","STRING_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1","intDimMV2","stringDimMV2"]},"rows":[["s1-4",41,[42,52],[72,82],["m2-2-0","m2-2-1"]],["s1-2",11,[32,42],[62,72],["m2-3-0","m2-3-1"]],["s1-2",11,[32,42],[62,72],["m2-2-0","m2-2-1"]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned" [...]
# Selection & Grouping on Aggregation
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","LONG"],"columnNames":["longDimSV1","intDimMV1","count(*)"]},"rows":[[-9223372036854775808,-2147483648,1],[1,3,2],[1,4,2],[11,42,2],[11,32,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":20,"numGroupsLimitReached":false,"totalDo [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"]},"rows":[[-9223372036854775808,-2147483648,0.0,-2.147483648E9,0.0,22.0,-9.223372036854776E18,-2.147483648E9],[1,3,20.0,14.0,10.0,6.0,1.0,4.0],[1,4,20.0,14.0,10.0,6.0,1.0,4.0],[11,42,20.0,148.0,10.0,62.0,11.0,42.0],[11,32,20 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"]},"rows":[[-9223372036854775808,-2147483648,1,1,0.0,57.0,0.0,70.0],[1,3,2,4,12.100000381469727,6.5,0.0,1.0],[1,4,2,4,12.100000381469727,6.5,0.0,1.0],[11,42,2,4,22.100000381469727,67.0,0.0,10.0],[11,32,2,4,22.1000 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"]},"rows":[[-9223372036854775808,-2147483648,-9.223372036854776E18,-2.147483648E9,-9223372036854775808,-2147483648,-9.2233720368547 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","INT","INT","LONG","LONG"],"columnNames":["longDimSV1","intDimMV1","distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"]},"rows":[[-9223372036854775808,-2147483648,1,1,1,1],[1,3,1,2,1,2],[1,4,1,2,1,2],[11,42,1,2,1,2],[11,32,1,2,1,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatche [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","LONG"],"columnNames":["longDimSV1","intDimMV1","count(*)"]},"rows":[[-9223372036854775808,-2147483648,1],[1,3,2],[1,4,2],[11,42,2],[11,32,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":20,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":14,"segmentStatistics":[],"traceInfo":{}," [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"]},"rows":[[-9223372036854775808,-2147483648,0.0,-2.147483648E9,0.0,22.0,-9.223372036854776E18,-2.147483648E9],[1,3,20.0,14.0,10.0,6.0,1.0,4.0],[1,4,20.0,14.0,10.0,6.0,1.0,4.0],[11,42,20.0,148.0,10.0,62.0,11.0,42.0],[11,32,20 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"]},"rows":[[-9223372036854775808,-2147483648,1,1,0.0,57.0,0.0,70.0],[1,3,2,4,12.100000381469727,6.5,0.0,1.0],[1,4,2,4,12.100000381469727,6.5,0.0,1.0],[11,42,2,4,22.100000381469727,67.0,0.0,10.0],[11,32,2,4,22.1000 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"]},"rows":[[-9223372036854775808,-2147483648,-9.223372036854776E18,-2.147483648E9,-9223372036854775808,-2147483648,-9.2233720368547 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","INT","INT","LONG","LONG"],"columnNames":["longDimSV1","intDimMV1","distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"]},"rows":[[-9223372036854775808,-2147483648,1,1,1,1],[1,3,1,2,1,2],[1,4,1,2,1,2],[11,42,1,2,1,2],[11,32,1,2,1,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatche [...]
# Selection & Filtering & Grouping on Aggregation
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","LONG"],"columnNames":["longDimSV1","intDimMV1","count(*)"]},"rows":[[-9223372036854775808,-2147483648,1],[11,32,2],[11,42,2],[41,42,1],[41,52,1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":4,"numEntriesScannedInFilter":33,"numEntriesScannedPostFilter":8,"numGroupsLimitReached":false,"tota [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"]},"rows":[[-9223372036854775808,-2147483648,0,-2147483648,0,22,-9223372036854776000,-2147483648],[11,32,20,148,10,62,11,42],[11,42,20,148,10,62,11,42],[41,42,14,94,14,72,41,52],[41,52,14,94,14,72,41,52]]},"exceptions":[],"nu [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"]},"rows":[[-9223372036854775808,-2147483648,1,1,0,57,0,70],[11,32,2,4,22.100000381469727,67,0,10],[11,42,2,4,22.100000381469727,67,0,10],[41,42,1,2,24.100000381469727,77,0,10],[41,52,1,2,24.100000381469727,77,0,1 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"]},"rows":[[-9223372036854775808,-2147483648,-9223372036854775808,-2147483648,-9223372036854775808,-2147483648,-9223372036854776000 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","INT","INT","LONG","LONG"],"columnNames":["longDimSV1","intDimMV1","distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"]},"rows":[[-9223372036854775808,-2147483648,1,1,1,1],[11,32,1,2,1,2],[11,42,1,2,1,2],[41,42,1,2,1,2],[41,52,1,2,1,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMa [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","LONG"],"columnNames":["longDimSV1","intDimMV1","count(*)"]},"rows":[[-9223372036854775808,-2147483648,1],[11,32,2],[11,42,2],[41,42,1],[41,52,1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":4,"numEntriesScannedPostFilter":8,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":8,"segmentStatistics":[],"traceInfo":{}, [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"]},"rows":[[-9223372036854775808,-2147483648,0,-2147483648,0,22,-9223372036854776000,-2147483648],[11,32,20,148,10,62,11,42],[11,42,20,148,10,62,11,42],[41,42,14,94,14,72,41,52],[41,52,14,94,14,72,41,52]]},"exceptions":[],"nu [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"]},"rows":[[-9223372036854775808,-2147483648,1,1,0,57,0,70],[11,32,2,4,22.100000381469727,67,0,10],[11,42,2,4,22.100000381469727,67,0,10],[41,42,1,2,24.100000381469727,77,0,10],[41,52,1,2,24.100000381469727,77,0,1 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"],"columnNames":["longDimSV1","intDimMV1","percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"]},"rows":[[-9223372036854775808,-2147483648,-9223372036854775808,-2147483648,-9223372036854775808,-2147483648,-9223372036854776000 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","INT","INT","INT","LONG","LONG"],"columnNames":["longDimSV1","intDimMV1","distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"]},"rows":[[-9223372036854775808,-2147483648,1,1,1,1],[11,32,1,2,1,2],[11,42,1,2,1,2],[41,42,1,2,1,2],[41,52,1,2,1,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMa [...]
# Transformation Functions
-{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE"],"columnNames":["add(longDimSV1,sub(longDimSV2,'3'))","mod(intMetric1,'10')","div(doubleMetric1,mult(floatMetric1,'5'))"]},"rows":[[15229.0,1.0,0.20076306285631254],[15229.0,7.0,0.20076306285631254],[15229.0,7.0,0.20076306285631254],[13540.0,7.0,0.20076306285631254],[60.0,4.0,0.1999999968342762],[29.0,0.0,0.20904977014723267],[29.0,0.0,0.20904977014723267],[0.0,0.0,0.21652891879345226],[0.0,0.0,0.2165289187934522 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE"],"columnNames":["floor(sqrt(doubleMetric1))","ceil(ln(longDimSV1))","exp(mod(abs(longDimSV2),'3'))"]},"rows":[[3.0,0.0,7.38905609893065],[3.0,0.0,7.38905609893065],[4.0,3.0,1.0],[4.0,3.0,1.0],[4.0,4.0,2.718281828459045],[4.0,"NaN",7.38905609893065],[16.0,9.0,2.718281828459045],[16.0,9.0,2.718281828459045],[16.0,9.0,2.718281828459045],[16.0,9.0,1.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1," [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG"],"columnNames":["count(*)"]},"rows":[[6],[1],[3]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":20,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":9,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
-{"resultTable":{"dataSchema":{"columnDataTypes":["INT","LONG"],"columnNames":["valuein(intDimMV1,'3','32')","count(*)"]},"rows":[[3,2],[32,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":18,"segmentStatistics":[],"traceInfo":{}," [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING","STRING","STRING","STRING"],"columnNames":["upper(stringDimSV1)","lower(textDim1)","reverse(stringDimSV2)","ltrim(substr(textDim1,'4','9'))","rtrim(substr(textDim1,'4','9'))"]},"rows":[["S1-0","java c++ python","0-2s","C++ "," C++"],["S1-0","java c++ python","0-2s","C++ "," C++"],["S1-2","java c++ golang","2-2s","C++ "," C++"],["S1-2","java c++ golang","2-2s","C++ "," C++"],["S1-4","java c++ golang","4-2s","C++ "," C++"], [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING","INT","STRING","STRING"],"columnNames":["stringDimSV2","replace(stringDimSV2,'foo','bar')","codepoint(stringDimSV2)","rpad(stringDimSV2,'11','abc')","lpad(stringDimSV2,'11','xyz')"]},"rows":[["s2-2","s2-2",115,"s2-2abcabca","xyzxyzxs2-2"],["s2-2","s2-2",115,"s2-2abcabca","xyzxyzxs2-2"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"nu [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE"],"columnNames":["add(longDimSV1,sub(longDimSV2,'3'))","mod(intMetric1,'10')","div(doubleMetric1,mult(floatMetric1,'5'))"]},"rows":[[15229.0,1.0,0.20076306285631254],[15229.0,7.0,0.20076306285631254],[15229.0,7.0,0.20076306285631254],[13540.0,7.0,0.20076306285631254],[60.0,4.0,0.1999999968342762],[29.0,0.0,0.20904977014723267],[29.0,0.0,0.20904977014723267],[0.0,0.0,0.21652891879345226],[0.0,0.0,0.2165289187934522 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE"],"columnNames":["floor(sqrt(doubleMetric1))","ceil(ln(longDimSV1))","exp(mod(abs(longDimSV2),'3'))"]},"rows":[[3.0,0.0,7.38905609893065],[3.0,0.0,7.38905609893065],[4.0,3.0,1.0],[4.0,3.0,1.0],[4.0,4.0,2.718281828459045],[4.0,"NaN",7.38905609893065],[16.0,9.0,2.718281828459045],[16.0,9.0,2.718281828459045],[16.0,9.0,2.718281828459045],[16.0,9.0,1.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1," [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG"],"columnNames":["count(*)"]},"rows":[[6],[1],[3]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":20,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":9,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
+{"resultTable":{"dataSchema":{"columnDataTypes":["INT","LONG"],"columnNames":["valuein(intDimMV1,'3','32')","count(*)"]},"rows":[[3,2],[32,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":18,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING","STRING","STRING","STRING"],"columnNames":["upper(stringDimSV1)","lower(textDim1)","reverse(stringDimSV2)","ltrim(substr(textDim1,'4','9'))","rtrim(substr(textDim1,'4','9'))"]},"rows":[["S1-0","java c++ python","0-2s","C++ "," C++"],["S1-0","java c++ python","0-2s","C++ "," C++"],["S1-2","java c++ golang","2-2s","C++ "," C++"],["S1-2","java c++ golang","2-2s","C++ "," C++"],["S1-4","java c++ golang","4-2s","C++ "," C++"], [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING","INT","STRING","STRING"],"columnNames":["stringDimSV2","replace(stringDimSV2,'foo','bar')","codepoint(stringDimSV2)","rpad(stringDimSV2,'11','abc')","lpad(stringDimSV2,'11','xyz')"]},"rows":[["s2-2","s2-2",115,"s2-2abcabca","xyzxyzxs2-2"],["s2-2","s2-2",115,"s2-2abcabca","xyzxyzxs2-2"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"nu [...]
# Groovy Scripts
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","LONG","LONG"],"columnNames":["longDimSV1","longDimSV2","groovy('{\"returnType\":\"LONG\",\"isSingleValue\":true}','arg0 + arg1',longDimSV1,longDimSV2)"]},"rows":[[-9223372036854775808,32,-9223372036854775776],[1,2,3],[1,2,3],[11,21,32],[11,21,32],[41,22,63],[6766,6777,13543],[7611,7621,15232],[7611,7621,15232],[7611,7621,15232]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProces [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","STRING"],"columnNames":["count(*)","groovy('{\"returnType\":\"STRING\", \"isSingleValue\":true}','def result; if (arg0 < 0) { result = \"NEGATIVE\"; } else if (arg0 < 10) { result = \"SMALL\";} else if (arg0 < 50) { result = \"MEDIUM\";} else{result = \"LARGE\"}; return result',longDimSV1)"]},"rows":[[4,"LARGE"],[3,"MEDIUM"],[2,"SMALL"],[1,"NEGATIVE"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueri [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["INT"],"columnNames":["groovy('{\"returnType\":\"INT\",\"isSingleValue\":true}','arg0.toList().max()',intDimMV1)"]},"rows":[[-2147483648],[4],[4],[42],[42],[52],[462],[462],[462],[462]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":10,"numGrou [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","LONG","LONG"],"columnNames":["longDimSV1","longDimSV2","groovy('{\"returnType\":\"LONG\",\"isSingleValue\":true}','arg0 + arg1',longDimSV1,longDimSV2)"]},"rows":[[-9223372036854775808,32,-9223372036854775776],[1,2,3],[1,2,3],[11,21,32],[11,21,32],[41,22,63],[6766,6777,13543],[7611,7621,15232],[7611,7621,15232],[7611,7621,15232]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProces [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG","STRING"],"columnNames":["count(*)","groovy('{\"returnType\":\"STRING\", \"isSingleValue\":true}','def result; if (arg0 < 0) { result = \"NEGATIVE\"; } else if (arg0 < 10) { result = \"SMALL\";} else if (arg0 < 50) { result = \"MEDIUM\";} else{result = \"LARGE\"}; return result',longDimSV1)"]},"rows":[[4,"LARGE"],[3,"MEDIUM"],[2,"SMALL"],[1,"NEGATIVE"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueri [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["INT"],"columnNames":["groovy('{\"returnType\":\"INT\",\"isSingleValue\":true}','arg0.toList().max()',intDimMV1)"]},"rows":[[-2147483648],[4],[4],[42],[42],[52],[462],[462],[462],[462]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":26,"segmentS [...]
# Text Search
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":6,"numEntriesScannedInFilter":0 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":0,"numEntriesScannedPost [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-4","Java C++ golang"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":9,"numEntriesScannedPo [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-4","Java C++ golang"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":9,"numEntriesScannedPo [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":0,"numEntriesScannedPost [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSeg [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":0,"numEntriesScannedPost [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-4","Java C++ golang"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":9,"numEntriesScannedPo [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-5","golang shell bash"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegme [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-5","golang shell bash"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegme [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-5","golang shell bash"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegme [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG"],"columnNames":["stringDimSV1","count(*)"]},"rows":[["s1-2",2],["s1-0",2],["s1-7",1],["s1-4",1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":6,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":6,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":6,"segmentStatistics":[], [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":6,"numEntriesScannedPostFilter":12,"numGroupsLimitReached":fals [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeU [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-4","Java C++ golang"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"tim [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-4","Java C++ golang"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"tim [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeU [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned" [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-0","Java C++ Python"],["s1-0","Java C++ Python"],["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeU [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-4","Java C++ golang"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"tim [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-5","golang shell bash"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":8 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-5","golang shell bash"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":8 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","STRING"],"columnNames":["stringDimSV1","textDim1"]},"rows":[["s1-2","Java C++ golang"],["s1-2","Java C++ golang"],["s1-4","Java C++ golang"],["s1-5","golang shell bash"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-6","C++ golang python"],["s1-7","golang Java"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":8 [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG"],"columnNames":["stringDimSV1","count(*)"]},"rows":[["s1-2",2],["s1-0",2],["s1-7",1],["s1-4",1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":6,"numEntriesScannedPostFilter":6,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":6,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
# Map
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","INT","INT"],"columnNames":["stringDimSV1","mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k4',mapDim1__VALUES)"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-2",7,7],["s1-4",7,8]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":0,"numEn [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","INT","INT"],"columnNames":["stringDimSV1","mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k4',mapDim1__VALUES)"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-4",7,8],["s1-2",7,7]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numE [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE"],"columnNames":["max(mapvalue(mapDim1__KEYS,'k2',mapDim1__VALUES))","min(mapvalue(mapDim1__KEYS,'k3',mapDim1__VALUES))"]},"rows":[[31,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":20,"numGroupsLimitReached":false,"totalDo [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE"],"columnNames":["max(mapvalue(mapDim1__KEYS,'k2',mapDim1__VALUES))","min(mapvalue(mapDim1__KEYS,'k3',mapDim1__VALUES))"]},"rows":[[1,2],[3,3],[5,6],[8,7],[31,32]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":20,"numGroupsLim [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["INT","INT"],"columnNames":["mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k2',mapDim1__VALUES)"]},"rows":[[1,1],[3,3],[4,5]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":3,"numEntriesScannedInFilter":10,"numEntriesScannedPostFilter":6,"numGroupsLimitReached":false,"totalDocs":10 [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["INT","INT"],"columnNames":["mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k2',mapDim1__VALUES)"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":0,"numConsumingSegmentsQueried":0,"numDocsScanned":0,"numEntriesScannedInFilter":10,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":12, [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING"],"columnNames":["mapvalue(mapDim1__KEYS,'non-existing-key',mapDim1__VALUES)"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":0,"numSegmentsMatched":0,"numConsumingSegmentsQueried":0,"numDocsScanned":0,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":3,"segmentStatistics":[],"traceInfo":{}, [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","INT","INT"],"columnNames":["stringDimSV1","mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k4',mapDim1__VALUES)"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-2",7,7],["s1-4",7,8]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":15,"numGroupsLimitReached":false,"tota [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","INT","INT"],"columnNames":["stringDimSV1","mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k4',mapDim1__VALUES)"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-4",7,8],["s1-2",7,7]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":45,"numGroupsLimitReached":false,"tot [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE"],"columnNames":["max(mapvalue(mapDim1__KEYS,'k2',mapDim1__VALUES))","min(mapvalue(mapDim1__KEYS,'k3',mapDim1__VALUES))"]},"rows":[[31,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":20,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":3,"segmentStatistics":[],"traceInfo":{},"m [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE"],"columnNames":["max(mapvalue(mapDim1__KEYS,'k2',mapDim1__VALUES))","min(mapvalue(mapDim1__KEYS,'k3',mapDim1__VALUES))"]},"rows":[[1,2],[3,3],[5,6],[8,7],[31,32]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":20,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":5,"segmentStatist [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["INT","INT"],"columnNames":["mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k2',mapDim1__VALUES)"]},"rows":[[1,1],[3,3],[4,5]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":3,"numEntriesScannedPostFilter":6,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":3,"segmentStatistics":[],"traceInfo":{},"minConsu [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["INT","INT"],"columnNames":["mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k2',mapDim1__VALUES)"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":0,"numDocsScanned":0,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":12,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING"],"columnNames":["mapvalue(mapDim1__KEYS,'non-existing-key',mapDim1__VALUES)"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":0,"numSegmentsMatched":0,"numDocsScanned":0,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":3,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
# Json Map
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","INT","INT"],"columnNames":["stringDimSV1","jsonextractscalar(mapDim2json,'$.k1','INT')","jsonextractscalar(mapDim2json,'$.k4','INT')"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-2",7,7],["s1-4",7,8]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":0,"numEntr [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","INT","INT"],"columnNames":["stringDimSV1","jsonextractscalar(mapDim2json,'$.k1','INT')","jsonextractscalar(mapDim2json,'$.k4','INT')"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-4",7,8],["s1-2",7,7]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEnt [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE"],"columnNames":["max(jsonextractscalar(mapDim2json,'$.k2','INT'))","min(jsonextractscalar(mapDim2json,'$.k3','INT'))"]},"rows":[[31,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE"],"columnNames":["max(jsonextractscalar(mapDim2json,'$.k2','INT'))","min(jsonextractscalar(mapDim2json,'$.k3','INT'))"]},"rows":[[1,2],[3,3],[5,6],[8,7],[31,32]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":10,"numGroupsLimit [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["INT","INT"],"columnNames":["jsonextractscalar(mapDim2json,'$.k1','INT')","jsonextractscalar(mapDim2json,'$.k2','INT')"]},"rows":[[1,1],[3,3],[4,5]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":3,"numEntriesScannedInFilter":10,"numEntriesScannedPostFilter":3,"numGroupsLimitReached":false,"totalDocs":10," [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["INT"],"columnNames":["jsonextractscalar(mapDim2json,'$.non-existing-key','INT','-1')"]},"rows":[[-1],[-1],[-1],[-1],[-1],[-1],[-1],[-1],[-1],[-1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10," [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["INT"],"columnNames":["jsonextractscalar(mapDim2json,'$.non-existing-key','INT')"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":0,"numConsumingSegmentsQueried":0,"numDocsScanned":0,"numEntriesScannedInFilter":50,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":7,"segmentStatistics":[],"traceInfo":{},"mi [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","INT","INT"],"columnNames":["stringDimSV1","jsonextractscalar(mapDim2json,'$.k1','INT')","jsonextractscalar(mapDim2json,'$.k4','INT')"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-2",7,7],["s1-4",7,8]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalD [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","INT","INT"],"columnNames":["stringDimSV1","jsonextractscalar(mapDim2json,'$.k1','INT')","jsonextractscalar(mapDim2json,'$.k4','INT')"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-4",7,8],["s1-2",7,7]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":30,"numGroupsLimitReached":false,"total [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE"],"columnNames":["max(jsonextractscalar(mapDim2json,'$.k2','INT'))","min(jsonextractscalar(mapDim2json,'$.k3','INT'))"]},"rows":[[31,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":3,"segmentStatistics":[],"traceInfo":{},"min [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["DOUBLE","DOUBLE"],"columnNames":["max(jsonextractscalar(mapDim2json,'$.k2','INT'))","min(jsonextractscalar(mapDim2json,'$.k3','INT'))"]},"rows":[[1,2],[3,3],[5,6],[8,7],[31,32]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":7,"segmentStatistic [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["INT","INT"],"columnNames":["jsonextractscalar(mapDim2json,'$.k1','INT')","jsonextractscalar(mapDim2json,'$.k2','INT')"]},"rows":[[1,1],[3,3],[4,5]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":3,"numEntriesScannedPostFilter":3,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":5,"segmentStatistics":[],"traceInfo":{},"minConsumi [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["INT"],"columnNames":["jsonextractscalar(mapDim2json,'$.non-existing-key','INT','-1')"]},"rows":[[-1],[-1],[-1],[-1],[-1],[-1],[-1],[-1],[-1],[-1]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":4,"segmentStatistics":[],"traceInfo":{},"minConsum [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["INT"],"columnNames":["jsonextractscalar(mapDim2json,'$.non-existing-key','INT')"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":0,"numDocsScanned":0,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":7,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
# Misc
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG"],"columnNames":["count(*)"]},"rows":[[2],[1],[2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":5,"numEntriesScannedInFilter":10,"numEntriesScannedPostFilter":5,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":6,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
-{"resultTable":{"dataSchema":{"columnDataTypes":["LONG"],"columnNames":["count(*)"]},"rows":[[6],[2],[2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":16,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":4,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1"]},"rows":[["s1-7",6766,[392,462]],["s1-6",7611,[392,462]],["s1-6",7611,[392,462]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":33,"numGroupsLimitReached":fal [...]
-{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1"]},"rows":[["s1-7",6766,[392,462]],["s1-6",7611,[392,462]],["s1-6",7611,[392,462]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":0,"numDocsScanned":10,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":33,"numGroupsLimitReached":fal [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG"],"columnNames":["count(*)"]},"rows":[[2],[1],[2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":5,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":6,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
+{"resultTable":{"dataSchema":{"columnDataTypes":["LONG"],"columnNames":["count(*)"]},"rows":[[6],[2],[2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":4,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":0}
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1"]},"rows":[["s1-7",6766,[392,462]],["s1-6",7611,[392,462]],["s1-6",7611,[392,462]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":33,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":4,"segmentStatistics":[],"trace [...]
+{"resultTable":{"dataSchema":{"columnDataTypes":["STRING","LONG","INT_ARRAY"],"columnNames":["stringDimSV1","longDimSV1","intDimMV1"]},"rows":[["s1-7",6766,[392,462]],["s1-6",7611,[392,462]],["s1-6",7611,[392,462]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":10,"numEntriesScannedPostFilter":33,"numGroupsLimitReached":false,"totalDocs":10,"timeUsedMs":3,"segmentStatistics":[],"trace [...]
diff --git a/compatibility-verifier/sample-test-suite/config/query-results/feature-test-2-sql-realtime.results b/compatibility-verifier/sample-test-suite/config/query-results/feature-test-2-sql-realtime.results
index d563ad9eab..47f7a2805c 100644
--- a/compatibility-verifier/sample-test-suite/config/query-results/feature-test-2-sql-realtime.results
+++ b/compatibility-verifier/sample-test-suite/config/query-results/feature-test-2-sql-realtime.results
@@ -18,47 +18,47 @@
#
# Selection
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1"],"columnDataTypes":["LONG","INT_ARRAY"]},"rows":[[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[11,[32,42]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegment [...]
-# {"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1"],"columnDataTypes":["LONG","INT_ARRAY"]},"rows":[[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":5,"numEntriesScannedInFilter":63,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"t [...]
-{"isSuperset":true, "resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1"],"columnDataTypes":["LONG","INT_ARRAY"]},"rows":[[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":2,"numSegmentsProcessed":2,"numSegmentsMatched":2,"numConsumingSegmentsQueried":1,"numDocsS [...]
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1"],"columnDataTypes":["LONG","INT_ARRAY"]},"rows":[[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-214748 [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1"],"columnDataTypes":["LONG","INT_ARRAY"]},"rows":[[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[11,[32,42]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegment [...]
+# {"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1"],"columnDataTypes":["LONG","INT_ARRAY"]},"rows":[[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":5,"numEntriesScannedPostFilter":10,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":6,"offlineThreadCpuTimeNs":0,"realtim [...]
+{"isSuperset":true, "resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1"],"columnDataTypes":["LONG","INT_ARRAY"]},"rows":[[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":2,"numSegmentsProcessed":2,"numSegmentsMatched":2,"numDocsScanned":13,"numEntriesScannedPos [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1"],"columnDataTypes":["LONG","INT_ARRAY"]},"rows":[[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-2147483648]],[11,[32,42]],[11,[32,42]],[41,[42,52]],[-9223372036854775808,[-214748 [...]
# Aggregation
-{"resultTable":{"dataSchema":{"columnNames":["count(*)"],"columnDataTypes":["LONG"]},"rows":[[66]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":66,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":4,"offlineThreadCpuTimeNs":0,"realtimeThreadCpuTimeNs":0,"segmentStatistics":[],"traceI [...]
-{"resultTable":{"dataSchema":{"columnNames":["sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"],"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"]},"rows":[[2.576980527E10,-1.5032363248E10,0.0,6.0,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":66,"numEntrie [...]
-{"resultTable":{"dataSchema":{"columnNames":["count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"],"columnDataTypes":["LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"]},"rows":[[66,125,105.11969939145175,1383.2575757575758,250.00000000000003,6656.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1, [...]
-{"resultTable":{"dataSchema":{"columnNames":["percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"],"columnDataTypes":["DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"]},"rows":[[7611.0,462.0,7611,462,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegme [...]
-{"resultTable":{"dataSchema":{"columnNames":["percentile(longDimSV1, 80.01)","percentilemv(intDimMV1, 99.99)","percentileest(longDimSV1, 80.01)","percentileestmv(intDimMV1, 99.99)","percentiletdigest(longDimSV1, 80.01)","percentiletdigestmv(intDimMV1, 99.99)"],"columnDataTypes":["DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"]},"rows":[[7611.0,462.0,7611,462,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"nu [...]
-{"resultTable":{"dataSchema":{"columnNames":["distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"],"columnDataTypes":["INT","INT","LONG","LONG"]},"rows":[[6,8,6,8]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":66,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":132,"numGroups [...]
+{"resultTable":{"dataSchema":{"columnNames":["count(*)"],"columnDataTypes":["LONG"]},"rows":[[66]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":4,"offlineThreadCpuTimeNs":0,"realtimeThreadCpuTimeNs":0,"segmentStatistics":[],"traceInfo":{},"minConsumingFreshnessTimeMs":1620950080428}
+{"resultTable":{"dataSchema":{"columnNames":["sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"],"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"]},"rows":[[2.576980527E10,-1.5032363248E10,0.0,6.0,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilter":264,"numGrou [...]
+{"resultTable":{"dataSchema":{"columnNames":["count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"],"columnDataTypes":["LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"]},"rows":[[66,125,105.11969939145175,1383.2575757575758,250.00000000000003,6656.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesS [...]
+{"resultTable":{"dataSchema":{"columnNames":["percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"],"columnDataTypes":["DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"]},"rows":[[7611.0,462.0,7611,462,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegme [...]
+{"resultTable":{"dataSchema":{"columnNames":["percentile(longDimSV1, 80.01)","percentilemv(intDimMV1, 99.99)","percentileest(longDimSV1, 80.01)","percentileestmv(intDimMV1, 99.99)","percentiletdigest(longDimSV1, 80.01)","percentiletdigestmv(intDimMV1, 99.99)"],"columnDataTypes":["DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"]},"rows":[[7611.0,462.0,7611,462,7611.0,462.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"nu [...]
+{"resultTable":{"dataSchema":{"columnNames":["distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"],"columnDataTypes":["INT","INT","LONG","LONG"]},"rows":[[6,8,6,8]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilter":132,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":5,"offlineThre [...]
# Selection & Filtering & Grouping on Aggregation
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","count(*)"],"columnDataTypes":["LONG","INT","LONG"]},"rows":[[-9223372036854775808,-2147483648,7],[11,32,14],[11,42,14],[41,42,7],[41,52,7]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":28,"numEntriesScannedInFilter":269,"numEntriesScannedPostFilter":56,"numGroupsLimitReached":false, [...]
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"],"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"]},"rows":[[-9223372036854775808,-2147483648,0.0,-1.5032385536E10,0.0,22.0,-9.223372036854776E18,-2.147483648E9],[11,32,140.0,1036.0,10.0,62.0,11.0,42.0],[11,42,140.0,1036.0,10.0,62.0,11.0,42.0],[41,42,98.0,658.0,14.0,72.0,41 [...]
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"],"columnDataTypes":["LONG","INT","LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"]},"rows":[[-9223372036854775808,-2147483648,7,7,0.0,57.0,0.0,70.0],[11,32,14,28,22.100000381469727,67.0,0.0,10.0],[11,42,14,28,22.100000381469727,67.0,0.0,10.0],[41,42,7,14,24.100000381469727,77.0,0.0,10.0],[41,5 [...]
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"],"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"]},"rows":[[-9223372036854775808,-2147483648,-9.223372036854776E18,-2.147483648E9,-9223372036854775808,-2147483648,-9.2233720368547 [...]
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","percentile(longDimSV1, 80.01)","percentilemv(intDimMV1, 99.99)","percentileest(longDimSV1, 80.01)","percentileestmv(intDimMV1, 99.99)","percentiletdigest(longDimSV1, 80.01)","percentiletdigestmv(intDimMV1, 99.99)"],"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"]},"rows":[[-9223372036854775808,-2147483648,-9.223372036854776E18,-2.147483648E9,-9223372036854775808,-2147483648,-9.2233720 [...]
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"],"columnDataTypes":["LONG","INT","INT","INT","LONG","LONG"]},"rows":[[-9223372036854775808,-2147483648,1,1,1,1],[11,32,1,2,1,2],[11,42,1,2,1,2],[41,42,1,2,1,2],[41,52,1,2,1,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMa [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","count(*)"],"columnDataTypes":["LONG","INT","LONG"]},"rows":[[-9223372036854775808,-2147483648,7],[11,32,14],[11,42,14],[41,42,7],[41,52,7]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":28,"numEntriesScannedPostFilter":56,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":6,"offlineThreadCpuTimeNs":0,"realti [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","sum(intMetric1)","summv(intDimMV1)","min(intMetric1)","minmv(intDimMV2)","max(longDimSV1)","maxmv(intDimMV1)"],"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE","DOUBLE"]},"rows":[[-9223372036854775808,-2147483648,0.0,-1.5032385536E10,0.0,22.0,-9.223372036854776E18,-2.147483648E9],[11,32,140.0,1036.0,10.0,62.0,11.0,42.0],[11,42,140.0,1036.0,10.0,62.0,11.0,42.0],[41,42,98.0,658.0,14.0,72.0,41 [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","count(*)","countmv(intDimMV1)","avg(floatMetric1)","avgmv(intDimMV2)","minmaxrange(doubleMetric1)","minmaxrangemv(intDimMV2)"],"columnDataTypes":["LONG","INT","LONG","LONG","DOUBLE","DOUBLE","DOUBLE","DOUBLE"]},"rows":[[-9223372036854775808,-2147483648,7,7,0.0,57.0,0.0,70.0],[11,32,14,28,22.100000381469727,67.0,0.0,10.0],[11,42,14,28,22.100000381469727,67.0,0.0,10.0],[41,42,7,14,24.100000381469727,77.0,0.0,10.0],[41,5 [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","percentile(longDimSV1, 80.0)","percentilemv(intDimMV1, 90.0)","percentileest(longDimSV1, 80.0)","percentileestmv(intDimMV1, 90.0)","percentiletdigest(longDimSV1, 80.0)","percentiletdigestmv(intDimMV1, 90.0)"],"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"]},"rows":[[-9223372036854775808,-2147483648,-9.223372036854776E18,-2.147483648E9,-9223372036854775808,-2147483648,-9.2233720368547 [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","percentile(longDimSV1, 80.01)","percentilemv(intDimMV1, 99.99)","percentileest(longDimSV1, 80.01)","percentileestmv(intDimMV1, 99.99)","percentiletdigest(longDimSV1, 80.01)","percentiletdigestmv(intDimMV1, 99.99)"],"columnDataTypes":["LONG","INT","DOUBLE","DOUBLE","LONG","LONG","DOUBLE","DOUBLE"]},"rows":[[-9223372036854775808,-2147483648,-9.223372036854776E18,-2.147483648E9,-9223372036854775808,-2147483648,-9.2233720 [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","intDimMV1","distinctcount(longDimSV1)","distinctcountmv(intDimMV1)","distinctcounthll(longDimSV1)","distinctcounthllmv(intDimMV1)"],"columnDataTypes":["LONG","INT","INT","INT","LONG","LONG"]},"rows":[[-9223372036854775808,-2147483648,1,1,1,1],[11,32,1,2,1,2],[11,42,1,2,1,2],[41,42,1,2,1,2],[41,52,1,2,1,2]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMa [...]
# Transformation Functions
-{"resultTable":{"dataSchema":{"columnNames":["add(longDimSV1,sub(longDimSV2,'3'))","mod(intMetric1,'10')","div(doubleMetric1,mult(floatMetric1,'5'))"],"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE"]},"rows":[[15229.0,1.0,0.20076306285631254],[15229.0,7.0,0.20076306285631254],[13540.0,7.0,0.20076306285631254],[60.0,4.0,0.1999999968342762],[29.0,0.0,0.20904977014723267],[0.0,0.0,0.21652891879345226],[-9.223372036854776E18,0.0,"Infinity"]]},"exceptions":[],"numServersQueried":1,"numServersRe [...]
-{"resultTable":{"dataSchema":{"columnNames":["floor(sqrt(doubleMetric1))","ceil(ln(longDimSV1))","exp(mod(abs(longDimSV2),'3'))"],"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE"]},"rows":[[3.0,0.0,7.38905609893065],[4.0,3.0,1.0],[4.0,4.0,2.718281828459045],[4.0,"NaN",7.38905609893065],[16.0,9.0,2.718281828459045],[16.0,9.0,1.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried" [...]
-{"resultTable":{"dataSchema":{"columnNames":["arraylength(intDimMV1)","arraylength(valuein(stringDimMV2,'m2-2-0','m2-3-0'))","count(*)"],"columnDataTypes":["INT","INT","LONG"]},"rows":[[2,1,39],[1,1,7],[2,0,20]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":66,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":132,"numGroupsLimitReached":false, [...]
-{"resultTable":{"dataSchema":{"columnNames":["valuein(intDimMV1,'3','32')","count(*)"],"columnDataTypes":["INT","LONG"]},"rows":[[3,14],[32,14]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":66,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":66,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":5,"offlineThreadCpuTimeNs":0,"realtimeTh [...]
-{"resultTable":{"dataSchema":{"columnNames":["upper(stringDimSV1)","lower(textDim1)","reverse(stringDimSV2)","ltrim(substr(textDim1,'4','9'))","rtrim(substr(textDim1,'4','9'))"],"columnDataTypes":["STRING","STRING","STRING","STRING","STRING"]},"rows":[["S1-0","java c++ python","0-2s","C++ "," C++"],["S1-2","java c++ golang","2-2s","C++ "," C++"],["S1-4","java c++ golang","4-2s","C++ "," C++"],["S1-5","golang shell bash","llun","ng sh","ng sh"],["S1-6","c++ golang python","6-2s","golan"," [...]
-{"resultTable":{"dataSchema":{"columnNames":["stringDimSV2","replace(stringDimSV2,'foo','bar')","codepoint(stringDimSV2)","rpad(stringDimSV2,'11','abc')","lpad(stringDimSV2,'11','xyz')"],"columnDataTypes":["STRING","STRING","INT","STRING","STRING"]},"rows":[["s2-2","s2-2",115,"s2-2abcabca","xyzxyzxs2-2"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":14 [...]
+{"resultTable":{"dataSchema":{"columnNames":["add(longDimSV1,sub(longDimSV2,'3'))","mod(intMetric1,'10')","div(doubleMetric1,mult(floatMetric1,'5'))"],"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE"]},"rows":[[15229.0,1.0,0.20076306285631254],[15229.0,7.0,0.20076306285631254],[13540.0,7.0,0.20076306285631254],[60.0,4.0,0.1999999968342762],[29.0,0.0,0.20904977014723267],[0.0,0.0,0.21652891879345226],[-9.223372036854776E18,0.0,"Infinity"]]},"exceptions":[],"numServersQueried":1,"numServersRe [...]
+{"resultTable":{"dataSchema":{"columnNames":["floor(sqrt(doubleMetric1))","ceil(ln(longDimSV1))","exp(mod(abs(longDimSV2),'3'))"],"columnDataTypes":["DOUBLE","DOUBLE","DOUBLE"]},"rows":[[3.0,0.0,7.38905609893065],[4.0,3.0,1.0],[4.0,4.0,2.718281828459045],[4.0,"NaN",7.38905609893065],[16.0,9.0,2.718281828459045],[16.0,9.0,1.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntri [...]
+{"resultTable":{"dataSchema":{"columnNames":["arraylength(intDimMV1)","arraylength(valuein(stringDimMV2,'m2-2-0','m2-3-0'))","count(*)"],"columnDataTypes":["INT","INT","LONG"]},"rows":[[2,1,39],[1,1,7],[2,0,20]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilter":132,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":9,"offlineThreadCpuTimeNs":0,"real [...]
+{"resultTable":{"dataSchema":{"columnNames":["valuein(intDimMV1,'3','32')","count(*)"],"columnDataTypes":["INT","LONG"]},"rows":[[3,14],[32,14]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilter":66,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":5,"offlineThreadCpuTimeNs":0,"realtimeThreadCpuTimeNs":0,"segmentStatistics":[],"traceInfo":{},"minCon [...]
+{"resultTable":{"dataSchema":{"columnNames":["upper(stringDimSV1)","lower(textDim1)","reverse(stringDimSV2)","ltrim(substr(textDim1,'4','9'))","rtrim(substr(textDim1,'4','9'))"],"columnDataTypes":["STRING","STRING","STRING","STRING","STRING"]},"rows":[["S1-0","java c++ python","0-2s","C++ "," C++"],["S1-2","java c++ golang","2-2s","C++ "," C++"],["S1-4","java c++ golang","4-2s","C++ "," C++"],["S1-5","golang shell bash","llun","ng sh","ng sh"],["S1-6","c++ golang python","6-2s","golan"," [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV2","replace(stringDimSV2,'foo','bar')","codepoint(stringDimSV2)","rpad(stringDimSV2,'11','abc')","lpad(stringDimSV2,'11','xyz')"],"columnDataTypes":["STRING","STRING","INT","STRING","STRING"]},"rows":[["s2-2","s2-2",115,"s2-2abcabca","xyzxyzxs2-2"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":14,"numEntriesScannedPostFilter":1 [...]
# Groovy Scripts
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","longDimSV2","groovy('{\"returnType\":\"LONG\",\"isSingleValue\":true}','arg0 + arg1',longDimSV1,longDimSV2)"],"columnDataTypes":["LONG","LONG","LONG"]},"rows":[[7611,7621,15232],[1,2,3],[41,22,63],[6766,6777,13543],[-9223372036854775808,32,-9223372036854775776],[11,21,32]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQuer [...]
-{"resultTable":{"dataSchema":{"columnNames":["count(*)","groovy('{\"returnType\":\"STRING\", \"isSingleValue\":true}','def result; if (arg0 < 0) { result = \"NEGATIVE\"; } else if (arg0 < 10) { result = \"SMALL\";} else if (arg0 < 50) { result = \"MEDIUM\";} else{result = \"LARGE\"}; return result',longDimSV1)"],"columnDataTypes":["LONG","STRING"]},"rows":[[24,"LARGE"],[21,"MEDIUM"],[14,"SMALL"],[7,"NEGATIVE"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQu [...]
-{"resultTable":{"dataSchema":{"columnNames":["groovy('{\"returnType\":\"INT\",\"isSingleValue\":true}','arg0.toList().max()',intDimMV1)"],"columnDataTypes":["INT"]},"rows":[[-2147483648],[4],[42],[52],[462]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":66,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":66,"numGroupsLimitReached":false,"tota [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","longDimSV2","groovy('{\"returnType\":\"LONG\",\"isSingleValue\":true}','arg0 + arg1',longDimSV1,longDimSV2)"],"columnDataTypes":["LONG","LONG","LONG"]},"rows":[[7611,7621,15232],[1,2,3],[41,22,63],[6766,6777,13543],[-9223372036854775808,32,-9223372036854775776],[11,21,32]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numE [...]
+{"resultTable":{"dataSchema":{"columnNames":["count(*)","groovy('{\"returnType\":\"STRING\", \"isSingleValue\":true}','def result; if (arg0 < 0) { result = \"NEGATIVE\"; } else if (arg0 < 10) { result = \"SMALL\";} else if (arg0 < 50) { result = \"MEDIUM\";} else{result = \"LARGE\"}; return result',longDimSV1)"],"columnDataTypes":["LONG","STRING"]},"rows":[[24,"LARGE"],[21,"MEDIUM"],[14,"SMALL"],[7,"NEGATIVE"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQu [...]
+{"resultTable":{"dataSchema":{"columnNames":["groovy('{\"returnType\":\"INT\",\"isSingleValue\":true}','arg0.toList().max()',intDimMV1)"],"columnDataTypes":["INT"]},"rows":[[-2147483648],[4],[42],[52],[462]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilter":66,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":17,"offlineThreadCpuTimeNs":0,"realtime [...]
# Json Map
-{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k4',mapDim1__VALUES)"],"columnDataTypes":["STRING","INT","INT"]},"rows":[["s1-2",7,7],["s1-7",31,32],["s1-4",7,8],["s1-2",4,7],["s1-6",7,10],["s1-5",7,7],["s1-0",1,2],["s1-0",3,3]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScann [...]
-{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","jsonextractscalar(mapDim2json,'$.k1','INT')","jsonextractscalar(mapDim2json,'$.k4','INT')"],"columnDataTypes":["STRING","INT","INT"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-2",7,7],["s1-4",7,8],["s1-5",7,7],["s1-6",7,10],["s1-7",31,32]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned [...]
-{"resultTable":{"dataSchema":{"columnNames":["jsonextractscalar(mapDim2json,'$.k1','INT')","max(jsonextractscalar(mapDim2json,'$.k2','INT'))","min(jsonextractscalar(mapDim2json,'$.k3','INT'))"],"columnDataTypes":["INT","DOUBLE","DOUBLE"]},"rows":[[1,1.0,2.0],[3,3.0,3.0],[4,5.0,6.0],[7,8.0,7.0],[31,31.0,32.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","mapvalue(mapDim1__KEYS,'k1',mapDim1__VALUES)","mapvalue(mapDim1__KEYS,'k4',mapDim1__VALUES)"],"columnDataTypes":["STRING","INT","INT"]},"rows":[["s1-2",7,7],["s1-7",31,32],["s1-4",7,8],["s1-2",4,7],["s1-6",7,10],["s1-5",7,7],["s1-0",1,2],["s1-0",3,3]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFil [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","jsonextractscalar(mapDim2json,'$.k1','INT')","jsonextractscalar(mapDim2json,'$.k4','INT')"],"columnDataTypes":["STRING","INT","INT"]},"rows":[["s1-0",1,2],["s1-0",3,3],["s1-2",4,7],["s1-2",7,7],["s1-4",7,8],["s1-5",7,7],["s1-6",7,10],["s1-7",31,32]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilte [...]
+{"resultTable":{"dataSchema":{"columnNames":["jsonextractscalar(mapDim2json,'$.k1','INT')","max(jsonextractscalar(mapDim2json,'$.k2','INT'))","min(jsonextractscalar(mapDim2json,'$.k3','INT'))"],"columnDataTypes":["INT","DOUBLE","DOUBLE"]},"rows":[[1,1.0,2.0],[3,3.0,3.0],[4,5.0,6.0],[7,8.0,7.0],[31,31.0,32.0]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilte [...]
# Misc
-{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","count(*)"],"columnDataTypes":["LONG","LONG"]},"rows":[[1,14],[41,7],[11,14]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":35,"numEntriesScannedInFilter":66,"numEntriesScannedPostFilter":35,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":4,"offlineThreadCpuTimeNs":0,"realtimeThreadCpuT [...]
-{"resultTable":{"dataSchema":{"columnNames":["stringDimMV2","count(*)"],"columnDataTypes":["STRING","LONG"]},"rows":[["m2-6-0",6],["m2-6-1",6],["m2-3-1",7],["m2-2-0",39],["m2-3-0",7],["m2-2-1",14],["m2-0-0",14],["m2-0-1",14]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":1,"numDocsScanned":66,"numEntriesScannedInFilter":107,"numEntriesScannedPostFilter":66,"numGroupsLimit [...]
-{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","longDimSV1","intDimMV1","intDimMV2"],"columnDataTypes":["STRING","LONG","INT_ARRAY","INT_ARRAY"]},"rows":[["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-2",11,[32,42],[62,72]],["s1-2",11,[32,42],[62,72]],["s1-2",11,[32,42],[62,72]],["s1-2",11,[32,42],[62,72]],["s1-2",11,[32,42 [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","count(*)"],"columnDataTypes":["LONG","LONG"]},"rows":[[1,14],[41,7],[11,14]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":35,"numEntriesScannedPostFilter":35,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":4,"offlineThreadCpuTimeNs":0,"realtimeThreadCpuTimeNs":0,"segmentStatistics":[],"traceInfo":{},"minConsumingFre [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimMV2","count(*)"],"columnDataTypes":["STRING","LONG"]},"rows":[["m2-6-0",6],["m2-6-1",6],["m2-3-1",7],["m2-2-0",39],["m2-3-0",7],["m2-2-1",14],["m2-0-0",14],["m2-0-1",14]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":1,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numDocsScanned":66,"numEntriesScannedPostFilter":66,"numGroupsLimitReached":false,"totalDocs":66,"timeUsedMs":3,"offlineThreadCpuTi [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","longDimSV1","intDimMV1","intDimMV2"],"columnDataTypes":["STRING","LONG","INT_ARRAY","INT_ARRAY"]},"rows":[["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-4",41,[42,52],[72,82]],["s1-2",11,[32,42],[62,72]],["s1-2",11,[32,42],[62,72]],["s1-2",11,[32,42],[62,72]],["s1-2",11,[32,42],[62,72]],["s1-2",11,[32,42 [...]
diff --git a/compatibility-verifier/sample-test-suite/config/query-results/feature-test-3-sql-realtime.results b/compatibility-verifier/sample-test-suite/config/query-results/feature-test-3-sql-realtime.results
new file mode 100644
index 0000000000..23102a964d
--- /dev/null
+++ b/compatibility-verifier/sample-test-suite/config/query-results/feature-test-3-sql-realtime.results
@@ -0,0 +1,47 @@
+#
+# 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.
+#
+
+# rangeIndex[doubleDimSV1]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","doubleDimSV1"],"columnDataTypes":["LONG","DOUBLE"]},"rows":[[210,95.98],[203,90.46],[288,90.63],[286,99.1],[24,97.12],[19,92.92],[10,95.01],[48,96.68],[169,96.07],[83,91.27],[80,91.65],[74,91.66],[71,96.88],[257,94.67],[253,97.08],[247,90.84],[243,91.92],[4,98.57],[193,98.22],[183,99.11],[179,97.93],[175,93.76],[69,98.18],[66,92.25],[64,93.3],[55,90.62],[52,96.87],[231,91.73],[278,98.6],[270,99.62],[268,99.08],[259,91.1],[107,95. [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","doubleDimSV1"],"columnDataTypes":["LONG","DOUBLE"]},"rows":[[214,10.08],[206,17.88],[285,10.58],[170,19.98],[163,12.75],[158,12.29],[237,14.4],[235,14.13],[180,18.87],[25,12.83],[22,18.23],[17,17.61],[11,18.99],[261,19.59],[116,11.17],[149,14.85],[141,14.62],[78,16.54],[72,10.78],[53,17.61],[105,12.42],[96,19],[30,12.64],[251,13.9],[245,11.53]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":18 [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","doubleDimSV1"],"columnDataTypes":["LONG","DOUBLE"]},"rows":[[286,99.1],[183,99.11],[270,99.62],[268,99.08]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":3,"numSegmentsMatched":3,"numConsumingSegmentsQueried":3,"numDocsScanned":4,"numEntriesScannedInFilter":12,"numEntriesScannedPostFilter":8,"numGroupsLimitReached":false,"totalDocs":300,"timeUsedMs":20,"offlineThread [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","doubleDimSV1"],"columnDataTypes":["STRING","STRING"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":0,"numSegmentsMatched":0,"numConsumingSegmentsQueried":3,"numDocsScanned":0,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":0,"numGroupsLimitReached":false,"totalDocs":300,"timeUsedMs":3,"offlineThreadCpuTimeNs":0,"realtimeThreadCpuTimeNs":0,"offl [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","doubleDimSV1"],"columnDataTypes":["LONG","DOUBLE"]},"rows":[[5,4.57],[3,0.88],[188,5.88],[186,3.35],[180,18.87],[178,4.3],[237,14.4],[235,14.13],[234,1.51],[233,6.78],[230,1.42],[229,3.05],[223,4.91],[219,7.23],[276,3.49],[261,19.59],[53,17.61],[214,10.08],[211,7.83],[206,17.88],[200,6.55],[149,14.85],[142,5.89],[141,14.62],[136,6.44],[133,9.69],[251,13.9],[245,11.53],[244,0.57],[105,12.42],[99,2.91],[96,19.0],[94,4.52],[93,5.03] [...]
+{"resultTable":{"dataSchema":{"columnNames":["longDimSV1","doubleDimSV1"],"columnDataTypes":["LONG","DOUBLE"]},"rows":[[110,50.91],[103,45.1],[100,54.03],[153,48.87],[150,46.02],[146,50.13],[143,54.71],[252,48.4],[241,50.1],[240,52.83],[277,53.1],[68,54.37],[65,54.67],[57,46.19],[50,48.4],[197,50.2],[221,46.9],[28,45.71],[76,50.17],[131,48.94],[118,46.43],[113,48.9],[173,46.13],[167,45.82],[159,54.69],[155,45.03],[154,45.28],[299,48.14],[298,51.45],[283,48.46],[280,46.17],[190,51.27],[17 [...]
+
+# bloomFilterColumns[stringDimSV1]; varLengthDictionaryColumns[stringDimSV1]; noDictionaryColumns["stringDimSV2","intMetric1", "longMetric1", "floatMetric1", "doubleMetric1", "bytesMetric1"]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["qmxauaacotyezcqw","knurucwrydcufd",6563,281474976717652,62.72,6.2E45,"deadbeef"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":2,"numSegmentsMatched":1,"numConsumingSegmentsQueried":3,"numDoc [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":1,"numSegmentsMatched":0,"numConsumingSegmentsQueried":3,"numDocsScanned":0,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":0,"numGrou [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["pbbeecjjabupkrf","kjuhobuoynryay",188,281474976710683,72.21,9.223372036854776E16,"d54d0507"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":2,"numSegmentsMatched":1,"numConsumingSegmentsQuerie [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":1,"numSegmentsMatched":0,"numConsumingSegmentsQueried":3,"numDocsScanned":0,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":0,"numGrou [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["ljuwlnaailbvukpk","dqybtowfjeam",8046,281474976718276,77.92,9.223372036854776E16,"01a0bc"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":3,"numSegmentsMatched":1,"numConsumingSegmentsQueried" [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["mcpilzfivcfwci","wldocwdhaqyl",8033,281474976712017,91.08,9.223372036854776E16,"01a0bc"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":2,"numSegmentsMatched":1,"numConsumingSegmentsQueried":3 [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["pigrefok","lvuziytyuftibms",2084,281474976716587,14.59,9.223372036854776E16,"d54d0507"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":2,"numSegmentsMatched":1,"numConsumingSegmentsQueried":3, [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":1,"numSegmentsMatched":0,"numConsumingSegmentsQueried":3,"numDocsScanned":0,"numEntriesScannedInFilter":0,"numEntriesScannedPostFilter":0,"numGrou [...]
+
+# partitionedColumn[longDimSV1]; varLengthDictionaryColumns[stringDimSV1]; noDictionaryColumns["stringDimSV2","intMetric1", "longMetric1", "floatMetric1", "doubleMetric1", "bytesMetric1"]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["tsvknmxua","hkfviagqwaodjs",5881,281474976720355,54.82,9.223372036854776E16,"deed0507"],["udiyszdw","ezxcchzpb",2805,281474976717544,5.44,9.223372036854776E16,"deadbeef"],["bhxpgexg","oydnfucyiov",5590,281474976718795,44.23,9.223372036854776E16,"d54d0507"] [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["jkuhidefpqry","nxnjlzdrtnwpwvu",2064,281474976714265,60.0,9.223372036854776E16,"deed0507"],["bhxpgexg","oydnfucyiov",5590,281474976718795,44.23,9.223372036854776E16,"d54d0507"],["oerfxfdpqgr","eebimdxgtx",1802,281474976719813,54.11,9.223372036854776E16,"de [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["jkxftqwgzszefw","lvfwsewnj",2824,281474976716411,61.71,9.223372036854776E16,"deadbeef"],["mvbprcfsljhkclt","quzbozdgxhyzd",6314,281474976712191,70.1,9.223372036854776E16,"deadbeef"],["otrfcluhre","hcjaxekilj",8888,281474976719670,32.3,9.223372036854776E16, [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["jkxftqwgzszefw","lvfwsewnj",2824,281474976716411,61.71,9.223372036854776E16,"deadbeef"],["sxvjftsrj","unsamzlmse",8855,281474976710712,99.11,9.223372036854776E16,"deadbeef"],["rvvazctyuhm","jzouegxpuqaeod",3575,281474976717622,46.08,9.223372036854776E16,"d [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["jyjbskss","ktzbslhqxociw",5655,281474976710734,36.66,9.223372036854776E16,"01a0bc"],["ytdhswvrujrhlu","kljynwcigrbwvjas",2537,281474976713189,85.2,9.223372036854776E16,"01a0bc"],["kjokwtkmuqz","ynefztocmqdr",4797,281474976713019,45.1,9.223372036854776E16," [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[ ["rgitlxyuwudikl","ixbnwcnvfl",4264,281474976719401,91.14,9.223372036854776E16,"01a0bc"],["rkoutvhyxiyabvf","olcqnezapdibpg",5939,281474976717872,93.17,9.223372036854776E16,"d54d0507"],["buympgyn","sjusmkrcptzk",6951,281474976715188,74.96,9.223372036854776E [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["oerfxfdpqgr","eebimdxgtx",1802,281474976719813,54.11,9.223372036854776E16,"deadbeef"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":3,"n [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["xaoqldkhnqeslf","hquvdmomblsdgk",2348,281474976717334,82.13,9.223372036854776E16,"d54d0507"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQuerie [...]
+{"resultTable":{"dataSchema":{"columnNames":["stringDimSV1","stringDimSV2","intMetric1","longMetric1","floatMetric1","doubleMetric1","bytesMetric1"],"columnDataTypes":["STRING","STRING","INT","LONG","FLOAT","DOUBLE","BYTES"]},"rows":[["hcqapafepmu","xhjeavrutltde",1397,281474976715751,90.35,9.223372036854776E16,"d54d0507"]]},"exceptions":[],"numServersQueried":1,"numServersResponded":1,"numSegmentsQueried":17,"numSegmentsProcessed":1,"numSegmentsMatched":1,"numConsumingSegmentsQueried":3 [...]
diff --git a/compatibility-verifier/sample-test-suite/post-broker-rollback.yaml b/compatibility-verifier/sample-test-suite/post-broker-rollback.yaml
index 855cd260f5..4d6fc60b7b 100644
--- a/compatibility-verifier/sample-test-suite/post-broker-rollback.yaml
+++ b/compatibility-verifier/sample-test-suite/post-broker-rollback.yaml
@@ -33,9 +33,17 @@ operations:
op: PRODUCE
streamConfigFileName: feature-test-2-realtime-stream-config.json
numRows: 66
- inputDataFileName: data/RealtimeFeatureTest1-data-00.csv
+ inputDataFileName: data/FeatureTest2-data-realtime-00.csv
recordReaderConfigFileName: data/recordReaderConfig.json
tableConfigFileName: feature-test-2-realtime.json
+ - type: streamOp
+ description: publish rows to PinotRealtimeFeatureTest3Event
+ op: PRODUCE
+ streamConfigFileName: feature-test-3-realtime-stream-config.json
+ numRows: 300
+ inputDataFileName: data/FeatureTest3-data-realtime-00.csv
+ recordReaderConfigFileName: data/recordReaderConfig-FeatureTest3.json
+ tableConfigFileName: feature-test-3-realtime.json
- type: queryOp
description: Run query on FeatureTest1 using SQL
queryFileName: queries/feature-test-1-sql.queries
@@ -44,3 +52,9 @@ operations:
description: Run query on FeatureTest2 using SQL
queryFileName: queries/feature-test-2-sql-realtime.queries
expectedResultsFileName: query-results/feature-test-2-sql-realtime.results
+ - type: queryOp
+ description: Run query on FeatureTest3 using SQL
+ queryFileName: queries/feature-test-3-sql-realtime.queries
+ expectedResultsFileName: query-results/feature-test-3-sql-realtime.results
+
+
diff --git a/compatibility-verifier/sample-test-suite/post-controller-rollback.yaml b/compatibility-verifier/sample-test-suite/post-controller-rollback.yaml
index 3f7be07b23..be488c7237 100644
--- a/compatibility-verifier/sample-test-suite/post-controller-rollback.yaml
+++ b/compatibility-verifier/sample-test-suite/post-controller-rollback.yaml
@@ -33,9 +33,17 @@ operations:
op: PRODUCE
streamConfigFileName: feature-test-2-realtime-stream-config.json
numRows: 66
- inputDataFileName: data/RealtimeFeatureTest1-data-00.csv
+ inputDataFileName: data/FeatureTest2-data-realtime-00.csv
recordReaderConfigFileName: data/recordReaderConfig.json
tableConfigFileName: feature-test-2-realtime.json
+ - type: streamOp
+ description: publish rows to PinotRealtimeFeatureTest3Event
+ op: PRODUCE
+ streamConfigFileName: feature-test-3-realtime-stream-config.json
+ numRows: 300
+ inputDataFileName: data/FeatureTest3-data-realtime-00.csv
+ recordReaderConfigFileName: data/recordReaderConfig-FeatureTest3.json
+ tableConfigFileName: feature-test-3-realtime.json
- type: queryOp
description: Run query on FeatureTest1 using SQL
queryFileName: queries/feature-test-1-sql.queries
@@ -44,6 +52,10 @@ operations:
description: Run query on FeatureTest2 using SQL
queryFileName: queries/feature-test-2-sql-realtime.queries
expectedResultsFileName: query-results/feature-test-2-sql-realtime.results
+ - type: queryOp
+ description: Run query on FeatureTest3 using SQL
+ queryFileName: queries/feature-test-3-sql-realtime.queries
+ expectedResultsFileName: query-results/feature-test-3-sql-realtime.results
- type: segmentOp
description: Delete segment FeatureTest1_Segment
op: DELETE
diff --git a/compatibility-verifier/sample-test-suite/post-server-rollback.yaml b/compatibility-verifier/sample-test-suite/post-server-rollback.yaml
index 13e58f3cfa..e14792072c 100644
--- a/compatibility-verifier/sample-test-suite/post-server-rollback.yaml
+++ b/compatibility-verifier/sample-test-suite/post-server-rollback.yaml
@@ -33,9 +33,17 @@ operations:
op: PRODUCE
streamConfigFileName: feature-test-2-realtime-stream-config.json
numRows: 66
- inputDataFileName: data/RealtimeFeatureTest1-data-00.csv
+ inputDataFileName: data/FeatureTest2-data-realtime-00.csv
recordReaderConfigFileName: data/recordReaderConfig.json
tableConfigFileName: feature-test-2-realtime.json
+ - type: streamOp
+ description: publish rows to PinotRealtimeFeatureTest3Event
+ op: PRODUCE
+ streamConfigFileName: feature-test-3-realtime-stream-config.json
+ numRows: 300
+ inputDataFileName: data/FeatureTest3-data-realtime-00.csv
+ recordReaderConfigFileName: data/recordReaderConfig-FeatureTest3.json
+ tableConfigFileName: feature-test-3-realtime.json
- type: queryOp
description: Run query on FeatureTest1 using SQL
queryFileName: queries/feature-test-1-sql.queries
@@ -44,3 +52,9 @@ operations:
description: Run query on FeatureTest2 using SQL
queryFileName: queries/feature-test-2-sql-realtime.queries
expectedResultsFileName: query-results/feature-test-2-sql-realtime.results
+ - type: queryOp
+ description: Run query on FeatureTest3 using SQL
+ queryFileName: queries/feature-test-3-sql-realtime.queries
+ expectedResultsFileName: query-results/feature-test-3-sql-realtime.results
+
+
diff --git a/compatibility-verifier/sample-test-suite/post-server-upgrade.yaml b/compatibility-verifier/sample-test-suite/post-server-upgrade.yaml
index a581cf6f89..38b50c44dd 100644
--- a/compatibility-verifier/sample-test-suite/post-server-upgrade.yaml
+++ b/compatibility-verifier/sample-test-suite/post-server-upgrade.yaml
@@ -33,9 +33,17 @@ operations:
op: PRODUCE
streamConfigFileName: feature-test-2-realtime-stream-config.json
numRows: 66
- inputDataFileName: data/RealtimeFeatureTest1-data-00.csv
+ inputDataFileName: data/FeatureTest2-data-realtime-00.csv
recordReaderConfigFileName: data/recordReaderConfig.json
tableConfigFileName: feature-test-2-realtime.json
+ - type: streamOp
+ description: publish rows to PinotRealtimeFeatureTest3Event
+ op: PRODUCE
+ streamConfigFileName: feature-test-3-realtime-stream-config.json
+ numRows: 300
+ inputDataFileName: data/FeatureTest3-data-realtime-00.csv
+ recordReaderConfigFileName: data/recordReaderConfig-FeatureTest3.json
+ tableConfigFileName: feature-test-3-realtime.json
- type: queryOp
description: Run query on FeatureTest1 using SQL
queryFileName: queries/feature-test-1-sql.queries
@@ -44,3 +52,9 @@ operations:
description: Run query on FeatureTest2 using SQL
queryFileName: queries/feature-test-2-sql-realtime.queries
expectedResultsFileName: query-results/feature-test-2-sql-realtime.results
+ - type: queryOp
+ description: Run query on FeatureTest3 using SQL
+ queryFileName: queries/feature-test-3-sql-realtime.queries
+ expectedResultsFileName: query-results/feature-test-3-sql-realtime.results
+
+
diff --git a/compatibility-verifier/sample-test-suite/pre-broker-upgrade.yaml b/compatibility-verifier/sample-test-suite/pre-broker-upgrade.yaml
index 97fd509e40..c20d5f45b4 100644
--- a/compatibility-verifier/sample-test-suite/pre-broker-upgrade.yaml
+++ b/compatibility-verifier/sample-test-suite/pre-broker-upgrade.yaml
@@ -33,9 +33,17 @@ operations:
op: PRODUCE
streamConfigFileName: feature-test-2-realtime-stream-config.json
numRows: 66
- inputDataFileName: data/RealtimeFeatureTest1-data-00.csv
+ inputDataFileName: data/FeatureTest2-data-realtime-00.csv
recordReaderConfigFileName: data/recordReaderConfig.json
tableConfigFileName: feature-test-2-realtime.json
+ - type: streamOp
+ description: publish rows to PinotRealtimeFeatureTest3Event
+ op: PRODUCE
+ streamConfigFileName: feature-test-3-realtime-stream-config.json
+ numRows: 300
+ inputDataFileName: data/FeatureTest3-data-realtime-00.csv
+ recordReaderConfigFileName: data/recordReaderConfig-FeatureTest3.json
+ tableConfigFileName: feature-test-3-realtime.json
- type: queryOp
description: Run query on FeatureTest1 using SQL
queryFileName: queries/feature-test-1-sql.queries
@@ -44,3 +52,8 @@ operations:
description: Run query on FeatureTest2 using SQL
queryFileName: queries/feature-test-2-sql-realtime.queries
expectedResultsFileName: query-results/feature-test-2-sql-realtime.results
+ - type: queryOp
+ description: Run query on FeatureTest3 using SQL
+ queryFileName: queries/feature-test-3-sql-realtime.queries
+ expectedResultsFileName: query-results/feature-test-3-sql-realtime.results
+
diff --git a/compatibility-verifier/sample-test-suite/pre-controller-upgrade.yaml b/compatibility-verifier/sample-test-suite/pre-controller-upgrade.yaml
index bb3b36b111..a2b7ee5af0 100644
--- a/compatibility-verifier/sample-test-suite/pre-controller-upgrade.yaml
+++ b/compatibility-verifier/sample-test-suite/pre-controller-upgrade.yaml
@@ -24,12 +24,22 @@ operations:
description: create Kafka topic PinotRealtimeFeatureTest2Event
op: CREATE
streamConfigFileName: feature-test-2-realtime-stream-config.json
+ - type: streamOp
+ description: create Kafka topic PinotRealtimeFeatureTest3Event
+ op: CREATE
+ streamConfigFileName: feature-test-3-realtime-stream-config.json
- type: tableOp
description: Create realtime table FeatureTest2
op: CREATE
schemaFileName: FeatureTest2-schema.json
tableConfigFileName: feature-test-2-realtime.json
recordReaderConfigFileName: data/recordReaderConfig.json
+ - type: tableOp
+ description: Create realtime table FeatureTest3
+ op: CREATE
+ schemaFileName: FeatureTest3-schema.json
+ tableConfigFileName: feature-test-3-realtime.json
+ recordReaderConfigFileName: data/recordReaderConfig-FeatureTest3.json
- type: tableOp
description: Create offline table FeatureTest1
op: CREATE
@@ -48,9 +58,17 @@ operations:
op: PRODUCE
streamConfigFileName: feature-test-2-realtime-stream-config.json
numRows: 66
- inputDataFileName: data/RealtimeFeatureTest1-data-00.csv
+ inputDataFileName: data/FeatureTest2-data-realtime-00.csv
recordReaderConfigFileName: data/recordReaderConfig.json
tableConfigFileName: feature-test-2-realtime.json
+ - type: streamOp
+ description: publish rows to PinotRealtimeFeatureTest3Event
+ op: PRODUCE
+ streamConfigFileName: feature-test-3-realtime-stream-config.json
+ numRows: 300
+ inputDataFileName: data/FeatureTest3-data-realtime-00.csv
+ recordReaderConfigFileName: data/recordReaderConfig-FeatureTest3.json
+ tableConfigFileName: feature-test-3-realtime.json
- type: queryOp
description: Run query on FeatureTest1 using SQL
queryFileName: queries/feature-test-1-sql.queries
@@ -59,3 +77,9 @@ operations:
description: Run query on FeatureTest2 using SQL
queryFileName: queries/feature-test-2-sql-realtime.queries
expectedResultsFileName: query-results/feature-test-2-sql-realtime.results
+ - type: queryOp
+ description: Run query on FeatureTest3 using SQL
+ queryFileName: queries/feature-test-3-sql-realtime.queries
+ expectedResultsFileName: query-results/feature-test-3-sql-realtime.results
+
+
diff --git a/compatibility-verifier/sample-test-suite/pre-server-upgrade.yaml b/compatibility-verifier/sample-test-suite/pre-server-upgrade.yaml
index 52c7f73da4..0a303ae73a 100644
--- a/compatibility-verifier/sample-test-suite/pre-server-upgrade.yaml
+++ b/compatibility-verifier/sample-test-suite/pre-server-upgrade.yaml
@@ -33,9 +33,17 @@ operations:
op: PRODUCE
streamConfigFileName: feature-test-2-realtime-stream-config.json
numRows: 66
- inputDataFileName: data/RealtimeFeatureTest1-data-00.csv
+ inputDataFileName: data/FeatureTest2-data-realtime-00.csv
recordReaderConfigFileName: data/recordReaderConfig.json
tableConfigFileName: feature-test-2-realtime.json
+ - type: streamOp
+ description: publish rows to PinotRealtimeFeatureTest3Event
+ op: PRODUCE
+ streamConfigFileName: feature-test-3-realtime-stream-config.json
+ numRows: 300
+ inputDataFileName: data/FeatureTest3-data-realtime-00.csv
+ recordReaderConfigFileName: data/recordReaderConfig-FeatureTest3.json
+ tableConfigFileName: feature-test-3-realtime.json
- type: queryOp
description: Run query on FeatureTest1 using SQL
queryFileName: queries/feature-test-1-sql.queries
@@ -44,3 +52,8 @@ operations:
description: Run query on FeatureTest2 using SQL
queryFileName: queries/feature-test-2-sql-realtime.queries
expectedResultsFileName: query-results/feature-test-2-sql-realtime.results
+ - type: queryOp
+ description: Run query on FeatureTest3 using SQL
+ queryFileName: queries/feature-test-3-sql-realtime.queries
+ expectedResultsFileName: query-results/feature-test-3-sql-realtime.results
+
diff --git a/pinot-common/src/main/java/org/apache/pinot/common/utils/SqlResultComparator.java b/pinot-common/src/main/java/org/apache/pinot/common/utils/SqlResultComparator.java
index c9f24814aa..3120eaea30 100644
--- a/pinot-common/src/main/java/org/apache/pinot/common/utils/SqlResultComparator.java
+++ b/pinot-common/src/main/java/org/apache/pinot/common/utils/SqlResultComparator.java
@@ -153,6 +153,12 @@ public class SqlResultComparator {
if (!isSelectionQuery(query) && !isNumDocsScannedBetter(actual, expected)) {
return false;
}
+ if (isNumEntriesScannedInFilterPresent(expected) && !isNumEntriesScannedInFilterBetter(actual, expected)) {
+ return false;
+ }
+ if (isNumConsumingSegmentsQueriedPresent(expected) && !areNumConsumingSegmentsQueriedEqual(actual, expected)) {
+ return false;
+ }
}
return areResultsEqual;
}
@@ -309,6 +315,10 @@ public class SqlResultComparator {
return true;
}
+ private static boolean isNumConsumingSegmentsQueriedPresent(JsonNode expected) {
+ return expected.get(FIELD_NUM_CONSUMING_SEGMENTS_QUERIED) != null;
+ }
+
private static boolean areNumConsumingSegmentsQueriedEqual(JsonNode actual, JsonNode expected) {
long actualNumConsumingSegmentsQueried = actual.get(FIELD_NUM_CONSUMING_SEGMENTS_QUERIED).asLong();
long expectedNumConsumingSegmentsQueried = expected.get(FIELD_NUM_CONSUMING_SEGMENTS_QUERIED).asLong();
@@ -375,6 +385,10 @@ public class SqlResultComparator {
return true;
}
+ private static boolean isNumEntriesScannedInFilterPresent(JsonNode expected) {
+ return expected.get(FIELD_NUM_ENTRIES_SCANNED_IN_FILTER) != null;
+ }
+
private static boolean isNumEntriesScannedInFilterBetter(JsonNode actual, JsonNode expected) {
long actualNumEntriesScannedInFilter = actual.get(FIELD_NUM_ENTRIES_SCANNED_IN_FILTER).asLong();
long expectedNumEntriesScannedInFilter = expected.get(FIELD_NUM_ENTRIES_SCANNED_IN_FILTER).asLong();
diff --git a/pinot-compatibility-verifier/src/main/java/org/apache/pinot/compat/QueryOp.java b/pinot-compatibility-verifier/src/main/java/org/apache/pinot/compat/QueryOp.java
index 928b591cff..2489851d5d 100644
--- a/pinot-compatibility-verifier/src/main/java/org/apache/pinot/compat/QueryOp.java
+++ b/pinot-compatibility-verifier/src/main/java/org/apache/pinot/compat/QueryOp.java
@@ -133,7 +133,8 @@ public class QueryOp extends BaseOp {
if (expectedJson != null && actualJson != null) {
try {
- boolean passed = SqlResultComparator.areEqual(actualJson, expectedJson, query);
+ boolean passed = SqlResultComparator
+ .areEqual(actualJson, expectedJson, query);
if (passed) {
succeededQueryCount++;
LOGGER.debug("Comparison PASSED: Line: {}, query: '{}', actual response: {}, expected response: {}",
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org