| PREHOOK: query: create table newtypesorc_n2(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_n2 |
| POSTHOOK: query: create table newtypesorc_n2(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_n2 |
| PREHOOK: query: insert overwrite table newtypesorc_n2 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_n2 |
| POSTHOOK: query: insert overwrite table newtypesorc_n2 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_n2 |
| POSTHOOK: Lineage: newtypesorc_n2.c EXPRESSION [] |
| POSTHOOK: Lineage: newtypesorc_n2.d EXPRESSION [] |
| POSTHOOK: Lineage: newtypesorc_n2.ts EXPRESSION [] |
| POSTHOOK: Lineage: newtypesorc_n2.v EXPRESSION [] |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where cast(ts as string)='2011-01-01 01:01:01' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where cast(ts as string)='2011-01-01 01:01:01' |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where cast(ts as string)='2011-01-01 01:01:01' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where cast(ts as string)='2011-01-01 01:01:01' |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts=cast('2011-01-01 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts=cast('2011-01-01 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts=cast('2011-01-01 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts=cast('2011-01-01 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts=cast('2011-01-01 01:01:01' as varchar(20)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts=cast('2011-01-01 01:01:01' as varchar(20)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts=cast('2011-01-01 01:01:01' as varchar(20)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts=cast('2011-01-01 01:01:01' as varchar(20)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts!=cast('2011-01-01 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts!=cast('2011-01-01 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 1033237945500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts!=cast('2011-01-01 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts!=cast('2011-01-01 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 1033237945500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2011-01-20 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2011-01-20 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2011-01-20 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2011-01-20 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2011-01-22 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2011-01-22 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 1478890961000 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2011-01-22 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2011-01-22 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 1478890961000 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2010-10-01 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2010-10-01 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| NULL |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2010-10-01 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<cast('2010-10-01 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| NULL |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<=cast('2011-01-01 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<=cast('2011-01-01 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<=cast('2011-01-01 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<=cast('2011-01-01 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<=cast('2011-01-20 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<=cast('2011-01-20 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 1478890961000 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<=cast('2011-01-20 01:01:01' as timestamp) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 where ts<=cast('2011-01-20 01:01:01' as timestamp) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@newtypesorc_n2 |
| #### A masked pattern was here #### |
| 1478890961000 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| 1033237945500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| 1033237945500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| 1478890961000 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| 1478890961000 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| NULL |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| NULL |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| 445653015500 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| 1478890961000 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| 1478890961000 |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| NULL |
| PREHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select sum(hash(*)) from newtypesorc_n2 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_n2 |
| #### A masked pattern was here #### |
| NULL |
