PREHOOK: query: drop table timestamp_1 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table timestamp_1 POSTHOOK: type: DROPTABLE PREHOOK: query: create table timestamp_1 (t timestamp) PREHOOK: type: CREATETABLE POSTHOOK: query: create table timestamp_1 (t timestamp) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@timestamp_1 PREHOOK: query: alter table timestamp_1 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: default@timestamp_1 PREHOOK: Output: default@timestamp_1 POSTHOOK: query: alter table timestamp_1 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: default@timestamp_1 PREHOOK: query: insert overwrite table timestamp_1 select cast('2011-01-01 01:01:01' as timestamp) from src limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@timestamp_1 POSTHOOK: query: insert overwrite table timestamp_1 select cast('2011-01-01 01:01:01' as timestamp) from src limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@timestamp_1 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-15_673_4408273775422868450/-mr-10000 POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-15_673_4408273775422868450/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] true PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-18_746_4932103921783133339/-mr-10000 POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-18_746_4932103921783133339/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 77 PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-21_844_2708388659244936027/-mr-10000 POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-21_844_2708388659244936027/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] -4787 PREHOOK: query: select cast(t as int) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-24_813_5716956451308382894/-mr-10000 POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-24_813_5716956451308382894/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-27_803_3878179276965005826/-mr-10000 POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-27_803_3878179276965005826/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as float) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-30_804_2580978481528947425/-mr-10000 POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-30_804_2580978481528947425/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.29387251E9 PREHOOK: query: select cast(t as double) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-33_798_3197380634598936966/-mr-10000 POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-33_798_3197380634598936966/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.293872461E9 PREHOOK: query: select cast(t as string) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-36_812_6243303470519170009/-mr-10000 POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-36_812_6243303470519170009/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 2011-01-01 01:01:01 PREHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01' from src limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@timestamp_1 POSTHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01' from src limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@timestamp_1 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-44_244_5130987512739326820/-mr-10000 POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-44_244_5130987512739326820/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] true PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-47_287_1896639484614005520/-mr-10000 POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-47_287_1896639484614005520/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 77 PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-50_264_7576388328084060202/-mr-10000 POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-50_264_7576388328084060202/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] -4787 PREHOOK: query: select cast(t as int) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-53_318_2662382568138024277/-mr-10000 POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-53_318_2662382568138024277/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-56_346_1338506489498661596/-mr-10000 POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-56_346_1338506489498661596/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as float) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-59_334_8696543905725057752/-mr-10000 POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-45-59_334_8696543905725057752/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.29387251E9 PREHOOK: query: select cast(t as double) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-02_296_9027609210976973562/-mr-10000 POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-02_296_9027609210976973562/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.293872461E9 PREHOOK: query: select cast(t as string) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-05_413_380961111206156155/-mr-10000 POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-05_413_380961111206156155/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 2011-01-01 01:01:01 PREHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01.1' from src limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@timestamp_1 POSTHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01.1' from src limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@timestamp_1 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-13_125_2829877051145525726/-mr-10000 POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-13_125_2829877051145525726/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] true PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-16_102_221424930441519001/-mr-10000 POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-16_102_221424930441519001/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 77 PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-19_100_3256033535416125006/-mr-10000 POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-19_100_3256033535416125006/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] -4787 PREHOOK: query: select cast(t as int) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-22_141_7327077506146237178/-mr-10000 POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-22_141_7327077506146237178/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-25_118_9143022508800283596/-mr-10000 POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-25_118_9143022508800283596/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as float) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-28_133_4899745479711547176/-mr-10000 POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-28_133_4899745479711547176/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.29387251E9 PREHOOK: query: select cast(t as double) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-31_158_6071620138802537791/-mr-10000 POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-31_158_6071620138802537791/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.2938724611E9 PREHOOK: query: select cast(t as string) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-34_077_8863957917848291181/-mr-10000 POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-34_077_8863957917848291181/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 2011-01-01 01:01:01.1 PREHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01.0001' from src limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@timestamp_1 POSTHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01.0001' from src limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@timestamp_1 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-42_422_5361315899348240189/-mr-10000 POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-42_422_5361315899348240189/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] true PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-45_399_7074034405805928504/-mr-10000 POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-45_399_7074034405805928504/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 77 PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-48_365_2263022985271121719/-mr-10000 POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-48_365_2263022985271121719/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] -4787 PREHOOK: query: select cast(t as int) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-51_436_4608699469856775030/-mr-10000 POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-51_436_4608699469856775030/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-54_392_6106265740670014927/-mr-10000 POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-54_392_6106265740670014927/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as float) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-57_367_8456247319189738989/-mr-10000 POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-46-57_367_8456247319189738989/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.29387251E9 PREHOOK: query: select cast(t as double) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-00_366_7133266320643115499/-mr-10000 POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-00_366_7133266320643115499/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.2938724610001E9 PREHOOK: query: select cast(t as string) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-03_370_1351556572087437830/-mr-10000 POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-03_370_1351556572087437830/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 2011-01-01 01:01:01.0001 PREHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01.000100000' from src limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@timestamp_1 POSTHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01.000100000' from src limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@timestamp_1 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-10_610_5835184626602663461/-mr-10000 POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-10_610_5835184626602663461/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] true PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-13_688_5426752860397638090/-mr-10000 POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-13_688_5426752860397638090/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 77 PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-16_966_6773207551250357174/-mr-10000 POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-16_966_6773207551250357174/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] -4787 PREHOOK: query: select cast(t as int) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-19_930_5956276359267603771/-mr-10000 POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-19_930_5956276359267603771/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-22_978_248645095092367626/-mr-10000 POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-22_978_248645095092367626/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as float) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-25_954_6895029739153598575/-mr-10000 POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-25_954_6895029739153598575/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.29387251E9 PREHOOK: query: select cast(t as double) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-28_872_4006824349208780207/-mr-10000 POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-28_872_4006824349208780207/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.2938724610001E9 PREHOOK: query: select cast(t as string) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-31_857_9124887287659879381/-mr-10000 POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-31_857_9124887287659879381/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 2011-01-01 01:01:01.0001 PREHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01.001000011' from src limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@timestamp_1 POSTHOOK: query: insert overwrite table timestamp_1 select '2011-01-01 01:01:01.001000011' from src limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@timestamp_1 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] PREHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-39_097_2912851854986589105/-mr-10000 POSTHOOK: query: select cast(t as boolean) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-39_097_2912851854986589105/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] true PREHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-42_183_6209542158732663786/-mr-10000 POSTHOOK: query: select cast(t as tinyint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-42_183_6209542158732663786/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 77 PREHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-45_151_3041031375905365547/-mr-10000 POSTHOOK: query: select cast(t as smallint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-45_151_3041031375905365547/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] -4787 PREHOOK: query: select cast(t as int) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-48_115_378030164207951662/-mr-10000 POSTHOOK: query: select cast(t as int) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-48_115_378030164207951662/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-51_092_6580623353477276765/-mr-10000 POSTHOOK: query: select cast(t as bigint) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-51_092_6580623353477276765/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1293872461 PREHOOK: query: select cast(t as float) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-54_446_1520269806265117369/-mr-10000 POSTHOOK: query: select cast(t as float) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-54_446_1520269806265117369/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.29387251E9 PREHOOK: query: select cast(t as double) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-57_416_9191166993746767552/-mr-10000 POSTHOOK: query: select cast(t as double) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-47-57_416_9191166993746767552/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 1.293872461001E9 PREHOOK: query: select cast(t as string) from timestamp_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_1 PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-00_377_2365300502030781927/-mr-10000 POSTHOOK: query: select cast(t as string) from timestamp_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-00_377_2365300502030781927/-mr-10000 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] 2011-01-01 01:01:01.001000011 PREHOOK: query: drop table timestamp_1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@timestamp_1 PREHOOK: Output: default@timestamp_1 POSTHOOK: query: drop table timestamp_1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@timestamp_1 POSTHOOK: Output: default@timestamp_1 POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION [] POSTHOOK: Lineage: timestamp_1.t EXPRESSION []