http://git-wip-us.apache.org/repos/asf/hive/blob/1f258e96/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out 
b/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out
new file mode 100644
index 0000000..e07739d
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/orc_ppd_date.q.out
@@ -0,0 +1,301 @@
+PREHOOK: query: create table newtypesorc(c char(10), v varchar(10), d 
decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@newtypesorc
+POSTHOOK: query: create table newtypesorc(c char(10), v varchar(10), d 
decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@newtypesorc
+PREHOOK: query: insert overwrite table newtypesorc select * from (select 
cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" 
as date) from src src1 union all select cast("hello" as char(10)), cast("world" 
as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@newtypesorc
+POSTHOOK: query: insert overwrite table newtypesorc select * from (select 
cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" 
as date) from src src1 union all select cast("hello" as char(10)), cast("world" 
as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@newtypesorc
+POSTHOOK: Lineage: newtypesorc.c EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.d EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.da EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.v EXPRESSION []
+PREHOOK: query: -- date data types (EQUAL, NOT_EQUAL, LESS_THAN, 
LESS_THAN_EQUALS, IN, BETWEEN tests)
+select sum(hash(*)) from newtypesorc where da='1970-02-20'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: -- date data types (EQUAL, NOT_EQUAL, LESS_THAN, 
LESS_THAN_EQUALS, IN, BETWEEN tests)
+select sum(hash(*)) from newtypesorc where da='1970-02-20'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da='1970-02-20'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da='1970-02-20'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da= date 
'1970-02-20'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da= date 
'1970-02-20'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
da=cast('1970-02-20' as date)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
da=cast('1970-02-20' as date)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
da=cast('1970-02-20' as date)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
da=cast('1970-02-20' as date)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
da=cast('1970-02-20' as varchar(20))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
da=cast('1970-02-20' as varchar(20))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
da=cast('1970-02-20' as varchar(20))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
da=cast('1970-02-20' as varchar(20))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da!='1970-02-20'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da!='1970-02-20'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da!='1970-02-20'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da!='1970-02-20'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-27'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-27'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-27'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-27'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-29'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-29'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-29'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-29'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-15'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-15'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-15'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<'1970-02-15'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<='1970-02-20'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<='1970-02-20'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<='1970-02-20'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<='1970-02-20'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<='1970-02-27'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<='1970-02-27'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da<='1970-02-27'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da<='1970-02-27'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-21' as date), cast('1970-02-27' as date))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-21' as date), cast('1970-02-27' as date))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-21' as date), cast('1970-02-27' as date))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-21' as date), cast('1970-02-27' as date))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-20' as date), cast('1970-02-27' as date))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-20' as date), cast('1970-02-27' as date))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-20' as date), cast('1970-02-27' as date))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-20' as date), cast('1970-02-27' as date))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-21' as date), cast('1970-02-22' as date))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-21' as date), cast('1970-02-22' as date))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-21' as date), cast('1970-02-22' as date))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da in 
(cast('1970-02-21' as date), cast('1970-02-22' as date))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-19' and '1970-02-22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-19' and '1970-02-22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-19' and '1970-02-22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-19' and '1970-02-22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-19' and '1970-02-28'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-19' and '1970-02-28'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-19' and '1970-02-28'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-19' and '1970-02-28'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-18' and '1970-02-19'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-18' and '1970-02-19'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-18' and '1970-02-19'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where da between 
'1970-02-18' and '1970-02-19'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL

http://git-wip-us.apache.org/repos/asf/hive/blob/1f258e96/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out 
b/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out
new file mode 100644
index 0000000..6ddff10
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/orc_ppd_decimal.q.out
@@ -0,0 +1,490 @@
+PREHOOK: query: create table newtypesorc(c char(10), v varchar(10), d 
decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@newtypesorc
+POSTHOOK: query: create table newtypesorc(c char(10), v varchar(10), d 
decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@newtypesorc
+PREHOOK: query: insert overwrite table newtypesorc select * from (select 
cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" 
as date) from src src1 union all select cast("hello" as char(10)), cast("world" 
as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@newtypesorc
+POSTHOOK: query: insert overwrite table newtypesorc select * from (select 
cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" 
as date) from src src1 union all select cast("hello" as char(10)), cast("world" 
as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@newtypesorc
+POSTHOOK: Lineage: newtypesorc.c EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.d EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.da EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.v EXPRESSION []
+PREHOOK: query: -- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, 
LESS_THAN_EQUALS, IN, BETWEEN tests)
+select sum(hash(*)) from newtypesorc where d=0.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: -- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, 
LESS_THAN_EQUALS, IN, BETWEEN tests)
+select sum(hash(*)) from newtypesorc where d=0.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d=0.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d=0.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d='0.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d='0.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d='0.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d='0.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d=cast('0.22' as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d=cast('0.22' as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d=cast('0.22' as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d=cast('0.22' as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d!=0.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d!=0.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d!=0.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d!=0.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d!='0.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d!='0.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d!='0.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d!='0.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d!=cast('0.22' as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d!=cast('0.22' as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d!=cast('0.22' as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d!=cast('0.22' as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<11.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<11.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<11.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<11.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<'11.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<'11.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<'11.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<'11.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<cast('11.22' as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<cast('11.22' as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<cast('11.22' as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<cast('11.22' as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<='11.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<='11.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<='11.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<='11.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as 
decimal)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as 
decimal)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as 
decimal)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as 
decimal)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22BD
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22BD
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22BD
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22BD
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=12
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=12
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=12
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=12
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.22', '1.0')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.22', 
'1.0')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.22', '1.0')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.22', 
'1.0')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.22', 
'11.22')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.22', 
'11.22')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.22', 
'11.22')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.22', 
'11.22')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', '1.0')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', '1.0')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', '1.0')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', '1.0')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', 0.22)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', 0.22)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', 0.22)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', 0.22)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', 0.22, 
cast('11.22' as float))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', 0.22, 
cast('11.22' as float))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', 0.22, 
cast('11.22' as float))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d in ('0.9', 0.22, 
cast('11.22' as float))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 1000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
1000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 1000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
1000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
'2.0'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
'2.0'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
'2.0'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
'2.0'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
cast(3 as float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
cast(3 as float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
cast(3 as float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 0 and 
cast(3 as float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 1 and 
cast(30 as char(10))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 1 and 
cast(30 as char(10))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d between 1 and 
cast(30 as char(10))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d between 1 and 
cast(30 as char(10))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+334427804500

http://git-wip-us.apache.org/repos/asf/hive/blob/1f258e96/ql/src/test/results/clientpositive/llap/orc_ppd_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/orc_ppd_timestamp.q.out 
b/ql/src/test/results/clientpositive/llap/orc_ppd_timestamp.q.out
new file mode 100644
index 0000000..f1030a9
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/orc_ppd_timestamp.q.out
@@ -0,0 +1,292 @@
+PREHOOK: query: create table newtypesorc(c char(10), v varchar(10), d 
decimal(5,3), ts timestamp) stored as orc 
tblproperties("orc.stripe.size"="16777216")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@newtypesorc
+POSTHOOK: query: create table newtypesorc(c char(10), v varchar(10), d 
decimal(5,3), ts timestamp) stored as orc 
tblproperties("orc.stripe.size"="16777216")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@newtypesorc
+PREHOOK: query: insert overwrite table newtypesorc select * from (select 
cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("2011-01-01 
01:01:01" as timestamp) from src src1 union all select cast("hello" as 
char(10)), cast("world" as varchar(10)), 11.22, cast("2011-01-20 01:01:01" as 
timestamp) from src src2) uniontbl
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@newtypesorc
+POSTHOOK: query: insert overwrite table newtypesorc select * from (select 
cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("2011-01-01 
01:01:01" as timestamp) from src src1 union all select cast("hello" as 
char(10)), cast("world" as varchar(10)), 11.22, cast("2011-01-20 01:01:01" as 
timestamp) from src src2) uniontbl
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@newtypesorc
+POSTHOOK: Lineage: newtypesorc.c EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.d EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.ts EXPRESSION []
+POSTHOOK: Lineage: newtypesorc.v EXPRESSION []
+PREHOOK: query: -- timestamp data types (EQUAL, NOT_EQUAL, LESS_THAN, 
LESS_THAN_EQUALS, IN, BETWEEN tests)
+select sum(hash(*)) from newtypesorc where cast(ts as string)='2011-01-01 
01:01:01'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: -- timestamp data types (EQUAL, NOT_EQUAL, LESS_THAN, 
LESS_THAN_EQUALS, IN, BETWEEN tests)
+select sum(hash(*)) from newtypesorc where cast(ts as string)='2011-01-01 
01:01:01'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where cast(ts as 
string)='2011-01-01 01:01:01'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where cast(ts as 
string)='2011-01-01 01:01:01'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts=cast('2011-01-01 
01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts=cast('2011-01-01 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts=cast('2011-01-01 
01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts=cast('2011-01-01 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts=cast('2011-01-01 
01:01:01' as varchar(20))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts=cast('2011-01-01 01:01:01' as varchar(20))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts=cast('2011-01-01 
01:01:01' as varchar(20))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts=cast('2011-01-01 01:01:01' as varchar(20))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
ts!=cast('2011-01-01 01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts!=cast('2011-01-01 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1033237945500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
ts!=cast('2011-01-01 01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts!=cast('2011-01-01 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1033237945500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts<cast('2011-01-20 
01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<cast('2011-01-20 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts<cast('2011-01-20 
01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<cast('2011-01-20 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts<cast('2011-01-22 
01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<cast('2011-01-22 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1478890961000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts<cast('2011-01-22 
01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<cast('2011-01-22 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1478890961000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts<cast('2010-10-01 
01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<cast('2010-10-01 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts<cast('2010-10-01 
01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<cast('2010-10-01 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<=cast('2011-01-01 01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<=cast('2011-01-01 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<=cast('2011-01-01 01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<=cast('2011-01-01 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<=cast('2011-01-20 01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<=cast('2011-01-20 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1478890961000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<=cast('2011-01-20 01:01:01' as timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where 
ts<=cast('2011-01-20 01:01:01' as timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1478890961000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as 
timestamp))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as 
timestamp))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1033237945500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as 
timestamp))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as 
timestamp))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1033237945500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as 
timestamp))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as 
timestamp))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1478890961000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as 
timestamp))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as 
timestamp))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1478890961000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as 
timestamp))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as 
timestamp))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as 
timestamp))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts in 
(cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as 
timestamp))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as 
timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as 
timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as 
timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as 
timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+445653015500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as 
timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as 
timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1478890961000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as 
timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as 
timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+1478890961000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as 
timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as 
timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL
+PREHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as 
timestamp)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where ts between 
cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as 
timestamp)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+NULL

http://git-wip-us.apache.org/repos/asf/hive/blob/1f258e96/ql/src/test/results/clientpositive/llap/parquet_ppd_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/parquet_ppd_decimal.q.out 
b/ql/src/test/results/clientpositive/llap/parquet_ppd_decimal.q.out
new file mode 100644
index 0000000..5b1669e
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/parquet_ppd_decimal.q.out
@@ -0,0 +1,858 @@
+PREHOOK: query: create table newtypestbl(c char(10), v varchar(10), d 
decimal(5,3), da date) stored as parquet
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@newtypestbl
+POSTHOOK: query: create table newtypestbl(c char(10), v varchar(10), d 
decimal(5,3), da date) stored as parquet
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@newtypestbl
+PREHOOK: query: insert overwrite table newtypestbl select * from (select 
cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" 
as date) from src src1 union all select cast("hello" as char(10)), cast("world" 
as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) 
uniontbl
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@newtypestbl
+POSTHOOK: query: insert overwrite table newtypestbl select * from (select 
cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" 
as date) from src src1 union all select cast("hello" as char(10)), cast("world" 
as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) 
uniontbl
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@newtypestbl
+POSTHOOK: Lineage: newtypestbl.c EXPRESSION []
+POSTHOOK: Lineage: newtypestbl.d EXPRESSION []
+POSTHOOK: Lineage: newtypestbl.da EXPRESSION []
+POSTHOOK: Lineage: newtypestbl.v EXPRESSION []
+PREHOOK: query: -- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, 
LESS_THAN_EQUALS, IN, BETWEEN tests)
+select * from newtypestbl where d=0.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: -- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, 
LESS_THAN_EQUALS, IN, BETWEEN tests)
+select * from newtypestbl where d=0.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+PREHOOK: query: select * from newtypestbl where d=0.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d=0.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+apple          bee     0.22    1970-02-20
+PREHOOK: query: select * from newtypestbl where d='0.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d='0.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d='0.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d='0.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d=cast('0.22' as float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d=cast('0.22' as float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d=cast('0.22' as float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d=cast('0.22' as float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d!=0.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d!=0.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d!=0.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d!=0.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d!='0.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d!='0.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d!='0.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d!='0.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d!=cast('0.22' as float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d!=cast('0.22' as float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d!=cast('0.22' as float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d!=cast('0.22' as float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d<11.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<11.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<11.22
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<11.22
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<'11.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<'11.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<'11.22'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<'11.22'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<cast('11.22' as float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<cast('11.22' as float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<cast('11.22' as float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<cast('11.22' as float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=11.22 sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=11.22 sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=11.22 sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=11.22 sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<='11.22' sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<='11.22' sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<='11.22' sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<='11.22' sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=cast('11.22' as float) sort 
by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=cast('11.22' as float) 
sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=cast('11.22' as float) sort 
by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=cast('11.22' as float) 
sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=cast('11.22' as decimal)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=cast('11.22' as decimal)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=cast('11.22' as decimal)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=cast('11.22' as decimal)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=11.22BD sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=11.22BD sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=11.22BD sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=11.22BD sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=12 sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=12 sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d<=12 sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d<=12 sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d in ('0.22', '1.0')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.22', '1.0')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d in ('0.22', '1.0')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.22', '1.0')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d in ('0.22', '11.22') sort by 
c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.22', '11.22') sort 
by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d in ('0.22', '11.22') sort by 
c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.22', '11.22') sort 
by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d in ('0.9', '1.0')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.9', '1.0')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d in ('0.9', '1.0')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.9', '1.0')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d in ('0.9', 0.22)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.9', 0.22)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d in ('0.9', 0.22)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.9', 0.22)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d in ('0.9', 0.22, 
cast('11.22' as float)) sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.9', 0.22, 
cast('11.22' as float)) sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d in ('0.9', 0.22, 
cast('11.22' as float)) sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d in ('0.9', 0.22, 
cast('11.22' as float)) sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 0 and 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 0 and 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 0 and 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 0 and 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 0 and 1000 sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 0 and 1000 sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 0 and 1000 sort by c
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 0 and 1000 sort by c
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 0 and '2.0'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 0 and '2.0'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 0 and '2.0'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 0 and '2.0'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 0 and cast(3 as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 0 and cast(3 as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 0 and cast(3 as 
float)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 0 and cast(3 as 
float)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+apple          bee     0.220   1970-02-20
+PREHOOK: query: select * from newtypestbl where d between 1 and cast(30 as 
char(10))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 1 and cast(30 as 
char(10))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+PREHOOK: query: select * from newtypestbl where d between 1 and cast(30 as 
char(10))
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####
+POSTHOOK: query: select * from newtypestbl where d between 1 and cast(30 as 
char(10))
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypestbl
+#### A masked pattern was here ####

Reply via email to