http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/statsfs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/statsfs.q.out 
b/ql/src/test/results/clientpositive/spark/statsfs.q.out
index d070e9a..fef2040 100644
--- a/ql/src/test/results/clientpositive/spark/statsfs.q.out
+++ b/ql/src/test/results/clientpositive/spark/statsfs.q.out
@@ -47,13 +47,11 @@ POSTHOOK: query: describe formatted t1 partition (ds='2010')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@t1
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Partition Information                
@@ -86,13 +84,11 @@ POSTHOOK: query: describe formatted t1 partition (ds='2011')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@t1
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Partition Information                
@@ -161,13 +157,11 @@ POSTHOOK: query: describe formatted t1 partition 
(ds='2010')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@t1
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Partition Information                
@@ -200,13 +194,11 @@ POSTHOOK: query: describe formatted t1 partition 
(ds='2011')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@t1
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Partition Information                
@@ -271,7 +263,6 @@ POSTHOOK: query: describe formatted t1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@t1
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
@@ -332,7 +323,6 @@ POSTHOOK: query: describe formatted t1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@t1
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
@@ -410,13 +400,11 @@ POSTHOOK: query: describe formatted t1 partition 
(ds='2008-04-08',hr='11')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@t1
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -450,13 +438,11 @@ POSTHOOK: query: describe formatted t1 partition 
(ds='2008-04-09',hr='12')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@t1
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_1.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
index 1cc1303..858cac6 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
@@ -145,7 +145,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_10.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
index 18438d2..6bac57b 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
@@ -220,7 +220,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_11.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
index 8aeb902..992ddd7 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
@@ -210,7 +210,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_12.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_12.q.out
index 020497f..fc3eb6d 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_12.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_12.q.out
@@ -212,7 +212,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_13.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_13.q.out
index e83f927..4ed630b 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_13.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_13.q.out
@@ -234,7 +234,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_14.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_14.q.out
index 020497f..fc3eb6d 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_14.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_14.q.out
@@ -212,7 +212,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_15.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
index 320d869..8a25ceb 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
@@ -158,13 +158,11 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Table Information            

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_16.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
index 04b668b..8594301 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
@@ -200,13 +200,11 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Table Information            

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_17.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
index f4eed3c..cef4255 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
@@ -136,13 +136,11 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Table Information            

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_18.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
index 62c3598..51f2f16 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
@@ -170,13 +170,11 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Table Information            

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_19.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
index 0ec066e..4e3dc8e 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
@@ -145,7 +145,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_2.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_2.q.out
index 928f266..d440f45 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_2.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_2.q.out
@@ -170,7 +170,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_20.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_20.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_20.q.out
index 1bc3d57..4e2d472 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_20.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_20.q.out
@@ -153,7 +153,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 values                 bigint                                      
 key                    string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_21.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_21.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_21.q.out
index d9fcf54..9eb2978 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_21.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_21.q.out
@@ -140,7 +140,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
                 
 # Detailed Table Information            

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_22.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_22.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_22.q.out
index 2f9941d..072d5c9 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_22.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_22.q.out
@@ -154,7 +154,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
 values2                bigint                                      

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_23.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_23.q.out
index dcc8635..89938f0 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_23.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_23.q.out
@@ -206,7 +206,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_24.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_24.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_24.q.out
index 8f7187b..8ba574a 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_24.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_24.q.out
@@ -153,7 +153,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    double                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_25.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_25.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_25.q.out
index 1949a90..f681428 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_25.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_25.q.out
@@ -163,13 +163,11 @@ POSTHOOK: query: desc formatted outputTbl1 
partition(ds='2004')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Partition Information                
@@ -354,13 +352,11 @@ POSTHOOK: query: desc formatted outputTbl2 
partition(ds='2008-04-08')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl2
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Partition Information                
@@ -528,13 +524,11 @@ POSTHOOK: query: desc formatted outputTbl3 
partition(ds='2008-04-08', hr='11')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl3
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_3.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_3.q.out
index 7531472..4ce449b 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_3.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_3.q.out
@@ -160,7 +160,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_4.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_4.q.out
index b31ae64..405356b 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_4.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_4.q.out
@@ -195,7 +195,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_5.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_5.q.out
index 1380180..36046a5 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_5.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_5.q.out
@@ -220,7 +220,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_7.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_7.q.out
index 0fabbac..5ccadb2 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_7.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_7.q.out
@@ -145,7 +145,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_8.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_8.q.out
index c96f591..31680e9 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_8.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_8.q.out
@@ -170,7 +170,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/spark/union_remove_9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_9.q.out 
b/ql/src/test/results/clientpositive/spark/union_remove_9.q.out
index 550b2ad..43b77c8 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_9.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_9.q.out
@@ -228,7 +228,6 @@ POSTHOOK: query: desc formatted outputTbl1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@outputtbl1
 # col_name             data_type               comment             
-                
 key                    string                                      
 values                 bigint                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats0.q.out 
b/ql/src/test/results/clientpositive/stats0.q.out
index 0476acb..c7e8da9 100644
--- a/ql/src/test/results/clientpositive/stats0.q.out
+++ b/ql/src/test/results/clientpositive/stats0.q.out
@@ -1274,7 +1274,6 @@ ds                        string
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 #### A masked pattern was here ####
@@ -1290,7 +1289,6 @@ ds                        string
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 #### A masked pattern was here ####
@@ -2824,7 +2822,6 @@ ds                        string
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 #### A masked pattern was here ####
@@ -2840,7 +2837,6 @@ ds                        string
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 #### A masked pattern was here ####

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats1.q.out 
b/ql/src/test/results/clientpositive/stats1.q.out
index 5c6049b..075e16b 100644
--- a/ql/src/test/results/clientpositive/stats1.q.out
+++ b/ql/src/test/results/clientpositive/stats1.q.out
@@ -167,7 +167,6 @@ POSTHOOK: query: DESCRIBE FORMATTED tmptable
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@tmptable
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
@@ -210,7 +209,6 @@ POSTHOOK: query: DESCRIBE FORMATTED tmptable
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@tmptable
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats10.q.out 
b/ql/src/test/results/clientpositive/stats10.q.out
index d1fe473..fa6142f 100644
--- a/ql/src/test/results/clientpositive/stats10.q.out
+++ b/ql/src/test/results/clientpositive/stats10.q.out
@@ -399,13 +399,11 @@ POSTHOOK: query: describe formatted bucket3_1 partition 
(ds='1')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@bucket3_1
 # col_name             data_type               comment             
-                
 key                    int                                         
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Partition Information                
@@ -438,13 +436,11 @@ POSTHOOK: query: describe formatted bucket3_1 partition 
(ds='2')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@bucket3_1
 # col_name             data_type               comment             
-                
 key                    int                                         
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Partition Information                
@@ -477,13 +473,11 @@ POSTHOOK: query: describe formatted bucket3_1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@bucket3_1
 # col_name             data_type               comment             
-                
 key                    int                                         
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
                 
 # Detailed Table Information            

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats12.q.out 
b/ql/src/test/results/clientpositive/stats12.q.out
index cebdf67..3b91cc9 100644
--- a/ql/src/test/results/clientpositive/stats12.q.out
+++ b/ql/src/test/results/clientpositive/stats12.q.out
@@ -176,13 +176,11 @@ POSTHOOK: query: desc formatted analyze_srcpart
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -217,13 +215,11 @@ POSTHOOK: query: desc formatted analyze_srcpart partition 
(ds='2008-04-08', hr=1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -257,13 +253,11 @@ POSTHOOK: query: desc formatted analyze_srcpart partition 
(ds='2008-04-08', hr=1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -297,13 +291,11 @@ POSTHOOK: query: desc formatted analyze_srcpart partition 
(ds='2008-04-09', hr=1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -334,13 +326,11 @@ POSTHOOK: query: desc formatted analyze_srcpart partition 
(ds='2008-04-09', hr=1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats13.q.out 
b/ql/src/test/results/clientpositive/stats13.q.out
index 227dfb5..903e256 100644
--- a/ql/src/test/results/clientpositive/stats13.q.out
+++ b/ql/src/test/results/clientpositive/stats13.q.out
@@ -126,13 +126,11 @@ POSTHOOK: query: desc formatted analyze_srcpart
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -167,13 +165,11 @@ POSTHOOK: query: desc formatted analyze_srcpart partition 
(ds='2008-04-08', hr=1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -207,13 +203,11 @@ POSTHOOK: query: desc formatted analyze_srcpart partition 
(ds='2008-04-08', hr=1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -244,13 +238,11 @@ POSTHOOK: query: desc formatted analyze_srcpart partition 
(ds='2008-04-09', hr=1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -281,13 +273,11 @@ POSTHOOK: query: desc formatted analyze_srcpart partition 
(ds='2008-04-09', hr=1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -326,13 +316,11 @@ POSTHOOK: query: desc formatted analyze_srcpart2
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart2
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats14.q.out 
b/ql/src/test/results/clientpositive/stats14.q.out
index 8501746..eb8a995 100644
--- a/ql/src/test/results/clientpositive/stats14.q.out
+++ b/ql/src/test/results/clientpositive/stats14.q.out
@@ -31,7 +31,6 @@ POSTHOOK: query: desc formatted stats_src
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_src
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
@@ -128,13 +127,11 @@ POSTHOOK: query: desc formatted stats_part
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -170,13 +167,11 @@ POSTHOOK: query: desc formatted stats_part partition 
(ds='2010-04-08', hr = '11'
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -210,13 +205,11 @@ POSTHOOK: query: desc formatted stats_part partition 
(ds='2010-04-08', hr = '12'
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -270,13 +263,11 @@ POSTHOOK: query: desc formatted stats_part
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats15.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats15.q.out 
b/ql/src/test/results/clientpositive/stats15.q.out
index 8501746..eb8a995 100644
--- a/ql/src/test/results/clientpositive/stats15.q.out
+++ b/ql/src/test/results/clientpositive/stats15.q.out
@@ -31,7 +31,6 @@ POSTHOOK: query: desc formatted stats_src
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_src
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
@@ -128,13 +127,11 @@ POSTHOOK: query: desc formatted stats_part
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -170,13 +167,11 @@ POSTHOOK: query: desc formatted stats_part partition 
(ds='2010-04-08', hr = '11'
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -210,13 +205,11 @@ POSTHOOK: query: desc formatted stats_part partition 
(ds='2010-04-08', hr = '12'
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -270,13 +263,11 @@ POSTHOOK: query: desc formatted stats_part
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats16.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats16.q.out 
b/ql/src/test/results/clientpositive/stats16.q.out
index 3b371a8..659d581 100644
--- a/ql/src/test/results/clientpositive/stats16.q.out
+++ b/ql/src/test/results/clientpositive/stats16.q.out
@@ -17,7 +17,6 @@ POSTHOOK: query: desc formatted stats16
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats16
 # col_name             data_type               comment             
-                
 key                    int                                         
 value                  string                                      
                 
@@ -65,7 +64,6 @@ POSTHOOK: query: desc formatted stats16
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats16
 # col_name             data_type               comment             
-                
 key                    int                                         
 value                  string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats18.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats18.q.out 
b/ql/src/test/results/clientpositive/stats18.q.out
index 4945808..dd54c0d 100644
--- a/ql/src/test/results/clientpositive/stats18.q.out
+++ b/ql/src/test/results/clientpositive/stats18.q.out
@@ -23,13 +23,11 @@ POSTHOOK: query: desc formatted stats_part partition 
(ds='2010-04-08', hr='13')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -71,13 +69,11 @@ POSTHOOK: query: desc formatted stats_part partition 
(ds='2010-04-08', hr='13')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_part
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats2.q.out 
b/ql/src/test/results/clientpositive/stats2.q.out
index 29a659f..991b137 100644
--- a/ql/src/test/results/clientpositive/stats2.q.out
+++ b/ql/src/test/results/clientpositive/stats2.q.out
@@ -83,13 +83,11 @@ POSTHOOK: query: desc formatted analyze_t1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_t1
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -167,13 +165,11 @@ POSTHOOK: query: describe formatted analyze_t1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_t1
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats3.q.out 
b/ql/src/test/results/clientpositive/stats3.q.out
index 2f76d0e..7d4ed9b 100644
--- a/ql/src/test/results/clientpositive/stats3.q.out
+++ b/ql/src/test/results/clientpositive/stats3.q.out
@@ -71,7 +71,6 @@ POSTHOOK: query: desc formatted hive_test_src
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@hive_test_src
 # col_name             data_type               comment             
-                
 col1                   string                                      
                 
 # Detailed Table Information            
@@ -204,12 +203,10 @@ POSTHOOK: query: describe formatted hive_test_dst
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@hive_test_dst
 # col_name             data_type               comment             
-                
 col1                   string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 pcol1                  string                                      
 pcol2                  string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats4.q.out 
b/ql/src/test/results/clientpositive/stats4.q.out
index 8f503a9..c0c3c12 100644
--- a/ql/src/test/results/clientpositive/stats4.q.out
+++ b/ql/src/test/results/clientpositive/stats4.q.out
@@ -2289,13 +2289,11 @@ POSTHOOK: query: describe formatted nzhang_part1 
partition(ds='2008-04-08',hr=11
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@nzhang_part1
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -2329,13 +2327,11 @@ POSTHOOK: query: describe formatted nzhang_part1 
partition(ds='2008-04-08',hr=12
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@nzhang_part1
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -2369,13 +2365,11 @@ POSTHOOK: query: describe formatted nzhang_part2 
partition(ds='2008-12-31',hr=11
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@nzhang_part2
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -2409,13 +2403,11 @@ POSTHOOK: query: describe formatted nzhang_part2 
partition(ds='2008-12-31',hr=12
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@nzhang_part2
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -2449,13 +2441,11 @@ POSTHOOK: query: describe formatted nzhang_part1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@nzhang_part1
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -2491,13 +2481,11 @@ POSTHOOK: query: describe formatted nzhang_part2
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@nzhang_part2
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats5.q.out 
b/ql/src/test/results/clientpositive/stats5.q.out
index 74ddadb..b71c7c1 100644
--- a/ql/src/test/results/clientpositive/stats5.q.out
+++ b/ql/src/test/results/clientpositive/stats5.q.out
@@ -44,7 +44,6 @@ POSTHOOK: query: describe formatted analyze_src
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_src
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats6.q.out 
b/ql/src/test/results/clientpositive/stats6.q.out
index 81a80cb..704bff8 100644
--- a/ql/src/test/results/clientpositive/stats6.q.out
+++ b/ql/src/test/results/clientpositive/stats6.q.out
@@ -64,13 +64,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -104,13 +102,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -144,13 +140,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-09',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -181,13 +175,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-09',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -218,13 +210,11 @@ POSTHOOK: query: describe formatted analyze_srcpart
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats7.q.out 
b/ql/src/test/results/clientpositive/stats7.q.out
index 4d30413..5db2619 100644
--- a/ql/src/test/results/clientpositive/stats7.q.out
+++ b/ql/src/test/results/clientpositive/stats7.q.out
@@ -75,13 +75,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -115,13 +113,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -155,13 +151,11 @@ POSTHOOK: query: describe formatted analyze_srcpart
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats8.q.out 
b/ql/src/test/results/clientpositive/stats8.q.out
index ea5f1d0..3a617d4 100644
--- a/ql/src/test/results/clientpositive/stats8.q.out
+++ b/ql/src/test/results/clientpositive/stats8.q.out
@@ -71,13 +71,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -111,13 +109,11 @@ POSTHOOK: query: describe formatted analyze_srcpart
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -183,13 +179,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -254,13 +248,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-09',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -325,13 +317,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-09',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -408,13 +398,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -448,13 +436,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -488,13 +474,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-09',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -528,13 +512,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-09',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -568,13 +550,11 @@ POSTHOOK: query: describe formatted analyze_srcpart
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats9.q.out 
b/ql/src/test/results/clientpositive/stats9.q.out
index a073b8b..7556c05 100644
--- a/ql/src/test/results/clientpositive/stats9.q.out
+++ b/ql/src/test/results/clientpositive/stats9.q.out
@@ -50,7 +50,6 @@ POSTHOOK: query: describe formatted analyze_srcbucket
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcbucket
 # col_name             data_type               comment             
-                
 key                    int                                         
 value                  string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats_empty_partition.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats_empty_partition.q.out 
b/ql/src/test/results/clientpositive/stats_empty_partition.q.out
index 289d17a..b1ddac3 100644
--- a/ql/src/test/results/clientpositive/stats_empty_partition.q.out
+++ b/ql/src/test/results/clientpositive/stats_empty_partition.q.out
@@ -23,13 +23,11 @@ POSTHOOK: query: describe formatted tmptable partition 
(part = '1')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@tmptable
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 part                   string                                      
                 
 # Detailed Partition Information                

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats_invalidation.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats_invalidation.q.out 
b/ql/src/test/results/clientpositive/stats_invalidation.q.out
index a0e7663..77d39d4 100644
--- a/ql/src/test/results/clientpositive/stats_invalidation.q.out
+++ b/ql/src/test/results/clientpositive/stats_invalidation.q.out
@@ -33,7 +33,6 @@ POSTHOOK: query: desc formatted stats_invalid
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_invalid
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
@@ -76,7 +75,6 @@ POSTHOOK: query: desc formatted stats_invalid
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_invalid
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
 new_col                string                                      

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats_list_bucket.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats_list_bucket.q.out 
b/ql/src/test/results/clientpositive/stats_list_bucket.q.out
index 0c43b1b..f6eb799 100644
--- a/ql/src/test/results/clientpositive/stats_list_bucket.q.out
+++ b/ql/src/test/results/clientpositive/stats_list_bucket.q.out
@@ -45,13 +45,11 @@ POSTHOOK: query: desc formatted stats_list_bucket partition 
(ds = '2008-04-08',
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_list_bucket
 # col_name             data_type               comment             
-                
 c1                     string                                      
 c2                     string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -122,7 +120,6 @@ POSTHOOK: query: desc formatted stats_list_bucket_1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_list_bucket_1
 # col_name             data_type               comment             
-                
 c1                     string                                      
 c2                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats_noscan_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats_noscan_1.q.out 
b/ql/src/test/results/clientpositive/stats_noscan_1.q.out
index ad2ca94..6d3f413 100644
--- a/ql/src/test/results/clientpositive/stats_noscan_1.q.out
+++ b/ql/src/test/results/clientpositive/stats_noscan_1.q.out
@@ -77,13 +77,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -115,13 +113,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-08',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -153,13 +149,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-09',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -190,13 +184,11 @@ POSTHOOK: query: describe formatted analyze_srcpart 
PARTITION(ds='2008-04-09',hr
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -227,13 +219,11 @@ POSTHOOK: query: describe formatted analyze_srcpart
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -340,13 +330,11 @@ POSTHOOK: query: describe formatted 
analyze_srcpart_partial PARTITION(ds='2008-0
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart_partial
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -378,13 +366,11 @@ POSTHOOK: query: describe formatted 
analyze_srcpart_partial PARTITION(ds='2008-0
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart_partial
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -416,13 +402,11 @@ POSTHOOK: query: describe formatted 
analyze_srcpart_partial PARTITION(ds='2008-0
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart_partial
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -453,13 +437,11 @@ POSTHOOK: query: describe formatted 
analyze_srcpart_partial PARTITION(ds='2008-0
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart_partial
 # col_name             data_type               comment             
-                
 key                    string                  default             
 value                  string                  default             
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats_noscan_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats_noscan_2.q.out 
b/ql/src/test/results/clientpositive/stats_noscan_2.q.out
index 1e9603e..14e131c 100644
--- a/ql/src/test/results/clientpositive/stats_noscan_2.q.out
+++ b/ql/src/test/results/clientpositive/stats_noscan_2.q.out
@@ -37,7 +37,6 @@ POSTHOOK: query: describe formatted anaylyze_external
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@anaylyze_external
 # col_name             data_type               comment             
-                
 a                      int                                         
                 
 # Detailed Table Information            
@@ -78,7 +77,6 @@ POSTHOOK: query: describe formatted anaylyze_external
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@anaylyze_external
 # col_name             data_type               comment             
-                
 a                      int                                         
                 
 # Detailed Table Information            
@@ -199,13 +197,11 @@ POSTHOOK: query: describe formatted anaylyze_external 
PARTITION (insertdate='200
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@anaylyze_external
 # col_name             data_type               comment             
-                
 key                    string                                      
 val                    string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 insertdate             string                                      
                 
 # Detailed Partition Information                
@@ -248,13 +244,11 @@ POSTHOOK: query: describe formatted anaylyze_external 
PARTITION (insertdate='200
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@anaylyze_external
 # col_name             data_type               comment             
-                
 key                    string                                      
 val                    string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 insertdate             string                                      
                 
 # Detailed Partition Information                

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats_only_null.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats_only_null.q.out 
b/ql/src/test/results/clientpositive/stats_only_null.q.out
index e7068d3..bcbc3f4 100644
--- a/ql/src/test/results/clientpositive/stats_only_null.q.out
+++ b/ql/src/test/results/clientpositive/stats_only_null.q.out
@@ -201,7 +201,6 @@ POSTHOOK: query: describe formatted stats_null_part 
partition (dt='2010')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_null_part
 # col_name             data_type               comment             
-                
 a                      double                                      
 b                      int                                         
 c                      string                                      
@@ -209,7 +208,6 @@ d                           smallint
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 dt                     string                                      
                 
 # Detailed Partition Information                
@@ -242,7 +240,6 @@ POSTHOOK: query: describe formatted stats_null_part 
partition (dt='2011')
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_null_part
 # col_name             data_type               comment             
-                
 a                      double                                      
 b                      int                                         
 c                      string                                      
@@ -250,7 +247,6 @@ d                           smallint
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 dt                     string                                      
                 
 # Detailed Partition Information                
@@ -377,9 +373,18 @@ PREHOOK: Input: default@stats_null_part
 POSTHOOK: query: describe formatted stats_null_part partition(dt = 1) a
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@stats_null_part
-# col_name             data_type               min                     max     
                num_nulls               distinct_count          avg_col_len     
        max_col_len             num_trues               num_falses              
comment                 bitVector           
-                                                                               
         
-a                      double                  1.0                     1.0     
                1                       1                                       
                                                                                
HL                      from deserializer   
+col_name               a                                                       
                                         
+data_type              double                                                  
                                         
+min                    1.0                                                     
                                         
+max                    1.0                                                     
                                         
+num_nulls              1                                                       
                                         
+distinct_count         1                                                       
                                         
+avg_col_len                                                                    
                                         
+max_col_len                                                                    
                                         
+num_trues                                                                      
                                         
+num_falses                                                                     
                                         
+bitVector              HL                                                      
                                         
+comment                from deserializer                                       
                                         
 PREHOOK: query: drop table stats_null
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@stats_null

http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out 
b/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out
index cf9867d..bc2fec5 100644
--- a/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out
+++ b/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out
@@ -44,13 +44,11 @@ POSTHOOK: query: describe formatted 
analyze_srcpart_partial_scan PARTITION(ds='2
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart_partial_scan
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -110,13 +108,11 @@ POSTHOOK: query: describe formatted 
analyze_srcpart_partial_scan PARTITION(ds='2
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart_partial_scan
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 
@@ -150,13 +146,11 @@ POSTHOOK: query: describe formatted 
analyze_srcpart_partial_scan PARTITION(ds='2
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@analyze_srcpart_partial_scan
 # col_name             data_type               comment             
-                
 key                    string                                      
 value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
-                
 ds                     string                                      
 hr                     string                                      
                 

Reply via email to