http://git-wip-us.apache.org/repos/asf/hive/blob/f562dfb5/ql/src/test/results/clientpositive/llap/parquet_predicate_pushdown.q.out
----------------------------------------------------------------------
diff --git 
a/ql/src/test/results/clientpositive/llap/parquet_predicate_pushdown.q.out 
b/ql/src/test/results/clientpositive/llap/parquet_predicate_pushdown.q.out
new file mode 100644
index 0000000..6541772
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/parquet_predicate_pushdown.q.out
@@ -0,0 +1,1277 @@
+PREHOOK: query: -- SORT_QUERY_RESULTS
+CREATE TABLE tbl_pred(t tinyint,
+           si smallint,
+           i int,
+           b bigint,
+           f float,
+           d double,
+           bo boolean,
+           s string,
+           ts timestamp,
+           dec decimal(4,2),
+           bin binary)
+STORED AS PARQUET
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tbl_pred
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+CREATE TABLE tbl_pred(t tinyint,
+           si smallint,
+           i int,
+           b bigint,
+           f float,
+           d double,
+           bo boolean,
+           s string,
+           ts timestamp,
+           dec decimal(4,2),
+           bin binary)
+STORED AS PARQUET
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tbl_pred
+PREHOOK: query: CREATE TABLE staging(t tinyint,
+           si smallint,
+           i int,
+           b bigint,
+           f float,
+           d double,
+           bo boolean,
+           s string,
+           ts timestamp,
+           dec decimal(4,2),
+           bin binary)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@staging
+POSTHOOK: query: CREATE TABLE staging(t tinyint,
+           si smallint,
+           i int,
+           b bigint,
+           f float,
+           d double,
+           bo boolean,
+           s string,
+           ts timestamp,
+           dec decimal(4,2),
+           bin binary)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@staging
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE 
INTO TABLE staging
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@staging
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE 
INTO TABLE staging
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@staging
+PREHOOK: query: INSERT INTO TABLE tbl_pred select * from staging
+PREHOOK: type: QUERY
+PREHOOK: Input: default@staging
+PREHOOK: Output: default@tbl_pred
+POSTHOOK: query: INSERT INTO TABLE tbl_pred select * from staging
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@staging
+POSTHOOK: Output: default@tbl_pred
+POSTHOOK: Lineage: tbl_pred.b SIMPLE [(staging)staging.FieldSchema(name:b, 
type:bigint, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, 
type:binary, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, 
type:boolean, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, 
type:double, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, 
type:decimal(4,2), comment:null), ]
+POSTHOOK: Lineage: tbl_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, 
type:float, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, 
type:int, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, 
type:string, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.si SIMPLE [(staging)staging.FieldSchema(name:si, 
type:smallint, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.t SIMPLE [(staging)staging.FieldSchema(name:t, 
type:tinyint, comment:null), ]
+POSTHOOK: Lineage: tbl_pred.ts SIMPLE [(staging)staging.FieldSchema(name:ts, 
type:timestamp, comment:null), ]
+PREHOOK: query: -- no predicate case. the explain plan should not have filter 
expression in table scan operator
+
+SELECT SUM(HASH(t)) FROM tbl_pred
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: -- no predicate case. the explain plan should not have filter 
expression in table scan operator
+
+SELECT SUM(HASH(t)) FROM tbl_pred
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+62430
+PREHOOK: query: SELECT SUM(HASH(t)) FROM tbl_pred
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT SUM(HASH(t)) FROM tbl_pred
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+62430
+PREHOOK: query: EXPLAIN SELECT SUM(HASH(t)) FROM tbl_pred
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT SUM(HASH(t)) FROM tbl_pred
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Select Operator
+                    expressions: hash(t) (type: int)
+                    outputColumnNames: _col0
+                    Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                    Group By Operator
+                      aggregations: sum(_col0)
+                      mode: hash
+                      outputColumnNames: _col0
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        sort order: 
+                        Statistics: Num rows: 1 Data size: 8 Basic stats: 
COMPLETE Column stats: NONE
+                        value expressions: _col0 (type: bigint)
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Group By Operator
+                aggregations: sum(VALUE._col0)
+                mode: mergepartial
+                outputColumnNames: _col0
+                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                  table:
+                      input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: EXPLAIN SELECT SUM(HASH(t)) FROM tbl_pred
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT SUM(HASH(t)) FROM tbl_pred
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Select Operator
+                    expressions: hash(t) (type: int)
+                    outputColumnNames: _col0
+                    Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                    Group By Operator
+                      aggregations: sum(_col0)
+                      mode: hash
+                      outputColumnNames: _col0
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        sort order: 
+                        Statistics: Num rows: 1 Data size: 8 Basic stats: 
COMPLETE Column stats: NONE
+                        value expressions: _col0 (type: bigint)
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Group By Operator
+                aggregations: sum(VALUE._col0)
+                mode: mergepartial
+                outputColumnNames: _col0
+                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                  table:
+                      input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: -- all the following queries have predicates which are pushed 
down to table scan operator if
+-- hive.optimize.index.filter is set to true. the explain plan should show 
filter expression
+-- in table scan operator.
+
+SELECT * FROM tbl_pred WHERE t<2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: -- all the following queries have predicates which are pushed 
down to table scan operator if
+-- hive.optimize.index.filter is set to true. the explain plan should show 
filter expression
+-- in table scan operator.
+
+SELECT * FROM tbl_pred WHERE t<2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+-3     467     65575   4294967437      81.64   23.53   true    tom hernandez   
2013-03-01 09:11:58.703188      32.85   study skills
+PREHOOK: query: SELECT * FROM tbl_pred WHERE t<2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM tbl_pred WHERE t<2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+-3     467     65575   4294967437      81.64   23.53   true    tom hernandez   
2013-03-01 09:11:58.703188      32.85   study skills
+PREHOOK: query: SELECT * FROM tbl_pred WHERE t>2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM tbl_pred WHERE t>2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+124    336     65664   4294967435      74.72   42.47   true    bob davidson    
2013-03-01 09:11:58.703302      45.40   yard duty
+PREHOOK: query: SELECT * FROM tbl_pred WHERE t>2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM tbl_pred WHERE t>2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+124    336     65664   4294967435      74.72   42.47   true    bob davidson    
2013-03-01 09:11:58.703302      45.40   yard duty
+PREHOOK: query: SELECT * FROM tbl_pred
+  WHERE t IS NOT NULL
+  AND t < 0
+  AND t > -2
+  LIMIT 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM tbl_pred
+  WHERE t IS NOT NULL
+  AND t < 0
+  AND t > -2
+  LIMIT 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+-1     268     65778   4294967418      56.33   44.73   true    calvin falkner  
2013-03-01 09:11:58.70322       7.37    history
+-1     281     65643   4294967323      15.1    45.0    false   irene nixon     
2013-03-01 09:11:58.703223      80.96   undecided
+-1     300     65663   4294967343      71.26   34.62   true    calvin ovid     
2013-03-01 09:11:58.703262      78.56   study skills
+-1     348     65556   4294967413      35.17   9.51    false   bob young       
2013-03-01 09:11:58.70328       45.81   quiet hour
+-1     372     65680   4294967490      15.45   18.09   false   ethan laertes   
2013-03-01 09:11:58.70311       65.88   opthamology
+-1     417     65685   4294967492      28.89   5.19    true    mike white      
2013-03-01 09:11:58.703275      90.69   forestry
+-1     423     65663   4294967380      0.79    21.33   false   bob laertes     
2013-03-01 09:11:58.703278      94.16   debate
+-1     433     65581   4294967299      86.92   23.15   false   yuri ellison    
2013-03-01 09:11:58.703098      21.29   history
+PREHOOK: query: SELECT * FROM tbl_pred
+  WHERE t IS NOT NULL
+  AND t < 0
+  AND t > -2
+  LIMIT 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM tbl_pred
+  WHERE t IS NOT NULL
+  AND t < 0
+  AND t > -2
+  LIMIT 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+-1     268     65778   4294967418      56.33   44.73   true    calvin falkner  
2013-03-01 09:11:58.70322       7.37    history
+-1     281     65643   4294967323      15.1    45.0    false   irene nixon     
2013-03-01 09:11:58.703223      80.96   undecided
+-1     300     65663   4294967343      71.26   34.62   true    calvin ovid     
2013-03-01 09:11:58.703262      78.56   study skills
+-1     348     65556   4294967413      35.17   9.51    false   bob young       
2013-03-01 09:11:58.70328       45.81   quiet hour
+-1     372     65680   4294967490      15.45   18.09   false   ethan laertes   
2013-03-01 09:11:58.70311       65.88   opthamology
+-1     417     65685   4294967492      28.89   5.19    true    mike white      
2013-03-01 09:11:58.703275      90.69   forestry
+-1     423     65663   4294967380      0.79    21.33   false   bob laertes     
2013-03-01 09:11:58.703278      94.16   debate
+-1     433     65581   4294967299      86.92   23.15   false   yuri ellison    
2013-03-01 09:11:58.703098      21.29   history
+PREHOOK: query: EXPLAIN SELECT * FROM tbl_pred
+  WHERE t IS NOT NULL
+  AND t < 0
+  AND t > -2
+  LIMIT 10
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT * FROM tbl_pred
+  WHERE t IS NOT NULL
+  AND t < 0
+  AND t > -2
+  LIMIT 10
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: 10
+      Processor Tree:
+        TableScan
+          alias: tbl_pred
+          Filter Operator
+            predicate: ((t < 0) and (UDFToInteger(t) > -2)) (type: boolean)
+            Select Operator
+              expressions: t (type: tinyint), si (type: smallint), i (type: 
int), b (type: bigint), f (type: float), d (type: double), bo (type: boolean), 
s (type: string), ts (type: timestamp), dec (type: decimal(4,2)), bin (type: 
binary)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10
+              Limit
+                Number of rows: 10
+                ListSink
+
+PREHOOK: query: EXPLAIN SELECT * FROM tbl_pred
+  WHERE t IS NOT NULL
+  AND t < 0
+  AND t > -2
+  LIMIT 10
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT * FROM tbl_pred
+  WHERE t IS NOT NULL
+  AND t < 0
+  AND t > -2
+  LIMIT 10
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: 10
+      Processor Tree:
+        TableScan
+          alias: tbl_pred
+          filterExpr: ((t < 0) and (UDFToInteger(t) > -2)) (type: boolean)
+          Filter Operator
+            predicate: ((t < 0) and (UDFToInteger(t) > -2)) (type: boolean)
+            Select Operator
+              expressions: t (type: tinyint), si (type: smallint), i (type: 
int), b (type: bigint), f (type: float), d (type: double), bo (type: boolean), 
s (type: string), ts (type: timestamp), dec (type: decimal(4,2)), bin (type: 
binary)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10
+              Limit
+                Number of rows: 10
+                ListSink
+
+PREHOOK: query: SELECT t, s FROM tbl_pred
+  WHERE t <=> -1
+  AND s IS NOT NULL
+  AND s LIKE 'bob%'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, s FROM tbl_pred
+  WHERE t <=> -1
+  AND s IS NOT NULL
+  AND s LIKE 'bob%'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+-1     bob laertes
+-1     bob young
+PREHOOK: query: SELECT t, s FROM tbl_pred
+  WHERE t <=> -1
+  AND s IS NOT NULL
+  AND s LIKE 'bob%'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, s FROM tbl_pred
+  WHERE t <=> -1
+  AND s IS NOT NULL
+  AND s LIKE 'bob%'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+-1     bob laertes
+-1     bob young
+PREHOOK: query: EXPLAIN SELECT t, s FROM tbl_pred
+  WHERE t <=> -1
+  AND s IS NOT NULL
+  AND s LIKE 'bob%'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT t, s FROM tbl_pred
+  WHERE t <=> -1
+  AND s IS NOT NULL
+  AND s LIKE 'bob%'
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: tbl_pred
+          Filter Operator
+            predicate: ((t = -1) and s is not null and (s like 'bob%')) (type: 
boolean)
+            Select Operator
+              expressions: -1 (type: tinyint), s (type: string)
+              outputColumnNames: _col0, _col1
+              ListSink
+
+PREHOOK: query: EXPLAIN SELECT t, s FROM tbl_pred
+  WHERE t <=> -1
+  AND s IS NOT NULL
+  AND s LIKE 'bob%'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT t, s FROM tbl_pred
+  WHERE t <=> -1
+  AND s IS NOT NULL
+  AND s LIKE 'bob%'
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: tbl_pred
+          filterExpr: ((t = -1) and s is not null and (s like 'bob%')) (type: 
boolean)
+          Filter Operator
+            predicate: ((t = -1) and s is not null and (s like 'bob%')) (type: 
boolean)
+            Select Operator
+              expressions: -1 (type: tinyint), s (type: string)
+              outputColumnNames: _col0, _col1
+              ListSink
+
+PREHOOK: query: SELECT t, s FROM tbl_pred
+  WHERE s IS NOT NULL
+  AND s LIKE 'bob%'
+  AND t NOT IN (-1,-2,-3)
+  AND t BETWEEN 25 AND 30
+  SORT BY t,s
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, s FROM tbl_pred
+  WHERE s IS NOT NULL
+  AND s LIKE 'bob%'
+  AND t NOT IN (-1,-2,-3)
+  AND t BETWEEN 25 AND 30
+  SORT BY t,s
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+26     bob ovid
+26     bob quirinius
+27     bob ovid
+PREHOOK: query: SELECT t, s FROM tbl_pred
+  WHERE s IS NOT NULL
+  AND s LIKE 'bob%'
+  AND t NOT IN (-1,-2,-3)
+  AND t BETWEEN 25 AND 30
+  SORT BY t,s
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, s FROM tbl_pred
+  WHERE s IS NOT NULL
+  AND s LIKE 'bob%'
+  AND t NOT IN (-1,-2,-3)
+  AND t BETWEEN 25 AND 30
+  SORT BY t,s
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+26     bob ovid
+26     bob quirinius
+27     bob ovid
+PREHOOK: query: EXPLAIN SELECT t, s FROM tbl_pred
+  WHERE s IS NOT NULL
+  AND s LIKE 'bob%'
+  AND t NOT IN (-1,-2,-3)
+  AND t BETWEEN 25 AND 30
+  SORT BY t,s
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT t, s FROM tbl_pred
+  WHERE s IS NOT NULL
+  AND s LIKE 'bob%'
+  AND t NOT IN (-1,-2,-3)
+  AND t BETWEEN 25 AND 30
+  SORT BY t,s
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Filter Operator
+                    predicate: (s is not null and (s like 'bob%') and (not (t) 
IN (-1, -2, -3)) and t BETWEEN 25 AND 30) (type: boolean)
+                    Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+                    Select Operator
+                      expressions: t (type: tinyint), s (type: string)
+                      outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col0 (type: tinyint), _col1 (type: 
string)
+                        sort order: ++
+                        Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: KEY.reducesinkkey0 (type: tinyint), 
KEY.reducesinkkey1 (type: string)
+                outputColumnNames: _col0, _col1
+                Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+                  table:
+                      input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: EXPLAIN SELECT t, s FROM tbl_pred
+  WHERE s IS NOT NULL
+  AND s LIKE 'bob%'
+  AND t NOT IN (-1,-2,-3)
+  AND t BETWEEN 25 AND 30
+  SORT BY t,s
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT t, s FROM tbl_pred
+  WHERE s IS NOT NULL
+  AND s LIKE 'bob%'
+  AND t NOT IN (-1,-2,-3)
+  AND t BETWEEN 25 AND 30
+  SORT BY t,s
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  filterExpr: (s is not null and (s like 'bob%') and (not (t) 
IN (-1, -2, -3)) and t BETWEEN 25 AND 30) (type: boolean)
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Filter Operator
+                    predicate: (s is not null and (s like 'bob%') and (not (t) 
IN (-1, -2, -3)) and t BETWEEN 25 AND 30) (type: boolean)
+                    Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+                    Select Operator
+                      expressions: t (type: tinyint), s (type: string)
+                      outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col0 (type: tinyint), _col1 (type: 
string)
+                        sort order: ++
+                        Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: KEY.reducesinkkey0 (type: tinyint), 
KEY.reducesinkkey1 (type: string)
+                outputColumnNames: _col0, _col1
+                Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 131 Data size: 1441 Basic stats: 
COMPLETE Column stats: NONE
+                  table:
+                      input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: SELECT t, si, d, s FROM tbl_pred
+  WHERE d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  ORDER BY s DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, si, d, s FROM tbl_pred
+  WHERE d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  ORDER BY s DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+101    327     11.48   gabriella ellison
+15     334     11.12   jessica robinson
+7      320     11.54   bob ellison
+PREHOOK: query: SELECT t, si, d, s FROM tbl_pred
+  WHERE d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  ORDER BY s DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, si, d, s FROM tbl_pred
+  WHERE d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  ORDER BY s DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+101    327     11.48   gabriella ellison
+15     334     11.12   jessica robinson
+7      320     11.54   bob ellison
+PREHOOK: query: EXPLAIN SELECT t, si, d, s FROM tbl_pred
+  WHERE d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  ORDER BY s DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT t, si, d, s FROM tbl_pred
+  WHERE d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  ORDER BY s DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Filter Operator
+                    predicate: ((d >= 10.0) and (d < 12.0) and (s like '%son') 
and (t > 0) and si BETWEEN 300 AND 400 and (not (s like '%car%'))) (type: 
boolean)
+                    Statistics: Num rows: 5 Data size: 55 Basic stats: 
COMPLETE Column stats: NONE
+                    Select Operator
+                      expressions: t (type: tinyint), si (type: smallint), d 
(type: double), s (type: string)
+                      outputColumnNames: _col0, _col1, _col2, _col3
+                      Statistics: Num rows: 5 Data size: 55 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col3 (type: string)
+                        sort order: -
+                        Statistics: Num rows: 5 Data size: 55 Basic stats: 
COMPLETE Column stats: NONE
+                        TopN Hash Memory Usage: 0.1
+                        value expressions: _col0 (type: tinyint), _col1 (type: 
smallint), _col2 (type: double)
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: 
smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
+                outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE 
Column stats: NONE
+                Limit
+                  Number of rows: 3
+                  Statistics: Num rows: 3 Data size: 33 Basic stats: COMPLETE 
Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    Statistics: Num rows: 3 Data size: 33 Basic stats: 
COMPLETE Column stats: NONE
+                    table:
+                        input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                        output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                        serde: 
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: 3
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: EXPLAIN SELECT t, si, d, s FROM tbl_pred
+  WHERE d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  ORDER BY s DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT t, si, d, s FROM tbl_pred
+  WHERE d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  ORDER BY s DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  filterExpr: ((d >= 10.0) and (d < 12.0) and (s like '%son') 
and (t > 0) and si BETWEEN 300 AND 400 and (not (s like '%car%'))) (type: 
boolean)
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Filter Operator
+                    predicate: ((d >= 10.0) and (d < 12.0) and (s like '%son') 
and (t > 0) and si BETWEEN 300 AND 400 and (not (s like '%car%'))) (type: 
boolean)
+                    Statistics: Num rows: 5 Data size: 55 Basic stats: 
COMPLETE Column stats: NONE
+                    Select Operator
+                      expressions: t (type: tinyint), si (type: smallint), d 
(type: double), s (type: string)
+                      outputColumnNames: _col0, _col1, _col2, _col3
+                      Statistics: Num rows: 5 Data size: 55 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col3 (type: string)
+                        sort order: -
+                        Statistics: Num rows: 5 Data size: 55 Basic stats: 
COMPLETE Column stats: NONE
+                        TopN Hash Memory Usage: 0.1
+                        value expressions: _col0 (type: tinyint), _col1 (type: 
smallint), _col2 (type: double)
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: 
smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
+                outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE 
Column stats: NONE
+                Limit
+                  Number of rows: 3
+                  Statistics: Num rows: 3 Data size: 33 Basic stats: COMPLETE 
Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    Statistics: Num rows: 3 Data size: 33 Basic stats: 
COMPLETE Column stats: NONE
+                    table:
+                        input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                        output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                        serde: 
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: 3
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: SELECT t, si, d, s FROM tbl_pred
+  WHERE t > 10
+  AND t <> 101
+  AND d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  SORT BY s DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, si, d, s FROM tbl_pred
+  WHERE t > 10
+  AND t <> 101
+  AND d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  SORT BY s DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+15     334     11.12   jessica robinson
+PREHOOK: query: SELECT t, si, d, s FROM tbl_pred
+  WHERE t > 10
+  AND t <> 101
+  AND d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  SORT BY s DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, si, d, s FROM tbl_pred
+  WHERE t > 10
+  AND t <> 101
+  AND d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  SORT BY s DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+15     334     11.12   jessica robinson
+PREHOOK: query: SELECT f, i, b FROM tbl_pred
+  WHERE f IS NOT NULL
+  AND f < 123.2
+  AND f > 1.92
+  AND f >= 9.99
+  AND f BETWEEN 1.92 AND 123.2
+  AND i IS NOT NULL
+  AND i < 67627
+  AND i > 60627
+  AND i >= 60626
+  AND i BETWEEN 60626 AND 67627
+  AND b IS NOT NULL
+  AND b < 4294967861
+  AND b > 4294967261
+  AND b >= 4294967260
+  AND b BETWEEN 4294967261 AND 4294967861
+  SORT BY f DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT f, i, b FROM tbl_pred
+  WHERE f IS NOT NULL
+  AND f < 123.2
+  AND f > 1.92
+  AND f >= 9.99
+  AND f BETWEEN 1.92 AND 123.2
+  AND i IS NOT NULL
+  AND i < 67627
+  AND i > 60627
+  AND i >= 60626
+  AND i BETWEEN 60626 AND 67627
+  AND b IS NOT NULL
+  AND b < 4294967861
+  AND b > 4294967261
+  AND b >= 4294967260
+  AND b BETWEEN 4294967261 AND 4294967861
+  SORT BY f DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_pred
+#### A masked pattern was here ####
+99.68  65658   4294967503
+99.91  65763   4294967324
+99.92  65661   4294967404
+PREHOOK: query: EXPLAIN SELECT t, si, d, s FROM tbl_pred
+  WHERE t > 10
+  AND t <> 101
+  AND d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  SORT BY s DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT t, si, d, s FROM tbl_pred
+  WHERE t > 10
+  AND t <> 101
+  AND d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  SORT BY s DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+        Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Filter Operator
+                    predicate: ((t > 10) and (t <> 101) and (d >= 10) and (d < 
12.0) and (s like '%son') and (not (s like '%car%')) and (t > 0) and si BETWEEN 
300 AND 400) (type: boolean)
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    Select Operator
+                      expressions: t (type: tinyint), si (type: smallint), d 
(type: double), s (type: string)
+                      outputColumnNames: _col0, _col1, _col2, _col3
+                      Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col3 (type: string)
+                        sort order: -
+                        Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                        TopN Hash Memory Usage: 0.1
+                        value expressions: _col0 (type: tinyint), _col1 (type: 
smallint), _col2 (type: double)
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: 
smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
+                outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                Limit
+                  Number of rows: 3
+                  Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                  Reduce Output Operator
+                    key expressions: _col3 (type: string)
+                    sort order: -
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    TopN Hash Memory Usage: 0.1
+                    value expressions: _col0 (type: tinyint), _col1 (type: 
smallint), _col2 (type: double)
+        Reducer 3 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: 
smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
+                outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                Limit
+                  Number of rows: 3
+                  Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    table:
+                        input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                        output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                        serde: 
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: 3
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: EXPLAIN SELECT t, si, d, s FROM tbl_pred
+  WHERE t > 10
+  AND t <> 101
+  AND d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  SORT BY s DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT t, si, d, s FROM tbl_pred
+  WHERE t > 10
+  AND t <> 101
+  AND d >= ROUND(9.99)
+  AND d < 12
+  AND t IS NOT NULL
+  AND s LIKE '%son'
+  AND s NOT LIKE '%car%'
+  AND t > 0
+  AND si BETWEEN 300 AND 400
+  SORT BY s DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+        Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  filterExpr: ((t > 10) and (t <> 101) and (d >= 10) and (d < 
12.0) and (s like '%son') and (not (s like '%car%')) and (t > 0) and si BETWEEN 
300 AND 400) (type: boolean)
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Filter Operator
+                    predicate: ((t > 10) and (t <> 101) and (d >= 10) and (d < 
12.0) and (s like '%son') and (not (s like '%car%')) and (t > 0) and si BETWEEN 
300 AND 400) (type: boolean)
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    Select Operator
+                      expressions: t (type: tinyint), si (type: smallint), d 
(type: double), s (type: string)
+                      outputColumnNames: _col0, _col1, _col2, _col3
+                      Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col3 (type: string)
+                        sort order: -
+                        Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                        TopN Hash Memory Usage: 0.1
+                        value expressions: _col0 (type: tinyint), _col1 (type: 
smallint), _col2 (type: double)
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: 
smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
+                outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                Limit
+                  Number of rows: 3
+                  Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                  Reduce Output Operator
+                    key expressions: _col3 (type: string)
+                    sort order: -
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    TopN Hash Memory Usage: 0.1
+                    value expressions: _col0 (type: tinyint), _col1 (type: 
smallint), _col2 (type: double)
+        Reducer 3 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: 
smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
+                outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                Limit
+                  Number of rows: 3
+                  Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    table:
+                        input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                        output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                        serde: 
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: 3
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: EXPLAIN SELECT f, i, b FROM tbl_pred
+  WHERE f IS NOT NULL
+  AND f < 123.2
+  AND f > 1.92
+  AND f >= 9.99
+  AND f BETWEEN 1.92 AND 123.2
+  AND i IS NOT NULL
+  AND i < 67627
+  AND i > 60627
+  AND i >= 60626
+  AND i BETWEEN 60626 AND 67627
+  AND b IS NOT NULL
+  AND b < 4294967861
+  AND b > 4294967261
+  AND b >= 4294967260
+  AND b BETWEEN 4294967261 AND 4294967861
+  SORT BY f DESC
+  LIMIT 3
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT f, i, b FROM tbl_pred
+  WHERE f IS NOT NULL
+  AND f < 123.2
+  AND f > 1.92
+  AND f >= 9.99
+  AND f BETWEEN 1.92 AND 123.2
+  AND i IS NOT NULL
+  AND i < 67627
+  AND i > 60627
+  AND i >= 60626
+  AND i BETWEEN 60626 AND 67627
+  AND b IS NOT NULL
+  AND b < 4294967861
+  AND b > 4294967261
+  AND b >= 4294967260
+  AND b BETWEEN 4294967261 AND 4294967861
+  SORT BY f DESC
+  LIMIT 3
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+        Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: tbl_pred
+                  filterExpr: ((f < 123.2) and (f > 1.92) and (f >= 9.99) and 
f BETWEEN 1.92 AND 123.2 and (i < 67627) and (i > 60627) and (i >= 60626) and i 
BETWEEN 60626 AND 67627 and (b < 4294967861) and (b > 4294967261) and (b >= 
4294967260) and b BETWEEN 4294967261 AND 4294967861) (type: boolean)
+                  Statistics: Num rows: 1049 Data size: 11539 Basic stats: 
COMPLETE Column stats: NONE
+                  Filter Operator
+                    predicate: ((f < 123.2) and (f > 1.92) and (f >= 9.99) and 
f BETWEEN 1.92 AND 123.2 and (i < 67627) and (i > 60627) and (i >= 60626) and i 
BETWEEN 60626 AND 67627 and (b < 4294967861) and (b > 4294967261) and (b >= 
4294967260) and b BETWEEN 4294967261 AND 4294967861) (type: boolean)
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    Select Operator
+                      expressions: f (type: float), i (type: int), b (type: 
bigint)
+                      outputColumnNames: _col0, _col1, _col2
+                      Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                      Reduce Output Operator
+                        key expressions: _col0 (type: float)
+                        sort order: -
+                        Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                        TopN Hash Memory Usage: 0.1
+                        value expressions: _col1 (type: int), _col2 (type: 
bigint)
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: KEY.reducesinkkey0 (type: float), VALUE._col0 
(type: int), VALUE._col1 (type: bigint)
+                outputColumnNames: _col0, _col1, _col2
+                Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                Limit
+                  Number of rows: 3
+                  Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                  Reduce Output Operator
+                    key expressions: _col0 (type: float)
+                    sort order: -
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    TopN Hash Memory Usage: 0.1
+                    value expressions: _col1 (type: int), _col2 (type: bigint)
+        Reducer 3 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Select Operator
+                expressions: KEY.reducesinkkey0 (type: float), VALUE._col0 
(type: int), VALUE._col1 (type: bigint)
+                outputColumnNames: _col0, _col1, _col2
+                Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                Limit
+                  Number of rows: 3
+                  Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE 
Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    Statistics: Num rows: 1 Data size: 11 Basic stats: 
COMPLETE Column stats: NONE
+                    table:
+                        input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                        output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                        serde: 
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: 3
+      Processor Tree:
+        ListSink
+

http://git-wip-us.apache.org/repos/asf/hive/blob/f562dfb5/ql/src/test/results/clientpositive/llap/parquet_types.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/parquet_types.q.out 
b/ql/src/test/results/clientpositive/llap/parquet_types.q.out
new file mode 100644
index 0000000..ad743ef
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/parquet_types.q.out
@@ -0,0 +1,379 @@
+PREHOOK: query: DROP TABLE parquet_types_staging
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE parquet_types_staging
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: DROP TABLE parquet_types
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE parquet_types
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE parquet_types_staging (
+  cint int,
+  ctinyint tinyint,
+  csmallint smallint,
+  cfloat float,
+  cdouble double,
+  cstring1 string,
+  t timestamp,
+  cchar char(5),
+  cvarchar varchar(10),
+  cbinary string,
+  m1 map<string, varchar(3)>,
+  l1 array<int>,
+  st1 struct<c1:int, c2:char(1)>,
+  d date
+) ROW FORMAT DELIMITED
+FIELDS TERMINATED BY '|'
+COLLECTION ITEMS TERMINATED BY ','
+MAP KEYS TERMINATED BY ':'
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_types_staging
+POSTHOOK: query: CREATE TABLE parquet_types_staging (
+  cint int,
+  ctinyint tinyint,
+  csmallint smallint,
+  cfloat float,
+  cdouble double,
+  cstring1 string,
+  t timestamp,
+  cchar char(5),
+  cvarchar varchar(10),
+  cbinary string,
+  m1 map<string, varchar(3)>,
+  l1 array<int>,
+  st1 struct<c1:int, c2:char(1)>,
+  d date
+) ROW FORMAT DELIMITED
+FIELDS TERMINATED BY '|'
+COLLECTION ITEMS TERMINATED BY ','
+MAP KEYS TERMINATED BY ':'
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@parquet_types_staging
+PREHOOK: query: CREATE TABLE parquet_types (
+  cint int,
+  ctinyint tinyint,
+  csmallint smallint,
+  cfloat float,
+  cdouble double,
+  cstring1 string,
+  t timestamp,
+  cchar char(5),
+  cvarchar varchar(10),
+  cbinary binary,
+  m1 map<string, varchar(3)>,
+  l1 array<int>,
+  st1 struct<c1:int, c2:char(1)>,
+  d date
+) STORED AS PARQUET
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_types
+POSTHOOK: query: CREATE TABLE parquet_types (
+  cint int,
+  ctinyint tinyint,
+  csmallint smallint,
+  cfloat float,
+  cdouble double,
+  cstring1 string,
+  t timestamp,
+  cchar char(5),
+  cvarchar varchar(10),
+  cbinary binary,
+  m1 map<string, varchar(3)>,
+  l1 array<int>,
+  st1 struct<c1:int, c2:char(1)>,
+  d date
+) STORED AS PARQUET
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@parquet_types
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/parquet_types.txt' 
OVERWRITE INTO TABLE parquet_types_staging
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@parquet_types_staging
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/parquet_types.txt' 
OVERWRITE INTO TABLE parquet_types_staging
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@parquet_types_staging
+PREHOOK: query: SELECT * FROM parquet_types_staging
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types_staging
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM parquet_types_staging
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types_staging
+#### A masked pattern was here ####
+100    1       1       1.0     0.0     abc     2011-01-01 01:01:01.111111111   
a       a       B4F3CAFDBEDD    {"k1":"v1"}     [101,200]       
{"c1":10,"c2":"a"}      2011-01-01
+101    2       2       1.1     0.3     def     2012-02-02 02:02:02.222222222   
ab      ab      68692CCAC0BDE7  {"k2":"v2"}     [102,200]       
{"c1":10,"c2":"d"}      2012-02-02
+102    3       3       1.2     0.6     ghi     2013-03-03 03:03:03.333333333   
abc     abc     B4F3CAFDBEDD    {"k3":"v3"}     [103,200]       
{"c1":10,"c2":"g"}      2013-03-03
+103    1       4       1.3     0.9     jkl     2014-04-04 04:04:04.444444444   
abcd    abcd    68692CCAC0BDE7  {"k4":"v4"}     [104,200]       
{"c1":10,"c2":"j"}      2014-04-04
+104    2       5       1.4     1.2     mno     2015-05-05 05:05:05.555555555   
abcde   abcde   B4F3CAFDBEDD    {"k5":"v5"}     [105,200]       
{"c1":10,"c2":"m"}      2015-05-05
+105    3       1       1.0     1.5     pqr     2016-06-06 06:06:06.666666666   
abcde   abcdef  68692CCAC0BDE7  {"k6":"v6"}     [106,200]       
{"c1":10,"c2":"p"}      2016-06-06
+106    1       2       1.1     1.8     stu     2017-07-07 07:07:07.777777777   
abcde   abcdefg B4F3CAFDBEDD    {"k7":"v7"}     [107,200]       
{"c1":10,"c2":"s"}      2017-07-07
+107    2       3       1.2     2.1     vwx     2018-08-08 08:08:08.888888888   
bcdef   abcdefgh        68692CCAC0BDE7  {"k8":"v8"}     [108,200]       
{"c1":10,"c2":"v"}      2018-08-08
+108    3       4       1.3     2.4     yza     2019-09-09 09:09:09.999999999   
cdefg   B4F3CAFDBE      68656C6C6F      {"k9":"v9"}     [109,200]       
{"c1":10,"c2":"y"}      2019-09-09
+109    1       5       1.4     2.7     bcd     2020-10-10 10:10:10.101010101   
klmno   abcdedef        68692CCAC0BDE7  {"k10":"v10"}   [110,200]       
{"c1":10,"c2":"b"}      2020-10-10
+110    2       1       1.0     3.0     efg     2021-11-11 11:11:11.111111111   
pqrst   abcdede B4F3CAFDBEDD    {"k11":"v11"}   [111,200]       
{"c1":10,"c2":"e"}      2021-11-11
+111    3       2       1.1     3.3     hij     2022-12-12 12:12:12.121212121   
nopqr   abcded  68692CCAC0BDE7  {"k12":"v12"}   [112,200]       
{"c1":10,"c2":"h"}      2022-12-12
+112    1       3       1.2     3.6     klm     2023-01-02 13:13:13.131313131   
opqrs   abcdd   B4F3CAFDBEDD    {"k13":"v13"}   [113,200]       
{"c1":10,"c2":"k"}      2023-01-02
+113    2       4       1.3     3.9     nop     2024-02-02 14:14:14.141414141   
pqrst   abc     68692CCAC0BDE7  {"k14":"v14"}   [114,200]       
{"c1":10,"c2":"n"}      2024-02-02
+114    3       5       1.4     4.2     qrs     2025-03-03 15:15:15.151515151   
qrstu   b       B4F3CAFDBEDD    {"k15":"v15"}   [115,200]       
{"c1":10,"c2":"q"}      2025-03-03
+115    1       1       1.0     4.5     qrs     2026-04-04 16:16:16.161616161   
rstuv   abcded  68692CCAC0BDE7  {"k16":"v16"}   [116,200]       
{"c1":10,"c2":"q"}      2026-04-04
+116    2       2       1.1     4.8     wxy     2027-05-05 17:17:17.171717171   
stuvw   abcded  B4F3CAFDBEDD    {"k17":"v17"}   [117,200]       
{"c1":10,"c2":"w"}      2027-05-05
+117    3       3       1.2     5.1     zab     2028-06-06 18:18:18.181818181   
tuvwx   abcded  68692CCAC0BDE7  {"k18":"v18"}   [118,200]       
{"c1":10,"c2":"z"}      2028-06-06
+118    1       4       1.3     5.4     cde     2029-07-07 19:19:19.191919191   
uvwzy   abcdede B4F3CAFDBEDD    {"k19":"v19"}   [119,200]       
{"c1":10,"c2":"c"}      2029-07-07
+119    2       5       1.4     5.7     fgh     2030-08-08 20:20:20.202020202   
vwxyz   abcdede 68692CCAC0BDE7  {"k20":"v20"}   [120,200]       
{"c1":10,"c2":"f"}      2030-08-08
+120    3       1       1.0     6.0     ijk     2031-09-09 21:21:21.212121212   
wxyza   abcde   B4F3CAFDBEDD    {"k21":"v21"}   [121,200]       
{"c1":10,"c2":"i"}      2031-09-09
+121    1       2       1.1     6.3     lmn     2032-10-10 22:22:22.222222222   
bcdef   abcde           {"k22":"v22"}   [122,200]       {"c1":10,"c2":"l"}      
2032-10-10
+PREHOOK: query: INSERT OVERWRITE TABLE parquet_types
+SELECT cint, ctinyint, csmallint, cfloat, cdouble, cstring1, t, cchar, 
cvarchar,
+unhex(cbinary), m1, l1, st1, d FROM parquet_types_staging
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types_staging
+PREHOOK: Output: default@parquet_types
+POSTHOOK: query: INSERT OVERWRITE TABLE parquet_types
+SELECT cint, ctinyint, csmallint, cfloat, cdouble, cstring1, t, cchar, 
cvarchar,
+unhex(cbinary), m1, l1, st1, d FROM parquet_types_staging
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types_staging
+POSTHOOK: Output: default@parquet_types
+POSTHOOK: Lineage: parquet_types.cbinary EXPRESSION 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:cbinary, 
type:string, comment:null), ]
+POSTHOOK: Lineage: parquet_types.cchar SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:cchar, 
type:char(5), comment:null), ]
+POSTHOOK: Lineage: parquet_types.cdouble SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:cdouble, 
type:double, comment:null), ]
+POSTHOOK: Lineage: parquet_types.cfloat SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:cfloat, 
type:float, comment:null), ]
+POSTHOOK: Lineage: parquet_types.cint SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:cint, type:int, 
comment:null), ]
+POSTHOOK: Lineage: parquet_types.csmallint SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:csmallint, 
type:smallint, comment:null), ]
+POSTHOOK: Lineage: parquet_types.cstring1 SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:cstring1, 
type:string, comment:null), ]
+POSTHOOK: Lineage: parquet_types.ctinyint SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:ctinyint, 
type:tinyint, comment:null), ]
+POSTHOOK: Lineage: parquet_types.cvarchar SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:cvarchar, 
type:varchar(10), comment:null), ]
+POSTHOOK: Lineage: parquet_types.d SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:d, type:date, 
comment:null), ]
+POSTHOOK: Lineage: parquet_types.l1 SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:l1, 
type:array<int>, comment:null), ]
+POSTHOOK: Lineage: parquet_types.m1 SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:m1, 
type:map<string,varchar(3)>, comment:null), ]
+POSTHOOK: Lineage: parquet_types.st1 SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:st1, 
type:struct<c1:int,c2:char(1)>, comment:null), ]
+POSTHOOK: Lineage: parquet_types.t SIMPLE 
[(parquet_types_staging)parquet_types_staging.FieldSchema(name:t, 
type:timestamp, comment:null), ]
+PREHOOK: query: SELECT cint, ctinyint, csmallint, cfloat, cdouble, cstring1, 
t, cchar, cvarchar,
+hex(cbinary), m1, l1, st1, d FROM parquet_types
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT cint, ctinyint, csmallint, cfloat, cdouble, cstring1, 
t, cchar, cvarchar,
+hex(cbinary), m1, l1, st1, d FROM parquet_types
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+100    1       1       1.0     0.0     abc     2011-01-01 01:01:01.111111111   
a       a       B4F3CAFDBEDD    {"k1":"v1"}     [101,200]       
{"c1":10,"c2":"a"}      2011-01-01
+101    2       2       1.1     0.3     def     2012-02-02 02:02:02.222222222   
ab      ab      68692CCAC0BDE7  {"k2":"v2"}     [102,200]       
{"c1":10,"c2":"d"}      2012-02-02
+102    3       3       1.2     0.6     ghi     2013-03-03 03:03:03.333333333   
abc     abc     B4F3CAFDBEDD    {"k3":"v3"}     [103,200]       
{"c1":10,"c2":"g"}      2013-03-03
+103    1       4       1.3     0.9     jkl     2014-04-04 04:04:04.444444444   
abcd    abcd    68692CCAC0BDE7  {"k4":"v4"}     [104,200]       
{"c1":10,"c2":"j"}      2014-04-04
+104    2       5       1.4     1.2     mno     2015-05-05 05:05:05.555555555   
abcde   abcde   B4F3CAFDBEDD    {"k5":"v5"}     [105,200]       
{"c1":10,"c2":"m"}      2015-05-05
+105    3       1       1.0     1.5     pqr     2016-06-06 06:06:06.666666666   
abcde   abcdef  68692CCAC0BDE7  {"k6":"v6"}     [106,200]       
{"c1":10,"c2":"p"}      2016-06-06
+106    1       2       1.1     1.8     stu     2017-07-07 07:07:07.777777777   
abcde   abcdefg B4F3CAFDBEDD    {"k7":"v7"}     [107,200]       
{"c1":10,"c2":"s"}      2017-07-07
+107    2       3       1.2     2.1     vwx     2018-08-08 08:08:08.888888888   
bcdef   abcdefgh        68692CCAC0BDE7  {"k8":"v8"}     [108,200]       
{"c1":10,"c2":"v"}      2018-08-08
+108    3       4       1.3     2.4     yza     2019-09-09 09:09:09.999999999   
cdefg   B4F3CAFDBE      68656C6C6F      {"k9":"v9"}     [109,200]       
{"c1":10,"c2":"y"}      2019-09-09
+109    1       5       1.4     2.7     bcd     2020-10-10 10:10:10.101010101   
klmno   abcdedef        68692CCAC0BDE7  {"k10":"v10"}   [110,200]       
{"c1":10,"c2":"b"}      2020-10-10
+110    2       1       1.0     3.0     efg     2021-11-11 11:11:11.111111111   
pqrst   abcdede B4F3CAFDBEDD    {"k11":"v11"}   [111,200]       
{"c1":10,"c2":"e"}      2021-11-11
+111    3       2       1.1     3.3     hij     2022-12-12 12:12:12.121212121   
nopqr   abcded  68692CCAC0BDE7  {"k12":"v12"}   [112,200]       
{"c1":10,"c2":"h"}      2022-12-12
+112    1       3       1.2     3.6     klm     2023-01-02 13:13:13.131313131   
opqrs   abcdd   B4F3CAFDBEDD    {"k13":"v13"}   [113,200]       
{"c1":10,"c2":"k"}      2023-01-02
+113    2       4       1.3     3.9     nop     2024-02-02 14:14:14.141414141   
pqrst   abc     68692CCAC0BDE7  {"k14":"v14"}   [114,200]       
{"c1":10,"c2":"n"}      2024-02-02
+114    3       5       1.4     4.2     qrs     2025-03-03 15:15:15.151515151   
qrstu   b       B4F3CAFDBEDD    {"k15":"v15"}   [115,200]       
{"c1":10,"c2":"q"}      2025-03-03
+115    1       1       1.0     4.5     qrs     2026-04-04 16:16:16.161616161   
rstuv   abcded  68692CCAC0BDE7  {"k16":"v16"}   [116,200]       
{"c1":10,"c2":"q"}      2026-04-04
+116    2       2       1.1     4.8     wxy     2027-05-05 17:17:17.171717171   
stuvw   abcded  B4F3CAFDBEDD    {"k17":"v17"}   [117,200]       
{"c1":10,"c2":"w"}      2027-05-05
+117    3       3       1.2     5.1     zab     2028-06-06 18:18:18.181818181   
tuvwx   abcded  68692CCAC0BDE7  {"k18":"v18"}   [118,200]       
{"c1":10,"c2":"z"}      2028-06-06
+118    1       4       1.3     5.4     cde     2029-07-07 19:19:19.191919191   
uvwzy   abcdede B4F3CAFDBEDD    {"k19":"v19"}   [119,200]       
{"c1":10,"c2":"c"}      2029-07-07
+119    2       5       1.4     5.7     fgh     2030-08-08 20:20:20.202020202   
vwxyz   abcdede 68692CCAC0BDE7  {"k20":"v20"}   [120,200]       
{"c1":10,"c2":"f"}      2030-08-08
+120    3       1       1.0     6.0     ijk     2031-09-09 21:21:21.212121212   
wxyza   abcde   B4F3CAFDBEDD    {"k21":"v21"}   [121,200]       
{"c1":10,"c2":"i"}      2031-09-09
+121    1       2       1.1     6.3     lmn     2032-10-10 22:22:22.222222222   
bcdef   abcde           {"k22":"v22"}   [122,200]       {"c1":10,"c2":"l"}      
2032-10-10
+PREHOOK: query: SELECT cchar, LENGTH(cchar), cvarchar, LENGTH(cvarchar) FROM 
parquet_types
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT cchar, LENGTH(cchar), cvarchar, LENGTH(cvarchar) FROM 
parquet_types
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+a      1       a       3
+ab     2       ab      3
+abc    3       abc     3
+abcd   4       abcd    4
+abcde  5       abcde   5
+abcde  5       abcdef  6
+abcde  5       abcdefg 7
+bcdef  5       abcdefgh        8
+cdefg  5       B4F3CAFDBE      10
+klmno  5       abcdedef        8
+pqrst  5       abcdede 7
+nopqr  5       abcded  6
+opqrs  5       abcdd   5
+pqrst  5       abc     3
+qrstu  5       b       1
+rstuv  5       abcded  6
+stuvw  5       abcded  6
+tuvwx  5       abcded  6
+uvwzy  5       abcdede 7
+vwxyz  5       abcdede 7
+wxyza  5       abcde   5
+bcdef  5       abcde   5
+PREHOOK: query: -- test types in group by
+
+SELECT ctinyint,
+  MAX(cint),
+  MIN(csmallint),
+  COUNT(cstring1),
+  ROUND(AVG(cfloat), 5),
+  ROUND(STDDEV_POP(cdouble),5)
+FROM parquet_types
+GROUP BY ctinyint
+ORDER BY ctinyint
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: -- test types in group by
+
+SELECT ctinyint,
+  MAX(cint),
+  MIN(csmallint),
+  COUNT(cstring1),
+  ROUND(AVG(cfloat), 5),
+  ROUND(STDDEV_POP(cdouble),5)
+FROM parquet_types
+GROUP BY ctinyint
+ORDER BY ctinyint
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+1      121     1       8       1.175   2.06216
+2      119     1       7       1.21429 1.8
+3      120     1       7       1.17143 1.8
+PREHOOK: query: SELECT cfloat, count(*) FROM parquet_types GROUP BY cfloat 
ORDER BY cfloat
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT cfloat, count(*) FROM parquet_types GROUP BY cfloat 
ORDER BY cfloat
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+1.0    5
+1.1    5
+1.2    4
+1.3    4
+1.4    4
+PREHOOK: query: SELECT cchar, count(*) FROM parquet_types GROUP BY cchar ORDER 
BY cchar
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT cchar, count(*) FROM parquet_types GROUP BY cchar 
ORDER BY cchar
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+a      1
+ab     1
+abc    1
+abcd   1
+abcde  3
+bcdef  2
+cdefg  1
+klmno  1
+nopqr  1
+opqrs  1
+pqrst  2
+qrstu  1
+rstuv  1
+stuvw  1
+tuvwx  1
+uvwzy  1
+vwxyz  1
+wxyza  1
+PREHOOK: query: SELECT cvarchar, count(*) FROM parquet_types GROUP BY cvarchar 
ORDER BY cvarchar
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT cvarchar, count(*) FROM parquet_types GROUP BY 
cvarchar ORDER BY cvarchar
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+B4F3CAFDBE     1
+a      1
+ab     1
+abc    2
+abcd   1
+abcdd  1
+abcde  3
+abcded 4
+abcdede        3
+abcdedef       1
+abcdef 1
+abcdefg        1
+abcdefgh       1
+b      1
+PREHOOK: query: SELECT cstring1, count(*) FROM parquet_types GROUP BY cstring1 
ORDER BY cstring1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT cstring1, count(*) FROM parquet_types GROUP BY 
cstring1 ORDER BY cstring1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+abc    1
+bcd    1
+cde    1
+def    1
+efg    1
+fgh    1
+ghi    1
+hij    1
+ijk    1
+jkl    1
+klm    1
+lmn    1
+mno    1
+nop    1
+pqr    1
+qrs    2
+stu    1
+vwx    1
+wxy    1
+yza    1
+zab    1
+PREHOOK: query: SELECT t, count(*) FROM parquet_types GROUP BY t ORDER BY t
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT t, count(*) FROM parquet_types GROUP BY t ORDER BY t
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+2011-01-01 01:01:01.111111111  1
+2012-02-02 02:02:02.222222222  1
+2013-03-03 03:03:03.333333333  1
+2014-04-04 04:04:04.444444444  1
+2015-05-05 05:05:05.555555555  1
+2016-06-06 06:06:06.666666666  1
+2017-07-07 07:07:07.777777777  1
+2018-08-08 08:08:08.888888888  1
+2019-09-09 09:09:09.999999999  1
+2020-10-10 10:10:10.101010101  1
+2021-11-11 11:11:11.111111111  1
+2022-12-12 12:12:12.121212121  1
+2023-01-02 13:13:13.131313131  1
+2024-02-02 14:14:14.141414141  1
+2025-03-03 15:15:15.151515151  1
+2026-04-04 16:16:16.161616161  1
+2027-05-05 17:17:17.171717171  1
+2028-06-06 18:18:18.181818181  1
+2029-07-07 19:19:19.191919191  1
+2030-08-08 20:20:20.202020202  1
+2031-09-09 21:21:21.212121212  1
+2032-10-10 22:22:22.222222222  1
+PREHOOK: query: SELECT hex(cbinary), count(*) FROM parquet_types GROUP BY 
cbinary
+PREHOOK: type: QUERY
+PREHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT hex(cbinary), count(*) FROM parquet_types GROUP BY 
cbinary
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@parquet_types
+#### A masked pattern was here ####
+       1
+68656C6C6F     1
+68692CCAC0BDE7 10
+B4F3CAFDBEDD   10

Reply via email to