You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/10/14 06:52:13 UTC
svn commit: r1631612 [3/3] - in /hive/trunk: itests/src/test/resources/
ql/src/java/org/apache/hadoop/hive/ql/exec/vector/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
ql/src/test/results/clientpositive/tez/
Added: hive/trunk/ql/src/test/results/clientpositive/vector_partitioned_date_time.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_partitioned_date_time.q.out?rev=1631612&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_partitioned_date_time.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_partitioned_date_time.q.out Tue Oct 14 04:52:12 2014
@@ -0,0 +1,2042 @@
+PREHOOK: query: -- Check if vectorization code is handling partitioning on DATE and the other data types.
+
+
+CREATE TABLE flights_tiny (
+ origin_city_name STRING,
+ dest_city_name STRING,
+ fl_date DATE,
+ arr_delay FLOAT,
+ fl_num INT
+)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@flights_tiny
+POSTHOOK: query: -- Check if vectorization code is handling partitioning on DATE and the other data types.
+
+
+CREATE TABLE flights_tiny (
+ origin_city_name STRING,
+ dest_city_name STRING,
+ fl_date DATE,
+ arr_delay FLOAT,
+ fl_num INT
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@flights_tiny
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE flights_tiny
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@flights_tiny
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE flights_tiny
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@flights_tiny
+PREHOOK: query: CREATE TABLE flights_tiny_orc STORED AS ORC AS
+SELECT origin_city_name, dest_city_name, fl_date, to_utc_timestamp(fl_date, 'America/Los_Angeles') as fl_time, arr_delay, fl_num
+FROM flights_tiny
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@flights_tiny
+PREHOOK: Output: database:default
+PREHOOK: Output: default@flights_tiny_orc
+POSTHOOK: query: CREATE TABLE flights_tiny_orc STORED AS ORC AS
+SELECT origin_city_name, dest_city_name, fl_date, to_utc_timestamp(fl_date, 'America/Los_Angeles') as fl_time, arr_delay, fl_num
+FROM flights_tiny
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@flights_tiny
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@flights_tiny_orc
+PREHOOK: query: SELECT * FROM flights_tiny_orc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM flights_tiny_orc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+Baltimore New York 2010-10-20 2010-10-20 07:00:00 -30.0 1064
+Baltimore New York 2010-10-20 2010-10-20 07:00:00 23.0 1142
+Baltimore New York 2010-10-20 2010-10-20 07:00:00 6.0 1599
+Chicago New York 2010-10-20 2010-10-20 07:00:00 42.0 361
+Chicago New York 2010-10-20 2010-10-20 07:00:00 24.0 897
+Chicago New York 2010-10-20 2010-10-20 07:00:00 15.0 1531
+Chicago New York 2010-10-20 2010-10-20 07:00:00 -6.0 1610
+Chicago New York 2010-10-20 2010-10-20 07:00:00 -2.0 3198
+Baltimore New York 2010-10-21 2010-10-21 07:00:00 17.0 1064
+Baltimore New York 2010-10-21 2010-10-21 07:00:00 105.0 1142
+Baltimore New York 2010-10-21 2010-10-21 07:00:00 28.0 1599
+Chicago New York 2010-10-21 2010-10-21 07:00:00 142.0 361
+Chicago New York 2010-10-21 2010-10-21 07:00:00 77.0 897
+Chicago New York 2010-10-21 2010-10-21 07:00:00 53.0 1531
+Chicago New York 2010-10-21 2010-10-21 07:00:00 -5.0 1610
+Chicago New York 2010-10-21 2010-10-21 07:00:00 51.0 3198
+Baltimore New York 2010-10-22 2010-10-22 07:00:00 -12.0 1064
+Baltimore New York 2010-10-22 2010-10-22 07:00:00 54.0 1142
+Baltimore New York 2010-10-22 2010-10-22 07:00:00 18.0 1599
+Chicago New York 2010-10-22 2010-10-22 07:00:00 2.0 361
+Chicago New York 2010-10-22 2010-10-22 07:00:00 24.0 897
+Chicago New York 2010-10-22 2010-10-22 07:00:00 16.0 1531
+Chicago New York 2010-10-22 2010-10-22 07:00:00 -6.0 1610
+Chicago New York 2010-10-22 2010-10-22 07:00:00 -11.0 3198
+Baltimore New York 2010-10-23 2010-10-23 07:00:00 18.0 272
+Baltimore New York 2010-10-23 2010-10-23 07:00:00 -10.0 1805
+Baltimore New York 2010-10-23 2010-10-23 07:00:00 6.0 3171
+Chicago New York 2010-10-23 2010-10-23 07:00:00 3.0 384
+Chicago New York 2010-10-23 2010-10-23 07:00:00 32.0 426
+Chicago New York 2010-10-23 2010-10-23 07:00:00 1.0 650
+Chicago New York 2010-10-23 2010-10-23 07:00:00 11.0 3085
+Baltimore New York 2010-10-24 2010-10-24 07:00:00 12.0 1599
+Baltimore New York 2010-10-24 2010-10-24 07:00:00 20.0 2571
+Chicago New York 2010-10-24 2010-10-24 07:00:00 10.0 361
+Chicago New York 2010-10-24 2010-10-24 07:00:00 113.0 897
+Chicago New York 2010-10-24 2010-10-24 07:00:00 -5.0 1531
+Chicago New York 2010-10-24 2010-10-24 07:00:00 -17.0 1610
+Chicago New York 2010-10-24 2010-10-24 07:00:00 -3.0 3198
+Baltimore New York 2010-10-25 2010-10-25 07:00:00 -25.0 1064
+Baltimore New York 2010-10-25 2010-10-25 07:00:00 92.0 1142
+Baltimore New York 2010-10-25 2010-10-25 07:00:00 106.0 1599
+Chicago New York 2010-10-25 2010-10-25 07:00:00 31.0 361
+Chicago New York 2010-10-25 2010-10-25 07:00:00 -1.0 897
+Chicago New York 2010-10-25 2010-10-25 07:00:00 43.0 1531
+Chicago New York 2010-10-25 2010-10-25 07:00:00 6.0 1610
+Chicago New York 2010-10-25 2010-10-25 07:00:00 -16.0 3198
+Baltimore New York 2010-10-26 2010-10-26 07:00:00 -22.0 1064
+Baltimore New York 2010-10-26 2010-10-26 07:00:00 123.0 1142
+Baltimore New York 2010-10-26 2010-10-26 07:00:00 90.0 1599
+Chicago New York 2010-10-26 2010-10-26 07:00:00 12.0 361
+Chicago New York 2010-10-26 2010-10-26 07:00:00 0.0 897
+Chicago New York 2010-10-26 2010-10-26 07:00:00 29.0 1531
+Chicago New York 2010-10-26 2010-10-26 07:00:00 -17.0 1610
+Chicago New York 2010-10-26 2010-10-26 07:00:00 6.0 3198
+Baltimore New York 2010-10-27 2010-10-27 07:00:00 -18.0 1064
+Baltimore New York 2010-10-27 2010-10-27 07:00:00 49.0 1142
+Baltimore New York 2010-10-27 2010-10-27 07:00:00 92.0 1599
+Chicago New York 2010-10-27 2010-10-27 07:00:00 148.0 361
+Chicago New York 2010-10-27 2010-10-27 07:00:00 -11.0 897
+Chicago New York 2010-10-27 2010-10-27 07:00:00 70.0 1531
+Chicago New York 2010-10-27 2010-10-27 07:00:00 8.0 1610
+Chicago New York 2010-10-27 2010-10-27 07:00:00 21.0 3198
+Baltimore New York 2010-10-28 2010-10-28 07:00:00 -4.0 1064
+Baltimore New York 2010-10-28 2010-10-28 07:00:00 -14.0 1142
+Baltimore New York 2010-10-28 2010-10-28 07:00:00 -14.0 1599
+Chicago New York 2010-10-28 2010-10-28 07:00:00 2.0 361
+Chicago New York 2010-10-28 2010-10-28 07:00:00 2.0 897
+Chicago New York 2010-10-28 2010-10-28 07:00:00 -11.0 1531
+Chicago New York 2010-10-28 2010-10-28 07:00:00 3.0 1610
+Chicago New York 2010-10-28 2010-10-28 07:00:00 -18.0 3198
+Baltimore New York 2010-10-29 2010-10-29 07:00:00 -24.0 1064
+Baltimore New York 2010-10-29 2010-10-29 07:00:00 21.0 1142
+Baltimore New York 2010-10-29 2010-10-29 07:00:00 -2.0 1599
+Chicago New York 2010-10-29 2010-10-29 07:00:00 -12.0 361
+Chicago New York 2010-10-29 2010-10-29 07:00:00 -11.0 897
+Chicago New York 2010-10-29 2010-10-29 07:00:00 15.0 1531
+Chicago New York 2010-10-29 2010-10-29 07:00:00 -18.0 1610
+Chicago New York 2010-10-29 2010-10-29 07:00:00 -4.0 3198
+Baltimore New York 2010-10-30 2010-10-30 07:00:00 14.0 272
+Baltimore New York 2010-10-30 2010-10-30 07:00:00 -1.0 1805
+Baltimore New York 2010-10-30 2010-10-30 07:00:00 5.0 3171
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -6.0 384
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -10.0 426
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -5.0 650
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -5.0 3085
+Baltimore New York 2010-10-31 2010-10-31 07:00:00 -1.0 1599
+Baltimore New York 2010-10-31 2010-10-31 07:00:00 -14.0 2571
+Chicago New York 2010-10-31 2010-10-31 07:00:00 -25.0 361
+Chicago New York 2010-10-31 2010-10-31 07:00:00 -18.0 897
+Chicago New York 2010-10-31 2010-10-31 07:00:00 -4.0 1531
+Chicago New York 2010-10-31 2010-10-31 07:00:00 -22.0 1610
+Chicago New York 2010-10-31 2010-10-31 07:00:00 -15.0 3198
+Cleveland New York 2010-10-30 2010-10-30 07:00:00 -23.0 2018
+Cleveland New York 2010-10-30 2010-10-30 07:00:00 -12.0 2932
+Cleveland New York 2010-10-29 2010-10-29 07:00:00 -4.0 2630
+Cleveland New York 2010-10-29 2010-10-29 07:00:00 -19.0 2646
+Cleveland New York 2010-10-29 2010-10-29 07:00:00 -12.0 3014
+Cleveland New York 2010-10-28 2010-10-28 07:00:00 3.0 2630
+Cleveland New York 2010-10-28 2010-10-28 07:00:00 -6.0 2646
+Cleveland New York 2010-10-28 2010-10-28 07:00:00 1.0 3014
+Cleveland New York 2010-10-27 2010-10-27 07:00:00 16.0 2630
+Cleveland New York 2010-10-27 2010-10-27 07:00:00 27.0 3014
+Cleveland New York 2010-10-26 2010-10-26 07:00:00 4.0 2630
+Cleveland New York 2010-10-26 2010-10-26 07:00:00 -27.0 2646
+Cleveland New York 2010-10-26 2010-10-26 07:00:00 -11.0 2662
+Cleveland New York 2010-10-26 2010-10-26 07:00:00 13.0 3014
+Cleveland New York 2010-10-25 2010-10-25 07:00:00 -4.0 2630
+Cleveland New York 2010-10-25 2010-10-25 07:00:00 81.0 2646
+Cleveland New York 2010-10-25 2010-10-25 07:00:00 42.0 3014
+Cleveland New York 2010-10-24 2010-10-24 07:00:00 5.0 2254
+Cleveland New York 2010-10-24 2010-10-24 07:00:00 -11.0 2630
+Cleveland New York 2010-10-24 2010-10-24 07:00:00 -20.0 2646
+Cleveland New York 2010-10-24 2010-10-24 07:00:00 -9.0 3014
+Cleveland New York 2010-10-23 2010-10-23 07:00:00 -21.0 2932
+Cleveland New York 2010-10-22 2010-10-22 07:00:00 1.0 2630
+Cleveland New York 2010-10-22 2010-10-22 07:00:00 -25.0 2646
+Cleveland New York 2010-10-22 2010-10-22 07:00:00 -3.0 3014
+Cleveland New York 2010-10-21 2010-10-21 07:00:00 3.0 2630
+Cleveland New York 2010-10-21 2010-10-21 07:00:00 29.0 2646
+Cleveland New York 2010-10-21 2010-10-21 07:00:00 72.0 3014
+Cleveland New York 2010-10-20 2010-10-20 07:00:00 -8.0 2630
+Cleveland New York 2010-10-20 2010-10-20 07:00:00 -15.0 3014
+Washington New York 2010-10-23 2010-10-23 07:00:00 -25.0 5832
+Washington New York 2010-10-23 2010-10-23 07:00:00 -21.0 5904
+Washington New York 2010-10-23 2010-10-23 07:00:00 -18.0 5917
+Washington New York 2010-10-30 2010-10-30 07:00:00 -27.0 5904
+Washington New York 2010-10-30 2010-10-30 07:00:00 -16.0 5917
+Washington New York 2010-10-20 2010-10-20 07:00:00 -2.0 7291
+Washington New York 2010-10-21 2010-10-21 07:00:00 22.0 7291
+Washington New York 2010-10-23 2010-10-23 07:00:00 -16.0 7274
+Washington New York 2010-10-24 2010-10-24 07:00:00 -26.0 7282
+Washington New York 2010-10-25 2010-10-25 07:00:00 9.0 7291
+Washington New York 2010-10-26 2010-10-26 07:00:00 4.0 7291
+Washington New York 2010-10-27 2010-10-27 07:00:00 26.0 7291
+Washington New York 2010-10-28 2010-10-28 07:00:00 45.0 7291
+Washington New York 2010-10-29 2010-10-29 07:00:00 1.0 7291
+Washington New York 2010-10-31 2010-10-31 07:00:00 -18.0 7282
+PREHOOK: query: select * from flights_tiny_orc sort by fl_num, fl_date limit 25
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+POSTHOOK: query: select * from flights_tiny_orc sort by fl_num, fl_date limit 25
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+Baltimore New York 2010-10-23 2010-10-23 07:00:00 18.0 272
+Baltimore New York 2010-10-30 2010-10-30 07:00:00 14.0 272
+Chicago New York 2010-10-20 2010-10-20 07:00:00 42.0 361
+Chicago New York 2010-10-21 2010-10-21 07:00:00 142.0 361
+Chicago New York 2010-10-22 2010-10-22 07:00:00 2.0 361
+Chicago New York 2010-10-24 2010-10-24 07:00:00 10.0 361
+Chicago New York 2010-10-25 2010-10-25 07:00:00 31.0 361
+Chicago New York 2010-10-26 2010-10-26 07:00:00 12.0 361
+Chicago New York 2010-10-27 2010-10-27 07:00:00 148.0 361
+Chicago New York 2010-10-28 2010-10-28 07:00:00 2.0 361
+Chicago New York 2010-10-29 2010-10-29 07:00:00 -12.0 361
+Chicago New York 2010-10-31 2010-10-31 07:00:00 -25.0 361
+Chicago New York 2010-10-23 2010-10-23 07:00:00 3.0 384
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -6.0 384
+Chicago New York 2010-10-23 2010-10-23 07:00:00 32.0 426
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -10.0 426
+Chicago New York 2010-10-23 2010-10-23 07:00:00 1.0 650
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -5.0 650
+Chicago New York 2010-10-20 2010-10-20 07:00:00 24.0 897
+Chicago New York 2010-10-21 2010-10-21 07:00:00 77.0 897
+Chicago New York 2010-10-22 2010-10-22 07:00:00 24.0 897
+Chicago New York 2010-10-24 2010-10-24 07:00:00 113.0 897
+Chicago New York 2010-10-25 2010-10-25 07:00:00 -1.0 897
+Chicago New York 2010-10-26 2010-10-26 07:00:00 0.0 897
+Chicago New York 2010-10-27 2010-10-27 07:00:00 -11.0 897
+PREHOOK: query: select fl_date, count(*) from flights_tiny_orc group by fl_date
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+POSTHOOK: query: select fl_date, count(*) from flights_tiny_orc group by fl_date
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+2010-10-20 11
+2010-10-21 12
+2010-10-22 11
+2010-10-23 12
+2010-10-24 12
+2010-10-25 12
+2010-10-26 13
+2010-10-27 11
+2010-10-28 12
+2010-10-29 12
+2010-10-30 11
+2010-10-31 8
+PREHOOK: query: explain
+select * from flights_tiny_orc sort by fl_num, fl_date limit 25
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select * from flights_tiny_orc sort by fl_num, fl_date limit 25
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: flights_tiny_orc
+ Statistics: Num rows: 137 Data size: 39456 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: origin_city_name (type: string), dest_city_name (type: string), fl_date (type: date), fl_time (type: timestamp), arr_delay (type: float), fl_num (type: int)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 137 Data size: 39456 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col5 (type: int), _col2 (type: date)
+ sort order: ++
+ Statistics: Num rows: 137 Data size: 39456 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string), _col3 (type: timestamp), _col4 (type: float)
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), KEY.reducesinkkey1 (type: date), VALUE._col2 (type: timestamp), VALUE._col3 (type: float), KEY.reducesinkkey0 (type: int)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 137 Data size: 39456 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 25
+ Statistics: Num rows: 25 Data size: 7200 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+ Stage: Stage-2
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ Reduce Output Operator
+ key expressions: _col5 (type: int), _col2 (type: date)
+ sort order: ++
+ Statistics: Num rows: 25 Data size: 7200 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string), _col3 (type: timestamp), _col4 (type: float)
+ Reduce Operator Tree:
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), KEY.reducesinkkey1 (type: date), VALUE._col2 (type: timestamp), VALUE._col3 (type: float), KEY.reducesinkkey0 (type: int)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 25 Data size: 7200 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 25
+ Statistics: Num rows: 25 Data size: 7200 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 25 Data size: 7200 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 25
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select * from flights_tiny_orc sort by fl_num, fl_date limit 25
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+POSTHOOK: query: select * from flights_tiny_orc sort by fl_num, fl_date limit 25
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+Baltimore New York 2010-10-23 2010-10-23 07:00:00 18.0 272
+Baltimore New York 2010-10-30 2010-10-30 07:00:00 14.0 272
+Chicago New York 2010-10-20 2010-10-20 07:00:00 42.0 361
+Chicago New York 2010-10-21 2010-10-21 07:00:00 142.0 361
+Chicago New York 2010-10-22 2010-10-22 07:00:00 2.0 361
+Chicago New York 2010-10-24 2010-10-24 07:00:00 10.0 361
+Chicago New York 2010-10-25 2010-10-25 07:00:00 31.0 361
+Chicago New York 2010-10-26 2010-10-26 07:00:00 12.0 361
+Chicago New York 2010-10-27 2010-10-27 07:00:00 148.0 361
+Chicago New York 2010-10-28 2010-10-28 07:00:00 2.0 361
+Chicago New York 2010-10-29 2010-10-29 07:00:00 -12.0 361
+Chicago New York 2010-10-31 2010-10-31 07:00:00 -25.0 361
+Chicago New York 2010-10-23 2010-10-23 07:00:00 3.0 384
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -6.0 384
+Chicago New York 2010-10-23 2010-10-23 07:00:00 32.0 426
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -10.0 426
+Chicago New York 2010-10-23 2010-10-23 07:00:00 1.0 650
+Chicago New York 2010-10-30 2010-10-30 07:00:00 -5.0 650
+Chicago New York 2010-10-20 2010-10-20 07:00:00 24.0 897
+Chicago New York 2010-10-21 2010-10-21 07:00:00 77.0 897
+Chicago New York 2010-10-22 2010-10-22 07:00:00 24.0 897
+Chicago New York 2010-10-24 2010-10-24 07:00:00 113.0 897
+Chicago New York 2010-10-25 2010-10-25 07:00:00 -1.0 897
+Chicago New York 2010-10-26 2010-10-26 07:00:00 0.0 897
+Chicago New York 2010-10-27 2010-10-27 07:00:00 -11.0 897
+PREHOOK: query: explain
+select fl_date, count(*) from flights_tiny_orc group by fl_date
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select fl_date, count(*) from flights_tiny_orc group by fl_date
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: flights_tiny_orc
+ Statistics: Num rows: 137 Data size: 39456 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: fl_date (type: date)
+ outputColumnNames: fl_date
+ Statistics: Num rows: 137 Data size: 39456 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: count()
+ keys: fl_date (type: date)
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 137 Data size: 39456 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: date)
+ Statistics: Num rows: 137 Data size: 39456 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: bigint)
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: count(VALUE._col0)
+ keys: KEY._col0 (type: date)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 68 Data size: 19584 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: date), _col1 (type: bigint)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 68 Data size: 19584 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 68 Data size: 19584 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select fl_date, count(*) from flights_tiny_orc group by fl_date
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+POSTHOOK: query: select fl_date, count(*) from flights_tiny_orc group by fl_date
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc
+#### A masked pattern was here ####
+2010-10-20 11
+2010-10-21 12
+2010-10-22 11
+2010-10-23 12
+2010-10-24 12
+2010-10-25 12
+2010-10-26 13
+2010-10-27 11
+2010-10-28 12
+2010-10-29 12
+2010-10-30 11
+2010-10-31 8
+PREHOOK: query: CREATE TABLE flights_tiny_orc_partitioned_date (
+ origin_city_name STRING,
+ dest_city_name STRING,
+ fl_time TIMESTAMP,
+ arr_delay FLOAT,
+ fl_num INT
+)
+PARTITIONED BY (fl_date DATE)
+STORED AS ORC
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@flights_tiny_orc_partitioned_date
+POSTHOOK: query: CREATE TABLE flights_tiny_orc_partitioned_date (
+ origin_city_name STRING,
+ dest_city_name STRING,
+ fl_time TIMESTAMP,
+ arr_delay FLOAT,
+ fl_num INT
+)
+PARTITIONED BY (fl_date DATE)
+STORED AS ORC
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date
+PREHOOK: query: INSERT INTO TABLE flights_tiny_orc_partitioned_date
+PARTITION (fl_date)
+SELECT origin_city_name, dest_city_name, fl_time, arr_delay, fl_num, fl_date
+FROM flights_tiny_orc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc
+PREHOOK: Output: default@flights_tiny_orc_partitioned_date
+POSTHOOK: query: INSERT INTO TABLE flights_tiny_orc_partitioned_date
+PARTITION (fl_date)
+SELECT origin_city_name, dest_city_name, fl_time, arr_delay, fl_num, fl_date
+FROM flights_tiny_orc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-20).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-20).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-20).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-20).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-20).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-21).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-21).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-21).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-21).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-21).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-22).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-22).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-22).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-22).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-22).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-23).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-23).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-23).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-23).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-23).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-24).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-24).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-24).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-24).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-24).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-25).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-25).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-25).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-25).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-25).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-26).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-26).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-26).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-26).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-26).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-27).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-27).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-27).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-27).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-27).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-28).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-28).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-28).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-28).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-28).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-29).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-29).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-29).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-29).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-29).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-30).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-30).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-30).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-30).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-30).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-31).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-31).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-31).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-31).fl_time SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_time, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_date PARTITION(fl_date=2010-10-31).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+PREHOOK: query: select * from flights_tiny_orc_partitioned_date
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+POSTHOOK: query: select * from flights_tiny_orc_partitioned_date
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+Baltimore New York 2010-10-20 07:00:00 -30.0 1064 2010-10-20
+Baltimore New York 2010-10-20 07:00:00 23.0 1142 2010-10-20
+Baltimore New York 2010-10-20 07:00:00 6.0 1599 2010-10-20
+Chicago New York 2010-10-20 07:00:00 42.0 361 2010-10-20
+Chicago New York 2010-10-20 07:00:00 24.0 897 2010-10-20
+Chicago New York 2010-10-20 07:00:00 15.0 1531 2010-10-20
+Chicago New York 2010-10-20 07:00:00 -6.0 1610 2010-10-20
+Chicago New York 2010-10-20 07:00:00 -2.0 3198 2010-10-20
+Cleveland New York 2010-10-20 07:00:00 -8.0 2630 2010-10-20
+Cleveland New York 2010-10-20 07:00:00 -15.0 3014 2010-10-20
+Washington New York 2010-10-20 07:00:00 -2.0 7291 2010-10-20
+Baltimore New York 2010-10-21 07:00:00 17.0 1064 2010-10-21
+Baltimore New York 2010-10-21 07:00:00 105.0 1142 2010-10-21
+Baltimore New York 2010-10-21 07:00:00 28.0 1599 2010-10-21
+Chicago New York 2010-10-21 07:00:00 142.0 361 2010-10-21
+Chicago New York 2010-10-21 07:00:00 77.0 897 2010-10-21
+Chicago New York 2010-10-21 07:00:00 53.0 1531 2010-10-21
+Chicago New York 2010-10-21 07:00:00 -5.0 1610 2010-10-21
+Chicago New York 2010-10-21 07:00:00 51.0 3198 2010-10-21
+Cleveland New York 2010-10-21 07:00:00 3.0 2630 2010-10-21
+Cleveland New York 2010-10-21 07:00:00 29.0 2646 2010-10-21
+Cleveland New York 2010-10-21 07:00:00 72.0 3014 2010-10-21
+Washington New York 2010-10-21 07:00:00 22.0 7291 2010-10-21
+Baltimore New York 2010-10-22 07:00:00 -12.0 1064 2010-10-22
+Baltimore New York 2010-10-22 07:00:00 54.0 1142 2010-10-22
+Baltimore New York 2010-10-22 07:00:00 18.0 1599 2010-10-22
+Chicago New York 2010-10-22 07:00:00 2.0 361 2010-10-22
+Chicago New York 2010-10-22 07:00:00 24.0 897 2010-10-22
+Chicago New York 2010-10-22 07:00:00 16.0 1531 2010-10-22
+Chicago New York 2010-10-22 07:00:00 -6.0 1610 2010-10-22
+Chicago New York 2010-10-22 07:00:00 -11.0 3198 2010-10-22
+Cleveland New York 2010-10-22 07:00:00 1.0 2630 2010-10-22
+Cleveland New York 2010-10-22 07:00:00 -25.0 2646 2010-10-22
+Cleveland New York 2010-10-22 07:00:00 -3.0 3014 2010-10-22
+Baltimore New York 2010-10-23 07:00:00 18.0 272 2010-10-23
+Baltimore New York 2010-10-23 07:00:00 -10.0 1805 2010-10-23
+Baltimore New York 2010-10-23 07:00:00 6.0 3171 2010-10-23
+Chicago New York 2010-10-23 07:00:00 3.0 384 2010-10-23
+Chicago New York 2010-10-23 07:00:00 32.0 426 2010-10-23
+Chicago New York 2010-10-23 07:00:00 1.0 650 2010-10-23
+Chicago New York 2010-10-23 07:00:00 11.0 3085 2010-10-23
+Cleveland New York 2010-10-23 07:00:00 -21.0 2932 2010-10-23
+Washington New York 2010-10-23 07:00:00 -25.0 5832 2010-10-23
+Washington New York 2010-10-23 07:00:00 -21.0 5904 2010-10-23
+Washington New York 2010-10-23 07:00:00 -18.0 5917 2010-10-23
+Washington New York 2010-10-23 07:00:00 -16.0 7274 2010-10-23
+Baltimore New York 2010-10-24 07:00:00 12.0 1599 2010-10-24
+Baltimore New York 2010-10-24 07:00:00 20.0 2571 2010-10-24
+Chicago New York 2010-10-24 07:00:00 10.0 361 2010-10-24
+Chicago New York 2010-10-24 07:00:00 113.0 897 2010-10-24
+Chicago New York 2010-10-24 07:00:00 -5.0 1531 2010-10-24
+Chicago New York 2010-10-24 07:00:00 -17.0 1610 2010-10-24
+Chicago New York 2010-10-24 07:00:00 -3.0 3198 2010-10-24
+Cleveland New York 2010-10-24 07:00:00 5.0 2254 2010-10-24
+Cleveland New York 2010-10-24 07:00:00 -11.0 2630 2010-10-24
+Cleveland New York 2010-10-24 07:00:00 -20.0 2646 2010-10-24
+Cleveland New York 2010-10-24 07:00:00 -9.0 3014 2010-10-24
+Washington New York 2010-10-24 07:00:00 -26.0 7282 2010-10-24
+Baltimore New York 2010-10-25 07:00:00 -25.0 1064 2010-10-25
+Baltimore New York 2010-10-25 07:00:00 92.0 1142 2010-10-25
+Baltimore New York 2010-10-25 07:00:00 106.0 1599 2010-10-25
+Chicago New York 2010-10-25 07:00:00 31.0 361 2010-10-25
+Chicago New York 2010-10-25 07:00:00 -1.0 897 2010-10-25
+Chicago New York 2010-10-25 07:00:00 43.0 1531 2010-10-25
+Chicago New York 2010-10-25 07:00:00 6.0 1610 2010-10-25
+Chicago New York 2010-10-25 07:00:00 -16.0 3198 2010-10-25
+Cleveland New York 2010-10-25 07:00:00 -4.0 2630 2010-10-25
+Cleveland New York 2010-10-25 07:00:00 81.0 2646 2010-10-25
+Cleveland New York 2010-10-25 07:00:00 42.0 3014 2010-10-25
+Washington New York 2010-10-25 07:00:00 9.0 7291 2010-10-25
+Baltimore New York 2010-10-26 07:00:00 -22.0 1064 2010-10-26
+Baltimore New York 2010-10-26 07:00:00 123.0 1142 2010-10-26
+Baltimore New York 2010-10-26 07:00:00 90.0 1599 2010-10-26
+Chicago New York 2010-10-26 07:00:00 12.0 361 2010-10-26
+Chicago New York 2010-10-26 07:00:00 0.0 897 2010-10-26
+Chicago New York 2010-10-26 07:00:00 29.0 1531 2010-10-26
+Chicago New York 2010-10-26 07:00:00 -17.0 1610 2010-10-26
+Chicago New York 2010-10-26 07:00:00 6.0 3198 2010-10-26
+Cleveland New York 2010-10-26 07:00:00 4.0 2630 2010-10-26
+Cleveland New York 2010-10-26 07:00:00 -27.0 2646 2010-10-26
+Cleveland New York 2010-10-26 07:00:00 -11.0 2662 2010-10-26
+Cleveland New York 2010-10-26 07:00:00 13.0 3014 2010-10-26
+Washington New York 2010-10-26 07:00:00 4.0 7291 2010-10-26
+Baltimore New York 2010-10-27 07:00:00 -18.0 1064 2010-10-27
+Baltimore New York 2010-10-27 07:00:00 49.0 1142 2010-10-27
+Baltimore New York 2010-10-27 07:00:00 92.0 1599 2010-10-27
+Chicago New York 2010-10-27 07:00:00 148.0 361 2010-10-27
+Chicago New York 2010-10-27 07:00:00 -11.0 897 2010-10-27
+Chicago New York 2010-10-27 07:00:00 70.0 1531 2010-10-27
+Chicago New York 2010-10-27 07:00:00 8.0 1610 2010-10-27
+Chicago New York 2010-10-27 07:00:00 21.0 3198 2010-10-27
+Cleveland New York 2010-10-27 07:00:00 16.0 2630 2010-10-27
+Cleveland New York 2010-10-27 07:00:00 27.0 3014 2010-10-27
+Washington New York 2010-10-27 07:00:00 26.0 7291 2010-10-27
+Baltimore New York 2010-10-28 07:00:00 -4.0 1064 2010-10-28
+Baltimore New York 2010-10-28 07:00:00 -14.0 1142 2010-10-28
+Baltimore New York 2010-10-28 07:00:00 -14.0 1599 2010-10-28
+Chicago New York 2010-10-28 07:00:00 2.0 361 2010-10-28
+Chicago New York 2010-10-28 07:00:00 2.0 897 2010-10-28
+Chicago New York 2010-10-28 07:00:00 -11.0 1531 2010-10-28
+Chicago New York 2010-10-28 07:00:00 3.0 1610 2010-10-28
+Chicago New York 2010-10-28 07:00:00 -18.0 3198 2010-10-28
+Cleveland New York 2010-10-28 07:00:00 3.0 2630 2010-10-28
+Cleveland New York 2010-10-28 07:00:00 -6.0 2646 2010-10-28
+Cleveland New York 2010-10-28 07:00:00 1.0 3014 2010-10-28
+Washington New York 2010-10-28 07:00:00 45.0 7291 2010-10-28
+Baltimore New York 2010-10-29 07:00:00 -24.0 1064 2010-10-29
+Baltimore New York 2010-10-29 07:00:00 21.0 1142 2010-10-29
+Baltimore New York 2010-10-29 07:00:00 -2.0 1599 2010-10-29
+Chicago New York 2010-10-29 07:00:00 -12.0 361 2010-10-29
+Chicago New York 2010-10-29 07:00:00 -11.0 897 2010-10-29
+Chicago New York 2010-10-29 07:00:00 15.0 1531 2010-10-29
+Chicago New York 2010-10-29 07:00:00 -18.0 1610 2010-10-29
+Chicago New York 2010-10-29 07:00:00 -4.0 3198 2010-10-29
+Cleveland New York 2010-10-29 07:00:00 -4.0 2630 2010-10-29
+Cleveland New York 2010-10-29 07:00:00 -19.0 2646 2010-10-29
+Cleveland New York 2010-10-29 07:00:00 -12.0 3014 2010-10-29
+Washington New York 2010-10-29 07:00:00 1.0 7291 2010-10-29
+Baltimore New York 2010-10-30 07:00:00 14.0 272 2010-10-30
+Baltimore New York 2010-10-30 07:00:00 -1.0 1805 2010-10-30
+Baltimore New York 2010-10-30 07:00:00 5.0 3171 2010-10-30
+Chicago New York 2010-10-30 07:00:00 -6.0 384 2010-10-30
+Chicago New York 2010-10-30 07:00:00 -10.0 426 2010-10-30
+Chicago New York 2010-10-30 07:00:00 -5.0 650 2010-10-30
+Chicago New York 2010-10-30 07:00:00 -5.0 3085 2010-10-30
+Cleveland New York 2010-10-30 07:00:00 -23.0 2018 2010-10-30
+Cleveland New York 2010-10-30 07:00:00 -12.0 2932 2010-10-30
+Washington New York 2010-10-30 07:00:00 -27.0 5904 2010-10-30
+Washington New York 2010-10-30 07:00:00 -16.0 5917 2010-10-30
+Baltimore New York 2010-10-31 07:00:00 -1.0 1599 2010-10-31
+Baltimore New York 2010-10-31 07:00:00 -14.0 2571 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -25.0 361 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -18.0 897 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -4.0 1531 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -22.0 1610 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -15.0 3198 2010-10-31
+Washington New York 2010-10-31 07:00:00 -18.0 7282 2010-10-31
+PREHOOK: query: select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 25
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+POSTHOOK: query: select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 25
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+Baltimore New York 2010-10-23 07:00:00 18.0 272 2010-10-23
+Baltimore New York 2010-10-30 07:00:00 14.0 272 2010-10-30
+Chicago New York 2010-10-20 07:00:00 42.0 361 2010-10-20
+Chicago New York 2010-10-21 07:00:00 142.0 361 2010-10-21
+Chicago New York 2010-10-22 07:00:00 2.0 361 2010-10-22
+Chicago New York 2010-10-24 07:00:00 10.0 361 2010-10-24
+Chicago New York 2010-10-25 07:00:00 31.0 361 2010-10-25
+Chicago New York 2010-10-26 07:00:00 12.0 361 2010-10-26
+Chicago New York 2010-10-27 07:00:00 148.0 361 2010-10-27
+Chicago New York 2010-10-28 07:00:00 2.0 361 2010-10-28
+Chicago New York 2010-10-29 07:00:00 -12.0 361 2010-10-29
+Chicago New York 2010-10-31 07:00:00 -25.0 361 2010-10-31
+Chicago New York 2010-10-23 07:00:00 3.0 384 2010-10-23
+Chicago New York 2010-10-30 07:00:00 -6.0 384 2010-10-30
+Chicago New York 2010-10-23 07:00:00 32.0 426 2010-10-23
+Chicago New York 2010-10-30 07:00:00 -10.0 426 2010-10-30
+Chicago New York 2010-10-23 07:00:00 1.0 650 2010-10-23
+Chicago New York 2010-10-30 07:00:00 -5.0 650 2010-10-30
+Chicago New York 2010-10-20 07:00:00 24.0 897 2010-10-20
+Chicago New York 2010-10-21 07:00:00 77.0 897 2010-10-21
+Chicago New York 2010-10-22 07:00:00 24.0 897 2010-10-22
+Chicago New York 2010-10-24 07:00:00 113.0 897 2010-10-24
+Chicago New York 2010-10-25 07:00:00 -1.0 897 2010-10-25
+Chicago New York 2010-10-26 07:00:00 0.0 897 2010-10-26
+Chicago New York 2010-10-27 07:00:00 -11.0 897 2010-10-27
+PREHOOK: query: select fl_date, count(*) from flights_tiny_orc_partitioned_date group by fl_date
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+POSTHOOK: query: select fl_date, count(*) from flights_tiny_orc_partitioned_date group by fl_date
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+2010-10-20 11
+2010-10-21 12
+2010-10-22 11
+2010-10-23 12
+2010-10-24 12
+2010-10-25 12
+2010-10-26 13
+2010-10-27 11
+2010-10-28 12
+2010-10-29 12
+2010-10-30 11
+2010-10-31 8
+PREHOOK: query: explain
+select * from flights_tiny_orc_partitioned_date
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select * from flights_tiny_orc_partitioned_date
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: flights_tiny_orc_partitioned_date
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: origin_city_name (type: string), dest_city_name (type: string), fl_time (type: timestamp), arr_delay (type: float), fl_num (type: int), fl_date (type: date)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ ListSink
+
+PREHOOK: query: select * from flights_tiny_orc_partitioned_date
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+POSTHOOK: query: select * from flights_tiny_orc_partitioned_date
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+Baltimore New York 2010-10-20 07:00:00 -30.0 1064 2010-10-20
+Baltimore New York 2010-10-20 07:00:00 23.0 1142 2010-10-20
+Baltimore New York 2010-10-20 07:00:00 6.0 1599 2010-10-20
+Chicago New York 2010-10-20 07:00:00 42.0 361 2010-10-20
+Chicago New York 2010-10-20 07:00:00 24.0 897 2010-10-20
+Chicago New York 2010-10-20 07:00:00 15.0 1531 2010-10-20
+Chicago New York 2010-10-20 07:00:00 -6.0 1610 2010-10-20
+Chicago New York 2010-10-20 07:00:00 -2.0 3198 2010-10-20
+Cleveland New York 2010-10-20 07:00:00 -8.0 2630 2010-10-20
+Cleveland New York 2010-10-20 07:00:00 -15.0 3014 2010-10-20
+Washington New York 2010-10-20 07:00:00 -2.0 7291 2010-10-20
+Baltimore New York 2010-10-21 07:00:00 17.0 1064 2010-10-21
+Baltimore New York 2010-10-21 07:00:00 105.0 1142 2010-10-21
+Baltimore New York 2010-10-21 07:00:00 28.0 1599 2010-10-21
+Chicago New York 2010-10-21 07:00:00 142.0 361 2010-10-21
+Chicago New York 2010-10-21 07:00:00 77.0 897 2010-10-21
+Chicago New York 2010-10-21 07:00:00 53.0 1531 2010-10-21
+Chicago New York 2010-10-21 07:00:00 -5.0 1610 2010-10-21
+Chicago New York 2010-10-21 07:00:00 51.0 3198 2010-10-21
+Cleveland New York 2010-10-21 07:00:00 3.0 2630 2010-10-21
+Cleveland New York 2010-10-21 07:00:00 29.0 2646 2010-10-21
+Cleveland New York 2010-10-21 07:00:00 72.0 3014 2010-10-21
+Washington New York 2010-10-21 07:00:00 22.0 7291 2010-10-21
+Baltimore New York 2010-10-22 07:00:00 -12.0 1064 2010-10-22
+Baltimore New York 2010-10-22 07:00:00 54.0 1142 2010-10-22
+Baltimore New York 2010-10-22 07:00:00 18.0 1599 2010-10-22
+Chicago New York 2010-10-22 07:00:00 2.0 361 2010-10-22
+Chicago New York 2010-10-22 07:00:00 24.0 897 2010-10-22
+Chicago New York 2010-10-22 07:00:00 16.0 1531 2010-10-22
+Chicago New York 2010-10-22 07:00:00 -6.0 1610 2010-10-22
+Chicago New York 2010-10-22 07:00:00 -11.0 3198 2010-10-22
+Cleveland New York 2010-10-22 07:00:00 1.0 2630 2010-10-22
+Cleveland New York 2010-10-22 07:00:00 -25.0 2646 2010-10-22
+Cleveland New York 2010-10-22 07:00:00 -3.0 3014 2010-10-22
+Baltimore New York 2010-10-23 07:00:00 18.0 272 2010-10-23
+Baltimore New York 2010-10-23 07:00:00 -10.0 1805 2010-10-23
+Baltimore New York 2010-10-23 07:00:00 6.0 3171 2010-10-23
+Chicago New York 2010-10-23 07:00:00 3.0 384 2010-10-23
+Chicago New York 2010-10-23 07:00:00 32.0 426 2010-10-23
+Chicago New York 2010-10-23 07:00:00 1.0 650 2010-10-23
+Chicago New York 2010-10-23 07:00:00 11.0 3085 2010-10-23
+Cleveland New York 2010-10-23 07:00:00 -21.0 2932 2010-10-23
+Washington New York 2010-10-23 07:00:00 -25.0 5832 2010-10-23
+Washington New York 2010-10-23 07:00:00 -21.0 5904 2010-10-23
+Washington New York 2010-10-23 07:00:00 -18.0 5917 2010-10-23
+Washington New York 2010-10-23 07:00:00 -16.0 7274 2010-10-23
+Baltimore New York 2010-10-24 07:00:00 12.0 1599 2010-10-24
+Baltimore New York 2010-10-24 07:00:00 20.0 2571 2010-10-24
+Chicago New York 2010-10-24 07:00:00 10.0 361 2010-10-24
+Chicago New York 2010-10-24 07:00:00 113.0 897 2010-10-24
+Chicago New York 2010-10-24 07:00:00 -5.0 1531 2010-10-24
+Chicago New York 2010-10-24 07:00:00 -17.0 1610 2010-10-24
+Chicago New York 2010-10-24 07:00:00 -3.0 3198 2010-10-24
+Cleveland New York 2010-10-24 07:00:00 5.0 2254 2010-10-24
+Cleveland New York 2010-10-24 07:00:00 -11.0 2630 2010-10-24
+Cleveland New York 2010-10-24 07:00:00 -20.0 2646 2010-10-24
+Cleveland New York 2010-10-24 07:00:00 -9.0 3014 2010-10-24
+Washington New York 2010-10-24 07:00:00 -26.0 7282 2010-10-24
+Baltimore New York 2010-10-25 07:00:00 -25.0 1064 2010-10-25
+Baltimore New York 2010-10-25 07:00:00 92.0 1142 2010-10-25
+Baltimore New York 2010-10-25 07:00:00 106.0 1599 2010-10-25
+Chicago New York 2010-10-25 07:00:00 31.0 361 2010-10-25
+Chicago New York 2010-10-25 07:00:00 -1.0 897 2010-10-25
+Chicago New York 2010-10-25 07:00:00 43.0 1531 2010-10-25
+Chicago New York 2010-10-25 07:00:00 6.0 1610 2010-10-25
+Chicago New York 2010-10-25 07:00:00 -16.0 3198 2010-10-25
+Cleveland New York 2010-10-25 07:00:00 -4.0 2630 2010-10-25
+Cleveland New York 2010-10-25 07:00:00 81.0 2646 2010-10-25
+Cleveland New York 2010-10-25 07:00:00 42.0 3014 2010-10-25
+Washington New York 2010-10-25 07:00:00 9.0 7291 2010-10-25
+Baltimore New York 2010-10-26 07:00:00 -22.0 1064 2010-10-26
+Baltimore New York 2010-10-26 07:00:00 123.0 1142 2010-10-26
+Baltimore New York 2010-10-26 07:00:00 90.0 1599 2010-10-26
+Chicago New York 2010-10-26 07:00:00 12.0 361 2010-10-26
+Chicago New York 2010-10-26 07:00:00 0.0 897 2010-10-26
+Chicago New York 2010-10-26 07:00:00 29.0 1531 2010-10-26
+Chicago New York 2010-10-26 07:00:00 -17.0 1610 2010-10-26
+Chicago New York 2010-10-26 07:00:00 6.0 3198 2010-10-26
+Cleveland New York 2010-10-26 07:00:00 4.0 2630 2010-10-26
+Cleveland New York 2010-10-26 07:00:00 -27.0 2646 2010-10-26
+Cleveland New York 2010-10-26 07:00:00 -11.0 2662 2010-10-26
+Cleveland New York 2010-10-26 07:00:00 13.0 3014 2010-10-26
+Washington New York 2010-10-26 07:00:00 4.0 7291 2010-10-26
+Baltimore New York 2010-10-27 07:00:00 -18.0 1064 2010-10-27
+Baltimore New York 2010-10-27 07:00:00 49.0 1142 2010-10-27
+Baltimore New York 2010-10-27 07:00:00 92.0 1599 2010-10-27
+Chicago New York 2010-10-27 07:00:00 148.0 361 2010-10-27
+Chicago New York 2010-10-27 07:00:00 -11.0 897 2010-10-27
+Chicago New York 2010-10-27 07:00:00 70.0 1531 2010-10-27
+Chicago New York 2010-10-27 07:00:00 8.0 1610 2010-10-27
+Chicago New York 2010-10-27 07:00:00 21.0 3198 2010-10-27
+Cleveland New York 2010-10-27 07:00:00 16.0 2630 2010-10-27
+Cleveland New York 2010-10-27 07:00:00 27.0 3014 2010-10-27
+Washington New York 2010-10-27 07:00:00 26.0 7291 2010-10-27
+Baltimore New York 2010-10-28 07:00:00 -4.0 1064 2010-10-28
+Baltimore New York 2010-10-28 07:00:00 -14.0 1142 2010-10-28
+Baltimore New York 2010-10-28 07:00:00 -14.0 1599 2010-10-28
+Chicago New York 2010-10-28 07:00:00 2.0 361 2010-10-28
+Chicago New York 2010-10-28 07:00:00 2.0 897 2010-10-28
+Chicago New York 2010-10-28 07:00:00 -11.0 1531 2010-10-28
+Chicago New York 2010-10-28 07:00:00 3.0 1610 2010-10-28
+Chicago New York 2010-10-28 07:00:00 -18.0 3198 2010-10-28
+Cleveland New York 2010-10-28 07:00:00 3.0 2630 2010-10-28
+Cleveland New York 2010-10-28 07:00:00 -6.0 2646 2010-10-28
+Cleveland New York 2010-10-28 07:00:00 1.0 3014 2010-10-28
+Washington New York 2010-10-28 07:00:00 45.0 7291 2010-10-28
+Baltimore New York 2010-10-29 07:00:00 -24.0 1064 2010-10-29
+Baltimore New York 2010-10-29 07:00:00 21.0 1142 2010-10-29
+Baltimore New York 2010-10-29 07:00:00 -2.0 1599 2010-10-29
+Chicago New York 2010-10-29 07:00:00 -12.0 361 2010-10-29
+Chicago New York 2010-10-29 07:00:00 -11.0 897 2010-10-29
+Chicago New York 2010-10-29 07:00:00 15.0 1531 2010-10-29
+Chicago New York 2010-10-29 07:00:00 -18.0 1610 2010-10-29
+Chicago New York 2010-10-29 07:00:00 -4.0 3198 2010-10-29
+Cleveland New York 2010-10-29 07:00:00 -4.0 2630 2010-10-29
+Cleveland New York 2010-10-29 07:00:00 -19.0 2646 2010-10-29
+Cleveland New York 2010-10-29 07:00:00 -12.0 3014 2010-10-29
+Washington New York 2010-10-29 07:00:00 1.0 7291 2010-10-29
+Baltimore New York 2010-10-30 07:00:00 14.0 272 2010-10-30
+Baltimore New York 2010-10-30 07:00:00 -1.0 1805 2010-10-30
+Baltimore New York 2010-10-30 07:00:00 5.0 3171 2010-10-30
+Chicago New York 2010-10-30 07:00:00 -6.0 384 2010-10-30
+Chicago New York 2010-10-30 07:00:00 -10.0 426 2010-10-30
+Chicago New York 2010-10-30 07:00:00 -5.0 650 2010-10-30
+Chicago New York 2010-10-30 07:00:00 -5.0 3085 2010-10-30
+Cleveland New York 2010-10-30 07:00:00 -23.0 2018 2010-10-30
+Cleveland New York 2010-10-30 07:00:00 -12.0 2932 2010-10-30
+Washington New York 2010-10-30 07:00:00 -27.0 5904 2010-10-30
+Washington New York 2010-10-30 07:00:00 -16.0 5917 2010-10-30
+Baltimore New York 2010-10-31 07:00:00 -1.0 1599 2010-10-31
+Baltimore New York 2010-10-31 07:00:00 -14.0 2571 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -25.0 361 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -18.0 897 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -4.0 1531 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -22.0 1610 2010-10-31
+Chicago New York 2010-10-31 07:00:00 -15.0 3198 2010-10-31
+Washington New York 2010-10-31 07:00:00 -18.0 7282 2010-10-31
+PREHOOK: query: explain
+select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 25
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 25
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: flights_tiny_orc_partitioned_date
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: origin_city_name (type: string), dest_city_name (type: string), fl_time (type: timestamp), arr_delay (type: float), fl_num (type: int), fl_date (type: date)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col4 (type: int), _col5 (type: date)
+ sort order: ++
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: timestamp), _col3 (type: float)
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: timestamp), VALUE._col3 (type: float), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: date)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 25
+ Statistics: Num rows: 25 Data size: 5775 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+ Stage: Stage-2
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ Reduce Output Operator
+ key expressions: _col4 (type: int), _col5 (type: date)
+ sort order: ++
+ Statistics: Num rows: 25 Data size: 5775 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: timestamp), _col3 (type: float)
+ Reduce Operator Tree:
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: timestamp), VALUE._col3 (type: float), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: date)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 25 Data size: 5775 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 25
+ Statistics: Num rows: 25 Data size: 5775 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 25 Data size: 5775 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 25
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 25
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+POSTHOOK: query: select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 25
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+Baltimore New York 2010-10-23 07:00:00 18.0 272 2010-10-23
+Baltimore New York 2010-10-30 07:00:00 14.0 272 2010-10-30
+Chicago New York 2010-10-20 07:00:00 42.0 361 2010-10-20
+Chicago New York 2010-10-21 07:00:00 142.0 361 2010-10-21
+Chicago New York 2010-10-22 07:00:00 2.0 361 2010-10-22
+Chicago New York 2010-10-24 07:00:00 10.0 361 2010-10-24
+Chicago New York 2010-10-25 07:00:00 31.0 361 2010-10-25
+Chicago New York 2010-10-26 07:00:00 12.0 361 2010-10-26
+Chicago New York 2010-10-27 07:00:00 148.0 361 2010-10-27
+Chicago New York 2010-10-28 07:00:00 2.0 361 2010-10-28
+Chicago New York 2010-10-29 07:00:00 -12.0 361 2010-10-29
+Chicago New York 2010-10-31 07:00:00 -25.0 361 2010-10-31
+Chicago New York 2010-10-23 07:00:00 3.0 384 2010-10-23
+Chicago New York 2010-10-30 07:00:00 -6.0 384 2010-10-30
+Chicago New York 2010-10-23 07:00:00 32.0 426 2010-10-23
+Chicago New York 2010-10-30 07:00:00 -10.0 426 2010-10-30
+Chicago New York 2010-10-23 07:00:00 1.0 650 2010-10-23
+Chicago New York 2010-10-30 07:00:00 -5.0 650 2010-10-30
+Chicago New York 2010-10-20 07:00:00 24.0 897 2010-10-20
+Chicago New York 2010-10-21 07:00:00 77.0 897 2010-10-21
+Chicago New York 2010-10-22 07:00:00 24.0 897 2010-10-22
+Chicago New York 2010-10-24 07:00:00 113.0 897 2010-10-24
+Chicago New York 2010-10-25 07:00:00 -1.0 897 2010-10-25
+Chicago New York 2010-10-26 07:00:00 0.0 897 2010-10-26
+Chicago New York 2010-10-27 07:00:00 -11.0 897 2010-10-27
+PREHOOK: query: explain
+select fl_date, count(*) from flights_tiny_orc_partitioned_date group by fl_date
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select fl_date, count(*) from flights_tiny_orc_partitioned_date group by fl_date
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: flights_tiny_orc_partitioned_date
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: fl_date (type: date)
+ outputColumnNames: fl_date
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: count()
+ keys: fl_date (type: date)
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: date)
+ Statistics: Num rows: 137 Data size: 31776 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: bigint)
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: count(VALUE._col0)
+ keys: KEY._col0 (type: date)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 68 Data size: 15772 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: date), _col1 (type: bigint)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 68 Data size: 15772 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 68 Data size: 15772 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select fl_date, count(*) from flights_tiny_orc_partitioned_date group by fl_date
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+PREHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+POSTHOOK: query: select fl_date, count(*) from flights_tiny_orc_partitioned_date group by fl_date
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-20
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-21
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-22
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-23
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-24
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-25
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-26
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-27
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-28
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-29
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-30
+POSTHOOK: Input: default@flights_tiny_orc_partitioned_date@fl_date=2010-10-31
+#### A masked pattern was here ####
+2010-10-20 11
+2010-10-21 12
+2010-10-22 11
+2010-10-23 12
+2010-10-24 12
+2010-10-25 12
+2010-10-26 13
+2010-10-27 11
+2010-10-28 12
+2010-10-29 12
+2010-10-30 11
+2010-10-31 8
+PREHOOK: query: CREATE TABLE flights_tiny_orc_partitioned_timestamp (
+ origin_city_name STRING,
+ dest_city_name STRING,
+ fl_date DATE,
+ arr_delay FLOAT,
+ fl_num INT
+)
+PARTITIONED BY (fl_time TIMESTAMP)
+STORED AS ORC
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@flights_tiny_orc_partitioned_timestamp
+POSTHOOK: query: CREATE TABLE flights_tiny_orc_partitioned_timestamp (
+ origin_city_name STRING,
+ dest_city_name STRING,
+ fl_date DATE,
+ arr_delay FLOAT,
+ fl_num INT
+)
+PARTITIONED BY (fl_time TIMESTAMP)
+STORED AS ORC
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp
+PREHOOK: query: INSERT INTO TABLE flights_tiny_orc_partitioned_timestamp
+PARTITION (fl_time)
+SELECT origin_city_name, dest_city_name, fl_date, arr_delay, fl_num, fl_time
+FROM flights_tiny_orc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny_orc
+PREHOOK: Output: default@flights_tiny_orc_partitioned_timestamp
+POSTHOOK: query: INSERT INTO TABLE flights_tiny_orc_partitioned_timestamp
+PARTITION (fl_time)
+SELECT origin_city_name, dest_city_name, fl_date, arr_delay, fl_num, fl_time
+FROM flights_tiny_orc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny_orc
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00
+POSTHOOK: Output: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-20 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-20 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-20 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-20 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-20 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-21 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-21 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-21 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-21 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-21 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-22 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-22 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-22 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-22 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-22 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-23 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-23 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-23 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-23 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-23 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-24 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-24 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-24 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-24 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-24 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-25 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-25 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-25 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-25 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-25 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-26 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-26 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-26 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-26 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-26 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-27 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-27 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-27 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-27 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-27 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-28 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-28 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-28 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-28 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-28 07:00:00).origin_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:origin_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-29 07:00:00).arr_delay SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:arr_delay, type:float, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-29 07:00:00).dest_city_name SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:dest_city_name, type:string, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-29 07:00:00).fl_date SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_date, type:date, comment:null), ]
+POSTHOOK: Lineage: flights_tiny_orc_partitioned_timestamp PARTITION(fl_time=2010-10-29 07:00:00).fl_num SIMPLE [(flights_tiny_orc)flights_tiny_orc.FieldSchema(name:fl_num, type:int, comment:null), ]
[... 708 lines stripped ...]