hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From amareshw...@apache.org
Subject svn commit: r1468783 [10/16] - in /hive/branches/HIVE-4115: ./ beeline/src/java/org/apache/hive/beeline/ beeline/src/test/org/ beeline/src/test/org/apache/ beeline/src/test/org/apache/hive/ beeline/src/test/org/apache/hive/beeline/ beeline/src/test/org...
Date Wed, 17 Apr 2013 07:29:46 GMT
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_or_replace_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_or_replace_view.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_or_replace_view.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_or_replace_view.q.out Wed Apr 17 07:29:38 2013
@@ -4,11 +4,9 @@ POSTHOOK: query: drop view v
 POSTHOOK: type: DROPVIEW
 PREHOOK: query: create view v as select * from srcpart
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: create view v as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@v
-#### A masked pattern was here ####
 PREHOOK: query: describe formatted v
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe formatted v
@@ -44,12 +42,10 @@ View Expanded Text: 	select `srcpart`.`k
 PREHOOK: query: -- modifying definition of unpartitioned view
 create or replace view v partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- modifying definition of unpartitioned view
 create or replace view v partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@v
-#### A masked pattern was here ####
 PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='11')
 PREHOOK: type: ALTERTABLE_ADDPARTS
 PREHOOK: Input: default@srcpart
@@ -132,12 +128,10 @@ ds=2008-04-08/hr=12
 PREHOOK: query: -- altering partitioned view 1
 create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- altering partitioned view 1
 create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@v
-#### A masked pattern was here ####
 PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@srcpart
@@ -197,12 +191,10 @@ ds=2008-04-08/hr=12
 PREHOOK: query: -- altering partitioned view 2
 create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- altering partitioned view 2
 create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@v
-#### A masked pattern was here ####
 PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@srcpart
@@ -277,11 +269,9 @@ POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@srcpart_temp
 PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@v
-#### A masked pattern was here ####
 PREHOOK: query: drop table srcpart_temp
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@srcpart_temp
@@ -293,12 +283,10 @@ POSTHOOK: Output: default@srcpart_temp
 PREHOOK: query: -- v is now invalid
 create or replace view v partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- v is now invalid
 create or replace view v partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@v
-#### A masked pattern was here ####
 PREHOOK: query: describe formatted v
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe formatted v

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view.q.out Wed Apr 17 07:29:38 2013
@@ -85,29 +85,23 @@ POSTHOOK: Input: default@src
 86	val_86
 PREHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view1
-#### A masked pattern was here ####
 PREHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view2
-#### A masked pattern was here ####
 PREHOOK: query: CREATE VIEW view3(valoo) 
 TBLPROPERTIES ("fear" = "factor")
 AS SELECT upper(value) FROM src WHERE key=86
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view3(valoo) 
 TBLPROPERTIES ("fear" = "factor")
 AS SELECT upper(value) FROM src WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view3
-#### A masked pattern was here ####
 PREHOOK: query: SELECT * from view1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
@@ -225,15 +219,11 @@ PREHOOK: query: DESCRIBE view1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 value               	string              	None                
 PREHOOK: query: DESCRIBE EXTENDED view1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 value               	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -270,16 +260,12 @@ PREHOOK: query: DESCRIBE view2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view2
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 PREHOOK: query: DESCRIBE EXTENDED view2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view2
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -318,15 +304,11 @@ PREHOOK: query: DESCRIBE view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view3
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 valoo               	string              	None                
 PREHOOK: query: DESCRIBE EXTENDED view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view3
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 valoo               	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -372,8 +354,6 @@ PREHOOK: query: DESCRIBE EXTENDED view3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED view3
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 valoo               	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -421,8 +401,6 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
 -- of comparison for view descriptions
 DESCRIBE EXTENDED table1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -430,8 +408,6 @@ PREHOOK: query: DESCRIBE EXTENDED src1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED src1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -444,8 +420,6 @@ POSTHOOK: query: -- use DESCRIBE EXTENDE
 -- view descriptions
 DESCRIBE EXTENDED table1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -470,11 +444,9 @@ POSTHOOK: Lineage: table1.key EXPRESSION
 86
 PREHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view4
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: SELECT * FROM view4
 PREHOOK: type: QUERY
@@ -493,8 +465,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view4
 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                
 PREHOOK: query: ALTER TABLE table1 ADD COLUMNS (value STRING)
 PREHOOK: type: ALTERTABLE_ADDCOLS
@@ -532,8 +502,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 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                
 value               	string              	None                
 PREHOOK: query: DESCRIBE view4
@@ -541,20 +509,16 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view4
 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                
 PREHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
 FROM view4 v1 join view4 v2
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@view4
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
 FROM view4 v1 join view4 v2
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@view4
 POSTHOOK: Output: default@view5
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: SELECT * FROM view5
 PREHOOK: type: QUERY
@@ -575,8 +539,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view5
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 key2                	int                 	None                
 PREHOOK: query: -- verify that column name and comment in DDL portion
@@ -584,22 +546,18 @@ PREHOOK: query: -- verify that column na
 CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
 SELECT upper(value) as blarg FROM src WHERE key=86
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- verify that column name and comment in DDL portion
 -- overrides column alias in SELECT
 CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
 SELECT upper(value) as blarg FROM src WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view6
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE view6
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view6
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 valoo               	string              	I cannot spell      
 PREHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
 CREATE VIEW view7 AS
@@ -608,7 +566,6 @@ WHERE key > 80 AND key < 100
 ORDER BY key, value
 LIMIT 10
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
 CREATE VIEW view7 AS
 SELECT * FROM src
@@ -617,7 +574,6 @@ ORDER BY key, value
 LIMIT 10
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view7
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: SELECT * FROM view7
 PREHOOK: type: QUERY
@@ -721,21 +677,17 @@ PREHOOK: query: CREATE VIEW view8(c) AS
 SELECT test_translate('abc', 'a', 'b')
 FROM table1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view8(c) AS
 SELECT test_translate('abc', 'a', 'b')
 FROM table1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view8
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view8
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 c                   	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -799,22 +751,18 @@ CREATE VIEW view9(m) AS
 SELECT test_max(length(value))
 FROM src
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- disable map-side aggregation
 CREATE VIEW view9(m) AS
 SELECT test_max(length(value))
 FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view9
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view9
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 m                   	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -878,22 +826,18 @@ CREATE VIEW view9(m) AS
 SELECT test_max(length(value))
 FROM src
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- enable map-side aggregation
 CREATE VIEW view9(m) AS
 SELECT test_max(length(value))
 FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view9
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view9
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 m                   	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -947,21 +891,17 @@ PREHOOK: query: -- test usage of a subse
 CREATE VIEW view10 AS
 SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test usage of a subselect within a view
 CREATE VIEW view10 AS
 SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view10
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view10
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -1022,21 +962,17 @@ PREHOOK: query: CREATE VIEW view11 AS
 SELECT test_explode(array(1,2,3)) AS (boom)
 FROM table1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view11 AS
 SELECT test_explode(array(1,2,3)) AS (boom)
 FROM table1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view11
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view11
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 boom                	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -1092,21 +1028,17 @@ PREHOOK: query: -- test usage of LATERAL
 CREATE VIEW view12 AS
 SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test usage of LATERAL within a view
 CREATE VIEW view12 AS
 SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view12
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view12
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 mycol               	int                 	None                
@@ -1179,22 +1111,18 @@ CREATE VIEW view13 AS
 SELECT s.key
 FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test usage of TABLESAMPLE within a view
 CREATE VIEW view13 AS
 SELECT s.key
 FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view13
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view13
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	int                 	None                
 	 	 
 #### A masked pattern was here ####
@@ -1270,7 +1198,6 @@ JOIN
       select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2
 ON (unionsrc1.key = unionsrc2.key)
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test usage of JOIN+UNION+AGG all within same view
 CREATE VIEW view14 AS
 SELECT unionsrc1.key as k1, unionsrc1.value as v1,
@@ -1285,15 +1212,12 @@ JOIN
 ON (unionsrc1.key = unionsrc2.key)
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view14
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view14
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 k1                  	string              	None                
 v1                  	string              	None                
 k2                  	string              	None                
@@ -1411,7 +1335,6 @@ SELECT key,COUNT(value) AS value_count
 FROM src
 GROUP BY key
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test usage of GROUP BY within view
 CREATE VIEW view15 AS
 SELECT key,COUNT(value) AS value_count
@@ -1419,15 +1342,12 @@ FROM src
 GROUP BY key
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view15
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view15
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value_count         	bigint              	None                
 	 	 
@@ -1501,22 +1421,18 @@ CREATE VIEW view16 AS
 SELECT DISTINCT value
 FROM src
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test usage of DISTINCT within view
 CREATE VIEW view16 AS
 SELECT DISTINCT value
 FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view16
-#### A masked pattern was here ####
 POSTHOOK: Lineage: table1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 PREHOOK: query: DESCRIBE EXTENDED view16
 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), ]
-# col_name            	data_type           	comment             
-	 	 
 value               	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -1595,8 +1511,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE view16
 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                
 PREHOOK: query: -- Likewise, DROP VIEW IF EXISTS should ignore a matching table name
 DROP VIEW IF EXISTS table1
@@ -1614,8 +1528,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE table1
 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                
 value               	string              	None                
 PREHOOK: query: -- this should work since currently we don't track view->table

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view_partitioned.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/create_view_partitioned.q.out Wed Apr 17 07:29:38 2013
@@ -19,7 +19,6 @@ SELECT key, value
 FROM src
 WHERE key=86
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test partitioned view definition
 -- (underlying table is not actually partitioned)
 CREATE VIEW vp1
@@ -30,13 +29,10 @@ FROM src
 WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@vp1
-#### A masked pattern was here ####
 PREHOOK: query: DESCRIBE EXTENDED vp1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED vp1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -234,7 +230,6 @@ CREATE VIEW vp2
 PARTITIONED ON (hr)
 AS SELECT * FROM srcpart WHERE key < 10
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test a partitioned view on top of an underlying partitioned table,
 -- but with only a suffix of the partitioning columns
 CREATE VIEW vp2
@@ -242,7 +237,6 @@ PARTITIONED ON (hr)
 AS SELECT * FROM srcpart WHERE key < 10
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@vp2
-#### A masked pattern was here ####
 PREHOOK: query: DESCRIBE FORMATTED vp2
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE FORMATTED vp2
@@ -340,7 +334,6 @@ SELECT key, value
 FROM src
 WHERE key=86
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- test a partitioned view where the PARTITIONED ON clause references
 -- an imposed column name
 CREATE VIEW vp3(k,v)
@@ -351,7 +344,6 @@ FROM src
 WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@vp3
-#### A masked pattern was here ####
 PREHOOK: query: DESCRIBE FORMATTED vp3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE FORMATTED vp3

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ctas.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ctas.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ctas.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ctas.q.out Wed Apr 17 07:29:38 2013
@@ -1,8 +1,8 @@
-PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20)
+PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
 
 create table nzhang_Tmp(a int, b string)
 PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20)
+POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
 
 create table nzhang_Tmp(a int, b string)
 POSTHOOK: type: CREATETABLE
@@ -827,8 +827,6 @@ STAGE PLANS:
               TotalFiles: 1
               GatherStats: false
               MultiFileSpray: false
-      Path -> Sorted Columns:
-#### A masked pattern was here ####
       Truncated Path -> Alias:
         /src [src]
 
@@ -893,8 +891,6 @@ STAGE PLANS:
               TotalFiles: 1
               GatherStats: true
               MultiFileSpray: false
-      Path -> Sorted Columns:
-#### A masked pattern was here ####
       Truncated Path -> Alias:
 #### A masked pattern was here ####
 

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database.q.out Wed Apr 17 07:29:38 2013
@@ -129,8 +129,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- DESCRIBE table in non-default DB
 DESCRIBE test_table
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 col1                	string              	None                
 PREHOOK: query: -- DESCRIBE EXTENDED in non-default DB
 DESCRIBE EXTENDED test_table
@@ -138,8 +136,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- DESCRIBE EXTENDED in non-default DB
 DESCRIBE EXTENDED test_table
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 col1                	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -160,8 +156,6 @@ PREHOOK: query: DESCRIBE EXTENDED test_t
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED test_table_like
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 col1                	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -1344,8 +1338,6 @@ POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: bucketized_src.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: bucketized_src.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: temp_tbl2.c EXPRESSION [(temp_tbl)temp_tbl.null, ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database_drop.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database_drop.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database_drop.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/database_drop.q.out Wed Apr 17 07:29:38 2013
@@ -40,11 +40,9 @@ POSTHOOK: type: LOAD
 POSTHOOK: Output: db5@temp_tbl
 PREHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db5@temp_tbl_view
-#### A masked pattern was here ####
 PREHOOK: query: CREATE INDEX idx1 ON TABLE temp_tbl(id) AS 'COMPACT' with DEFERRED REBUILD
 PREHOOK: type: CREATEINDEX
 POSTHOOK: query: CREATE INDEX idx1 ON TABLE temp_tbl(id) AS 'COMPACT' with DEFERRED REBUILD
@@ -82,11 +80,9 @@ POSTHOOK: Lineage: db5__temp_tbl_idx1__.
 POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]
 PREHOOK: query: CREATE VIEW temp_tbl2_view AS SELECT * FROM temp_tbl2
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW temp_tbl2_view AS SELECT * FROM temp_tbl2
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db5@temp_tbl2_view
-#### A masked pattern was here ####
 POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
 POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ]

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ddltime.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ddltime.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ddltime.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ddltime.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: desc extended T1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: desc extended T1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -29,8 +27,6 @@ POSTHOOK: query: desc extended T1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -55,8 +51,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
 POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -85,8 +79,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 	 	 
@@ -112,8 +104,6 @@ POSTHOOK: Lineage: t1.key SIMPLE [(src)s
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -154,8 +144,6 @@ POSTHOOK: Lineage: t1.value SIMPLE [(src
 POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -200,8 +188,6 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -250,8 +236,6 @@ POSTHOOK: Lineage: t2 PARTITION(ds=2010-
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_3.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_3.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_3.q.out Wed Apr 17 07:29:38 2013
@@ -27,8 +27,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_3
 #### A masked pattern was here ####
+NULL	0
+NULL	0
 -1234567890.123456789	-1234567890
--4.4E+3	4400
+-4400	4400
 -1255.49	-1255
 -1.122	-11
 -1.12	-1
@@ -38,7 +40,6 @@ POSTHOOK: Input: default@decimal_3
 -0.3	0
 0	0
 0	0
-1E-99	0
 0.01	0
 0.02	0
 0.1	0
@@ -57,14 +58,13 @@ POSTHOOK: Input: default@decimal_3
 3.14	3
 3.14	3
 3.14	4
-1E+1	10
-2E+1	20
-1E+2	100
+10	10
+20	20
+100	100
 124	124
 125.2	125
-2E+2	200
+200	200
 1234567890.12345678	1234567890
-1E+99	0
 PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key DESC, value DESC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_3
@@ -73,14 +73,13 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_3
 #### A masked pattern was here ####
-1E+99	0
 1234567890.12345678	1234567890
-2E+2	200
+200	200
 125.2	125
 124	124
-1E+2	100
-2E+1	20
-1E+1	10
+100	100
+20	20
+10	10
 3.14	4
 3.14	3
 3.14	3
@@ -99,7 +98,6 @@ POSTHOOK: Input: default@decimal_3
 0.1	0
 0.02	0
 0.01	0
-1E-99	0
 0	0
 0	0
 -0.3	0
@@ -109,8 +107,10 @@ POSTHOOK: Input: default@decimal_3
 -1.12	-1
 -1.122	-11
 -1255.49	-1255
--4.4E+3	4400
+-4400	4400
 -1234567890.123456789	-1234567890
+NULL	0
+NULL	0
 PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key, value
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_3
@@ -119,8 +119,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_3
 #### A masked pattern was here ####
+NULL	0
+NULL	0
 -1234567890.123456789	-1234567890
--4.4E+3	4400
+-4400	4400
 -1255.49	-1255
 -1.122	-11
 -1.12	-1
@@ -130,7 +132,6 @@ POSTHOOK: Input: default@decimal_3
 -0.3	0
 0	0
 0	0
-1E-99	0
 0.01	0
 0.02	0
 0.1	0
@@ -149,14 +150,13 @@ POSTHOOK: Input: default@decimal_3
 3.14	3
 3.14	3
 3.14	4
-1E+1	10
-2E+1	20
-1E+2	100
+10	10
+20	20
+100	100
 124	124
 125.2	125
-2E+2	200
+200	200
 1234567890.12345678	1234567890
-1E+99	0
 PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_3 ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_3
@@ -165,8 +165,9 @@ POSTHOOK: query: SELECT DISTINCT key FRO
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_3
 #### A masked pattern was here ####
+NULL
 -1234567890.123456789
--4.4E+3
+-4400
 -1255.49
 -1.122
 -1.12
@@ -174,7 +175,6 @@ POSTHOOK: Input: default@decimal_3
 -0.33
 -0.3
 0
-1E-99
 0.01
 0.02
 0.1
@@ -188,14 +188,13 @@ POSTHOOK: Input: default@decimal_3
 1.122
 2
 3.14
-1E+1
-2E+1
-1E+2
+10
+20
+100
 124
 125.2
-2E+2
+200
 1234567890.12345678
-1E+99
 PREHOOK: query: SELECT key, sum(value) FROM DECIMAL_3 GROUP BY key ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_3
@@ -204,8 +203,9 @@ POSTHOOK: query: SELECT key, sum(value) 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_3
 #### A masked pattern was here ####
+NULL	0
 -1234567890.123456789	-1234567890
--4.4E+3	4400
+-4400	4400
 -1255.49	-1255
 -1.122	-11
 -1.12	-2
@@ -213,7 +213,6 @@ POSTHOOK: Input: default@decimal_3
 -0.33	0
 -0.3	0
 0	0
-1E-99	0
 0.01	0
 0.02	0
 0.1	0
@@ -227,14 +226,13 @@ POSTHOOK: Input: default@decimal_3
 1.122	1
 2	4
 3.14	13
-1E+1	10
-2E+1	20
-1E+2	100
+10	10
+20	20
+100	100
 124	124
 125.2	125
-2E+2	200
+200	200
 1234567890.12345678	1234567890
-1E+99	0
 PREHOOK: query: SELECT value, sum(key) FROM DECIMAL_3 GROUP BY value ORDER BY value
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_3
@@ -247,18 +245,18 @@ POSTHOOK: Input: default@decimal_3
 -1255	-1255.49
 -11	-1.122
 -1	-2.24
-0	1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.330000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
+0	0.33
 1	5.2419999999999999999999999
 2	4
 3	9.42
 4	3.14
-10	1E+1
-20	2E+1
-100	1E+2
+10	10
+20	20
+100	100
 124	124
 125	125.2
-200	2E+2
-4400	-4.4E+3
+200	200
+4400	-4400
 1234567890	1234567890.12345678
 PREHOOK: query: SELECT * FROM DECIMAL_3 a JOIN DECIMAL_3 b ON (a.key = b.key) ORDER BY a.key, a.value, b.value
 PREHOOK: type: QUERY
@@ -269,7 +267,7 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_3
 #### A masked pattern was here ####
 -1234567890.123456789	-1234567890	-1234567890.123456789	-1234567890
--4.4E+3	4400	-4.4E+3	4400
+-4400	4400	-4400	4400
 -1255.49	-1255	-1255.49	-1255
 -1.122	-11	-1.122	-11
 -1.12	-1	-1.12	-1
@@ -283,7 +281,6 @@ POSTHOOK: Input: default@decimal_3
 0	0	0	0
 0	0	0	0
 0	0	0	0
-1E-99	0	1E-99	0
 0.01	0	0.01	0
 0.02	0	0.02	0
 0.1	0	0.1	0
@@ -318,14 +315,13 @@ POSTHOOK: Input: default@decimal_3
 3.14	4	3.14	3
 3.14	4	3.14	3
 3.14	4	3.14	4
-1E+1	10	1E+1	10
-2E+1	20	2E+1	20
-1E+2	100	1E+2	100
+10	10	10	10
+20	20	20	20
+100	100	100	100
 124	124	124	124
 125.2	125	125.2	125
-2E+2	200	2E+2	200
+200	200	200	200
 1234567890.12345678	1234567890	1234567890.12345678	1234567890
-1E+99	0	1E+99	0
 PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.14 ORDER BY key, value
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_3

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_serde.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_serde.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_serde.q.out Wed Apr 17 07:29:38 2013
@@ -39,8 +39,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_T
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_text
 #### A masked pattern was here ####
+NULL	0
+NULL	0
 -1234567890.123456789	-1234567890
--4.4E+3	4400
+-4400	4400
 -1255.49	-1255
 -1.122	-11
 -1.12	-1
@@ -50,7 +52,6 @@ POSTHOOK: Input: default@decimal_text
 -0.3	0
 0	0
 0	0
-1E-99	0
 0.01	0
 0.02	0
 0.1	0
@@ -69,14 +70,13 @@ POSTHOOK: Input: default@decimal_text
 3.14	3
 3.14	3
 3.14	4
-1E+1	10
-2E+1	20
-1E+2	100
+10	10
+20	20
+100	100
 124	124
 125.2	125
-2E+2	200
+200	200
 1234567890.12345678	1234567890
-1E+99	0
 PREHOOK: query: CREATE TABLE DECIMAL_RC
 STORED AS RCFile AS
 SELECT * FROM DECIMAL_TEXT
@@ -128,8 +128,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_S
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_sequence
 #### A masked pattern was here ####
+NULL	0
+NULL	0
 -1234567890.123456789	-1234567890
--4.4E+3	4400
+-4400	4400
 -1255.49	-1255
 -1.122	-11
 -1.12	-1
@@ -139,7 +141,6 @@ POSTHOOK: Input: default@decimal_sequenc
 -0.3	0
 0	0
 0	0
-1E-99	0
 0.01	0
 0.02	0
 0.1	0
@@ -158,14 +159,13 @@ POSTHOOK: Input: default@decimal_sequenc
 3.14	3
 3.14	3
 3.14	4
-1E+1	10
-2E+1	20
-1E+2	100
+10	10
+20	20
+100	100
 124	124
 125.2	125
-2E+2	200
+200	200
 1234567890.12345678	1234567890
-1E+99	0
 PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_TEXT
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@decimal_text

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/decimal_udf.q.out Wed Apr 17 07:29:38 2013
@@ -64,17 +64,17 @@ POSTHOOK: query: SELECT key + key FROM D
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--8.8E+3
-2E+99
-2E-99
+-8800
+NULL
+NULL
 0
-2E+2
-2E+1
+200
+20
 2
 0.2
 0.02
-4E+2
-4E+1
+400
+40
 4
 0
 0.4
@@ -146,16 +146,16 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 0
-1E+99
-1E-99
+NULL
+NULL
 0
-2E+2
-2E+1
+200
+20
 2
 0.1
 0.01
-4E+2
-4E+1
+400
+40
 4
 0
 0.2
@@ -226,17 +226,17 @@ POSTHOOK: query: SELECT key + (value/2) 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--2.2E+3
-1E+99
-1E-99
+-2200
+NULL
+NULL
 0
-1.5E+2
+150
 15
 1.5
 0.1
 0.01
-3E+2
-3E+1
+300
+30
 3
 0
 0.2
@@ -308,8 +308,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -4399
-1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
-1.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
+NULL
+NULL
 1
 101
 11
@@ -391,8 +391,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 0
-0
-0
+NULL
+NULL
 0
 0
 0
@@ -471,9 +471,9 @@ POSTHOOK: query: SELECT key - value FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--8.8E+3
-1E+99
-1E-99
+-8800
+NULL
+NULL
 0
 0
 0
@@ -506,7 +506,7 @@ POSTHOOK: Input: default@decimal_udf
 0.14
 0.14
 -0.86
--1E-25
+-0.0000000000000000000000001
 -0.123456789
 0.12345678
 PREHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF
@@ -552,17 +552,17 @@ POSTHOOK: query: SELECT key - (value/2) 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--6.6E+3
-1E+99
-1E-99
+-6600
+NULL
+NULL
 0
-5E+1
+50
 5
 0.5
 0.1
 0.01
-1E+2
-1E+1
+100
+10
 1
 0
 0.2
@@ -634,8 +634,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -4401
-999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
--0.999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
+NULL
+NULL
 -1
 99
 9
@@ -668,7 +668,7 @@ POSTHOOK: Input: default@decimal_udf
 2.14
 2.14
 2.14
--1E-25
+-0.0000000000000000000000001
 -1234567891.123456789
 1234567889.12345678
 PREHOOK: query: -- multiplication
@@ -716,17 +716,17 @@ POSTHOOK: query: SELECT key * key FROM D
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-1.936E+7
-1E+198
-1E-198
+19360000
+NULL
+NULL
 0
-1E+4
-1E+2
+10000
+100
 1
 0.01
 0.0001
-4E+4
-4E+2
+40000
+400
 4
 0
 0.04
@@ -751,7 +751,7 @@ POSTHOOK: Input: default@decimal_udf
 9.8596
 9.8596
 9.8596
-0.99999999999999999999999980000000000000000000000001
+NULL
 1524157875323883675.019051998750190521
 1524157875323883652.7968299765279684
 PREHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF
@@ -797,17 +797,17 @@ POSTHOOK: query: SELECT key * value FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--1.936E+7
-0
-0
+-19360000
+NULL
+NULL
 0
-1E+4
-1E+2
+10000
+100
 1
 0
 0
-4E+4
-4E+2
+40000
+400
 4
 0
 0
@@ -827,7 +827,7 @@ POSTHOOK: Input: default@decimal_udf
 1.12
 1.122
 15376
-1.565E+4
+15650
 1575639.95
 9.42
 9.42
@@ -878,17 +878,17 @@ POSTHOOK: query: SELECT key * (value/2) 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--9.68E+6
-0
-0
+-9680000
+NULL
+NULL
 0
-5E+3
-5E+1
+5000
+50
 0.5
 0
 0
-2E+4
-2E+2
+20000
+200
 2
 0
 0
@@ -959,17 +959,17 @@ POSTHOOK: query: SELECT key * '2.0' FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--8.8E+3
-2E+99
-2E-99
+-8800
+NULL
+NULL
 0
-2E+2
-2E+1
+200
+20
 2
 0.2
 0.02
-4E+2
-4E+1
+400
+40
 4
 0
 0.4
@@ -1170,8 +1170,6 @@ POSTHOOK: Input: default@decimal_udf
 1
 1
 1
-1
-1
 PREHOOK: query: EXPLAIN SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1228,7 +1226,7 @@ POSTHOOK: Input: default@decimal_udf
 1
 1
 1
-1.04666666666666666666666666666666666666666666666666666666666666667
+1.0466666666666666666666666666666666667
 1.12
 1.12
 0.102
@@ -1236,13 +1234,13 @@ POSTHOOK: Input: default@decimal_udf
 1.122
 1
 1.0016
-1.00039043824701195219123505976095617529880478087649402390438247012
-1.04666666666666666666666666666666666666666666666666666666666666667
-1.04666666666666666666666666666666666666666666666666666666666666667
+1.0003904382470119521912350597609561753
+1.0466666666666666666666666666666666667
+1.0466666666666666666666666666666666667
 0.785
 0.9999999999999999999999999
 1.0000000001
-1.00000000009999999270999993366099939631509450646736000885297608056
+1.0000000000999999927099999336609993963
 PREHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF  WHERE value is not null and value <> 0
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF  WHERE value is not null and value <> 0
@@ -1299,7 +1297,7 @@ POSTHOOK: Input: default@decimal_udf
 2
 2
 2
-2.09333333333333333333333333333333333333333333333333333333333333333
+2.0933333333333333333333333333333333333
 2.24
 2.24
 0.204
@@ -1307,13 +1305,13 @@ POSTHOOK: Input: default@decimal_udf
 2.244
 2
 2.0032
-2.00078087649402390438247011952191235059760956175298804780876494024
-2.09333333333333333333333333333333333333333333333333333333333333333
-2.09333333333333333333333333333333333333333333333333333333333333333
+2.0007808764940239043824701195219123506
+2.0933333333333333333333333333333333333
+2.0933333333333333333333333333333333333
 1.57
 1.9999999999999999999999998
 2.0000000002
-2.00000000019999998541999986732199879263018901293472001770595216112
+2.0000000001999999854199998673219987926
 PREHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
@@ -1357,17 +1355,17 @@ POSTHOOK: query: SELECT key / '2.0' FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--2.2E+3
-5E+98
-0
+-2200
+NULL
+NULL
 0
-5E+1
+50
 5
 0.5
 0.05
 0.005
-1E+2
-1E+1
+100
+10
 1
 0
 0.1
@@ -1440,17 +1438,17 @@ POSTHOOK: query: SELECT abs(key) FROM DE
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-4.4E+3
-1E+99
-1E-99
+4400
+NULL
+NULL
 0
-1E+2
-1E+1
+100
+10
 1
 0.1
 0.01
-2E+2
-2E+1
+200
+20
 2
 0
 0.2
@@ -1478,6 +1476,145 @@ POSTHOOK: Input: default@decimal_udf
 0.9999999999999999999999999
 1234567890.123456789
 1234567890.12345678
+PREHOOK: query: -- avg
+EXPLAIN SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
+PREHOOK: type: QUERY
+POSTHOOK: query: -- avg
+EXPLAIN SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (/ (TOK_FUNCTION sum (TOK_TABLE_OR_COL key)) (TOK_FUNCTION count (TOK_TABLE_OR_COL key)))) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_TABLE_OR_COL key)))) (TOK_GROUPBY (TOK_TABLE_OR_COL value)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value)))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        decimal_udf 
+          TableScan
+            alias: decimal_udf
+            Select Operator
+              expressions:
+                    expr: value
+                    type: int
+                    expr: key
+                    type: decimal
+              outputColumnNames: value, key
+              Group By Operator
+                aggregations:
+                      expr: sum(key)
+                      expr: count(key)
+                      expr: avg(key)
+                bucketGroup: false
+                keys:
+                      expr: value
+                      type: int
+                mode: hash
+                outputColumnNames: _col0, _col1, _col2, _col3
+                Reduce Output Operator
+                  key expressions:
+                        expr: _col0
+                        type: int
+                  sort order: +
+                  Map-reduce partition columns:
+                        expr: _col0
+                        type: int
+                  tag: -1
+                  value expressions:
+                        expr: _col1
+                        type: decimal
+                        expr: _col2
+                        type: bigint
+                        expr: _col3
+                        type: struct<count:bigint,sum:decimal>
+      Reduce Operator Tree:
+        Group By Operator
+          aggregations:
+                expr: sum(VALUE._col0)
+                expr: count(VALUE._col1)
+                expr: avg(VALUE._col2)
+          bucketGroup: false
+          keys:
+                expr: KEY._col0
+                type: int
+          mode: mergepartial
+          outputColumnNames: _col0, _col1, _col2, _col3
+          Select Operator
+            expressions:
+                  expr: _col0
+                  type: int
+                  expr: (_col1 / _col2)
+                  type: decimal
+                  expr: _col3
+                  type: decimal
+            outputColumnNames: _col0, _col1, _col2
+            File Output Operator
+              compressed: false
+              GlobalTableId: 0
+              table:
+                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+
+  Stage: Stage-2
+    Map Reduce
+      Alias -> Map Operator Tree:
+#### A masked pattern was here ####
+            Reduce Output Operator
+              key expressions:
+                    expr: _col0
+                    type: int
+              sort order: +
+              tag: -1
+              value expressions:
+                    expr: _col0
+                    type: int
+                    expr: _col1
+                    type: decimal
+                    expr: _col2
+                    type: decimal
+      Reduce Operator Tree:
+        Extract
+          File Output Operator
+            compressed: false
+            GlobalTableId: 0
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+PREHOOK: query: SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT value, sum(key) / count(key), avg(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+-1234567890	-1234567890.123456789	-1234567890.123456789
+-1255	-1255.49	-1255.49
+-11	-1.122	-1.122
+-1	-1.12	-1.12
+0	0.0275	0.0275
+1	1.04839999999999999999999998	1.04839999999999999999999998
+2	2	2
+3	3.14	3.14
+4	3.14	3.14
+10	10	10
+20	20	20
+100	100	100
+124	124	124
+125	125.2	125.2
+200	200	200
+4400	-4400	-4400
+1234567890	1234567890.12345678	1234567890.12345678
 PREHOOK: query: -- negative
 EXPLAIN SELECT -key FROM DECIMAL_UDF
 PREHOOK: type: QUERY
@@ -1523,17 +1660,17 @@ POSTHOOK: query: SELECT -key FROM DECIMA
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-4.4E+3
--1E+99
--1E-99
+4400
+NULL
+NULL
 0
--1E+2
--1E+1
+-100
+-10
 -1
 -0.1
 -0.01
--2E+2
--2E+1
+-200
+-20
 -2
 0
 -0.2
@@ -1606,17 +1743,17 @@ POSTHOOK: query: SELECT +key FROM DECIMA
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--4.4E+3
-1E+99
-1E-99
+-4400
+NULL
+NULL
 0
-1E+2
-1E+1
+100
+10
 1
 0.1
 0.01
-2E+2
-2E+1
+200
+20
 2
 0
 0.2
@@ -1689,17 +1826,17 @@ POSTHOOK: query: SELECT CEIL(key) FROM D
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--4.4E+3
-1E+99
-1
+-4400
+NULL
+NULL
 0
-1E+2
-1E+1
+100
+10
 1
 1
 1
-2E+2
-2E+1
+200
+20
 2
 0
 1
@@ -1725,7 +1862,7 @@ POSTHOOK: Input: default@decimal_udf
 4
 4
 1
--1.23456789E+9
+-1234567890
 1234567891
 PREHOOK: query: -- floor
 EXPLAIN SELECT FLOOR(key) FROM DECIMAL_UDF
@@ -1772,17 +1909,17 @@ POSTHOOK: query: SELECT FLOOR(key) FROM 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--4.4E+3
-1E+99
-0
+-4400
+NULL
+NULL
 0
-1E+2
-1E+1
+100
+10
 1
 0
 0
-2E+2
-2E+1
+200
+20
 2
 0
 0
@@ -1809,7 +1946,7 @@ POSTHOOK: Input: default@decimal_udf
 3
 0
 -1234567891
-1.23456789E+9
+1234567890
 PREHOOK: query: -- round
 EXPLAIN SELECT ROUND(key, 2) FROM DECIMAL_UDF
 PREHOOK: type: QUERY
@@ -1855,17 +1992,17 @@ POSTHOOK: query: SELECT ROUND(key, 2) FR
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--4.4E+3
-1E+99
-0
+-4400
+NULL
+NULL
 0
-1E+2
-1E+1
+100
+10
 1
 0.1
 0.01
-2E+2
-2E+1
+200
+20
 2
 0
 0.2
@@ -1938,17 +2075,17 @@ POSTHOOK: query: SELECT POWER(key, 2) FR
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-1.936E+7
-1E+198
-1E-198
+19360000
+NULL
+NULL
 0
-1E+4
-1E+2
+10000
+100
 1
 0.01
 0.0001
-4E+4
-4E+2
+40000
+400
 4
 0
 0.04
@@ -1973,7 +2110,7 @@ POSTHOOK: Input: default@decimal_udf
 9.8596
 9.8596
 9.8596
-0.99999999999999999999999980000000000000000000000001
+NULL
 1524157875323883675.019051998750190521
 1524157875323883652.7968299765279684
 PREHOOK: query: -- modulo
@@ -2022,7 +2159,7 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -2199
-1
+NULL
 NULL
 NULL
 1
@@ -2056,7 +2193,7 @@ NULL
 1
 1
 1
-1E-25
+0.0000000000000000000000001
 -617283944.0617283945
 1
 PREHOOK: query: -- stddev, var
@@ -2154,7 +2291,7 @@ POSTHOOK: Input: default@decimal_udf
 -1255	0.0	0.0
 -11	0.0	0.0
 -1	0.0	0.0
-0	2.5753937681885636E98	6.632653061224489E196
+0	0.23469892060538614	0.055083583333333345
 1	0.05928102563215321	0.0035142400000000066
 2	0.0	0.0
 3	0.0	0.0
@@ -2262,7 +2399,7 @@ POSTHOOK: Input: default@decimal_udf
 -1255	0.0	0.0
 -11	0.0	0.0
 -1	0.0	0.0
-0	2.6726124191242437E98	7.142857142857142E196
+0	0.24513502772590828	0.06009118181818183
 1	0.06627820154470102	0.004392800000000008
 2	0.0	0.0
 3	0.0	0.0
@@ -2344,7 +2481,217 @@ POSTHOOK: query: SELECT histogram_numeri
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-[{"x":-3.429369299009602E7,"y":36.0},{"x":1.2345678901234567E9,"y":1.0},{"x":1.0E99,"y":1.0}]
+[{"x":-1.2345678901234567E9,"y":1.0},{"x":-148.75058823529412,"y":34.0},{"x":1.2345678901234567E9,"y":1.0}]
+PREHOOK: query: -- min
+EXPLAIN SELECT MIN(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- min
+EXPLAIN SELECT MIN(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL key))))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        decimal_udf 
+          TableScan
+            alias: decimal_udf
+            Select Operator
+              expressions:
+                    expr: key
+                    type: decimal
+              outputColumnNames: key
+              Group By Operator
+                aggregations:
+                      expr: min(key)
+                bucketGroup: false
+                mode: hash
+                outputColumnNames: _col0
+                Reduce Output Operator
+                  sort order: 
+                  tag: -1
+                  value expressions:
+                        expr: _col0
+                        type: decimal
+      Reduce Operator Tree:
+        Group By Operator
+          aggregations:
+                expr: min(VALUE._col0)
+          bucketGroup: false
+          mode: mergepartial
+          outputColumnNames: _col0
+          Select Operator
+            expressions:
+                  expr: _col0
+                  type: decimal
+            outputColumnNames: _col0
+            File Output Operator
+              compressed: false
+              GlobalTableId: 0
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+PREHOOK: query: SELECT MIN(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT MIN(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+-1234567890.123456789
+PREHOOK: query: -- max
+EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- max
+EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL key))))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        decimal_udf 
+          TableScan
+            alias: decimal_udf
+            Select Operator
+              expressions:
+                    expr: key
+                    type: decimal
+              outputColumnNames: key
+              Group By Operator
+                aggregations:
+                      expr: max(key)
+                bucketGroup: false
+                mode: hash
+                outputColumnNames: _col0
+                Reduce Output Operator
+                  sort order: 
+                  tag: -1
+                  value expressions:
+                        expr: _col0
+                        type: decimal
+      Reduce Operator Tree:
+        Group By Operator
+          aggregations:
+                expr: max(VALUE._col0)
+          bucketGroup: false
+          mode: mergepartial
+          outputColumnNames: _col0
+          Select Operator
+            expressions:
+                  expr: _col0
+                  type: decimal
+            outputColumnNames: _col0
+            File Output Operator
+              compressed: false
+              GlobalTableId: 0
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+PREHOOK: query: SELECT MAX(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT MAX(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+1234567890.12345678
+PREHOOK: query: -- count
+EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+POSTHOOK: query: -- count
+EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME DECIMAL_UDF))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION COUNT (TOK_TABLE_OR_COL key))))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        decimal_udf 
+          TableScan
+            alias: decimal_udf
+            Select Operator
+              expressions:
+                    expr: key
+                    type: decimal
+              outputColumnNames: key
+              Group By Operator
+                aggregations:
+                      expr: count(key)
+                bucketGroup: false
+                mode: hash
+                outputColumnNames: _col0
+                Reduce Output Operator
+                  sort order: 
+                  tag: -1
+                  value expressions:
+                        expr: _col0
+                        type: bigint
+      Reduce Operator Tree:
+        Group By Operator
+          aggregations:
+                expr: count(VALUE._col0)
+          bucketGroup: false
+          mode: mergepartial
+          outputColumnNames: _col0
+          Select Operator
+            expressions:
+                  expr: _col0
+                  type: bigint
+            outputColumnNames: _col0
+            File Output Operator
+              compressed: false
+              GlobalTableId: 0
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+PREHOOK: query: SELECT COUNT(key) FROM DECIMAL_UDF
+PREHOOK: type: QUERY
+PREHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT COUNT(key) FROM DECIMAL_UDF
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@decimal_udf
+#### A masked pattern was here ####
+36
 PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_UDF
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@decimal_udf

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_comment_indent.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_comment_indent.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_comment_indent.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_comment_indent.q.out Wed Apr 17 07:29:38 2013
@@ -27,8 +27,6 @@ PREHOOK: query: DESCRIBE test_table
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE test_table
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 col1                	int                 	col1 one line comment
 col2                	string              	col2                
                     	                    	two lines comment

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out Wed Apr 17 07:29:38 2013
@@ -9,7 +9,6 @@ SELECT key, value
 FROM src
 WHERE key=86
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view_partitioned
 PARTITIONED ON (value)
 AS
@@ -18,7 +17,6 @@ FROM src
 WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view_partitioned
-#### A masked pattern was here ####
 PREHOOK: query: ALTER VIEW view_partitioned
 ADD PARTITION (value='val_86')
 PREHOOK: type: ALTERTABLE_ADDPARTS

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out Wed Apr 17 07:29:38 2013
@@ -9,7 +9,6 @@ SELECT key, value
 FROM src
 WHERE key=86
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: CREATE VIEW view_partitioned
 PARTITIONED ON (value)
 AS
@@ -18,7 +17,6 @@ FROM src
 WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@view_partitioned
-#### A masked pattern was here ####
 PREHOOK: query: ALTER VIEW view_partitioned
 ADD PARTITION (value='val_86')
 PREHOOK: type: ALTERTABLE_ADDPARTS

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_syntax.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_syntax.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_syntax.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_syntax.q.out Wed Apr 17 07:29:38 2013
@@ -38,8 +38,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- describe table
 DESCRIBE t1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 value1              	string              	None                
 ds                  	string              	None                
@@ -54,8 +52,6 @@ PREHOOK: query: DESCRIBE EXTENDED t1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED t1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 value1              	string              	None                
 ds                  	string              	None                
@@ -109,8 +105,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- describe database.table
 DESCRIBE db1.t1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 value1              	string              	None                
 ds                  	string              	None                
@@ -125,8 +119,6 @@ PREHOOK: query: DESCRIBE EXTENDED db1.t1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED db1.t1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 value1              	string              	None                
 ds                  	string              	None                
@@ -180,15 +172,11 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- describe table column
 DESCRIBE t1 key1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	from deserializer   
 PREHOOK: query: DESCRIBE EXTENDED t1 key1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED t1 key1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	from deserializer   
 PREHOOK: query: DESCRIBE FORMATTED t1 key1
 PREHOOK: type: DESCTABLE
@@ -203,15 +191,11 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- describe database.tabe column
 DESCRIBE db1.t1 key1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	from deserializer   
 PREHOOK: query: DESCRIBE EXTENDED db1.t1 key1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED db1.t1 key1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	from deserializer   
 PREHOOK: query: DESCRIBE FORMATTED db1.t1 key1
 PREHOOK: type: DESCTABLE
@@ -230,15 +214,11 @@ POSTHOOK: query: -- describe table.colum
 -- fall back to the old syntax table.column
 DESCRIBE t1.key1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	from deserializer   
 PREHOOK: query: DESCRIBE EXTENDED t1.key1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED t1.key1
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	from deserializer   
 PREHOOK: query: DESCRIBE FORMATTED t1.key1
 PREHOOK: type: DESCTABLE
@@ -253,8 +233,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- describe table partition
 DESCRIBE t1 PARTITION(ds='4', part='5')
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 value1              	string              	None                
 ds                  	string              	None                
@@ -269,8 +247,6 @@ PREHOOK: query: DESCRIBE EXTENDED t1 PAR
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED t1 PARTITION(ds='4', part='5')
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 value1              	string              	None                
 ds                  	string              	None                
@@ -324,8 +300,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- describe database.table partition
 DESCRIBE db1.t1 PARTITION(ds='4', part='5')
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 value1              	string              	None                
 ds                  	string              	None                
@@ -340,8 +314,6 @@ PREHOOK: query: DESCRIBE EXTENDED db1.t1
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED db1.t1 PARTITION(ds='4', part='5')
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key1                	int                 	None                
 value1              	string              	None                
 ds                  	string              	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_table.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_table.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_table.q.out Wed Apr 17 07:29:38 2013
@@ -2,8 +2,6 @@ PREHOOK: query: describe srcpart
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe srcpart
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -18,15 +16,11 @@ PREHOOK: query: describe srcpart.key
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe srcpart.key
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	from deserializer   
 PREHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12')
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12')
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -41,8 +35,6 @@ PREHOOK: query: describe extended srcpar
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe extended srcpart
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -59,15 +51,11 @@ PREHOOK: query: describe extended srcpar
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe extended srcpart.key
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	from deserializer   
 PREHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12')
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12')
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_xpath.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_xpath.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_xpath.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/describe_xpath.q.out Wed Apr 17 07:29:38 2013
@@ -4,8 +4,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- Describe a list structure in a thrift table
 describe src_thrift.lint
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 lint                	array<int>          	from deserializer   
 PREHOOK: query: -- Describe the element of a list
 describe src_thrift.lint.$elem$
@@ -13,8 +11,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- Describe the element of a list
 describe src_thrift.lint.$elem$
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 $elem$              	int                 	from deserializer   
 PREHOOK: query: -- Describe the key of a map
 describe src_thrift.mStringString.$key$
@@ -22,8 +18,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- Describe the key of a map
 describe src_thrift.mStringString.$key$
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 $key$               	string              	from deserializer   
 PREHOOK: query: -- Describe the value of a map
 describe src_thrift.mStringString.$value$
@@ -31,8 +25,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- Describe the value of a map
 describe src_thrift.mStringString.$value$
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 $value$             	string              	from deserializer   
 PREHOOK: query: -- Describe a complex element of a list
 describe src_thrift.lintString.$elem$
@@ -40,8 +32,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- Describe a complex element of a list
 describe src_thrift.lintString.$elem$
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 myint               	int                 	from deserializer   
 mystring            	string              	from deserializer   
 underscore_int      	int                 	from deserializer   
@@ -51,6 +41,4 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: -- Describe a member of an element of a list
 describe src_thrift.lintString.$elem$.myint
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 myint               	int                 	from deserializer   

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe ptestfilter
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	int                 	None                
 c                   	string              	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe ptestfilter
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	int                 	None                
 c                   	int                 	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe ptestfilter
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe ptestfilter
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	int                 	None                
 c                   	string              	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out Wed Apr 17 07:29:38 2013
@@ -23,8 +23,6 @@ PREHOOK: query: desc extended tbl_protec
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: desc extended tbl_protectmode_no_drop partition (p='p1')
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 c1                  	string              	None                
 c2                  	string              	None                
 p                   	string              	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_00_nonpart_empty.q.out Wed Apr 17 07:29:38 2013
@@ -41,8 +41,6 @@ PREHOOK: query: describe extended exim_d
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe extended exim_department
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 dep_id              	int                 	department id       
 	 	 
 #### A masked pattern was here ####

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_01_nonpart.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_01_nonpart.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_01_nonpart.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_01_nonpart.q.out Wed Apr 17 07:29:38 2013
@@ -47,8 +47,6 @@ PREHOOK: query: describe extended exim_d
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe extended exim_department
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 dep_id              	int                 	department id       
 	 	 
 #### A masked pattern was here ####

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out Wed Apr 17 07:29:38 2013
@@ -43,8 +43,6 @@ PREHOOK: query: describe extended exim_e
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe extended exim_employee
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 emp_id              	int                 	employee id         
 emp_country         	string              	two char iso code   
 emp_state           	string              	free text           

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_part.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_part.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/exim_02_part.q.out Wed Apr 17 07:29:38 2013
@@ -55,8 +55,6 @@ PREHOOK: query: describe extended exim_e
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe extended exim_employee
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 emp_id              	int                 	employee id         
 emp_country         	string              	two char iso code   
 emp_state           	string              	free text           



Mime
View raw message