You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by am...@apache.org on 2013/04/26 06:59:58 UTC
svn commit: r1476039 [22/22] - in /hive/branches/HIVE-4115: ./ beeline/
beeline/src/java/org/apache/hive/beeline/ bin/ builtins/ cli/
common/src/java/org/apache/hadoop/hive/conf/ conf/ data/files/
eclipse-templates/ hbase-handler/ hbase-handler/src/jav...
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_windowspec.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_windowspec.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_windowspec.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_windowspec.q.out Fri Apr 26 04:59:50 2013
@@ -39,148 +39,148 @@ PREHOOK: Output: default@over10k
POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
POSTHOOK: Output: default@over10k
-PREHOOK: query: select s, sum(b) over (partition by i order by si rows unbounded preceding) from over10k limit 100
+PREHOOK: query: select s, sum(b) over (partition by i order by s,b rows unbounded preceding) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select s, sum(b) over (partition by i order by si rows unbounded preceding) from over10k limit 100
+POSTHOOK: query: select s, sum(b) over (partition by i order by s,b rows unbounded preceding) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-bob robinson 4294967349
-irene johnson 8589934809
-david nixon 12884902300
-holly white 17179869620
-sarah thompson 21474836919
-david johnson 25769804409
-gabriella garcia 30064771840
-nick davidson 34359739370
-ethan underhill 38654706880
-ethan johnson 42949674237
-ethan ovid 47244641665
-ulysses polk 51539609149
-rachel xylophone 55834576466
-priscilla young 60129543807
-zach hernandez 64424511119
-wendy polk 68719478445
-priscilla garcia 73014445793
-oscar allen 77309413101
-priscilla xylophone 81604380561
-oscar garcia 85899348058
-sarah thompson 90194315396
-oscar ovid 94489282904
-luke allen 98784250367
-fred miller 103079217857
-rachel brown 107374185306
-alice ichabod 111669152747
-alice robinson 115964120223
-victor johnson 120259087607
-priscilla white 124554055096
-calvin thompson 128849022432
-rachel ichabod 133143989766
-mike quirinius 137438957244
-gabriella underhill 141733924551
-david laertes 146028891982
-katie ellison 150323859357
-fred miller 154618826769
-xavier davidson 158913794163
-oscar ichabod 163208761567
-tom steinbeck 167503728932
-tom johnson 171798696363
-david nixon 176093663744
-zach allen 180388631253
-yuri ellison 184683598766
-oscar steinbeck 188978566217
-mike white 193273533646
-david xylophone 4294967419
-oscar carson 8589934879
-alice ellison 12884902325
-nick davidson 17179869787
-mike hernandez 21474837308
-sarah ichabod 25769804857
-zach ichabod 30064772276
-zach ovid 34359739647
-yuri garcia 38654707087
-zach nixon 42949674516
-nick carson 47244641852
-mike garcia 51539609271
-wendy van buren 55834576685
-luke nixon 60129544135
-priscilla white 64424511540
-gabriella ichabod 68719478979
-xavier underhill 73014446393
-zach falkner 77309413898
-holly laertes 81604381346
-calvin brown 85899348783
-yuri quirinius 90194316225
-yuri white 94489283634
-katie robinson 98784251053
-katie thompson 103079218409
-oscar robinson 107374185735
-jessica hernandez 111669153271
-ulysses falkner 115964120819
-holly quirinius 120259088349
-fred van buren 124554055812
-victor xylophone 128849023352
-bob carson 133143990798
-ethan white 137438958291
-wendy garcia 141733925665
-fred johnson 146028893128
-sarah falkner 150323860576
-gabriella johnson 4294967496
-yuri brown 8589935023
-xavier davidson 12884902564
-katie nixon 17179870081
-calvin allen 21474837415
-mike brown 25769804757
-zach van buren 30064772179
-tom polk 34359739577
-alice ichabod 38654707028
-holly thompson 42949674367
-oscar white 47244641792
-priscilla xylophone 51539609245
-nick quirinius 55834576730
-ulysses davidson 60129544067
-gabriella nixon 64424511395
-rachel young 68719478910
-sarah ichabod 73014446396
-ulysses robinson 77309413900
-quinn laertes 81604381239
-luke white 85899348560
-PREHOOK: query: select s, sum(f) over (partition by d order by i rows unbounded preceding) from over10k limit 100
+alice ichabod 4294967441
+alice robinson 8589934917
+bob robinson 12884902266
+calvin thompson 17179869602
+david johnson 21474837092
+david laertes 25769804523
+david nixon 30064771904
+david nixon 34359739395
+ethan johnson 38654706752
+ethan ovid 42949674180
+ethan underhill 47244641690
+fred miller 51539609102
+fred miller 55834576592
+gabriella garcia 60129544023
+gabriella underhill 64424511330
+holly white 68719478650
+irene johnson 73014446110
+katie ellison 77309413485
+luke allen 81604380948
+mike quirinius 85899348426
+mike white 90194315855
+nick davidson 94489283385
+oscar allen 98784250693
+oscar garcia 103079218190
+oscar ichabod 107374185594
+oscar ovid 111669153102
+oscar steinbeck 115964120553
+priscilla garcia 120259087901
+priscilla white 124554055390
+priscilla xylophone 128849022850
+priscilla young 133143990191
+rachel brown 137438957640
+rachel ichabod 141733924974
+rachel xylophone 146028892291
+sarah thompson 150323859590
+sarah thompson 154618826928
+tom johnson 158913794359
+tom steinbeck 163208761724
+ulysses polk 167503729208
+victor johnson 171798696592
+wendy polk 176093663918
+xavier davidson 180388631312
+yuri ellison 184683598825
+zach allen 188978566334
+zach hernandez 193273533646
+alice ellison 4294967446
+bob carson 8589934892
+calvin brown 12884902329
+david xylophone 17179869748
+ethan white 21474837241
+fred johnson 25769804704
+fred van buren 30064772167
+gabriella ichabod 34359739606
+holly laertes 38654707054
+holly quirinius 42949674584
+jessica hernandez 47244642120
+katie robinson 51539609539
+katie thompson 55834576895
+luke nixon 60129544345
+mike garcia 64424511764
+mike hernandez 68719479285
+nick carson 73014446621
+nick davidson 77309414083
+oscar carson 81604381543
+oscar robinson 85899348869
+priscilla white 90194316274
+sarah falkner 94489283722
+sarah ichabod 98784251271
+ulysses falkner 103079218819
+victor xylophone 107374186359
+wendy garcia 111669153733
+wendy van buren 115964121147
+xavier underhill 120259088561
+yuri garcia 124554056001
+yuri quirinius 128849023443
+yuri white 133143990852
+zach falkner 137438958357
+zach ichabod 141733925776
+zach nixon 146028893205
+zach ovid 150323860576
+alice ichabod 4294967451
+alice king 8589934958
+alice robinson 12884902278
+calvin allen 17179869612
+gabriella johnson 21474837108
+gabriella nixon 25769804436
+holly falkner 30064771905
+holly hernandez 34359739256
+holly thompson 38654706595
+katie nixon 42949674112
+luke brown 47244641636
+luke davidson 51539608978
+luke white 55834576299
+mike brown 60129543641
+nick quirinius 64424511126
+oscar white 68719478551
+priscilla xylophone 73014446004
+quinn garcia 77309413317
+quinn laertes 81604380656
+rachel young 85899348171
+PREHOOK: query: select s, sum(f) over (partition by d order by s,f rows unbounded preceding) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select s, sum(f) over (partition by d order by i rows unbounded preceding) from over10k limit 100
+POSTHOOK: query: select s, sum(f) over (partition by d order by s,f rows unbounded preceding) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
calvin miller 8.390000343322754
-wendy quirinius 25.5
-holly polk 30.789999961853027
+holly polk 5.289999961853027
+wendy quirinius 30.789999961853027
yuri laertes 68.38000011444092
nick steinbeck 79.23999786376953
katie brown 60.0
priscilla quirinius 137.83999633789062
tom young 186.33999633789062
-xavier robinson 87.91000366210938
-katie falkner 139.4800033569336
-gabriella quirinius 153.84000301361084
+gabriella quirinius 14.359999656677246
+katie falkner 65.92999935150146
+xavier robinson 153.84000301361084
ethan carson 40.90999984741211
victor johnson 100.0
-zach white 46.54999923706055
-jessica white 78.0099983215332
-jessica king 170.71999740600586
+jessica king 92.70999908447266
+jessica white 124.16999816894531
+zach white 170.71999740600586
holly falkner 97.3499984741211
-victor davidson 157.06999969482422
-quinn falkner 255.95999908447266
+quinn falkner 196.23999786376953
+victor davidson 255.95999908447266
holly young 19.110000610351562
nick robinson 13.329999923706055
xavier steinbeck 48.53999900817871
irene king 30.469999313354492
quinn zipper 90.04000091552734
-wendy zipper 77.44000244140625
-priscilla miller 92.8000020980835
+priscilla miller 15.359999656677246
+wendy zipper 92.8000020980835
yuri miller 153.5600004196167
zach steinbeck 9.069999694824219
fred nixon 50.08000183105469
@@ -192,606 +192,606 @@ holly hernandez 48.52000045776367
jessica quirinius 90.18000030517578
tom xylophone 166.11000061035156
wendy king 184.76000022888184
-yuri zipper 70.7699966430664
-gabriella brown 155.5999984741211
-quinn johnson 205.75
+gabriella brown 84.83000183105469
+quinn johnson 134.9800033569336
+yuri zipper 205.75
david robinson 64.79000091552734
mike nixon 153.7300033569336
-rachel davidson 96.70999908447266
-gabriella white 98.12999904155731
+gabriella white 1.4199999570846558
+rachel davidson 98.12999904155731
yuri garcia 9.880000114440918
yuri zipper 104.01999950408936
-katie hernandez 67.55999755859375
-jessica steinbeck 93.24999809265137
-alice king 178.9699993133545
-quinn davidson 95.11000061035156
-quinn van buren 177.91000366210938
-priscilla young 239.6400032043457
-katie ovid 279.6400032043457
+alice king 85.72000122070312
+jessica steinbeck 111.41000175476074
+katie hernandez 178.9699993133545
+katie ovid 40.0
+priscilla young 101.72999954223633
+quinn davidson 196.8400001525879
+quinn van buren 279.6400032043457
victor steinbeck 309.6400032043457
gabriella brown 80.6500015258789
jessica ichabod 96.54000091552734
zach laertes 104.50000095367432
-tom robinson 89.36000061035156
-irene carson 150.43000030517578
-irene falkner 171.17000007629395
-priscilla zipper 241.14000129699707
-ethan miller 290.75000190734863
-nick white 58.25
-xavier laertes 119.95999908447266
-katie polk 158.64999771118164
-sarah davidson 161.30999779701233
-nick polk 98.29000091552734
-alice ichabod 130.97999954223633
-luke brown 0.6200000047683716
-gabriella robinson 90.71999847888947
+ethan miller 49.61000061035156
+irene carson 110.68000030517578
+irene falkner 131.42000007629395
+priscilla zipper 201.39000129699707
+tom robinson 290.75000190734863
+katie polk 38.689998626708984
+nick white 96.93999862670898
+sarah davidson 99.59999871253967
+xavier laertes 161.30999779701233
+alice ichabod 32.689998626708984
+nick polk 130.97999954223633
+gabriella robinson 90.0999984741211
+luke brown 90.71999847888947
wendy allen 116.34999763965607
calvin ichabod 29.059999465942383
holly steinbeck 98.4799976348877
gabriella carson 38.09000015258789
-tom nixon 123.11999893188477
-holly van buren 191.92999649047852
-mike brown 88.22000122070312
-katie laertes 163.97000122070312
+holly van buren 106.89999771118164
+tom nixon 191.92999649047852
+katie laertes 75.75
+mike brown 163.97000122070312
oscar nixon 24.020000457763672
zach garcia 101.61999893188477
tom polk 76.98999786376953
mike allen 96.44999694824219
alice johnson 1.090000033378601
-priscilla thompson 84.91999816894531
-yuri young 142.52999877929688
-holly robinson 168.73999786376953
+holly robinson 26.209999084472656
+priscilla thompson 111.12999725341797
+yuri young 168.73999786376953
rachel carson 80.98999786376953
-victor brown 39.15999984741211
-gabriella laertes 78.97999954223633
-holly allen 44.56999969482422
-bob carson 68.71999931335449
-rachel carson 81.55000305175781
-fred nixon 119.60000228881836
+gabriella laertes 39.81999969482422
+victor brown 78.97999954223633
+bob carson 24.149999618530273
+holly allen 68.71999931335449
+fred nixon 38.04999923706055
+rachel carson 119.60000228881836
alice nixon 49.130001068115234
priscilla brown 123.57999801635742
victor falkner 42.4900016784668
-tom white 37.630001068115234
-david garcia 104.90999984741211
-holly hernandez 154.0
+david garcia 67.27999877929688
+holly hernandez 116.36999893188477
+tom white 154.0
rachel ellison 10.600000381469727
-PREHOOK: query: select s, sum(f) over (partition by ts order by b range between current row and unbounded following) from over10k limit 100
+PREHOOK: query: select s, sum(f) over (partition by ts order by f range between current row and unbounded following) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select s, sum(f) over (partition by ts order by b range between current row and unbounded following) from over10k limit 100
+POSTHOOK: query: select s, sum(f) over (partition by ts order by f range between current row and unbounded following) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-sarah falkner 1276.850001335144
-mike laertes 1236.3100004196167
-katie white 1194.7100019454956
-priscilla zipper 1194.7100019454956
-fred zipper 1081.7100057601929
-yuri allen 997.0000066757202
-fred nixon 982.220006942749
-wendy steinbeck 953.5300064086914
-nick carson 888.5700073242188
-calvin laertes 797.2100067138672
-jessica polk 766.0400066375732
-calvin brown 671.0000057220459
-david falkner 660.1100053787231
-calvin steinbeck 621.760006904602
-katie king 583.1500062942505
-jessica laertes 490.19000720977783
-rachel thompson 475.6500072479248
-gabriella van buren 475.6500072479248
-victor ellison 309.64000511169434
-gabriella xylophone 263.56000328063965
-oscar brown 260.3900032043457
-luke zipper 231.1700038909912
-tom johnson 176.81000328063965
-rachel garcia 158.96000289916992
-victor van buren 102.02000427246094
-bob ovid 20.610000610351562
-priscilla hernandez 2368.430002987385
-quinn ovid 2316.340002834797
-yuri brown 2253.3100040555
-katie zipper 2235.730004131794
-irene brown 2198.4100044369698
-nick ellison 2163.0900047421455
-jessica robinson 2152.4700048565865
-fred polk 2152.4700048565865
-gabriella johnson 2087.890006840229
-wendy johnson 2058.1800077557564
-jessica brown 1974.2000043988228
-katie xylophone 1895.150001347065
-priscilla zipper 1809.5999982953072
-luke thompson 1762.7599981427193
-rachel ovid 1733.689998447895
-holly thompson 1729.9599984288216
-xavier davidson 1729.9599984288216
-ethan young 1671.4599993824959
-ulysses xylophone 1583.52999907732
-wendy thompson 1568.829999268055
-katie davidson 1553.869999229908
-victor underhill 1472.4599955677986
-calvin carson 1407.9099925160408
-rachel ovid 1331.7799952626228
-zach young 1275.3299944996834
-rachel robinson 1231.0299952626228
-calvin nixon 1210.019995033741
-yuri hernandez 1210.019995033741
-quinn allen 1121.3799956440926
-luke xylophone 1089.439995110035
-ulysses johnson 1032.6799967885017
-jessica nixon 948.4699977040291
-luke steinbeck 868.0399973988533
-rachel young 773.7700007557869
-gabriella steinbeck 724.8800013661385
-oscar davidson 686.3800013661385
-alice miller 685.5500013828278
-bob king 640.8900015354156
-fred king 628.0600016117096
-xavier johnson 628.0600016117096
-gabriella underhill 543.2200031280518
-ethan ovid 454.290002822876
-luke king 435.19000244140625
-jessica brown 366.5699996948242
-bob falkner 334.7299995422363
-oscar van buren 334.7299995422363
-sarah van buren 173.4000015258789
-calvin white 119.31000137329102
-priscilla brown 69.03000259399414
-holly falkner 26.950000762939453
-bob carson 1607.950005441904
-oscar carson 1607.1600054204464
-rachel polk 1514.8300035893917
-sarah falkner 1485.8200033605099
-yuri garcia 1446.5200041234493
-ethan nixon 1423.2500036656857
-victor hernandez 1385.3000029027462
-nick king 1385.3000029027462
-quinn van buren 1385.3000029027462
-victor hernandez 1193.4799989163876
-rachel ichabod 1168.349999755621
-holly allen 1115.910001128912
-priscilla garcia 1115.5500011146069
-rachel davidson 1035.5300044715405
-priscilla thompson 954.2400035560131
-wendy brown 900.140005081892
-alice underhill 811.3100032508373
-holly nixon 785.4000034034252
-jessica thompson 754.9300040900707
-rachel ichabod 698.2300033271313
-wendy falkner 697.7500033378601
-wendy miller 635.6600031852722
-wendy underhill 634.3900032043457
-calvin white 609.0500030517578
-PREHOOK: query: select s, avg(f) over (partition by bin order by s rows between current row and 5 following) from over10k limit 100
+gabriella xylophone 1276.850001335144
+calvin brown 1273.68000125885
+jessica laertes 1262.7900009155273
+yuri allen 1248.2500009536743
+tom johnson 1233.4700012207031
+bob ovid 1215.6200008392334
+fred nixon 1195.0100002288818
+oscar brown 1166.3199996948242
+calvin laertes 1137.1000003814697
+david falkner 1105.9300003051758
+calvin steinbeck 1067.5800018310547
+katie white 1028.9700012207031
+sarah falkner 989.4900016784668
+mike laertes 948.9500007629395
+victor ellison 907.3500022888184
+luke zipper 861.2700004577637
+rachel garcia 806.9099998474121
+wendy steinbeck 749.9700012207031
+priscilla zipper 685.0100021362305
+rachel thompson 611.4900054931641
+victor van buren 532.9100036621094
+fred zipper 451.5
+gabriella van buren 366.79000091552734
+nick carson 279.36000061035156
+katie king 188.0
+jessica polk 95.04000091552734
+oscar davidson 2368.430002987385
+xavier johnson 2367.600003004074
+rachel ovid 2365.6100029945374
+xavier davidson 2361.880002975464
+nick ellison 2353.0200033187866
+jessica robinson 2342.4000034332275
+bob king 2331.0800037384033
+ulysses xylophone 2318.2500038146973
+wendy thompson 2303.550004005432
+yuri brown 2288.590003967285
+ethan ovid 2271.010004043579
+rachel robinson 2251.9100036621094
+holly falkner 2230.9000034332275
+calvin nixon 2203.950002670288
+luke thompson 2176.7200031280518
+gabriella johnson 2147.6500034332275
+jessica brown 2117.940004348755
+quinn allen 2086.100004196167
+irene brown 2054.1600036621094
+katie zipper 2018.8400039672852
+gabriella steinbeck 1981.520004272461
+priscilla brown 1943.020004272461
+zach young 1900.9400024414062
+alice miller 1856.6400032043457
+priscilla zipper 1811.9800033569336
+rachel young 1765.1400032043457
+holly thompson 1716.2500038146973
+calvin white 1666.6100044250488
+priscilla hernandez 1616.330005645752
+fred polk 1564.240005493164
+sarah van buren 1510.9800071716309
+rachel ovid 1456.890007019043
+luke xylophone 1400.4400062561035
+yuri hernandez 1343.6800079345703
+oscar van buren 1282.2700080871582
+quinn ovid 1220.390007019043
+victor underhill 1157.360008239746
+luke king 1092.8100051879883
+calvin carson 1024.1900024414062
+jessica brown 948.0600051879883
+jessica nixon 869.0100021362305
+katie davidson 788.5800018310547
+fred king 707.1699981689453
+wendy johnson 624.3199996948242
+ulysses johnson 540.3399963378906
+katie xylophone 456.12999725341797
+ethan young 370.57999420166016
+gabriella underhill 282.6499938964844
+luke steinbeck 193.7199935913086
+bob falkner 99.44999694824219
+holly allen 1607.950005441904
+rachel ichabod 1607.590005427599
+bob carson 1607.1100054383278
+wendy miller 1606.3200054168701
+nick king 1605.0500054359436
+rachel ellison 1600.5700054168701
+yuri garcia 1591.5700054168701
+victor hernandez 1568.3000049591064
+wendy underhill 1543.1700057983398
+alice underhill 1517.830005645752
+rachel polk 1491.9200057983398
+holly nixon 1462.910005569458
+ethan nixon 1432.4400062561035
+sarah falkner 1394.490005493164
+tom hernandez 1355.1900062561035
+rachel ichabod 1309.2800064086914
+priscilla thompson 1256.8400077819824
+jessica thompson 1202.7400093078613
+ulysses carson 1146.0400085449219
+wendy falkner 1087.2700080871582
+calvin white 1025.1800079345703
+jessica ovid 956.9800109863281
+jessica johnson 885.3000106811523
+priscilla garcia 805.8400115966797
+PREHOOK: query: select s, avg(f) over (partition by ts order by s,f rows between current row and 5 following) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select s, avg(f) over (partition by bin order by s rows between current row and 5 following) from over10k limit 100
+POSTHOOK: query: select s, avg(f) over (partition by ts order by s,f rows between current row and 5 following) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-alice davidson 48.39166768391927
-alice davidson 46.76333427429199
-alice falkner 46.43333371480306
-alice falkner 46.9966672261556
-alice garcia 50.778334299723305
-alice hernandez 58.11500040690104
-alice king 56.846666971842446
-alice king 48.9350004196167
-alice nixon 42.5600004196167
-alice ovid 41.2383337020874
-alice polk 40.97999986012777
-alice quirinius 39.10666688283285
-alice steinbeck 38.64833370844523
-alice steinbeck 45.453333695729576
-alice xylophone 45.72333383560181
-bob allen 49.850000858306885
-bob carson 47.93000078201294
-bob davidson 50.72666724522909
-bob garcia 54.31500085194906
-bob ichabod 53.10500113169352
-bob king 54.813334147135414
-bob nixon 46.69166692097982
-bob quirinius 40.1850004196167
-bob robinson 40.178333600362144
-bob steinbeck 41.888333320617676
-bob thompson 45.609999656677246
-bob underhill 54.843332608540855
-bob underhill 67.28666655222575
-bob van buren 78.15333302815755
-bob white 77.08833312988281
-bob zipper 77.79500007629395
-calvin falkner 73.87833340962727
-calvin johnson 64.13000043233235
-calvin king 59.62166659037272
-calvin miller 54.65000025431315
-calvin robinson 45.6850004196167
-calvin young 47.97666708628336
-david falkner 53.101667722066246
-david falkner 46.96000130971273
-david garcia 38.215001265207924
-david laertes 31.49333429336548
-david robinson 29.42000087102254
-david robinson 20.826667308807373
-david underhill 18.201666673024494
-david underhill 25.678333441416424
-david underhill 35.02333323160807
-david young 33.43166661262512
-david young 44.64500037829081
-david young 52.74333373705546
-ethan brown 48.8166671593984
-ethan brown 54.74000064531962
-ethan brown 51.29333392779032
-ethan carson 61.7383337020874
-ethan carson 61.09500026702881
-ethan ellison 63.83333365122477
-ethan falkner 71.36666742960612
-ethan hernandez 64.01333363850911
-ethan hernandez 63.31000073750814
-ethan king 61.715000788370766
-ethan miller 62.758334477742515
-ethan nixon 59.5483341217041
-ethan nixon 52.14833354949951
-ethan polk 54.858333905537926
-ethan thompson 48.25166702270508
-ethan thompson 51.20000076293945
-ethan underhill 38.90000009536743
-ethan underhill 35.8683336575826
-ethan xylophone 33.24166711171468
-ethan zipper 38.02166716257731
-fred davidson 40.61000061035156
-fred ellison 42.13666661580404
-fred laertes 48.21500031153361
-fred ovid 50.3050004641215
-fred robinson 51.78000036875407
-fred underhill 39.080000162124634
-fred zipper 42.42166670163473
-gabriella ellison 29.853333711624146
-gabriella king 33.516666332880654
-gabriella laertes 33.8649996916453
-gabriella miller 31.606666326522827
-gabriella steinbeck 31.81166632970174
-gabriella underhill 32.311666329701744
-gabriella van buren 37.053332805633545
-gabriella van buren 32.42833344141642
-gabriella young 38.19166707992554
-gabriella zipper 45.965000788370766
-holly brown 49.75166734059652
-holly carson 53.02666759490967
-holly king 61.99000072479248
-holly king 71.15833377838135
-holly laertes 59.49499988555908
-holly nixon 51.66999959945679
-holly polk 47.653333028157554
-holly polk 43.83499972025553
-holly quirinius 28.495000183582306
-holly robinson 17.7650000055631
-holly steinbeck 15.870000024636587
-holly underhill 17.810000081857044
-holly underhill 17.54666676123937
-holly van buren 24.124999662240345
-PREHOOK: query: select s, avg(d) over (partition by t order by ts desc rows between 5 preceding and 5 following) from over10k limit 100
+bob ovid 28.053333441416424
+calvin brown 38.73666652043661
+calvin laertes 51.493333180745445
+calvin steinbeck 46.826666514078774
+david falkner 42.81499973932902
+fred nixon 52.26333347956339
+fred zipper 62.97499990463257
+gabriella van buren 55.43666664759318
+gabriella xylophone 49.925000031789146
+jessica laertes 56.32999976476034
+jessica polk 69.13333320617676
+katie king 58.16333293914795
+katie white 54.92333253224691
+luke zipper 57.83333237965902
+mike laertes 61.86999924977621
+nick carson 61.69333299001058
+oscar brown 49.44166628519694
+priscilla zipper 52.25166670481364
+rachel garcia 53.56666787465414
+rachel thompson 54.903334617614746
+sarah falkner 44.27000093460083
+tom johnson 45.01600093841553
+victor ellison 51.80750107765198
+victor van buren 53.71666749318441
+wendy steinbeck 39.869999408721924
+yuri allen 14.779999732971191
+alice miller 51.76333204905192
+bob falkner 47.50333213806152
+bob king 45.58333269755045
+calvin carson 57.253332455952965
+calvin nixon 53.441665967305504
+calvin white 53.85499922434489
+ethan ovid 51.891666094462074
+ethan young 63.52999941507975
+fred king 53.36666615804037
+fred polk 47.83166631062826
+gabriella johnson 44.84166653951009
+gabriella steinbeck 45.1966667175293
+gabriella underhill 51.95500055948893
+holly falkner 50.538333892822266
+holly thompson 47.93333371480306
+irene brown 53.22833442687988
+jessica brown 61.600001653035484
+jessica brown 62.51333491007487
+jessica nixon 60.775001525878906
+jessica robinson 63.08166758219401
+katie davidson 66.04000091552734
+katie xylophone 61.931666692097984
+katie zipper 49.44333283106486
+luke king 43.36166621247927
+luke steinbeck 42.238332599401474
+luke thompson 33.54000013073286
+luke xylophone 37.376666873693466
+nick ellison 35.72333384553591
+oscar davidson 39.27666728695234
+oscar van buren 49.643333752950035
+priscilla brown 39.95166691144308
+priscilla hernandez 42.346666733423866
+priscilla zipper 37.166666746139526
+quinn allen 37.50833328564962
+quinn ovid 41.199999888738
+rachel ovid 44.729999939600624
+rachel ovid 46.558333237965904
+rachel robinson 47.90833361943563
+rachel young 58.40333414077759
+sarah van buren 52.74833424886068
+ulysses johnson 45.21000083287557
+ulysses xylophone 31.506667653719585
+victor underhill 31.98666767279307
+wendy johnson 31.46333380540212
+wendy thompson 24.84999978542328
+xavier davidson 26.82799973487854
+xavier johnson 31.319999754428864
+yuri brown 41.09666633605957
+yuri hernandez 52.85499954223633
+zach young 44.29999923706055
+alice underhill 38.0366666217645
+bob carson 38.7966665327549
+calvin white 51.90833304325739
+ethan ichabod 52.48833360274633
+ethan nixon 46.103333373864494
+holly allen 40.5249999165535
+holly nixon 55.85333355267843
+jessica johnson 64.11166644096375
+jessica ovid 66.54166674613953
+jessica thompson 69.09166725476582
+nick king 68.65833353996277
+oscar carson 82.59166717529297
+priscilla garcia 80.75166702270508
+priscilla hernandez 68.91500091552734
+priscilla polk 53.32166742781798
+priscilla thompson 47.56499997278055
+quinn van buren 43.383333598574005
+rachel davidson 35.253333166241646
+rachel ellison 29.356666321555775
+rachel ichabod 37.651666397849716
+rachel ichabod 41.75999959309896
+rachel polk 49.56333351135254
+sarah falkner 59.53333377838135
+tom hernandez 63.331667264302574
+PREHOOK: query: select s, avg(d) over (partition by t order by s,d desc rows between 5 preceding and 5 following) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select s, avg(d) over (partition by t order by ts desc rows between 5 preceding and 5 following) from over10k limit 100
+POSTHOOK: query: select s, avg(d) over (partition by t order by s,d desc rows between 5 preceding and 5 following) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-alice allen 26.85166666666667
-priscilla zipper 26.47857142857143
-oscar miller 29.321250000000003
-jessica johnson 31.596666666666668
-rachel davidson 30.332
-mike xylophone 30.16
-victor robinson 30.48909090909091
-david falkner 30.072727272727274
-alice falkner 31.735454545454548
-victor thompson 34.666363636363634
-irene underhill 30.888181818181817
-calvin white 28.08545454545454
-wendy robinson 30.245454545454546
-luke ichabod 30.201818181818183
-mike allen 26.28818181818182
-sarah zipper 24.572727272727274
-gabriella brown 23.074545454545458
-sarah robinson 21.203636363636367
-oscar garcia 20.433636363636367
-bob falkner 16.83454545454546
-jessica king 14.047272727272725
-rachel thompson 16.774545454545454
-holly polk 20.42727272727273
-wendy quirinius 17.714545454545455
-holly nixon 13.49909090909091
-bob ellison 17.05818181818182
-ulysses steinbeck 21.513636363636365
-yuri xylophone 24.372727272727275
-ulysses carson 27.01090909090909
-zach thompson 27.95909090909091
-david hernandez 31.309090909090912
-tom steinbeck 34.02454545454546
-priscilla laertes 32.46454545454546
-alice king 32.71636363636364
-jessica miller 31.975454545454546
-quinn polk 34.85454545454546
-holly steinbeck 34.307272727272725
-bob ichabod 32.709999999999994
-fred ellison 31.74272727272727
-quinn ellison 31.06363636363636
-priscilla quirinius 31.685454545454547
-ulysses robinson 27.94363636363636
-alice davidson 24.37
-holly underhill 24.76
-tom polk 21.314545454545456
-mike king 23.95909090909091
-calvin ichabod 21.58909090909091
-luke king 20.710000000000004
-bob johnson 20.000000000000004
-bob van buren 20.19
-jessica white 19.713636363636365
-ulysses ellison 18.872727272727275
-xavier garcia 18.97
-zach young 21.62272727272727
-wendy xylophone 21.697272727272725
-mike polk 24.85545454545455
-david garcia 23.35363636363636
-ulysses quirinius 24.449999999999992
-bob underhill 23.74272727272727
-tom hernandez 22.682727272727274
-luke young 22.7
-bob underhill 20.69
-victor hernandez 22.755454545454544
-sarah miller 25.623636363636365
-victor allen 24.8
-xavier ovid 22.758181818181818
-nick robinson 19.535454545454545
-alice king 19.842727272727274
-katie ichabod 19.493636363636366
-ethan underhill 17.997272727272726
-david carson 17.12272727272727
-victor xylophone 16.85545454545455
-oscar johnson 17.233636363636364
-alice xylophone 15.209090909090913
-bob polk 13.514545454545454
-sarah xylophone 15.072727272727274
-oscar johnson 15.853636363636365
-tom hernandez 19.042727272727276
-irene ellison 19.905454545454543
-mike white 20.50181818181818
-irene young 22.430000000000003
-nick nixon 24.43
-ethan steinbeck 23.576666666666668
-luke garcia 25.168750000000003
-holly thompson 27.551428571428573
-oscar davidson 29.75666666666667
-zach johnson 28.561666666666667
-alice nixon 25.732857142857142
-sarah van buren 23.74
-rachel thompson 24.32222222222222
-jessica white 26.415999999999997
-rachel polk 26.687272727272724
-fred ichabod 27.236363636363635
-irene ichabod 24.90909090909091
-fred polk 25.44181818181818
-quinn carson 23.25909090909091
-sarah allen 22.62727272727273
-jessica steinbeck 24.30636363636364
-ethan nixon 25.035454545454545
-jessica zipper 25.474545454545456
-PREHOOK: query: select s, sum(i) over() from over10k limit 100
+alice allen 33.20166666666666
+alice davidson 30.741428571428568
+alice falkner 27.742499999999996
+alice king 26.706666666666663
+alice king 26.306999999999995
+alice xylophone 24.458181818181814
+bob ellison 25.029090909090904
+bob falkner 24.216363636363635
+bob ichabod 20.17363636363637
+bob johnson 16.431818181818183
+bob polk 16.64090909090909
+bob underhill 15.266363636363637
+bob underhill 18.288181818181815
+bob van buren 18.405454545454543
+calvin ichabod 20.903636363636362
+calvin white 22.44818181818182
+david carson 24.329090909090908
+david falkner 25.01181818181818
+david garcia 22.984545454545454
+david hernandez 22.922727272727272
+ethan steinbeck 24.026363636363637
+ethan underhill 25.189090909090908
+fred ellison 27.16
+gabriella brown 25.664545454545454
+holly nixon 25.705454545454543
+holly polk 24.118181818181824
+holly steinbeck 24.490909090909096
+holly thompson 23.376363636363635
+holly underhill 19.453636363636363
+irene ellison 20.37818181818182
+irene underhill 23.51
+irene young 25.371818181818185
+jessica johnson 24.426363636363636
+jessica king 26.38
+jessica miller 23.99545454545455
+jessica white 26.86636363636364
+katie ichabod 28.520909090909093
+luke garcia 26.110909090909093
+luke ichabod 27.41909090909091
+luke king 28.713636363636365
+luke young 30.591818181818187
+mike allen 27.91545454545455
+mike king 25.526363636363637
+mike polk 24.774545454545454
+mike white 25.183636363636364
+mike xylophone 27.508181818181814
+nick nixon 26.225454545454543
+nick robinson 24.344545454545457
+oscar davidson 26.719090909090912
+oscar garcia 27.19636363636364
+oscar johnson 27.082727272727276
+oscar johnson 25.16454545454545
+oscar miller 28.05909090909091
+priscilla laertes 31.737272727272725
+priscilla quirinius 30.353636363636358
+priscilla zipper 27.96181818181818
+quinn ellison 29.406363636363633
+quinn polk 27.267272727272726
+rachel davidson 25.41545454545454
+rachel thompson 23.608181818181823
+sarah miller 21.499090909090913
+sarah robinson 23.40454545454546
+sarah xylophone 26.95727272727273
+sarah zipper 24.83545454545455
+tom hernandez 21.274545454545457
+tom hernandez 20.315454545454546
+tom polk 21.901818181818182
+tom steinbeck 20.772727272727273
+ulysses carson 21.64727272727273
+ulysses ellison 22.960909090909094
+ulysses quirinius 23.025454545454547
+ulysses robinson 23.762727272727275
+ulysses steinbeck 21.08909090909091
+victor allen 16.62818181818182
+victor hernandez 15.74909090909091
+victor robinson 18.19363636363636
+victor thompson 20.811818181818186
+victor xylophone 20.37272727272727
+wendy quirinius 20.816363636363636
+wendy robinson 19.936363636363634
+wendy xylophone 20.270909090909093
+xavier garcia 19.874000000000002
+xavier ovid 19.976666666666667
+yuri xylophone 21.896250000000002
+zach thompson 25.021428571428572
+zach young 27.776666666666667
+alice carson 18.785
+alice nixon 17.58142857142857
+alice underhill 17.072499999999998
+alice underhill 19.146666666666665
+alice xylophone 20.556
+bob falkner 19.116363636363637
+bob king 21.04
+bob ovid 20.85454545454546
+bob van buren 21.988181818181822
+bob xylophone 24.36454545454546
+calvin xylophone 26.912727272727274
+david falkner 27.310000000000002
+david laertes 28.004545454545454
+david miller 28.400909090909092
+PREHOOK: query: select s, sum(i) over(partition by ts order by s) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select s, sum(i) over() from over10k limit 100
+POSTHOOK: query: select s, sum(i) over(partition by ts order by s) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-bob davidson 656584379
-alice zipper 656584379
-katie davidson 656584379
-xavier quirinius 656584379
-nick robinson 656584379
-tom hernandez 656584379
-ulysses hernandez 656584379
-priscilla ichabod 656584379
-quinn van buren 656584379
-luke laertes 656584379
-xavier polk 656584379
-zach falkner 656584379
-quinn davidson 656584379
-priscilla van buren 656584379
-fred king 656584379
-calvin ellison 656584379
-sarah garcia 656584379
-zach young 656584379
-david underhill 656584379
-yuri carson 656584379
-ulysses laertes 656584379
-jessica thompson 656584379
-sarah johnson 656584379
-zach ovid 656584379
-victor nixon 656584379
-sarah ellison 656584379
-xavier davidson 656584379
-fred steinbeck 656584379
-tom robinson 656584379
-victor allen 656584379
-luke allen 656584379
-fred zipper 656584379
-alice nixon 656584379
-irene van buren 656584379
-alice laertes 656584379
-quinn davidson 656584379
-rachel ellison 656584379
-tom van buren 656584379
-luke zipper 656584379
-mike carson 656584379
-jessica ellison 656584379
-bob brown 656584379
-zach thompson 656584379
-holly ichabod 656584379
-david polk 656584379
-holly falkner 656584379
-wendy van buren 656584379
-tom falkner 656584379
-xavier thompson 656584379
-fred johnson 656584379
-victor steinbeck 656584379
-irene thompson 656584379
-calvin brown 656584379
-irene underhill 656584379
-calvin davidson 656584379
-luke xylophone 656584379
-fred ichabod 656584379
-victor davidson 656584379
-bob xylophone 656584379
-oscar white 656584379
-irene laertes 656584379
-tom polk 656584379
-calvin garcia 656584379
-mike king 656584379
-ulysses underhill 656584379
-katie hernandez 656584379
-katie miller 656584379
-luke allen 656584379
-nick laertes 656584379
-holly underhill 656584379
-irene falkner 656584379
-oscar quirinius 656584379
-nick allen 656584379
-xavier ichabod 656584379
-zach xylophone 656584379
-jessica zipper 656584379
-alice allen 656584379
-jessica johnson 656584379
-fred steinbeck 656584379
-wendy ovid 656584379
-wendy king 656584379
-holly hernandez 656584379
-mike white 656584379
-priscilla johnson 656584379
-gabriella ovid 656584379
-victor xylophone 656584379
-alice laertes 656584379
-ulysses xylophone 656584379
-yuri nixon 656584379
-xavier johnson 656584379
-fred miller 656584379
-luke garcia 656584379
-oscar ovid 656584379
-calvin falkner 656584379
-luke ellison 656584379
-rachel allen 656584379
-oscar king 656584379
-calvin hernandez 656584379
-nick ichabod 656584379
-bob ovid 656584379
-PREHOOK: query: select f, sum(f) over (order by f range between unbounded preceding and current row) from over10k limit 100
+bob ovid 65748
+calvin brown 131440
+calvin laertes 197097
+calvin steinbeck 262874
+david falkner 328506
+fred nixon 394118
+fred zipper 459719
+gabriella van buren 525334
+gabriella xylophone 591058
+jessica laertes 656771
+jessica polk 722558
+katie king 788310
+katie white 853920
+luke zipper 919543
+mike laertes 985277
+nick carson 1050928
+oscar brown 1116474
+priscilla zipper 1182084
+rachel garcia 1247836
+rachel thompson 1313378
+sarah falkner 1379093
+tom johnson 1444791
+victor ellison 1510421
+victor van buren 1576006
+wendy steinbeck 1641591
+yuri allen 1707256
+alice miller 65581
+bob falkner 131319
+bob king 197015
+calvin carson 262712
+calvin nixon 328407
+calvin white 393960
+ethan ovid 459504
+ethan young 525178
+fred king 590838
+fred polk 656600
+gabriella johnson 722283
+gabriella steinbeck 787886
+gabriella underhill 853497
+holly falkner 919218
+holly thompson 985000
+irene brown 1050757
+jessica brown 1182155
+jessica brown 1182155
+jessica nixon 1247815
+jessica robinson 1313437
+katie davidson 1379172
+katie xylophone 1444746
+katie zipper 1510302
+luke king 1576084
+luke steinbeck 1641724
+luke thompson 1707324
+luke xylophone 1773102
+nick ellison 1838744
+oscar davidson 1904390
+oscar van buren 1969971
+priscilla brown 2035582
+priscilla hernandez 2101353
+priscilla zipper 2166925
+quinn allen 2232487
+quinn ovid 2298060
+rachel ovid 2429366
+rachel ovid 2429366
+rachel robinson 2495140
+rachel young 2560880
+sarah van buren 2626599
+ulysses johnson 2692259
+ulysses xylophone 2757830
+victor underhill 2823401
+wendy johnson 2889058
+wendy thompson 2954831
+xavier davidson 3020367
+xavier johnson 3086050
+yuri brown 3151628
+yuri hernandez 3217338
+zach young 3283046
+alice underhill 65705
+bob carson 131461
+calvin white 197044
+ethan ichabod 262796
+ethan nixon 328501
+holly allen 394248
+holly nixon 459928
+jessica johnson 525664
+jessica ovid 591415
+jessica thompson 657122
+nick king 722691
+oscar carson 788459
+priscilla garcia 854222
+priscilla hernandez 919979
+priscilla polk 985680
+priscilla thompson 1051347
+quinn van buren 1117102
+rachel davidson 1182710
+rachel ellison 1248448
+rachel ichabod 1379923
+rachel ichabod 1379923
+rachel polk 1445518
+sarah falkner 1511234
+tom hernandez 1576947
+PREHOOK: query: select f, sum(f) over (partition by ts order by f range between unbounded preceding and current row) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select f, sum(f) over (order by f range between unbounded preceding and current row) from over10k limit 100
+POSTHOOK: query: select f, sum(f) over (partition by ts order by f range between unbounded preceding and current row) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-0.01 0.019999999552965164
-0.01 0.019999999552965164
-0.02 0.07999999821186066
-0.02 0.07999999821186066
-0.02 0.07999999821186066
-0.03 0.13999999687075615
-0.03 0.13999999687075615
-0.04 0.17999999597668648
-0.05 0.22999999672174454
-0.07 0.369999997317791
-0.07 0.369999997317791
-0.08 0.609999991953373
-0.08 0.609999991953373
-0.08 0.609999991953373
-0.09 0.7899999991059303
-0.09 0.7899999991059303
-0.1 0.8900000005960464
-0.11 1.0
-0.12 1.239999994635582
-0.12 1.239999994635582
-0.13 1.3699999898672104
-0.14 1.6499999910593033
-0.14 1.6499999910593033
-0.15 1.9500000029802322
-0.15 1.9500000029802322
-0.16 2.269999995827675
-0.16 2.269999995827675
-0.17 2.439999997615814
-0.18 2.6200000047683716
-0.19 2.810000002384186
-0.2 3.2100000083446503
-0.2 3.2100000083446503
-0.23 3.9000000208616257
-0.23 3.9000000208616257
-0.23 3.9000000208616257
-0.27 4.710000053048134
-0.27 4.710000053048134
-0.27 4.710000053048134
-0.28 5.27000005543232
-0.28 5.27000005543232
-0.29 5.560000047087669
-0.31 5.870000049471855
-0.32 6.190000042319298
-0.35 6.540000036358833
-0.36 7.260000064969063
-0.36 7.260000064969063
-0.37 7.630000069737434
-0.39 8.410000041127205
-0.39 8.410000041127205
-0.42 8.830000028014183
-0.43 10.120000049471855
-0.43 10.120000049471855
-0.43 10.120000049471855
-0.44 11.000000044703484
-0.44 11.000000044703484
-0.48 11.480000033974648
-0.5 12.480000033974648
-0.5 12.480000033974648
-0.51 12.990000024437904
-0.52 14.549999967217445
-0.52 14.549999967217445
-0.52 14.549999967217445
-0.53 15.079999938607216
-0.54 15.619999960064888
-0.55 16.169999971985817
-0.56 16.729999974370003
-0.57 17.299999967217445
-0.58 17.879999950528145
-0.59 18.4699999243021
-0.6 19.06999994814396
-0.61 19.679999962449074
-0.62 21.53999997675419
-0.62 21.53999997675419
-0.62 21.53999997675419
-0.67 22.20999999344349
-0.68 23.570000007748604
-0.68 23.570000007748604
-0.69 24.950000002980232
-0.69 24.950000002980232
-0.71 25.65999998152256
-0.75 26.40999998152256
-0.76 27.169999971985817
-0.77 27.93999995291233
-0.78 28.7199999243021
-0.79 31.089999988675117
-0.79 31.089999988675117
-0.79 31.089999988675117
-0.8 31.890000000596046
-0.82 32.70999999344349
-0.83 33.53999997675419
-0.84 35.2199999243021
-0.84 35.2199999243021
-0.85 36.06999994814396
-0.87 36.93999995291233
-0.88 37.81999994814396
-0.89 38.709999933838844
-0.9 39.609999909996986
-0.91 40.51999993622303
-0.92 41.43999995291233
-0.93 42.36999996006489
+3.17 3.1700000762939453
+10.89 14.0600004196167
+14.54 28.600000381469727
+14.78 43.38000011444092
+17.85 61.230000495910645
+20.61 81.8400011062622
+28.69 110.53000164031982
+29.22 139.75000095367432
+31.17 170.92000102996826
+38.35 209.26999950408936
+38.61 247.88000011444092
+39.48 287.35999965667725
+40.54 327.9000005722046
+41.6 369.4999990463257
+46.08 415.58000087738037
+54.36 469.94000148773193
+56.94 526.8800001144409
+64.96 591.8399991989136
+73.52 665.35999584198
+78.58 743.9399976730347
+81.41 825.350001335144
+84.71 910.0600004196167
+87.43 997.4900007247925
+91.36 1088.850001335144
+92.96 1181.8100004196167
+95.04 1276.850001335144
+0.83 0.8299999833106995
+1.99 2.8199999928474426
+3.73 6.550000011920929
+8.86 15.409999668598175
+10.62 26.029999554157257
+11.32 37.349999248981476
+12.83 50.17999917268753
+14.7 64.87999898195267
+14.96 79.83999902009964
+17.58 97.4199989438057
+19.1 116.51999932527542
+21.01 137.52999955415726
+26.95 164.4800003170967
+27.23 191.70999985933304
+29.07 220.77999955415726
+29.71 250.4899986386299
+31.84 282.3299987912178
+31.94 314.2699993252754
+35.32 349.58999902009964
+37.32 386.90999871492386
+38.5 425.40999871492386
+42.08 467.49000054597855
+44.3 511.7899997830391
+44.66 556.4499996304512
+46.84 603.2899997830391
+48.89 652.1799991726875
+49.64 701.819998562336
+50.28 752.0999973416328
+52.09 804.1899974942207
+53.26 857.4499958157539
+54.09 911.5399959683418
+56.45 967.9899967312813
+56.76 1024.7499950528145
+61.41 1086.1599949002266
+61.88 1148.0399959683418
+63.03 1211.0699947476387
+64.55 1275.6199977993965
+68.62 1344.2400005459785
+76.13 1420.3699977993965
+79.05 1499.4200008511543
+80.43 1579.85000115633
+81.41 1661.2600048184395
+82.85 1744.1100032925606
+83.98 1828.0900066494942
+84.21 1912.3000057339668
+85.55 1997.8500087857246
+87.93 2085.7800090909004
+88.93 2174.710009396076
+94.27 2268.9800060391426
+99.45 2368.430002987385
+0.36 0.36000001430511475
+0.48 0.8400000035762787
+0.79 1.6300000250339508
+1.27 2.9000000059604645
+4.48 7.380000025033951
+9.0 16.38000002503395
+23.27 39.65000048279762
+25.13 64.77999964356422
+25.34 90.11999979615211
+25.91 116.02999964356422
+29.01 145.03999987244606
+30.47 175.50999918580055
+37.95 213.45999994874
+39.3 252.75999918580055
+45.91 298.66999903321266
+52.44 351.10999765992165
+54.1 405.20999613404274
+56.7 461.9099968969822
+58.77 520.6799973547459
+62.09 582.7699975073338
+68.2 650.9699944555759
+71.68 722.6499947607517
+79.46 802.1099938452244
+80.02 882.1299904882908
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/groupby2.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/groupby2.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/groupby2.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/groupby2.q.xml Fri Apr 26 04:59:50 2013
@@ -693,6 +693,9 @@
</void>
</object>
</void>
+ <void property="distinct">
+ <boolean>true</boolean>
+ </void>
<void property="groupByMemoryUsage">
<float>0.5</float>
</void>
@@ -1711,6 +1714,9 @@
</void>
</object>
</void>
+ <void property="distinct">
+ <boolean>true</boolean>
+ </void>
<void property="groupByMemoryUsage">
<float>0.5</float>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/groupby3.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/groupby3.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/groupby3.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/groupby3.q.xml Fri Apr 26 04:59:50 2013
@@ -888,6 +888,9 @@
</void>
</object>
</void>
+ <void property="distinct">
+ <boolean>true</boolean>
+ </void>
<void property="groupByMemoryUsage">
<float>0.5</float>
</void>
@@ -2034,6 +2037,9 @@
</void>
</object>
</void>
+ <void property="distinct">
+ <boolean>true</boolean>
+ </void>
<void property="groupByMemoryUsage">
<float>0.5</float>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join1.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join1.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join1.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join1.q.xml Fri Apr 26 04:59:50 2013
@@ -619,6 +619,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>src2</string>
+ </void>
<void property="operatorId">
<string>RS_3</string>
</void>
@@ -918,6 +921,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>src1</string>
+ </void>
<void property="operatorId">
<string>RS_2</string>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join2.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join2.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join2.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join2.q.xml Fri Apr 26 04:59:50 2013
@@ -793,6 +793,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>src3</string>
+ </void>
<void property="operatorId">
<string>RS_7</string>
</void>
@@ -2160,6 +2163,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>src2</string>
+ </void>
<void property="operatorId">
<string>RS_4</string>
</void>
@@ -2452,6 +2458,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>src1</string>
+ </void>
<void property="operatorId">
<string>RS_3</string>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join3.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join3.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join3.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join3.q.xml Fri Apr 26 04:59:50 2013
@@ -744,6 +744,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>src2</string>
+ </void>
<void property="operatorId">
<string>RS_4</string>
</void>
@@ -1029,6 +1032,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>src3</string>
+ </void>
<void property="operatorId">
<string>RS_5</string>
</void>
@@ -1324,6 +1330,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>src1</string>
+ </void>
<void property="operatorId">
<string>RS_3</string>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join4.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join4.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join4.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join4.q.xml Fri Apr 26 04:59:50 2013
@@ -482,6 +482,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>a</string>
+ </void>
<void property="operatorId">
<string>RS_6</string>
</void>
@@ -1074,6 +1077,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>b</string>
+ </void>
<void property="operatorId">
<string>RS_7</string>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join5.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join5.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join5.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join5.q.xml Fri Apr 26 04:59:50 2013
@@ -482,6 +482,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>a</string>
+ </void>
<void property="operatorId">
<string>RS_6</string>
</void>
@@ -1074,6 +1077,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>b</string>
+ </void>
<void property="operatorId">
<string>RS_7</string>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join6.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join6.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join6.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join6.q.xml Fri Apr 26 04:59:50 2013
@@ -482,6 +482,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>a</string>
+ </void>
<void property="operatorId">
<string>RS_6</string>
</void>
@@ -1074,6 +1077,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>b</string>
+ </void>
<void property="operatorId">
<string>RS_7</string>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join7.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join7.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join7.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join7.q.xml Fri Apr 26 04:59:50 2013
@@ -630,6 +630,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>a</string>
+ </void>
<void property="operatorId">
<string>RS_9</string>
</void>
@@ -1222,6 +1225,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>b</string>
+ </void>
<void property="operatorId">
<string>RS_10</string>
</void>
@@ -1802,6 +1808,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>c</string>
+ </void>
<void property="operatorId">
<string>RS_11</string>
</void>
Modified: hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join8.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join8.q.xml?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join8.q.xml (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/compiler/plan/join8.q.xml Fri Apr 26 04:59:50 2013
@@ -482,6 +482,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>a</string>
+ </void>
<void property="operatorId">
<string>RS_6</string>
</void>
@@ -1115,6 +1118,9 @@
</void>
</object>
</void>
+ <void property="inputAlias">
+ <string>b</string>
+ </void>
<void property="operatorId">
<string>RS_7</string>
</void>
Modified: hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/InnerStruct.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/InnerStruct.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/InnerStruct.java (original)
+++ hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/InnerStruct.java Fri Apr 26 04:59:50 2013
@@ -6,6 +6,7 @@
*/
package org.apache.hadoop.hive.serde.test;
+import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.thrift.scheme.IScheme;
import org.apache.thrift.scheme.SchemeFactory;
import org.apache.thrift.scheme.StandardScheme;
@@ -226,7 +227,14 @@ public class InnerStruct implements org.
@Override
public int hashCode() {
- return 0;
+ HashCodeBuilder builder = new HashCodeBuilder();
+
+ boolean present_field0 = true;
+ builder.append(present_field0);
+ if (present_field0)
+ builder.append(field0);
+
+ return builder.toHashCode();
}
public int compareTo(InnerStruct other) {
Modified: hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/ThriftTestObj.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/ThriftTestObj.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/ThriftTestObj.java (original)
+++ hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/ThriftTestObj.java Fri Apr 26 04:59:50 2013
@@ -6,6 +6,7 @@
*/
package org.apache.hadoop.hive.serde.test;
+import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.thrift.scheme.IScheme;
import org.apache.thrift.scheme.SchemeFactory;
import org.apache.thrift.scheme.StandardScheme;
@@ -362,7 +363,24 @@ public class ThriftTestObj implements or
@Override
public int hashCode() {
- return 0;
+ HashCodeBuilder builder = new HashCodeBuilder();
+
+ boolean present_field1 = true;
+ builder.append(present_field1);
+ if (present_field1)
+ builder.append(field1);
+
+ boolean present_field2 = true && (isSetField2());
+ builder.append(present_field2);
+ if (present_field2)
+ builder.append(field2);
+
+ boolean present_field3 = true && (isSetField3());
+ builder.append(present_field3);
+ if (present_field3)
+ builder.append(field3);
+
+ return builder.toHashCode();
}
public int compareTo(ThriftTestObj other) {
Modified: hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java (original)
+++ hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java Fri Apr 26 04:59:50 2013
@@ -6,6 +6,7 @@
*/
package org.apache.hadoop.hive.serde2.thrift.test;
+import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.thrift.scheme.IScheme;
import org.apache.thrift.scheme.SchemeFactory;
import org.apache.thrift.scheme.StandardScheme;
@@ -601,7 +602,39 @@ public class Complex implements org.apac
@Override
public int hashCode() {
- return 0;
+ HashCodeBuilder builder = new HashCodeBuilder();
+
+ boolean present_aint = true;
+ builder.append(present_aint);
+ if (present_aint)
+ builder.append(aint);
+
+ boolean present_aString = true && (isSetAString());
+ builder.append(present_aString);
+ if (present_aString)
+ builder.append(aString);
+
+ boolean present_lint = true && (isSetLint());
+ builder.append(present_lint);
+ if (present_lint)
+ builder.append(lint);
+
+ boolean present_lString = true && (isSetLString());
+ builder.append(present_lString);
+ if (present_lString)
+ builder.append(lString);
+
+ boolean present_lintString = true && (isSetLintString());
+ builder.append(present_lintString);
+ if (present_lintString)
+ builder.append(lintString);
+
+ boolean present_mStringString = true && (isSetMStringString());
+ builder.append(present_mStringString);
+ if (present_mStringString)
+ builder.append(mStringString);
+
+ return builder.toHashCode();
}
public int compareTo(Complex other) {
@@ -859,7 +892,7 @@ public class Complex implements org.apac
for (int _i10 = 0; _i10 < _map9.size; ++_i10)
{
String _key11; // required
- String _val12; // optional
+ String _val12; // required
_key11 = iprot.readString();
_val12 = iprot.readString();
struct.mStringString.put(_key11, _val12);
@@ -1082,7 +1115,7 @@ public class Complex implements org.apac
for (int _i31 = 0; _i31 < _map30.size; ++_i31)
{
String _key32; // required
- String _val33; // optional
+ String _val33; // required
_key32 = iprot.readString();
_val33 = iprot.readString();
struct.mStringString.put(_key32, _val33);
Modified: hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/IntString.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/IntString.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/IntString.java (original)
+++ hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/IntString.java Fri Apr 26 04:59:50 2013
@@ -6,6 +6,7 @@
*/
package org.apache.hadoop.hive.serde2.thrift.test;
+import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.thrift.scheme.IScheme;
import org.apache.thrift.scheme.SchemeFactory;
import org.apache.thrift.scheme.StandardScheme;
@@ -342,7 +343,24 @@ public class IntString implements org.ap
@Override
public int hashCode() {
- return 0;
+ HashCodeBuilder builder = new HashCodeBuilder();
+
+ boolean present_myint = true;
+ builder.append(present_myint);
+ if (present_myint)
+ builder.append(myint);
+
+ boolean present_myString = true && (isSetMyString());
+ builder.append(present_myString);
+ if (present_myString)
+ builder.append(myString);
+
+ boolean present_underscore_int = true;
+ builder.append(present_underscore_int);
+ if (present_underscore_int)
+ builder.append(underscore_int);
+
+ return builder.toHashCode();
}
public int compareTo(IntString other) {
Modified: hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java (original)
+++ hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java Fri Apr 26 04:59:50 2013
@@ -6,6 +6,7 @@
*/
package org.apache.hadoop.hive.serde2.thrift.test;
+import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.thrift.scheme.IScheme;
import org.apache.thrift.scheme.SchemeFactory;
import org.apache.thrift.scheme.StandardScheme;
@@ -1566,7 +1567,109 @@ public class MegaStruct implements org.a
@Override
public int hashCode() {
- return 0;
+ HashCodeBuilder builder = new HashCodeBuilder();
+
+ boolean present_my_bool = true && (isSetMy_bool());
+ builder.append(present_my_bool);
+ if (present_my_bool)
+ builder.append(my_bool);
+
+ boolean present_my_byte = true && (isSetMy_byte());
+ builder.append(present_my_byte);
+ if (present_my_byte)
+ builder.append(my_byte);
+
+ boolean present_my_16bit_int = true && (isSetMy_16bit_int());
+ builder.append(present_my_16bit_int);
+ if (present_my_16bit_int)
+ builder.append(my_16bit_int);
+
+ boolean present_my_32bit_int = true && (isSetMy_32bit_int());
+ builder.append(present_my_32bit_int);
+ if (present_my_32bit_int)
+ builder.append(my_32bit_int);
+
+ boolean present_my_64bit_int = true && (isSetMy_64bit_int());
+ builder.append(present_my_64bit_int);
+ if (present_my_64bit_int)
+ builder.append(my_64bit_int);
+
+ boolean present_my_double = true && (isSetMy_double());
+ builder.append(present_my_double);
+ if (present_my_double)
+ builder.append(my_double);
+
+ boolean present_my_string = true && (isSetMy_string());
+ builder.append(present_my_string);
+ if (present_my_string)
+ builder.append(my_string);
+
+ boolean present_my_binary = true && (isSetMy_binary());
+ builder.append(present_my_binary);
+ if (present_my_binary)
+ builder.append(my_binary);
+
+ boolean present_my_string_string_map = true && (isSetMy_string_string_map());
+ builder.append(present_my_string_string_map);
+ if (present_my_string_string_map)
+ builder.append(my_string_string_map);
+
+ boolean present_my_string_enum_map = true && (isSetMy_string_enum_map());
+ builder.append(present_my_string_enum_map);
+ if (present_my_string_enum_map)
+ builder.append(my_string_enum_map);
+
+ boolean present_my_enum_string_map = true && (isSetMy_enum_string_map());
+ builder.append(present_my_enum_string_map);
+ if (present_my_enum_string_map)
+ builder.append(my_enum_string_map);
+
+ boolean present_my_enum_struct_map = true && (isSetMy_enum_struct_map());
+ builder.append(present_my_enum_struct_map);
+ if (present_my_enum_struct_map)
+ builder.append(my_enum_struct_map);
+
+ boolean present_my_enum_stringlist_map = true && (isSetMy_enum_stringlist_map());
+ builder.append(present_my_enum_stringlist_map);
+ if (present_my_enum_stringlist_map)
+ builder.append(my_enum_stringlist_map);
+
+ boolean present_my_enum_structlist_map = true && (isSetMy_enum_structlist_map());
+ builder.append(present_my_enum_structlist_map);
+ if (present_my_enum_structlist_map)
+ builder.append(my_enum_structlist_map);
+
+ boolean present_my_stringlist = true && (isSetMy_stringlist());
+ builder.append(present_my_stringlist);
+ if (present_my_stringlist)
+ builder.append(my_stringlist);
+
+ boolean present_my_structlist = true && (isSetMy_structlist());
+ builder.append(present_my_structlist);
+ if (present_my_structlist)
+ builder.append(my_structlist);
+
+ boolean present_my_enumlist = true && (isSetMy_enumlist());
+ builder.append(present_my_enumlist);
+ if (present_my_enumlist)
+ builder.append(my_enumlist);
+
+ boolean present_my_stringset = true && (isSetMy_stringset());
+ builder.append(present_my_stringset);
+ if (present_my_stringset)
+ builder.append(my_stringset);
+
+ boolean present_my_enumset = true && (isSetMy_enumset());
+ builder.append(present_my_enumset);
+ if (present_my_enumset)
+ builder.append(my_enumset);
+
+ boolean present_my_structset = true && (isSetMy_structset());
+ builder.append(present_my_structset);
+ if (present_my_structset)
+ builder.append(my_structset);
+
+ return builder.toHashCode();
}
public int compareTo(MegaStruct other) {
@@ -2089,7 +2192,7 @@ public class MegaStruct implements org.a
for (int _i1 = 0; _i1 < _map0.size; ++_i1)
{
String _key2; // required
- String _val3; // optional
+ String _val3; // required
_key2 = iprot.readString();
_val3 = iprot.readString();
struct.my_string_string_map.put(_key2, _val3);
@@ -2109,7 +2212,7 @@ public class MegaStruct implements org.a
for (int _i5 = 0; _i5 < _map4.size; ++_i5)
{
String _key6; // required
- MyEnum _val7; // optional
+ MyEnum _val7; // required
_key6 = iprot.readString();
_val7 = MyEnum.findByValue(iprot.readI32());
struct.my_string_enum_map.put(_key6, _val7);
@@ -2129,7 +2232,7 @@ public class MegaStruct implements org.a
for (int _i9 = 0; _i9 < _map8.size; ++_i9)
{
MyEnum _key10; // required
- String _val11; // optional
+ String _val11; // required
_key10 = MyEnum.findByValue(iprot.readI32());
_val11 = iprot.readString();
struct.my_enum_string_map.put(_key10, _val11);
@@ -2149,7 +2252,7 @@ public class MegaStruct implements org.a
for (int _i13 = 0; _i13 < _map12.size; ++_i13)
{
MyEnum _key14; // required
- MiniStruct _val15; // optional
+ MiniStruct _val15; // required
_key14 = MyEnum.findByValue(iprot.readI32());
_val15 = new MiniStruct();
_val15.read(iprot);
@@ -2170,7 +2273,7 @@ public class MegaStruct implements org.a
for (int _i17 = 0; _i17 < _map16.size; ++_i17)
{
MyEnum _key18; // required
- List<String> _val19; // optional
+ List<String> _val19; // required
_key18 = MyEnum.findByValue(iprot.readI32());
{
org.apache.thrift.protocol.TList _list20 = iprot.readListBegin();
@@ -2200,7 +2303,7 @@ public class MegaStruct implements org.a
for (int _i24 = 0; _i24 < _map23.size; ++_i24)
{
MyEnum _key25; // required
- List<MiniStruct> _val26; // optional
+ List<MiniStruct> _val26; // required
_key25 = MyEnum.findByValue(iprot.readI32());
{
org.apache.thrift.protocol.TList _list27 = iprot.readListBegin();
@@ -2852,7 +2955,7 @@ public class MegaStruct implements org.a
for (int _i77 = 0; _i77 < _map76.size; ++_i77)
{
String _key78; // required
- String _val79; // optional
+ String _val79; // required
_key78 = iprot.readString();
_val79 = iprot.readString();
struct.my_string_string_map.put(_key78, _val79);
@@ -2867,7 +2970,7 @@ public class MegaStruct implements org.a
for (int _i81 = 0; _i81 < _map80.size; ++_i81)
{
String _key82; // required
- MyEnum _val83; // optional
+ MyEnum _val83; // required
_key82 = iprot.readString();
_val83 = MyEnum.findByValue(iprot.readI32());
struct.my_string_enum_map.put(_key82, _val83);
@@ -2882,7 +2985,7 @@ public class MegaStruct implements org.a
for (int _i85 = 0; _i85 < _map84.size; ++_i85)
{
MyEnum _key86; // required
- String _val87; // optional
+ String _val87; // required
_key86 = MyEnum.findByValue(iprot.readI32());
_val87 = iprot.readString();
struct.my_enum_string_map.put(_key86, _val87);
@@ -2897,7 +3000,7 @@ public class MegaStruct implements org.a
for (int _i89 = 0; _i89 < _map88.size; ++_i89)
{
MyEnum _key90; // required
- MiniStruct _val91; // optional
+ MiniStruct _val91; // required
_key90 = MyEnum.findByValue(iprot.readI32());
_val91 = new MiniStruct();
_val91.read(iprot);
@@ -2913,7 +3016,7 @@ public class MegaStruct implements org.a
for (int _i93 = 0; _i93 < _map92.size; ++_i93)
{
MyEnum _key94; // required
- List<String> _val95; // optional
+ List<String> _val95; // required
_key94 = MyEnum.findByValue(iprot.readI32());
{
org.apache.thrift.protocol.TList _list96 = new org.apache.thrift.protocol.TList(org.apache.thrift.protocol.TType.STRING, iprot.readI32());
@@ -2937,7 +3040,7 @@ public class MegaStruct implements org.a
for (int _i100 = 0; _i100 < _map99.size; ++_i100)
{
MyEnum _key101; // required
- List<MiniStruct> _val102; // optional
+ List<MiniStruct> _val102; // required
_key101 = MyEnum.findByValue(iprot.readI32());
{
org.apache.thrift.protocol.TList _list103 = new org.apache.thrift.protocol.TList(org.apache.thrift.protocol.TType.STRUCT, iprot.readI32());
Modified: hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MiniStruct.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MiniStruct.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MiniStruct.java (original)
+++ hive/branches/HIVE-4115/serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MiniStruct.java Fri Apr 26 04:59:50 2013
@@ -6,6 +6,7 @@
*/
package org.apache.hadoop.hive.serde2.thrift.test;
+import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.thrift.scheme.IScheme;
import org.apache.thrift.scheme.SchemeFactory;
import org.apache.thrift.scheme.StandardScheme;
@@ -286,7 +287,19 @@ public class MiniStruct implements org.a
@Override
public int hashCode() {
- return 0;
+ HashCodeBuilder builder = new HashCodeBuilder();
+
+ boolean present_my_string = true && (isSetMy_string());
+ builder.append(present_my_string);
+ if (present_my_string)
+ builder.append(my_string);
+
+ boolean present_my_enum = true && (isSetMy_enum());
+ builder.append(present_my_enum);
+ if (present_my_enum)
+ builder.append(my_enum.getValue());
+
+ return builder.toHashCode();
}
public int compareTo(MiniStruct other) {
Modified: hive/branches/HIVE-4115/serde/src/java/org/apache/hadoop/hive/serde2/columnar/BytesRefArrayWritable.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/serde/src/java/org/apache/hadoop/hive/serde2/columnar/BytesRefArrayWritable.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/serde/src/java/org/apache/hadoop/hive/serde2/columnar/BytesRefArrayWritable.java (original)
+++ hive/branches/HIVE-4115/serde/src/java/org/apache/hadoop/hive/serde2/columnar/BytesRefArrayWritable.java Fri Apr 26 04:59:50 2013
@@ -31,7 +31,7 @@ import org.apache.hadoop.io.WritableFact
* <tt>BytesRefArrayWritable</tt> holds an array reference to BytesRefWritable,
* and is able to resize without recreating new array if not necessary.
* <p>
- *
+ *
* Each <tt>BytesRefArrayWritable holds</tt> instance has a <i>valid</i> field,
* which is the desired valid number of <tt>BytesRefWritable</tt> it holds.
* <tt>resetValid</tt> can reset the valid, but it will not care the underlying
@@ -47,7 +47,7 @@ public class BytesRefArrayWritable imple
/**
* Constructs an empty array with the specified capacity.
- *
+ *
* @param capacity
* initial capacity
* @exception IllegalArgumentException
@@ -70,7 +70,7 @@ public class BytesRefArrayWritable imple
/**
* Returns the number of valid elements.
- *
+ *
* @return the number of valid elements
*/
public int size() {
@@ -80,7 +80,7 @@ public class BytesRefArrayWritable imple
/**
* Gets the BytesRefWritable at the specified position. Make sure the position
* is valid by first call resetValid.
- *
+ *
* @param index
* the position index, starting from zero
* @throws IndexOutOfBoundsException
@@ -95,7 +95,7 @@ public class BytesRefArrayWritable imple
/**
* Gets the BytesRefWritable at the specified position without checking.
- *
+ *
* @param index
* the position index, starting from zero
* @throws IndexOutOfBoundsException
@@ -107,7 +107,7 @@ public class BytesRefArrayWritable imple
/**
* Set the BytesRefWritable at the specified position with the specified
* BytesRefWritable.
- *
+ *
* @param index
* index position
* @param bytesRefWritable
@@ -116,9 +116,6 @@ public class BytesRefArrayWritable imple
* if the specified new element is null
*/
public void set(int index, BytesRefWritable bytesRefWritable) {
- if (bytesRefWritable == null) {
- throw new IllegalArgumentException("Can not assign null.");
- }
ensureCapacity(index + 1);
bytesRefWritables[index] = bytesRefWritable;
if (valid <= index) {
@@ -154,7 +151,7 @@ public class BytesRefArrayWritable imple
/**
* Returns <tt>true</tt> if this instance contains one or more the specified
* BytesRefWritable.
- *
+ *
* @param bytesRefWritable
* BytesRefWritable element to be tested
* @return <tt>true</tt> if contains the specified element
@@ -196,7 +193,7 @@ public class BytesRefArrayWritable imple
* elements specified by newValidCapacity argument. It will also narrow the
* valid capacity when needed. Notice: it only enlarge or narrow the valid
* capacity with no care of the already stored invalid BytesRefWritable.
- *
+ *
* @param newValidCapacity
* the desired capacity
*/
Modified: hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/auth/PlainSaslHelper.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/auth/PlainSaslHelper.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/auth/PlainSaslHelper.java (original)
+++ hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/auth/PlainSaslHelper.java Fri Apr 26 04:59:50 2013
@@ -103,7 +103,7 @@ public class PlainSaslHelper {
super(null);
this.service = service;
this.conf = service.getHiveConf();
- this.doAsEnabled = conf.getBoolean("hive.server2.enable.doAs", false);
+ this.doAsEnabled = conf.getBoolVar(HiveConf.ConfVars.HIVE_SERVER2_ENABLE_DOAS);
}
@Override
Modified: hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/cli/CLIService.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/cli/CLIService.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/cli/CLIService.java (original)
+++ hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/cli/CLIService.java Fri Apr 26 04:59:50 2013
@@ -309,7 +309,7 @@ public class CLIService extends Composit
public synchronized String getDelegationTokenFromMetaStore(String owner)
throws HiveSQLException, UnsupportedOperationException, LoginException, IOException {
if (!hiveConf.getBoolVar(HiveConf.ConfVars.METASTORE_USE_THRIFT_SASL) ||
- !hiveConf.getBoolVar(HiveConf.ConfVars.HIVE_SERVER2_KERBEROS_IMPERSONATION)) {
+ !hiveConf.getBoolVar(HiveConf.ConfVars.HIVE_SERVER2_ENABLE_DOAS)) {
throw new UnsupportedOperationException(
"delegation token is can only be obtained for a secure remote metastore");
}
Modified: hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/cli/thrift/ThriftCLIService.java
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/cli/thrift/ThriftCLIService.java?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/cli/thrift/ThriftCLIService.java (original)
+++ hive/branches/HIVE-4115/service/src/java/org/apache/hive/service/cli/thrift/ThriftCLIService.java Fri Apr 26 04:59:50 2013
@@ -18,16 +18,20 @@
package org.apache.hive.service.cli.thrift;
+import java.io.IOException;
import java.net.InetSocketAddress;
import java.util.HashMap;
import java.util.Map;
+import javax.security.auth.login.LoginException;
+
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.hadoop.hive.conf.HiveConf;
import org.apache.hadoop.hive.conf.HiveConf.ConfVars;
import org.apache.hive.service.AbstractService;
import org.apache.hive.service.auth.HiveAuthFactory;
+import org.apache.hive.service.cli.CLIService;
import org.apache.hive.service.cli.FetchOrientation;
import org.apache.hive.service.cli.GetInfoType;
import org.apache.hive.service.cli.GetInfoValue;
@@ -35,7 +39,6 @@ import org.apache.hive.service.cli.HiveS
import org.apache.hive.service.cli.OperationHandle;
import org.apache.hive.service.cli.OperationState;
import org.apache.hive.service.cli.RowSet;
-import org.apache.hive.service.cli.CLIService;
import org.apache.hive.service.cli.SessionHandle;
import org.apache.hive.service.cli.TableSchema;
import org.apache.thrift.TException;
@@ -110,28 +113,7 @@ public class ThriftCLIService extends Ab
public TOpenSessionResp OpenSession(TOpenSessionReq req) throws TException {
TOpenSessionResp resp = new TOpenSessionResp();
try {
- String userName;
- if (hiveAuthFactory != null
- && hiveAuthFactory.getRemoteUser() != null) {
- userName = hiveAuthFactory.getRemoteUser();
- } else {
- userName = req.getUsername();
- }
- SessionHandle sessionHandle = null;
- if (cliService.getHiveConf().
- getBoolVar(HiveConf.ConfVars.HIVE_SERVER2_KERBEROS_IMPERSONATION)) {
- String delegationTokenStr = null;
- try {
- delegationTokenStr = cliService.getDelegationTokenFromMetaStore(userName);
- } catch (UnsupportedOperationException e) {
- // The delegation token is not applicable in the given deployment mode
- }
- sessionHandle = cliService.openSessionWithImpersonation(userName, req.getPassword(),
- req.getConfiguration(), delegationTokenStr);
- } else {
- sessionHandle = cliService.openSession(userName, req.getPassword(),
- req.getConfiguration());
- }
+ SessionHandle sessionHandle = getSessionHandle(req);
resp.setSessionHandle(sessionHandle.toTSessionHandle());
// TODO: set real configuration map
resp.setConfiguration(new HashMap<String, String>());
@@ -143,6 +125,44 @@ public class ThriftCLIService extends Ab
return resp;
}
+ private String getUserName(TOpenSessionReq req) {
+ if (hiveAuthFactory != null
+ && hiveAuthFactory.getRemoteUser() != null) {
+ return hiveAuthFactory.getRemoteUser();
+ } else {
+ return req.getUsername();
+ }
+ }
+
+ SessionHandle getSessionHandle(TOpenSessionReq req)
+ throws HiveSQLException, LoginException, IOException {
+
+ String userName = getUserName(req);
+
+ SessionHandle sessionHandle = null;
+ if (
+ cliService.getHiveConf().getVar(ConfVars.HIVE_SERVER2_AUTHENTICATION)
+ .equals(HiveAuthFactory.AuthTypes.KERBEROS.toString())
+ &&
+ cliService.getHiveConf().
+ getBoolVar(ConfVars.HIVE_SERVER2_ENABLE_DOAS)
+ )
+ {
+ String delegationTokenStr = null;
+ try {
+ delegationTokenStr = cliService.getDelegationTokenFromMetaStore(userName);
+ } catch (UnsupportedOperationException e) {
+ // The delegation token is not applicable in the given deployment mode
+ }
+ sessionHandle = cliService.openSessionWithImpersonation(userName, req.getPassword(),
+ req.getConfiguration(), delegationTokenStr);
+ } else {
+ sessionHandle = cliService.openSession(userName, req.getPassword(),
+ req.getConfiguration());
+ }
+ return sessionHandle;
+ }
+
@Override
public TCloseSessionResp CloseSession(TCloseSessionReq req) throws TException {
TCloseSessionResp resp = new TCloseSessionResp();