hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gop...@apache.org
Subject svn commit: r1629068 [10/11] - in /hive/branches/branch-0.14: data/files/ itests/src/test/resources/ ql/src/java/org/apache/hadoop/hive/ql/exec/vector/ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/ ql/src/test/results/clientpo...
Date Thu, 02 Oct 2014 20:58:54 GMT
Added: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out?rev=1629068&view=auto
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out (added)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out Thu Oct  2 20:58:53 2014
@@ -0,0 +1,328 @@
+PREHOOK: query: create table if not exists alltypes_parquet (
+  cint int, 
+  ctinyint tinyint, 
+  csmallint smallint, 
+  cfloat float, 
+  cdouble double, 
+  cstring1 string) stored as parquet
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@alltypes_parquet
+POSTHOOK: query: create table if not exists alltypes_parquet (
+  cint int, 
+  ctinyint tinyint, 
+  csmallint smallint, 
+  cfloat float, 
+  cdouble double, 
+  cstring1 string) stored as parquet
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@alltypes_parquet
+PREHOOK: query: insert overwrite table alltypes_parquet 
+  select cint, 
+    ctinyint, 
+    csmallint, 
+    cfloat, 
+    cdouble, 
+    cstring1 
+  from alltypesorc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@alltypes_parquet
+POSTHOOK: query: insert overwrite table alltypes_parquet 
+  select cint, 
+    ctinyint, 
+    csmallint, 
+    cfloat, 
+    cdouble, 
+    cstring1 
+  from alltypesorc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@alltypes_parquet
+POSTHOOK: Lineage: alltypes_parquet.cdouble SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null), ]
+POSTHOOK: Lineage: alltypes_parquet.cfloat SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ]
+POSTHOOK: Lineage: alltypes_parquet.cint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: alltypes_parquet.csmallint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:csmallint, type:smallint, comment:null), ]
+POSTHOOK: Lineage: alltypes_parquet.cstring1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: alltypes_parquet.ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
+PREHOOK: query: explain select * 
+  from alltypes_parquet
+  where cint = 528534767 
+  limit 10
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select * 
+  from alltypes_parquet
+  where cint = 528534767 
+  limit 10
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: 10
+      Processor Tree:
+        TableScan
+          alias: alltypes_parquet
+          Filter Operator
+            predicate: (cint = 528534767) (type: boolean)
+            Select Operator
+              expressions: 528534767 (type: int), ctinyint (type: tinyint), csmallint (type: smallint), cfloat (type: float), cdouble (type: double), cstring1 (type: string)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+              Limit
+                Number of rows: 10
+                ListSink
+
+PREHOOK: query: select * 
+  from alltypes_parquet
+  where cint = 528534767 
+  limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypes_parquet
+#### A masked pattern was here ####
+POSTHOOK: query: select * 
+  from alltypes_parquet
+  where cint = 528534767 
+  limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypes_parquet
+#### A masked pattern was here ####
+528534767	-50	-13326	-50.0	-13326.0	cvLH6Eat2yFsyy7p
+528534767	NULL	-4213	NULL	-4213.0	cvLH6Eat2yFsyy7p
+528534767	-28	-15813	-28.0	-15813.0	cvLH6Eat2yFsyy7p
+528534767	31	-9566	31.0	-9566.0	cvLH6Eat2yFsyy7p
+528534767	-34	15007	-34.0	15007.0	cvLH6Eat2yFsyy7p
+528534767	29	7021	29.0	7021.0	cvLH6Eat2yFsyy7p
+528534767	31	4963	31.0	4963.0	cvLH6Eat2yFsyy7p
+528534767	27	-7824	27.0	-7824.0	cvLH6Eat2yFsyy7p
+528534767	-11	-15431	-11.0	-15431.0	cvLH6Eat2yFsyy7p
+528534767	61	-15549	61.0	-15549.0	cvLH6Eat2yFsyy7p
+PREHOOK: query: explain select ctinyint, 
+  max(cint), 
+  min(csmallint), 
+  count(cstring1), 
+  avg(cfloat), 
+  stddev_pop(cdouble)
+  from alltypes_parquet
+  group by ctinyint
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select ctinyint, 
+  max(cint), 
+  min(csmallint), 
+  count(cstring1), 
+  avg(cfloat), 
+  stddev_pop(cdouble)
+  from alltypes_parquet
+  group by ctinyint
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: alltypes_parquet
+                  Statistics: Num rows: 12288 Data size: 73728 Basic stats: COMPLETE Column stats: NONE
+                  Select Operator
+                    expressions: ctinyint (type: tinyint), cint (type: int), csmallint (type: smallint), cstring1 (type: string), cfloat (type: float), cdouble (type: double)
+                    outputColumnNames: ctinyint, cint, csmallint, cstring1, cfloat, cdouble
+                    Statistics: Num rows: 12288 Data size: 73728 Basic stats: COMPLETE Column stats: NONE
+                    Group By Operator
+                      aggregations: max(cint), min(csmallint), count(cstring1), avg(cfloat), stddev_pop(cdouble)
+                      keys: ctinyint (type: tinyint)
+                      mode: hash
+                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+                      Statistics: Num rows: 12288 Data size: 73728 Basic stats: COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col0 (type: tinyint)
+                        sort order: +
+                        Map-reduce partition columns: _col0 (type: tinyint)
+                        Statistics: Num rows: 12288 Data size: 73728 Basic stats: COMPLETE Column stats: NONE
+                        value expressions: _col1 (type: int), _col2 (type: smallint), _col3 (type: bigint), _col4 (type: struct<count:bigint,sum:double,input:float>), _col5 (type: struct<count:bigint,sum:double,variance:double>)
+            Execution mode: vectorized
+        Reducer 2 
+            Reduce Operator Tree:
+              Group By Operator
+                aggregations: max(VALUE._col0), min(VALUE._col1), count(VALUE._col2), avg(VALUE._col3), stddev_pop(VALUE._col4)
+                keys: KEY._col0 (type: tinyint)
+                mode: mergepartial
+                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+                Statistics: Num rows: 6144 Data size: 36864 Basic stats: COMPLETE Column stats: NONE
+                Select Operator
+                  expressions: _col0 (type: tinyint), _col1 (type: int), _col2 (type: smallint), _col3 (type: bigint), _col4 (type: double), _col5 (type: double)
+                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+                  Statistics: Num rows: 6144 Data size: 36864 Basic stats: COMPLETE Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    Statistics: Num rows: 6144 Data size: 36864 Basic stats: COMPLETE Column stats: NONE
+                    table:
+                        input format: org.apache.hadoop.mapred.TextInputFormat
+                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: select ctinyint, 
+  max(cint), 
+  min(csmallint), 
+  count(cstring1), 
+  avg(cfloat), 
+  stddev_pop(cdouble)
+  from alltypes_parquet
+  group by ctinyint
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypes_parquet
+#### A masked pattern was here ####
+POSTHOOK: query: select ctinyint, 
+  max(cint), 
+  min(csmallint), 
+  count(cstring1), 
+  avg(cfloat), 
+  stddev_pop(cdouble)
+  from alltypes_parquet
+  group by ctinyint
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypes_parquet
+#### A masked pattern was here ####
+NULL	1073418988	-16379	3115	NULL	305051.4870777435
+-64	626923679	-15920	21	-64.0	9254.456539277186
+-63	626923679	-12516	16	-63.0	9263.605837223322
+-62	626923679	-15992	24	-62.0	9004.593091474135
+-61	626923679	-15142	22	-61.0	9357.236187870849
+-60	626923679	-15792	24	-60.0	9892.656196775464
+-59	626923679	-15789	28	-59.0	9829.790704244733
+-58	626923679	-15169	20	-58.0	9549.096672008198
+-57	626923679	-14893	32	-57.0	8572.083461570477
+-56	626923679	-11999	33	-56.0	9490.842152672341
+-55	626923679	-13381	26	-55.0	9157.562103946742
+-54	626923679	-14815	23	-54.0	9614.154026896626
+-53	626923679	-15445	19	-53.0	9387.739325499799
+-52	626923679	-16369	30	-52.0	8625.06871423408
+-51	1073680599	-15734	1028	-51.0	9531.569305177045
+-50	626923679	-14320	27	-50.0	8548.827748002343
+-49	626923679	-14831	23	-49.0	9894.429191738676
+-48	626923679	-15462	26	-48.0	9913.883371354861
+-47	626923679	-16096	19	-47.0	9011.009178780589
+-46	626923679	-12427	21	-46.0	9182.943188188632
+-45	626923679	-15027	21	-45.0	8567.489593562543
+-44	626923679	-15667	21	-44.0	10334.01810499552
+-43	626923679	-15607	27	-43.0	8715.255026265124
+-42	626923679	-16025	14	-42.0	9692.646755759979
+-41	626923679	-12606	21	-41.0	9034.40949481481
+-40	626923679	-14678	23	-40.0	9883.334986561835
+-39	626923679	-15612	19	-39.0	9765.551806305297
+-38	626923679	-14914	28	-38.0	8767.375358291503
+-37	626923679	-14780	17	-37.0	10368.905538788269
+-36	626923679	-16208	23	-36.0	8773.547684436919
+-35	626923679	-16059	23	-35.0	10136.580492864763
+-34	626923679	-15450	29	-34.0	8708.243526705026
+-33	626923679	-12779	21	-33.0	8854.331159704514
+-32	626923679	-15866	25	-32.0	9535.546396775915
+-31	626923679	-15915	22	-31.0	9187.596784112568
+-30	626923679	-14863	23	-30.0	9193.941914019653
+-29	626923679	-14747	26	-29.0	9052.945656011721
+-28	626923679	-15813	20	-28.0	9616.869413270924
+-27	626923679	-14984	20	-27.0	8465.29660255097
+-26	626923679	-15686	15	-26.0	10874.523900405318
+-25	626923679	-15862	24	-25.0	9778.256724727018
+-24	626923679	-16311	26	-24.0	9386.736402961187
+-23	626923679	-16355	36	-23.345263230173213	9401.831290253447
+-22	626923679	-14701	22	-22.0	8809.230165774987
+-21	626923679	-16017	27	-21.0	9480.349236669877
+-20	626923679	-16126	24	-20.0	9868.92268080106
+-19	626923679	-15935	25	-19.0	9967.22240685782
+-18	626923679	-14863	24	-18.0	9638.430684071413
+-17	626923679	-15922	19	-17.0	9944.104273894172
+-16	626923679	-15154	21	-16.0	8884.207393686478
+-15	626923679	-16036	24	-15.0	9450.506254395024
+-14	626923679	-13884	22	-14.0	10125.818731386042
+-13	626923679	-15446	30	-13.0	8907.942987576693
+-12	626923679	-16373	22	-12.0	10173.15707541171
+-11	626923679	-15659	32	-11.0	10453.738567408038
+-10	626923679	-15384	28	-10.0	8850.451610567823
+-9	626923679	-15329	31	-9.0	8999.391457373968
+-8	626923679	-14678	18	-8.0	9976.831992670684
+-7	626923679	-14584	23	-7.0	9946.605446407746
+-6	626923679	-15980	30	-6.0	10262.829252317424
+-5	626923679	-15780	24	-5.0	10599.227726422314
+-4	626923679	-16207	21	-4.0	9682.726604102581
+-3	626923679	-13632	16	-3.0	8836.215573422822
+-2	626923679	-16277	20	-2.0	10800.090249507177
+-1	626923679	-15441	36	-1.0486250072717667	8786.246963933321
+0	626923679	-14254	24	0.0	10057.5018088718
+1	626923679	-14610	30	1.0	10016.486277900643
+2	626923679	-16227	25	2.0	10083.276127543355
+3	626923679	-16339	30	3.0	10483.526375885149
+4	626923679	-15999	29	4.0	9516.189702058042
+5	626923679	-16169	31	5.0	11114.001902469323
+6	626923679	-15948	30	6.0	9644.247255286113
+7	626923679	-15839	25	7.0	10077.151640330823
+8	1070764888	-15778	1034	8.0	9562.355155774725
+9	626923679	-13629	25	9.0	10157.217948808622
+10	626923679	-15887	26	10.0	9104.820520135108
+11	1072654057	-14696	1035	11.0	9531.018991371746
+12	626923679	-14642	18	12.0	9696.038286378725
+13	626923679	-14771	26	13.0	8128.265919972384
+14	626923679	-13367	28	14.0	9074.674998750581
+15	626923679	-16339	28	15.0	9770.473400901916
+16	626923679	-14001	26	16.0	10130.883606275334
+17	626923679	-16109	22	16.73235294865627	1353416.3383574807
+18	626923679	-15779	21	18.0	10820.004053788869
+19	626923679	-16049	21	19.0	9423.560227007669
+20	626923679	-15149	21	20.0	11161.893298093504
+21	626923679	-15931	23	21.0	9683.044864861204
+22	626923679	-16280	26	22.0	9693.155720861765
+23	626923679	-15514	24	23.0	8542.419116415425
+24	626923679	-15086	24	24.0	9661.203790645088
+25	626923679	-11349	23	25.0	8888.959012093468
+26	626923679	-14516	29	26.0	9123.125508880432
+27	626923679	-14965	24	27.0	9802.871860196345
+28	626923679	-14455	20	28.0	9283.289383115296
+29	626923679	-15892	16	29.0	9874.046501817154
+30	626923679	-14111	27	30.0	10066.520234676527
+31	626923679	-15960	24	31.0	10427.970184550613
+32	626923679	-14044	24	32.0	8376.464579403413
+33	626923679	-14642	29	40.61776386607777	1304429.5939037625
+34	626923679	-15059	28	34.0	8756.731536033676
+35	626923679	-16153	27	35.0	10351.008404963042
+36	626923679	-15912	20	36.0	9475.257975138164
+37	626923679	-12081	24	37.0	9017.860034890362
+38	626923679	-15248	29	38.0	9900.256257785535
+39	626923679	-14887	28	39.0	10513.343644635232
+40	626923679	-15861	22	40.0	9283.318678549174
+41	626923679	-13480	21	41.0	9016.291129937847
+42	626923679	-15834	28	42.0	10318.01399719996
+43	626923679	-15703	28	43.0	8757.796089055722
+44	626923679	-11185	16	44.0	9425.076634933797
+45	626923679	-15228	18	45.0	9459.968668643689
+46	626923679	-15187	22	46.0	9685.908173160062
+47	626923679	-16324	22	47.0	9822.220821743611
+48	626923679	-16372	29	48.0	10079.286173063345
+49	626923679	-15923	27	49.0	9850.111848934683
+50	626923679	-16236	21	50.0	9398.176197406601
+51	626923679	-15790	17	51.0	9220.075799194028
+52	626923679	-15450	20	52.0	9261.723648435052
+53	626923679	-16217	30	53.0	9895.247408969733
+54	626923679	-15245	16	54.0	9789.50878424882
+55	626923679	-15887	21	55.0	9826.38569192808
+56	626923679	-12631	21	56.0	8860.917133763547
+57	626923679	-15620	25	57.0	9413.99393840875
+58	626923679	-13627	20	58.0	9083.529665947459
+59	626923679	-16076	17	59.0	10117.44967077967
+60	626923679	-13606	23	60.0	8346.267436552042
+61	626923679	-15894	29	61.0	8785.714950987198
+62	626923679	-14307	17	62.0	9491.752726667326

Added: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_rcfile_columnar.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_rcfile_columnar.q.out?rev=1629068&view=auto
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_rcfile_columnar.q.out (added)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_rcfile_columnar.q.out Thu Oct  2 20:58:53 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: --This query must pass even when vectorized reader is not available for
+--RC files. The query must fall back to the non-vector mode and run successfully.
+
+CREATE table columnTable (key STRING, value STRING)
+ROW FORMAT SERDE
+  'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
+STORED AS
+  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileInputFormat'
+  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@columnTable
+POSTHOOK: query: --This query must pass even when vectorized reader is not available for
+--RC files. The query must fall back to the non-vector mode and run successfully.
+
+CREATE table columnTable (key STRING, value STRING)
+ROW FORMAT SERDE
+  'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
+STORED AS
+  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileInputFormat'
+  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@columnTable
+PREHOOK: query: FROM src
+INSERT OVERWRITE TABLE columnTable SELECT src.key, src.value LIMIT 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@columntable
+POSTHOOK: query: FROM src
+INSERT OVERWRITE TABLE columnTable SELECT src.key, src.value LIMIT 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@columntable
+POSTHOOK: Lineage: columntable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: columntable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: describe columnTable
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@columntable
+POSTHOOK: query: describe columnTable
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@columntable
+key                 	string              	                    
+value               	string              	                    
+PREHOOK: query: SELECT key, value FROM columnTable ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@columntable
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT key, value FROM columnTable ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@columntable
+#### A masked pattern was here ####
+165	val_165
+238	val_238
+255	val_255
+27	val_27
+278	val_278
+311	val_311
+409	val_409
+484	val_484
+86	val_86
+98	val_98

Added: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_string_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_string_funcs.q.out?rev=1629068&view=auto
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_string_funcs.q.out (added)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vectorized_string_funcs.q.out Thu Oct  2 20:58:53 2014
@@ -0,0 +1,123 @@
+PREHOOK: query: -- Test string functions in vectorized mode to verify end-to-end functionality.
+
+explain 
+select 
+   substr(cstring1, 1, 2)
+  ,substr(cstring1, 2)
+  ,lower(cstring1)
+  ,upper(cstring1)
+  ,ucase(cstring1)
+  ,length(cstring1)
+  ,trim(cstring1)
+  ,ltrim(cstring1)
+  ,rtrim(cstring1)
+  ,concat(cstring1, cstring2)
+  ,concat('>', cstring1)
+  ,concat(cstring1, '<')
+  ,concat(substr(cstring1, 1, 2), substr(cstring2, 1, 2))
+from alltypesorc
+-- Limit the number of rows of output to a reasonable amount.
+where cbigint % 237 = 0
+-- Test function use in the WHERE clause.
+and length(substr(cstring1, 1, 2)) <= 2
+and cstring1 like '%'
+PREHOOK: type: QUERY
+POSTHOOK: query: -- Test string functions in vectorized mode to verify end-to-end functionality.
+
+explain 
+select 
+   substr(cstring1, 1, 2)
+  ,substr(cstring1, 2)
+  ,lower(cstring1)
+  ,upper(cstring1)
+  ,ucase(cstring1)
+  ,length(cstring1)
+  ,trim(cstring1)
+  ,ltrim(cstring1)
+  ,rtrim(cstring1)
+  ,concat(cstring1, cstring2)
+  ,concat('>', cstring1)
+  ,concat(cstring1, '<')
+  ,concat(substr(cstring1, 1, 2), substr(cstring2, 1, 2))
+from alltypesorc
+-- Limit the number of rows of output to a reasonable amount.
+where cbigint % 237 = 0
+-- Test function use in the WHERE clause.
+and length(substr(cstring1, 1, 2)) <= 2
+and cstring1 like '%'
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: alltypesorc
+          Filter Operator
+            predicate: ((((cbigint % 237) = 0) and (length(substr(cstring1, 1, 2)) <= 2)) and (cstring1 like '%')) (type: boolean)
+            Select Operator
+              expressions: substr(cstring1, 1, 2) (type: string), substr(cstring1, 2) (type: string), lower(cstring1) (type: string), upper(cstring1) (type: string), upper(cstring1) (type: string), length(cstring1) (type: int), trim(cstring1) (type: string), ltrim(cstring1) (type: string), rtrim(cstring1) (type: string), concat(cstring1, cstring2) (type: string), concat('>', cstring1) (type: string), concat(cstring1, '<') (type: string), concat(substr(cstring1, 1, 2), substr(cstring2, 1, 2)) (type: string)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
+              ListSink
+
+PREHOOK: query: select 
+   substr(cstring1, 1, 2)
+  ,substr(cstring1, 2)
+  ,lower(cstring1)
+  ,upper(cstring1)
+  ,ucase(cstring1)
+  ,length(cstring1)
+  ,trim(cstring1)
+  ,ltrim(cstring1)
+  ,rtrim(cstring1)
+  ,concat(cstring1, cstring2)
+  ,concat('>', cstring1)
+  ,concat(cstring1, '<')
+  ,concat(substr(cstring1, 1, 2), substr(cstring2, 1, 2))
+from alltypesorc
+-- Limit the number of rows of output to a reasonable amount.
+where cbigint % 237 = 0
+-- Test function use in the WHERE clause.
+and length(substr(cstring1, 1, 2)) <= 2
+and cstring1 like '%'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select 
+   substr(cstring1, 1, 2)
+  ,substr(cstring1, 2)
+  ,lower(cstring1)
+  ,upper(cstring1)
+  ,ucase(cstring1)
+  ,length(cstring1)
+  ,trim(cstring1)
+  ,ltrim(cstring1)
+  ,rtrim(cstring1)
+  ,concat(cstring1, cstring2)
+  ,concat('>', cstring1)
+  ,concat(cstring1, '<')
+  ,concat(substr(cstring1, 1, 2), substr(cstring2, 1, 2))
+from alltypesorc
+-- Limit the number of rows of output to a reasonable amount.
+where cbigint % 237 = 0
+-- Test function use in the WHERE clause.
+and length(substr(cstring1, 1, 2)) <= 2
+and cstring1 like '%'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+Vi	iqXS6s88N1yr14lj7I	viqxs6s88n1yr14lj7i	VIQXS6S88N1YR14LJ7I	VIQXS6S88N1YR14LJ7I	19	ViqXS6s88N1yr14lj7I	ViqXS6s88N1yr14lj7I	ViqXS6s88N1yr14lj7I	ViqXS6s88N1yr14lj7ITh638b67kn8o	>ViqXS6s88N1yr14lj7I	ViqXS6s88N1yr14lj7I<	ViTh
+R4	4e7Gf	r4e7gf	R4E7GF	R4E7GF	6	R4e7Gf	R4e7Gf	R4e7Gf	R4e7GfPTBh56R3LS7L13sB4	>R4e7Gf	R4e7Gf<	R4PT
+3g	gubGh4J18TV	3gubgh4j18tv	3GUBGH4J18TV	3GUBGH4J18TV	12	3gubGh4J18TV	3gubGh4J18TV	3gubGh4J18TV	3gubGh4J18TVpJucOe4dN4R5XURJW8	>3gubGh4J18TV	3gubGh4J18TV<	3gpJ
+EP	PCRx8ObNv51rOF	epcrx8obnv51rof	EPCRX8OBNV51ROF	EPCRX8OBNV51ROF	15	EPCRx8ObNv51rOF	EPCRx8ObNv51rOF	EPCRx8ObNv51rOF	EPCRx8ObNv51rOFysaU2Xm11f715L0I35rut2	>EPCRx8ObNv51rOF	EPCRx8ObNv51rOF<	EPys
+8e	eiti74gc5m01xyMKSjUIx	8eiti74gc5m01xymksjuix	8EITI74GC5M01XYMKSJUIX	8EITI74GC5M01XYMKSJUIX	22	8eiti74gc5m01xyMKSjUIx	8eiti74gc5m01xyMKSjUIx	8eiti74gc5m01xyMKSjUIx	8eiti74gc5m01xyMKSjUIxI8x87Fm1J4hE8g4CWNo	>8eiti74gc5m01xyMKSjUIx	8eiti74gc5m01xyMKSjUIx<	8eI8
+m0	0hbv1516qk8	m0hbv1516qk8	M0HBV1516QK8	M0HBV1516QK8	12	m0hbv1516qk8	m0hbv1516qk8	m0hbv1516qk8	m0hbv1516qk8N8i3sxF54C4x5h0	>m0hbv1516qk8	m0hbv1516qk8<	m0N8
+uT	T5e2	ut5e2	UT5E2	UT5E2	5	uT5e2	uT5e2	uT5e2	uT5e2SJp57VKYsDtA2r1Xb2H	>uT5e2	uT5e2<	uTSJ
+l3	35W8012cM77E227Ts	l35w8012cm77e227ts	L35W8012CM77E227TS	L35W8012CM77E227TS	18	l35W8012cM77E227Ts	l35W8012cM77E227Ts	l35W8012cM77E227Ts	l35W8012cM77E227TsMH38bE	>l35W8012cM77E227Ts	l35W8012cM77E227Ts<	l3MH
+o1	1uPH5EflET5ts1RjSB74	o1uph5eflet5ts1rjsb74	O1UPH5EFLET5TS1RJSB74	O1UPH5EFLET5TS1RJSB74	21	o1uPH5EflET5ts1RjSB74	o1uPH5EflET5ts1RjSB74	o1uPH5EflET5ts1RjSB74	o1uPH5EflET5ts1RjSB74a1U3DRA788kW7I0UTF203	>o1uPH5EflET5ts1RjSB74	o1uPH5EflET5ts1RjSB74<	o1a1
+Ix	x8dXlDbC3S44L1FQJqpwa	ix8dxldbc3s44l1fqjqpwa	IX8DXLDBC3S44L1FQJQPWA	IX8DXLDBC3S44L1FQJQPWA	22	Ix8dXlDbC3S44L1FQJqpwa	Ix8dXlDbC3S44L1FQJqpwa	Ix8dXlDbC3S44L1FQJqpwa	Ix8dXlDbC3S44L1FQJqpwa8wQR4X28CiccBVXGqPL7	>Ix8dXlDbC3S44L1FQJqpwa	Ix8dXlDbC3S44L1FQJqpwa<	Ix8w
+OT	Tn0Dj2HiBi05Baq1Xt	otn0dj2hibi05baq1xt	OTN0DJ2HIBI05BAQ1XT	OTN0DJ2HIBI05BAQ1XT	19	OTn0Dj2HiBi05Baq1Xt	OTn0Dj2HiBi05Baq1Xt	OTn0Dj2HiBi05Baq1Xt	OTn0Dj2HiBi05Baq1XtAoQ21J1lQ27kYSmfA	>OTn0Dj2HiBi05Baq1Xt	OTn0Dj2HiBi05Baq1Xt<	OTAo
+a0	0P3sn1ihxJCsTLDb	a0p3sn1ihxjcstldb	A0P3SN1IHXJCSTLDB	A0P3SN1IHXJCSTLDB	17	a0P3sn1ihxJCsTLDb	a0P3sn1ihxJCsTLDb	a0P3sn1ihxJCsTLDb	a0P3sn1ihxJCsTLDbfT4Jlw38k8kmd6Dt1wv	>a0P3sn1ihxJCsTLDb	a0P3sn1ihxJCsTLDb<	a0fT

Added: hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_distinct_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_distinct_2.q.out?rev=1629068&view=auto
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_distinct_2.q.out (added)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_distinct_2.q.out Thu Oct  2 20:58:53 2014
@@ -0,0 +1,1859 @@
+PREHOOK: query: create table vectortab2k(
+            t tinyint,
+            si smallint,
+            i int,
+            b bigint,
+            f float,
+            d double,
+            dc decimal(38,18),
+            bo boolean,
+            s string,
+            s2 string,
+            ts timestamp,
+            ts2 timestamp,
+            dt date)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vectortab2k
+POSTHOOK: query: create table vectortab2k(
+            t tinyint,
+            si smallint,
+            i int,
+            b bigint,
+            f float,
+            d double,
+            dc decimal(38,18),
+            bo boolean,
+            s string,
+            s2 string,
+            ts timestamp,
+            ts2 timestamp,
+            dt date)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@vectortab2k
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/vectortab2k' OVERWRITE INTO TABLE vectortab2k
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@vectortab2k
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/vectortab2k' OVERWRITE INTO TABLE vectortab2k
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@vectortab2k
+PREHOOK: query: create table vectortab2korc(
+            t tinyint,
+            si smallint,
+            i int,
+            b bigint,
+            f float,
+            d double,
+            dc decimal(38,18),
+            bo boolean,
+            s string,
+            s2 string,
+            ts timestamp,
+            ts2 timestamp,
+            dt date)
+STORED AS ORC
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vectortab2korc
+POSTHOOK: query: create table vectortab2korc(
+            t tinyint,
+            si smallint,
+            i int,
+            b bigint,
+            f float,
+            d double,
+            dc decimal(38,18),
+            bo boolean,
+            s string,
+            s2 string,
+            ts timestamp,
+            ts2 timestamp,
+            dt date)
+STORED AS ORC
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@vectortab2korc
+PREHOOK: query: INSERT INTO TABLE vectortab2korc SELECT * FROM vectortab2k
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vectortab2k
+PREHOOK: Output: default@vectortab2korc
+POSTHOOK: query: INSERT INTO TABLE vectortab2korc SELECT * FROM vectortab2k
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vectortab2k
+POSTHOOK: Output: default@vectortab2korc
+POSTHOOK: Lineage: vectortab2korc.b SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:b, type:bigint, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.bo SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:bo, type:boolean, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.d SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:d, type:double, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.dc SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:dc, type:decimal(38,18), comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.dt SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:dt, type:date, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.f SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:f, type:float, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.i SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:i, type:int, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.s SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:s, type:string, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.s2 SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:s2, type:string, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.si SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:si, type:smallint, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.t SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:t, type:tinyint, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.ts SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:ts, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.ts2 SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:ts2, type:timestamp, comment:null), ]
+PREHOOK: query: explain
+select distinct s, t from vectortab2korc
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select distinct s, t from vectortab2korc
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: vectortab2korc
+            Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+            Select Operator
+              expressions: s (type: string), t (type: tinyint)
+              outputColumnNames: s, t
+              Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+              Group By Operator
+                keys: s (type: string), t (type: tinyint)
+                mode: hash
+                outputColumnNames: _col0, _col1
+                Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+                Reduce Output Operator
+                  key expressions: _col0 (type: string), _col1 (type: tinyint)
+                  sort order: ++
+                  Map-reduce partition columns: _col0 (type: string), _col1 (type: tinyint)
+                  Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+      Execution mode: vectorized
+      Reduce Operator Tree:
+        Group By Operator
+          keys: KEY._col0 (type: string), KEY._col1 (type: tinyint)
+          mode: mergepartial
+          outputColumnNames: _col0, _col1
+          Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
+          Select Operator
+            expressions: _col0 (type: string), _col1 (type: tinyint)
+            outputColumnNames: _col0, _col1
+            Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
+            File Output Operator
+              compressed: false
+              Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: select distinct s, t from vectortab2korc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vectortab2korc
+#### A masked pattern was here ####
+POSTHOOK: query: select distinct s, t from vectortab2korc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vectortab2korc
+#### A masked pattern was here ####
+	NULL
+	-116
+	-114
+	-113
+	-108
+	-107
+	-104
+	-91
+	-87
+	-86
+	-85
+	-84
+	-83
+	-80
+	-75
+	-72
+	-66
+	-53
+	-46
+	-38
+	-36
+	-33
+	-29
+	-28
+	-25
+	-24
+	-19
+	-16
+	-14
+	-12
+	-10
+	-5
+	-4
+	-2
+	0
+	4
+	5
+	8
+	12
+	16
+	19
+	22
+	23
+	26
+	29
+	31
+	37
+	42
+	46
+	48
+	54
+	57
+	59
+	60
+	62
+	64
+	79
+	84
+	87
+	88
+	90
+	91
+	96
+	97
+	102
+	103
+	105
+	109
+	112
+	113
+	114
+	123
+american history	NULL
+american history	-127
+american history	-119
+american history	-116
+american history	-112
+american history	-110
+american history	-108
+american history	-105
+american history	-103
+american history	-101
+american history	-95
+american history	-94
+american history	-92
+american history	-90
+american history	-89
+american history	-87
+american history	-86
+american history	-81
+american history	-80
+american history	-73
+american history	-66
+american history	-60
+american history	-59
+american history	-55
+american history	-53
+american history	-50
+american history	-48
+american history	-47
+american history	-34
+american history	-30
+american history	-28
+american history	-27
+american history	-26
+american history	-19
+american history	-18
+american history	-17
+american history	-15
+american history	-11
+american history	-9
+american history	0
+american history	5
+american history	20
+american history	22
+american history	29
+american history	31
+american history	33
+american history	38
+american history	39
+american history	40
+american history	42
+american history	46
+american history	48
+american history	54
+american history	56
+american history	60
+american history	68
+american history	69
+american history	71
+american history	72
+american history	74
+american history	77
+american history	79
+american history	82
+american history	84
+american history	89
+american history	96
+american history	100
+american history	103
+american history	111
+american history	119
+american history	122
+american history	123
+biology	NULL
+biology	-127
+biology	-121
+biology	-120
+biology	-119
+biology	-104
+biology	-101
+biology	-98
+biology	-97
+biology	-96
+biology	-92
+biology	-90
+biology	-86
+biology	-85
+biology	-83
+biology	-82
+biology	-81
+biology	-79
+biology	-72
+biology	-67
+biology	-66
+biology	-59
+biology	-57
+biology	-54
+biology	-53
+biology	-49
+biology	-46
+biology	-44
+biology	-42
+biology	-40
+biology	-36
+biology	-35
+biology	-31
+biology	-20
+biology	-19
+biology	-16
+biology	-13
+biology	-7
+biology	-6
+biology	-5
+biology	0
+biology	2
+biology	3
+biology	4
+biology	5
+biology	6
+biology	7
+biology	8
+biology	12
+biology	18
+biology	27
+biology	30
+biology	34
+biology	35
+biology	36
+biology	41
+biology	47
+biology	51
+biology	52
+biology	54
+biology	55
+biology	57
+biology	64
+biology	83
+biology	86
+biology	89
+biology	90
+biology	91
+biology	100
+biology	111
+biology	113
+biology	114
+biology	115
+biology	117
+biology	120
+biology	124
+chemistry	NULL
+chemistry	-127
+chemistry	-125
+chemistry	-122
+chemistry	-117
+chemistry	-115
+chemistry	-110
+chemistry	-109
+chemistry	-108
+chemistry	-103
+chemistry	-101
+chemistry	-98
+chemistry	-95
+chemistry	-91
+chemistry	-90
+chemistry	-89
+chemistry	-81
+chemistry	-75
+chemistry	-68
+chemistry	-61
+chemistry	-59
+chemistry	-57
+chemistry	-56
+chemistry	-52
+chemistry	-46
+chemistry	-44
+chemistry	-40
+chemistry	-37
+chemistry	-33
+chemistry	-31
+chemistry	-30
+chemistry	-26
+chemistry	-23
+chemistry	-8
+chemistry	-3
+chemistry	-2
+chemistry	3
+chemistry	4
+chemistry	8
+chemistry	14
+chemistry	16
+chemistry	19
+chemistry	25
+chemistry	27
+chemistry	32
+chemistry	37
+chemistry	39
+chemistry	41
+chemistry	46
+chemistry	51
+chemistry	55
+chemistry	64
+chemistry	74
+chemistry	75
+chemistry	78
+chemistry	79
+chemistry	83
+chemistry	88
+chemistry	90
+chemistry	91
+chemistry	96
+chemistry	102
+chemistry	104
+chemistry	110
+chemistry	113
+chemistry	116
+chemistry	124
+chemistry	126
+debate	NULL
+debate	-127
+debate	-117
+debate	-114
+debate	-108
+debate	-106
+debate	-98
+debate	-96
+debate	-95
+debate	-88
+debate	-87
+debate	-86
+debate	-85
+debate	-82
+debate	-72
+debate	-70
+debate	-69
+debate	-67
+debate	-57
+debate	-52
+debate	-50
+debate	-47
+debate	-46
+debate	-41
+debate	-35
+debate	-32
+debate	-29
+debate	-28
+debate	-27
+debate	-26
+debate	-24
+debate	-15
+debate	-12
+debate	-3
+debate	5
+debate	17
+debate	19
+debate	20
+debate	26
+debate	34
+debate	36
+debate	41
+debate	42
+debate	52
+debate	54
+debate	56
+debate	63
+debate	67
+debate	68
+debate	69
+debate	70
+debate	73
+debate	75
+debate	77
+debate	85
+debate	87
+debate	89
+debate	90
+debate	93
+debate	94
+debate	113
+debate	124
+education	NULL
+education	-127
+education	-125
+education	-113
+education	-111
+education	-109
+education	-105
+education	-101
+education	-98
+education	-96
+education	-93
+education	-92
+education	-89
+education	-87
+education	-86
+education	-77
+education	-72
+education	-69
+education	-64
+education	-61
+education	-55
+education	-52
+education	-44
+education	-43
+education	-38
+education	-37
+education	-36
+education	-34
+education	-28
+education	-24
+education	-15
+education	-13
+education	-9
+education	4
+education	12
+education	17
+education	27
+education	33
+education	34
+education	35
+education	38
+education	41
+education	45
+education	46
+education	49
+education	51
+education	53
+education	59
+education	61
+education	66
+education	73
+education	75
+education	77
+education	81
+education	82
+education	85
+education	89
+education	95
+education	102
+education	103
+education	110
+education	111
+education	113
+education	114
+education	116
+education	119
+education	125
+forestry	NULL
+forestry	-126
+forestry	-118
+forestry	-116
+forestry	-109
+forestry	-105
+forestry	-98
+forestry	-95
+forestry	-94
+forestry	-83
+forestry	-81
+forestry	-80
+forestry	-79
+forestry	-77
+forestry	-74
+forestry	-73
+forestry	-68
+forestry	-58
+forestry	-51
+forestry	-50
+forestry	-49
+forestry	-42
+forestry	-34
+forestry	-23
+forestry	-12
+forestry	-11
+forestry	-10
+forestry	-8
+forestry	-3
+forestry	-1
+forestry	0
+forestry	7
+forestry	8
+forestry	11
+forestry	12
+forestry	19
+forestry	29
+forestry	31
+forestry	35
+forestry	37
+forestry	39
+forestry	40
+forestry	44
+forestry	45
+forestry	50
+forestry	51
+forestry	52
+forestry	55
+forestry	56
+forestry	71
+forestry	78
+forestry	79
+forestry	87
+forestry	90
+forestry	93
+forestry	94
+forestry	97
+forestry	102
+forestry	106
+forestry	107
+forestry	111
+forestry	115
+forestry	117
+forestry	120
+geology	NULL
+geology	-124
+geology	-117
+geology	-115
+geology	-112
+geology	-108
+geology	-106
+geology	-101
+geology	-100
+geology	-96
+geology	-94
+geology	-84
+geology	-82
+geology	-80
+geology	-79
+geology	-75
+geology	-72
+geology	-68
+geology	-59
+geology	-57
+geology	-54
+geology	-53
+geology	-50
+geology	-48
+geology	-35
+geology	-34
+geology	-32
+geology	-31
+geology	-30
+geology	-23
+geology	-21
+geology	-18
+geology	-16
+geology	1
+geology	4
+geology	5
+geology	6
+geology	9
+geology	14
+geology	18
+geology	21
+geology	23
+geology	26
+geology	28
+geology	31
+geology	33
+geology	37
+geology	38
+geology	49
+geology	58
+geology	72
+geology	82
+geology	84
+geology	86
+geology	89
+geology	92
+geology	93
+geology	95
+geology	100
+geology	101
+geology	102
+geology	116
+geology	121
+geology	124
+geology	127
+history	NULL
+history	-125
+history	-124
+history	-105
+history	-104
+history	-103
+history	-101
+history	-98
+history	-91
+history	-90
+history	-89
+history	-79
+history	-75
+history	-67
+history	-61
+history	-58
+history	-54
+history	-42
+history	-37
+history	-34
+history	-26
+history	-24
+history	-19
+history	-18
+history	-15
+history	-12
+history	-8
+history	-5
+history	-1
+history	1
+history	2
+history	7
+history	14
+history	18
+history	25
+history	50
+history	51
+history	52
+history	57
+history	58
+history	59
+history	61
+history	62
+history	71
+history	72
+history	73
+history	75
+history	78
+history	84
+history	92
+history	95
+history	98
+history	100
+history	108
+history	112
+history	113
+history	114
+history	126
+history	127
+industrial engineering	NULL
+industrial engineering	-124
+industrial engineering	-110
+industrial engineering	-101
+industrial engineering	-98
+industrial engineering	-96
+industrial engineering	-87
+industrial engineering	-85
+industrial engineering	-72
+industrial engineering	-68
+industrial engineering	-65
+industrial engineering	-58
+industrial engineering	-57
+industrial engineering	-53
+industrial engineering	-49
+industrial engineering	-47
+industrial engineering	-43
+industrial engineering	-38
+industrial engineering	-35
+industrial engineering	-31
+industrial engineering	-30
+industrial engineering	-28
+industrial engineering	-22
+industrial engineering	-11
+industrial engineering	-7
+industrial engineering	-6
+industrial engineering	-5
+industrial engineering	-1
+industrial engineering	3
+industrial engineering	7
+industrial engineering	27
+industrial engineering	29
+industrial engineering	32
+industrial engineering	33
+industrial engineering	36
+industrial engineering	42
+industrial engineering	43
+industrial engineering	48
+industrial engineering	54
+industrial engineering	58
+industrial engineering	59
+industrial engineering	70
+industrial engineering	73
+industrial engineering	78
+industrial engineering	79
+industrial engineering	83
+industrial engineering	95
+industrial engineering	96
+industrial engineering	98
+industrial engineering	99
+industrial engineering	102
+industrial engineering	104
+industrial engineering	105
+industrial engineering	106
+industrial engineering	113
+industrial engineering	126
+joggying	NULL
+joggying	-125
+joggying	-121
+joggying	-119
+joggying	-110
+joggying	-101
+joggying	-100
+joggying	-80
+joggying	-79
+joggying	-77
+joggying	-76
+joggying	-73
+joggying	-69
+joggying	-64
+joggying	-62
+joggying	-61
+joggying	-57
+joggying	-55
+joggying	-48
+joggying	-47
+joggying	-43
+joggying	-40
+joggying	-30
+joggying	-27
+joggying	-24
+joggying	-15
+joggying	-14
+joggying	-8
+joggying	-1
+joggying	13
+joggying	20
+joggying	25
+joggying	26
+joggying	27
+joggying	28
+joggying	37
+joggying	43
+joggying	46
+joggying	48
+joggying	49
+joggying	52
+joggying	57
+joggying	61
+joggying	62
+joggying	69
+joggying	70
+joggying	72
+joggying	74
+joggying	80
+joggying	85
+joggying	87
+joggying	92
+joggying	93
+joggying	94
+joggying	97
+joggying	99
+joggying	104
+joggying	105
+joggying	118
+joggying	119
+joggying	121
+joggying	123
+joggying	125
+kindergarten	NULL
+kindergarten	-126
+kindergarten	-113
+kindergarten	-106
+kindergarten	-98
+kindergarten	-95
+kindergarten	-92
+kindergarten	-79
+kindergarten	-78
+kindergarten	-75
+kindergarten	-74
+kindergarten	-69
+kindergarten	-60
+kindergarten	-59
+kindergarten	-57
+kindergarten	-54
+kindergarten	-42
+kindergarten	-40
+kindergarten	-26
+kindergarten	-18
+kindergarten	-8
+kindergarten	10
+kindergarten	16
+kindergarten	18
+kindergarten	19
+kindergarten	23
+kindergarten	29
+kindergarten	37
+kindergarten	46
+kindergarten	48
+kindergarten	51
+kindergarten	52
+kindergarten	55
+kindergarten	61
+kindergarten	66
+kindergarten	69
+kindergarten	82
+kindergarten	84
+kindergarten	85
+kindergarten	86
+kindergarten	90
+kindergarten	92
+kindergarten	96
+kindergarten	100
+kindergarten	101
+kindergarten	109
+kindergarten	111
+kindergarten	116
+kindergarten	118
+kindergarten	120
+kindergarten	122
+kindergarten	127
+linguistics	NULL
+linguistics	-127
+linguistics	-122
+linguistics	-113
+linguistics	-101
+linguistics	-90
+linguistics	-89
+linguistics	-87
+linguistics	-86
+linguistics	-78
+linguistics	-77
+linguistics	-73
+linguistics	-70
+linguistics	-69
+linguistics	-68
+linguistics	-67
+linguistics	-53
+linguistics	-52
+linguistics	-41
+linguistics	-34
+linguistics	-28
+linguistics	-22
+linguistics	-20
+linguistics	-17
+linguistics	-16
+linguistics	-14
+linguistics	-13
+linguistics	-12
+linguistics	-6
+linguistics	-4
+linguistics	-2
+linguistics	0
+linguistics	1
+linguistics	3
+linguistics	6
+linguistics	7
+linguistics	10
+linguistics	11
+linguistics	18
+linguistics	33
+linguistics	37
+linguistics	42
+linguistics	44
+linguistics	50
+linguistics	53
+linguistics	64
+linguistics	67
+linguistics	72
+linguistics	73
+linguistics	83
+linguistics	89
+linguistics	93
+linguistics	96
+linguistics	98
+linguistics	100
+linguistics	113
+linguistics	115
+linguistics	123
+linguistics	125
+linguistics	126
+mathematics	NULL
+mathematics	-127
+mathematics	-124
+mathematics	-122
+mathematics	-120
+mathematics	-118
+mathematics	-117
+mathematics	-103
+mathematics	-101
+mathematics	-100
+mathematics	-99
+mathematics	-98
+mathematics	-95
+mathematics	-91
+mathematics	-88
+mathematics	-81
+mathematics	-79
+mathematics	-77
+mathematics	-75
+mathematics	-66
+mathematics	-57
+mathematics	-52
+mathematics	-50
+mathematics	-49
+mathematics	-46
+mathematics	-45
+mathematics	-40
+mathematics	-33
+mathematics	-31
+mathematics	-21
+mathematics	-19
+mathematics	-7
+mathematics	0
+mathematics	3
+mathematics	6
+mathematics	10
+mathematics	22
+mathematics	23
+mathematics	25
+mathematics	32
+mathematics	35
+mathematics	38
+mathematics	39
+mathematics	46
+mathematics	48
+mathematics	50
+mathematics	53
+mathematics	55
+mathematics	56
+mathematics	58
+mathematics	59
+mathematics	62
+mathematics	63
+mathematics	65
+mathematics	76
+mathematics	79
+mathematics	80
+mathematics	82
+mathematics	87
+mathematics	92
+mathematics	98
+mathematics	102
+mathematics	107
+mathematics	111
+mathematics	114
+nap time	NULL
+nap time	-122
+nap time	-119
+nap time	-115
+nap time	-113
+nap time	-104
+nap time	-102
+nap time	-101
+nap time	-91
+nap time	-85
+nap time	-71
+nap time	-61
+nap time	-54
+nap time	-49
+nap time	-45
+nap time	-41
+nap time	-31
+nap time	-15
+nap time	-6
+nap time	-4
+nap time	-2
+nap time	0
+nap time	3
+nap time	6
+nap time	16
+nap time	23
+nap time	27
+nap time	31
+nap time	35
+nap time	42
+nap time	51
+nap time	52
+nap time	56
+nap time	62
+nap time	69
+nap time	70
+nap time	73
+nap time	76
+nap time	80
+nap time	89
+nap time	90
+nap time	92
+nap time	93
+nap time	98
+nap time	103
+nap time	104
+nap time	105
+nap time	107
+nap time	108
+nap time	118
+opthamology	NULL
+opthamology	-122
+opthamology	-121
+opthamology	-118
+opthamology	-111
+opthamology	-99
+opthamology	-97
+opthamology	-91
+opthamology	-86
+opthamology	-82
+opthamology	-79
+opthamology	-78
+opthamology	-77
+opthamology	-75
+opthamology	-73
+opthamology	-63
+opthamology	-59
+opthamology	-55
+opthamology	-49
+opthamology	-48
+opthamology	-44
+opthamology	-35
+opthamology	-33
+opthamology	-30
+opthamology	-28
+opthamology	-27
+opthamology	-24
+opthamology	-22
+opthamology	-18
+opthamology	-17
+opthamology	-14
+opthamology	-8
+opthamology	-5
+opthamology	4
+opthamology	5
+opthamology	21
+opthamology	39
+opthamology	41
+opthamology	48
+opthamology	49
+opthamology	52
+opthamology	53
+opthamology	55
+opthamology	68
+opthamology	69
+opthamology	74
+opthamology	76
+opthamology	77
+opthamology	79
+opthamology	81
+opthamology	84
+opthamology	87
+opthamology	88
+opthamology	89
+opthamology	92
+opthamology	96
+opthamology	97
+opthamology	100
+opthamology	104
+opthamology	117
+opthamology	120
+opthamology	122
+opthamology	125
+opthamology	127
+philosophy	NULL
+philosophy	-125
+philosophy	-121
+philosophy	-119
+philosophy	-115
+philosophy	-110
+philosophy	-105
+philosophy	-103
+philosophy	-100
+philosophy	-99
+philosophy	-95
+philosophy	-93
+philosophy	-92
+philosophy	-80
+philosophy	-78
+philosophy	-77
+philosophy	-69
+philosophy	-68
+philosophy	-61
+philosophy	-56
+philosophy	-55
+philosophy	-53
+philosophy	-52
+philosophy	-51
+philosophy	-50
+philosophy	-40
+philosophy	-39
+philosophy	-27
+philosophy	-26
+philosophy	-25
+philosophy	-17
+philosophy	-11
+philosophy	8
+philosophy	20
+philosophy	21
+philosophy	22
+philosophy	29
+philosophy	31
+philosophy	34
+philosophy	38
+philosophy	41
+philosophy	43
+philosophy	45
+philosophy	48
+philosophy	64
+philosophy	67
+philosophy	68
+philosophy	73
+philosophy	83
+philosophy	96
+philosophy	98
+philosophy	104
+philosophy	108
+philosophy	117
+philosophy	118
+philosophy	120
+philosophy	123
+quiet hour	NULL
+quiet hour	-127
+quiet hour	-123
+quiet hour	-121
+quiet hour	-119
+quiet hour	-114
+quiet hour	-111
+quiet hour	-105
+quiet hour	-104
+quiet hour	-88
+quiet hour	-87
+quiet hour	-76
+quiet hour	-73
+quiet hour	-68
+quiet hour	-66
+quiet hour	-65
+quiet hour	-56
+quiet hour	-55
+quiet hour	-52
+quiet hour	-50
+quiet hour	-48
+quiet hour	-45
+quiet hour	-42
+quiet hour	-41
+quiet hour	-33
+quiet hour	-31
+quiet hour	-25
+quiet hour	-14
+quiet hour	-8
+quiet hour	-1
+quiet hour	0
+quiet hour	6
+quiet hour	7
+quiet hour	8
+quiet hour	13
+quiet hour	21
+quiet hour	23
+quiet hour	29
+quiet hour	30
+quiet hour	33
+quiet hour	35
+quiet hour	38
+quiet hour	43
+quiet hour	58
+quiet hour	60
+quiet hour	66
+quiet hour	71
+quiet hour	74
+quiet hour	80
+quiet hour	82
+quiet hour	84
+quiet hour	93
+quiet hour	98
+quiet hour	110
+quiet hour	112
+quiet hour	115
+quiet hour	120
+quiet hour	121
+quiet hour	123
+religion	NULL
+religion	-125
+religion	-106
+religion	-104
+religion	-94
+religion	-93
+religion	-81
+religion	-78
+religion	-77
+religion	-76
+religion	-71
+religion	-70
+religion	-69
+religion	-64
+religion	-62
+religion	-60
+religion	-56
+religion	-44
+religion	-42
+religion	-41
+religion	-38
+religion	-35
+religion	-32
+religion	-29
+religion	-28
+religion	-26
+religion	-24
+religion	-23
+religion	-9
+religion	-7
+religion	-3
+religion	0
+religion	2
+religion	4
+religion	5
+religion	15
+religion	17
+religion	29
+religion	31
+religion	38
+religion	44
+religion	45
+religion	49
+religion	52
+religion	54
+religion	58
+religion	67
+religion	70
+religion	73
+religion	74
+religion	76
+religion	78
+religion	82
+religion	92
+religion	93
+religion	96
+religion	97
+religion	102
+religion	103
+religion	106
+religion	107
+religion	110
+religion	115
+religion	120
+religion	123
+religion	124
+study skills	NULL
+study skills	-127
+study skills	-126
+study skills	-117
+study skills	-107
+study skills	-106
+study skills	-100
+study skills	-88
+study skills	-86
+study skills	-82
+study skills	-81
+study skills	-76
+study skills	-73
+study skills	-65
+study skills	-52
+study skills	-36
+study skills	-33
+study skills	-27
+study skills	-26
+study skills	-22
+study skills	-17
+study skills	-14
+study skills	-13
+study skills	-6
+study skills	-5
+study skills	-4
+study skills	-3
+study skills	-1
+study skills	2
+study skills	3
+study skills	18
+study skills	21
+study skills	23
+study skills	25
+study skills	28
+study skills	29
+study skills	30
+study skills	35
+study skills	39
+study skills	40
+study skills	47
+study skills	49
+study skills	50
+study skills	54
+study skills	55
+study skills	58
+study skills	62
+study skills	63
+study skills	66
+study skills	68
+study skills	72
+study skills	77
+study skills	80
+study skills	83
+study skills	92
+study skills	95
+study skills	96
+study skills	101
+study skills	106
+study skills	107
+study skills	110
+study skills	115
+study skills	119
+study skills	123
+topology	NULL
+topology	-122
+topology	-116
+topology	-106
+topology	-105
+topology	-102
+topology	-98
+topology	-96
+topology	-88
+topology	-86
+topology	-78
+topology	-74
+topology	-71
+topology	-60
+topology	-58
+topology	-57
+topology	-50
+topology	-44
+topology	-42
+topology	-41
+topology	-36
+topology	-32
+topology	-31
+topology	-25
+topology	-21
+topology	-5
+topology	-1
+topology	7
+topology	11
+topology	13
+topology	14
+topology	18
+topology	26
+topology	30
+topology	38
+topology	41
+topology	42
+topology	47
+topology	50
+topology	52
+topology	54
+topology	55
+topology	58
+topology	59
+topology	61
+topology	63
+topology	67
+topology	69
+topology	71
+topology	80
+topology	81
+topology	83
+topology	86
+topology	87
+topology	94
+topology	105
+topology	107
+topology	119
+topology	121
+topology	127
+undecided	NULL
+undecided	-120
+undecided	-118
+undecided	-117
+undecided	-116
+undecided	-115
+undecided	-114
+undecided	-112
+undecided	-105
+undecided	-104
+undecided	-96
+undecided	-93
+undecided	-90
+undecided	-84
+undecided	-83
+undecided	-78
+undecided	-69
+undecided	-62
+undecided	-53
+undecided	-52
+undecided	-51
+undecided	-43
+undecided	-41
+undecided	-29
+undecided	-28
+undecided	-23
+undecided	-19
+undecided	-13
+undecided	-10
+undecided	-8
+undecided	0
+undecided	1
+undecided	7
+undecided	11
+undecided	13
+undecided	14
+undecided	27
+undecided	30
+undecided	33
+undecided	37
+undecided	45
+undecided	47
+undecided	50
+undecided	51
+undecided	56
+undecided	69
+undecided	76
+undecided	95
+undecided	97
+undecided	98
+undecided	111
+undecided	114
+undecided	119
+undecided	123
+undecided	124
+values clariffication	NULL
+values clariffication	-123
+values clariffication	-119
+values clariffication	-114
+values clariffication	-109
+values clariffication	-108
+values clariffication	-107
+values clariffication	-105
+values clariffication	-100
+values clariffication	-98
+values clariffication	-97
+values clariffication	-95
+values clariffication	-92
+values clariffication	-90
+values clariffication	-81
+values clariffication	-75
+values clariffication	-70
+values clariffication	-69
+values clariffication	-67
+values clariffication	-63
+values clariffication	-62
+values clariffication	-60
+values clariffication	-55
+values clariffication	-51
+values clariffication	-50
+values clariffication	-48
+values clariffication	-46
+values clariffication	-42
+values clariffication	-40
+values clariffication	-38
+values clariffication	-37
+values clariffication	-31
+values clariffication	-28
+values clariffication	-8
+values clariffication	-6
+values clariffication	-5
+values clariffication	4
+values clariffication	8
+values clariffication	9
+values clariffication	10
+values clariffication	12
+values clariffication	14
+values clariffication	15
+values clariffication	21
+values clariffication	23
+values clariffication	30
+values clariffication	32
+values clariffication	42
+values clariffication	50
+values clariffication	53
+values clariffication	56
+values clariffication	57
+values clariffication	62
+values clariffication	70
+values clariffication	74
+values clariffication	80
+values clariffication	85
+values clariffication	92
+values clariffication	93
+values clariffication	96
+values clariffication	97
+values clariffication	98
+values clariffication	108
+values clariffication	118
+values clariffication	120
+values clariffication	122
+values clariffication	124
+values clariffication	126
+values clariffication	127
+wind surfing	NULL
+wind surfing	-124
+wind surfing	-121
+wind surfing	-117
+wind surfing	-116
+wind surfing	-113
+wind surfing	-111
+wind surfing	-104
+wind surfing	-102
+wind surfing	-99
+wind surfing	-98
+wind surfing	-96
+wind surfing	-83
+wind surfing	-80
+wind surfing	-78
+wind surfing	-71
+wind surfing	-65
+wind surfing	-60
+wind surfing	-57
+wind surfing	-56
+wind surfing	-42
+wind surfing	-39
+wind surfing	-38
+wind surfing	-34
+wind surfing	-31
+wind surfing	-30
+wind surfing	-21
+wind surfing	-18
+wind surfing	-14
+wind surfing	-12
+wind surfing	-8
+wind surfing	-6
+wind surfing	-2
+wind surfing	5
+wind surfing	11
+wind surfing	15
+wind surfing	16
+wind surfing	20
+wind surfing	21
+wind surfing	22
+wind surfing	26
+wind surfing	29
+wind surfing	33
+wind surfing	36
+wind surfing	37
+wind surfing	40
+wind surfing	41
+wind surfing	44
+wind surfing	45
+wind surfing	48
+wind surfing	52
+wind surfing	53
+wind surfing	54
+wind surfing	58
+wind surfing	59
+wind surfing	62
+wind surfing	63
+wind surfing	64
+wind surfing	66
+wind surfing	68
+wind surfing	71
+wind surfing	75
+wind surfing	78
+wind surfing	86
+wind surfing	88
+wind surfing	92
+wind surfing	96
+wind surfing	101
+wind surfing	102
+wind surfing	107
+wind surfing	108
+wind surfing	111
+wind surfing	112
+wind surfing	121
+xylophone band	NULL
+xylophone band	-115
+xylophone band	-112
+xylophone band	-109
+xylophone band	-104
+xylophone band	-101
+xylophone band	-98
+xylophone band	-96
+xylophone band	-94
+xylophone band	-91
+xylophone band	-78
+xylophone band	-75
+xylophone band	-72
+xylophone band	-70
+xylophone band	-68
+xylophone band	-59
+xylophone band	-46
+xylophone band	-27
+xylophone band	-26
+xylophone band	-23
+xylophone band	-15
+xylophone band	-13
+xylophone band	-10
+xylophone band	-6
+xylophone band	-3
+xylophone band	-2
+xylophone band	0
+xylophone band	3
+xylophone band	6
+xylophone band	7
+xylophone band	9
+xylophone band	11
+xylophone band	14
+xylophone band	17
+xylophone band	19
+xylophone band	22
+xylophone band	23
+xylophone band	33
+xylophone band	36
+xylophone band	38
+xylophone band	40
+xylophone band	52
+xylophone band	60
+xylophone band	62
+xylophone band	77
+xylophone band	79
+xylophone band	84
+xylophone band	85
+xylophone band	88
+xylophone band	92
+xylophone band	94
+xylophone band	107
+xylophone band	108
+xylophone band	112
+xylophone band	118
+xylophone band	122
+xylophone band	123
+xylophone band	125
+xylophone band	127
+yard duty	NULL
+yard duty	-127
+yard duty	-115
+yard duty	-114
+yard duty	-109
+yard duty	-103
+yard duty	-102
+yard duty	-100
+yard duty	-98
+yard duty	-93
+yard duty	-91
+yard duty	-88
+yard duty	-86
+yard duty	-85
+yard duty	-82
+yard duty	-76
+yard duty	-62
+yard duty	-61
+yard duty	-57
+yard duty	-53
+yard duty	-51
+yard duty	-50
+yard duty	-49
+yard duty	-48
+yard duty	-46
+yard duty	-45
+yard duty	-44
+yard duty	-33
+yard duty	-28
+yard duty	-27
+yard duty	-21
+yard duty	-19
+yard duty	-17
+yard duty	-15
+yard duty	-1
+yard duty	8
+yard duty	9
+yard duty	10
+yard duty	15
+yard duty	18
+yard duty	22
+yard duty	25
+yard duty	28
+yard duty	30
+yard duty	34
+yard duty	42
+yard duty	48
+yard duty	53
+yard duty	55
+yard duty	57
+yard duty	60
+yard duty	64
+yard duty	65
+yard duty	78
+yard duty	86
+yard duty	90
+yard duty	102
+yard duty	105
+yard duty	110
+zync studies	NULL
+zync studies	-127
+zync studies	-117
+zync studies	-116
+zync studies	-111
+zync studies	-105
+zync studies	-103
+zync studies	-102
+zync studies	-94
+zync studies	-90
+zync studies	-83
+zync studies	-79
+zync studies	-78
+zync studies	-68
+zync studies	-61
+zync studies	-58
+zync studies	-57
+zync studies	-54
+zync studies	-52
+zync studies	-50
+zync studies	-45
+zync studies	-40
+zync studies	-39
+zync studies	-38
+zync studies	-37
+zync studies	-36
+zync studies	-35
+zync studies	-34
+zync studies	-33
+zync studies	-32
+zync studies	-27
+zync studies	-26
+zync studies	-21
+zync studies	-20
+zync studies	-12
+zync studies	1
+zync studies	7
+zync studies	9
+zync studies	11
+zync studies	15
+zync studies	19
+zync studies	31
+zync studies	37
+zync studies	48
+zync studies	59
+zync studies	63
+zync studies	70
+zync studies	87
+zync studies	90
+zync studies	91
+zync studies	98
+zync studies	99
+zync studies	100
+zync studies	116
+zync studies	120



Mime
View raw message