[1/7] hive git commit: HIVE-20703: Put dynamic sort partition optimization under cost based decision (Vineet Garg, reviewed by Prasanth Jayachandran, Sergey Shelukhin)

[vgarg]

Repository: hive
Updated Branches:
  refs/heads/master 0d39a81c1 -> 5eebbdf7c


http://git-wip-us.apache.org/repos/asf/hive/blob/5eebbdf7/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out
----------------------------------------------------------------------
diff --git 
a/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out 
b/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out
index 5ae15fe..2ab11da 100644
--- a/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out
@@ -57,139 +57,139 @@ POSTHOOK: Input: default@flights_tiny_orc
 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     17.0    
1064
 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-22      2010-10-22 07:00:00     54.0    
1142
 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     18.0    
272
 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-25      2010-10-25 07:00:00     92.0    
1142
 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
+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
+Baltimore      New York        2010-10-28      2010-10-28 07:00:00     -4.0    
1064
+Baltimore      New York        2010-10-29      2010-10-29 07:00:00     -2.0    
1599
+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-30      2010-10-30 07:00:00     -1.0    
1805
+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     5.0     
3171
+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-20      2010-10-20 07:00:00     -2.0    
3198
+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     15.0    
1531
+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     42.0    
361
+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     142.0   
361
+Chicago        New York        2010-10-21      2010-10-21 07:00:00     51.0    
3198
+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     77.0    
897
+Chicago        New York        2010-10-22      2010-10-22 07:00:00     -11.0   
3198
+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     16.0    
1531
+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-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
+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-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
+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     10.0    
361
+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-25      2010-10-25 07:00:00     -16.0   
3198
+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     43.0    
1531
+Chicago        New York        2010-10-25      2010-10-25 07:00:00     6.0     
1610
+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     0.0     
897
+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     29.0    
1531
+Chicago        New York        2010-10-26      2010-10-26 07:00:00     6.0     
3198
 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     148.0   
361
+Chicago        New York        2010-10-27      2010-10-27 07:00:00     21.0    
3198
 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     -11.0   
1531
+Chicago        New York        2010-10-28      2010-10-28 07:00:00     -18.0   
3198
 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     -12.0   
361
 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-29      2010-10-29 07:00:00     15.0    
1531
 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-30      2010-10-30 07:00:00     -5.0    
650
+Chicago        New York        2010-10-30      2010-10-30 07:00:00     -6.0    
384
+Chicago        New York        2010-10-31      2010-10-31 07:00:00     -15.0   
3198
 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
+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     -4.0    
1531
+Cleveland      New York        2010-10-20      2010-10-20 07:00:00     -15.0   
3014
+Cleveland      New York        2010-10-20      2010-10-20 07:00:00     -8.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     3.0     
2630
+Cleveland      New York        2010-10-21      2010-10-21 07:00:00     72.0    
3014
+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-22      2010-10-22 07:00:00     1.0     
2630
+Cleveland      New York        2010-10-23      2010-10-23 07:00:00     -21.0   
2932
 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
+Cleveland      New York        2010-10-24      2010-10-24 07:00:00     5.0     
2254
+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     42.0    
3014
+Cleveland      New York        2010-10-25      2010-10-25 07:00:00     81.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     -27.0   
2646
+Cleveland      New York        2010-10-26      2010-10-26 07:00:00     13.0    
3014
+Cleveland      New York        2010-10-26      2010-10-26 07:00:00     4.0     
2630
+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-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-28      2010-10-28 07:00:00     3.0     
2630
+Cleveland      New York        2010-10-29      2010-10-29 07:00:00     -12.0   
3014
+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     -4.0    
2630
+Cleveland      New York        2010-10-30      2010-10-30 07:00:00     -12.0   
2932
+Cleveland      New York        2010-10-30      2010-10-30 07:00:00     -23.0   
2018
 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-23      2010-10-23 07:00:00     -18.0   
5917
+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     -25.0   
5832
 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-30      2010-10-30 07:00:00     -16.0   
5917
+Washington     New York        2010-10-30      2010-10-30 07:00:00     -27.0   
5904
 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
@@ -201,29 +201,29 @@ 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     24.0    
897
 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-21      2010-10-21 07:00:00     77.0    
897
 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-23      2010-10-23 07:00:00     1.0     
650
+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-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-25      2010-10-25 07:00:00     -1.0    
897
 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     0.0     
897
 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     -11.0   
897
 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
+Chicago        New York        2010-10-30      2010-10-30 07:00:00     -6.0    
384
+Chicago        New York        2010-10-31      2010-10-31 07:00:00     -25.0   
361
 PREHOOK: query: select fl_date, count(*) from flights_tiny_orc group by fl_date
 PREHOOK: type: QUERY
 PREHOOK: Input: default@flights_tiny_orc
@@ -232,16 +232,16 @@ 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-29     12
-2010-10-20     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 vectorization expression
@@ -390,29 +390,29 @@ 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     24.0    
897
 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-21      2010-10-21 07:00:00     77.0    
897
 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-23      2010-10-23 07:00:00     1.0     
650
+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-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-25      2010-10-25 07:00:00     -1.0    
897
 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     0.0     
897
 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     -11.0   
897
 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
+Chicago        New York        2010-10-30      2010-10-30 07:00:00     -6.0    
384
+Chicago        New York        2010-10-31      2010-10-31 07:00:00     -25.0   
361
 PREHOOK: query: explain vectorization expression
 select fl_date, count(*) from flights_tiny_orc group by fl_date
 PREHOOK: type: QUERY
@@ -537,16 +537,16 @@ 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-29     12
-2010-10-20     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 (
@@ -690,142 +690,142 @@ 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-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-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-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-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-23 07:00:00     18.0    272     
2010-10-23
+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
+Baltimore      New York        2010-10-21 07:00:00     105.0   1142    
2010-10-21
+Baltimore      New York        2010-10-21 07:00:00     17.0    1064    
2010-10-21
+Baltimore      New York        2010-10-21 07:00:00     28.0    1599    
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     18.0    1599    
2010-10-22
+Baltimore      New York        2010-10-22 07:00:00     54.0    1142    
2010-10-22
 Baltimore      New York        2010-10-23 07:00:00     -10.0   1805    
2010-10-23
+Baltimore      New York        2010-10-23 07:00:00     18.0    272     
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-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-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
+Baltimore      New York        2010-10-25 07:00:00     -25.0   1064    
2010-10-25
+Baltimore      New York        2010-10-25 07:00:00     106.0   1599    
2010-10-25
+Baltimore      New York        2010-10-25 07:00:00     92.0    1142    
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
 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
+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
+Baltimore      New York        2010-10-28 07:00:00     -4.0    1064    
2010-10-28
+Baltimore      New York        2010-10-29 07:00:00     -2.0    1599    
2010-10-29
+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-30 07:00:00     -1.0    1805    
2010-10-30
+Baltimore      New York        2010-10-30 07:00:00     14.0    272     
2010-10-30
+Baltimore      New York        2010-10-30 07:00:00     5.0     3171    
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-20 07:00:00     -2.0    3198    
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     15.0    1531    
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     42.0    361     
2010-10-20
+Chicago        New York        2010-10-21 07:00:00     -5.0    1610    
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     51.0    3198    
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     77.0    897     
2010-10-21
+Chicago        New York        2010-10-22 07:00:00     -11.0   3198    
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     16.0    1531    
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-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
+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-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
+Chicago        New York        2010-10-24 07:00:00     -5.0    1531    
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-25 07:00:00     -1.0    897     
2010-10-25
+Chicago        New York        2010-10-25 07:00:00     -16.0   3198    
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     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-26 07:00:00     -17.0   1610    
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     12.0    361     
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     6.0     3198    
2010-10-26
 Chicago        New York        2010-10-27 07:00:00     -11.0   897     
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     21.0    3198    
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     -11.0   1531    
2010-10-28
+Chicago        New York        2010-10-28 07:00:00     -18.0   3198    
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-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-29 07:00:00     -11.0   897     
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     -18.0   1610    
2010-10-29
+Chicago        New York        2010-10-29 07:00:00     -4.0    3198    
2010-10-29
+Chicago        New York        2010-10-29 07:00:00     15.0    1531    
2010-10-29
 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-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
+Chicago        New York        2010-10-30 07:00:00     -5.0    650     
2010-10-30
+Chicago        New York        2010-10-30 07:00:00     -6.0    384     
2010-10-30
+Chicago        New York        2010-10-31 07:00:00     -15.0   3198    
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     -22.0   1610    
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     -4.0    1531    
2010-10-31
 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-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-20 07:00:00     -8.0    2630    
2010-10-20
+Cleveland      New York        2010-10-21 07:00:00     29.0    2646    
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     72.0    3014    
2010-10-21
 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-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
+Cleveland      New York        2010-10-22 07:00:00     1.0     2630    
2010-10-22
+Cleveland      New York        2010-10-23 07:00:00     -21.0   2932    
2010-10-23
+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
+Cleveland      New York        2010-10-24 07:00:00     5.0     2254    
2010-10-24
+Cleveland      New York        2010-10-25 07:00:00     -4.0    2630    
2010-10-25
+Cleveland      New York        2010-10-25 07:00:00     42.0    3014    
2010-10-25
+Cleveland      New York        2010-10-25 07:00:00     81.0    2646    
2010-10-25
+Cleveland      New York        2010-10-26 07:00:00     -11.0   2662    
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     13.0    3014    
2010-10-26
+Cleveland      New York        2010-10-26 07:00:00     4.0     2630    
2010-10-26
+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
+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
+Cleveland      New York        2010-10-28 07:00:00     3.0     2630    
2010-10-28
+Cleveland      New York        2010-10-29 07:00:00     -12.0   3014    
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     -4.0    2630    
2010-10-29
+Cleveland      New York        2010-10-30 07:00:00     -12.0   2932    
2010-10-30
+Cleveland      New York        2010-10-30 07:00:00     -23.0   2018    
2010-10-30
+Washington     New York        2010-10-20 07:00:00     -2.0    7291    
2010-10-20
+Washington     New York        2010-10-21 07:00:00     22.0    7291    
2010-10-21
+Washington     New York        2010-10-23 07:00:00     -16.0   7274    
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     -21.0   5904    
2010-10-23
+Washington     New York        2010-10-23 07:00:00     -25.0   5832    
2010-10-23
+Washington     New York        2010-10-24 07:00:00     -26.0   7282    
2010-10-24
+Washington     New York        2010-10-25 07:00:00     9.0     7291    
2010-10-25
+Washington     New York        2010-10-26 07:00:00     4.0     7291    
2010-10-26
+Washington     New York        2010-10-27 07:00:00     26.0    7291    
2010-10-27
+Washington     New York        2010-10-28 07:00:00     45.0    7291    
2010-10-28
+Washington     New York        2010-10-29 07:00:00     1.0     7291    
2010-10-29
+Washington     New York        2010-10-30 07:00:00     -16.0   5917    
2010-10-30
+Washington     New York        2010-10-30 07:00:00     -27.0   5904    
2010-10-30
 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
@@ -861,29 +861,29 @@ 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     24.0    897     
2010-10-20
 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-21 07:00:00     77.0    897     
2010-10-21
 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-23 07:00:00     1.0     650     
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-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-25 07:00:00     -1.0    897     
2010-10-25
 Chicago        New York        2010-10-25 07:00:00     31.0    361     
2010-10-25
+Chicago        New York        2010-10-26 07:00:00     0.0     897     
2010-10-26
 Chicago        New York        2010-10-26 07:00:00     12.0    361     
2010-10-26
+Chicago        New York        2010-10-27 07:00:00     -11.0   897     
2010-10-27
 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
+Chicago        New York        2010-10-30 07:00:00     -6.0    384     
2010-10-30
+Chicago        New York        2010-10-31 07:00:00     -25.0   361     
2010-10-31
 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
@@ -916,16 +916,16 @@ 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-29     12
-2010-10-20     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 vectorization expression
@@ -979,7 +979,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: flights_tiny_orc_partitioned_date
-                  Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                  Statistics: Num rows: 137 Data size: 94360 Basic stats: 
COMPLETE Column stats: PARTIAL
                   TableScan Vectorization:
                       native: true
                   Select Operator
@@ -989,13 +989,13 @@ STAGE PLANS:
                         className: VectorSelectOperator
                         native: true
                         projectedOutputColumnNums: [0, 1, 2, 3, 4, 5]
-                    Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                    Statistics: Num rows: 137 Data size: 62584 Basic stats: 
COMPLETE Column stats: PARTIAL
                     File Output Operator
                       compressed: false
                       File Sink Vectorization:
                           className: VectorFileSinkOperator
                           native: false
-                      Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                      Statistics: Num rows: 137 Data size: 62584 Basic stats: 
COMPLETE Column stats: PARTIAL
                       table:
                           input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1050,142 +1050,142 @@ 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-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-21 07:00:00     17.0    1064    
2010-10-21
+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
 Baltimore      New York        2010-10-21 07:00:00     105.0   1142    
2010-10-21
+Baltimore      New York        2010-10-21 07:00:00     17.0    1064    
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-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-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-23 07:00:00     18.0    272     
2010-10-23
+Baltimore      New York        2010-10-22 07:00:00     -12.0   1064    
2010-10-22
+Baltimore      New York        2010-10-22 07:00:00     18.0    1599    
2010-10-22
+Baltimore      New York        2010-10-22 07:00:00     54.0    1142    
2010-10-22
 Baltimore      New York        2010-10-23 07:00:00     -10.0   1805    
2010-10-23
+Baltimore      New York        2010-10-23 07:00:00     18.0    272     
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-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-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
+Baltimore      New York        2010-10-25 07:00:00     -25.0   1064    
2010-10-25
+Baltimore      New York        2010-10-25 07:00:00     106.0   1599    
2010-10-25
+Baltimore      New York        2010-10-25 07:00:00     92.0    1142    
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
 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
+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
+Baltimore      New York        2010-10-28 07:00:00     -4.0    1064    
2010-10-28
+Baltimore      New York        2010-10-29 07:00:00     -2.0    1599    
2010-10-29
+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-30 07:00:00     -1.0    1805    
2010-10-30
+Baltimore      New York        2010-10-30 07:00:00     14.0    272     
2010-10-30
+Baltimore      New York        2010-10-30 07:00:00     5.0     3171    
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-20 07:00:00     -2.0    3198    
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     15.0    1531    
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     42.0    361     
2010-10-20
+Chicago        New York        2010-10-21 07:00:00     -5.0    1610    
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     51.0    3198    
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     77.0    897     
2010-10-21
+Chicago        New York        2010-10-22 07:00:00     -11.0   3198    
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     16.0    1531    
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-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
+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-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
+Chicago        New York        2010-10-24 07:00:00     -5.0    1531    
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-25 07:00:00     -1.0    897     
2010-10-25
+Chicago        New York        2010-10-25 07:00:00     -16.0   3198    
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     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-26 07:00:00     -17.0   1610    
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     12.0    361     
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     6.0     3198    
2010-10-26
 Chicago        New York        2010-10-27 07:00:00     -11.0   897     
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     21.0    3198    
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     -11.0   1531    
2010-10-28
+Chicago        New York        2010-10-28 07:00:00     -18.0   3198    
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-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-29 07:00:00     -11.0   897     
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     -18.0   1610    
2010-10-29
+Chicago        New York        2010-10-29 07:00:00     -4.0    3198    
2010-10-29
+Chicago        New York        2010-10-29 07:00:00     15.0    1531    
2010-10-29
 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-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
+Chicago        New York        2010-10-30 07:00:00     -5.0    650     
2010-10-30
+Chicago        New York        2010-10-30 07:00:00     -6.0    384     
2010-10-30
+Chicago        New York        2010-10-31 07:00:00     -15.0   3198    
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     -22.0   1610    
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     -4.0    1531    
2010-10-31
 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-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-20 07:00:00     -8.0    2630    
2010-10-20
+Cleveland      New York        2010-10-21 07:00:00     29.0    2646    
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     72.0    3014    
2010-10-21
 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-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
+Cleveland      New York        2010-10-22 07:00:00     1.0     2630    
2010-10-22
+Cleveland      New York        2010-10-23 07:00:00     -21.0   2932    
2010-10-23
+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
+Cleveland      New York        2010-10-24 07:00:00     5.0     2254    
2010-10-24
+Cleveland      New York        2010-10-25 07:00:00     -4.0    2630    
2010-10-25
+Cleveland      New York        2010-10-25 07:00:00     42.0    3014    
2010-10-25
+Cleveland      New York        2010-10-25 07:00:00     81.0    2646    
2010-10-25
+Cleveland      New York        2010-10-26 07:00:00     -11.0   2662    
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     13.0    3014    
2010-10-26
+Cleveland      New York        2010-10-26 07:00:00     4.0     2630    
2010-10-26
+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
+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
+Cleveland      New York        2010-10-28 07:00:00     3.0     2630    
2010-10-28
+Cleveland      New York        2010-10-29 07:00:00     -12.0   3014    
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     -4.0    2630    
2010-10-29
+Cleveland      New York        2010-10-30 07:00:00     -12.0   2932    
2010-10-30
+Cleveland      New York        2010-10-30 07:00:00     -23.0   2018    
2010-10-30
+Washington     New York        2010-10-20 07:00:00     -2.0    7291    
2010-10-20
+Washington     New York        2010-10-21 07:00:00     22.0    7291    
2010-10-21
+Washington     New York        2010-10-23 07:00:00     -16.0   7274    
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     -21.0   5904    
2010-10-23
+Washington     New York        2010-10-23 07:00:00     -25.0   5832    
2010-10-23
+Washington     New York        2010-10-24 07:00:00     -26.0   7282    
2010-10-24
+Washington     New York        2010-10-25 07:00:00     9.0     7291    
2010-10-25
+Washington     New York        2010-10-26 07:00:00     4.0     7291    
2010-10-26
+Washington     New York        2010-10-27 07:00:00     26.0    7291    
2010-10-27
+Washington     New York        2010-10-28 07:00:00     45.0    7291    
2010-10-28
+Washington     New York        2010-10-29 07:00:00     1.0     7291    
2010-10-29
+Washington     New York        2010-10-30 07:00:00     -16.0   5917    
2010-10-30
+Washington     New York        2010-10-30 07:00:00     -27.0   5904    
2010-10-30
 Washington     New York        2010-10-31 07:00:00     -18.0   7282    
2010-10-31
 PREHOOK: query: explain vectorization expression
 select * from flights_tiny_orc_partitioned_date sort by fl_num, fl_date limit 
25
@@ -1242,7 +1242,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: flights_tiny_orc_partitioned_date
-                  Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                  Statistics: Num rows: 137 Data size: 94360 Basic stats: 
COMPLETE Column stats: PARTIAL
                   TableScan Vectorization:
                       native: true
                   Select Operator
@@ -1252,7 +1252,7 @@ STAGE PLANS:
                         className: VectorSelectOperator
                         native: true
                         projectedOutputColumnNums: [0, 1, 2, 3, 4, 5]
-                    Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                    Statistics: Num rows: 137 Data size: 94360 Basic stats: 
COMPLETE Column stats: PARTIAL
                     Reduce Output Operator
                       key expressions: _col4 (type: int), _col5 (type: date)
                       sort order: ++
@@ -1260,7 +1260,7 @@ STAGE PLANS:
                           className: VectorReduceSinkObjectHashOperator
                           native: true
                           nativeConditionsMet: 
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine 
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, 
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
-                      Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                      Statistics: Num rows: 137 Data size: 94360 Basic stats: 
COMPLETE Column stats: PARTIAL
                       TopN Hash Memory Usage: 0.1
                       value expressions: _col0 (type: string), _col1 (type: 
string), _col2 (type: timestamp), _col3 (type: float)
             Execution mode: vectorized, llap
@@ -1290,13 +1290,13 @@ STAGE PLANS:
                     className: VectorSelectOperator
                     native: true
                     projectedOutputColumnNums: [2, 3, 4, 5, 0, 1]
-                Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                Statistics: Num rows: 137 Data size: 62584 Basic stats: 
COMPLETE Column stats: PARTIAL
                 Limit
                   Number of rows: 25
                   Limit Vectorization:
                       className: VectorLimitOperator
                       native: true
-                  Statistics: Num rows: 25 Data size: 7225 Basic stats: 
COMPLETE Column stats: COMPLETE
+                  Statistics: Num rows: 25 Data size: 11800 Basic stats: 
COMPLETE Column stats: PARTIAL
                   Reduce Output Operator
                     key expressions: _col4 (type: int), _col5 (type: date)
                     sort order: ++
@@ -1304,7 +1304,7 @@ STAGE PLANS:
                         className: VectorReduceSinkObjectHashOperator
                         native: true
                         nativeConditionsMet: 
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine 
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, 
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
-                    Statistics: Num rows: 25 Data size: 7225 Basic stats: 
COMPLETE Column stats: COMPLETE
+                    Statistics: Num rows: 25 Data size: 11800 Basic stats: 
COMPLETE Column stats: PARTIAL
                     TopN Hash Memory Usage: 0.1
                     value expressions: _col0 (type: string), _col1 (type: 
string), _col2 (type: timestamp), _col3 (type: float)
         Reducer 3 
@@ -1323,19 +1323,19 @@ STAGE PLANS:
                     className: VectorSelectOperator
                     native: true
                     projectedOutputColumnNums: [2, 3, 4, 5, 0, 1]
-                Statistics: Num rows: 25 Data size: 7225 Basic stats: COMPLETE 
Column stats: COMPLETE
+                Statistics: Num rows: 25 Data size: 11800 Basic stats: 
COMPLETE Column stats: PARTIAL
                 Limit
                   Number of rows: 25
                   Limit Vectorization:
                       className: VectorLimitOperator
                       native: true
-                  Statistics: Num rows: 25 Data size: 7225 Basic stats: 
COMPLETE Column stats: COMPLETE
+                  Statistics: Num rows: 25 Data size: 11800 Basic stats: 
COMPLETE Column stats: PARTIAL
                   File Output Operator
                     compressed: false
                     File Sink Vectorization:
                         className: VectorFileSinkOperator
                         native: false
-                    Statistics: Num rows: 25 Data size: 7225 Basic stats: 
COMPLETE Column stats: COMPLETE
+                    Statistics: Num rows: 25 Data size: 11800 Basic stats: 
COMPLETE Column stats: PARTIAL
                     table:
                         input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1381,29 +1381,29 @@ 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     24.0    897     
2010-10-20
 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-21 07:00:00     77.0    897     
2010-10-21
 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-23 07:00:00     1.0     650     
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-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-25 07:00:00     -1.0    897     
2010-10-25
 Chicago        New York        2010-10-25 07:00:00     31.0    361     
2010-10-25
+Chicago        New York        2010-10-26 07:00:00     0.0     897     
2010-10-26
 Chicago        New York        2010-10-26 07:00:00     12.0    361     
2010-10-26
+Chicago        New York        2010-10-27 07:00:00     -11.0   897     
2010-10-27
 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
+Chicago        New York        2010-10-30 07:00:00     -6.0    384     
2010-10-30
+Chicago        New York        2010-10-31 07:00:00     -25.0   361     
2010-10-31
 PREHOOK: query: explain vectorization expression
 select fl_date, count(*) from flights_tiny_orc_partitioned_date group by 
fl_date
 PREHOOK: type: QUERY
@@ -1576,16 +1576,16 @@ 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-29     12
-2010-10-20     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 (
@@ -1729,142 +1729,142 @@ POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-
 POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00
 POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00
 #### A masked pattern was here ####
+Baltimore      New York        2010-10-20      -30.0   1064    2010-10-20 
07:00:00
+Baltimore      New York        2010-10-20      23.0    1142    2010-10-20 
07:00:00
+Baltimore      New York        2010-10-20      6.0     1599    2010-10-20 
07:00:00
+Baltimore      New York        2010-10-21      105.0   1142    2010-10-21 
07:00:00
+Baltimore      New York        2010-10-21      17.0    1064    2010-10-21 
07:00:00
+Baltimore      New York        2010-10-21      28.0    1599    2010-10-21 
07:00:00
+Baltimore      New York        2010-10-22      -12.0   1064    2010-10-22 
07:00:00
+Baltimore      New York        2010-10-22      18.0    1599    2010-10-22 
07:00:00
+Baltimore      New York        2010-10-22      54.0    1142    2010-10-22 
07:00:00
+Baltimore      New York        2010-10-23      -10.0   1805    2010-10-23 
07:00:00
+Baltimore      New York        2010-10-23      18.0    272     2010-10-23 
07:00:00
+Baltimore      New York        2010-10-23      6.0     3171    2010-10-23 
07:00:00
+Baltimore      New York        2010-10-24      12.0    1599    2010-10-24 
07:00:00
+Baltimore      New York        2010-10-24      20.0    2571    2010-10-24 
07:00:00
+Baltimore      New York        2010-10-25      -25.0   1064    2010-10-25 
07:00:00
+Baltimore      New York        2010-10-25      106.0   1599    2010-10-25 
07:00:00
+Baltimore      New York        2010-10-25      92.0    1142    2010-10-25 
07:00:00
 Baltimore      New York        2010-10-26      -22.0   1064    2010-10-26 
07:00:00
 Baltimore      New York        2010-10-26      123.0   1142    2010-10-26 
07:00:00
 Baltimore      New York        2010-10-26      90.0    1599    2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      12.0    361     2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      0.0     897     2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      29.0    1531    2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      -17.0   1610    2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      6.0     3198    2010-10-26 
07:00:00
-Cleveland      New York        2010-10-26      4.0     2630    2010-10-26 
07:00:00
-Cleveland      New York        2010-10-26      -27.0   2646    2010-10-26 
07:00:00
-Cleveland      New York        2010-10-26      -11.0   2662    2010-10-26 
07:00:00
-Cleveland      New York        2010-10-26      13.0    3014    2010-10-26 
07:00:00
-Washington     New York        2010-10-26      4.0     7291    2010-10-26 
07:00:00
-Baltimore      New York        2010-10-21      17.0    1064    2010-10-21 
07:00:00
-Baltimore      New York        2010-10-21      105.0   1142    2010-10-21 
07:00:00
-Baltimore      New York        2010-10-21      28.0    1599    2010-10-21 
07:00:00
-Chicago        New York        2010-10-21      142.0   361     2010-10-21 
07:00:00
-Chicago        New York        2010-10-21      77.0    897     2010-10-21 
07:00:00
-Chicago        New York        2010-10-21      53.0    1531    2010-10-21 
07:00:00
+Baltimore      New York        2010-10-27      -18.0   1064    2010-10-27 
07:00:00
+Baltimore      New York        2010-10-27      49.0    1142    2010-10-27 
07:00:00
+Baltimore      New York        2010-10-27      92.0    1599    2010-10-27 
07:00:00
+Baltimore      New York        2010-10-28      -14.0   1142    2010-10-28 
07:00:00
+Baltimore      New York        2010-10-28      -14.0   1599    2010-10-28 
07:00:00
+Baltimore      New York        2010-10-28      -4.0    1064    2010-10-28 
07:00:00
+Baltimore      New York        2010-10-29      -2.0    1599    2010-10-29 
07:00:00
+Baltimore      New York        2010-10-29      -24.0   1064    2010-10-29 
07:00:00
+Baltimore      New York        2010-10-29      21.0    1142    2010-10-29 
07:00:00
+Baltimore      New York        2010-10-30      -1.0    1805    2010-10-30 
07:00:00
+Baltimore      New York        2010-10-30      14.0    272     2010-10-30 
07:00:00
+Baltimore      New York        2010-10-30      5.0     3171    2010-10-30 
07:00:00
+Baltimore      New York        2010-10-31      -1.0    1599    2010-10-31 
07:00:00
+Baltimore      New York        2010-10-31      -14.0   2571    2010-10-31 
07:00:00
+Chicago        New York        2010-10-20      -2.0    3198    2010-10-20 
07:00:00
+Chicago        New York        2010-10-20      -6.0    1610    2010-10-20 
07:00:00
+Chicago        New York        2010-10-20      15.0    1531    2010-10-20 
07:00:00
+Chicago        New York        2010-10-20      24.0    897     2010-10-20 
07:00:00
+Chicago        New York        2010-10-20      42.0    361     2010-10-20 
07:00:00
 Chicago        New York        2010-10-21      -5.0    1610    2010-10-21 
07:00:00
+Chicago        New York        2010-10-21      142.0   361     2010-10-21 
07:00:00
 Chicago        New York        2010-10-21      51.0    3198    2010-10-21 
07:00:00
-Cleveland      New York        2010-10-21      3.0     2630    2010-10-21 
07:00:00
-Cleveland      New York        2010-10-21      29.0    2646    2010-10-21 
07:00:00
-Cleveland      New York        2010-10-21      72.0    3014    2010-10-21 
07:00:00
-Washington     New York        2010-10-21      22.0    7291    2010-10-21 
07:00:00
-Baltimore      New York        2010-10-25      -25.0   1064    2010-10-25 
07:00:00
-Baltimore      New York        2010-10-25      92.0    1142    2010-10-25 
07:00:00
-Baltimore      New York        2010-10-25      106.0   1599    2010-10-25 
07:00:00
-Chicago        New York        2010-10-25      31.0    361     2010-10-25 
07:00:00
+Chicago        New York        2010-10-21      53.0    1531    2010-10-21 
07:00:00
+Chicago        New York        2010-10-21      77.0    897     2010-10-21 
07:00:00
+Chicago        New York        2010-10-22      -11.0   3198    2010-10-22 
07:00:00
+Chicago        New York        2010-10-22      -6.0    1610    2010-10-22 
07:00:00
+Chicago        New York        2010-10-22      16.0    1531    2010-10-22 
07:00:00
+Chicago        New York        2010-10-22      2.0     361     2010-10-22 
07:00:00
+Chicago        New York        2010-10-22      24.0    897     2010-10-22 
07:00:00
+Chicago        New York        2010-10-23      1.0     650     2010-10-23 
07:00:00
+Chicago        New York        2010-10-23      11.0    3085    2010-10-23 
07:00:00
+Chicago        New York        2010-10-23      3.0     384     2010-10-23 
07:00:00
+Chicago        New York        2010-10-23      32.0    426     2010-10-23 
07:00:00
+Chicago        New York        2010-10-24      -17.0   1610    2010-10-24 
07:00:00
+Chicago        New York        2010-10-24      -3.0    3198    2010-10-24 
07:00:00
+Chicago        New York        2010-10-24      -5.0    1531    2010-10-24 
07:00:00
+Chicago        New York        2010-10-24      10.0    361     2010-10-24 
07:00:00
+Chicago        New York        2010-10-24      113.0   897     2010-10-24 
07:00:00
 Chicago        New York        2010-10-25      -1.0    897     2010-10-25 
07:00:00
+Chicago        New York        2010-10-25      -16.0   3198    2010-10-25 
07:00:00
+Chicago        New York        2010-10-25      31.0    361     2010-10-25 
07:00:00
 Chicago        New York        2010-10-25      43.0    1531    2010-10-25 
07:00:00
 Chicago        New York        2010-10-25      6.0     1610    2010-10-25 
07:00:00
-Chicago        New York        2010-10-25      -16.0   3198    2010-10-25 
07:00:00
-Cleveland      New York        2010-10-25      -4.0    2630    2010-10-25 
07:00:00
-Cleveland      New York        2010-10-25      81.0    2646    2010-10-25 
07:00:00
-Cleveland      New York        2010-10-25      42.0    3014    2010-10-25 
07:00:00
-Washington     New York        2010-10-25      9.0     7291    2010-10-25 
07:00:00
-Baltimore      New York        2010-10-24      12.0    1599    2010-10-24 
07:00:00
-Baltimore      New York        2010-10-24      20.0    2571    2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      10.0    361     2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      113.0   897     2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      -5.0    1531    2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      -17.0   1610    2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      -3.0    3198    2010-10-24 
07:00:00
-Cleveland      New York        2010-10-24      5.0     2254    2010-10-24 
07:00:00
-Cleveland      New York        2010-10-24      -11.0   2630    2010-10-24 
07:00:00
-Cleveland      New York        2010-10-24      -20.0   2646    2010-10-24 
07:00:00
-Cleveland      New York        2010-10-24      -9.0    3014    2010-10-24 
07:00:00
-Washington     New York        2010-10-24      -26.0   7282    2010-10-24 
07:00:00
-Baltimore      New York        2010-10-23      18.0    272     2010-10-23 
07:00:00
-Baltimore      New York        2010-10-23      -10.0   1805    2010-10-23 
07:00:00
-Baltimore      New York        2010-10-23      6.0     3171    2010-10-23 
07:00:00
-Chicago        New York        2010-10-23      3.0     384     2010-10-23 
07:00:00
-Chicago        New York        2010-10-23      32.0    426     2010-10-23 
07:00:00
-Chicago        New York        2010-10-23      1.0     650     2010-10-23 
07:00:00
-Chicago        New York        2010-10-23      11.0    3085    2010-10-23 
07:00:00
-Cleveland      New York        2010-10-23      -21.0   2932    2010-10-23 
07:00:00
-Washington     New York        2010-10-23      -25.0   5832    2010-10-23 
07:00:00
-Washington     New York        2010-10-23      -21.0   5904    2010-10-23 
07:00:00
-Washington     New York        2010-10-23      -18.0   5917    2010-10-23 
07:00:00
-Washington     New York        2010-10-23      -16.0   7274    2010-10-23 
07:00:00
-Baltimore      New York        2010-10-29      -24.0   1064    2010-10-29 
07:00:00
-Baltimore      New York        2010-10-29      21.0    1142    2010-10-29 
07:00:00
-Baltimore      New York        2010-10-29      -2.0    1599    2010-10-29 
07:00:00
-Chicago        New York        2010-10-29      -12.0   361     2010-10-29 
07:00:00
-Chicago        New York        2010-10-29      -11.0   897     2010-10-29 
07:00:00
-Chicago        New York        2010-10-29      15.0    1531    2010-10-29 
07:00:00
-Chicago        New York        2010-10-29      -18.0   1610    2010-10-29 
07:00:00
-Chicago        New York        2010-10-29      -4.0    3198    2010-10-29 
07:00:00
-Cleveland      New York        2010-10-29      -4.0    2630    2010-10-29 
07:00:00
-Cleveland      New York        2010-10-29      -19.0   2646    2010-10-29 
07:00:00
-Cleveland      New York        2010-10-29      -12.0   3014    2010-10-29 
07:00:00
-Washington     New York        2010-10-29      1.0     7291    2010-10-29 
07:00:00
-Baltimore      New York        2010-10-27      -18.0   1064    2010-10-27 
07:00:00
-Baltimore      New York        2010-10-27      49.0    1142    2010-10-27 
07:00:00
-Baltimore      New York        2010-10-27      92.0    1599    2010-10-27 
07:00:00
-Chicago        New York        2010-10-27      148.0   361     2010-10-27 
07:00:00
+Chicago        New York        2010-10-26      -17.0   1610    2010-10-26 
07:00:00
+Chicago        New York        2010-10-26      0.0     897     2010-10-26 
07:00:00
+Chicago        New York        2010-10-26      12.0    361     2010-10-26 
07:00:00
+Chicago        New York        2010-10-26      29.0    1531    2010-10-26 
07:00:00
+Chicago        New York        2010-10-26      6.0     3198    2010-10-26 
07:00:00
 Chicago        New York        2010-10-27      -11.0   897     2010-10-27 
07:00:00
+Chicago        New York        2010-10-27      148.0   361     2010-10-27 
07:00:00
+Chicago        New York        2010-10-27      21.0    3198    2010-10-27 
07:00:00
 Chicago        New York        2010-10-27      70.0    1531    2010-10-27 
07:00:00
 Chicago        New York        2010-10-27      8.0     1610    2010-10-27 
07:00:00
-Chicago        New York        2010-10-27      21.0    3198    2010-10-27 
07:00:00
-Cleveland      New York        2010-10-27      16.0    2630    2010-10-27 
07:00:00
-Cleveland      New York        2010-10-27      27.0    3014    2010-10-27 
07:00:00
-Washington     New York        2010-10-27      26.0    7291    2010-10-27 
07:00:00
-Baltimore      New York        2010-10-28      -4.0    1064    2010-10-28 
07:00:00
-Baltimore      New York        2010-10-28      -14.0   1142    2010-10-28 
07:00:00
-Baltimore      New York        2010-10-28      -14.0   1599    2010-10-28 
07:00:00
+Chicago        New York        2010-10-28      -11.0   1531    2010-10-28 
07:00:00
+Chicago        New York        2010-10-28      -18.0   3198    2010-10-28 
07:00:00
 Chicago        New York        2010-10-28      2.0     361     2010-10-28 
07:00:00
 Chicago        New York        2010-10-28      2.0     897     2010-10-28 
07:00:00
-Chicago        New York        2010-10-28      -11.0   1531    2010-10-28 
07:00:00
 Chicago        New York        2010-10-28      3.0     1610    2010-10-28 
07:00:00
-Chicago        New York        2010-10-28      -18.0   3198    2010-10-28 
07:00:00
-Cleveland      New York        2010-10-28      3.0     2630    2010-10-28 
07:00:00
-Cleveland      New York        2010-10-28      -6.0    2646    2010-10-28 
07:00:00
-Cleveland      New York        2010-10-28      1.0     3014    2010-10-28 
07:00:00
-Washington     New York        2010-10-28      45.0    7291    2010-10-28 
07:00:00
-Baltimore      New York        2010-10-30      14.0    272     2010-10-30 
07:00:00
-Baltimore      New York        2010-10-30      -1.0    1805    2010-10-30 
07:00:00
-Baltimore      New York        2010-10-30      5.0     3171    2010-10-30 
07:00:00
-Chicago        New York        2010-10-30      -6.0    384     2010-10-30 
07:00:00
+Chicago        New York        2010-10-29      -11.0   897     2010-10-29 
07:00:00
+Chicago        New York        2010-10-29      -12.0   361     2010-10-29 
07:00:00
+Chicago        New York        2010-10-29      -18.0   1610    2010-10-29 
07:00:00
+Chicago        New York        2010-10-29      -4.0    3198    2010-10-29 
07:00:00
+Chicago        New York        2010-10-29      15.0    1531    2010-10-29 
07:00:00
 Chicago        New York        2010-10-30      -10.0   426     2010-10-30 
07:00:00
-Chicago        New York        2010-10-30      -5.0    650     2010-10-30 
07:00:00
 Chicago        New York        2010-10-30      -5.0    3085    2010-10-30 
07:00:00
-Cleveland      New York        2010-10-30      -23.0   2018    2010-10-30 
07:00:00
-Cleveland      New York        2010-10-30      -12.0   2932    2010-10-30 
07:00:00
-Washington     New York        2010-10-30      -27.0   5904    2010-10-30 
07:00:00
-Washington     New York        2010-10-30      -16.0   5917    2010-10-30 
07:00:00
-Baltimore      New York        2010-10-20      -30.0   1064    2010-10-20 
07:00:00
-Baltimore      New York        2010-10-20      23.0    1142    2010-10-20 
07:00:00
-Baltimore      New York        2010-10-20      6.0     1599    2010-10-20 
07:00:00
-Chicago        New York        2010-10-20      42.0    361     2010-10-20 
07:00:00
-Chicago        New York        2010-10-20      24.0    897     2010-10-20 
07:00:00
-Chicago        New York        2010-10-20      15.0    1531    2010-10-20 
07:00:00
-Chicago        New York        2010-10-20      -6.0    1610    2010-10-20 
07:00:00
-Chicago        New York        2010-10-20      -2.0    3198    2010-10-20 
07:00:00
-Cleveland      New York        2010-10-20      -8.0    2630    2010-10-20 
07:00:00
+Chicago        New York        2010-10-30      -5.0    650     2010-10-30 
07:00:00
+Chicago        New York        2010-10-30      -6.0    384     2010-10-30 
07:00:00
+Chicago        New York        2010-10-31      -15.0   3198    2010-10-31 
07:00:00
+Chicago        New York        2010-10-31      -18.0   897     2010-10-31 
07:00:00
+Chicago        New York        2010-10-31      -22.0   1610    2010-10-31 
07:00:00
+Chicago        New York        2010-10-31      -25.0   361     2010-10-31 
07:00:00
+Chicago        New York        2010-10-31      -4.0    1531    2010-10-31 
07:00:00
 Cleveland      New York        2010-10-20      -15.0   3014    2010-10-20 
07:00:00
-Washington     New York        2010-10-20      -2.0    7291    2010-10-20 
07:00:00
-Baltimore      New York        2010-10-22      -12.0   1064    2010-10-22 
07:00:00
-Baltimore      New York        2010-10-22      54.0    1142    2010-10-22 
07:00:00
-Baltimore      New York        2010-10-22      18.0    1599    2010-10-22 
07:00:00
-Chicago        New York        2010-10-22      2.0     361     2010-10-22 
07:00:00
-Chicago        New York        2010-10-22      24.0    897     2010-10-22 
07:00:00
-Chicago        New York        2010-10-22      16.0    1531    2010-10-22 
07:00:00
-Chicago        New York        2010-10-22      -6.0    1610    2010-10-22 
07:00:00
-Chicago        New York        2010-10-22      -11.0   3198    2010-10-22 
07:00:00
-Cleveland      New York        2010-10-22      1.0     2630    2010-10-22 
07:00:00
+Cleveland      New York        2010-10-20      -8.0    2630    2010-10-20 
07:00:00
+Cleveland      New York        2010-10-21      29.0    2646    2010-10-21 
07:00:00
+Cleveland      New York        2010-10-21      3.0     2630    2010-10-21 
07:00:00
+Cleveland      New York        2010-10-21      72.0    3014    2010-10-21 
07:00:00
 Cleveland      New York        2010-10-22      -25.0   2646    2010-10-22 
07:00:00
 Cleveland      New York        2010-10-22      -3.0    3014    2010-10-22 
07:00:00
-Baltimore      New York        2010-10-31      -1.0    1599    2010-10-31 
07:00:00
-Baltimore      New York        2010-10-31      -14.0   2571    2010-10-31 
07:00:00
-Chicago        New York        2010-10-31      -25.0   361     2010-10-31 
07:00:00
-Chicago        New York        2010-10-31      -18.0   897     2010-10-31 
07:00:00
-Chicago        New York        2010-10-31      -4.0    1531    2010-10-31 
07:00:00
-Chicago        New York        2010-10-31      -22.0   1610    2010-10-31 
07:00:00
-Chicago        New York        2010-10-31      -15.0   3198    2010-10-31 
07:00:00
+Cleveland      New York        2010-10-22      1.0     2630    2010-10-22 
07:00:00
+Cleveland      New York        2010-10-23      -21.0   2932    2010-10-23 
07:00:00
+Cleveland      New York        2010-10-24      -11.0   2630    2010-10-24 
07:00:00
+Cleveland      New York        2010-10-24      -20.0   2646    2010-10-24 
07:00:00
+Cleveland      New York        2010-10-24      -9.0    3014    2010-10-24 
07:00:00
+Cleveland      New York        2010-10-24      5.0     2254    2010-10-24 
07:00:00
+Cleveland      New York        2010-10-25      -4.0    2630    2010-10-25 
07:00:00
+Cleveland      New York        2010-10-25      42.0    3014    2010-10-25 
07:00:00
+Cleveland      New York        2010-10-25      81.0    2646    2010-10-25 
07:00:00
+Cleveland      New York        2010-10-26      -11.0   2662    2010-10-26 
07:00:00
+Cleveland      New York        2010-10-26      -27.0   2646    2010-10-26 
07:00:00
+Cleveland      New York        2010-10-26      13.0    3014    2010-10-26 
07:00:00
+Cleveland      New York        2010-10-26      4.0     2630    2010-10-26 
07:00:00
+Cleveland      New York        2010-10-27      16.0    2630    2010-10-27 
07:00:00
+Cleveland      New York        2010-10-27      27.0    3014    2010-10-27 
07:00:00
+Cleveland      New York        2010-10-28      -6.0    2646    2010-10-28 
07:00:00
+Cleveland      New York        2010-10-28      1.0     3014    2010-10-28 
07:00:00
+Cleveland      New York        2010-10-28      3.0     2630    2010-10-28 
07:00:00
+Cleveland      New York        2010-10-29      -12.0   3014    2010-10-29 
07:00:00
+Cleveland      New York        2010-10-29      -19.0   2646    2010-10-29 
07:00:00
+Cleveland      New York        2010-10-29      -4.0    2630    2010-10-29 
07:00:00
+Cleveland      New York        2010-10-30      -12.0   2932    2010-10-30 
07:00:00
+Cleveland      New York        2010-10-30      -23.0   2018    2010-10-30 
07:00:00
+Washington     New York        2010-10-20      -2.0    7291    2010-10-20 
07:00:00
+Washington     New York        2010-10-21      22.0    7291    2010-10-21 
07:00:00
+Washington     New York        2010-10-23      -16.0   7274    2010-10-23 
07:00:00
+Washington     New York        2010-10-23      -18.0   5917    2010-10-23 
07:00:00
+Washington     New York        2010-10-23      -21.0   5904    2010-10-23 
07:00:00
+Washington     New York        2010-10-23      -25.0   5832    2010-10-23 
07:00:00
+Washington     New York        2010-10-24      -26.0   7282    2010-10-24 
07:00:00
+Washington     New York        2010-10-25      9.0     7291    2010-10-25 
07:00:00
+Washington     New York        2010-10-26      4.0     7291    2010-10-26 
07:00:00
+Washington     New York        2010-10-27      26.0    7291    2010-10-27 
07:00:00
+Washington     New York        2010-10-28      45.0    7291    2010-10-28 
07:00:00
+Washington     New York        2010-10-29      1.0     7291    2010-10-29 
07:00:00
+Washington     New York        2010-10-30      -16.0   5917    2010-10-30 
07:00:00
+Washington     New York        2010-10-30      -27.0   5904    2010-10-30 
07:00:00
 Washington     New York        2010-10-31      -18.0   7282    2010-10-31 
07:00:00
 PREHOOK: query: select * from flights_tiny_orc_partitioned_timestamp sort by 
fl_num, fl_time limit 25
 PREHOOK: type: QUERY
@@ -1900,29 +1900,29 @@ POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-
 #### A masked pattern was here ####
 Baltimore      New York        2010-10-23      18.0    272     2010-10-23 
07:00:00
 Baltimore      New York        2010-10-30      14.0    272     2010-10-30 
07:00:00
+Chicago        New York        2010-10-20      24.0    897     2010-10-20 
07:00:00
 Chicago        New York        2010-10-20      42.0    361     2010-10-20 
07:00:00
 Chicago        New York        2010-10-21      142.0   361     2010-10-21 
07:00:00
+Chicago        New York        2010-10-21      77.0    897     2010-10-21 
07:00:00
 Chicago        New York        2010-10-22      2.0     361     2010-10-22 
07:00:00
+Chicago        New York        2010-10-22      24.0    897     2010-10-22 
07:00:00
+Chicago        New York        2010-10-23      1.0     650     2010-10-23 
07:00:00
+Chicago        New York        2010-10-23      3.0     384     2010-10-23 
07:00:00
+Chicago        New York        2010-10-23      32.0    426     2010-10-23 
07:00:00
 Chicago        New York        2010-10-24      10.0    361     2010-10-24 
07:00:00
+Chicago        New York        2010-10-24      113.0   897     2010-10-24 
07:00:00
+Chicago        New York        2010-10-25      -1.0    897     2010-10-25 
07:00:00
 Chicago        New York        2010-10-25      31.0    361     2010-10-25 
07:00:00
+Chicago        New York        2010-10-26      0.0     897     2010-10-26 
07:00:00
 Chicago        New York        2010-10-26      12.0    361     2010-10-26 
07:00:00
+Chicago        New York        2010-10-27      -11.0   897     2010-10-27 
07:00:00
 Chicago        New York        2010-10-27      148.0   361     2010-10-27 
07:00:00
 Chicago        New York        2010-10-28      2.0     361     2010-10-28 
07:00:00
 Chicago        New York        2010-10-29      -12.0   361     2010-10-29 
07:00:00
-Chicago        New York        2010-10-31      -25.0   361     2010-10-31 
07:00:00
-Chicago        New York        2010-10-23      3.0     384     2010-10-23 
07:00:00
-Chicago        New York        2010-10-30      -6.0    384     2010-10-30 
07:00:00
-Chicago        New York        2010-10-23      32.0    426     2010-10-23 
07:00:00
 Chicago        New York        2010-10-30      -10.0   426     2010-10-30 
07:00:00
-Chicago        New York        2010-10-23      1.0     650     2010-10-23 
07:00:00
 Chicago        New York        2010-10-30      -5.0    650     2010-10-30 
07:00:00
-Chicago        New York        2010-10-20      24.0    897     2010-10-20 
07:00:00
-Chicago        New York        2010-10-21      77.0    897     2010-10-21 
07:00:00
-Chicago        New York        2010-10-22      24.0    897     2010-10-22 
07:00:00
-Chicago        New York        2010-10-24      113.0   897     2010-10-24 
07:00:00
-Chicago        New York        2010-10-25      -1.0    897     2010-10-25 
07:00:00
-Chicago        New York        2010-10-26      0.0     897     2010-10-26 
07:00:00
-Chicago        New York        2010-10-27      -11.0   897     2010-10-27 
07:00:00
+Chicago        New York        2010-10-30      -6.0    384     2010-10-30 
07:00:00
+Chicago        New York        2010-10-31      -25.0   361     2010-10-31 
07:00:00
 PREHOOK: query: select fl_time, count(*) from 
flights_tiny_orc_partitioned_timestamp group by fl_time
 PREHOOK: type: QUERY
 PREHOOK: Input: default@flights_tiny_orc_partitioned_timestamp
@@ -1955,17 +1955,17 @@ POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-
 POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00
 POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00
 #### A masked pattern was here ####
-2010-10-22 07:00:00    11
-2010-10-23 07:00:00    12
-2010-10-30 07:00:00    11
 2010-10-20 07:00:00    11
 2010-10-21 07:00:00    12
+2010-10-22 07:00:00    11
+2010-10-23 07:00:00    12
 2010-10-24 07:00:00    12
 2010-10-25 07:00:00    12
 2010-10-26 07:00:00    13
 2010-10-27 07:00:00    11
 2010-10-28 07:00:00    12
 2010-10-29 07:00:00    12
+2010-10-30 07:00:00    11
 2010-10-31 07:00:00    8
 PREHOOK: query: explain vectorization expression
 select * from flights_tiny_orc_partitioned_timestamp
@@ -2018,7 +2018,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: flights_tiny_orc_partitioned_timestamp
-                  Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                  Statistics: Num rows: 137 Data size: 96472 Basic stats: 
COMPLETE Column stats: PARTIAL
                   TableScan Vectorization:
                       native: true
                   Select Operator
@@ -2028,13 +2028,13 @@ STAGE PLANS:
                         className: VectorSelectOperator
                         native: true
                         projectedOutputColumnNums: [0, 1, 2, 3, 4, 5]
-                    Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                    Statistics: Num rows: 137 Data size: 62504 Basic stats: 
COMPLETE Column stats: PARTIAL
                     File Output Operator
                       compressed: false
                       File Sink Vectorization:
                           className: VectorFileSinkOperator
                           native: false
-                      Statistics: Num rows: 137 Data size: 39593 Basic stats: 
COMPLETE Column stats: COMPLETE
+                      Statistics: Num rows: 137 Data size: 62504 Basic stats: 
COMPLETE Column stats: PARTIAL
                       table:
                           input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2077,154 +2077,154 @@ POSTHOOK: query: select * from 
flights_tiny_orc_partitioned_timestamp
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp
 POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-20 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-21 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-22 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-23 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-24 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-25 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-26 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-27 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-28 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-29 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00
-POSTHOOK: Input: 
default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00
-#### A masked pattern was here ####
-Baltimore      New York        2010-10-26      -22.0   1064    2010-10-26 
07:00:00
-Baltimore      New York        2010-10-26      123.0   1142    2010-10-26 
07:00:00
-Baltimore      New York        2010-10-26      90.0    1599    2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      12.0    361     2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      0.0     897     2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      29.0    1531    2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      -17.0   1610    2010-10-26 
07:00:00
-Chicago        New York        2010-10-26      6.0     3198    2010-10-26 
07:00:00
-Cleveland      New York        2010-10-26      4.0     2630    2010-10-26 
07:00:00
-Cleveland      New York        2010-10-26      -27.0   2646    2010-10-26 
07:00:00
-Cleveland      New York        2010-10-26      -11.0   2662    2010-10-26 
07:00:00
-Cleveland      New York        2010-10-26      13.0    3014    2010-10-26 
07:00:00
-Washington     New York        2010-10-26      4.0     7291    2010-10-26 
07:00:00
-Baltimore      New York        2010-10-21      17.0    1064    2010-10-21 
07:00:00
-Baltimore      New York        2010-10-21      105.0   1142    2010-10-21 
07:00:00
-Baltimore      New York        2010-10-21      28.0    1599    2010-10-21 
07:00:00
-Chicago        New York        2010-10-21      142.0   361     2010-10-21 
07:00:00
-Chicago        New York        2010-10-21      77.0    897     2010-10-21 
07:00:00
-Chicago        New York        2010-10-21      53.0    1531    2010-10-21 
07:00:00
-Chicago        New York        2010-10-21      -5.0    1610    2010-10-21 
07:00:00
-Chicago        New York        2010-10-21      51.0    3198    2010-10-21 
07:00:00
-Cleveland      New York        2010-10-21      3.0     2630    2010-10-21 
07:00:00
-Cleveland      New York        2010-10-21      29.0    2646    2010-10-21 
07:00:00
-Cleveland      New York        2010-10-21      72.0    3014    2010-10-21 
07:00:00
-Washington     New York        2010-10-21      22.0    7291    2010-10-21 
07:00:00
-Baltimore      New York        2010-10-25      -25.0   1064    2010-10-25 
07:00:00
-Baltimore      New York        2010-10-25      92.0    1142    2010-10-25 
07:00:00
-Baltimore      New York        2010-10-25      106.0   1599    2010-10-25 
07:00:00
-Chicago        New York        2010-10-25      31.0    361     2010-10-25 
07:00:00
-Chicago        New York        2010-10-25      -1.0    897     2010-10-25 
07:00:00
-Chicago        New York        2010-10-25      43.0    1531    2010-10-25 
07:00:00
-Chicago        New York        2010-10-25      6.0     1610    2010-10-25 
07:00:00
-Chicago        New York        2010-10-25      -16.0   3198    2010-10-25 
07:00:00
-Cleveland      New York        2010-10-25      -4.0    2630    2010-10-25 
07:00:00
-Cleveland      New York        2010-10-25      81.0    2646    2010-10-25 
07:00:00
-Cleveland      New York        2010-10-25      42.0    3014    2010-10-25 
07:00:00
-Washington     New York        2010-10-25      9.0     7291    2010-10-25 
07:00:00
-Baltimore      New York        2010-10-24      12.0    1599    2010-10-24 
07:00:00
-Baltimore      New York        2010-10-24      20.0    2571    2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      10.0    361     2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      113.0   897     2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      -5.0    1531    2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      -17.0   1610    2010-10-24 
07:00:00
-Chicago        New York        2010-10-24      -3.0    3198    2010-10-24 
07:00:00
-Cleveland      New York        2010-10-24      5.0     2254    2010-10-24 
07:00:00
-Cleveland      Ne

<TRUNCATED>