hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject svn commit: r1536823 [4/8] - in /hive/branches/tez: ./ cli/src/test/org/apache/hadoop/hive/cli/ common/src/java/conf/ common/src/java/org/apache/hadoop/hive/common/ common/src/java/org/apache/hadoop/hive/common/type/ common/src/java/org/apache/hadoop/h...
Date Tue, 29 Oct 2013 17:25:59 GMT
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_precision.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_precision.q.out?rev=1536823&r1=1536822&r2=1536823&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_precision.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_precision.q.out Tue Oct 29 17:25:55 2013
@@ -2,12 +2,12 @@ PREHOOK: query: DROP TABLE IF EXISTS DEC
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_PRECISION
 POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal) 
+PREHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(60,30)) 
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
 PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal) 
+POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(60,30)) 
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
@@ -35,28 +35,42 @@ NULL
 NULL
 NULL
 NULL
--99999999999999999999999999999999999999
--999999999999999999999999999999999999
--99999999999999999999999999999999999
--0.0000000000000000000000000000000000001
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+0
+0
+0
+0
 0
-0.0000000000000000000000000000000000001
 0.123456789012345
-0.1234567890123456789012345678901234578
+0.12345678901234567890123456789
 1.234567890123456
-1.2345678901234567890123456789012345678
+1.234567890123456789012345678901
+1.234567890123456789012345678901
 12.34567890123456
-12.345678901234567890123456789012345678
+12.345678901234567890123456789012
+12.345678901234567890123456789012
 123.4567890123456
-123.45678901234567890123456789012345678
+123.456789012345678901234567890123
+123.456789012345678901234567890123
 1234.567890123456
-1234.5678901234567890123456789012345678
+1234.567890123456789012345678901235
+1234.567890123456789012345678901235
 12345.67890123456
-12345.678901234567890123456789012345678
+12345.678901234567890123456789012346
 123456.7890123456
-123456.78901234567890123456789012345678
+123456.789012345678901234567890123457
 1234567.890123456
-1234567.8901234567890123456789012345678
+1234567.890123456789012345678901234568
 12345678.90123456
 12345678.901234567890123456789012345678
 123456789.0123456
@@ -88,20 +102,6 @@ NULL
 1234567890123456789012345678.9012345678
 12345678901234567890123456789.012345678
 123456789012345678901234567890.12345678
-1234567890123456789012345678901.2345678
-12345678901234567890123456789012.345678
-123456789012345678901234567890123.45678
-1234567890123456789012345678901234.5678
-12345678901234567890123456789012345.678
-99999999999999999999999999999999999
-123456789012345678901234567890123456.78
-999999999999999999999999999999999999
-12345678901234567890123456789012345678
-12345678901234567890123456789012345678
-12345678901234567890123456789012345678
-12345678901234567890123456789012345678
-12345678901234567890123456789012345678
-99999999999999999999999999999999999999
 PREHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -118,28 +118,42 @@ NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
--99999999999999999999999999999999999999	-99999999999999999999999999999999999998	NULL
--999999999999999999999999999999999999	-999999999999999999999999999999999998	-1000000000000000000000000000000000000
--99999999999999999999999999999999999	-99999999999999999999999999999999998	-100000000000000000000000000000000000
--0.0000000000000000000000000000000000001	0.9999999999999999999999999999999999999	-1.0000000000000000000000000000000000001
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+0	1	-1
+0	1	-1
+0	1	-1
+0	1	-1
 0	1	-1
-0.0000000000000000000000000000000000001	1.0000000000000000000000000000000000001	-0.9999999999999999999999999999999999999
 0.123456789012345	1.123456789012345	-0.876543210987655
-0.1234567890123456789012345678901234578	1.1234567890123456789012345678901234578	-0.8765432109876543210987654321098765422
+0.12345678901234567890123456789	1.12345678901234567890123456789	-0.87654321098765432109876543211
 1.234567890123456	2.234567890123456	0.234567890123456
-1.2345678901234567890123456789012345678	2.2345678901234567890123456789012345678	0.2345678901234567890123456789012345678
+1.234567890123456789012345678901	2.234567890123456789012345678901	0.234567890123456789012345678901
+1.234567890123456789012345678901	2.234567890123456789012345678901	0.234567890123456789012345678901
 12.34567890123456	13.34567890123456	11.34567890123456
-12.345678901234567890123456789012345678	13.345678901234567890123456789012345678	11.345678901234567890123456789012345678
+12.345678901234567890123456789012	13.345678901234567890123456789012	11.345678901234567890123456789012
+12.345678901234567890123456789012	13.345678901234567890123456789012	11.345678901234567890123456789012
 123.4567890123456	124.4567890123456	122.4567890123456
-123.45678901234567890123456789012345678	124.45678901234567890123456789012345678	122.45678901234567890123456789012345678
+123.456789012345678901234567890123	124.456789012345678901234567890123	122.456789012345678901234567890123
+123.456789012345678901234567890123	124.456789012345678901234567890123	122.456789012345678901234567890123
 1234.567890123456	1235.567890123456	1233.567890123456
-1234.5678901234567890123456789012345678	1235.5678901234567890123456789012345678	1233.5678901234567890123456789012345678
+1234.567890123456789012345678901235	1235.567890123456789012345678901235	1233.567890123456789012345678901235
+1234.567890123456789012345678901235	1235.567890123456789012345678901235	1233.567890123456789012345678901235
 12345.67890123456	12346.67890123456	12344.67890123456
-12345.678901234567890123456789012345678	12346.678901234567890123456789012345678	12344.678901234567890123456789012345678
+12345.678901234567890123456789012346	12346.678901234567890123456789012346	12344.678901234567890123456789012346
 123456.7890123456	123457.7890123456	123455.7890123456
-123456.78901234567890123456789012345678	123457.78901234567890123456789012345678	123455.78901234567890123456789012345678
+123456.789012345678901234567890123457	123457.789012345678901234567890123457	123455.789012345678901234567890123457
 1234567.890123456	1234568.890123456	1234566.890123456
-1234567.8901234567890123456789012345678	1234568.8901234567890123456789012345678	1234566.8901234567890123456789012345678
+1234567.890123456789012345678901234568	1234568.890123456789012345678901234568	1234566.890123456789012345678901234568
 12345678.90123456	12345679.90123456	12345677.90123456
 12345678.901234567890123456789012345678	12345679.901234567890123456789012345678	12345677.901234567890123456789012345678
 123456789.0123456	123456790.0123456	123456788.0123456
@@ -171,20 +185,6 @@ NULL	NULL	NULL
 1234567890123456789012345678.9012345678	1234567890123456789012345679.9012345678	1234567890123456789012345677.9012345678
 12345678901234567890123456789.012345678	12345678901234567890123456790.012345678	12345678901234567890123456788.012345678
 123456789012345678901234567890.12345678	123456789012345678901234567891.12345678	123456789012345678901234567889.12345678
-1234567890123456789012345678901.2345678	1234567890123456789012345678902.2345678	1234567890123456789012345678900.2345678
-12345678901234567890123456789012.345678	12345678901234567890123456789013.345678	12345678901234567890123456789011.345678
-123456789012345678901234567890123.45678	123456789012345678901234567890124.45678	123456789012345678901234567890122.45678
-1234567890123456789012345678901234.5678	1234567890123456789012345678901235.5678	1234567890123456789012345678901233.5678
-12345678901234567890123456789012345.678	12345678901234567890123456789012346.678	12345678901234567890123456789012344.678
-99999999999999999999999999999999999	100000000000000000000000000000000000	99999999999999999999999999999999998
-123456789012345678901234567890123456.78	123456789012345678901234567890123457.78	123456789012345678901234567890123455.78
-999999999999999999999999999999999999	1000000000000000000000000000000000000	999999999999999999999999999999999998
-12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
-12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
-12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
-12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
-12345678901234567890123456789012345678	12345678901234567890123456789012345679	12345678901234567890123456789012345677
-99999999999999999999999999999999999999	NULL	99999999999999999999999999999999999998
 PREHOOK: query: SELECT dec, dec * 2, dec / 3  FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -201,28 +201,42 @@ NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
--99999999999999999999999999999999999999	NULL	-33333333333333333333333333333333333333
--999999999999999999999999999999999999	-1999999999999999999999999999999999998	-333333333333333333333333333333333333
--99999999999999999999999999999999999	-199999999999999999999999999999999998	-33333333333333333333333333333333333
--0.0000000000000000000000000000000000001	-0.0000000000000000000000000000000000002	0
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+NULL	NULL	NULL
+0	0	0
+0	0	0
+0	0	0
+0	0	0
 0	0	0
-0.0000000000000000000000000000000000001	0.0000000000000000000000000000000000002	0
 0.123456789012345	0.24691357802469	0.041152263004115
-0.1234567890123456789012345678901234578	0.2469135780246913578024691357802469156	0.0411522630041152263004115226300411526
+0.12345678901234567890123456789	0.24691357802469135780246913578	0.04115226300411522630041152263
 1.234567890123456	2.469135780246912	0.411522630041152
-1.2345678901234567890123456789012345678	2.4691357802469135780246913578024691356	0.4115226300411522630041152263004115226
+1.234567890123456789012345678901	2.469135780246913578024691357802	0.4115226300411522630041152263
+1.234567890123456789012345678901	2.469135780246913578024691357802	0.4115226300411522630041152263
 12.34567890123456	24.69135780246912	4.11522630041152
-12.345678901234567890123456789012345678	24.691357802469135780246913578024691356	4.115226300411522630041152263004115226
+12.345678901234567890123456789012	24.691357802469135780246913578024	4.115226300411522630041152263004
+12.345678901234567890123456789012	24.691357802469135780246913578024	4.115226300411522630041152263004
 123.4567890123456	246.9135780246912	41.1522630041152
-123.45678901234567890123456789012345678	246.91357802469135780246913578024691356	41.15226300411522630041152263004115226
+123.456789012345678901234567890123	246.913578024691357802469135780246	41.152263004115226300411522630041
+123.456789012345678901234567890123	246.913578024691357802469135780246	41.152263004115226300411522630041
 1234.567890123456	2469.135780246912	411.522630041152
-1234.5678901234567890123456789012345678	2469.1357802469135780246913578024691356	411.5226300411522630041152263004115226
+1234.567890123456789012345678901235	2469.13578024691357802469135780247	411.522630041152263004115226300412
+1234.567890123456789012345678901235	2469.13578024691357802469135780247	411.522630041152263004115226300412
 12345.67890123456	24691.35780246912	4115.22630041152
-12345.678901234567890123456789012345678	24691.357802469135780246913578024691356	4115.226300411522630041152263004115226
+12345.678901234567890123456789012346	24691.357802469135780246913578024692	4115.226300411522630041152263004115
 123456.7890123456	246913.5780246912	41152.2630041152
-123456.78901234567890123456789012345678	246913.57802469135780246913578024691356	41152.26300411522630041152263004115226
+123456.789012345678901234567890123457	246913.578024691357802469135780246914	41152.263004115226300411522630041152
 1234567.890123456	2469135.780246912	411522.630041152
-1234567.8901234567890123456789012345678	2469135.7802469135780246913578024691356	411522.6300411522630041152263004115226
+1234567.890123456789012345678901234568	2469135.780246913578024691357802469136	411522.630041152263004115226300411523
 12345678.90123456	24691357.80246912	4115226.30041152
 12345678.901234567890123456789012345678	24691357.802469135780246913578024691356	4115226.300411522630041152263004115226
 123456789.0123456	246913578.0246912	41152263.0041152
@@ -254,20 +268,6 @@ NULL	NULL	NULL
 1234567890123456789012345678.9012345678	2469135780246913578024691357.8024691356	411522630041152263004115226.3004115226
 12345678901234567890123456789.012345678	24691357802469135780246913578.024691356	4115226300411522630041152263.004115226
 123456789012345678901234567890.12345678	246913578024691357802469135780.24691356	41152263004115226300411522630.04115226
-1234567890123456789012345678901.2345678	2469135780246913578024691357802.4691356	411522630041152263004115226300.4115226
-12345678901234567890123456789012.345678	24691357802469135780246913578024.691356	4115226300411522630041152263004.115226
-123456789012345678901234567890123.45678	246913578024691357802469135780246.91356	41152263004115226300411522630041.15226
-1234567890123456789012345678901234.5678	2469135780246913578024691357802469.1356	411522630041152263004115226300411.5226
-12345678901234567890123456789012345.678	24691357802469135780246913578024691.356	4115226300411522630041152263004115.226
-99999999999999999999999999999999999	199999999999999999999999999999999998	33333333333333333333333333333333333
-123456789012345678901234567890123456.78	246913578024691357802469135780246913.56	41152263004115226300411522630041152.26
-999999999999999999999999999999999999	1999999999999999999999999999999999998	333333333333333333333333333333333333
-12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
-12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
-12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
-12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
-12345678901234567890123456789012345678	24691357802469135780246913578024691356	4115226300411522630041152263004115226
-99999999999999999999999999999999999999	NULL	33333333333333333333333333333333333333
 PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -284,43 +284,57 @@ NULL	NULL
 NULL	NULL
 NULL	NULL
 NULL	NULL
--99999999999999999999999999999999999999	-11111111111111111111111111111111111111
--999999999999999999999999999999999999	-111111111111111111111111111111111111
--99999999999999999999999999999999999	-11111111111111111111111111111111111
--0.0000000000000000000000000000000000001	0
-0	0
-0.0000000000000000000000000000000000001	0
-0.123456789012345	0.0137174210013716666666666666666666667
-0.1234567890123456789012345678901234578	0.0137174210013717421001371742100137175
-1.234567890123456	0.1371742100137173333333333333333333333
-1.2345678901234567890123456789012345678	0.1371742100137174210013717421001371742
-12.34567890123456	1.3717421001371733333333333333333333333
-12.345678901234567890123456789012345678	1.371742100137174210013717421001371742
-123.4567890123456	13.717421001371733333333333333333333333
-123.45678901234567890123456789012345678	13.71742100137174210013717421001371742
-1234.567890123456	137.17421001371733333333333333333333333
-1234.5678901234567890123456789012345678	137.1742100137174210013717421001371742
-12345.67890123456	1371.7421001371733333333333333333333333
-12345.678901234567890123456789012345678	1371.742100137174210013717421001371742
-123456.7890123456	13717.421001371733333333333333333333333
-123456.78901234567890123456789012345678	13717.42100137174210013717421001371742
-1234567.890123456	137174.21001371733333333333333333333333
-1234567.8901234567890123456789012345678	137174.2100137174210013717421001371742
-12345678.90123456	1371742.1001371733333333333333333333333
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+0	0
+0	0
+0	0
+0	0
+0	0
+0.123456789012345	0.013717421001371666666666666667
+0.12345678901234567890123456789	0.01371742100137174210013717421
+1.234567890123456	0.137174210013717333333333333333
+1.234567890123456789012345678901	0.1371742100137174210013717421
+1.234567890123456789012345678901	0.1371742100137174210013717421
+12.34567890123456	1.371742100137173333333333333333
+12.345678901234567890123456789012	1.371742100137174210013717421001
+12.345678901234567890123456789012	1.371742100137174210013717421001
+123.4567890123456	13.717421001371733333333333333333
+123.456789012345678901234567890123	13.717421001371742100137174210014
+123.456789012345678901234567890123	13.717421001371742100137174210014
+1234.567890123456	137.174210013717333333333333333333
+1234.567890123456789012345678901235	137.174210013717421001371742100137
+1234.567890123456789012345678901235	137.174210013717421001371742100137
+12345.67890123456	1371.742100137173333333333333333333
+12345.678901234567890123456789012346	1371.742100137174210013717421001372
+123456.7890123456	13717.421001371733333333333333333333
+123456.789012345678901234567890123457	13717.421001371742100137174210013717
+1234567.890123456	137174.210013717333333333333333333333
+1234567.890123456789012345678901234568	137174.210013717421001371742100137174
+12345678.90123456	1371742.100137173333333333333333333333
 12345678.901234567890123456789012345678	1371742.100137174210013717421001371742
 123456789.0123456	13717421.001371733333333333333333333333
 123456789.01234567890123456789012345678	13717421.00137174210013717421001371742
-1234567890.123456	137174210.01371733333333333333333333333
+1234567890.123456	137174210.013717333333333333333333333333
 1234567890.1234567890123456789012345678	137174210.0137174210013717421001371742
-12345678901.23456	1371742100.1371733333333333333333333333
+12345678901.23456	1371742100.137173333333333333333333333333
 12345678901.234567890123456789012345678	1371742100.137174210013717421001371742
-123456789012.3456	13717421001.371733333333333333333333333
+123456789012.3456	13717421001.371733333333333333333333333333
 123456789012.34567890123456789012345678	13717421001.37174210013717421001371742
-1234567890123.456	137174210013.71733333333333333333333333
+1234567890123.456	137174210013.717333333333333333333333333333
 1234567890123.4567890123456789012345678	137174210013.7174210013717421001371742
-12345678901234.56	1371742100137.1733333333333333333333333
+12345678901234.56	1371742100137.173333333333333333333333333333
 12345678901234.567890123456789012345678	1371742100137.174210013717421001371742
-123456789012345.6	13717421001371.733333333333333333333333
+123456789012345.6	13717421001371.733333333333333333333333333333
 123456789012345.67890123456789012345678	13717421001371.74210013717421001371742
 1234567890123456.7890123456789012345678	137174210013717.4210013717421001371742
 12345678901234567.890123456789012345678	1371742100137174.210013717421001371742
@@ -337,20 +351,6 @@ NULL	NULL
 1234567890123456789012345678.9012345678	137174210013717421001371742.1001371742
 12345678901234567890123456789.012345678	1371742100137174210013717421.001371742
 123456789012345678901234567890.12345678	13717421001371742100137174210.01371742
-1234567890123456789012345678901.2345678	137174210013717421001371742100.1371742
-12345678901234567890123456789012.345678	1371742100137174210013717421001.371742
-123456789012345678901234567890123.45678	13717421001371742100137174210013.71742
-1234567890123456789012345678901234.5678	137174210013717421001371742100137.1742
-12345678901234567890123456789012345.678	1371742100137174210013717421001371.742
-99999999999999999999999999999999999	11111111111111111111111111111111111
-123456789012345678901234567890123456.78	13717421001371742100137174210013717.42
-999999999999999999999999999999999999	111111111111111111111111111111111111
-12345678901234567890123456789012345678	1371742100137174210013717421001371742
-12345678901234567890123456789012345678	1371742100137174210013717421001371742
-12345678901234567890123456789012345678	1371742100137174210013717421001371742
-12345678901234567890123456789012345678	1371742100137174210013717421001371742
-12345678901234567890123456789012345678	1371742100137174210013717421001371742
-99999999999999999999999999999999999999	11111111111111111111111111111111111111
 PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -367,73 +367,73 @@ NULL	NULL
 NULL	NULL
 NULL	NULL
 NULL	NULL
--99999999999999999999999999999999999999	-3703703703703703703703703703703703703.7
--999999999999999999999999999999999999	-37037037037037037037037037037037037
--99999999999999999999999999999999999	-3703703703703703703703703703703703.6667
--0.0000000000000000000000000000000000001	0
-0	0
-0.0000000000000000000000000000000000001	0
-0.123456789012345	0.0045724736671238888888888888888888889
-0.1234567890123456789012345678901234578	0.0045724736671239140333790580700045725
-1.234567890123456	0.0457247366712391111111111111111111111
-1.2345678901234567890123456789012345678	0.0457247366712391403337905807000457247
-12.34567890123456	0.4572473667123911111111111111111111111
-12.345678901234567890123456789012345678	0.4572473667123914033379058070004572473
-123.4567890123456	4.5724736671239111111111111111111111111
-123.45678901234567890123456789012345678	4.5724736671239140333790580700045724733
-1234.567890123456	45.724736671239111111111111111111111111
-1234.5678901234567890123456789012345678	45.724736671239140333790580700045724733
-12345.67890123456	457.24736671239111111111111111111111111
-12345.678901234567890123456789012345678	457.24736671239140333790580700045724733
-123456.7890123456	4572.4736671239111111111111111111111111
-123456.78901234567890123456789012345678	4572.4736671239140333790580700045724733
-1234567.890123456	45724.736671239111111111111111111111111
-1234567.8901234567890123456789012345678	45724.736671239140333790580700045724733
-12345678.90123456	457247.36671239111111111111111111111111
-12345678.901234567890123456789012345678	457247.36671239140333790580700045724733
-123456789.0123456	4572473.6671239111111111111111111111111
-123456789.01234567890123456789012345678	4572473.6671239140333790580700045724733
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+0	0
+0	0
+0	0
+0	0
+0	0
+0.123456789012345	0.004572473667123888888888888889
+0.12345678901234567890123456789	0.00457247366712391403337905807
+1.234567890123456	0.045724736671239111111111111111
+1.234567890123456789012345678901	0.0457247366712391403337905807
+1.234567890123456789012345678901	0.0457247366712391403337905807
+12.34567890123456	0.457247366712391111111111111111
+12.345678901234567890123456789012	0.457247366712391403337905807
+12.345678901234567890123456789012	0.457247366712391403337905807
+123.4567890123456	4.572473667123911111111111111111
+123.456789012345678901234567890123	4.572473667123914033379058070005
+123.456789012345678901234567890123	4.572473667123914033379058070005
+1234.567890123456	45.724736671239111111111111111111
+1234.567890123456789012345678901235	45.724736671239140333790580700046
+1234.567890123456789012345678901235	45.724736671239140333790580700046
+12345.67890123456	457.247366712391111111111111111111
+12345.678901234567890123456789012346	457.247366712391403337905807000457
+123456.7890123456	4572.473667123911111111111111111111
+123456.789012345678901234567890123457	4572.473667123914033379058070004572
+1234567.890123456	45724.736671239111111111111111111111
+1234567.890123456789012345678901234568	45724.736671239140333790580700045725
+12345678.90123456	457247.366712391111111111111111111111
+12345678.901234567890123456789012345678	457247.366712391403337905807000457247
+123456789.0123456	4572473.667123911111111111111111111111
+123456789.01234567890123456789012345678	4572473.667123914033379058070004572473
 1234567890.123456	45724736.671239111111111111111111111111
 1234567890.1234567890123456789012345678	45724736.671239140333790580700045724733
-12345678901.23456	457247366.71239111111111111111111111111
-12345678901.234567890123456789012345678	457247366.71239140333790580700045724733
-123456789012.3456	4572473667.1239111111111111111111111111
-123456789012.34567890123456789012345678	4572473667.1239140333790580700045724733
-1234567890123.456	45724736671.239111111111111111111111111
-1234567890123.4567890123456789012345678	45724736671.239140333790580700045724733
-12345678901234.56	457247366712.39111111111111111111111111
-12345678901234.567890123456789012345678	457247366712.39140333790580700045724733
-123456789012345.6	4572473667123.9111111111111111111111111
-123456789012345.67890123456789012345678	4572473667123.9140333790580700045724733
-1234567890123456.7890123456789012345678	45724736671239.140333790580700045724733
-12345678901234567.890123456789012345678	457247366712391.40333790580700045724733
-123456789012345678.90123456789012345678	4572473667123914.0333790580700045724733
-1234567890123456789.0123456789012345678	45724736671239140.333790580700045724733
-12345678901234567890.123456789012345678	457247366712391403.33790580700045724733
-123456789012345678901.23456789012345678	4572473667123914033.3790580700045724733
-1234567890123456789012.3456789012345678	45724736671239140333.790580700045724733
-12345678901234567890123.456789012345678	457247366712391403337.90580700045724733
-123456789012345678901234.56789012345678	4572473667123914033379.0580700045724733
-1234567890123456789012345.6789012345678	45724736671239140333790.580700045724733
-12345678901234567890123456.789012345678	457247366712391403337905.80700045724733
-123456789012345678901234567.89012345678	4572473667123914033379058.0700045724733
-1234567890123456789012345678.9012345678	45724736671239140333790580.700045724733
-12345678901234567890123456789.012345678	457247366712391403337905807.00045724733
-123456789012345678901234567890.12345678	4572473667123914033379058070.0045724733
-1234567890123456789012345678901.2345678	45724736671239140333790580700.045724733
-12345678901234567890123456789012.345678	457247366712391403337905807000.45724733
-123456789012345678901234567890123.45678	4572473667123914033379058070004.5724733
-1234567890123456789012345678901234.5678	45724736671239140333790580700045.724733
-12345678901234567890123456789012345.678	457247366712391403337905807000457.24733
-99999999999999999999999999999999999	3703703703703703703703703703703703.6667
-123456789012345678901234567890123456.78	4572473667123914033379058070004572.4733
-999999999999999999999999999999999999	37037037037037037037037037037037037
-12345678901234567890123456789012345678	457247366712391403337905807000457247.33
-12345678901234567890123456789012345678	457247366712391403337905807000457247.33
-12345678901234567890123456789012345678	457247366712391403337905807000457247.33
-12345678901234567890123456789012345678	457247366712391403337905807000457247.33
-12345678901234567890123456789012345678	457247366712391403337905807000457247.33
-99999999999999999999999999999999999999	3703703703703703703703703703703703703.7
+12345678901.23456	457247366.712391111111111111111111111111
+12345678901.234567890123456789012345678	457247366.712391403337905807000457247333
+123456789012.3456	4572473667.123911111111111111111111111111
+123456789012.34567890123456789012345678	4572473667.123914033379058070004572473333
+1234567890123.456	45724736671.239111111111111111111111111111
+1234567890123.4567890123456789012345678	45724736671.239140333790580700045724733333
+12345678901234.56	457247366712.391111111111111111111111111111
+12345678901234.567890123456789012345678	457247366712.391403337905807000457247333333
+123456789012345.6	4572473667123.911111111111111111111111111111
+123456789012345.67890123456789012345678	4572473667123.914033379058070004572473333333
+1234567890123456.7890123456789012345678	45724736671239.140333790580700045724733333333
+12345678901234567.890123456789012345678	457247366712391.403337905807000457247333333333
+123456789012345678.90123456789012345678	4572473667123914.033379058070004572473333333333
+1234567890123456789.0123456789012345678	45724736671239140.333790580700045724733333333333
+12345678901234567890.123456789012345678	457247366712391403.337905807000457247333333333333
+123456789012345678901.23456789012345678	4572473667123914033.379058070004572473333333333333
+1234567890123456789012.3456789012345678	45724736671239140333.790580700045724733333333333333
+12345678901234567890123.456789012345678	457247366712391403337.905807000457247333333333333333
+123456789012345678901234.56789012345678	4572473667123914033379.058070004572473333333333333333
+1234567890123456789012345.6789012345678	45724736671239140333790.580700045724733333333333333333
+12345678901234567890123456.789012345678	457247366712391403337905.807000457247333333333333333333
+123456789012345678901234567.89012345678	4572473667123914033379058.070004572473333333333333333333
+1234567890123456789012345678.9012345678	45724736671239140333790580.700045724733333333333333333333
+12345678901234567890123456789.012345678	457247366712391403337905807.000457247333333333333333333333
+123456789012345678901234567890.12345678	4572473667123914033379058070.004572473333333333333333333333
 PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -450,28 +450,42 @@ NULL	NULL
 NULL	NULL
 NULL	NULL
 NULL	NULL
--99999999999999999999999999999999999999	NULL
--999999999999999999999999999999999999	NULL
--99999999999999999999999999999999999	NULL
--0.0000000000000000000000000000000000001	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+NULL	NULL
+0	0
+0	0
+0	0
+0	0
 0	0
-0.0000000000000000000000000000000000001	NULL
 0.123456789012345	0.015241578753238669120562399025
-0.1234567890123456789012345678901234578	NULL
+0.12345678901234567890123456789	NULL
 1.234567890123456	1.524157875323881726870921383936
-1.2345678901234567890123456789012345678	NULL
+1.234567890123456789012345678901	NULL
+1.234567890123456789012345678901	NULL
 12.34567890123456	152.4157875323881726870921383936
-12.345678901234567890123456789012345678	NULL
+12.345678901234567890123456789012	NULL
+12.345678901234567890123456789012	NULL
 123.4567890123456	15241.57875323881726870921383936
-123.45678901234567890123456789012345678	NULL
+123.456789012345678901234567890123	NULL
+123.456789012345678901234567890123	NULL
 1234.567890123456	1524157.875323881726870921383936
-1234.5678901234567890123456789012345678	NULL
+1234.567890123456789012345678901235	NULL
+1234.567890123456789012345678901235	NULL
 12345.67890123456	152415787.5323881726870921383936
-12345.678901234567890123456789012345678	NULL
+12345.678901234567890123456789012346	NULL
 123456.7890123456	15241578753.23881726870921383936
-123456.78901234567890123456789012345678	NULL
+123456.789012345678901234567890123457	NULL
 1234567.890123456	1524157875323.881726870921383936
-1234567.8901234567890123456789012345678	NULL
+1234567.890123456789012345678901234568	NULL
 12345678.90123456	152415787532388.1726870921383936
 12345678.901234567890123456789012345678	NULL
 123456789.0123456	15241578753238817.26870921383936
@@ -503,20 +517,6 @@ NULL	NULL
 1234567890123456789012345678.9012345678	NULL
 12345678901234567890123456789.012345678	NULL
 123456789012345678901234567890.12345678	NULL
-1234567890123456789012345678901.2345678	NULL
-12345678901234567890123456789012.345678	NULL
-123456789012345678901234567890123.45678	NULL
-1234567890123456789012345678901234.5678	NULL
-12345678901234567890123456789012345.678	NULL
-99999999999999999999999999999999999	NULL
-123456789012345678901234567890123456.78	NULL
-999999999999999999999999999999999999	NULL
-12345678901234567890123456789012345678	NULL
-12345678901234567890123456789012345678	NULL
-12345678901234567890123456789012345678	NULL
-12345678901234567890123456789012345678	NULL
-12345678901234567890123456789012345678	NULL
-99999999999999999999999999999999999999	NULL
 PREHOOK: query: SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -525,21 +525,21 @@ POSTHOOK: query: SELECT avg(dec), sum(de
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-NULL	NULL
-PREHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal) FROM DECIMAL_PRECISION LIMIT 1
+2449539464530670681706817092.661571403901626461618141287233	137174210013717558175581757189.047998618491081850615912085061
+PREHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal(39,9)) FROM DECIMAL_PRECISION LIMIT 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal) FROM DECIMAL_PRECISION LIMIT 1
+POSTHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal(39,9)) FROM DECIMAL_PRECISION LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
 NULL
-PREHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal) LIMIT 1
+PREHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal(39,9)) LIMIT 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal) LIMIT 1
+POSTHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal(39,9)) LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
@@ -552,24 +552,24 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
 NULL
-PREHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+PREHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+POSTHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-NULL
-PREHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+123456789012345678901234567890.123456789
+PREHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+POSTHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-0
+75
 PREHOOK: query: DROP TABLE DECIMAL_PRECISION
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@decimal_precision

Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out?rev=1536823&r1=1536822&r2=1536823&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out Tue Oct 29 17:25:55 2013
@@ -40,43 +40,43 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_text
 #### A masked pattern was here ####
 NULL	0
-NULL	0
--1234567890.123456789	-1234567890
+-1234567890	-1234567890
 -4400	4400
--1255.49	-1255
--1.122	-11
--1.12	-1
--1.12	-1
--0.333	0
--0.33	0
--0.3	0
-0	0
-0	0
-0.01	0
-0.02	0
-0.1	0
-0.2	0
-0.3	0
-0.33	0
-0.333	0
-0.9999999999999999999999999	1
+-1255	-1255
+-1	-11
+-1	-1
+-1	-1
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+1	1
+1	1
+1	1
 1	1
 1	1
-1.12	1
-1.122	1
 2	2
 2	2
-3.14	3
-3.14	3
-3.14	3
-3.14	4
+3	3
+3	3
+3	3
+3	4
 10	10
 20	20
 100	100
 124	124
-125.2	125
+125	125
 200	200
-1234567890.12345678	1234567890
+1234567890	1234567890
 PREHOOK: query: CREATE TABLE DECIMAL_RC
 STORED AS RCFile AS
 SELECT * FROM DECIMAL_TEXT
@@ -129,43 +129,43 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_sequence
 #### A masked pattern was here ####
 NULL	0
-NULL	0
--1234567890.123456789	-1234567890
+-1234567890	-1234567890
 -4400	4400
--1255.49	-1255
--1.122	-11
--1.12	-1
--1.12	-1
--0.333	0
--0.33	0
--0.3	0
-0	0
-0	0
-0.01	0
-0.02	0
-0.1	0
-0.2	0
-0.3	0
-0.33	0
-0.333	0
-0.9999999999999999999999999	1
+-1255	-1255
+-1	-11
+-1	-1
+-1	-1
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+0	0
+1	1
+1	1
+1	1
 1	1
 1	1
-1.12	1
-1.122	1
 2	2
 2	2
-3.14	3
-3.14	3
-3.14	3
-3.14	4
+3	3
+3	3
+3	3
+3	4
 10	10
 20	20
 100	100
 124	124
-125.2	125
+125	125
 200	200
-1234567890.12345678	1234567890
+1234567890	1234567890
 PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_TEXT
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@decimal_text

Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1536823&r1=1536822&r2=1536823&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_udf.q.out Tue Oct 29 17:25:55 2013
@@ -2,12 +2,12 @@ PREHOOK: query: DROP TABLE IF EXISTS DEC
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_UDF
 POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal, value int) 
+PREHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal(65,30), value int) 
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
 PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal, value int) 
+POSTHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal(65,30), value int) 
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
@@ -42,7 +42,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key + key)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -67,7 +67,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -8800
 NULL
-NULL
+0
 0
 200
 20
@@ -124,7 +124,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key + value)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -149,7 +149,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 0
 NULL
-NULL
+0
 0
 200
 20
@@ -206,7 +206,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key + (value / 2))
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -231,7 +231,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -2200
 NULL
-NULL
+0
 0
 150
 15
@@ -288,7 +288,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key + '1.0')
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -313,7 +313,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -4399
 NULL
-NULL
+1
 1
 101
 11
@@ -372,7 +372,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key - key)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -397,7 +397,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 0
 NULL
-NULL
+0
 0
 0
 0
@@ -454,7 +454,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key - value)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -479,7 +479,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -8800
 NULL
-NULL
+0
 0
 0
 0
@@ -536,7 +536,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key - (value / 2))
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -561,7 +561,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -6600
 NULL
-NULL
+0
 0
 50
 5
@@ -618,7 +618,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key - '1.0')
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -643,7 +643,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -4401
 NULL
-NULL
+-1
 -1
 99
 9
@@ -702,7 +702,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key * key)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -727,7 +727,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 19360000
 NULL
-NULL
+0
 0
 10000
 100
@@ -784,7 +784,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key * value)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -809,7 +809,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -19360000
 NULL
-NULL
+0
 0
 10000
 100
@@ -866,7 +866,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key * (value / 2))
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -891,7 +891,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -9680000
 NULL
-NULL
+0
 0
 5000
 50
@@ -948,7 +948,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key * '2.0')
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -973,7 +973,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -8800
 NULL
-NULL
+0
 0
 200
 20
@@ -1032,7 +1032,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key / 0)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               Limit
                 File Output Operator
@@ -1078,7 +1078,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key / null)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               Limit
                 File Output Operator
@@ -1128,7 +1128,7 @@ STAGE PLANS:
               Select Operator
                 expressions:
                       expr: (key / key)
-                      type: decimal
+                      type: decimal(65,30)
                 outputColumnNames: _col0
                 File Output Operator
                   compressed: false
@@ -1210,7 +1210,7 @@ STAGE PLANS:
               Select Operator
                 expressions:
                       expr: (key / value)
-                      type: decimal
+                      type: decimal(65,30)
                 outputColumnNames: _col0
                 File Output Operator
                   compressed: false
@@ -1242,7 +1242,7 @@ POSTHOOK: Input: default@decimal_udf
 1
 1
 1
-1.0466666666666666666666666666666666667
+1.046666666666666666666666666667
 1.12
 1.12
 0.102
@@ -1250,13 +1250,13 @@ POSTHOOK: Input: default@decimal_udf
 1.122
 1
 1.0016
-1.0003904382470119521912350597609561753
-1.0466666666666666666666666666666666667
-1.0466666666666666666666666666666666667
+1.000390438247011952191235059761
+1.046666666666666666666666666667
+1.046666666666666666666666666667
 0.785
 0.9999999999999999999999999
 1.0000000001
-1.0000000000999999927099999336609993963
+1.000000000099999992709999933661
 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
@@ -1282,7 +1282,7 @@ STAGE PLANS:
               Select Operator
                 expressions:
                       expr: (key / (value / 2))
-                      type: decimal
+                      type: decimal(65,30)
                 outputColumnNames: _col0
                 File Output Operator
                   compressed: false
@@ -1314,7 +1314,7 @@ POSTHOOK: Input: default@decimal_udf
 2
 2
 2
-2.0933333333333333333333333333333333333
+2.093333333333333333333333333333
 2.24
 2.24
 0.204
@@ -1322,13 +1322,13 @@ POSTHOOK: Input: default@decimal_udf
 2.244
 2
 2.0032
-2.0007808764940239043824701195219123506
-2.0933333333333333333333333333333333333
-2.0933333333333333333333333333333333333
+2.000780876494023904382470119522
+2.093333333333333333333333333333
+2.093333333333333333333333333333
 1.57
 1.9999999999999999999999998
 2.0000000002
-2.0000000001999999854199998673219987926
+2.000000000199999985419999867322
 PREHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
@@ -1350,7 +1350,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key / '2.0')
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -1375,7 +1375,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -2200
 NULL
-NULL
+0
 0
 50
 5
@@ -1434,7 +1434,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: abs(key)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -1459,7 +1459,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 4400
 NULL
-NULL
+0
 0
 100
 10
@@ -1521,7 +1521,7 @@ STAGE PLANS:
                     expr: value
                     type: int
                     expr: key
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: value, key
               Group By Operator
                 aggregations:
@@ -1545,11 +1545,11 @@ STAGE PLANS:
                   tag: -1
                   value expressions:
                         expr: _col1
-                        type: decimal
+                        type: decimal(65,30)
                         expr: _col2
                         type: bigint
                         expr: _col3
-                        type: struct<count:bigint,sum:decimal>
+                        type: struct<count:bigint,sum:decimal(65,30)>
       Reduce Operator Tree:
         Group By Operator
           aggregations:
@@ -1567,9 +1567,9 @@ STAGE PLANS:
                   expr: _col0
                   type: int
                   expr: (_col1 / _col2)
-                  type: decimal
+                  type: decimal(65,30)
                   expr: _col3
-                  type: decimal
+                  type: decimal(65,30)
             outputColumnNames: _col0, _col1, _col2
             File Output Operator
               compressed: false
@@ -1594,9 +1594,9 @@ STAGE PLANS:
                     expr: _col0
                     type: int
                     expr: _col1
-                    type: decimal
+                    type: decimal(65,30)
                     expr: _col2
-                    type: decimal
+                    type: decimal(65,30)
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -1624,7 +1624,7 @@ POSTHOOK: Input: default@decimal_udf
 -1255	-1255.49	-1255.49
 -11	-1.122	-1.122
 -1	-1.12	-1.12
-0	0.0275	0.0275
+0	0.025384615384615384615384615385	0.025384615384615384615384615385
 1	1.04839999999999999999999998	1.04839999999999999999999998
 2	2	2
 3	3.14	3.14
@@ -1660,7 +1660,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (- key)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -1685,7 +1685,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 4400
 NULL
-NULL
+0
 0
 -100
 -10
@@ -1744,7 +1744,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -1769,7 +1769,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -4400
 NULL
-NULL
+0
 0
 100
 10
@@ -1828,7 +1828,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: ceil(key)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -1853,7 +1853,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -4400
 NULL
-NULL
+0
 0
 100
 10
@@ -1912,7 +1912,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: floor(key)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -1937,7 +1937,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -4400
 NULL
-NULL
+0
 0
 100
 10
@@ -1996,7 +1996,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: round(key, 2)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -2021,7 +2021,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 -4400
 NULL
-NULL
+0
 0
 100
 10
@@ -2080,7 +2080,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: power(key, 2)
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -2105,7 +2105,7 @@ POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
 19360000
 NULL
-NULL
+0
 0
 10000
 100
@@ -2164,7 +2164,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: ((key + 1) % (key / 2))
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0
               File Output Operator
                 compressed: false
@@ -2250,7 +2250,7 @@ STAGE PLANS:
                     expr: value
                     type: int
                     expr: key
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: value, key
               Group By Operator
                 aggregations:
@@ -2321,7 +2321,7 @@ POSTHOOK: Input: default@decimal_udf
 -1255	0.0	0.0
 -11	0.0	0.0
 -1	0.0	0.0
-0	0.23469892060538614	0.055083583333333345
+0	0.22561046704494161	0.050900082840236685
 1	0.05928102563215321	0.0035142400000000066
 2	0.0	0.0
 3	0.0	0.0
@@ -2359,7 +2359,7 @@ STAGE PLANS:
                     expr: value
                     type: int
                     expr: key
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: value, key
               Group By Operator
                 aggregations:
@@ -2430,7 +2430,7 @@ POSTHOOK: Input: default@decimal_udf
 -1255	0.0	0.0
 -11	0.0	0.0
 -1	0.0	0.0
-0	0.24513502772590828	0.06009118181818183
+0	0.2348228191855647	0.055141756410256405
 1	0.06627820154470102	0.004392800000000008
 2	0.0	0.0
 3	0.0	0.0
@@ -2466,7 +2466,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: key
               Group By Operator
                 aggregations:
@@ -2513,7 +2513,7 @@ POSTHOOK: query: SELECT histogram_numeri
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-[{"x":-1.2345678901234567E9,"y":1.0},{"x":-148.75058823529412,"y":34.0},{"x":1.2345678901234567E9,"y":1.0}]
+[{"x":-1.2345678901234567E9,"y":1.0},{"x":-144.50057142857142,"y":35.0},{"x":1.2345678901234567E9,"y":1.0}]
 PREHOOK: query: -- min
 EXPLAIN SELECT MIN(key) FROM DECIMAL_UDF
 PREHOOK: type: QUERY
@@ -2537,7 +2537,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: key
               Group By Operator
                 aggregations:
@@ -2550,7 +2550,7 @@ STAGE PLANS:
                   tag: -1
                   value expressions:
                         expr: _col0
-                        type: decimal
+                        type: decimal(65,30)
       Reduce Operator Tree:
         Group By Operator
           aggregations:
@@ -2561,7 +2561,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: _col0
-                  type: decimal
+                  type: decimal(65,30)
             outputColumnNames: _col0
             File Output Operator
               compressed: false
@@ -2608,7 +2608,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: key
               Group By Operator
                 aggregations:
@@ -2621,7 +2621,7 @@ STAGE PLANS:
                   tag: -1
                   value expressions:
                         expr: _col0
-                        type: decimal
+                        type: decimal(65,30)
       Reduce Operator Tree:
         Group By Operator
           aggregations:
@@ -2632,7 +2632,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: _col0
-                  type: decimal
+                  type: decimal(65,30)
             outputColumnNames: _col0
             File Output Operator
               compressed: false
@@ -2679,7 +2679,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: key
               Group By Operator
                 aggregations:
@@ -2726,7 +2726,7 @@ POSTHOOK: query: SELECT COUNT(key) FROM 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-36
+37
 PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_UDF
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@decimal_udf

Modified: hive/branches/tez/ql/src/test/results/clientpositive/literal_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/literal_decimal.q.out?rev=1536823&r1=1536822&r2=1536823&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/literal_decimal.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/literal_decimal.q.out Tue Oct 29 17:25:55 2013
@@ -19,23 +19,23 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (- 1)
-                    type: decimal
+                    type: decimal(65,30)
                     expr: 0
-                    type: decimal
+                    type: decimal(65,30)
                     expr: 1
-                    type: decimal
+                    type: decimal(65,30)
                     expr: 3.14
-                    type: decimal
+                    type: decimal(65,30)
                     expr: (- 3.14)
-                    type: decimal
+                    type: decimal(65,30)
                     expr: 99999999999999999
-                    type: decimal
+                    type: decimal(65,30)
                     expr: 99999999999999999.9999999999999
-                    type: decimal
+                    type: decimal(65,30)
                     expr: 1E-99
-                    type: decimal
+                    type: decimal(65,30)
                     expr: 1E99
-                    type: decimal
+                    type: decimal(65,30)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
               Limit
                 File Output Operator
@@ -59,4 +59,4 @@ POSTHOOK: query: SELECT -1BD, 0BD, 1BD, 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
--1	0	1	3.14	-3.14	99999999999999999	99999999999999999.9999999999999	NULL	NULL
+-1	0	1	3.14	-3.14	99999999999999999	99999999999999999.9999999999999	0	NULL

Modified: hive/branches/tez/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out?rev=1536823&r1=1536822&r2=1536823&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out Tue Oct 29 17:25:55 2013
@@ -7,7 +7,7 @@ PREHOOK: query: CREATE TABLE orc_pred(t 
            bo boolean,
            s string,
            ts timestamp,
-           dec decimal,
+           dec decimal(4,2),
            bin binary)
 STORED AS ORC
 PREHOOK: type: CREATETABLE
@@ -20,7 +20,7 @@ POSTHOOK: query: CREATE TABLE orc_pred(t
            bo boolean,
            s string,
            ts timestamp,
-           dec decimal,
+           dec decimal(4,2),
            bin binary)
 STORED AS ORC
 POSTHOOK: type: CREATETABLE
@@ -42,7 +42,7 @@ PREHOOK: query: CREATE TABLE staging(t t
            bo boolean,
            s string,
            ts timestamp,
-           dec decimal,
+           dec decimal(4,2),
            bin binary)
 ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
 STORED AS TEXTFILE
@@ -56,7 +56,7 @@ POSTHOOK: query: CREATE TABLE staging(t 
            bo boolean,
            s string,
            ts timestamp,
-           dec decimal,
+           dec decimal(4,2),
            bin binary)
 ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
 STORED AS TEXTFILE
@@ -80,7 +80,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -103,7 +103,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -123,7 +123,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -139,7 +139,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -210,7 +210,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -299,7 +299,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -325,7 +325,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -347,7 +347,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -428,7 +428,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -518,7 +518,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -547,7 +547,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -572,7 +572,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -646,7 +646,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -729,7 +729,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -761,7 +761,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -789,7 +789,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -867,7 +867,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -960,7 +960,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -1000,7 +1000,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -1036,7 +1036,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -1129,7 +1129,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -1233,7 +1233,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -1275,7 +1275,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -1313,7 +1313,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]
@@ -1442,7 +1442,7 @@ POSTHOOK: Lineage: orc_pred.b SIMPLE [(s
 POSTHOOK: Lineage: orc_pred.bin SIMPLE [(staging)staging.FieldSchema(name:bin, type:binary, comment:null), ]
 POSTHOOK: Lineage: orc_pred.bo SIMPLE [(staging)staging.FieldSchema(name:bo, type:boolean, comment:null), ]
 POSTHOOK: Lineage: orc_pred.d SIMPLE [(staging)staging.FieldSchema(name:d, type:double, comment:null), ]
-POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal, comment:null), ]
+POSTHOOK: Lineage: orc_pred.dec SIMPLE [(staging)staging.FieldSchema(name:dec, type:decimal(4,2), comment:null), ]
 POSTHOOK: Lineage: orc_pred.f SIMPLE [(staging)staging.FieldSchema(name:f, type:float, comment:null), ]
 POSTHOOK: Lineage: orc_pred.i SIMPLE [(staging)staging.FieldSchema(name:i, type:int, comment:null), ]
 POSTHOOK: Lineage: orc_pred.s SIMPLE [(staging)staging.FieldSchema(name:s, type:string, comment:null), ]

Modified: hive/branches/tez/ql/src/test/results/clientpositive/ptf_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ptf_decimal.q.out?rev=1536823&r1=1536822&r2=1536823&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ptf_decimal.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ptf_decimal.q.out Tue Oct 29 17:25:55 2013
@@ -11,7 +11,7 @@ CREATE TABLE part( 
     p_type STRING,
     p_size INT,
     p_container STRING,
-    p_retailprice DECIMAL,
+    p_retailprice DECIMAL(6,2),
     p_comment STRING
 )
 PREHOOK: type: CREATETABLE
@@ -24,7 +24,7 @@ CREATE TABLE part( 
     p_type STRING,
     p_size INT,
     p_container STRING,
-    p_retailprice DECIMAL,
+    p_retailprice DECIMAL(6,2),
     p_comment STRING
 )
 POSTHOOK: type: CREATETABLE

Modified: hive/branches/tez/ql/src/test/results/clientpositive/serde_regex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/serde_regex.q.out?rev=1536823&r1=1536822&r2=1536823&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/serde_regex.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/serde_regex.q.out Tue Oct 29 17:25:55 2013
@@ -129,7 +129,7 @@ POSTHOOK: Input: default@serde_regex
 POSTHOOK: Output: default@serde_regex
 PREHOOK: query: EXPLAIN
 CREATE TABLE serde_regex1(
-  key decimal,
+  key decimal(65,30),
   value int)
 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
 WITH SERDEPROPERTIES (
@@ -139,7 +139,7 @@ STORED AS TEXTFILE
 PREHOOK: type: CREATETABLE
 POSTHOOK: query: EXPLAIN
 CREATE TABLE serde_regex1(
-  key decimal,
+  key decimal(65,30),
   value int)
 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
 WITH SERDEPROPERTIES (
@@ -148,7 +148,7 @@ WITH SERDEPROPERTIES (
 STORED AS TEXTFILE
 POSTHOOK: type: CREATETABLE
 ABSTRACT SYNTAX TREE:
-  (TOK_CREATETABLE (TOK_TABNAME serde_regex1) TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key TOK_DECIMAL) (TOK_TABCOL value TOK_INT)) (TOK_TABLESERIALIZER (TOK_SERDENAME 'org.apache.hadoop.hive.serde2.RegexSerDe' (TOK_TABLEPROPERTIES (TOK_TABLEPROPLIST (TOK_TABLEPROPERTY "input.regex" "([^ ]*) ([^ ]*)"))))) TOK_TBLTEXTFILE)
+  (TOK_CREATETABLE (TOK_TABNAME serde_regex1) TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key (TOK_DECIMAL 65 30)) (TOK_TABCOL value TOK_INT)) (TOK_TABLESERIALIZER (TOK_SERDENAME 'org.apache.hadoop.hive.serde2.RegexSerDe' (TOK_TABLEPROPERTIES (TOK_TABLEPROPLIST (TOK_TABLEPROPERTY "input.regex" "([^ ]*) ([^ ]*)"))))) TOK_TBLTEXTFILE)
 
 STAGE DEPENDENCIES:
   Stage-0 is a root stage
@@ -157,7 +157,7 @@ STAGE PLANS:
   Stage: Stage-0
       Create Table Operator:
         Create Table
-          columns: key decimal, value int
+          columns: key decimal(65,30), value int
           if not exists: false
           input format: org.apache.hadoop.mapred.TextInputFormat
           # buckets: -1
@@ -170,7 +170,7 @@ STAGE PLANS:
 
 
 PREHOOK: query: CREATE TABLE serde_regex1(
-  key decimal,
+  key decimal(65,30),
   value int)
 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
 WITH SERDEPROPERTIES (
@@ -179,7 +179,7 @@ WITH SERDEPROPERTIES (
 STORED AS TEXTFILE
 PREHOOK: type: CREATETABLE
 POSTHOOK: query: CREATE TABLE serde_regex1(
-  key decimal,
+  key decimal(65,30),
   value int)
 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
 WITH SERDEPROPERTIES (
@@ -203,7 +203,6 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@serde_regex1
 #### A masked pattern was here ####
 NULL	0
-NULL	0
 -1234567890.123456789	-1234567890
 -4400	4400
 -1255.49	-1255
@@ -215,6 +214,7 @@ NULL	0
 -0.3	0
 0	0
 0	0
+0	0
 0.01	0
 0.02	0
 0.1	0



Mime
View raw message