You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2016/10/11 23:09:59 UTC
[04/22] hive git commit: HIVE-14873: Add UDF for extraction of 'day
of week' (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/59539885/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out b/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out
index 299d3bc..68a2a4d 100644
--- a/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out
+++ b/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out
@@ -209,6 +209,7 @@ PREHOOK: query: EXPLAIN SELECT
month(fl_time),
day(fl_time),
dayofmonth(fl_time),
+ dayofweek(fl_time),
weekofyear(fl_time),
date(fl_time),
to_date(fl_time),
@@ -223,6 +224,7 @@ POSTHOOK: query: EXPLAIN SELECT
month(fl_time),
day(fl_time),
dayofmonth(fl_time),
+ dayofweek(fl_time),
weekofyear(fl_time),
date(fl_time),
to_date(fl_time),
@@ -243,8 +245,8 @@ STAGE PLANS:
alias: date_udf_flight_orc
Statistics: Num rows: 137 Data size: 13152 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: to_unix_timestamp(fl_time) (type: bigint), year(fl_time) (type: int), month(fl_time) (type: int), day(fl_time) (type: int), dayofmonth(fl_time) (type: int), weekofyear(fl_time) (type: int), CAST( fl_time AS DATE) (type: date), to_date(fl_time) (type: date), date_add(fl_time, 2) (type: date), date_sub(fl_time, 2) (type: date), datediff(fl_time, '2000-01-01') (type: int)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+ expressions: to_unix_timestamp(fl_time) (type: bigint), year(fl_time) (type: int), month(fl_time) (type: int), day(fl_time) (type: int), dayofmonth(fl_time) (type: int), dayofweek(fl_time) (type: int), weekofyear(fl_time) (type: int), CAST( fl_time AS DATE) (type: date), to_date(fl_time) (type: date), date_add(fl_time, 2) (type: date), date_sub(fl_time, 2) (type: date), datediff(fl_time, '2000-01-01') (type: int)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
Statistics: Num rows: 137 Data size: 13152 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -267,6 +269,7 @@ PREHOOK: query: SELECT
month(fl_time),
day(fl_time),
dayofmonth(fl_time),
+ dayofweek(fl_time),
weekofyear(fl_time),
date(fl_time),
to_date(fl_time),
@@ -283,6 +286,7 @@ POSTHOOK: query: SELECT
month(fl_time),
day(fl_time),
dayofmonth(fl_time),
+ dayofweek(fl_time),
weekofyear(fl_time),
date(fl_time),
to_date(fl_time),
@@ -293,149 +297,150 @@ FROM date_udf_flight_orc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@date_udf_flight_orc
#### A masked pattern was here ####
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287583200 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287669600 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287756000 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287842400 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287928800 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288015200 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288101600 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288188000 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288274400 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288360800 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288447200 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288533600 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288533600 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288533600 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288533600 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288533600 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288533600 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288533600 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288533600 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
PREHOOK: query: EXPLAIN SELECT
to_unix_timestamp(fl_date),
year(fl_date),
month(fl_date),
day(fl_date),
dayofmonth(fl_date),
+ dayofweek(fl_date),
weekofyear(fl_date),
date(fl_date),
to_date(fl_date),
@@ -450,6 +455,7 @@ POSTHOOK: query: EXPLAIN SELECT
month(fl_date),
day(fl_date),
dayofmonth(fl_date),
+ dayofweek(fl_date),
weekofyear(fl_date),
date(fl_date),
to_date(fl_date),
@@ -470,8 +476,8 @@ STAGE PLANS:
alias: date_udf_flight_orc
Statistics: Num rows: 137 Data size: 13152 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: to_unix_timestamp(fl_date) (type: bigint), year(fl_date) (type: int), month(fl_date) (type: int), day(fl_date) (type: int), dayofmonth(fl_date) (type: int), weekofyear(fl_date) (type: int), fl_date (type: date), to_date(fl_date) (type: date), date_add(fl_date, 2) (type: date), date_sub(fl_date, 2) (type: date), datediff(fl_date, '2000-01-01') (type: int)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+ expressions: to_unix_timestamp(fl_date) (type: bigint), year(fl_date) (type: int), month(fl_date) (type: int), day(fl_date) (type: int), dayofmonth(fl_date) (type: int), dayofweek(fl_date) (type: int), weekofyear(fl_date) (type: int), fl_date (type: date), to_date(fl_date) (type: date), date_add(fl_date, 2) (type: date), date_sub(fl_date, 2) (type: date), datediff(fl_date, '2000-01-01') (type: int)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
Statistics: Num rows: 137 Data size: 13152 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -494,6 +500,7 @@ PREHOOK: query: SELECT
month(fl_date),
day(fl_date),
dayofmonth(fl_date),
+ dayofweek(fl_date),
weekofyear(fl_date),
date(fl_date),
to_date(fl_date),
@@ -510,6 +517,7 @@ POSTHOOK: query: SELECT
month(fl_date),
day(fl_date),
dayofmonth(fl_date),
+ dayofweek(fl_date),
weekofyear(fl_date),
date(fl_date),
to_date(fl_date),
@@ -520,148 +528,149 @@ FROM date_udf_flight_orc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@date_udf_flight_orc
#### A masked pattern was here ####
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287558000 2010 10 20 20 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287644400 2010 10 21 21 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287730800 2010 10 22 22 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287817200 2010 10 23 23 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287903600 2010 10 24 24 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1287990000 2010 10 25 25 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288076400 2010 10 26 26 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288162800 2010 10 27 27 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288249200 2010 10 28 28 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288335600 2010 10 29 29 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288422000 2010 10 30 30 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
-1288508400 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288508400 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288508400 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288508400 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288508400 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288508400 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288508400 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
-1288508400 2010 10 31 31 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955
+1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
+1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956
PREHOOK: query: EXPLAIN SELECT
year(fl_time) = year(fl_date),
month(fl_time) = month(fl_date),
day(fl_time) = day(fl_date),
dayofmonth(fl_time) = dayofmonth(fl_date),
+ dayofweek(fl_time) = dayofweek(fl_date),
weekofyear(fl_time) = weekofyear(fl_date),
date(fl_time) = date(fl_date),
to_date(fl_time) = to_date(fl_date),
@@ -675,6 +684,7 @@ POSTHOOK: query: EXPLAIN SELECT
month(fl_time) = month(fl_date),
day(fl_time) = day(fl_date),
dayofmonth(fl_time) = dayofmonth(fl_date),
+ dayofweek(fl_time) = dayofweek(fl_date),
weekofyear(fl_time) = weekofyear(fl_date),
date(fl_time) = date(fl_date),
to_date(fl_time) = to_date(fl_date),
@@ -695,8 +705,8 @@ STAGE PLANS:
alias: date_udf_flight_orc
Statistics: Num rows: 137 Data size: 13152 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: (year(fl_time) = year(fl_date)) (type: boolean), (month(fl_time) = month(fl_date)) (type: boolean), (day(fl_time) = day(fl_date)) (type: boolean), (dayofmonth(fl_time) = dayofmonth(fl_date)) (type: boolean), (weekofyear(fl_time) = weekofyear(fl_date)) (type: boolean), (CAST( fl_time AS DATE) = fl_date) (type: boolean), (to_date(fl_time) = to_date(fl_date)) (type: boolean), (date_add(fl_time, 2) = date_add(fl_date, 2)) (type: boolean), (date_sub(fl_time, 2) = date_sub(fl_date, 2)) (type: boolean), (datediff(fl_time, '2000-01-01') = datediff(fl_date, '2000-01-01')) (type: boolean)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ expressions: (year(fl_time) = year(fl_date)) (type: boolean), (month(fl_time) = month(fl_date)) (type: boolean), (day(fl_time) = day(fl_date)) (type: boolean), (dayofmonth(fl_time) = dayofmonth(fl_date)) (type: boolean), (dayofweek(fl_time) = dayofweek(fl_date)) (type: boolean), (weekofyear(fl_time) = weekofyear(fl_date)) (type: boolean), (CAST( fl_time AS DATE) = fl_date) (type: boolean), (to_date(fl_time) = to_date(fl_date)) (type: boolean), (date_add(fl_time, 2) = date_add(fl_date, 2)) (type: boolean), (date_sub(fl_time, 2) = date_sub(fl_date, 2)) (type: boolean), (datediff(fl_time, '2000-01-01') = datediff(fl_date, '2000-01-01')) (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
Statistics: Num rows: 137 Data size: 13152 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -719,6 +729,7 @@ SELECT
month(fl_time) = month(fl_date),
day(fl_time) = day(fl_date),
dayofmonth(fl_time) = dayofmonth(fl_date),
+ dayofweek(fl_time) = dayofweek(fl_date),
weekofyear(fl_time) = weekofyear(fl_date),
date(fl_time) = date(fl_date),
to_date(fl_time) = to_date(fl_date),
@@ -735,6 +746,7 @@ SELECT
month(fl_time) = month(fl_date),
day(fl_time) = day(fl_date),
dayofmonth(fl_time) = dayofmonth(fl_date),
+ dayofweek(fl_time) = dayofweek(fl_date),
weekofyear(fl_time) = weekofyear(fl_date),
date(fl_time) = date(fl_date),
to_date(fl_time) = to_date(fl_date),
@@ -745,143 +757,143 @@ FROM date_udf_flight_orc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@date_udf_flight_orc
#### A masked pattern was here ####
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
-true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
+true true true true true true true true true true true
PREHOOK: query: EXPLAIN SELECT
fl_date,
to_date(date_add(fl_date, 2)),