You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/08/13 19:37:25 UTC
svn commit: r1617777 [2/2] - in /hive/branches/cbo/ql/src:
java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
test/queries/clientpositive/cbo_correctness.q
test/results/clientpositive/cbo_correctness.q.out
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out?rev=1617777&r1=1617776&r2=1617777&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out Wed Aug 13 17:37:24 2014
@@ -10,21 +10,17 @@ 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
+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
+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
@@ -35,29 +31,24 @@ POSTHOOK: query: create table t3(key str
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 +57,49 @@ 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: 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
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@t4
-PREHOOK: query: analyze table t1 compute statistics
+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 +117,107 @@ 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: type: QUERY
-PREHOOK: Input: default@t4
-PREHOOK: Output: default@t4
-POSTHOOK: query: analyze table t4 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
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t4
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table t4 compute statistics for columns key, value, c_int, c_float, c_boolean
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t4
-#### 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 +243,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 +357,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 +470,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 +582,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 +610,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 +639,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
@@ -735,12 +754,16 @@ NULL NULL
PREHOOK: query: select t1.c_int from t1 left semi 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 from t1 left semi 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
@@ -765,12 +788,16 @@ 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@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
@@ -875,12 +902,16 @@ 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
@@ -990,12 +1021,16 @@ NULL NULL
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@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
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
@@ -1105,13 +1140,17 @@ 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
@@ -1653,13 +1692,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 +2244,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 +2796,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 +3348,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 +3900,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 +4452,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 +5004,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 +5556,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 +6114,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 +6666,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
@@ -7146,13 +7225,17 @@ PREHOOK: query: -- 5. Test Select + Join
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)
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
@@ -7253,12 +7336,16 @@ POSTHOOK: Input: default@t2
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@t1@dt=2014
PREHOOK: Input: default@t2
+PREHOOK: Input: default@t2@dt=2014
#### 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@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
#### A masked pattern was here ####
1
1
@@ -7281,12 +7368,16 @@ POSTHOOK: Input: default@t2
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 +7478,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 +7588,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 +7698,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 +8242,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 +8786,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 +9330,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 +9874,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
@@ -10299,13 +10418,17 @@ POSTHOOK: Input: default@t3
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@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 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@t1@dt=2014
POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t2@dt=2014
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
1.0 1 1
@@ -10329,13 +10452,17 @@ POSTHOOK: Input: default@t3
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: 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@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
@@ -10425,13 +10552,17 @@ POSTHOOK: Input: default@t3
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@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 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@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.0
@@ -10521,13 +10652,17 @@ POSTHOOK: Input: default@t3
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@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 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@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.0
@@ -10617,13 +10752,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 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 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 +11296,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 +11840,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 +12384,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 +12928,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 +13472,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 +14016,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 +14560,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 +15104,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,21 +15649,25 @@ 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
+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
@@ -15502,10 +15677,12 @@ null NULL NULL
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
@@ -15513,13 +15690,17 @@ NULL NULL
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
@@ -15527,13 +15708,17 @@ POSTHOOK: Input: default@t3
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 a+b desc, c asc) t1 left semi 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 order by q+r/10 desc, p) t2 on t1.a=p left semi join t3 on t1.a=key where (b + 1 >= 0) and (b > 0 or a >= 0) group by a, c having a > 0 and (a >=1 or c >= 1) and (a + c) >= 0 order by c, 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 * 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 a+b desc, c asc) t1 left semi 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 order by q+r/10 desc, p) t2 on t1.a=p left semi join t3 on t1.a=key where (b + 1 >= 0) and (b > 0 or a >= 0) group by a, c having a > 0 and (a >=1 or c >= 1) and (a + c) >= 0 order by c, 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 2
@@ -15543,13 +15728,17 @@ POSTHOOK: Input: default@t3
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 ####
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 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
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
@@ -15557,13 +15746,17 @@ POSTHOOK: Input: default@t3
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, a desc) t1 right 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 right outer join t3 on t1.a=key where (b + t2.q >= 2) and (b > 0 or c_int >= 0) group by t3.c_int, 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 having t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b+c, a desc) t1 right 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 right outer join t3 on t1.a=key where (b + t2.q >= 2) and (b > 0 or c_int >= 0) group by t3.c_int, 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 2
@@ -15571,13 +15764,17 @@ POSTHOOK: Input: default@t3
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 c+a desc) t1 full 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 order by p+q desc, r asc) t2 on t1.a=p full 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
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 having t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by c+a desc) t1 full 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 order by p+q desc, r asc) t2 on t1.a=p full 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
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
@@ -15585,13 +15782,17 @@ POSTHOOK: Input: default@t3
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) 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 having t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) 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
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 having t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) 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 having t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) 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
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 2
@@ -15600,38 +15801,46 @@ PREHOOK: query: -- 7. Test Select + TS +
select * from t1 group by c_int limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: -- 7. Test Select + TS + Join + Fil + GB + GB Having + Limit
select * from t1 group by c_int limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
NULL
PREHOOK: query: select key, (c_int+1)+2 as x, sum(c_int) from t1 group by c_float, t1.c_int, key order by x limit 1
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 order by x limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
null NULL NULL
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 order by x,y limit 1
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 order by x,y limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
NULL NULL
PREHOOK: query: select key from(select key from (select key from t1 limit 5)t2 limit 5)t3 limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select key from(select key from (select key from t1 limit 5)t2 limit 5)t3 limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
1
1
@@ -15641,10 +15850,12 @@ POSTHOOK: Input: default@t1
PREHOOK: query: select key, c_int from(select key, c_int from (select key, c_int from t1 order by c_int limit 5)t1 order by c_int limit 5)t2 order by c_int limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: select key, c_int from(select key, c_int from (select key, c_int from t1 order by c_int limit 5)t1 order by c_int limit 5)t2 order by c_int limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
null NULL
null NULL
@@ -15654,13 +15865,17 @@ null NULL
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 limit 5) 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 limit 5) 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 limit 5
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 limit 5) 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 limit 5) 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 limit 5
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
@@ -15668,13 +15883,17 @@ POSTHOOK: Input: default@t3
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 a+b desc, c asc limit 5) t1 left semi 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 order by q+r/10 desc, p limit 5) t2 on t1.a=p left semi join t3 on t1.a=key where (b + 1 >= 0) and (b > 0 or a >= 0) group by a, c having a > 0 and (a >=1 or c >= 1) and (a + c) >= 0 order by c, 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 * 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 a+b desc, c asc limit 5) t1 left semi 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 order by q+r/10 desc, p limit 5) t2 on t1.a=p left semi join t3 on t1.a=key where (b + 1 >= 0) and (b > 0 or a >= 0) group by a, c having a > 0 and (a >=1 or c >= 1) and (a + c) >= 0 order by c, 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 2
@@ -15684,13 +15903,17 @@ POSTHOOK: Input: default@t3
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 limit 5) 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 limit 5) 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 limit 5
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 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 limit 5) 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 limit 5) 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 limit 5
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
@@ -15699,47 +15922,57 @@ PREHOOK: query: -- 8. Test UDAF
select count(*), count(c_int), sum(c_int), avg(c_int), max(c_int), min(c_int) from t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: -- 8. Test UDAF
select count(*), count(c_int), sum(c_int), avg(c_int), max(c_int), min(c_int) from t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
20 18 18 1.0 1 1
PREHOOK: query: select * from (select count(*) as a, count(distinct c_int) as b, sum(c_int) as c, avg(c_int) as d, max(c_int) as e, min(c_int) as f from t1) t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
+PREHOOK: Input: default@t1@dt=2014
#### A masked pattern was here ####
[... 298 lines stripped ...]