PREHOOK: query: drop table timestamp_3
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table timestamp_3
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table timestamp_3 (t timestamp)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@timestamp_3
POSTHOOK: query: create table timestamp_3 (t timestamp)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@timestamp_3
PREHOOK: query: alter table timestamp_3 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
PREHOOK: type: ALTERTABLE_SERIALIZER
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: default@timestamp_3
POSTHOOK: query: alter table timestamp_3 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
POSTHOOK: type: ALTERTABLE_SERIALIZER
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: default@timestamp_3
PREHOOK: query: insert overwrite table timestamp_3
  select cast(cast('1.3041352164485E9' as double) as timestamp) from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@timestamp_3
POSTHOOK: query: insert overwrite table timestamp_3
  select cast(cast('1.3041352164485E9' as double) as timestamp) from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@timestamp_3
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
PREHOOK: query: select cast(t as boolean) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select cast(t as boolean) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
true
PREHOOK: query: select cast(t as tinyint) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select cast(t as tinyint) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
48
PREHOOK: query: select cast(t as smallint) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select cast(t as smallint) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
-31184
PREHOOK: query: select cast(t as int) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select cast(t as int) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
1304135216
PREHOOK: query: select cast(t as bigint) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select cast(t as bigint) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
1304135216
PREHOOK: query: select cast(t as float) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select cast(t as float) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
1.30413517E9
PREHOOK: query: select cast(t as double) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select cast(t as double) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
1.3041352164485E9
PREHOOK: query: select cast(t as string) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select cast(t as string) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
2011-04-29 20:46:56.4485
PREHOOK: query: select t, sum(t), count(*), sum(t)/count(*), avg(t) from timestamp_3 group by t
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
POSTHOOK: query: select t, sum(t), count(*), sum(t)/count(*), avg(t) from timestamp_3 group by t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
#### A masked pattern was here ####
2011-04-29 20:46:56.4485	1.3041352164485E9	1	1.3041352164485E9	1.3041352164485E9
PREHOOK: query: drop table timestamp_3
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: default@timestamp_3
POSTHOOK: query: drop table timestamp_3
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: default@timestamp_3