PREHOOK: query: drop table timestamp_udf PREHOOK: type: DROPTABLE POSTHOOK: query: drop table timestamp_udf POSTHOOK: type: DROPTABLE PREHOOK: query: drop table timestamp_udf_string PREHOOK: type: DROPTABLE POSTHOOK: query: drop table timestamp_udf_string POSTHOOK: type: DROPTABLE PREHOOK: query: create table timestamp_udf (t timestamp) PREHOOK: type: CREATETABLE POSTHOOK: query: create table timestamp_udf (t timestamp) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@timestamp_udf PREHOOK: query: create table timestamp_udf_string (t string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table timestamp_udf_string (t string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@timestamp_udf_string PREHOOK: query: 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 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@timestamp_udf PREHOOK: Output: default@timestamp_udf_string POSTHOOK: query: 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 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@timestamp_udf POSTHOOK: Output: default@timestamp_udf_string POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] PREHOOK: query: -- 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 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-23_171_7947076159754995294/-mr-10000 POSTHOOK: query: -- 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 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-23_171_7947076159754995294/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 1304690889 2011 5 6 6 18 7 8 9 2011-05-06 PREHOOK: query: select date_add(t, 5), date_sub(t, 10) from timestamp_udf PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-26_332_7736225081611226782/-mr-10000 POSTHOOK: query: select date_add(t, 5), date_sub(t, 10) from timestamp_udf POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-26_332_7736225081611226782/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 2011-05-11 2011-04-26 PREHOOK: query: select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t) from timestamp_udf PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-29_301_1140620362250414035/-mr-10000 POSTHOOK: query: select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t) from timestamp_udf POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-29_301_1140620362250414035/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 0 3333 -3333 PREHOOK: query: select from_utc_timestamp(t, 'America/Chicago') from timestamp_udf PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-32_281_8587314075270802684/-mr-10000 POSTHOOK: query: select from_utc_timestamp(t, 'America/Chicago') from timestamp_udf POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-32_281_8587314075270802684/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 2011-05-06 02:08:09.2464567 PREHOOK: query: select to_utc_timestamp(t, 'America/Chicago') from timestamp_udf PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-35_219_3365806571591781180/-mr-10000 POSTHOOK: query: select to_utc_timestamp(t, 'America/Chicago') from timestamp_udf POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-35_219_3365806571591781180/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 2011-05-06 12:08:09.2464567 PREHOOK: query: -- 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 PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf_string PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-38_187_2248272713610212604/-mr-10000 POSTHOOK: query: -- 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 POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf_string POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-38_187_2248272713610212604/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 1304690889 2011 5 6 6 18 7 8 9 2011-05-06 PREHOOK: query: select date_add(t, 5), date_sub(t, 10) from timestamp_udf_string PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf_string PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-41_233_7026658402237219829/-mr-10000 POSTHOOK: query: select date_add(t, 5), date_sub(t, 10) from timestamp_udf_string POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf_string POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-41_233_7026658402237219829/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 2011-05-11 2011-04-26 PREHOOK: query: select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t) from timestamp_udf_string PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf_string PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-44_229_1408313723115883676/-mr-10000 POSTHOOK: query: select datediff(t, t), datediff(t, '2002-03-21'), datediff('2002-03-21', t) from timestamp_udf_string POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf_string POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-44_229_1408313723115883676/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 0 3333 -3333 PREHOOK: query: select from_utc_timestamp(t, 'America/Chicago') from timestamp_udf_string PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf_string PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-47_192_7770480524717901723/-mr-10000 POSTHOOK: query: select from_utc_timestamp(t, 'America/Chicago') from timestamp_udf_string POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf_string POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-47_192_7770480524717901723/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 2011-05-06 02:08:09.2464567 PREHOOK: query: select to_utc_timestamp(t, 'America/Chicago') from timestamp_udf_string PREHOOK: type: QUERY PREHOOK: Input: default@timestamp_udf_string PREHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-50_086_9149577780206626620/-mr-10000 POSTHOOK: query: select to_utc_timestamp(t, 'America/Chicago') from timestamp_udf_string POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamp_udf_string POSTHOOK: Output: file:/tmp/franklin/hive_2011-08-10_11-29-50_086_9149577780206626620/-mr-10000 POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] 2011-05-06 12:08:09.2464567 PREHOOK: query: drop table timestamp_udf PREHOOK: type: DROPTABLE PREHOOK: Input: default@timestamp_udf PREHOOK: Output: default@timestamp_udf POSTHOOK: query: drop table timestamp_udf POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@timestamp_udf POSTHOOK: Output: default@timestamp_udf POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE [] PREHOOK: query: drop table timestamp_udf_string PREHOOK: type: DROPTABLE PREHOOK: Input: default@timestamp_udf_string PREHOOK: Output: default@timestamp_udf_string POSTHOOK: query: drop table timestamp_udf_string POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@timestamp_udf_string POSTHOOK: Output: default@timestamp_udf_string POSTHOOK: Lineage: timestamp_udf.t EXPRESSION [] POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE []