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
