You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by go...@apache.org on 2014/10/02 22:53:35 UTC
svn commit: r1629067 [10/11] - in /hive/trunk: 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/clientpositive/tez/
Added: hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out?rev=1629067&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out Thu Oct 2 20:53:34 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/trunk/ql/src/test/results/clientpositive/tez/vectorized_rcfile_columnar.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_rcfile_columnar.q.out?rev=1629067&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_rcfile_columnar.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_rcfile_columnar.q.out Thu Oct 2 20:53:34 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/trunk/ql/src/test/results/clientpositive/tez/vectorized_string_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_string_funcs.q.out?rev=1629067&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_string_funcs.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_string_funcs.q.out Thu Oct 2 20:53:34 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/trunk/ql/src/test/results/clientpositive/vector_distinct_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_distinct_2.q.out?rev=1629067&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_distinct_2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_distinct_2.q.out Thu Oct 2 20:53:34 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