Modified: hive/trunk/ql/src/test/results/clientpositive/create_like.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like.q.out Fri Mar 21 
04:15:18 2014
@@ -11,8 +11,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -47,8 +47,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -91,8 +91,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out Fri Mar 21 
04:15:18 2014
@@ -32,8 +32,8 @@ POSTHOOK: query: DESC FORMATTED table2
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-a                      int                     None                
-b                      string                  None                
+a                      int                                         
+b                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: 
hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out 
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out 
Fri Mar 21 04:15:18 2014
@@ -188,8 +188,8 @@ POSTHOOK: query: DESC FORMATTED test_tab
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out 
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out Fri 
Mar 21 04:15:18 2014
@@ -25,16 +25,16 @@ PREHOOK: query: DESCRIBE table1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 POSTHOOK: type: DESCTABLE
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
 PREHOOK: query: DESCRIBE FORMATTED table1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE FORMATTED table1
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -74,16 +74,16 @@ PREHOOK: query: DESCRIBE table2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table2
 POSTHOOK: type: DESCTABLE
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
 PREHOOK: query: DESCRIBE FORMATTED table2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE FORMATTED table2
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -124,16 +124,16 @@ PREHOOK: query: DESCRIBE table3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table3
 POSTHOOK: type: DESCTABLE
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
 PREHOOK: query: DESCRIBE FORMATTED table3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE FORMATTED table3
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-a                      string                  None                
-b                      string                  None                
+a                      string                                      
+b                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -275,14 +275,14 @@ POSTHOOK: Lineage: table2.a SIMPLE [(src
 POSTHOOK: Lineage: table2.b SIMPLE [(src)src.FieldSchema(name:value, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-ds                     string                  None                
-hr                     string                  None                
+ds                     string                                      
+hr                     string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out 
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_nested_type.q.out Fri 
Mar 21 04:15:18 2014
@@ -19,18 +19,18 @@ PREHOOK: query: DESCRIBE table1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 POSTHOOK: type: DESCTABLE
-a                      string                  None                
-b                      array<string>           None                
-c                      array<map<string,string>>       None                
-d                      map<string,array<string>>       None                
+a                      string                                      
+b                      array<string>                               
+c                      array<map<string,string>>                           
+d                      map<string,array<string>>                           
 PREHOOK: query: DESCRIBE EXTENDED table1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED table1
 POSTHOOK: type: DESCTABLE
-a                      string                  None                
-b                      array<string>           None                
-c                      array<map<string,string>>       None                
-d                      map<string,array<string>>       None                
+a                      string                                      
+b                      array<string>                               
+c                      array<map<string,string>>                           
+d                      map<string,array<string>>                           
                 
 #### A masked pattern was here ####
 PREHOOK: query: LOAD DATA LOCAL INPATH 
'../../data/files/create_nested_type.txt' OVERWRITE INTO TABLE table1

Modified: 
hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out 
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out 
Fri Mar 21 04:15:18 2014
@@ -15,10 +15,10 @@ POSTHOOK: query: describe formatted v
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
-ds                     string                  None                
-hr                     string                  None                
+key                    string                                      
+value                  string                                      
+ds                     string                                      
+hr                     string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -97,14 +97,14 @@ POSTHOOK: query: describe formatted v
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-ds                     string                  None                
-hr                     string                  None                
+ds                     string                                      
+hr                     string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -163,13 +163,13 @@ POSTHOOK: query: describe formatted v
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-value                  string                  None                
+value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-ds                     string                  None                
-hr                     string                  None                
+ds                     string                                      
+hr                     string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -228,14 +228,14 @@ POSTHOOK: query: describe formatted v
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-ds                     string                  None                
-hr                     string                  None                
+ds                     string                                      
+hr                     string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -311,14 +311,14 @@ POSTHOOK: query: describe formatted v
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-ds                     string                  None                
-hr                     string                  None                
+ds                     string                                      
+hr                     string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: 
hive/trunk/ql/src/test/results/clientpositive/create_skewed_table1.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_skewed_table1.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_skewed_table1.q.out 
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_skewed_table1.q.out 
Fri Mar 21 04:15:18 2014
@@ -25,8 +25,8 @@ POSTHOOK: query: describe formatted list
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -56,8 +56,8 @@ POSTHOOK: query: describe formatted list
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -87,9 +87,9 @@ POSTHOOK: query: describe formatted list
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-col1                   string                  None                
-col2                   int                     None                
-col3                   string                  None                
+col1                   string                                      
+col2                   int                                         
+col3                   string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view.q.out Fri Mar 21 
04:15:18 2014
@@ -212,12 +212,12 @@ PREHOOK: query: DESCRIBE view1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view1
 POSTHOOK: type: DESCTABLE
-value                  string                  None                
+value                  string                                      
 PREHOOK: query: DESCRIBE EXTENDED view1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view1
 POSTHOOK: type: DESCTABLE
-value                  string                  None                
+value                  string                                      
                 
 #### A masked pattern was here ####
 PREHOOK: query: DESCRIBE FORMATTED view1
@@ -226,7 +226,7 @@ POSTHOOK: query: DESCRIBE FORMATTED view
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-value                  string                  None                
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -253,14 +253,14 @@ PREHOOK: query: DESCRIBE view2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view2
 POSTHOOK: type: DESCTABLE
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
 PREHOOK: query: DESCRIBE EXTENDED view2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view2
 POSTHOOK: type: DESCTABLE
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 #### A masked pattern was here ####
 PREHOOK: query: DESCRIBE FORMATTED view2
@@ -269,8 +269,8 @@ POSTHOOK: query: DESCRIBE FORMATTED view
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -297,12 +297,12 @@ PREHOOK: query: DESCRIBE view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view3
 POSTHOOK: type: DESCTABLE
-valoo                  string                  None                
+valoo                  string                                      
 PREHOOK: query: DESCRIBE EXTENDED view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view3
 POSTHOOK: type: DESCTABLE
-valoo                  string                  None                
+valoo                  string                                      
                 
 #### A masked pattern was here ####
 PREHOOK: query: DESCRIBE FORMATTED view3
@@ -311,7 +311,7 @@ POSTHOOK: query: DESCRIBE FORMATTED view
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-valoo                  string                  None                
+valoo                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -347,7 +347,7 @@ PREHOOK: query: DESCRIBE EXTENDED view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view3
 POSTHOOK: type: DESCTABLE
-valoo                  string                  None                
+valoo                  string                                      
                 
 #### A masked pattern was here ####
 PREHOOK: query: DESCRIBE FORMATTED view3
@@ -356,7 +356,7 @@ POSTHOOK: query: DESCRIBE FORMATTED view
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-valoo                  string                  None                
+valoo                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -396,7 +396,7 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
 -- of comparison for view descriptions
 DESCRIBE EXTENDED table1
 POSTHOOK: type: DESCTABLE
-key                    int                     None                
+key                    int                                         
                 
 #### A masked pattern was here ####
 PREHOOK: query: DESCRIBE EXTENDED src1
@@ -415,7 +415,7 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
 -- view descriptions
 DESCRIBE EXTENDED table1
 POSTHOOK: type: DESCTABLE
-key                    int                     None                
+key                    int                                         
                 
 #### A masked pattern was here ####
 PREHOOK: query: INSERT OVERWRITE TABLE table1 SELECT key FROM src WHERE key = 
86
@@ -462,7 +462,7 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key                    int                     None                
+key                    int                                         
 PREHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
 PREHOOK: type: ALTERTABLE_ADDCOLS
 PREHOOK: Input: default@table1
@@ -499,14 +499,14 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key                    int                     None                
-value                  string                  None                
+key                    int                                         
+value                  string                                      
 PREHOOK: query: DESCRIBE view4
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key                    int                     None                
+key                    int                                         
 PREHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
 FROM view4 v1 join view4 v2
 PREHOOK: type: CREATEVIEW
@@ -538,8 +538,8 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view5
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key1                   int                     None                
-key2                   int                     None                
+key1                   int                                         
+key2                   int                                         
 PREHOOK: query: -- verify that column name and comment in DDL portion
 -- overrides column alias in SELECT
 CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
@@ -695,7 +695,7 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view8
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-c                      string                  None                
+c                      string                                      
                 
 #### A masked pattern was here ####
 FROM table1, viewExpandedText:SELECT `_c0` AS `c` FROM (SELECT 
`test_translate`('abc', 'a', 'b')                
@@ -707,7 +707,7 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-c                      string                  None                
+c                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -774,7 +774,7 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view9
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-m                      int                     None                
+m                      int                                         
                 
 #### A masked pattern was here ####
 FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT 
`test_max`(length(`src`.`value`))           
@@ -786,7 +786,7 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-m                      int                     None                
+m                      int                                         
                 
 # Detailed Table Information            
 Database:              default                  
@@ -851,7 +851,7 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view9
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-m                      int                     None                
+m                      int                                         
                 
 #### A masked pattern was here ####
 FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT 
`test_max`(length(`src`.`value`))           
@@ -863,7 +863,7 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-m                      int                     None                
+m                      int                                         
                 
 # Detailed Table Information            
 Database:              default                  
@@ -917,8 +917,8 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view10
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 #### A masked pattern was here ####
 PREHOOK: query: DESCRIBE FORMATTED view10
@@ -928,8 +928,8 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -992,7 +992,7 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view11
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-boom                   int                     None                
+boom                   int                                         
                 
 #### A masked pattern was here ####
 FROM table1, viewExpandedText:SELECT `test_explode`(array(1,2,3)) AS (`boom`)  
         
@@ -1004,7 +1004,7 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-boom                   int                     None                
+boom                   int                                         
                 
 # Detailed Table Information            
 Database:              default                  
@@ -1060,9 +1060,9 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view12
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key                    string                  None                
-value                  string                  None                
-mycol                  int                     None                
+key                    string                                      
+value                  string                                      
+mycol                  int                                         
                 
 #### A masked pattern was here ####
 PREHOOK: query: DESCRIBE FORMATTED view12
@@ -1072,9 +1072,9 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
-mycol                  int                     None                
+key                    string                                      
+value                  string                                      
+mycol                  int                                         
                 
 # Detailed Table Information            
 Database:              default                  
@@ -1146,7 +1146,7 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view13
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key                    int                     None                
+key                    int                                         
                 
 #### A masked pattern was here ####
 FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s, 
viewExpandedText:SELECT `s`.`key`              
@@ -1158,7 +1158,7 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-key                    int                     None                
+key                    int                                         
                 
 # Detailed Table Information            
 Database:              default                  
@@ -1243,10 +1243,10 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view14
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-k1                     string                  None                
-v1                     string                  None                
-k2                     string                  None                
-v2                     string                  None                
+k1                     string                                      
+v1                     string                                      
+k2                     string                                      
+v2                     string                                      
                 
 #### A masked pattern was here ####
        unionsrc2.key as k2, unionsrc2.value as v2               
@@ -1274,10 +1274,10 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-k1                     string                  None                
-v1                     string                  None                
-k2                     string                  None                
-v2                     string                  None                
+k1                     string                                      
+v1                     string                                      
+k2                     string                                      
+v2                     string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -1375,8 +1375,8 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view15
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key                    string                  None                
-value_count            bigint                  None                
+key                    string                                      
+value_count            bigint                                      
                 
 #### A masked pattern was here ####
 FROM src                
@@ -1390,8 +1390,8 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value_count            bigint                  None                
+key                    string                                      
+value_count            bigint                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -1462,7 +1462,7 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view16
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-value                  string                  None                
+value                  string                                      
                 
 #### A masked pattern was here ####
 FROM src, viewExpandedText:SELECT DISTINCT `src`.`value`                
@@ -1474,7 +1474,7 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 # col_name             data_type               comment             
                 
-value                  string                  None                
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -1540,7 +1540,7 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view16
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-value                  string                  None                
+value                  string                                      
 PREHOOK: query: -- Likewise, DROP VIEW IF EXISTS should ignore a matching 
table name
 DROP VIEW IF EXISTS table1
 PREHOOK: type: DROPVIEW
@@ -1557,8 +1557,8 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
-key                    int                     None                
-value                  string                  None                
+key                    int                                         
+value                  string                                      
 PREHOOK: query: -- this should work since currently we don't track view->table
 -- dependencies for implementing RESTRICT
 

Modified: 
hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out 
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out 
Fri Mar 21 04:15:18 2014
@@ -35,13 +35,13 @@ PREHOOK: query: DESCRIBE EXTENDED vp1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED vp1
 POSTHOOK: type: DESCTABLE
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-value                  string                  None                
+value                  string                                      
                 
 #### A masked pattern was here ####
 FROM src                
@@ -54,12 +54,12 @@ POSTHOOK: query: DESCRIBE FORMATTED vp1
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
+key                    string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-value                  string                  None                
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -249,14 +249,14 @@ POSTHOOK: query: DESCRIBE FORMATTED vp2
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
-ds                     string                  None                
+key                    string                                      
+value                  string                                      
+ds                     string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-hr                     string                  None                
+hr                     string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -360,12 +360,12 @@ POSTHOOK: query: DESCRIBE FORMATTED vp3
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-k                      string                  None                
+k                      string                                      
                 
 # Partition Information                 
 # col_name             data_type               comment             
                 
-v                      string                  None                
+v                      string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: 
hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out 
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out 
Fri Mar 21 04:15:18 2014
@@ -19,7 +19,7 @@ POSTHOOK: query: describe formatted v
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
+key                    string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -59,8 +59,8 @@ POSTHOOK: query: describe formatted w
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: hive/trunk/ql/src/test/results/clientpositive/ctas.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas.q.out Fri Mar 21 
04:15:18 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_
 
 create table nzhang_Tmp(a int, b string)
 PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
 POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
 
 create table nzhang_Tmp(a int, b string)
 POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@nzhang_Tmp
 PREHOOK: query: select * from nzhang_Tmp
 PREHOOK: type: QUERY
@@ -127,8 +129,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-k                      string                  None                
-value                  string                  None                
+k                      string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -267,8 +269,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -408,8 +410,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-half_key               double                  None                
-conb                   string                  None                
+half_key               double                                      
+conb                   string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -471,8 +473,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-half_key               double                  None                
-conb                   string                  None                
+half_key               double                                      
+conb                   string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -612,8 +614,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -722,6 +724,7 @@ STAGE PLANS:
               COLUMN_STATS_ACCURATE true
               bucket_count -1
               columns key,value
+              columns.comments defaultdefault
               columns.types string:string
 #### A masked pattern was here ####
               name default.src
@@ -741,6 +744,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,value
+                columns.comments defaultdefault
                 columns.types string:string
 #### A masked pattern was here ####
                 name default.src
@@ -880,8 +884,10 @@ POSTHOOK: Input: default@src
 POSTHOOK: Output: default@nzhang_ctas5
 PREHOOK: query: create table nzhang_ctas6 (key string, `to` string)
 PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
 POSTHOOK: query: create table nzhang_ctas6 (key string, `to` string)
 POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@nzhang_ctas6
 PREHOOK: query: insert overwrite table nzhang_ctas6 select key, value from src 
tablesample (10 rows)
 PREHOOK: type: QUERY

Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out Fri Mar 21 
04:15:18 2014
@@ -87,10 +87,10 @@ POSTHOOK: query: describe formatted summ
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-_col0                  double                  None                
-_col1                  bigint                  None                
-_c1                    double                  None                
-_c2                    bigint                  None                
+_col0                  double                                      
+_col1                  bigint                                      
+_c1                    double                                      
+_c2                    bigint                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -201,9 +201,9 @@ POSTHOOK: query: describe formatted x4
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
-rr                     int                     None                
+key                    string                                      
+value                  string                                      
+rr                     int                                         
                 
 # Detailed Table Information            
 Database:              default                  
@@ -361,9 +361,9 @@ POSTHOOK: query: describe formatted x5
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
-lead1                  string                  None                
+key                    string                                      
+value                  string                                      
+lead1                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -501,8 +501,8 @@ POSTHOOK: query: describe formatted x6
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-_col0                  string                  None                
-_c1                    string                  None                
+_col0                  string                                      
+_c1                    string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -620,7 +620,7 @@ POSTHOOK: query: describe formatted x7
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-_col0                  string                  None                
+_col0                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -1049,7 +1049,7 @@ POSTHOOK: query: describe formatted x8
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-_col0                  string                  None                
+_col0                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -1180,8 +1180,8 @@ POSTHOOK: query: describe formatted x9
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-_c0                    string                  None                
-key                    string                  None                
+_c0                    string                                      
+key                    string                                      
                 
 # Detailed Table Information            
 Database:              default                  

Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out Fri Mar 
21 04:15:18 2014
@@ -129,8 +129,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-k                      string                  None                
-value                  string                  None                
+k                      string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -269,8 +269,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -410,8 +410,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-half_key               double                  None                
-conb                   string                  None                
+half_key               double                                      
+conb                   string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -473,8 +473,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-half_key               double                  None                
-conb                   string                  None                
+half_key               double                                      
+conb                   string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -614,8 +614,8 @@ POSTHOOK: query: describe formatted nzha
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              default                  
@@ -724,6 +724,7 @@ STAGE PLANS:
               COLUMN_STATS_ACCURATE true
               bucket_count -1
               columns key,value
+              columns.comments defaultdefault
               columns.types string:string
 #### A masked pattern was here ####
               name default.src
@@ -743,6 +744,7 @@ STAGE PLANS:
                 COLUMN_STATS_ACCURATE true
                 bucket_count -1
                 columns key,value
+                columns.comments defaultdefault
                 columns.types string:string
 #### A masked pattern was here ####
                 name default.src
@@ -921,7 +923,7 @@ POSTHOOK: query: desc nzhang_ctas8
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: nzhang_ctas6.key SIMPLE [(src)src.FieldSchema(name:key, 
type:string, comment:default), ]
 POSTHOOK: Lineage: nzhang_ctas6.to SIMPLE [(src)src.FieldSchema(name:value, 
type:string, comment:default), ]
-_c0                    decimal(3,2)            None                
+_c0                    decimal(3,2)                                
 PREHOOK: query: drop table nzhang_ctas8
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@nzhang_ctas8

Modified: 
hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- 
hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out 
(original)
+++ 
hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out 
Fri Mar 21 04:15:18 2014
@@ -122,8 +122,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 # Detailed Table Information            
 Database:              db1                      

Modified: 
hive/trunk/ql/src/test/results/clientpositive/custom_input_output_format.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/custom_input_output_format.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- 
hive/trunk/ql/src/test/results/clientpositive/custom_input_output_format.q.out 
(original)
+++ 
hive/trunk/ql/src/test/results/clientpositive/custom_input_output_format.q.out 
Fri Mar 21 04:15:18 2014
@@ -13,8 +13,8 @@ PREHOOK: query: DESCRIBE EXTENDED src1_r
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED src1_rot13_iof
 POSTHOOK: type: DESCTABLE
-key                    string                  None                
-value                  string                  None                
+key                    string                                      
+value                  string                                      
                 
 #### A masked pattern was here ####
 PREHOOK: query: SELECT * FROM src1 ORDER BY key, value

Modified: hive/trunk/ql/src/test/results/clientpositive/database.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/database.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/database.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/database.q.out Fri Mar 21 
04:15:18 2014
@@ -139,14 +139,14 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- DESCRIBE table in non-default DB
 DESCRIBE test_table
 POSTHOOK: type: DESCTABLE
-col1                   string                  None                
+col1                   string                                      
 PREHOOK: query: -- DESCRIBE EXTENDED in non-default DB
 DESCRIBE EXTENDED test_table
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- DESCRIBE EXTENDED in non-default DB
 DESCRIBE EXTENDED test_table
 POSTHOOK: type: DESCTABLE
-col1                   string                  None                
+col1                   string                                      
                 
 #### A masked pattern was here ####
 PREHOOK: query: -- CREATE LIKE in non-default DB
@@ -168,7 +168,7 @@ PREHOOK: query: DESCRIBE EXTENDED test_t
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED test_table_like
 POSTHOOK: type: DESCTABLE
-col1                   string                  None                
+col1                   string                                      
                 
 #### A masked pattern was here ####
 PREHOOK: query: -- LOAD and SELECT

Modified: hive/trunk/ql/src/test/results/clientpositive/database_location.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/database_location.q.out?rev=1579876&r1=1579875&r2=1579876&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/database_location.q.out 
(original)
+++ hive/trunk/ql/src/test/results/clientpositive/database_location.q.out Fri 
Mar 21 04:15:18 2014
@@ -24,8 +24,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-name                   string                  None                
-value                  int                     None                
+name                   string                                      
+value                  int                                         
                 
 # Detailed Table Information            
 Database:              db1                      
@@ -84,8 +84,8 @@ POSTHOOK: query: DESCRIBE FORMATTED tabl
 POSTHOOK: type: DESCTABLE
 # col_name             data_type               comment             
                 
-name                   string                  None                
-value                  int                     None                
+name                   string                                      
+value                  int                                         
                 
 # Detailed Table Information            
 Database:              db2                      


Reply via email to