http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/alter_table_update_status.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/alter_table_update_status.q.out 
b/ql/src/test/results/clientpositive/alter_table_update_status.q.out
index 452f37b..899ebbd 100644
--- a/ql/src/test/results/clientpositive/alter_table_update_status.q.out
+++ b/ql/src/test/results/clientpositive/alter_table_update_status.q.out
@@ -46,9 +46,18 @@ PREHOOK: Input: default@src_stat
 POSTHOOK: query: describe formatted src_stat key
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@src_stat
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-key                    string                                                  
                0                       16                      1.72            
        3                                                                       
HL                      from deserializer   
+col_name               key                                                     
                                         
+data_type              string                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              0                                                       
                                         
+distinct_count         16                                                      
                                         
+avg_col_len            1.72                                                    
                                         
+max_col_len            3                                                       
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector              HL                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\"}}                  
                                                         
 PREHOOK: query: ALTER TABLE src_stat UPDATE STATISTICS for column key SET 
('numDVs'='1111','avgColLen'='1.111')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -60,9 +69,18 @@ PREHOOK: Input: default@src_stat
 POSTHOOK: query: describe formatted src_stat key
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@src_stat
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-key                    string                                                  
                0                       1111                    1.111           
        3                                                                       
HL                      from deserializer   
+col_name               key                                                     
                                         
+data_type              string                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              0                                                       
                                         
+distinct_count         1111                                                    
                                         
+avg_col_len            1.111                                                   
                                         
+max_col_len            3                                                       
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector              HL                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\"}}                  
                                                         
 PREHOOK: query: ALTER TABLE src_stat UPDATE STATISTICS for column value SET 
('numDVs'='121','numNulls'='122','avgColLen'='1.23','maxColLen'='124')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -74,9 +92,18 @@ PREHOOK: Input: default@src_stat
 POSTHOOK: query: describe formatted src_stat value
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@src_stat
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-value                  string                                                  
                122                     121                     1.23            
        124                                                                     
                        from deserializer   
+col_name               value                                                   
                                         
+data_type              string                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              122                                                     
                                         
+distinct_count         121                                                     
                                         
+avg_col_len            1.23                                                    
                                         
+max_col_len            124                                                     
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
                                                                                
 PREHOOK: query: ANALYZE TABLE src_stat_int COMPUTE STATISTICS for columns key
 PREHOOK: type: QUERY
@@ -92,9 +119,18 @@ PREHOOK: Input: default@src_stat_int
 POSTHOOK: query: describe formatted src_stat_int key
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@src_stat_int
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-key                    double                  66.0                    406.0   
                10                      15                                      
                                                                                
HL                      from deserializer   
+col_name               key                                                     
                                         
+data_type              double                                                  
                                         
+min                    66.0                                                    
                                         
+max                    406.0                                                   
                                         
+num_nulls              10                                                      
                                         
+distinct_count         15                                                      
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector              HL                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"COLUMN_STATS\":{\"key\":\"true\"}}                   
                                                         
 PREHOOK: query: ALTER TABLE src_stat_int UPDATE STATISTICS for column key SET 
('numDVs'='2222','lowValue'='333.22','highValue'='22.22')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -106,9 +142,18 @@ PREHOOK: Input: default@src_stat_int
 POSTHOOK: query: describe formatted src_stat_int key
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@src_stat_int
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-key                    double                  333.22                  22.22   
                10                      2222                                    
                                                                                
HL                      from deserializer   
+col_name               key                                                     
                                         
+data_type              double                                                  
                                         
+min                    333.22                                                  
                                         
+max                    22.22                                                   
                                         
+num_nulls              10                                                      
                                         
+distinct_count         2222                                                    
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector              HL                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"COLUMN_STATS\":{\"key\":\"true\"}}                   
                                                         
 PREHOOK: query: create database if not exists dummydb
 PREHOOK: type: CREATEDATABASE
@@ -132,9 +177,18 @@ PREHOOK: Input: default@src_stat
 POSTHOOK: query: describe formatted default.src_stat key
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@src_stat
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-key                    string                                                  
                0                       3333                    2.222           
        3                                                                       
HL                      from deserializer   
+col_name               key                                                     
                                         
+data_type              string                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              0                                                       
                                         
+distinct_count         3333                                                    
                                         
+avg_col_len            2.222                                                   
                                         
+max_col_len            3                                                       
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector              HL                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
                                                                                
 PREHOOK: query: ALTER TABLE default.src_stat UPDATE STATISTICS for column 
value SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -146,9 +200,18 @@ PREHOOK: Input: default@src_stat
 POSTHOOK: query: describe formatted default.src_stat value
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@src_stat
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-value                  string                                                  
                233                     232                     2.34            
        235                                                                     
                        from deserializer   
+col_name               value                                                   
                                         
+data_type              string                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              233                                                     
                                         
+distinct_count         232                                                     
                                         
+avg_col_len            2.34                                                    
                                         
+max_col_len            235                                                     
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
                                                                                
 PREHOOK: query: use default
 PREHOOK: type: SWITCHDATABASE
@@ -246,9 +309,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats s
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-s                      smallint                                                
                                                                                
                                                                                
                        from deserializer   
+col_name               s                                                       
                                         
+data_type              smallint                                                
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats i
 PREHOOK: type: DESCTABLE
@@ -256,9 +328,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats i
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-i                      int                                                     
                                                                                
                                                                                
                        from deserializer   
+col_name               i                                                       
                                         
+data_type              int                                                     
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats b
 PREHOOK: type: DESCTABLE
@@ -266,9 +347,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats b
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-b                      bigint                                                  
                                                                                
                                                                                
                        from deserializer   
+col_name               b                                                       
                                         
+data_type              bigint                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats f
 PREHOOK: type: DESCTABLE
@@ -276,9 +366,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats f
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-f                      float                                                   
                                                                                
                                                                                
                        from deserializer   
+col_name               f                                                       
                                         
+data_type              float                                                   
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats d
 PREHOOK: type: DESCTABLE
@@ -286,9 +385,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats d
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-d                      double                                                  
                                                                                
                                                                                
                        from deserializer   
+col_name               d                                                       
                                         
+data_type              double                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats dem
 PREHOOK: type: DESCTABLE
@@ -296,9 +404,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats dem
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-dem                    decimal(10,0)                                           
                                                                                
                                                                                
                        from deserializer   
+col_name               dem                                                     
                                         
+data_type              decimal(10,0)                                           
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats ts
 PREHOOK: type: DESCTABLE
@@ -306,9 +423,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats ts
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-ts                     timestamp                                               
                                                                                
                                                                                
                        from deserializer   
+col_name               ts                                                      
                                         
+data_type              timestamp                                               
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats dt
 PREHOOK: type: DESCTABLE
@@ -316,9 +442,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats dt
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-dt                     date                                                    
                                                                                
                                                                                
                        from deserializer   
+col_name               dt                                                      
                                         
+data_type              date                                                    
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats str
 PREHOOK: type: DESCTABLE
@@ -326,9 +461,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats str
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-str                    string                                                  
                                                                                
                                                                                
                        from deserializer   
+col_name               str                                                     
                                         
+data_type              string                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats v
 PREHOOK: type: DESCTABLE
@@ -336,9 +480,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats v
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-v                      varchar(12)                                             
                                                                                
                                                                                
                        from deserializer   
+col_name               v                                                       
                                         
+data_type              varchar(12)                                             
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats c
 PREHOOK: type: DESCTABLE
@@ -346,9 +499,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats c
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-c                      char(5)                                                 
                                                                                
                                                                                
                        from deserializer   
+col_name               c                                                       
                                         
+data_type              char(5)                                                 
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats bl
 PREHOOK: type: DESCTABLE
@@ -356,9 +518,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats bl
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-bl                     boolean                                                 
                                                                                
                                                                                
                        from deserializer   
+col_name               bl                                                      
                                         
+data_type              boolean                                                 
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats bin
 PREHOOK: type: DESCTABLE
@@ -366,9 +537,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats bin
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-bin                    binary                                                  
                                                                                
                                                                                
                        from deserializer   
+col_name               bin                                                     
                                         
+data_type              binary                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: DESC FORMATTED datatype_stats t
 PREHOOK: type: DESCTABLE
@@ -376,9 +556,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats t
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-t                      tinyint                                                 
                                                                                
                                                                                
                        from deserializer   
+col_name               t                                                       
                                         
+data_type              tinyint                                                 
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  {\"BASIC_STATS\":\"true\"}                              
                                                 
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column t SET ('numDVs'='232','numNulls'='233','highValue'='234','lowValue'='35')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -390,9 +579,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats t
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-t                      tinyint                 35                      234     
                233                     232                                     
                                                                                
                        from deserializer   
+col_name               t                                                       
                                         
+data_type              tinyint                                                 
                                         
+min                    35                                                      
                                         
+max                    234                                                     
                                         
+num_nulls              233                                                     
                                         
+distinct_count         232                                                     
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"t\":\"true\"}}                    
                                                         
 PREHOOK: query: DESC FORMATTED datatype_stats s
 PREHOOK: type: DESCTABLE
@@ -400,9 +598,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats s
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-s                      smallint                                                
                                                                                
                                                                                
                        from deserializer   
+col_name               s                                                       
                                         
+data_type              smallint                                                
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"t\":\"true\"}}                    
                                                         
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column s SET ('numDVs'='56','numNulls'='56','highValue'='489','lowValue'='25')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -414,9 +621,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats s
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-s                      smallint                25                      489     
                56                      56                                      
                                                                                
                        from deserializer   
+col_name               s                                                       
                                         
+data_type              smallint                                                
                                         
+min                    25                                                      
                                         
+max                    489                                                     
                                         
+num_nulls              56                                                      
                                         
+distinct_count         56                                                      
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"s\":\"true\",\"t\":\"true\"}}     
                                                                         
 PREHOOK: query: DESC FORMATTED datatype_stats i
 PREHOOK: type: DESCTABLE
@@ -424,9 +640,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats i
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-i                      int                                                     
                                                                                
                                                                                
                        from deserializer   
+col_name               i                                                       
                                         
+data_type              int                                                     
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"s\":\"true\",\"t\":\"true\"}}     
                                                                         
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column i SET ('numDVs'='59','numNulls'='1','highValue'='889','lowValue'='5')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -438,9 +663,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats i
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-i                      int                     5                       889     
                1                       59                                      
                                                                                
                        from deserializer   
+col_name               i                                                       
                                         
+data_type              int                                                     
                                         
+min                    5                                                       
                                         
+max                    889                                                     
                                         
+num_nulls              1                                                       
                                         
+distinct_count         59                                                      
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                               
 PREHOOK: query: DESC FORMATTED datatype_stats b
 PREHOOK: type: DESCTABLE
@@ -448,9 +682,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats b
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-b                      bigint                                                  
                                                                                
                                                                                
                        from deserializer   
+col_name               b                                                       
                                         
+data_type              bigint                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                               
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column b SET ('numDVs'='9','numNulls'='14','highValue'='89','lowValue'='8')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -462,9 +705,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats b
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-b                      bigint                  8                       89      
                14                      9                                       
                                                                                
                        from deserializer   
+col_name               b                                                       
                                         
+data_type              bigint                                                  
                                         
+min                    8                                                       
                                         
+max                    89                                                      
                                         
+num_nulls              14                                                      
                                         
+distinct_count         9                                                       
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                                
 PREHOOK: query: DESC FORMATTED datatype_stats f
 PREHOOK: type: DESCTABLE
@@ -472,9 +724,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats f
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-f                      float                                                   
                                                                                
                                                                                
                        from deserializer   
+col_name               f                                                       
                                         
+data_type              float                                                   
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                                
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column f SET 
('numDVs'='563','numNulls'='45','highValue'='2345.656','lowValue'='8.00')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -486,9 +747,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats f
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-f                      float                   8.0                     
2345.656                45                      563                             
                                                                                
                                from deserializer   
+col_name               f                                                       
                                         
+data_type              float                                                   
                                         
+min                    8.0                                                     
                                         
+max                    2345.656                                                
                                         
+num_nulls              45                                                      
                                         
+distinct_count         563                                                     
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                                
 
 PREHOOK: query: DESC FORMATTED datatype_stats d
 PREHOOK: type: DESCTABLE
@@ -496,9 +766,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats d
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-d                      double                                                  
                                                                                
                                                                                
                        from deserializer   
+col_name               d                                                       
                                         
+data_type              double                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                                
 
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column d SET 
('numDVs'='5677','numNulls'='12','highValue'='560.3367','lowValue'='0.00455')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -510,9 +789,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats d
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-d                      double                  0.00455                 
560.3367                12                      5677                            
                                                                                
                                from deserializer   
+col_name               d                                                       
                                         
+data_type              double                                                  
                                         
+min                    0.00455                                                 
                                         
+max                    560.3367                                                
                                         
+num_nulls              12                                                      
                                         
+distinct_count         5677                                                    
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                          
 PREHOOK: query: DESC FORMATTED datatype_stats dem
 PREHOOK: type: DESCTABLE
@@ -520,9 +808,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats dem
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-dem                    decimal(10,0)                                           
                                                                                
                                                                                
                        from deserializer   
+col_name               dem                                                     
                                         
+data_type              decimal(10,0)                                           
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                          
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column dem SET ('numDVs'='57','numNulls'='912','highValue'='560','lowValue'='0')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -534,9 +831,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats dem
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-dem                    decimal(10,0)           0                       560     
                912                     57                                      
                                                                                
                        from deserializer   
+col_name               dem                                                     
                                         
+data_type              decimal(10,0)                                           
                                         
+min                    0                                                       
                                         
+max                    560                                                     
                                         
+num_nulls              912                                                     
                                         
+distinct_count         57                                                      
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                                
 
 PREHOOK: query: DESC FORMATTED datatype_stats ts
 PREHOOK: type: DESCTABLE
@@ -544,9 +850,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats ts
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-ts                     timestamp                                               
                                                                                
                                                                                
                        from deserializer   
+col_name               ts                                                      
                                         
+data_type              timestamp                                               
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
                                                                                
 
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column ts SET 
('numDVs'='7','numNulls'='12','highValue'='1357030923','lowValue'='1357030924')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -558,9 +873,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats ts
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-ts                     timestamp               1357030924              
1357030923              12                      7                               
                                                                                
                                from deserializer   
+col_name               ts                                                      
                                         
+data_type              timestamp                                               
                                         
+min                    1357030924                                              
                                         
+max                    1357030923                                              
                                         
+num_nulls              12                                                      
                                         
+distinct_count         7                                                       
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
                                                                                
 
 PREHOOK: query: DESC FORMATTED datatype_stats dt
 PREHOOK: type: DESCTABLE
@@ -568,9 +892,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats dt
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-dt                     date                                                    
                                                                                
                                                                                
                        from deserializer   
+col_name               dt                                                      
                                         
+data_type              date                                                    
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
                                                                                
 
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column dt SET 
('numDVs'='57','numNulls'='912','highValue'='2012-01-01','lowValue'='2001-02-04')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -582,9 +915,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats dt
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-dt                     date                    2001-02-04              
2012-01-01              912                     57                              
                                                                                
                                from deserializer   
+col_name               dt                                                      
                                         
+data_type              date                                                    
                                         
+min                    2001-02-04                                              
                                         
+max                    2012-01-01                                              
                                         
+num_nulls              912                                                     
                                         
+distinct_count         57                                                      
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
                                                                                
 
 PREHOOK: query: DESC FORMATTED datatype_stats str
 PREHOOK: type: DESCTABLE
@@ -592,9 +934,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats str
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-str                    string                                                  
                                                                                
                                                                                
                        from deserializer   
+col_name               str                                                     
                                         
+data_type              string                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
                                                                                
 
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column str SET 
('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -606,9 +957,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats str
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-str                    string                                                  
                233                     232                     2.34            
        235                                                                     
                        from deserializer   
+col_name               str                                                     
                                         
+data_type              string                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              233                                                     
                                         
+distinct_count         232                                                     
                                         
+avg_col_len            2.34                                                    
                                         
+max_col_len            235                                                     
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
                                                                                
 PREHOOK: query: DESC FORMATTED datatype_stats v
 PREHOOK: type: DESCTABLE
@@ -616,9 +976,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats v
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-v                      varchar(12)                                             
                                                                                
                                                                                
                        from deserializer   
+col_name               v                                                       
                                         
+data_type              varchar(12)                                             
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
                                                                                
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column v SET ('numDVs'='22','numNulls'='33','avgColLen'='4.40','maxColLen'='25')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -630,9 +999,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats v
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-v                      varchar(12)                                             
                33                      22                      4.4             
        25                                                                      
                        from deserializer   
+col_name               v                                                       
                                         
+data_type              varchar(12)                                             
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              33                                                      
                                         
+distinct_count         22                                                      
                                         
+avg_col_len            4.4                                                     
                                         
+max_col_len            25                                                      
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
                                                                                
 
 PREHOOK: query: DESC FORMATTED datatype_stats c
 PREHOOK: type: DESCTABLE
@@ -640,9 +1018,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats c
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-c                      char(5)                                                 
                                                                                
                                                                                
                        from deserializer   
+col_name               c                                                       
                                         
+data_type              char(5)                                                 
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
                                                                                
 
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column c SET ('numDVs'='2','numNulls'='03','avgColLen'='9.00','maxColLen'='58')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -654,9 +1041,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats c
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-c                      char(5)                                                 
                3                       2                       9.0             
        58                                                                      
                        from deserializer   
+col_name               c                                                       
                                         
+data_type              char(5)                                                 
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              3                                                       
                                         
+distinct_count         2                                                       
                                         
+avg_col_len            9.0                                                     
                                         
+max_col_len            58                                                      
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
                                                                          
 PREHOOK: query: DESC FORMATTED datatype_stats bl
 PREHOOK: type: DESCTABLE
@@ -664,9 +1060,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats bl
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-bl                     boolean                                                 
                                                                                
                                                                                
                        from deserializer   
+col_name               bl                                                      
                                         
+data_type              boolean                                                 
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
                                                                          
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column bl SET ('numNulls'='1','numTrues'='9','numFalses'='8')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -678,9 +1083,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats bl
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-bl                     boolean                                                 
                1                                                               
                                9                       8                       
                        from deserializer   
+col_name               bl                                                      
                                         
+data_type              boolean                                                 
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              1                                                       
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues              9                                                       
                                         
+num_falses             8                                                       
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
                                                                          
 PREHOOK: query: DESC FORMATTED datatype_stats bin
 PREHOOK: type: DESCTABLE
@@ -688,9 +1102,18 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats bin
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-bin                    binary                                                  
                                                                                
                                                                                
                        from deserializer   
+col_name               bin                                                     
                                         
+data_type              binary                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls                                                                      
                                         
+distinct_count                                                                 
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
                                                                          
 PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for 
column bin SET ('numNulls'='8','avgColLen'='2.0','maxColLen'='8')
 PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -702,7 +1125,16 @@ PREHOOK: Input: default@datatype_stats
 POSTHOOK: query: DESC FORMATTED datatype_stats bin
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@datatype_stats
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-bin                    binary                                                  
                8                                               2.0             
        8                                                                       
                        from deserializer   
+col_name               bin                                                     
                                         
+data_type              binary                                                  
                                         
+min                                                                            
                                         
+max                                                                            
                                         
+num_nulls              8                                                       
                                         
+distinct_count                                                                 
                                         
+avg_col_len            2.0                                                     
                                         
+max_col_len            8                                                       
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector                                                                      
                                         
+comment                from deserializer                                       
                                         
 COLUMN_STATS_ACCURATE  
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bin\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
                                                                                
 

Reply via email to