You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by sd...@apache.org on 2011/08/12 21:21:38 UTC
svn commit: r1157222 [2/3] - in /hive/trunk:
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/java/org/apache/hadoop/hive/ql/udf/
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/
ql/src/test/queries/clie...
Added: hive/trunk/ql/src/test/queries/clientpositive/timestamp_3.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/timestamp_3.q?rev=1157222&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/timestamp_3.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/timestamp_3.q Fri Aug 12 19:21:36 2011
@@ -0,0 +1,17 @@
+drop table timestamp_3;
+
+create table timestamp_3 (t timestamp);
+alter table timestamp_3 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe';
+
+insert overwrite table timestamp_3
+ select cast(cast('1.3041352164485E9' as double) as timestamp) from src limit 1;
+select cast(t as boolean) from timestamp_3 limit 1;
+select cast(t as tinyint) from timestamp_3 limit 1;
+select cast(t as smallint) from timestamp_3 limit 1;
+select cast(t as int) from timestamp_3 limit 1;
+select cast(t as bigint) from timestamp_3 limit 1;
+select cast(t as float) from timestamp_3 limit 1;
+select cast(t as double) from timestamp_3 limit 1;
+select cast(t as string) from timestamp_3 limit 1;
+
+drop table timestamp_3;
Added: hive/trunk/ql/src/test/queries/clientpositive/timestamp_comparison.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/timestamp_comparison.q?rev=1157222&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/timestamp_comparison.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/timestamp_comparison.q Fri Aug 12 19:21:36 2011
@@ -0,0 +1,28 @@
+
+select cast('2011-05-06 07:08:09' as timestamp) >
+ cast('2011-05-06 07:08:09' as timestamp) from src limit 1;
+
+select cast('2011-05-06 07:08:09' as timestamp) <
+ cast('2011-05-06 07:08:09' as timestamp) from src limit 1;
+
+select cast('2011-05-06 07:08:09' as timestamp) =
+ cast('2011-05-06 07:08:09' as timestamp) from src limit 1;
+
+select cast('2011-05-06 07:08:09' as timestamp) <>
+ cast('2011-05-06 07:08:09' as timestamp) from src limit 1;
+
+select cast('2011-05-06 07:08:09' as timestamp) >=
+ cast('2011-05-06 07:08:09' as timestamp) from src limit 1;
+
+select cast('2011-05-06 07:08:09' as timestamp) <=
+ cast('2011-05-06 07:08:09' as timestamp) from src limit 1;
+
+select cast('2011-05-06 07:08:09' as timestamp) >=
+ cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1;
+
+select cast('2011-05-06 07:08:09' as timestamp) <
+ cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1;
+
+select cast('2011-05-06 07:08:09.1000' as timestamp) =
+ cast('2011-05-06 07:08:09.1' as timestamp) from src limit 1;
+
Added: hive/trunk/ql/src/test/queries/clientpositive/timestamp_udf.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/timestamp_udf.q?rev=1157222&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/timestamp_udf.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/timestamp_udf.q Fri Aug 12 19:21:36 2011
@@ -0,0 +1,47 @@
+drop table timestamp_udf;
+drop table timestamp_udf_string;
+
+create table timestamp_udf (t timestamp);
+create table timestamp_udf_string (t string);
+from src
+ insert overwrite table timestamp_udf
+ select '2011-05-06 07:08:09.1234567' limit 1
+ insert overwrite table timestamp_udf_string
+ select '2011-05-06 07:08:09.1234567' limit 1;
+
+-- Test UDFs with Timestamp input
+select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
+ weekofyear(t), hour(t), minute(t), second(t), to_date(t)
+ from timestamp_udf;
+
+select date_add(t, 5), date_sub(t, 10)
+ from timestamp_udf;
+
+select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t)
+ from timestamp_udf;
+
+select from_utc_timestamp(t, 'America/Chicago')
+ from timestamp_udf;
+
+select to_utc_timestamp(t, 'America/Chicago')
+ from timestamp_udf;
+
+
+-- Test UDFs with string input
+select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
+ weekofyear(t), hour(t), minute(t), second(t), to_date(t)
+ from timestamp_udf_string;
+
+select date_add(t, 5), date_sub(t, 10) from timestamp_udf_string;
+
+select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t)
+ from timestamp_udf_string;
+
+select from_utc_timestamp(t, 'America/Chicago')
+ from timestamp_udf_string;
+
+select to_utc_timestamp(t, 'America/Chicago')
+ from timestamp_udf_string;
+
+drop table timestamp_udf;
+drop table timestamp_udf_string;
Modified: hive/trunk/ql/src/test/results/clientnegative/invalid_create_tbl1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_create_tbl1.q.out?rev=1157222&r1=1157221&r2=1157222&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_create_tbl1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_create_tbl1.q.out Fri Aug 12 19:21:36 2011
@@ -1 +1 @@
-FAILED: Error in semantic analysis: DATE, DATETIME, and TIMESTAMP types aren't supported yet. Please use STRING instead
+FAILED: Error in semantic analysis: DATE and DATETIME types aren't supported yet. Please use TIMESTAMP instead
Modified: hive/trunk/ql/src/test/results/clientnegative/invalid_t_alter1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_t_alter1.q.out?rev=1157222&r1=1157221&r2=1157222&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_t_alter1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_t_alter1.q.out Fri Aug 12 19:21:36 2011
@@ -3,4 +3,4 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE alter_test (d STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter_test
-FAILED: Error in semantic analysis: DATE, DATETIME, and TIMESTAMP types aren't supported yet. Please use STRING instead
+FAILED: Error in semantic analysis: DATE and DATETIME types aren't supported yet. Please use TIMESTAMP instead
Modified: hive/trunk/ql/src/test/results/clientnegative/invalid_t_alter2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_t_alter2.q.out?rev=1157222&r1=1157221&r2=1157222&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_t_alter2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_t_alter2.q.out Fri Aug 12 19:21:36 2011
@@ -3,4 +3,4 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE alter_test (d STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter_test
-FAILED: Error in semantic analysis: DATE, DATETIME, and TIMESTAMP types aren't supported yet. Please use STRING instead
+FAILED: Error in semantic analysis: DATE and DATETIME types aren't supported yet. Please use TIMESTAMP instead
Modified: hive/trunk/ql/src/test/results/clientnegative/invalid_t_create1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_t_create1.q.out?rev=1157222&r1=1157221&r2=1157222&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_t_create1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_t_create1.q.out Fri Aug 12 19:21:36 2011
@@ -1 +1 @@
-FAILED: Error in semantic analysis: DATE, DATETIME, and TIMESTAMP types aren't supported yet. Please use STRING instead
+FAILED: Error in semantic analysis: DATE and DATETIME types aren't supported yet. Please use TIMESTAMP instead
Modified: hive/trunk/ql/src/test/results/clientnegative/invalid_t_create2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_t_create2.q.out?rev=1157222&r1=1157221&r2=1157222&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_t_create2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_t_create2.q.out Fri Aug 12 19:21:36 2011
@@ -1 +1 @@
-FAILED: Error in semantic analysis: DATE, DATETIME, and TIMESTAMP types aren't supported yet. Please use STRING instead
+FAILED: Error in semantic analysis: DATE and DATETIME types aren't supported yet. Please use TIMESTAMP instead
Modified: hive/trunk/ql/src/test/results/clientnegative/invalid_t_transform.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_t_transform.q.out?rev=1157222&r1=1157221&r2=1157222&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_t_transform.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_t_transform.q.out Fri Aug 12 19:21:36 2011
@@ -1 +1 @@
-FAILED: Error in semantic analysis: DATE, DATETIME, and TIMESTAMP types aren't supported yet. Please use STRING instead
+FAILED: Error in semantic analysis: DATE and DATETIME types aren't supported yet. Please use TIMESTAMP instead
Modified: hive/trunk/ql/src/test/results/clientnegative/wrong_column_type.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/wrong_column_type.q.out?rev=1157222&r1=1157221&r2=1157222&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/wrong_column_type.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/wrong_column_type.q.out Fri Aug 12 19:21:36 2011
@@ -3,4 +3,4 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(a float)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@dest1
-FAILED: Error in semantic analysis: No matching method for class org.apache.hadoop.hive.ql.udf.UDFToFloat with (array<double>). Possible choices: _FUNC_(void) _FUNC_(boolean) _FUNC_(tinyint) _FUNC_(smallint) _FUNC_(int) _FUNC_(bigint) _FUNC_(double) _FUNC_(string)
+FAILED: Error in semantic analysis: No matching method for class org.apache.hadoop.hive.ql.udf.UDFToFloat with (array<double>). Possible choices: _FUNC_(void) _FUNC_(boolean) _FUNC_(tinyint) _FUNC_(smallint) _FUNC_(int) _FUNC_(bigint) _FUNC_(double) _FUNC_(string) _FUNC_(timestamp)
Modified: hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out?rev=1157222&r1=1157221&r2=1157222&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out Fri Aug 12 19:21:36 2011
@@ -66,6 +66,7 @@ find_in_set
float
floor
from_unixtime
+from_utc_timestamp
get_json_object
hash
hex
@@ -142,8 +143,10 @@ substr
substring
sum
tan
+timestamp
tinyint
to_date
+to_utc_timestamp
trim
ucase
unhex
Added: hive/trunk/ql/src/test/results/clientpositive/timestamp_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_1.q.out?rev=1157222&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_1.q.out Fri Aug 12 19:21:36 2011
@@ -0,0 +1,712 @@
+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 []
Added: hive/trunk/ql/src/test/results/clientpositive/timestamp_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_2.q.out?rev=1157222&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_2.q.out Fri Aug 12 19:21:36 2011
@@ -0,0 +1,712 @@
+PREHOOK: query: drop table timestamp_2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table timestamp_2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table timestamp_2 (t timestamp)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table timestamp_2 (t timestamp)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@timestamp_2
+PREHOOK: query: alter table timestamp_2 set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe'
+PREHOOK: type: ALTERTABLE_SERIALIZER
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: alter table timestamp_2 set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe'
+POSTHOOK: type: ALTERTABLE_SERIALIZER
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: default@timestamp_2
+PREHOOK: query: insert overwrite table timestamp_2
+ 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_2
+POSTHOOK: query: insert overwrite table timestamp_2
+ 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_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-09_254_1677780486046903577/-mr-10000
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-09_254_1677780486046903577/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-12_174_8355246285977609781/-mr-10000
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-12_174_8355246285977609781/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-15_187_1474177769686631179/-mr-10000
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-15_187_1474177769686631179/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-18_135_6674553302810288601/-mr-10000
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-18_135_6674553302810288601/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-21_147_7439441759500528969/-mr-10000
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-21_147_7439441759500528969/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-24_157_8137342921467725858/-mr-10000
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-24_157_8137342921467725858/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-27_115_7570510000112541754/-mr-10000
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-27_115_7570510000112541754/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.293872461E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-30_149_7863201428865842908/-mr-10000
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-30_149_7863201428865842908/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+2011-01-01 01:01:01
+PREHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01' from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01' from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-37_326_6078939667797496082/-mr-10000
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-37_326_6078939667797496082/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-40_421_5280108096226979833/-mr-10000
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-40_421_5280108096226979833/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-43_387_7406640498703670553/-mr-10000
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-43_387_7406640498703670553/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-46_302_8260175709422432937/-mr-10000
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-46_302_8260175709422432937/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-49_276_8483419191999330874/-mr-10000
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-49_276_8483419191999330874/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-52_296_2341700485252035168/-mr-10000
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-52_296_2341700485252035168/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-55_268_9219554481193433449/-mr-10000
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-55_268_9219554481193433449/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.293872461E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-58_231_8887436648539780808/-mr-10000
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-48-58_231_8887436648539780808/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+2011-01-01 01:01:01
+PREHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01.1' from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01.1' from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-05_930_3486792034390357603/-mr-10000
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-05_930_3486792034390357603/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-08_943_7831453960584727401/-mr-10000
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-08_943_7831453960584727401/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-11_943_4793990075197886013/-mr-10000
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-11_943_4793990075197886013/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-14_870_3758505695282442742/-mr-10000
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-14_870_3758505695282442742/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-17_883_2914296100063525715/-mr-10000
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-17_883_2914296100063525715/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-20_934_3487178570616336367/-mr-10000
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-20_934_3487178570616336367/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-23_902_4484213838609434018/-mr-10000
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-23_902_4484213838609434018/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.2938724611E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-26_954_2336095754116315212/-mr-10000
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-26_954_2336095754116315212/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+2011-01-01 01:01:01.1
+PREHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01.0001' from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01.0001' from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-34_653_4781838027058443331/-mr-10000
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-34_653_4781838027058443331/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-38_304_1317016439907140832/-mr-10000
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-38_304_1317016439907140832/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-41_275_9148893321464358248/-mr-10000
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-41_275_9148893321464358248/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-44_254_5017580943982042165/-mr-10000
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-44_254_5017580943982042165/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-47_208_6485422477749545271/-mr-10000
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-47_208_6485422477749545271/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-50_163_1281533183229086880/-mr-10000
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-50_163_1281533183229086880/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-53_184_8143474264472938500/-mr-10000
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-53_184_8143474264472938500/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.2938724610001E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-56_154_7984370185735682521/-mr-10000
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-49-56_154_7984370185735682521/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+2011-01-01 01:01:01.0001
+PREHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01.000100000' from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01.000100000' from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-03_569_5946080326619912392/-mr-10000
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-03_569_5946080326619912392/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-06_591_5565829922065788266/-mr-10000
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-06_591_5565829922065788266/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-09_607_2753204269820264462/-mr-10000
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-09_607_2753204269820264462/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-13_240_3438652433892606992/-mr-10000
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-13_240_3438652433892606992/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-16_215_8956544347440517321/-mr-10000
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-16_215_8956544347440517321/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-19_172_5977493939798601065/-mr-10000
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-19_172_5977493939798601065/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-22_179_704915874158342655/-mr-10000
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-22_179_704915874158342655/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.2938724610001E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-25_227_2626758837651763278/-mr-10000
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-25_227_2626758837651763278/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+2011-01-01 01:01:01.0001
+PREHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01.001000011' from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: insert overwrite table timestamp_2
+ select '2011-01-01 01:01:01.001000011' from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+PREHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-32_419_7429589015864428572/-mr-10000
+POSTHOOK: query: select cast(t as boolean) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-32_419_7429589015864428572/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+true
+PREHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-35_412_4900591732686437088/-mr-10000
+POSTHOOK: query: select cast(t as tinyint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-35_412_4900591732686437088/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+77
+PREHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-38_318_138268242299761700/-mr-10000
+POSTHOOK: query: select cast(t as smallint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-38_318_138268242299761700/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+-4787
+PREHOOK: query: select cast(t as int) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-41_280_7066940416696071705/-mr-10000
+POSTHOOK: query: select cast(t as int) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-41_280_7066940416696071705/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-44_251_8058715338324634255/-mr-10000
+POSTHOOK: query: select cast(t as bigint) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-44_251_8058715338324634255/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1293872461
+PREHOOK: query: select cast(t as float) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-47_224_5898144204382843545/-mr-10000
+POSTHOOK: query: select cast(t as float) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-47_224_5898144204382843545/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.29387251E9
+PREHOOK: query: select cast(t as double) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-50_190_2151309129086457111/-mr-10000
+POSTHOOK: query: select cast(t as double) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-50_190_2151309129086457111/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+1.293872461001E9
+PREHOOK: query: select cast(t as string) from timestamp_2 limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-53_108_1539319794662532942/-mr-10000
+POSTHOOK: query: select cast(t as string) from timestamp_2 limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: file:/tmp/franklin/hive_2011-07-01_12-50-53_108_1539319794662532942/-mr-10000
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+2011-01-01 01:01:01.001000011
+PREHOOK: query: drop table timestamp_2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@timestamp_2
+PREHOOK: Output: default@timestamp_2
+POSTHOOK: query: drop table timestamp_2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@timestamp_2
+POSTHOOK: Output: default@timestamp_2
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
+POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
Added: hive/trunk/ql/src/test/results/clientpositive/timestamp_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_3.q.out?rev=1157222&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_3.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_3.q.out Fri Aug 12 19:21:36 2011
@@ -0,0 +1,117 @@
+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 []