You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2014/10/27 19:37:06 UTC
svn commit: r1634636 [5/6] - in /hive/trunk/ql/src/test:
queries/clientpositive/ results/clientpositive/ results/clientpositive/tez/
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_groupby_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_groupby_3.q.out?rev=1634636&r1=1634635&r2=1634636&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_groupby_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_groupby_3.q.out Mon Oct 27 18:37:05 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: create table vectortab2k(
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table vectortab2k(
t tinyint,
si smallint,
i int,
@@ -17,7 +19,9 @@ STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@vectortab2k
-POSTHOOK: query: create table vectortab2k(
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table vectortab2k(
t tinyint,
si smallint,
i int,
@@ -168,45 +172,49 @@ POSTHOOK: query: select s, t, max(b) fro
POSTHOOK: type: QUERY
POSTHOOK: Input: default@vectortab2korc
#### A masked pattern was here ####
- NULL 2714
- -116 8945302550165004288
- -114 1312
- -113 7569249672628789248
- -108 8939431770838810624
- -107 1906
+ -10 8991442360387584000
-104 8268875586442256384
- -91 3965
- -87 7078641038157643776
- -86 2862
- -85 -7139677575412686848
- -84 -7085247548404178944
- -83 8900351886974279680
- -80 -8938849835283677184
- -75 NULL
- -72 9149216169284091904
- -66 3197
- -53 -8619303037130301440
- -46 -9080568167841226752
- -38 2933
- -36 -7512297136103800832
- -33 1075
- -29 8371939471056470016
- -28 -7292078334519894016
- -25 2262
- -24 898
- -19 9094945190752903168
- -16 -7673901622181953536
- -14 7983789401706094592
+ -107 1906
+ -108 8939431770838810624
+ -113 7569249672628789248
+ -114 1312
+ -116 8945302550165004288
-12 -7413317118463164416
- -10 8991442360387584000
- -5 3534
- -4 -9014145341570203648
+ -14 7983789401706094592
+ -16 -7673901622181953536
+ -19 9094945190752903168
-2 8759184090543857664
+ -24 898
+ -25 2262
+ -28 -7292078334519894016
+ -29 8371939471056470016
+ -33 1075
+ -36 -7512297136103800832
+ -38 2933
+ -4 -9014145341570203648
+ -46 -9080568167841226752
+ -5 3534
+ -53 -8619303037130301440
+ -66 3197
+ -72 9149216169284091904
+ -75 NULL
+ -80 -8938849835283677184
+ -83 8900351886974279680
+ -84 -7085247548404178944
+ -85 -7139677575412686848
+ -86 2862
+ -87 7078641038157643776
+ -91 3965
0 8163948965373386752
- 4 7062382339142156288
- 5 -8703026916864802816
- 8 2905
+ 102 -7036607470351654912
+ 103 780
+ 105 -7511952204985049088
+ 109 1436
+ 112 -7063777488249085952
+ 113 8775009214012456960
+ 114 1145
12 2553
+ 123 3625
16 8983857919580209152
19 2201
22 9191943992860327936
@@ -215,9 +223,11 @@ POSTHOOK: Input: default@vectortab2korc
29 8555933456197828608
31 2941
37 8143462899383345152
+ 4 7062382339142156288
42 NULL
46 3174
48 -8566856504746352640
+ 5 -8703026916864802816
54 -7242345057866285056
57 8230371298967609344
59 2494
@@ -225,6 +235,7 @@ POSTHOOK: Input: default@vectortab2korc
62 779
64 7368920486374989824
79 8736061027343859712
+ 8 2905
84 NULL
87 797
88 8782900615468302336
@@ -232,55 +243,52 @@ POSTHOOK: Input: default@vectortab2korc
91 2193
96 -7866079955473989632
97 2017
- 102 -7036607470351654912
- 103 780
- 105 -7511952204985049088
- 109 1436
- 112 -7063777488249085952
- 113 8775009214012456960
- 114 1145
- 123 3625
-american history NULL 3555
-american history -127 1719
-american history -119 19
-american history -116 3812
-american history -112 7731443941834678272
-american history -110 -8989473881707921408
-american history -108 7359004378440146944
-american history -105 7870277756614623232
-american history -103 -6962271229404348416
+ NULL 2714
american history -101 7348598907182800896
-american history -95 NULL
-american history -94 9119046173224370176
-american history -92 -7612455481940246528
-american history -90 1321
-american history -89 -7571293705217687552
-american history -87 -7536330682873937920
-american history -86 -8731068123910987776
-american history -81 2700
-american history -80 485
-american history -73 2487
-american history -66 -8368487814665895936
-american history -60 1566
-american history -59 3949
-american history -55 8407869317250220032
-american history -53 1955
-american history -50 7857878068300898304
-american history -48 -8016589197379289088
-american history -47 -8566940231897874432
-american history -34 4018
-american history -30 -8789178184387641344
-american history -28 -7720966287634112512
-american history -27 NULL
-american history -26 -7057750467944931328
-american history -19 78
-american history -18 -8659643752269242368
-american history -17 2968
-american history -15 9048002942653710336
+american history -103 -6962271229404348416
+american history -105 7870277756614623232
+american history -108 7359004378440146944
american history -11 8714829359200747520
+american history -110 -8989473881707921408
+american history -112 7731443941834678272
+american history -116 3812
+american history -119 19
+american history -127 1719
+american history -15 9048002942653710336
+american history -17 2968
+american history -18 -8659643752269242368
+american history -19 78
+american history -26 -7057750467944931328
+american history -27 NULL
+american history -28 -7720966287634112512
+american history -30 -8789178184387641344
+american history -34 4018
+american history -47 -8566940231897874432
+american history -48 -8016589197379289088
+american history -50 7857878068300898304
+american history -53 1955
+american history -55 8407869317250220032
+american history -59 3949
+american history -60 1566
+american history -66 -8368487814665895936
+american history -73 2487
+american history -80 485
+american history -81 2700
+american history -86 -8731068123910987776
+american history -87 -7536330682873937920
+american history -89 -7571293705217687552
american history -9 -8503342882470019072
+american history -90 1321
+american history -92 -7612455481940246528
+american history -94 9119046173224370176
+american history -95 NULL
american history 0 6928080429732536320
-american history 5 135
+american history 100 8760285623204290560
+american history 103 -7868306678534193152
+american history 111 522
+american history 119 8571268359622172672
+american history 122 7497276415392407552
+american history 123 -7488345684795342848
american history 20 -7037375807670501376
american history 22 8467976965865799680
american history 29 -8243487285852766208
@@ -292,6 +300,7 @@ american history 40 2886
american history 42 8190967051000659968
american history 46 8374321007870836736
american history 48 6962726713896484864
+american history 5 135
american history 54 -7784419454650843136
american history 56 1890
american history 60 3512
@@ -306,135 +315,135 @@ american history 82 3980
american history 84 2105
american history 89 8806507556248731648
american history 96 823
-american history 100 8760285623204290560
-american history 103 -7868306678534193152
-american history 111 522
-american history 119 8571268359622172672
-american history 122 7497276415392407552
-american history 123 -7488345684795342848
-biology NULL 9116137265342169088
-biology -127 1270
-biology -121 8109381965028548608
-biology -120 8388363436324085760
-biology -119 7054938591408996352
-biology -104 -8683802826440105984
+american history NULL 3555
biology -101 -7198372044947275776
-biology -98 -8940944155843461120
-biology -97 -7827420207675105280
-biology -96 NULL
-biology -92 1142
-biology -90 7775034125776363520
-biology -86 3755
-biology -85 -6935548339131138048
-biology -83 7232273749940838400
-biology -82 -7040248820505149440
-biology -81 NULL
-biology -79 3566
-biology -72 -7915999634274369536
-biology -67 8532016240026279936
-biology -66 -7623047151287754752
-biology -59 7534042483076857856
-biology -57 7049773031131283456
-biology -54 -7319315187617587200
-biology -53 -6962292590214234112
-biology -49 NULL
-biology -46 2241
-biology -44 2680
-biology -42 2469
-biology -40 -7469660864676585472
-biology -36 1489
-biology -35 2285
-biology -31 -9032650742739836928
-biology -20 7130159794259353600
-biology -19 -7442593976514420736
-biology -16 3960
+biology -104 -8683802826440105984
+biology -119 7054938591408996352
+biology -120 8388363436324085760
+biology -121 8109381965028548608
+biology -127 1270
biology -13 2463
-biology -7 -8665218198816497664
-biology -6 888
+biology -16 3960
+biology -19 -7442593976514420736
+biology -20 7130159794259353600
+biology -31 -9032650742739836928
+biology -35 2285
+biology -36 1489
+biology -40 -7469660864676585472
+biology -42 2469
+biology -44 2680
+biology -46 2241
+biology -49 NULL
biology -5 808
+biology -53 -6962292590214234112
+biology -54 -7319315187617587200
+biology -57 7049773031131283456
+biology -59 7534042483076857856
+biology -6 888
+biology -66 -7623047151287754752
+biology -67 8532016240026279936
+biology -7 -8665218198816497664
+biology -72 -7915999634274369536
+biology -79 3566
+biology -81 NULL
+biology -82 -7040248820505149440
+biology -83 7232273749940838400
+biology -85 -6935548339131138048
+biology -86 3755
+biology -90 7775034125776363520
+biology -92 1142
+biology -96 NULL
+biology -97 -7827420207675105280
+biology -98 -8940944155843461120
biology 0 523
+biology 100 -8782213262837530624
+biology 111 6933731240564056064
+biology 113 664
+biology 114 1343
+biology 115 -7017212700635545600
+biology 117 120
+biology 12 2492
+biology 120 3443
+biology 124 -6919476845891313664
+biology 18 -7255010240787030016
biology 2 -8387347109404286976
+biology 27 -9049720998034137088
biology 3 -9075486079396069376
-biology 4 482
-biology 5 7376467688511455232
-biology 6 -7797149520019062784
-biology 7 454
-biology 8 950
-biology 12 2492
-biology 18 -7255010240787030016
-biology 27 -9049720998034137088
biology 30 835
biology 34 2517
biology 35 8017403886247927808
biology 36 2539
+biology 4 482
biology 41 7052226236896256000
biology 47 3974
+biology 5 7376467688511455232
biology 51 3728
biology 52 9084402694981533696
biology 54 -7330203470474985472
biology 55 1785
biology 57 9083704659251798016
+biology 6 -7797149520019062784
biology 64 2400
+biology 7 454
+biology 8 950
biology 83 -8172827216441573376
biology 86 3199
biology 89 7747874976739016704
biology 90 -7598782894648565760
biology 91 -8131997716860526592
-biology 100 -8782213262837530624
-biology 111 6933731240564056064
-biology 113 664
-biology 114 1343
-biology 115 -7017212700635545600
-biology 117 120
-biology 120 3443
-biology 124 -6919476845891313664
-chemistry NULL 8854677881758162944
-chemistry -127 -7637755520917741568
-chemistry -125 3418
-chemistry -122 -8232763638546694144
-chemistry -117 8014986215157530624
-chemistry -115 3307
-chemistry -110 3430
-chemistry -109 -7624057992767782912
-chemistry -108 7255302164215013376
-chemistry -103 -8099313480512716800
+biology NULL 9116137265342169088
chemistry -101 2599
-chemistry -98 9005866015985713152
-chemistry -95 -7470307155642245120
-chemistry -91 9030480306789818368
-chemistry -90 1291
-chemistry -89 2968
-chemistry -81 -8664806103426252800
-chemistry -75 375
-chemistry -68 -8813211231120031744
-chemistry -61 -8021859935185928192
-chemistry -59 -7572262898020278272
-chemistry -57 -7362189611124563968
-chemistry -56 -7663293054873812992
-chemistry -52 4056
-chemistry -46 -7610137349734883328
-chemistry -44 7596563216912211968
-chemistry -40 4054
-chemistry -37 NULL
-chemistry -33 7545689659010949120
-chemistry -31 -9080956291212132352
-chemistry -30 2001
-chemistry -26 -9178166810751909888
+chemistry -103 -8099313480512716800
+chemistry -108 7255302164215013376
+chemistry -109 -7624057992767782912
+chemistry -110 3430
+chemistry -115 3307
+chemistry -117 8014986215157530624
+chemistry -122 -8232763638546694144
+chemistry -125 3418
+chemistry -127 -7637755520917741568
+chemistry -2 -7500200359698907136
chemistry -23 -8518060755719585792
-chemistry -8 8487573502287478784
+chemistry -26 -9178166810751909888
chemistry -3 3245
-chemistry -2 -7500200359698907136
-chemistry 3 2933
-chemistry 4 2138
-chemistry 8 873
+chemistry -30 2001
+chemistry -31 -9080956291212132352
+chemistry -33 7545689659010949120
+chemistry -37 NULL
+chemistry -40 4054
+chemistry -44 7596563216912211968
+chemistry -46 -7610137349734883328
+chemistry -52 4056
+chemistry -56 -7663293054873812992
+chemistry -57 -7362189611124563968
+chemistry -59 -7572262898020278272
+chemistry -61 -8021859935185928192
+chemistry -68 -8813211231120031744
+chemistry -75 375
+chemistry -8 8487573502287478784
+chemistry -81 -8664806103426252800
+chemistry -89 2968
+chemistry -90 1291
+chemistry -91 9030480306789818368
+chemistry -95 -7470307155642245120
+chemistry -98 9005866015985713152
+chemistry 102 -7907355742053883904
+chemistry 104 3609
+chemistry 110 NULL
+chemistry 113 7149417430082027520
+chemistry 116 7768984605670604800
+chemistry 124 1914
+chemistry 126 9083076230151864320
chemistry 14 7198687580227043328
chemistry 16 7229607057201127424
chemistry 19 NULL
chemistry 25 236
chemistry 27 1826
+chemistry 3 2933
chemistry 32 1775
chemistry 37 41
chemistry 39 2663
+chemistry 4 2138
chemistry 41 8693036785094565888
chemistry 46 1280
chemistry 51 392
@@ -444,53 +453,48 @@ chemistry 74 837
chemistry 75 3860
chemistry 78 2476
chemistry 79 8644602243484803072
+chemistry 8 873
chemistry 83 1286
chemistry 88 -8082793390939193344
chemistry 90 7794244032613703680
chemistry 91 3866
chemistry 96 -7395343938785738752
-chemistry 102 -7907355742053883904
-chemistry 104 3609
-chemistry 110 NULL
-chemistry 113 7149417430082027520
-chemistry 116 7768984605670604800
-chemistry 124 1914
-chemistry 126 9083076230151864320
-debate NULL 1777
-debate -127 8337549596011102208
-debate -117 -8269917980278980608
-debate -114 2085
-debate -108 2816
+chemistry NULL 8854677881758162944
debate -106 1948
-debate -98 8011602724663336960
-debate -96 8688483860094599168
-debate -95 1368
-debate -88 8345435427356090368
-debate -87 -8028910243475038208
-debate -86 1095
-debate -85 2341
-debate -82 NULL
-debate -72 7720187583697502208
-debate -70 8928133990107881472
-debate -69 7948803266578161664
-debate -67 1521
-debate -57 -8581979259158929408
-debate -52 7947544013461512192
-debate -50 7061498706968428544
-debate -47 49
-debate -46 1234
-debate -41 -8856821118526734336
-debate -35 7062605127422894080
-debate -32 -7831320202242228224
-debate -29 -7476082621253402624
-debate -28 -8379109122834997248
-debate -27 3835
-debate -26 471
-debate -24 8554899472487596032
-debate -15 34
+debate -108 2816
+debate -114 2085
+debate -117 -8269917980278980608
debate -12 7682327310082531328
+debate -127 8337549596011102208
+debate -15 34
+debate -24 8554899472487596032
+debate -26 471
+debate -27 3835
+debate -28 -8379109122834997248
+debate -29 -7476082621253402624
debate -3 8519937082746634240
-debate 5 -8649711322250362880
+debate -32 -7831320202242228224
+debate -35 7062605127422894080
+debate -41 -8856821118526734336
+debate -46 1234
+debate -47 49
+debate -50 7061498706968428544
+debate -52 7947544013461512192
+debate -57 -8581979259158929408
+debate -67 1521
+debate -69 7948803266578161664
+debate -70 8928133990107881472
+debate -72 7720187583697502208
+debate -82 NULL
+debate -85 2341
+debate -86 1095
+debate -87 -8028910243475038208
+debate -88 8345435427356090368
+debate -95 1368
+debate -96 8688483860094599168
+debate -98 8011602724663336960
+debate 113 1995
+debate 124 3691
debate 17 8560526613401714688
debate 19 8501910015960735744
debate 20 -8832750849949892608
@@ -499,6 +503,7 @@ debate 34 3060
debate 36 7792036342592348160
debate 41 7039820685967343616
debate 42 8557218322962644992
+debate 5 -8649711322250362880
debate 52 -7637494527844343808
debate 54 7534145866886782976
debate 56 -7161165959057334272
@@ -516,49 +521,56 @@ debate 89 2089
debate 90 9078604269481148416
debate 93 455
debate 94 -7506254246954500096
-debate 113 1995
-debate 124 3691
-education NULL 2903
-education -127 -8302817097848307712
-education -125 2214
-education -113 -8142667274351345664
-education -111 7296164580491075584
-education -109 8150115791664340992
-education -105 1066
+debate NULL 1777
education -101 7165364563962191872
-education -98 1341
-education -96 -8022573309127000064
-education -93 7343171468838567936
-education -92 2811
-education -89 1999
-education -87 345
-education -86 8473699639908261888
-education -77 9148071980848742400
-education -72 3021
-education -69 2805
-education -64 6974475559697768448
-education -61 7917494645725765632
-education -55 7989119273552158720
-education -52 9050032047355125760
-education -44 -8219876839318716416
-education -43 3911
-education -38 3749
-education -37 923
-education -36 694
-education -34 -7707242953271500800
-education -28 7735566678126616576
-education -24 1509
-education -15 -6960947572095770624
+education -105 1066
+education -109 8150115791664340992
+education -111 7296164580491075584
+education -113 -8142667274351345664
+education -125 2214
+education -127 -8302817097848307712
education -13 695
+education -15 -6960947572095770624
+education -24 1509
+education -28 7735566678126616576
+education -34 -7707242953271500800
+education -36 694
+education -37 923
+education -38 3749
+education -43 3911
+education -44 -8219876839318716416
+education -52 9050032047355125760
+education -55 7989119273552158720
+education -61 7917494645725765632
+education -64 6974475559697768448
+education -69 2805
+education -72 3021
+education -77 9148071980848742400
+education -86 8473699639908261888
+education -87 345
+education -89 1999
education -9 928
-education 4 -8034414142083170304
+education -92 2811
+education -93 7343171468838567936
+education -96 -8022573309127000064
+education -98 1341
+education 102 7375521127126089728
+education 103 7384150968511315968
+education 110 7452756603516190720
+education 111 3824
+education 113 8994608999945125888
+education 114 1846
+education 116 -8930307926221807616
+education 119 7548958830580563968
education 12 8454154705460666368
+education 125 8577096957495025664
education 17 2232
education 27 -8454143651040444416
education 33 -8488247955875618816
education 34 379
education 35 7473537548003352576
education 38 -8244116388227104768
+education 4 -8034414142083170304
education 41 7584007864107778048
education 45 238
education 46 7892281003266408448
@@ -576,50 +588,46 @@ education 82 1058
education 85 7961909238130270208
education 89 3409
education 95 3764
-education 102 7375521127126089728
-education 103 7384150968511315968
-education 110 7452756603516190720
-education 111 3824
-education 113 8994608999945125888
-education 114 1846
-education 116 -8930307926221807616
-education 119 7548958830580563968
-education 125 8577096957495025664
-forestry NULL 9123116008004288512
-forestry -126 9086905513121890304
-forestry -118 8272001752345690112
-forestry -116 7997694023324975104
-forestry -109 275
+education NULL 2903
+forestry -1 -9071565764086521856
+forestry -10 3962
forestry -105 2724
-forestry -98 3089
-forestry -95 2485
-forestry -94 -8051871680800120832
-forestry -83 2752
-forestry -81 -8922409715403112448
-forestry -80 1165
-forestry -79 1937
-forestry -77 1247
-forestry -74 1643
-forestry -73 -7228589258642194432
-forestry -68 -6988970700649168896
-forestry -58 7989160253372817408
-forestry -51 -9002912355472736256
-forestry -50 2283
-forestry -49 417
-forestry -42 268
-forestry -34 2524
-forestry -23 7790728456522784768
-forestry -12 -8205148279289085952
+forestry -109 275
forestry -11 9194388393453060096
-forestry -10 3962
-forestry -8 7955126053367119872
+forestry -116 7997694023324975104
+forestry -118 8272001752345690112
+forestry -12 -8205148279289085952
+forestry -126 9086905513121890304
+forestry -23 7790728456522784768
forestry -3 1165
-forestry -1 -9071565764086521856
+forestry -34 2524
+forestry -42 268
+forestry -49 417
+forestry -50 2283
+forestry -51 -9002912355472736256
+forestry -58 7989160253372817408
+forestry -68 -6988970700649168896
+forestry -73 -7228589258642194432
+forestry -74 1643
+forestry -77 1247
+forestry -79 1937
+forestry -8 7955126053367119872
+forestry -80 1165
+forestry -81 -8922409715403112448
+forestry -83 2752
+forestry -94 -8051871680800120832
+forestry -95 2485
+forestry -98 3089
forestry 0 -7603467428164009984
-forestry 7 3118
-forestry 8 7299197687217856512
+forestry 102 255
+forestry 106 8570983266408103936
+forestry 107 999
forestry 11 3467
+forestry 111 -7138415011665043456
+forestry 115 8573305425181941760
+forestry 117 -7120456708338688000
forestry 12 8160662610166194176
+forestry 120 7784169796350730240
forestry 19 -8760655406971863040
forestry 29 -7831595638727565312
forestry 31 3663
@@ -634,59 +642,57 @@ forestry 51 2580
forestry 52 8514851182589771776
forestry 55 -9091113592821972992
forestry 56 7418271723644403712
+forestry 7 3118
forestry 71 8779711700787298304
forestry 78 -7845896959112658944
forestry 79 -7818454479651135488
+forestry 8 7299197687217856512
forestry 87 1981
forestry 90 8829545979081744384
forestry 93 1422
forestry 94 -8469607298426437632
forestry 97 -8845239510002753536
-forestry 102 255
-forestry 106 8570983266408103936
-forestry 107 999
-forestry 111 -7138415011665043456
-forestry 115 8573305425181941760
-forestry 117 -7120456708338688000
-forestry 120 7784169796350730240
-geology NULL 8171188598958407680
-geology -124 3190
-geology -117 3421
-geology -115 -8660149447361404928
-geology -112 1462
-geology -108 -8604758220106014720
-geology -106 -7661250850555633664
-geology -101 -7078068944081002496
+forestry NULL 9123116008004288512
geology -100 3002
-geology -96 -6957946688477274112
-geology -94 268
-geology -84 -7511202710200885248
-geology -82 8817665768680906752
-geology -80 3446
-geology -79 1614
-geology -75 -7883252982752665600
-geology -72 8391785334471589888
-geology -68 -8203008052020879360
-geology -59 7621013099259527168
-geology -57 -7594824008626372608
-geology -54 -7328087811698909184
-geology -53 -6988811476286873600
-geology -50 8120593157178228736
-geology -48 1342
-geology -35 -7510418793070075904
-geology -34 8708845895460577280
-geology -32 7487538600082554880
-geology -31 871
-geology -30 -8127494999848919040
-geology -23 1537
-geology -21 91
-geology -18 7370803940448305152
+geology -101 -7078068944081002496
+geology -106 -7661250850555633664
+geology -108 -8604758220106014720
+geology -112 1462
+geology -115 -8660149447361404928
+geology -117 3421
+geology -124 3190
geology -16 8979012655944220672
+geology -18 7370803940448305152
+geology -21 91
+geology -23 1537
+geology -30 -8127494999848919040
+geology -31 871
+geology -32 7487538600082554880
+geology -34 8708845895460577280
+geology -35 -7510418793070075904
+geology -48 1342
+geology -50 8120593157178228736
+geology -53 -6988811476286873600
+geology -54 -7328087811698909184
+geology -57 -7594824008626372608
+geology -59 7621013099259527168
+geology -68 -8203008052020879360
+geology -72 8391785334471589888
+geology -75 -7883252982752665600
+geology -79 1614
+geology -80 3446
+geology -82 8817665768680906752
+geology -84 -7511202710200885248
+geology -94 268
+geology -96 -6957946688477274112
geology 1 -8870673219965001728
-geology 4 9020143715350814720
-geology 5 7784489776013295616
-geology 6 3203
-geology 9 -8379964450833367040
+geology 100 7528074274555305984
+geology 101 7701723309715685376
+geology 102 -8297230235506343936
+geology 116 3073
+geology 121 213
+geology 124 7779486624537370624
+geology 127 -7703540456272994304
geology 14 -8136227554401107968
geology 18 3763
geology 21 8850055384477401088
@@ -697,57 +703,60 @@ geology 31 1892
geology 33 7689489436826804224
geology 37 2762
geology 38 -8395998375405912064
+geology 4 9020143715350814720
geology 49 8854715632851345408
+geology 5 7784489776013295616
geology 58 -8856151919723003904
+geology 6 3203
geology 72 2179
geology 82 6967631925774639104
geology 84 8316336224427483136
geology 86 -9101953184875757568
geology 89 1346
+geology 9 -8379964450833367040
geology 92 -7833618000492109824
geology 93 NULL
geology 95 -7838598833900584960
-geology 100 7528074274555305984
-geology 101 7701723309715685376
-geology 102 -8297230235506343936
-geology 116 3073
-geology 121 213
-geology 124 7779486624537370624
-geology 127 -7703540456272994304
-history NULL 3231
-history -125 1856
-history -124 -8318886086186213376
-history -105 3701
-history -104 1769
-history -103 -7623405558242500608
+geology NULL 8171188598958407680
+history -1 -8544299740525461504
history -101 154
-history -98 2046
-history -91 1651
-history -90 65
-history -89 3418
-history -79 1796
-history -75 -8783777723063099392
-history -67 -7679894005808693248
-history -61 8325227661920133120
-history -58 8376440110255243264
-history -54 2393
-history -42 8987827141270880256
-history -37 3946
-history -34 -7192529627893858304
-history -26 NULL
-history -24 3079
-history -19 1791
-history -18 3770
-history -15 2013
+history -103 -7623405558242500608
+history -104 1769
+history -105 3701
history -12 154
-history -8 2187
+history -124 -8318886086186213376
+history -125 1856
+history -15 2013
+history -18 3770
+history -19 1791
+history -24 3079
+history -26 NULL
+history -34 -7192529627893858304
+history -37 3946
+history -42 8987827141270880256
history -5 1667
-history -1 -8544299740525461504
+history -54 2393
+history -58 8376440110255243264
+history -61 8325227661920133120
+history -67 -7679894005808693248
+history -75 -8783777723063099392
+history -79 1796
+history -8 2187
+history -89 3418
+history -90 65
+history -91 1651
+history -98 2046
history 1 8637720762289659904
-history 2 7648729477297987584
-history 7 7647481735646363648
+history 100 263
+history 108 -7800879252150779904
+history 112 -7419068456205385728
+history 113 3728
+history 114 289
+history 126 2810
+history 127 -7884460946615984128
history 14 6947488599548215296
history 18 -7778829032042790912
+history 2 7648729477297987584
history 25 3866
history 50 3874
history 51 8135164922674872320
@@ -757,6 +766,7 @@ history 58 3664
history 59 7514552840617558016
history 61 -8411282676082565120
history 62 3024
+history 7 7647481735646363648
history 71 -8730803262481580032
history 72 7099005292698550272
history 73 2776
@@ -766,45 +776,43 @@ history 84 -7162299524557471744
history 92 921
history 95 3769
history 98 3588
-history 100 263
-history 108 -7800879252150779904
-history 112 -7419068456205385728
-history 113 3728
-history 114 289
-history 126 2810
-history 127 -7884460946615984128
-industrial engineering NULL 3060
-industrial engineering -124 3249
-industrial engineering -110 2560
+history NULL 3231
+industrial engineering -1 8087737899452432384
industrial engineering -101 -7617860842651017216
-industrial engineering -98 8368012468775608320
-industrial engineering -96 688
-industrial engineering -87 7486884806277611520
-industrial engineering -85 -7512289590991544320
-industrial engineering -72 3208
-industrial engineering -68 -9206329156028112896
-industrial engineering -65 9112400579327483904
-industrial engineering -58 650
-industrial engineering -57 -8521578237232529408
-industrial engineering -53 68
-industrial engineering -49 181
-industrial engineering -47 2911
-industrial engineering -43 504
-industrial engineering -38 -8581765103969312768
-industrial engineering -35 1726
-industrial engineering -31 1520
-industrial engineering -30 3472
-industrial engineering -28 724
-industrial engineering -22 -7540104552219860992
industrial engineering -11 -7802538500225777664
-industrial engineering -7 2420
-industrial engineering -6 9185458640237641728
+industrial engineering -110 2560
+industrial engineering -124 3249
+industrial engineering -22 -7540104552219860992
+industrial engineering -28 724
+industrial engineering -30 3472
+industrial engineering -31 1520
+industrial engineering -35 1726
+industrial engineering -38 -8581765103969312768
+industrial engineering -43 504
+industrial engineering -47 2911
+industrial engineering -49 181
industrial engineering -5 2485
-industrial engineering -1 8087737899452432384
-industrial engineering 3 3682
-industrial engineering 7 7573530789362262016
+industrial engineering -53 68
+industrial engineering -57 -8521578237232529408
+industrial engineering -58 650
+industrial engineering -6 9185458640237641728
+industrial engineering -65 9112400579327483904
+industrial engineering -68 -9206329156028112896
+industrial engineering -7 2420
+industrial engineering -72 3208
+industrial engineering -85 -7512289590991544320
+industrial engineering -87 7486884806277611520
+industrial engineering -96 688
+industrial engineering -98 8368012468775608320
+industrial engineering 102 2900
+industrial engineering 104 -8875546987176206336
+industrial engineering 105 8071961599867387904
+industrial engineering 106 878
+industrial engineering 113 1862
+industrial engineering 126 -6968892545529896960
industrial engineering 27 -8445801063348281344
industrial engineering 29 3365
+industrial engineering 3 3682
industrial engineering 32 364
industrial engineering 33 -7240213957902663680
industrial engineering 36 1158
@@ -814,6 +822,7 @@ industrial engineering 48 355
industrial engineering 54 691
industrial engineering 58 8195103847607967744
industrial engineering 59 8808467247666241536
+industrial engineering 7 7573530789362262016
industrial engineering 70 9091082386452684800
industrial engineering 73 -7011425384222244864
industrial engineering 78 -9136398397785948160
@@ -823,41 +832,42 @@ industrial engineering 95 81923046926963
industrial engineering 96 -7910019233726242816
industrial engineering 98 -7524170566881329152
industrial engineering 99 -9215144824304721920
-industrial engineering 102 2900
-industrial engineering 104 -8875546987176206336
-industrial engineering 105 8071961599867387904
-industrial engineering 106 878
-industrial engineering 113 1862
-industrial engineering 126 -6968892545529896960
-joggying NULL -8877053610728161280
-joggying -125 7823874904139849728
-joggying -121 3103
-joggying -119 2189
-joggying -110 -8870186814744420352
-joggying -101 -8675661101615489024
+industrial engineering NULL 3060
+joggying -1 7844258063629852672
joggying -100 7080269176324218880
-joggying -80 8254763178969915392
-joggying -79 -7939634346485858304
-joggying -77 7626715182847090688
-joggying -76 NULL
-joggying -73 8011181697250631680
-joggying -69 7678790769408172032
-joggying -64 2373
-joggying -62 -8425998949410889728
-joggying -61 8687042963221159936
-joggying -57 8936639033158410240
-joggying -55 8208354137450766336
-joggying -48 8351163199364390912
-joggying -47 NULL
-joggying -43 8323460620425330688
-joggying -40 3781
-joggying -30 2217
-joggying -27 2790
-joggying -24 -7083646746411720704
-joggying -15 -8658387566611996672
+joggying -101 -8675661101615489024
+joggying -110 -8870186814744420352
+joggying -119 2189
+joggying -121 3103
+joggying -125 7823874904139849728
joggying -14 -8358130693961195520
+joggying -15 -8658387566611996672
+joggying -24 -7083646746411720704
+joggying -27 2790
+joggying -30 2217
+joggying -40 3781
+joggying -43 8323460620425330688
+joggying -47 NULL
+joggying -48 8351163199364390912
+joggying -55 8208354137450766336
+joggying -57 8936639033158410240
+joggying -61 8687042963221159936
+joggying -62 -8425998949410889728
+joggying -64 2373
+joggying -69 7678790769408172032
+joggying -73 8011181697250631680
+joggying -76 NULL
+joggying -77 7626715182847090688
+joggying -79 -7939634346485858304
joggying -8 8723248113030782976
-joggying -1 7844258063629852672
+joggying -80 8254763178969915392
+joggying 104 1864
+joggying 105 2002
+joggying 118 -8108693586698706944
+joggying 119 -7892780594910871552
+joggying 121 1987
+joggying 123 NULL
+joggying 125 2842
joggying 13 8525894870444638208
joggying 20 425
joggying 25 1556
@@ -885,35 +895,37 @@ joggying 93 8416121695917498368
joggying 94 7599019810193211392
joggying 97 2565
joggying 99 1863
-joggying 104 1864
-joggying 105 2002
-joggying 118 -8108693586698706944
-joggying 119 -7892780594910871552
-joggying 121 1987
-joggying 123 NULL
-joggying 125 2842
-kindergarten NULL 6933001829416034304
-kindergarten -126 2509
-kindergarten -113 259
+joggying NULL -8877053610728161280
kindergarten -106 -8103788088118018048
-kindergarten -98 982
-kindergarten -95 8983912573761167360
-kindergarten -92 NULL
-kindergarten -79 -7751427073017544704
-kindergarten -78 7524958388842078208
-kindergarten -75 7017956982081404928
-kindergarten -74 -8632237187473088512
-kindergarten -69 1813
-kindergarten -60 7027529814236192768
-kindergarten -59 8991071342495531008
-kindergarten -57 -7949309059286163456
-kindergarten -54 8896237972875370496
-kindergarten -42 -7094827141662539776
-kindergarten -40 7084659344078970880
-kindergarten -26 7226360892091416576
+kindergarten -113 259
+kindergarten -126 2509
kindergarten -18 7696737688942567424
+kindergarten -26 7226360892091416576
+kindergarten -40 7084659344078970880
+kindergarten -42 -7094827141662539776
+kindergarten -54 8896237972875370496
+kindergarten -57 -7949309059286163456
+kindergarten -59 8991071342495531008
+kindergarten -60 7027529814236192768
+kindergarten -69 1813
+kindergarten -74 -8632237187473088512
+kindergarten -75 7017956982081404928
+kindergarten -78 7524958388842078208
+kindergarten -79 -7751427073017544704
kindergarten -8 -7420448501073051648
+kindergarten -92 NULL
+kindergarten -95 8983912573761167360
+kindergarten -98 982
kindergarten 10 3111
+kindergarten 100 108
+kindergarten 101 7166263463731421184
+kindergarten 109 2962
+kindergarten 111 2320
+kindergarten 116 9207927479837319168
+kindergarten 118 -7819437864839495680
+kindergarten 120 7779735136559579136
+kindergarten 122 -7079898537463537664
+kindergarten 127 2223
kindergarten 16 7753882935005880320
kindergarten 18 -7395553021620731904
kindergarten 19 -8104684579106914304
@@ -935,62 +947,59 @@ kindergarten 86 NULL
kindergarten 90 8972161729142095872
kindergarten 92 8716401555586727936
kindergarten 96 -7429331808102899712
-kindergarten 100 108
-kindergarten 101 7166263463731421184
-kindergarten 109 2962
-kindergarten 111 2320
-kindergarten 116 9207927479837319168
-kindergarten 118 -7819437864839495680
-kindergarten 120 7779735136559579136
-kindergarten 122 -7079898537463537664
-kindergarten 127 2223
-linguistics NULL 8383159090746204160
-linguistics -127 -8896045754034978816
-linguistics -122 -7695491171376291840
-linguistics -113 7614435638888210432
+kindergarten NULL 6933001829416034304
linguistics -101 -8017791189288869888
-linguistics -90 -7739424919198187520
-linguistics -89 8489735221193138176
-linguistics -87 2244
-linguistics -86 NULL
-linguistics -78 8518454006987948032
-linguistics -77 7686992843032010752
-linguistics -73 -8916987977485312000
-linguistics -70 2277
-linguistics -69 -7104310188119834624
-linguistics -68 8184799300477943808
-linguistics -67 NULL
-linguistics -53 NULL
-linguistics -52 -8651641150831362048
-linguistics -41 1811
-linguistics -34 3958
-linguistics -28 7345991518378442752
-linguistics -22 8489584373231919104
-linguistics -20 7620183559667081216
-linguistics -17 9075404705968840704
-linguistics -16 2662
-linguistics -14 -9203804401302323200
-linguistics -13 7566273236152721408
+linguistics -113 7614435638888210432
linguistics -12 NULL
-linguistics -6 8145750910080745472
-linguistics -4 3789
+linguistics -122 -7695491171376291840
+linguistics -127 -8896045754034978816
+linguistics -13 7566273236152721408
+linguistics -14 -9203804401302323200
+linguistics -16 2662
+linguistics -17 9075404705968840704
linguistics -2 -7501803640821456896
+linguistics -20 7620183559667081216
+linguistics -22 8489584373231919104
+linguistics -28 7345991518378442752
+linguistics -34 3958
+linguistics -4 3789
+linguistics -41 1811
+linguistics -52 -8651641150831362048
+linguistics -53 NULL
+linguistics -6 8145750910080745472
+linguistics -67 NULL
+linguistics -68 8184799300477943808
+linguistics -69 -7104310188119834624
+linguistics -70 2277
+linguistics -73 -8916987977485312000
+linguistics -77 7686992843032010752
+linguistics -78 8518454006987948032
+linguistics -86 NULL
+linguistics -87 2244
+linguistics -89 8489735221193138176
+linguistics -90 -7739424919198187520
linguistics 0 9023663198045544448
linguistics 1 1386
-linguistics 3 7386087924003676160
-linguistics 6 8558000156325707776
-linguistics 7 9048297564833079296
linguistics 10 2846
+linguistics 100 3622
linguistics 11 83
+linguistics 113 7217123582035116032
+linguistics 115 -6920172215209426944
+linguistics 123 7762823913046556672
+linguistics 125 1074
+linguistics 126 9067985867711291392
linguistics 18 1261
+linguistics 3 7386087924003676160
linguistics 33 1086
linguistics 37 1777
linguistics 42 9117063974299148288
linguistics 44 9136548192574529536
linguistics 50 9188173682239275008
linguistics 53 1447
+linguistics 6 8558000156325707776
linguistics 64 1704
linguistics 67 -7201085131997011968
+linguistics 7 9048297564833079296
linguistics 72 204
linguistics 73 2502
linguistics 83 NULL
@@ -998,51 +1007,48 @@ linguistics 89 8116738401948377088
linguistics 93 -7879864376629567488
linguistics 96 803
linguistics 98 7898670840507031552
-linguistics 100 3622
-linguistics 113 7217123582035116032
-linguistics 115 -6920172215209426944
-linguistics 123 7762823913046556672
-linguistics 125 1074
-linguistics 126 9067985867711291392
-mathematics NULL 9001907486943993856
-mathematics -127 -7158472098920390656
-mathematics -124 8290014929764040704
-mathematics -122 -7453525026342617088
-mathematics -120 3322
-mathematics -118 -6997233584896229376
-mathematics -117 2786
-mathematics -103 658
-mathematics -101 -8756989568739835904
+linguistics NULL 8383159090746204160
mathematics -100 7662037650719850496
-mathematics -99 NULL
-mathematics -98 -7425160895830573056
-mathematics -95 490
-mathematics -91 8223732800007864320
-mathematics -88 -7115054815375073280
-mathematics -81 7753359568986636288
-mathematics -79 8111757081791733760
-mathematics -77 7581614118458335232
-mathematics -75 -7221474017515347968
-mathematics -66 -7894382303337832448
-mathematics -57 8219326436390821888
-mathematics -52 8435912708683087872
-mathematics -50 7746402369011277824
-mathematics -49 8156018594610790400
-mathematics -46 8210813831744118784
-mathematics -45 7237310132329488384
-mathematics -40 -8518258741831680000
-mathematics -33 7461153404961128448
-mathematics -31 681
-mathematics -21 -7661192563533062144
+mathematics -101 -8756989568739835904
+mathematics -103 658
+mathematics -117 2786
+mathematics -118 -6997233584896229376
+mathematics -120 3322
+mathematics -122 -7453525026342617088
+mathematics -124 8290014929764040704
+mathematics -127 -7158472098920390656
mathematics -19 3159
+mathematics -21 -7661192563533062144
+mathematics -31 681
+mathematics -33 7461153404961128448
+mathematics -40 -8518258741831680000
+mathematics -45 7237310132329488384
+mathematics -46 8210813831744118784
+mathematics -49 8156018594610790400
+mathematics -50 7746402369011277824
+mathematics -52 8435912708683087872
+mathematics -57 8219326436390821888
+mathematics -66 -7894382303337832448
mathematics -7 8396433451610652672
+mathematics -75 -7221474017515347968
+mathematics -77 7581614118458335232
+mathematics -79 8111757081791733760
+mathematics -81 7753359568986636288
+mathematics -88 -7115054815375073280
+mathematics -91 8223732800007864320
+mathematics -95 490
+mathematics -98 -7425160895830573056
+mathematics -99 NULL
mathematics 0 8282648443538710528
-mathematics 3 -8887058200926093312
-mathematics 6 1701
mathematics 10 7259955893466931200
+mathematics 102 690
+mathematics 107 8391407951622815744
+mathematics 111 2607
+mathematics 114 3094
mathematics 22 6934570741217755136
mathematics 23 7271887863395459072
mathematics 25 -7333362172439035904
+mathematics 3 -8887058200926093312
mathematics 32 2073
mathematics 35 -7558524160894427136
mathematics 38 -7557017910095650816
@@ -1055,6 +1061,7 @@ mathematics 55 2227
mathematics 56 898
mathematics 58 3830
mathematics 59 7487338208419823616
+mathematics 6 1701
mathematics 62 883
mathematics 63 8156782979767238656
mathematics 65 1648
@@ -1065,43 +1072,45 @@ mathematics 82 1093
mathematics 87 3707
mathematics 92 -8754992450211692544
mathematics 98 2398
-mathematics 102 690
-mathematics 107 8391407951622815744
-mathematics 111 2607
-mathematics 114 3094
-nap time NULL -8430283518005846016
-nap time -122 8660248367767076864
-nap time -119 2715
-nap time -115 -7576194692683563008
-nap time -113 8451612303224520704
-nap time -104 -7709958788604936192
-nap time -102 -6938706403992854528
+mathematics NULL 9001907486943993856
nap time -101 2229
-nap time -91 85
-nap time -85 3932
-nap time -71 9136234417125007360
-nap time -61 1524
-nap time -54 -8562524688907485184
-nap time -49 8079573715140485120
-nap time -45 7310869618402910208
-nap time -41 7801697837312884736
-nap time -31 939
+nap time -102 -6938706403992854528
+nap time -104 -7709958788604936192
+nap time -113 8451612303224520704
+nap time -115 -7576194692683563008
+nap time -119 2715
+nap time -122 8660248367767076864
nap time -15 7401968422230032384
-nap time -6 7843804446688264192
-nap time -4 736
nap time -2 8697823501349609472
+nap time -31 939
+nap time -4 736
+nap time -41 7801697837312884736
+nap time -45 7310869618402910208
+nap time -49 8079573715140485120
+nap time -54 -8562524688907485184
+nap time -6 7843804446688264192
+nap time -61 1524
+nap time -71 9136234417125007360
+nap time -85 3932
+nap time -91 85
nap time 0 1940
-nap time 3 9064847977742032896
-nap time 6 7871554728617025536
+nap time 103 361
+nap time 104 7125231541858205696
+nap time 105 7045967493826387968
+nap time 107 9114850402293882880
+nap time 108 1189
+nap time 118 8910706980937261056
nap time 16 NULL
nap time 23 7432428551399669760
nap time 27 1454
+nap time 3 9064847977742032896
nap time 31 6964585306125008896
nap time 35 2689
nap time 42 8652485812846567424
nap time 51 -7881262505761710080
nap time 52 2463
nap time 56 -8240034910581153792
+nap time 6 7871554728617025536
nap time 62 NULL
nap time 69 NULL
nap time 70 66
@@ -1113,52 +1122,53 @@ nap time 90 7761834341179375616
nap time 92 8540237852367446016
nap time 93 -8203075743525806080
nap time 98 7691062622443044864
-nap time 103 361
-nap time 104 7125231541858205696
-nap time 105 7045967493826387968
-nap time 107 9114850402293882880
-nap time 108 1189
-nap time 118 8910706980937261056
-opthamology NULL 8856674723376668672
-opthamology -122 9096395849845194752
-opthamology -121 3879
-opthamology -118 2072
+nap time NULL -8430283518005846016
opthamology -111 8244041599171862528
-opthamology -99 -7875953567586451456
-opthamology -97 8752150411997356032
-opthamology -91 2255
-opthamology -86 -9066993118333706240
-opthamology -82 1606
-opthamology -79 -9117959922369060864
-opthamology -78 -7303847963918393344
-opthamology -77 8631515095562887168
-opthamology -75 8779073705407963136
-opthamology -73 908
-opthamology -63 470
-opthamology -59 3021
-opthamology -55 2177
-opthamology -49 8854495099223375872
-opthamology -48 -7877598807023386624
-opthamology -44 2675
-opthamology -35 2274
-opthamology -33 1613
-opthamology -30 8048726769133592576
-opthamology -28 8849475396952514560
-opthamology -27 3599
-opthamology -24 383
-opthamology -22 7718825401976684544
-opthamology -18 2393
-opthamology -17 -7629401308029976576
+opthamology -118 2072
+opthamology -121 3879
+opthamology -122 9096395849845194752
opthamology -14 3235
-opthamology -8 7333512171174223872
+opthamology -17 -7629401308029976576
+opthamology -18 2393
+opthamology -22 7718825401976684544
+opthamology -24 383
+opthamology -27 3599
+opthamology -28 8849475396952514560
+opthamology -30 8048726769133592576
+opthamology -33 1613
+opthamology -35 2274
+opthamology -44 2675
+opthamology -48 -7877598807023386624
+opthamology -49 8854495099223375872
opthamology -5 7411793502161182720
-opthamology 4 9131533983989358592
-opthamology 5 130
+opthamology -55 2177
+opthamology -59 3021
+opthamology -63 470
+opthamology -73 908
+opthamology -75 8779073705407963136
+opthamology -77 8631515095562887168
+opthamology -78 -7303847963918393344
+opthamology -79 -9117959922369060864
+opthamology -8 7333512171174223872
+opthamology -82 1606
+opthamology -86 -9066993118333706240
+opthamology -91 2255
+opthamology -97 8752150411997356032
+opthamology -99 -7875953567586451456
+opthamology 100 -7532751268425261056
+opthamology 104 1866
+opthamology 117 2835
+opthamology 120 -8340523561480437760
+opthamology 122 3462
+opthamology 125 965
+opthamology 127 412
opthamology 21 7069729473166090240
opthamology 39 2745
+opthamology 4 9131533983989358592
opthamology 41 NULL
opthamology 48 3159
opthamology 49 -7904188195431661568
+opthamology 5 130
opthamology 52 -7081500255163727872
opthamology 53 -7055760785575665664
opthamology 55 2335
@@ -1176,46 +1186,44 @@ opthamology 89 -7978782649203228672
opthamology 92 NULL
opthamology 96 -8418913260807217152
opthamology 97 8935252708196999168
-opthamology 100 -7532751268425261056
-opthamology 104 1866
-opthamology 117 2835
-opthamology 120 -8340523561480437760
-opthamology 122 3462
-opthamology 125 965
-opthamology 127 412
-philosophy NULL 8759089349412847616
-philosophy -125 9199741683232399360
-philosophy -121 342
-philosophy -119 -8507279516485566464
-philosophy -115 1719
-philosophy -110 7471208109437304832
-philosophy -105 -7172594404186693632
-philosophy -103 8144552446127972352
+opthamology NULL 8856674723376668672
philosophy -100 -7603569103205916672
-philosophy -99 -8030058711611629568
-philosophy -95 3460
-philosophy -93 8720504651219001344
-philosophy -92 8649296591032172544
-philosophy -80 -7035132060308643840
-philosophy -78 1752
-philosophy -77 -7344947507044466688
-philosophy -69 2897
-philosophy -68 9185952983951343616
-philosophy -61 7271786885641666560
-philosophy -56 -7593363318079610880
-philosophy -55 3366
-philosophy -53 6987889924212203520
-philosophy -52 2824
-philosophy -51 2180
-philosophy -50 8875745082589929472
-philosophy -40 3478
-philosophy -39 1141
-philosophy -27 -8710298418608619520
-philosophy -26 -7344146703223496704
-philosophy -25 -7878145001776152576
-philosophy -17 -7515996202498473984
+philosophy -103 8144552446127972352
+philosophy -105 -7172594404186693632
philosophy -11 -7953426740065312768
-philosophy 8 -8088337436168830976
+philosophy -110 7471208109437304832
+philosophy -115 1719
+philosophy -119 -8507279516485566464
+philosophy -121 342
+philosophy -125 9199741683232399360
+philosophy -17 -7515996202498473984
+philosophy -25 -7878145001776152576
+philosophy -26 -7344146703223496704
+philosophy -27 -8710298418608619520
+philosophy -39 1141
+philosophy -40 3478
+philosophy -50 8875745082589929472
+philosophy -51 2180
+philosophy -52 2824
+philosophy -53 6987889924212203520
+philosophy -55 3366
+philosophy -56 -7593363318079610880
+philosophy -61 7271786885641666560
+philosophy -68 9185952983951343616
+philosophy -69 2897
+philosophy -77 -7344947507044466688
+philosophy -78 1752
+philosophy -80 -7035132060308643840
+philosophy -92 8649296591032172544
+philosophy -93 8720504651219001344
+philosophy -95 3460
+philosophy -99 -8030058711611629568
+philosophy 104 3541
+philosophy 108 6969599299897163776
+philosophy 117 2855
+philosophy 118 -7356685674003021824
+philosophy 120 -8300526097982226432
+philosophy 123 2140
philosophy 20 8290944180915871744
philosophy 21 -7903158849011843072
philosophy 22 7892026679115554816
@@ -1231,49 +1239,47 @@ philosophy 64 535
philosophy 67 2715
philosophy 68 1693
philosophy 73 8283099811330506752
+philosophy 8 -8088337436168830976
philosophy 83 281
philosophy 96 8682955459667951616
philosophy 98 8613562211893919744
-philosophy 104 3541
-philosophy 108 6969599299897163776
-philosophy 117 2855
-philosophy 118 -7356685674003021824
-philosophy 120 -8300526097982226432
-philosophy 123 2140
-quiet hour NULL 7874764415950176256
-quiet hour -127 1099
-quiet hour -123 8769199243315814400
-quiet hour -121 7031339012080549888
-quiet hour -119 7608447395949109248
-quiet hour -114 8419958579638157312
-quiet hour -111 8424515140664360960
-quiet hour -105 918
+philosophy NULL 8759089349412847616
+quiet hour -1 9085434340468473856
quiet hour -104 -7037638331316469760
-quiet hour -88 2919
-quiet hour -87 9182828596851990528
-quiet hour -76 -7792903881635938304
-quiet hour -73 8793387410919038976
-quiet hour -68 6982145326341423104
-quiet hour -66 383
-quiet hour -65 NULL
-quiet hour -56 3567
-quiet hour -55 8569030475428511744
-quiet hour -52 8201303040648052736
-quiet hour -50 7998687089080467456
-quiet hour -48 8398862954249560064
-quiet hour -45 7378993334503694336
-quiet hour -42 NULL
-quiet hour -41 7231399302953377792
-quiet hour -33 7637152193832886272
-quiet hour -31 -7744462446680375296
-quiet hour -25 NULL
+quiet hour -105 918
+quiet hour -111 8424515140664360960
+quiet hour -114 8419958579638157312
+quiet hour -119 7608447395949109248
+quiet hour -121 7031339012080549888
+quiet hour -123 8769199243315814400
+quiet hour -127 1099
quiet hour -14 997
+quiet hour -25 NULL
+quiet hour -31 -7744462446680375296
+quiet hour -33 7637152193832886272
+quiet hour -41 7231399302953377792
+quiet hour -42 NULL
+quiet hour -45 7378993334503694336
+quiet hour -48 8398862954249560064
+quiet hour -50 7998687089080467456
+quiet hour -52 8201303040648052736
+quiet hour -55 8569030475428511744
+quiet hour -56 3567
+quiet hour -65 NULL
+quiet hour -66 383
+quiet hour -68 6982145326341423104
+quiet hour -73 8793387410919038976
+quiet hour -76 -7792903881635938304
quiet hour -8 -7329767178250018816
-quiet hour -1 9085434340468473856
+quiet hour -87 9182828596851990528
+quiet hour -88 2919
quiet hour 0 7450416810848313344
-quiet hour 6 8795069490394882048
-quiet hour 7 2131
-quiet hour 8 -7265998318110711808
+quiet hour 110 2186
+quiet hour 112 7436133434239229952
+quiet hour 115 1641
+quiet hour 120 919
+quiet hour 121 1506
+quiet hour 123 7800332581637259264
quiet hour 13 2560
quiet hour 21 -8293833565967810560
quiet hour 23 1880
@@ -1284,64 +1290,70 @@ quiet hour 35 -7046180371529351168
quiet hour 38 2725
quiet hour 43 8069531888205086720
quiet hour 58 2461
+quiet hour 6 8795069490394882048
quiet hour 60 NULL
quiet hour 66 3770
+quiet hour 7 2131
quiet hour 71 500
quiet hour 74 -7902517224300036096
+quiet hour 8 -7265998318110711808
quiet hour 80 7006803044329021440
quiet hour 82 8853989376829833216
quiet hour 84 8920533610804609024
quiet hour 93 -7873753603299540992
quiet hour 98 -9008631121684832256
-quiet hour 110 2186
-quiet hour 112 7436133434239229952
-quiet hour 115 1641
-quiet hour 120 919
-quiet hour 121 1506
-quiet hour 123 7800332581637259264
-religion NULL 7295502697317097472
-religion -125 2106
-religion -106 NULL
+quiet hour NULL 7874764415950176256
religion -104 820
-religion -94 9174894805640142848
-religion -93 491
-religion -81 8463868417649524736
-religion -78 7497306924248834048
-religion -77 NULL
-religion -76 -8959796625322680320
-religion -71 296
-religion -70 -7461750143936897024
-religion -69 -7433265617153343488
-religion -64 -8430370933326536704
-religion -62 913
-religion -60 7700734109530767360
-religion -56 782
-religion -44 -8807361476639629312
-religion -42 -9213132862973829120
-religion -41 7266437490436341760
-religion -38 -8140349174954893312
-religion -35 7295926343524163584
-religion -32 1537
-religion -29 8221561626658881536
-religion -28 -8857335871148171264
-religion -26 1039
-religion -24 2194
+religion -106 NULL
+religion -125 2106
religion -23 3183
-religion -9 -8696162322976997376
-religion -7 -6968771079156654080
+religion -24 2194
+religion -26 1039
+religion -28 -8857335871148171264
+religion -29 8221561626658881536
religion -3 203
+religion -32 1537
+religion -35 7295926343524163584
+religion -38 -8140349174954893312
+religion -41 7266437490436341760
+religion -42 -9213132862973829120
+religion -44 -8807361476639629312
+religion -56 782
+religion -60 7700734109530767360
+religion -62 913
+religion -64 -8430370933326536704
+religion -69 -7433265617153343488
+religion -7 -6968771079156654080
+religion -70 -7461750143936897024
+religion -71 296
+religion -76 -8959796625322680320
+religion -77 NULL
+religion -78 7497306924248834048
+religion -81 8463868417649524736
+religion -9 -8696162322976997376
+religion -93 491
+religion -94 9174894805640142848
religion 0 8996824426131390464
-religion 2 8995562121346260992
-religion 4 2803
-religion 5 -7159700138947862528
+religion 102 -8471480409335513088
+religion 103 8815398225009967104
+religion 106 3058
+religion 107 3810
+religion 110 -7849504559236210688
+religion 115 -7712425776235274240
+religion 120 5
+religion 123 979
+religion 124 8899122608190930944
religion 15 4088
religion 17 1780
+religion 2 8995562121346260992
religion 29 -7612466483992051712
religion 31 1021
religion 38 1751
+religion 4 2803
religion 44 -8509547439040757760
religion 45 -8070535484085895168
religion 49 8836228556823977984
+religion 5 -7159700138947862528
religion 52 7250237407877382144
religion 54 9211455920344088576
religion 58 3467
@@ -1356,51 +1368,49 @@ religion 92 2067
religion 93 3848
religion 96 -8317591428117274624
religion 97 3456
-religion 102 -8471480409335513088
-religion 103 8815398225009967104
-religion 106 3058
-religion 107 3810
-religion 110 -7849504559236210688
-religion 115 -7712425776235274240
-religion 120 5
-religion 123 979
-religion 124 8899122608190930944
-study skills NULL 8201491077550874624
-study skills -127 -8559008501282832384
-study skills -126 3507
-study skills -117 -8400045653258444800
-study skills -107 8785153741735616512
-study skills -106 8002769767000145920
+religion NULL 7295502697317097472
+study skills -1 7381659098423926784
study skills -100 -8962547695651323904
-study skills -88 2551
-study skills -86 3990
-study skills -82 NULL
-study skills -81 612
-study skills -76 NULL
-study skills -73 -8535957064499879936
-study skills -65 8332670681629106176
-study skills -52 3533
-study skills -36 -8485389240529354752
-study skills -33 -7213775605408178176
-study skills -27 961
-study skills -26 -9187662685618348032
-study skills -22 7204802700490858496
-study skills -17 3144
-study skills -14 3913
+study skills -106 8002769767000145920
+study skills -107 8785153741735616512
+study skills -117 -8400045653258444800
+study skills -126 3507
+study skills -127 -8559008501282832384
study skills -13 7195454019231834112
-study skills -6 -7296096276653391872
-study skills -5 2412
-study skills -4 1094
+study skills -14 3913
+study skills -17 3144
+study skills -22 7204802700490858496
+study skills -26 -9187662685618348032
+study skills -27 961
study skills -3 707
-study skills -1 7381659098423926784
-study skills 2 -7507578199583694848
-study skills 3 7291432593139507200
+study skills -33 -7213775605408178176
+study skills -36 -8485389240529354752
+study skills -4 1094
+study skills -5 2412
+study skills -52 3533
+study skills -6 -7296096276653391872
+study skills -65 8332670681629106176
+study skills -73 -8535957064499879936
+study skills -76 NULL
+study skills -81 612
+study skills -82 NULL
+study skills -86 3990
+study skills -88 2551
+study skills 101 2295
+study skills 106 -8161047750470279168
+study skills 107 9132009829414584320
+study skills 110 -7998947380180819968
+study skills 115 7344029858387820544
+study skills 119 2264
+study skills 123 -7797151404935618560
study skills 18 743
+study skills 2 -7507578199583694848
study skills 21 7274777328897802240
study skills 23 8333523087360901120
study skills 25 -8704234107608203264
study skills 28 -8494118409594650624
study skills 29 -7220731681653604352
+study skills 3 7291432593139507200
study skills 30 2637
study skills 35 -7488415863027367936
study skills 39 8897901899039473664
@@ -1416,48 +1426,45 @@ study skills 63 2512
study skills 66 -7497303453253402624
study skills 68 3725
study skills 72 -8028275725610909696
-study skills 77 7354813692542304256
-study skills 80 -9078662294976061440
-study skills 83 -7779270198785875968
-study skills 92 3059
-study skills 95 7393308503950548992
-study skills 96 -8046189486447017984
-study skills 101 2295
-study skills 106 -8161047750470279168
-study skills 107 9132009829414584320
-study skills 110 -7998947380180819968
-study skills 115 7344029858387820544
-study skills 119 2264
-study skills 123 -7797151404935618560
-topology NULL 8639254009546055680
-topology -122 3941
-topology -116 -7964801953178091520
-topology -106 NULL
-topology -105 -7824788571789279232
+study skills 77 7354813692542304256
+study skills 80 -9078662294976061440
+study skills 83 -7779270198785875968
+study skills 92 3059
+study skills 95 7393308503950548992
+study skills 96 -8046189486447017984
+study skills NULL 8201491077550874624
+topology -1 7391208370547269632
topology -102 8783241818558193664
-topology -98 7212090742612467712
-topology -96 3568
-topology -88 -6975459232300236800
-topology -86 2515
-topology -78 7347732772348870656
-topology -74 8773222500321361920
-topology -71 4037
-topology -60 1493
-topology -58 2619
-topology -57 8895174927321243648
-topology -50 8168742078705262592
-topology -44 -8664374244449050624
-topology -42 2434
-topology -41 1153
-topology -36 3588
-topology -32 -8923529803981905920
-topology -31 -7330413050756235264
-topology -25 244
+topology -105 -7824788571789279232
+topology -106 NULL
+topology -116 -7964801953178091520
+topology -122 3941
topology -21 -8615168537390571520
+topology -25 244
+topology -31 -7330413050756235264
+topology -32 -8923529803981905920
+topology -36 3588
+topology -41 1153
+topology -42 2434
+topology -44 -8664374244449050624
topology -5 1439
-topology -1 7391208370547269632
-topology 7 7339426767877390336
+topology -50 8168742078705262592
+topology -57 8895174927321243648
+topology -58 2619
+topology -60 1493
+topology -71 4037
+topology -74 8773222500321361920
+topology -78 7347732772348870656
+topology -86 2515
+topology -88 -6975459232300236800
+topology -96 3568
+topology -98 7212090742612467712
+topology 105 462
+topology 107 112
topology 11 3333
+topology 119 8525336514806317056
+topology 121 7933040277013962752
+topology 127 -8835408234247168000
topology 13 8411494452500930560
topology 14 8367680396909404160
topology 18 -9189155542884474880
@@ -1477,6 +1484,7 @@ topology 61 1914
topology 63 -8961059046745669632
topology 67 3680
topology 69 2358
+topology 7 7339426767877390336
topology 71 812
topology 80 4075
topology 81 22
@@ -1484,45 +1492,44 @@ topology 83 1477
topology 86 294
topology 87 8900180888218329088
topology 94 8146492373537660928
-topology 105 462
-topology 107 112
-topology 119 8525336514806317056
-topology 121 7933040277013962752
-topology 127 -8835408234247168000
-undecided NULL 8811693967537774592
-undecided -120 7242751359672631296
-undecided -118 4078
-undecided -117 7086206629592252416
-undecided -116 7013693841855774720
-undecided -115 NULL
-undecided -114 8761174805938331648
-undecided -112 367
-undecided -105 4030
+topology NULL 8639254009546055680
+undecided -10 NULL
undecided -104 8625937019655200768
-undecided -96 7697541332524376064
-undecided -93 -7777884099756122112
-undecided -90 NULL
-undecided -84 -9109392978217484288
-undecided -83 7175638927948562432
-undecided -78 -9157613004431998976
-undecided -69 3907
-undecided -62 -8914039133569400832
-undecided -53 1827
-undecided -52 3071
-undecided -51 481
-undecided -43 7491898395977523200
-undecided -41 7690986322714066944
-undecided -29 1774
-undecided -28 4024
-undecided -23 1371
-undecided -19 -8523434203900674048
+undecided -105 4030
+undecided -112 367
+undecided -114 8761174805938331648
+undecided -115 NULL
+undecided -116 7013693841855774720
+undecided -117 7086206629592252416
+undecided -118 4078
+undecided -120 7242751359672631296
undecided -13 3823
-undecided -10 NULL
+undecided -19 -8523434203900674048
+undecided -23 1371
+undecided -28 4024
+undecided -29 1774
+undecided -41 7690986322714066944
+undecided -43 7491898395977523200
+undecided -51 481
+undecided -52 3071
+undecided -53 1827
+undecided -62 -8914039133569400832
+undecided -69 3907
+undecided -78 -9157613004431998976
undecided -8 8470141334513098752
+undecided -83 7175638927948562432
+undecided -84 -9109392978217484288
+undecided -90 NULL
+undecided -93 -7777884099756122112
+undecided -96 7697541332524376064
undecided 0 7944741547145502720
undecided 1 1671
-undecided 7 8269730157217062912
undecided 11 9089435102788009984
+undecided 111 9180098147855769600
+undecided 114 3006
+undecided 119 168
+undecided 123 1187
+undecided 124 7888238729321496576
undecided 13 -7700203302632210432
undecided 14 9190466190353661952
undecided 27 3622
@@ -1535,62 +1542,63 @@ undecided 50 7570474972934488064
undecided 51 1545
undecided 56 8583916402383601664
undecided 69 -7140008543769042944
+undecided 7 8269730157217062912
undecided 76 8169878743136043008
undecided 95 2821
undecided 97 -7451660755269853184
undecided 98 443
-undecided 111 9180098147855769600
-undecided 114 3006
-undecided 119 168
-undecided 123 1187
-undecided 124 7888238729321496576
-values clariffication NULL -7456869587112255488
-values clariffication -123 7412924364686458880
-values clariffication -119 NULL
-values clariffication -114 7235109456886816768
-values clariffication -109 7909645665163804672
-values clariffication -108 -7246123871306244096
-values clariffication -107 8295110846998233088
-values clariffication -105 7555301305375858688
+undecided NULL 8811693967537774592
values clariffication -100 1053
-values clariffication -98 -8013397854633648128
-values clariffication -97 8579974641030365184
-values clariffication -95 -8996954350906294272
-values clariffication -92 2011
-values clariffication -90 1423
-values clariffication -81 6996686091335884800
-values clariffication -75 2569
-values clariffication -70 3083
-values clariffication -69 -7329807949048193024
-values clariffication -67 169
-values clariffication -63 -6947955278050181120
-values clariffication -62 2712
-values clariffication -60 2971
-values clariffication -55 3904
-values clariffication -51 3637
-values clariffication -50 8199513544090730496
-values clariffication -48 7370078518278397952
-values clariffication -46 NULL
-values clariffication -42 -7611584069753552896
-values clariffication -40 2942
-values clariffication -38 2991
-values clariffication -37 7581052107944361984
-values clariffication -31 763
+values clariffication -105 7555301305375858688
+values clariffication -107 8295110846998233088
+values clariffication -108 -7246123871306244096
+values clariffication -109 7909645665163804672
+values clariffication -114 7235109456886816768
+values clariffication -119 NULL
+values clariffication -123 7412924364686458880
values clariffication -28 3352
-values clariffication -8 8148211378319933440
-values clariffication -6 2056
+values clariffication -31 763
+values clariffication -37 7581052107944361984
+values clariffication -38 2991
+values clariffication -40 2942
+values clariffication -42 -7611584069753552896
+values clariffication -46 NULL
+values clariffication -48 7370078518278397952
values clariffication -5 3031
-values clariffication 4 489
-values clariffication 8 -8426531414463545344
-values clariffication 9 -8603817012434198528
+values clariffication -50 8199513544090730496
+values clariffication -51 3637
+values clariffication -55 3904
+values clariffication -6 2056
+values clariffication -60 2971
+values clariffication -62 2712
+values clariffication -63 -6947955278050181120
+values clariffication -67 169
+values clariffication -69 -7329807949048193024
+values clariffication -70 3083
+values clariffication -75 2569
+values clariffication -8 8148211378319933440
+values clariffication -81 6996686091335884800
+values clariffication -90 1423
+values clariffication -92 2011
+values clariffication -95 -8996954350906294272
+values clariffication -97 8579974641030365184
+values clariffication -98 -8013397854633648128
values clariffication 10 7186401810812059648
+values clariffication 108 1115
+values clariffication 118 -9022154842129547264
values clariffication 12 8190539859890601984
+values clariffication 120 6927260280037097472
+values clariffication 122 -9084940280061485056
+values clariffication 124 -9210275791460499456
+values clariffication 126 3673
+values clariffication 127 -8347088645602050048
values clariffication 14 -8147405381260345344
values clariffication 15 7575087487730196480
values clariffication 21 NULL
values clariffication 23 3255
values clariffication 30 9107991000536498176
values clariffication 32 NULL
+values clariffication 4 489
values clariffication 42 2020
values clariffication 50 1983
values clariffication 53 3887
@@ -1599,55 +1607,56 @@ values clariffication 57 -76691691381242
values clariffication 62 3910
values clariffication 70 1287
values clariffication 74 2533
+values clariffication 8 -8426531414463545344
values clariffication 80 7220131672176058368
values clariffication 85 2986
+values clariffication 9 -8603817012434198528
values clariffication 92 -8490382417169408000
values clariffication 93 7741854854673367040
values clariffication 96 2625
values clariffication 97 3858
values clariffication 98 8515682078777081856
-values clariffication 108 1115
-values clariffication 118 -9022154842129547264
-values clariffication 120 6927260280037097472
-values clariffication 122 -9084940280061485056
-values clariffication 124 -9210275791460499456
-values clariffication 126 3673
-values clariffication 127 -8347088645602050048
-wind surfing NULL 7961515985722605568
-wind surfing -124 1048
-wind surfing -121 7164349895861829632
-wind surfing -117 1177
-wind surfing -116 1941
-wind surfing -113 4020
-wind surfing -111 8415171956168417280
-wind surfing -104 8666178591503564800
+values clariffication NULL -7456869587112255488
wind surfing -102 1518
-wind surfing -99 7265141874315517952
-wind surfing -98 8457906374051020800
-wind surfing -96 3147
-wind surfing -83 1509
-wind surfing -80 3630
-wind surfing -78 -9088239683374350336
-wind surfing -71 1990
-wind surfing -65 1495
-wind surfing -60 601
-wind surfing -57 6926925215281774592
-wind surfing -56 7107604675626008576
-wind surfing -42 2619
-wind surfing -39 3554
-wind surfing -38 7410872053689794560
-wind surfing -34 -7535857766791577600
-wind surfing -31 -9105701280936501248
-wind surfing -30 3945
-wind surfing -21 NULL
-wind surfing -18 -8117838333114212352
-wind surfing -14 7130306447560826880
+wind surfing -104 8666178591503564800
+wind surfing -111 8415171956168417280
+wind surfing -113 4020
+wind surfing -116 1941
+wind surfing -117 1177
wind surfing -12 3974
-wind surfing -8 9016280522993975296
+wind surfing -121 7164349895861829632
+wind surfing -124 1048
+wind surfing -14 7130306447560826880
+wind surfing -18 -8117838333114212352
+wind surfing -2 661
+wind surfing -21 NULL
+wind surfing -30 3945
+wind surfing -31 -9105701280936501248
+wind surfing -34 -7535857766791577600
+wind surfing -38 7410872053689794560
+wind surfing -39 3554
+wind surfing -42 2619
+wind surfing -56 7107604675626008576
+wind surfing -57 6926925215281774592
wind surfing -6 -6951350560260784128
-wind surfing -2 661
-wind surfing 5 3286
+wind surfing -60 601
+wind surfing -65 1495
+wind surfing -71 1990
+wind surfing -78 -9088239683374350336
+wind surfing -8 9016280522993975296
+wind surfing -80 3630
+wind surfing -83 1509
+wind surfing -96 3147
+wind surfing -98 8457906374051020800
+wind surfing -99 7265141874315517952
+wind surfing 101 -7848043121524228096
+wind surfing 102 2649
+wind surfing 107 1032
+wind surfing 108 8508401924853850112
wind surfing 11 -9149719074367946752
+wind surfing 111 8000440057238052864
+wind surfing 112 7077311975029555200
+wind surfing 121 3579
wind surfing 15 3940
wind surfing 16 2193
wind surfing 20 3703
@@ -1663,6 +1672,7 @@ wind surfing 41 3722
wind surfing 44 3462
wind surfing 45 8287522765741301760
wind surfing 48 7414865343000322048
+wind surfing 5 3286
wind surfing 52 8524940073536954368
wind surfing 53 1856
wind surfing 54 8100036735858401280
@@ -1680,110 +1690,104 @@ wind surfing 86 9169248521377374208
wind surfing 88 1132
wind surfing 92 1530
wind surfing 96 8142241016679735296
-wind surfing 101 -7848043121524228096
-wind surfing 102 2649
-wind surfing 107 1032
-wind surfing 108 8508401924853850112
-wind surfing 111 8000440057238052864
-wind surfing 112 7077311975029555200
-wind surfing 121 3579
-xylophone band NULL 3401
-xylophone band -115 -7000925438663041024
-xylophone band -112 -8705403811649355776
-xylophone band -109 -7804116532814151680
-xylophone band -104 3510
+wind surfing NULL 7961515985722605568
+xylophone band -10 -7404052043914526720
xylophone band -101 2786
-xylophone band -98 7060236714847412224
-xylophone band -96 8984935029383389184
-xylophone band -94 -7380731416973295616
-xylophone band -91 914
-xylophone band -78 8222714144797368320
-xylophone band -75 3084
-xylophone band -72 -7642381493746483200
-xylophone band -70 -8270479187688816640
-xylophone band -68 -8768744394742235136
-xylophone band -59 1845
-xylophone band -46 -7052619594823221248
-xylophone band -27 618
-xylophone band -26 3397
-xylophone band -23 8837420822750314496
-xylophone band -15 -9051477157204770816
+xylophone band -104 3510
+xylophone band -109 -7804116532814151680
+xylophone band -112 -8705403811649355776
+xylophone band -115 -7000925438663041024
xylophone band -13 8708232769657815040
-xylophone band -10 -7404052043914526720
-xylophone band -6 8410599906334097408
-xylophone band -3 2803
+xylophone band -15 -9051477157204770816
xylophone band -2 -7989766326847807488
+xylophone band -23 8837420822750314496
+xylophone band -26 3397
+xylophone band -27 618
+xylophone band -3 2803
+xylophone band -46 -7052619594823221248
+xylophone band -59 1845
+xylophone band -6 8410599906334097408
+xylophone band -68 -8768744394742235136
+xylophone band -70 -8270479187688816640
+xylophone band -72 -7642381493746483200
+xylophone band -75 3084
+xylophone band -78 8222714144797368320
+xylophone band -91 914
+xylophone band -94 -7380731416973295616
+xylophone band -96 8984935029383389184
+xylophone band -98 7060236714847412224
xylophone band 0 2988
-xylophone band 3 8286706213485297664
-xylophone band 6 1676
-xylophone band 7 7065344324692443136
-xylophone band 9 -7262798781688651776
+xylophone band 107 -8357136656913686528
+xylophone band 108 2108
xylophone band 11 7500716020874674176
+xylophone band 112 7921639119138070528
+xylophone band 118 1728
+xylophone band 122 9207107990561972224
+xylophone band 123 8677794924343164928
+xylophone band 125 263
+xylophone band 127 NULL
xylophone band 14 -7881351200983613440
xylophone band 17 7778936842502275072
xylophone band 19 2984
xylophone band 22 -7551394356730339328
xylophone band 23 7675009476762918912
+xylophone band 3 8286706213485297664
xylophone band 33 311
xylophone band 36 -6917607783359897600
xylophone band 38 3067
xylophone band 40 8129551357032259584
xylophone band 52 -7687052294777208832
+xylophone band 6 1676
xylophone band 60 1541
xylophone band 62 8365058996333953024
+xylophone band 7 7065344324692443136
xylophone band 77 9209153648361848832
xylophone band 79 1307
xylophone band 84 1398
xylophone band 85 7592440105065308160
xylophone band 88 584
+xylophone band 9 -7262798781688651776
xylophone band 92 -7399631791131074560
xylophone band 94 8643198489997254656
-xylophone band 107 -8357136656913686528
-xylophone band 108 2108
-xylophone band 112 7921639119138070528
-xylophone band 118 1728
-xylophone band 122 9207107990561972224
-xylophone band 123 8677794924343164928
-xylophone band 125 263
-xylophone band 127 NULL
-yard duty NULL 1972
-yard duty -127 2719
-yard duty -115 8279056098670198784
-yard duty -114 3747
-yard duty -109 2791
-yard duty -103 -8659692318743314432
-yard duty -102 NULL
+xylophone band NULL 3401
+yard duty -1 -9012093603044245504
yard duty -100 7309156463509061632
-yard duty -98 7492436934952574976
-yard duty -93 NULL
-yard duty -91 -7094189393339678720
-yard duty -88 8145745969573666816
-yard duty -86 3606
-yard duty -85 NULL
-yard duty -82 -8191825921746305024
-yard duty -76 3563
-yard duty -62 71
-yard duty -61 -7541860097718902784
-yard duty -57 8059284960252731392
-yard duty -53 2843
-yard duty -51 -7686220526274502656
-yard duty -50 8220104397160169472
-yard duty -49 NULL
-yard duty -48 9040958359122640896
-yard duty -46 8641221723991433216
-yard duty -45 9139805788041134080
-yard duty -44 1065
-yard duty -33 1075
-yard duty -28 -7444070205513138176
-yard duty -27 7199539820886958080
-yard duty -21 2092
-yard duty -19 8656571350884048896
-yard duty -17 NULL
+yard duty -102 NULL
+yard duty -103 -8659692318743314432
+yard duty -109 2791
+yard duty -114 3747
+yard duty -115 8279056098670198784
+yard duty -127 2719
yard duty -15 1481
-yard duty -1 -9012093603044245504
-yard duty 8 -7194281951646187520
-yard duty 9 -8345065519816695808
+yard duty -17 NULL
+yard duty -19 8656571350884048896
+yard duty -21 2092
+yard duty -27 7199539820886958080
+yard duty -28 -7444070205513138176
+yard duty -33 1075
+yard duty -44 1065
+yard duty -45 9139805788041134080
+yard duty -46 8641221723991433216
+yard duty -48 9040958359122640896
+yard duty -49 NULL
+yard duty -50 8220104397160169472
+yard duty -51 -7686220526274502656
+yard duty -53 2843
+yard duty -57 8059284960252731392
+yard duty -61 -7541860097718902784
+yard duty -62 71
+yard duty -76 3563
+yard duty -82 -8191825921746305024
+yard duty -85 NULL
+yard duty -86 3606
+yard duty -88 8145745969573666816
+yard duty -91 -7094189393339678720
+yard duty -93 NULL
+yard duty -98 7492436934952574976
yard duty 10 3212
+yard duty 102 2004
+yard duty 105 80
+yard duty 110 7153922334283776000
yard duty 15 8945004737083555840
yard duty 18 3901
yard duty 22 -7109790267244814336
@@ -1800,50 +1804,50 @@ yard duty 60 1781
yard duty 64 -8084716955963252736
yard duty 65 735
yard duty 78 -8275337702906757120
+yard duty 8 -7194281951646187520
yard duty 86 2688
+yard duty 9 -8345065519816695808
yard duty 90 -7692192232238678016
-yard duty 102 2004
-yard duty 105 80
-yard duty 110 7153922334283776000
-zync studies NULL 8962097525980225536
-zync studies -127 3079
-zync studies -117 -9219066990552760320
-zync studies -116 1542
-zync studies -111 1681
-zync studies -105 8665969966920990720
-zync studies -103 8509508263705477120
+yard duty NULL 1972
zync studies -102 8900545829211299840
-zync studies -94 2563
-zync studies -90 8160569434550403072
-zync studies -83 8213810702473183232
-zync studies -79 -7152177800841502720
-zync studies -78 8235179243092090880
-zync studies -68 1870
-zync studies -61 -6974654664348033024
-zync studies -58 -8859107121649893376
-zync studies -57 3213
-zync studies -54 8555948987770511360
-zync studies -52 3462
-zync studies -50 2016
-zync studies -45 -8300764106868350976
-zync studies -40 3244
-zync studies -39 8099215208813903872
-zync studies -38 2514
-zync studies -37 2412
-zync studies -36 412
-zync studies -35 9000633029632499712
-zync studies -34 579
-zync studies -33 -8086577583338061824
-zync studies -32 2540
-zync studies -27 7936149988210212864
-zync studies -26 -8453491903284994048
-zync studies -21 296
-zync studies -20 9104574294205636608
+zync studies -103 8509508263705477120
+zync studies -105 8665969966920990720
+zync studies -111 1681
+zync studies -116 1542
+zync studies -117 -9219066990552760320
zync studies -12 2325
+zync studies -127 3079
+zync studies -20 9104574294205636608
+zync studies -21 296
+zync studies -26 -8453491903284994048
+zync studies -27 7936149988210212864
+zync studies -32 2540
+zync studies -33 -8086577583338061824
+zync studies -34 579
+zync studies -35 9000633029632499712
+zync studies -36 412
+zync studies -37 2412
+zync studies -38 2514
+zync studies -39 8099215208813903872
+zync studies -40 3244
+zync studies -45 -8300764106868350976
+zync studies -50 2016
+zync studies -52 3462
+zync studies -54 8555948987770511360
+zync studies -57 3213
+zync studies -58 -8859107121649893376
+zync studies -61 -6974654664348033024
+zync studies -68 1870
+zync studies -78 8235179243092090880
+zync studies -79 -7152177800841502720
+zync studies -83 8213810702473183232
+zync studies -90 8160569434550403072
+zync studies -94 2563
zync studies 1 3841
-zync studies 7 1127
-zync studies 9 2878
+zync studies 100 8536948829863198720
zync studies 11 279
+zync studies 116 9073672806863790080
+zync studies 120 7845953007588401152
zync studies 15 8731960288562044928
zync studies 19 -8714995808835444736
zync studies 31 2306
@@ -1851,12 +1855,12 @@ zync studies 37 2979
zync studies 48 2205
zync studies 59 NULL
zync studies 63 -8877431933441327104
+zync studies 7 1127
zync studies 70 8294315622451740672
zync studies 87 -9203942396257984512
+zync studies 9 2878
zync studies 90 2850
zync studies 91 8091421389575282688
zync studies 98 1252
zync studies 99 1608
-zync studies 100 8536948829863198720
-zync studies 116 9073672806863790080
-zync studies 120 7845953007588401152
+zync studies NULL 8962097525980225536
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out?rev=1634636&r1=1634635&r2=1634636&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out Mon Oct 27 18:37:05 2014
@@ -1,6 +1,10 @@
-PREHOOK: query: DROP TABLE part
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+DROP TABLE part
PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE part
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+DROP TABLE part
POSTHOOK: type: DROPTABLE
PREHOOK: query: -- data setup
CREATE TABLE part(
@@ -269,16 +273,16 @@ where li.l_linenumber = 1 and
POSTHOOK: type: QUERY
POSTHOOK: Input: default@lineitem
#### A masked pattern was here ####
+108570 8571
+115118 7630
+115209 7721
+155190 7706
2320 9821
-4297 1798
40216 217
+4297 1798
61336 8855
64128 9141
82704 7721
-108570 8571
-115118 7630
-115209 7721
-155190 7706
PREHOOK: query: -- non agg, corr, with join in Parent Query
explain
select p.p_partkey, li.l_suppkey
@@ -448,5 +452,5 @@ where li.l_linenumber = 1 and
POSTHOOK: type: QUERY
POSTHOOK: Input: default@lineitem
#### A masked pattern was here ####
-4297 1798
108570 8571
+4297 1798