hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject svn commit: r1625215 [2/2] - in /hive/branches/cbo: itests/qtest/testconfiguration.properties ql/src/test/results/clientpositive/tez/cbo_correctness.q.out
Date Tue, 16 Sep 2014 05:38:39 GMT

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 ...]


Mime
View raw message