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
POSTHOOK: query: create table timestamp_3 (t timestamp)
POSTHOOK: type: CREATETABLE
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 limit 1
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 limit 1
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
PREHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-42_712_2101699211172053884/-mr-10000
POSTHOOK: query: select cast(t as boolean) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-42_712_2101699211172053884/-mr-10000
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
true
PREHOOK: query: select cast(t as tinyint) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-45_765_7701431663402206845/-mr-10000
POSTHOOK: query: select cast(t as tinyint) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-45_765_7701431663402206845/-mr-10000
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
48
PREHOOK: query: select cast(t as smallint) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-48_782_8290139959636610814/-mr-10000
POSTHOOK: query: select cast(t as smallint) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-48_782_8290139959636610814/-mr-10000
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
-31184
PREHOOK: query: select cast(t as int) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-51_797_8902671576244167018/-mr-10000
POSTHOOK: query: select cast(t as int) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-51_797_8902671576244167018/-mr-10000
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
1304135216
PREHOOK: query: select cast(t as bigint) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-54_798_1817155502241746935/-mr-10000
POSTHOOK: query: select cast(t as bigint) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-54_798_1817155502241746935/-mr-10000
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
1304135216
PREHOOK: query: select cast(t as float) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-57_795_1565227465212020714/-mr-10000
POSTHOOK: query: select cast(t as float) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-15-57_795_1565227465212020714/-mr-10000
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
1.30413517E9
PREHOOK: query: select cast(t as double) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-16-00_781_1914812716492368483/-mr-10000
POSTHOOK: query: select cast(t as double) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-16-00_781_1914812716492368483/-mr-10000
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
1.3041352164485E9
PREHOOK: query: select cast(t as string) from timestamp_3 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_3
PREHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-16-03_877_4595413304622996657/-mr-10000
POSTHOOK: query: select cast(t as string) from timestamp_3 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@timestamp_3
POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-08_15-16-03_877_4595413304622996657/-mr-10000
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []
2011-04-29 20:46:56.4485
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
POSTHOOK: Lineage: timestamp_3.t EXPRESSION []