You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/09/16 07:38:39 UTC
svn commit: r1625215 [2/2] - in /hive/branches/cbo:
itests/qtest/testconfiguration.properties
ql/src/test/results/clientpositive/tez/cbo_correctness.q.out
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out?rev=1625215&r1=1625214&r2=1625215&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out Tue Sep 16 05:38:39 2014
@@ -10,54 +10,48 @@ PREHOOK: query: drop table if exists t3
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table if exists t3
POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table if exists t4
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table if exists t4
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table t1(key string, value string, c_int int, c_float float, c_boolean boolean) row format delimited fields terminated by ',' STORED AS TEXTFILE
+PREHOOK: query: create table t1(key string, value string, c_int int, c_float float, c_boolean boolean) partitioned by (dt string) row format delimited fields terminated by ',' STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: create table t1(key string, value string, c_int int, c_float float, c_boolean boolean) row format delimited fields terminated by ',' STORED AS TEXTFILE
+PREHOOK: Output: default@t1
+POSTHOOK: query: create table t1(key string, value string, c_int int, c_float float, c_boolean boolean) partitioned by (dt string) row format delimited fields terminated by ',' STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
-PREHOOK: query: create table t2(key string, value string, c_int int, c_float float, c_boolean boolean) row format delimited fields terminated by ',' STORED AS TEXTFILE
+PREHOOK: query: create table t2(key string, value string, c_int int, c_float float, c_boolean boolean) partitioned by (dt string) row format delimited fields terminated by ',' STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: create table t2(key string, value string, c_int int, c_float float, c_boolean boolean) row format delimited fields terminated by ',' STORED AS TEXTFILE
+PREHOOK: Output: default@t2
+POSTHOOK: query: create table t2(key string, value string, c_int int, c_float float, c_boolean boolean) partitioned by (dt string) row format delimited fields terminated by ',' STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: create table t3(key string, value string, c_int int, c_float float, c_boolean boolean) row format delimited fields terminated by ',' STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t3
POSTHOOK: query: create table t3(key string, value string, c_int int, c_float float, c_boolean boolean) row format delimited fields terminated by ',' STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@t3
-PREHOOK: query: create table t4(key string, value string, c_int int, c_float float, c_boolean boolean) row format delimited fields terminated by ',' STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-POSTHOOK: query: create table t4(key string, value string, c_int int, c_float float, c_boolean boolean) row format delimited fields terminated by ',' STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@t4
-PREHOOK: query: load data local inpath '../../data/files/cbo_t1.txt' into table t1
+PREHOOK: query: load data local inpath '../../data/files/cbo_t1.txt' into table t1 partition (dt='2014')
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@t1
-POSTHOOK: query: load data local inpath '../../data/files/cbo_t1.txt' into table t1
+POSTHOOK: query: load data local inpath '../../data/files/cbo_t1.txt' into table t1 partition (dt='2014')
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@t1
-PREHOOK: query: load data local inpath '../../data/files/cbo_t2.txt' into table t2
+POSTHOOK: Output: default@t1@dt=2014
+PREHOOK: query: load data local inpath '../../data/files/cbo_t2.txt' into table t2 partition (dt='2014')
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@t2
-POSTHOOK: query: load data local inpath '../../data/files/cbo_t2.txt' into table t2
+POSTHOOK: query: load data local inpath '../../data/files/cbo_t2.txt' into table t2 partition (dt='2014')
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@t2
+POSTHOOK: Output: default@t2@dt=2014
PREHOOK: query: load data local inpath '../../data/files/cbo_t3.txt' into table t3
PREHOOK: type: LOAD
#### A masked pattern was here ####
@@ -66,45 +60,149 @@ POSTHOOK: query: load data local inpath
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@t3
-PREHOOK: query: load data local inpath '../../data/files/cbo_t4.txt' into table t4
+PREHOOK: query: CREATE TABLE part(
+ p_partkey INT,
+ p_name STRING,
+ p_mfgr STRING,
+ p_brand STRING,
+ p_type STRING,
+ p_size INT,
+ p_container STRING,
+ p_retailprice DOUBLE,
+ p_comment STRING
+)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@part
+POSTHOOK: query: CREATE TABLE part(
+ p_partkey INT,
+ p_name STRING,
+ p_mfgr STRING,
+ p_brand STRING,
+ p_type STRING,
+ p_size INT,
+ p_container STRING,
+ p_retailprice DOUBLE,
+ p_comment STRING
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@part
+PREHOOK: query: DROP TABLE lineitem
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE lineitem
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE lineitem (L_ORDERKEY INT,
+ L_PARTKEY INT,
+ L_SUPPKEY INT,
+ L_LINENUMBER INT,
+ L_QUANTITY DOUBLE,
+ L_EXTENDEDPRICE DOUBLE,
+ L_DISCOUNT DOUBLE,
+ L_TAX DOUBLE,
+ L_RETURNFLAG STRING,
+ L_LINESTATUS STRING,
+ l_shipdate STRING,
+ L_COMMITDATE STRING,
+ L_RECEIPTDATE STRING,
+ L_SHIPINSTRUCT STRING,
+ L_SHIPMODE STRING,
+ L_COMMENT STRING)
+ROW FORMAT DELIMITED
+FIELDS TERMINATED BY '|'
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@lineitem
+POSTHOOK: query: CREATE TABLE lineitem (L_ORDERKEY INT,
+ L_PARTKEY INT,
+ L_SUPPKEY INT,
+ L_LINENUMBER INT,
+ L_QUANTITY DOUBLE,
+ L_EXTENDEDPRICE DOUBLE,
+ L_DISCOUNT DOUBLE,
+ L_TAX DOUBLE,
+ L_RETURNFLAG STRING,
+ L_LINESTATUS STRING,
+ l_shipdate STRING,
+ L_COMMITDATE STRING,
+ L_RECEIPTDATE STRING,
+ L_SHIPINSTRUCT STRING,
+ L_SHIPMODE STRING,
+ L_COMMENT STRING)
+ROW FORMAT DELIMITED
+FIELDS TERMINATED BY '|'
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@lineitem
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/lineitem.txt' OVERWRITE INTO TABLE lineitem
PREHOOK: type: LOAD
#### A masked pattern was here ####
-PREHOOK: Output: default@t4
-POSTHOOK: query: load data local inpath '../../data/files/cbo_t4.txt' into table t4
+PREHOOK: Output: default@lineitem
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/lineitem.txt' OVERWRITE INTO TABLE lineitem
POSTHOOK: type: LOAD
#### A masked pattern was here ####
-POSTHOOK: Output: default@t4
-PREHOOK: query: analyze table t1 compute statistics
+POSTHOOK: Output: default@lineitem
+PREHOOK: query: create table src_cbo as select * from src
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_cbo
+POSTHOOK: query: create table src_cbo as select * from src
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@src_cbo
+PREHOOK: query: analyze table t1 partition (dt) compute statistics
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Output: default@t1
-POSTHOOK: query: analyze table t1 compute statistics
+PREHOOK: Output: default@t1@dt=2014
+POSTHOOK: query: analyze table t1 partition (dt) compute statistics
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Output: default@t1
+POSTHOOK: Output: default@t1@dt=2014
PREHOOK: query: analyze table t1 compute statistics for columns key, value, c_int, c_float, c_boolean
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: analyze table t1 compute statistics for columns key, value, c_int, c_float, c_boolean
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-PREHOOK: query: analyze table t2 compute statistics
+PREHOOK: query: analyze table t2 partition (dt) compute statistics
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Output: default@t2
-POSTHOOK: query: analyze table t2 compute statistics
+PREHOOK: Output: default@t2@dt=2014
+POSTHOOK: query: analyze table t2 partition (dt) compute statistics
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Output: default@t2
+POSTHOOK: Output: default@t2@dt=2014
PREHOOK: query: analyze table t2 compute statistics for columns key, value, c_int, c_float, c_boolean
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: analyze table t2 compute statistics for columns key, value, c_int, c_float, c_boolean
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
PREHOOK: query: analyze table t3 compute statistics
PREHOOK: type: QUERY
@@ -122,115 +220,155 @@ POSTHOOK: query: analyze table t3 comput
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
-PREHOOK: query: analyze table t4 compute statistics
+PREHOOK: query: analyze table src_cbo compute statistics
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_cbo
+PREHOOK: Output: default@src_cbo
+POSTHOOK: query: analyze table src_cbo compute statistics
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_cbo
+POSTHOOK: Output: default@src_cbo
+PREHOOK: query: analyze table src_cbo compute statistics for columns
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_cbo
+#### A masked pattern was here ####
+POSTHOOK: query: analyze table src_cbo compute statistics for columns
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_cbo
+#### A masked pattern was here ####
+PREHOOK: query: analyze table part compute statistics
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+PREHOOK: Output: default@part
+POSTHOOK: query: analyze table part compute statistics
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+POSTHOOK: Output: default@part
+PREHOOK: query: analyze table part compute statistics for columns
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: analyze table part compute statistics for columns
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+PREHOOK: query: analyze table lineitem compute statistics
PREHOOK: type: QUERY
-PREHOOK: Input: default@t4
-PREHOOK: Output: default@t4
-POSTHOOK: query: analyze table t4 compute statistics
+PREHOOK: Input: default@lineitem
+PREHOOK: Output: default@lineitem
+POSTHOOK: query: analyze table lineitem compute statistics
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t4
-POSTHOOK: Output: default@t4
-PREHOOK: query: analyze table t4 compute statistics for columns key, value, c_int, c_float, c_boolean
+POSTHOOK: Input: default@lineitem
+POSTHOOK: Output: default@lineitem
+PREHOOK: query: analyze table lineitem compute statistics for columns
PREHOOK: type: QUERY
-PREHOOK: Input: default@t4
+PREHOOK: Input: default@lineitem
#### A masked pattern was here ####
-POSTHOOK: query: analyze table t4 compute statistics for columns key, value, c_int, c_float, c_boolean
+POSTHOOK: query: analyze table lineitem compute statistics for columns
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t4
+POSTHOOK: Input: default@lineitem
#### A masked pattern was here ####
PREHOOK: query: -- 1. Test Select + TS
select * from t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: -- 1. Test Select + TS
select * from t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
-null null NULL NULL NULL
-null null NULL NULL NULL
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
+null null NULL NULL NULL 2014
+null null NULL NULL NULL 2014
PREHOOK: query: select * from t1 as t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from t1 as t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
-null null NULL NULL NULL
-null null NULL NULL NULL
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
+null null NULL NULL NULL 2014
+null null NULL NULL NULL 2014
PREHOOK: query: select * from t1 as t2
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from t1 as t2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
-null null NULL NULL NULL
-null null NULL NULL NULL
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
+null null NULL NULL NULL 2014
+null null NULL NULL NULL 2014
PREHOOK: query: select t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
1 1 25.0
1 1 25.0
@@ -256,89 +394,97 @@ PREHOOK: query: -- 2. Test Select + TS +
select * from t1 where t1.c_int >= 0
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: -- 2. Test Select + TS + FIL
select * from t1 where t1.c_int >= 0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select * from t1 as t1 where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from t1 as t1 where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
1 1 25.0
1 1 25.0
@@ -362,89 +508,97 @@ PREHOOK: query: -- 3 Test Select + Selec
select * from (select * from t1 where t1.c_int >= 0) as t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: -- 3 Test Select + Select + TS + FIL
select * from (select * from t1 where t1.c_int >= 0) as t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select * from (select * from t1 as t1 where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from (select * from t1 as t1 where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select * from (select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from (select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select * from (select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from (select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
1 1 25.0
1 1 25.0
@@ -467,88 +621,96 @@ POSTHOOK: Input: default@t1
PREHOOK: query: select * from (select * from t1 where t1.c_int >= 0) as t1 where t1.c_int >= 0
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from (select * from t1 where t1.c_int >= 0) as t1 where t1.c_int >= 0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select * from (select * from t1 as t1 where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1 where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from (select * from t1 as t1 where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1 where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select * from (select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from (select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
- 1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 true
-1 1 1 1.0 false
-1 1 1 1.0 false
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+ 1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 true 2014
+1 1 1 1.0 false 2014
+1 1 1 1.0 false 2014
PREHOOK: query: select * from (select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1 where t1.c_int >= 0 and y+c_int >= 0 or x <= 100
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select * from (select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1 where t1.c_int >= 0 and y+c_int >= 0 or x <= 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
1 1 25.0
1 1 25.0
@@ -571,10 +733,12 @@ POSTHOOK: Input: default@t1
PREHOOK: query: select t1.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from t1 where t1.c_int >= 0) as t1 where t1.c_int >= 0
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select t1.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from t1 where t1.c_int >= 0) as t1 where t1.c_int >= 0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
2.0 1 25.0
2.0 1 25.0
@@ -597,10 +761,12 @@ POSTHOOK: Input: default@t1
PREHOOK: query: select t2.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from t1 where t1.c_int >= 0) as t2 where t2.c_int >= 0
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select t2.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from t1 where t1.c_int >= 0) as t2 where t2.c_int >= 0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
2.0 1 25.0
2.0 1 25.0
@@ -624,13 +790,17 @@ PREHOOK: query: -- 4. Test Select + Join
select t1.c_int, t2.c_int from t1 join t2 on t1.key=t2.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: -- 4. Test Select + Join + TS
select t1.c_int, t2.c_int from t1 join t2 on t1.key=t2.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
1 1
1 1
@@ -732,16 +902,58 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
-PREHOOK: query: select t1.c_int from t1 left semi join t2 on t1.key=t2.key
+PREHOOK: query: select t1.key from t1 join t3
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
+PREHOOK: Input: default@t1@dt=2014
+PREHOOK: Input: default@t3
#### A masked pattern was here ####
-POSTHOOK: query: select t1.c_int from t1 left semi join t2 on t1.key=t2.key
+POSTHOOK: query: select t1.key from t1 join t3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t1@dt=2014
+POSTHOOK: Input: default@t3
#### A masked pattern was here ####
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
+null
1
1
1
@@ -760,242 +972,571 @@ POSTHOOK: Input: default@t2
1
1
1
-NULL
-NULL
-PREHOOK: query: select t1.c_int, t2.c_int from t1 left outer join t2 on t1.key=t2.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.c_int, t2.c_int from t1 left outer join t2 on t1.key=t2.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-#### A masked pattern was here ####
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-NULL NULL
-NULL NULL
-NULL NULL
-NULL NULL
-PREHOOK: query: select t1.c_int, t2.c_int from t1 right outer join t2 on t1.key=t2.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.c_int, t2.c_int from t1 right outer join t2 on t1.key=t2.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-#### A masked pattern was here ####
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-NULL 2
-NULL 2
-NULL 2
-NULL 2
-NULL 2
-NULL NULL
-NULL NULL
-NULL NULL
-NULL NULL
-PREHOOK: query: select t1.c_int, t2.c_int from t1 full outer join t2 on t1.key=t2.key
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+PREHOOK: query: select t1.key from t1 join t3 where t1.key=t3.key and t1.key >= 1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
+PREHOOK: Input: default@t1@dt=2014
+PREHOOK: Input: default@t3
#### A masked pattern was here ####
-POSTHOOK: query: select t1.c_int, t2.c_int from t1 full outer join t2 on t1.key=t2.key
+POSTHOOK: query: select t1.key from t1 join t3 where t1.key=t3.key and t1.key >= 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t1@dt=2014
+POSTHOOK: Input: default@t3
+#### A masked pattern was here ####
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+ 1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+PREHOOK: query: select t1.c_int, t2.c_int from t1 left outer join t2 on t1.key=t2.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.c_int, t2.c_int from t1 left outer join t2 on t1.key=t2.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
+#### A masked pattern was here ####
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+PREHOOK: query: select t1.c_int, t2.c_int from t1 right outer join t2 on t1.key=t2.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.c_int, t2.c_int from t1 right outer join t2 on t1.key=t2.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
1 1
1 1
@@ -1077,22 +1618,22 @@ POSTHOOK: Input: default@t2
1 1
1 1
1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
-1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
NULL 2
NULL 2
NULL 2
@@ -1102,60 +1643,183 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
-PREHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+PREHOOK: query: select t1.c_int, t2.c_int from t1 full outer join t2 on t1.key=t2.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
-PREHOOK: Input: default@t3
+PREHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
-POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+POSTHOOK: query: select t1.c_int, t2.c_int from t1 full outer join t2 on t1.key=t2.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
-POSTHOOK: Input: default@t3
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
-1 1.0 1 1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+NULL 2
+NULL 2
+NULL 2
+NULL 2
+NULL 2
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+PREHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
+POSTHOOK: Input: default@t3
+#### A masked pattern was here ####
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
+1 1.0 1 1 1
1 1.0 1 1 1
1 1.0 1 1 1
1 1.0 1 1 1
@@ -1653,13 +2317,17 @@ NULL NULL null NULL NULL
PREHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1
@@ -2201,13 +2869,17 @@ null NULL null NULL
PREHOOK: query: select a, t1.b, key, t2.c_int, t3.p from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=key join (select key as p, c_int as q, t3.c_float as r from t3)t3 on t1.a=t3.p
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select a, t1.b, key, t2.c_int, t3.p from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=key join (select key as p, c_int as q, t3.c_float as r from t3)t3 on t1.a=t3.p
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1 1
@@ -2749,13 +3421,17 @@ null NULL null NULL null
PREHOOK: query: select b, t1.c, t2.c_int, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=t2.key join t3 on t1.a=t3.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select b, t1.c, t2.c_int, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=t2.key join t3 on t1.a=t3.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1.0 1 1
@@ -3297,13 +3973,17 @@ NULL NULL NULL NULL
PREHOOK: query: select t3.c_int, b, t2.c_int, t1.c from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=t2.key join t3 on t1.a=t3.key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select t3.c_int, b, t2.c_int, t1.c from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=t2.key join t3 on t1.a=t3.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0
@@ -3845,13 +4525,17 @@ NULL NULL NULL NULL
PREHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1.0 1 1 1
@@ -4393,13 +5077,17 @@ NULL NULL null NULL NULL
PREHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p left outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p left outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1
@@ -4941,13 +5629,17 @@ null NULL null NULL
PREHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1.0 1 1 1
@@ -5489,13 +6181,17 @@ NULL NULL null NULL NULL
PREHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p right outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p right outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1
@@ -6043,13 +6739,17 @@ null NULL null NULL
PREHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1.0 1 1 1
@@ -6591,13 +7291,17 @@ NULL NULL null NULL NULL
PREHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p full outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p full outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1
@@ -7143,16 +7847,20 @@ null NULL null NULL
null NULL null NULL
null NULL null NULL
PREHOOK: query: -- 5. Test Select + Join + FIL + TS
-select t1.c_int, t2.c_int from t1 join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
+select t1.c_int, t2.c_int from t1 join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: -- 5. Test Select + Join + FIL + TS
-select t1.c_int, t2.c_int from t1 join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
+select t1.c_int, t2.c_int from t1 join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
1 1
1 1
@@ -7250,43 +7958,19 @@ POSTHOOK: Input: default@t2
1 1
1 1
1 1
-PREHOOK: query: select t1.c_int from t1 left semi join t2 on t1.key=t2.key where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.c_int from t1 left semi join t2 on t1.key=t2.key where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-#### A masked pattern was here ####
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
PREHOOK: query: select t1.c_int, t2.c_int from t1 left outer join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select t1.c_int, t2.c_int from t1 left outer join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
1 1
1 1
@@ -7387,12 +8071,16 @@ POSTHOOK: Input: default@t2
PREHOOK: query: select t1.c_int, t2.c_int from t1 right outer join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select t1.c_int, t2.c_int from t1 right outer join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
1 1
1 1
@@ -7493,12 +8181,16 @@ POSTHOOK: Input: default@t2
PREHOOK: query: select t1.c_int, t2.c_int from t1 full outer join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select t1.c_int, t2.c_int from t1 full outer join t2 on t1.key=t2.key where (t1.c_int + t2.c_int == 2) and (t1.c_int > 0 or t2.c_float >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
1 1
1 1
@@ -7599,13 +8291,17 @@ POSTHOOK: Input: default@t2
PREHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or t2.q >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or t2.q >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1.0 1 1 1
@@ -8139,13 +8835,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -8679,13 +9379,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -9219,13 +9923,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -9759,13 +10467,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -10296,334 +11008,20 @@ POSTHOOK: Input: default@t3
1 1 1 1.0 1
1 1 1 1.0 1
1 1 1 1.0 1
-PREHOOK: query: select * from (select c, b, a from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left semi join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left semi join t3 on t1.a=key where (b + 1 == 2) and (b > 0 or c >= 0)) R where (b + 1 = 2) and (R.b > 0 or c >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-PREHOOK: Input: default@t3
-#### A masked pattern was here ####
-POSTHOOK: query: select * from (select c, b, a from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left semi join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left semi join t3 on t1.a=key where (b + 1 == 2) and (b > 0 or c >= 0)) R where (b + 1 = 2) and (R.b > 0 or c >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-POSTHOOK: Input: default@t3
-#### A masked pattern was here ####
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-1.0 1 1
-PREHOOK: query: select * from (select t3.c_int, t1.c, b from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 = 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left semi join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t3.c_int == 2) and (b > 0 or c_int >= 0)) R where (R.c_int + 1 = 2) and (R.b > 0 or c_int >= 0)
+PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
-POSTHOOK: query: select * from (select t3.c_int, t1.c, b from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 = 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left semi join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t3.c_int == 2) and (b > 0 or c_int >= 0)) R where (R.c_int + 1 = 2) and (R.b > 0 or c_int >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-POSTHOOK: Input: default@t3
-#### A masked pattern was here ####
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-1 1.0 1
-PREHOOK: query: select * from (select c_int, b, t1.c from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left semi join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p right outer join t3 on t1.a=key where (b + 1 == 2) and (b > 0 or c_int >= 0)) R where (c + 1 = 2) and (R.b > 0 or c_int >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-PREHOOK: Input: default@t3
-#### A masked pattern was here ####
-POSTHOOK: query: select * from (select c_int, b, t1.c from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left semi join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p right outer join t3 on t1.a=key where (b + 1 == 2) and (b > 0 or c_int >= 0)) R where (c + 1 = 2) and (R.b > 0 or c_int >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-POSTHOOK: Input: default@t3
-#### A masked pattern was here ####
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-PREHOOK: query: select * from (select c_int, b, t1.c from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left semi join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p full outer join t3 on t1.a=key where (b + 1 == 2) and (b > 0 or c_int >= 0)) R where (c + 1 = 2) and (R.b > 0 or c_int >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-PREHOOK: Input: default@t3
-#### A masked pattern was here ####
-POSTHOOK: query: select * from (select c_int, b, t1.c from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left semi join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p full outer join t3 on t1.a=key where (b + 1 == 2) and (b > 0 or c_int >= 0)) R where (c + 1 = 2) and (R.b > 0 or c_int >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-POSTHOOK: Input: default@t3
-#### A masked pattern was here ####
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-1 1 1.0
-PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-PREHOOK: Input: default@t3
-#### A masked pattern was here ####
-POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
+POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -11157,13 +11555,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p right outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p right outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -11697,13 +12099,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p full outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p full outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -12237,13 +12643,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p right outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p right outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -12777,13 +13187,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -13317,13 +13731,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p full outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p full outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -13857,13 +14275,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p full outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p full outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -14397,13 +14819,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -14937,13 +15363,17 @@ POSTHOOK: Input: default@t3
PREHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p right outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
PREHOOK: Input: default@t3
#### A masked pattern was here ####
POSTHOOK: query: select * from (select q, b, t2.p, t1.c, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1 where (t1.c_int + 1 == 2) and (t1.c_int > 0 or t1.c_float >= 0)) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2 where (t2.c_int + 1 == 2) and (t2.c_int > 0 or t2.c_float >= 0)) t2 on t1.a=p right outer join t3 on t1.a=key where (b + t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1 1 1 1.0 1
@@ -15478,471 +15908,3055 @@ PREHOOK: query: -- 6. Test Select + TS +
select * from t1 group by c_int
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: -- 6. Test Select + TS + Join + Fil + GB + GB Having
select * from t1 group by c_int
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
NULL
1
-PREHOOK: query: select key, (c_int+1)+2 as x, sum(c_int) from t1 group by c_float, t1.c_int, key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-#### A masked pattern was here ####
-POSTHOOK: query: select key, (c_int+1)+2 as x, sum(c_int) from t1 group by c_float, t1.c_int, key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-#### A masked pattern was here ####
-null NULL NULL
- 1 4 2
- 1 4 2
-1 4 12
-1 4 2
-PREHOOK: query: select * from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from t1 group by c_float, t1.c_int, key) R group by y, x
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from t1 group by c_float, t1.c_int, key) R group by y, x
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-#### A masked pattern was here ####
-NULL NULL
-2 5.0
-12 5.0
-PREHOOK: query: select * from (select key as a, c_int+1 as b, sum(c_int) as c from t1 where (t1.c_int + 1 >= 0) and (t1.c_int > 0 or t1.c_float >= 0) group by c_float, t1.c_int, key order by a) t1 join (select key as p, c_int+1 as q, sum(c_int) as r from t2 where (t2.c_int + 1 >= 0) and (t2.c_int > 0 or t2.c_float >= 0) group by c_float, t2.c_int, key order by q/10 desc, r asc) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q >= 0) and (b > 0 or c_int >= 0) group by t3.c_int, c order by t3.c_int+c desc, c
+PREHOOK: query: select key, (c_int+1)+2 as x, sum(c_int) from t1 group by c_float, t1.c_int, key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
+#### A masked pattern was here ####
+POSTHOOK: query: select key, (c_int+1)+2 as x, sum(c_int) from t1 group by c_float, t1.c_int, key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
+#### A masked pattern was here ####
+null NULL NULL
+ 1 4 2
+ 1 4 2
+1 4 12
+1 4 2
+PREHOOK: query: select * from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from t1 group by c_float, t1.c_int, key) R group by y, x
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from t1 group by c_float, t1.c_int, key) R group by y, x
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
+#### A masked pattern was here ####
+NULL NULL
+2 5.0
+12 5.0
+PREHOOK: query: select * from (select key as a, c_int+1 as b, sum(c_int) as c from t1 where (t1.c_int + 1 >= 0) and (t1.c_int > 0 or t1.c_float >= 0) group by c_float, t1.c_int, key order by a) t1 join (select key as p, c_int+1 as q, sum(c_int) as r from t2 where (t2.c_int + 1 >= 0) and (t2.c_int > 0 or t2.c_float >= 0) group by c_float, t2.c_int, key order by q/10 desc, r asc) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q >= 0) and (b > 0 or c_int >= 0) group by t3.c_int, c order by t3.c_int+c desc, c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select key as a, c_int+1 as b, sum(c_int) as c from t1 where (t1.c_int + 1 >= 0) and (t1.c_int > 0 or t1.c_float >= 0) group by c_float, t1.c_int, key order by a) t1 join (select key as p, c_int+1 as q, sum(c_int) as r from t2 where (t2.c_int + 1 >= 0) and (t2.c_int > 0 or t2.c_float >= 0) group by c_float, t2.c_int, key order by q/10 desc, r asc) t2 on t1.a=p join t3 on t1.a=key where (b + t2.q >= 0) and (b > 0 or c_int >= 0) group by t3.c_int, c order by t3.c_int+c desc, c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
+POSTHOOK: Input: default@t3
+#### A masked pattern was here ####
+1 12
+1 2
+PREHOOK: query: select * from (select key as a, c_int+1 as b, sum(c_int) as c from t1 where (t1.c_int + 1 >= 0) and (t1.c_int > 0 or t1.c_float >= 0) group by c_float, t1.c_int, key having t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b % c asc, b desc) t1 left outer join (select key as p, c_int+1 as q, sum(c_int) as r from t2 where (t2.c_int + 1 >= 0) and (t2.c_int > 0 or t2.c_float >= 0) group by c_float, t2.c_int, key having t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) t2 on t1.a=p left outer join t3 on t1.a=key where (b + t2.q >= 0) and (b > 0 or c_int >= 0) group by t3.c_int, c having t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0 order by t3.c_int % c asc, t3.c_int desc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
[... 3314 lines stripped ...]