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