You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by mm...@apache.org on 2016/12/12 09:51:44 UTC
[3/4] hive git commit: HIVE-15338: Wrong result from non-vectorized
DATEDIFF with scalar parameter of type DATE/TIMESTAMP (Matt McCline,
reviewed by Jason Dere)
http://git-wip-us.apache.org/repos/asf/hive/blob/6ef0b507/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out b/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out
index f45e730..42d1a35 100644
--- a/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out
@@ -58,6 +58,7 @@ POSTHOOK: Input: default@date_udf_flight
POSTHOOK: Output: default@date_udf_flight_orc
POSTHOOK: Lineage: date_udf_flight_orc.fl_date SIMPLE [(date_udf_flight)date_udf_flight.FieldSchema(name:fl_date, type:date, comment:null), ]
POSTHOOK: Lineage: date_udf_flight_orc.fl_time EXPRESSION [(date_udf_flight)date_udf_flight.FieldSchema(name:fl_date, type:date, comment:null), ]
+fl_date c1
PREHOOK: query: SELECT * FROM date_udf_flight_orc
PREHOOK: type: QUERY
PREHOOK: Input: default@date_udf_flight_orc
@@ -66,6 +67,7 @@ POSTHOOK: query: SELECT * FROM date_udf_flight_orc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@date_udf_flight_orc
#### A masked pattern was here ####
+date_udf_flight_orc.fl_date date_udf_flight_orc.fl_time
2010-10-20 2010-10-20 07:00:00
2010-10-20 2010-10-20 07:00:00
2010-10-20 2010-10-20 07:00:00
@@ -204,6 +206,7 @@ POSTHOOK: Input: default@date_udf_flight_orc
2010-10-31 2010-10-31 07:00:00
2010-10-31 2010-10-31 07:00:00
PREHOOK: query: EXPLAIN SELECT
+ fl_time,
to_unix_timestamp(fl_time),
year(fl_time),
month(fl_time),
@@ -215,10 +218,18 @@ PREHOOK: query: EXPLAIN SELECT
to_date(fl_time),
date_add(fl_time, 2),
date_sub(fl_time, 2),
- datediff(fl_time, "2000-01-01")
+ datediff(fl_time, "2000-01-01"),
+ datediff(fl_time, date "2000-01-01"),
+ datediff(fl_time, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_time, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_time, "2007-03-14"),
+ datediff(fl_time, date "2007-03-14"),
+ datediff(fl_time, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_time, timestamp "2007-03-14 08:21:59")
FROM date_udf_flight_orc
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT
+ fl_time,
to_unix_timestamp(fl_time),
year(fl_time),
month(fl_time),
@@ -230,9 +241,17 @@ POSTHOOK: query: EXPLAIN SELECT
to_date(fl_time),
date_add(fl_time, 2),
date_sub(fl_time, 2),
- datediff(fl_time, "2000-01-01")
+ datediff(fl_time, "2000-01-01"),
+ datediff(fl_time, date "2000-01-01"),
+ datediff(fl_time, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_time, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_time, "2007-03-14"),
+ datediff(fl_time, date "2007-03-14"),
+ datediff(fl_time, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_time, timestamp "2007-03-14 08:21:59")
FROM date_udf_flight_orc
POSTHOOK: type: QUERY
+Explain
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -244,11 +263,12 @@ STAGE PLANS:
TableScan
alias: date_udf_flight_orc
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), 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
+ expressions: fl_time (type: timestamp), 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), datediff(fl_time, 2000-01-01) (type: int), datediff(fl_time, 2000-01-01 00:00:00.0) (type: int), datediff(fl_time, 2000-01-01 11:13:09.0) (type: int), datediff(fl_time, '2007-03-14') (type: int), datediff(fl_time, 2007-03-14) (type: int), datediff(fl_time, 2007-03-14 00:00:00.0) (type: int), datediff(fl_time, 2007-03-14 08:21:59.0) (type: int)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
ListSink
PREHOOK: query: SELECT
+ fl_time,
to_unix_timestamp(fl_time),
year(fl_time),
month(fl_time),
@@ -260,12 +280,20 @@ PREHOOK: query: SELECT
to_date(fl_time),
date_add(fl_time, 2),
date_sub(fl_time, 2),
- datediff(fl_time, "2000-01-01")
+ datediff(fl_time, "2000-01-01"),
+ datediff(fl_time, date "2000-01-01"),
+ datediff(fl_time, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_time, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_time, "2007-03-14"),
+ datediff(fl_time, date "2007-03-14"),
+ datediff(fl_time, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_time, timestamp "2007-03-14 08:21:59")
FROM date_udf_flight_orc
PREHOOK: type: QUERY
PREHOOK: Input: default@date_udf_flight_orc
#### A masked pattern was here ####
POSTHOOK: query: SELECT
+ fl_time,
to_unix_timestamp(fl_time),
year(fl_time),
month(fl_time),
@@ -277,149 +305,158 @@ POSTHOOK: query: SELECT
to_date(fl_time),
date_add(fl_time, 2),
date_sub(fl_time, 2),
- datediff(fl_time, "2000-01-01")
+ datediff(fl_time, "2000-01-01"),
+ datediff(fl_time, date "2000-01-01"),
+ datediff(fl_time, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_time, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_time, "2007-03-14"),
+ datediff(fl_time, date "2007-03-14"),
+ datediff(fl_time, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_time, timestamp "2007-03-14 08:21:59")
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 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
+fl_time c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 07:00:00 1287583200 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 07:00:00 1287669600 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 07:00:00 1287756000 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 07:00:00 1287842400 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 07:00:00 1287928800 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 07:00:00 1288015200 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 07:00:00 1288101600 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 07:00:00 1288188000 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 07:00:00 1288274400 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 07:00:00 1288360800 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 07:00:00 1288447200 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-31 07:00:00 1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 07:00:00 1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 07:00:00 1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 07:00:00 1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 07:00:00 1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 07:00:00 1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 07:00:00 1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 07:00:00 1288533600 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
PREHOOK: query: EXPLAIN SELECT
+ fl_date,
to_unix_timestamp(fl_date),
year(fl_date),
month(fl_date),
@@ -431,10 +468,18 @@ PREHOOK: query: EXPLAIN SELECT
to_date(fl_date),
date_add(fl_date, 2),
date_sub(fl_date, 2),
- datediff(fl_date, "2000-01-01")
+ datediff(fl_date, "2000-01-01"),
+ datediff(fl_date, date "2000-01-01"),
+ datediff(fl_date, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_date, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_date, "2007-03-14"),
+ datediff(fl_date, date "2007-03-14"),
+ datediff(fl_date, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_date, timestamp "2007-03-14 08:21:59")
FROM date_udf_flight_orc
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT
+ fl_date,
to_unix_timestamp(fl_date),
year(fl_date),
month(fl_date),
@@ -446,9 +491,17 @@ POSTHOOK: query: EXPLAIN SELECT
to_date(fl_date),
date_add(fl_date, 2),
date_sub(fl_date, 2),
- datediff(fl_date, "2000-01-01")
+ datediff(fl_date, "2000-01-01"),
+ datediff(fl_date, date "2000-01-01"),
+ datediff(fl_date, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_date, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_date, "2007-03-14"),
+ datediff(fl_date, date "2007-03-14"),
+ datediff(fl_date, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_date, timestamp "2007-03-14 08:21:59")
FROM date_udf_flight_orc
POSTHOOK: type: QUERY
+Explain
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -460,11 +513,12 @@ STAGE PLANS:
TableScan
alias: date_udf_flight_orc
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), 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
+ expressions: fl_date (type: date), 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), datediff(fl_date, 2000-01-01) (type: int), datediff(fl_date, 2000-01-01 00:00:00.0) (type: int), datediff(fl_date, 2000-01-01 11:13:09.0) (type: int), datediff(fl_date, '2007-03-14') (type: int), datediff(fl_date, 2007-03-14) (type: int), datediff(fl_date, 2007-03-14 00:00:00.0) (type: int), datediff(fl_date, 2007-03-14 08:21:59.0) (type: int)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
ListSink
PREHOOK: query: SELECT
+ fl_date,
to_unix_timestamp(fl_date),
year(fl_date),
month(fl_date),
@@ -476,12 +530,20 @@ PREHOOK: query: SELECT
to_date(fl_date),
date_add(fl_date, 2),
date_sub(fl_date, 2),
- datediff(fl_date, "2000-01-01")
+ datediff(fl_date, "2000-01-01"),
+ datediff(fl_date, date "2000-01-01"),
+ datediff(fl_date, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_date, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_date, "2007-03-14"),
+ datediff(fl_date, date "2007-03-14"),
+ datediff(fl_date, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_date, timestamp "2007-03-14 08:21:59")
FROM date_udf_flight_orc
PREHOOK: type: QUERY
PREHOOK: Input: default@date_udf_flight_orc
#### A masked pattern was here ####
POSTHOOK: query: SELECT
+ fl_date,
to_unix_timestamp(fl_date),
year(fl_date),
month(fl_date),
@@ -493,149 +555,159 @@ POSTHOOK: query: SELECT
to_date(fl_date),
date_add(fl_date, 2),
date_sub(fl_date, 2),
- datediff(fl_date, "2000-01-01")
+ datediff(fl_date, "2000-01-01"),
+ datediff(fl_date, date "2000-01-01"),
+ datediff(fl_date, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_date, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_date, "2007-03-14"),
+ datediff(fl_date, date "2007-03-14"),
+ datediff(fl_date, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_date, timestamp "2007-03-14 08:21:59")
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 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
+fl_date c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-20 1287558000 2010 10 20 20 4 42 2010-10-20 2010-10-20 2010-10-22 2010-10-18 3945 3945 3945 3945 1316 1316 1316 1316
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-21 1287644400 2010 10 21 21 5 42 2010-10-21 2010-10-21 2010-10-23 2010-10-19 3946 3946 3946 3946 1317 1317 1317 1317
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-22 1287730800 2010 10 22 22 6 42 2010-10-22 2010-10-22 2010-10-24 2010-10-20 3947 3947 3947 3947 1318 1318 1318 1318
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-23 1287817200 2010 10 23 23 7 42 2010-10-23 2010-10-23 2010-10-25 2010-10-21 3948 3948 3948 3948 1319 1319 1319 1319
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-24 1287903600 2010 10 24 24 1 42 2010-10-24 2010-10-24 2010-10-26 2010-10-22 3949 3949 3949 3949 1320 1320 1320 1320
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-25 1287990000 2010 10 25 25 2 43 2010-10-25 2010-10-25 2010-10-27 2010-10-23 3950 3950 3950 3950 1321 1321 1321 1321
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-26 1288076400 2010 10 26 26 3 43 2010-10-26 2010-10-26 2010-10-28 2010-10-24 3951 3951 3951 3951 1322 1322 1322 1322
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-27 1288162800 2010 10 27 27 4 43 2010-10-27 2010-10-27 2010-10-29 2010-10-25 3952 3952 3952 3952 1323 1323 1323 1323
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-28 1288249200 2010 10 28 28 5 43 2010-10-28 2010-10-28 2010-10-30 2010-10-26 3953 3953 3953 3953 1324 1324 1324 1324
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-29 1288335600 2010 10 29 29 6 43 2010-10-29 2010-10-29 2010-10-31 2010-10-27 3954 3954 3954 3954 1325 1325 1325 1325
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-30 1288422000 2010 10 30 30 7 43 2010-10-30 2010-10-30 2010-11-01 2010-10-28 3955 3955 3955 3955 1326 1326 1326 1326
+2010-10-31 1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
+2010-10-31 1288508400 2010 10 31 31 1 43 2010-10-31 2010-10-31 2010-11-02 2010-10-29 3956 3956 3956 3956 1327 1327 1327 1327
PREHOOK: query: EXPLAIN SELECT
+ fl_time,
+ fl_date,
year(fl_time) = year(fl_date),
month(fl_time) = month(fl_date),
day(fl_time) = day(fl_date),
@@ -646,10 +718,21 @@ PREHOOK: query: EXPLAIN SELECT
to_date(fl_time) = to_date(fl_date),
date_add(fl_time, 2) = date_add(fl_date, 2),
date_sub(fl_time, 2) = date_sub(fl_date, 2),
- datediff(fl_time, "2000-01-01") = datediff(fl_date, "2000-01-01")
+ datediff(fl_time, "2000-01-01") = datediff(fl_date, "2000-01-01"),
+ datediff(fl_time, date "2000-01-01") = datediff(fl_date, date "2000-01-01"),
+ datediff(fl_time, timestamp "2000-01-01 00:00:00") = datediff(fl_date, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_time, timestamp "2000-01-01 11:13:09") = datediff(fl_date, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_time, "2007-03-14") = datediff(fl_date, "2007-03-14"),
+ datediff(fl_time, date "2007-03-14") = datediff(fl_date, date "2007-03-14"),
+ datediff(fl_time, timestamp "2007-03-14 00:00:00") = datediff(fl_date, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_time, timestamp "2007-03-14 08:21:59") = datediff(fl_date, timestamp "2007-03-14 08:21:59"),
+ datediff(fl_date, "2000-01-01") = datediff(fl_date, date "2000-01-01"),
+ datediff(fl_date, "2007-03-14") = datediff(fl_date, date "2007-03-14")
FROM date_udf_flight_orc
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT
+ fl_time,
+ fl_date,
year(fl_time) = year(fl_date),
month(fl_time) = month(fl_date),
day(fl_time) = day(fl_date),
@@ -660,9 +743,19 @@ POSTHOOK: query: EXPLAIN SELECT
to_date(fl_time) = to_date(fl_date),
date_add(fl_time, 2) = date_add(fl_date, 2),
date_sub(fl_time, 2) = date_sub(fl_date, 2),
- datediff(fl_time, "2000-01-01") = datediff(fl_date, "2000-01-01")
+ datediff(fl_time, "2000-01-01") = datediff(fl_date, "2000-01-01"),
+ datediff(fl_time, date "2000-01-01") = datediff(fl_date, date "2000-01-01"),
+ datediff(fl_time, timestamp "2000-01-01 00:00:00") = datediff(fl_date, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_time, timestamp "2000-01-01 11:13:09") = datediff(fl_date, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_time, "2007-03-14") = datediff(fl_date, "2007-03-14"),
+ datediff(fl_time, date "2007-03-14") = datediff(fl_date, date "2007-03-14"),
+ datediff(fl_time, timestamp "2007-03-14 00:00:00") = datediff(fl_date, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_time, timestamp "2007-03-14 08:21:59") = datediff(fl_date, timestamp "2007-03-14 08:21:59"),
+ datediff(fl_date, "2000-01-01") = datediff(fl_date, date "2000-01-01"),
+ datediff(fl_date, "2007-03-14") = datediff(fl_date, date "2007-03-14")
FROM date_udf_flight_orc
POSTHOOK: type: QUERY
+Explain
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -674,12 +767,14 @@ STAGE PLANS:
TableScan
alias: date_udf_flight_orc
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), (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
+ expressions: fl_time (type: timestamp), fl_date (type: date), (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), (datediff(fl_time, 2000-01-01) = datediff(fl_date, 2000-01-01)) (type: boolean), (datediff(fl_time, 2000-01-01 00:00:00.0) = datediff(fl_date, 2000-01-01 00:00:00.0)) (type: boolean), (datediff(fl_time, 2000-01-01 11:13:09.0) = datediff(fl_date, 2000-01-01 11:13:09.0)) (type:
boolean), (datediff(fl_time, '2007-03-14') = datediff(fl_date, '2007-03-14')) (type: boolean), (datediff(fl_time, 2007-03-14) = datediff(fl_date, 2007-03-14)) (type: boolean), (datediff(fl_time, 2007-03-14 00:00:00.0) = datediff(fl_date, 2007-03-14 00:00:00.0)) (type: boolean), (datediff(fl_time, 2007-03-14 08:21:59.0) = datediff(fl_date, 2007-03-14 08:21:59.0)) (type: boolean), (datediff(fl_date, '2000-01-01') = datediff(fl_date, 2000-01-01)) (type: boolean), (datediff(fl_date, '2007-03-14') = datediff(fl_date, 2007-03-14)) (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21
ListSink
PREHOOK: query: -- Should all be true or NULL
SELECT
+ fl_time,
+ fl_date,
year(fl_time) = year(fl_date),
month(fl_time) = month(fl_date),
day(fl_time) = day(fl_date),
@@ -690,13 +785,24 @@ SELECT
to_date(fl_time) = to_date(fl_date),
date_add(fl_time, 2) = date_add(fl_date, 2),
date_sub(fl_time, 2) = date_sub(fl_date, 2),
- datediff(fl_time, "2000-01-01") = datediff(fl_date, "2000-01-01")
+ datediff(fl_time, "2000-01-01") = datediff(fl_date, "2000-01-01"),
+ datediff(fl_time, date "2000-01-01") = datediff(fl_date, date "2000-01-01"),
+ datediff(fl_time, timestamp "2000-01-01 00:00:00") = datediff(fl_date, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_time, timestamp "2000-01-01 11:13:09") = datediff(fl_date, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_time, "2007-03-14") = datediff(fl_date, "2007-03-14"),
+ datediff(fl_time, date "2007-03-14") = datediff(fl_date, date "2007-03-14"),
+ datediff(fl_time, timestamp "2007-03-14 00:00:00") = datediff(fl_date, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_time, timestamp "2007-03-14 08:21:59") = datediff(fl_date, timestamp "2007-03-14 08:21:59"),
+ datediff(fl_date, "2000-01-01") = datediff(fl_date, date "2000-01-01"),
+ datediff(fl_date, "2007-03-14") = datediff(fl_date, date "2007-03-14")
FROM date_udf_flight_orc
PREHOOK: type: QUERY
PREHOOK: Input: default@date_udf_flight_orc
#### A masked pattern was here ####
POSTHOOK: query: -- Should all be true or NULL
SELECT
+ fl_time,
+ fl_date,
year(fl_time) = year(fl_date),
month(fl_time) = month(fl_date),
day(fl_time) = day(fl_date),
@@ -707,148 +813,158 @@ SELECT
to_date(fl_time) = to_date(fl_date),
date_add(fl_time, 2) = date_add(fl_date, 2),
date_sub(fl_time, 2) = date_sub(fl_date, 2),
- datediff(fl_time, "2000-01-01") = datediff(fl_date, "2000-01-01")
+ datediff(fl_time, "2000-01-01") = datediff(fl_date, "2000-01-01"),
+ datediff(fl_time, date "2000-01-01") = datediff(fl_date, date "2000-01-01"),
+ datediff(fl_time, timestamp "2000-01-01 00:00:00") = datediff(fl_date, timestamp "2000-01-01 00:00:00"),
+ datediff(fl_time, timestamp "2000-01-01 11:13:09") = datediff(fl_date, timestamp "2000-01-01 11:13:09"),
+ datediff(fl_time, "2007-03-14") = datediff(fl_date, "2007-03-14"),
+ datediff(fl_time, date "2007-03-14") = datediff(fl_date, date "2007-03-14"),
+ datediff(fl_time, timestamp "2007-03-14 00:00:00") = datediff(fl_date, timestamp "2007-03-14 00:00:00"),
+ datediff(fl_time, timestamp "2007-03-14 08:21:59") = datediff(fl_date, timestamp "2007-03-14 08:21:59"),
+ datediff(fl_date, "2000-01-01") = datediff(fl_date, date "2000-01-01"),
+ datediff(fl_date, "2007-03-14") = datediff(fl_date, date "2007-03-14")
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
+fl_time fl_date c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-20 07:00:00 2010-10-20 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-21 07:00:00 2010-10-21 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-22 07:00:00 2010-10-22 true true true true true true true true true true true true true true true true true true true true
+2010-10-23 07:00:00 2010-10-23 true true true true true true true true true true true true true true true true true true true true
+2010-10-23 07:00:00 2010-10-23 true true true true true true true true true true true true true true true true true true true true
+2010-10-23 07:00:00 2010-10-23 true true true true true true true true true true true true true true true true tru
<TRUNCATED>