hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject svn commit: r1545564 [9/22] - in /hive/branches/tez: ./ ant/ beeline/ bin/ cli/ common/ common/src/java/org/apache/hadoop/hive/common/ common/src/java/org/apache/hadoop/hive/common/type/ common/src/java/org/apache/hadoop/hive/conf/ common/src/test/org/...
Date Tue, 26 Nov 2013 08:19:34 GMT
Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_1.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_1.q.out Tue Nov 26 08:19:25 2013
@@ -1,10 +1,10 @@
-PREHOOK: query: drop table decimal_1
+PREHOOK: query: drop table if exists decimal_1
 PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table decimal_1
+POSTHOOK: query: drop table if exists decimal_1
 POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table decimal_1 (t decimal(4,2))
+PREHOOK: query: create table decimal_1 (t decimal(4,2), u decimal(5), v decimal)
 PREHOOK: type: CREATETABLE
-POSTHOOK: query: create table decimal_1 (t decimal(4,2))
+POSTHOOK: query: create table decimal_1 (t decimal(4,2), u decimal(5), v decimal)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@decimal_1
 PREHOOK: query: alter table decimal_1 set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
@@ -15,17 +15,26 @@ POSTHOOK: query: alter table decimal_1 s
 POSTHOOK: type: ALTERTABLE_SERIALIZER
 POSTHOOK: Input: default@decimal_1
 POSTHOOK: Output: default@decimal_1
+PREHOOK: query: desc decimal_1
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc decimal_1
+POSTHOOK: type: DESCTABLE
+t                   	decimal(4,2)        	from deserializer   
+u                   	decimal(5,0)        	from deserializer   
+v                   	decimal(10,0)       	from deserializer   
 PREHOOK: query: insert overwrite table decimal_1
-  select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
+  select cast('17.29' as decimal(4,2)), 3.1415926BD, 3115926.54321BD from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@decimal_1
 POSTHOOK: query: insert overwrite table decimal_1
-  select cast('17.29' as decimal(4,2)) from src tablesample (1 rows)
+  select cast('17.29' as decimal(4,2)), 3.1415926BD, 3115926.54321BD from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@decimal_1
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 PREHOOK: query: select cast(t as boolean) from decimal_1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_1
@@ -35,6 +44,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 true
 PREHOOK: query: select cast(t as tinyint) from decimal_1
 PREHOOK: type: QUERY
@@ -45,6 +56,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 17
 PREHOOK: query: select cast(t as smallint) from decimal_1
 PREHOOK: type: QUERY
@@ -55,6 +68,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 17
 PREHOOK: query: select cast(t as int) from decimal_1
 PREHOOK: type: QUERY
@@ -65,6 +80,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 17
 PREHOOK: query: select cast(t as bigint) from decimal_1
 PREHOOK: type: QUERY
@@ -75,6 +92,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 17
 PREHOOK: query: select cast(t as float) from decimal_1
 PREHOOK: type: QUERY
@@ -85,6 +104,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 17.29
 PREHOOK: query: select cast(t as double) from decimal_1
 PREHOOK: type: QUERY
@@ -95,6 +116,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 17.29
 PREHOOK: query: select cast(t as string) from decimal_1
 PREHOOK: type: QUERY
@@ -105,6 +128,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 17.29
 PREHOOK: query: select cast(t as timestamp) from decimal_1
 PREHOOK: type: QUERY
@@ -115,6 +140,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []
 1969-12-31 16:00:17.29
 PREHOOK: query: drop table decimal_1
 PREHOOK: type: DROPTABLE
@@ -125,3 +152,5 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@decimal_1
 POSTHOOK: Output: default@decimal_1
 POSTHOOK: Lineage: decimal_1.t EXPRESSION []
+POSTHOOK: Lineage: decimal_1.u EXPRESSION []
+POSTHOOK: Lineage: decimal_1.v EXPRESSION []

Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_3.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_3.q.out Tue Nov 26 08:19:25 2013
@@ -2,12 +2,12 @@ PREHOOK: query: DROP TABLE IF EXISTS DEC
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_3
 POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE DECIMAL_3(key decimal(65,30), value int) 
+PREHOOK: query: CREATE TABLE DECIMAL_3(key decimal(38,18), value int)
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
 PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_3(key decimal(65,30), value int) 
+POSTHOOK: query: CREATE TABLE DECIMAL_3(key decimal(38,18), value int)
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
@@ -47,7 +47,7 @@ NULL	0
 0.3	0
 0.33	0
 0.333	0
-0.9999999999999999999999999	1
+1	1
 1	1
 1	1
 1.12	1
@@ -90,7 +90,7 @@ POSTHOOK: Input: default@decimal_3
 1.12	1
 1	1
 1	1
-0.9999999999999999999999999	1
+1	1
 0.333	0
 0.33	0
 0.3	0
@@ -139,7 +139,7 @@ NULL	0
 0.3	0
 0.33	0
 0.333	0
-0.9999999999999999999999999	1
+1	1
 1	1
 1	1
 1.12	1
@@ -182,7 +182,6 @@ NULL
 0.3
 0.33
 0.333
-0.9999999999999999999999999
 1
 1.12
 1.122
@@ -220,8 +219,7 @@ NULL	0
 0.3	0
 0.33	0
 0.333	0
-0.9999999999999999999999999	1
-1	2
+1	3
 1.12	1
 1.122	1
 2	4
@@ -246,7 +244,7 @@ POSTHOOK: Input: default@decimal_3
 -11	-1.122
 -1	-2.24
 0	0.33
-1	5.2419999999999999999999999
+1	5.242
 2	4
 3	9.42
 4	3.14
@@ -293,7 +291,11 @@ POSTHOOK: Input: default@decimal_3
 0.3	0	0.3	0
 0.33	0	0.33	0
 0.333	0	0.333	0
-0.9999999999999999999999999	1	0.9999999999999999999999999	1
+1	1	1	1
+1	1	1	1
+1	1	1	1
+1	1	1	1
+1	1	1	1
 1	1	1	1
 1	1	1	1
 1	1	1	1

Modified: hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out Tue Nov 26 08:19:25 2013
@@ -127,5 +127,5 @@ PREHOOK: query: desc DECIMAL_6_3
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: desc DECIMAL_6_3
 POSTHOOK: type: DESCTABLE
-k                   	decimal(65,30)      	None                
+k                   	double              	None                
 v                   	int                 	None                

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=1545564&r1=1545563&r2=1545564&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 Nov 26 08:19:25 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(60,30)) 
+PREHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(38,18))
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
 PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(60,30)) 
+POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(38,18))
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
@@ -46,62 +46,62 @@ NULL
 NULL
 NULL
 NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
 0
 0
 0
 0
 0
 0.123456789012345
-0.12345678901234567890123456789
+0.123456789012345679
 1.234567890123456
-1.234567890123456789012345678901
-1.234567890123456789012345678901
+1.234567890123456789
+1.234567890123456789
 12.34567890123456
-12.345678901234567890123456789012
-12.345678901234567890123456789012
+12.34567890123456789
+12.34567890123456789
 123.4567890123456
-123.456789012345678901234567890123
-123.456789012345678901234567890123
+123.456789012345678901
+123.456789012345678901
 1234.567890123456
-1234.567890123456789012345678901235
-1234.567890123456789012345678901235
+1234.567890123456789012
+1234.567890123456789012
 12345.67890123456
-12345.678901234567890123456789012346
+12345.678901234567890123
 123456.7890123456
-123456.789012345678901234567890123457
+123456.789012345678901235
 1234567.890123456
-1234567.890123456789012345678901234568
+1234567.890123456789012346
 12345678.90123456
-12345678.901234567890123456789012345678
+12345678.901234567890123457
 123456789.0123456
-123456789.01234567890123456789012345678
+123456789.012345678901234568
 1234567890.123456
-1234567890.1234567890123456789012345678
+1234567890.123456789012345679
 12345678901.23456
-12345678901.234567890123456789012345678
+12345678901.234567890123456789
 123456789012.3456
-123456789012.34567890123456789012345678
+123456789012.34567890123456789
 1234567890123.456
-1234567890123.4567890123456789012345678
+1234567890123.456789012345678901
 12345678901234.56
-12345678901234.567890123456789012345678
+12345678901234.567890123456789012
 123456789012345.6
-123456789012345.67890123456789012345678
-1234567890123456.7890123456789012345678
-12345678901234567.890123456789012345678
-123456789012345678.90123456789012345678
-1234567890123456789.0123456789012345678
+123456789012345.678901234567890123
+1234567890123456.789012345678901235
+12345678901234567.890123456789012346
+123456789012345678.901234567890123457
+1234567890123456789.012345678901234568
 12345678901234567890.123456789012345678
-123456789012345678901.23456789012345678
-1234567890123456789012.3456789012345678
-12345678901234567890123.456789012345678
-123456789012345678901234.56789012345678
-1234567890123456789012345.6789012345678
-12345678901234567890123456.789012345678
-123456789012345678901234567.89012345678
-1234567890123456789012345678.9012345678
-12345678901234567890123456789.012345678
-123456789012345678901234567890.12345678
 PREHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -129,62 +129,62 @@ 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
+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.123456789012345	1.123456789012345	-0.876543210987655
-0.12345678901234567890123456789	1.12345678901234567890123456789	-0.87654321098765432109876543211
+0.123456789012345679	1.123456789012345679	-0.876543210987654321
 1.234567890123456	2.234567890123456	0.234567890123456
-1.234567890123456789012345678901	2.234567890123456789012345678901	0.234567890123456789012345678901
-1.234567890123456789012345678901	2.234567890123456789012345678901	0.234567890123456789012345678901
+1.234567890123456789	2.234567890123456789	0.234567890123456789
+1.234567890123456789	2.234567890123456789	0.234567890123456789
 12.34567890123456	13.34567890123456	11.34567890123456
-12.345678901234567890123456789012	13.345678901234567890123456789012	11.345678901234567890123456789012
-12.345678901234567890123456789012	13.345678901234567890123456789012	11.345678901234567890123456789012
+12.34567890123456789	13.34567890123456789	11.34567890123456789
+12.34567890123456789	13.34567890123456789	11.34567890123456789
 123.4567890123456	124.4567890123456	122.4567890123456
-123.456789012345678901234567890123	124.456789012345678901234567890123	122.456789012345678901234567890123
-123.456789012345678901234567890123	124.456789012345678901234567890123	122.456789012345678901234567890123
+123.456789012345678901	124.456789012345678901	122.456789012345678901
+123.456789012345678901	124.456789012345678901	122.456789012345678901
 1234.567890123456	1235.567890123456	1233.567890123456
-1234.567890123456789012345678901235	1235.567890123456789012345678901235	1233.567890123456789012345678901235
-1234.567890123456789012345678901235	1235.567890123456789012345678901235	1233.567890123456789012345678901235
+1234.567890123456789012	1235.567890123456789012	1233.567890123456789012
+1234.567890123456789012	1235.567890123456789012	1233.567890123456789012
 12345.67890123456	12346.67890123456	12344.67890123456
-12345.678901234567890123456789012346	12346.678901234567890123456789012346	12344.678901234567890123456789012346
+12345.678901234567890123	12346.678901234567890123	12344.678901234567890123
 123456.7890123456	123457.7890123456	123455.7890123456
-123456.789012345678901234567890123457	123457.789012345678901234567890123457	123455.789012345678901234567890123457
+123456.789012345678901235	123457.789012345678901235	123455.789012345678901235
 1234567.890123456	1234568.890123456	1234566.890123456
-1234567.890123456789012345678901234568	1234568.890123456789012345678901234568	1234566.890123456789012345678901234568
+1234567.890123456789012346	1234568.890123456789012346	1234566.890123456789012346
 12345678.90123456	12345679.90123456	12345677.90123456
-12345678.901234567890123456789012345678	12345679.901234567890123456789012345678	12345677.901234567890123456789012345678
+12345678.901234567890123457	12345679.901234567890123457	12345677.901234567890123457
 123456789.0123456	123456790.0123456	123456788.0123456
-123456789.01234567890123456789012345678	123456790.01234567890123456789012345678	123456788.01234567890123456789012345678
+123456789.012345678901234568	123456790.012345678901234568	123456788.012345678901234568
 1234567890.123456	1234567891.123456	1234567889.123456
-1234567890.1234567890123456789012345678	1234567891.1234567890123456789012345678	1234567889.1234567890123456789012345678
+1234567890.123456789012345679	1234567891.123456789012345679	1234567889.123456789012345679
 12345678901.23456	12345678902.23456	12345678900.23456
-12345678901.234567890123456789012345678	12345678902.234567890123456789012345678	12345678900.234567890123456789012345678
+12345678901.234567890123456789	12345678902.234567890123456789	12345678900.234567890123456789
 123456789012.3456	123456789013.3456	123456789011.3456
-123456789012.34567890123456789012345678	123456789013.34567890123456789012345678	123456789011.34567890123456789012345678
+123456789012.34567890123456789	123456789013.34567890123456789	123456789011.34567890123456789
 1234567890123.456	1234567890124.456	1234567890122.456
-1234567890123.4567890123456789012345678	1234567890124.4567890123456789012345678	1234567890122.4567890123456789012345678
+1234567890123.456789012345678901	1234567890124.456789012345678901	1234567890122.456789012345678901
 12345678901234.56	12345678901235.56	12345678901233.56
-12345678901234.567890123456789012345678	12345678901235.567890123456789012345678	12345678901233.567890123456789012345678
+12345678901234.567890123456789012	12345678901235.567890123456789012	12345678901233.567890123456789012
 123456789012345.6	123456789012346.6	123456789012344.6
-123456789012345.67890123456789012345678	123456789012346.67890123456789012345678	123456789012344.67890123456789012345678
-1234567890123456.7890123456789012345678	1234567890123457.7890123456789012345678	1234567890123455.7890123456789012345678
-12345678901234567.890123456789012345678	12345678901234568.890123456789012345678	12345678901234566.890123456789012345678
-123456789012345678.90123456789012345678	123456789012345679.90123456789012345678	123456789012345677.90123456789012345678
-1234567890123456789.0123456789012345678	1234567890123456790.0123456789012345678	1234567890123456788.0123456789012345678
+123456789012345.678901234567890123	123456789012346.678901234567890123	123456789012344.678901234567890123
+1234567890123456.789012345678901235	1234567890123457.789012345678901235	1234567890123455.789012345678901235
+12345678901234567.890123456789012346	12345678901234568.890123456789012346	12345678901234566.890123456789012346
+123456789012345678.901234567890123457	123456789012345679.901234567890123457	123456789012345677.901234567890123457
+1234567890123456789.012345678901234568	1234567890123456790.012345678901234568	1234567890123456788.012345678901234568
 12345678901234567890.123456789012345678	12345678901234567891.123456789012345678	12345678901234567889.123456789012345678
-123456789012345678901.23456789012345678	123456789012345678902.23456789012345678	123456789012345678900.23456789012345678
-1234567890123456789012.3456789012345678	1234567890123456789013.3456789012345678	1234567890123456789011.3456789012345678
-12345678901234567890123.456789012345678	12345678901234567890124.456789012345678	12345678901234567890122.456789012345678
-123456789012345678901234.56789012345678	123456789012345678901235.56789012345678	123456789012345678901233.56789012345678
-1234567890123456789012345.6789012345678	1234567890123456789012346.6789012345678	1234567890123456789012344.6789012345678
-12345678901234567890123456.789012345678	12345678901234567890123457.789012345678	12345678901234567890123455.789012345678
-123456789012345678901234567.89012345678	123456789012345678901234568.89012345678	123456789012345678901234566.89012345678
-1234567890123456789012345678.9012345678	1234567890123456789012345679.9012345678	1234567890123456789012345677.9012345678
-12345678901234567890123456789.012345678	12345678901234567890123456790.012345678	12345678901234567890123456788.012345678
-123456789012345678901234567890.12345678	123456789012345678901234567891.12345678	123456789012345678901234567889.12345678
 PREHOOK: query: SELECT dec, dec * 2, dec / 3  FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -212,62 +212,62 @@ 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
+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.123456789012345	0.24691357802469	0.041152263004115
-0.12345678901234567890123456789	0.24691357802469135780246913578	0.04115226300411522630041152263
+0.123456789012345679	0.246913578024691358	0.04115226300411522633
 1.234567890123456	2.469135780246912	0.411522630041152
-1.234567890123456789012345678901	2.469135780246913578024691357802	0.4115226300411522630041152263
-1.234567890123456789012345678901	2.469135780246913578024691357802	0.4115226300411522630041152263
+1.234567890123456789	2.469135780246913578	0.411522630041152263
+1.234567890123456789	2.469135780246913578	0.411522630041152263
 12.34567890123456	24.69135780246912	4.11522630041152
-12.345678901234567890123456789012	24.691357802469135780246913578024	4.115226300411522630041152263004
-12.345678901234567890123456789012	24.691357802469135780246913578024	4.115226300411522630041152263004
+12.34567890123456789	24.69135780246913578	4.11522630041152263
+12.34567890123456789	24.69135780246913578	4.11522630041152263
 123.4567890123456	246.9135780246912	41.1522630041152
-123.456789012345678901234567890123	246.913578024691357802469135780246	41.152263004115226300411522630041
-123.456789012345678901234567890123	246.913578024691357802469135780246	41.152263004115226300411522630041
+123.456789012345678901	246.913578024691357802	41.15226300411522630033
+123.456789012345678901	246.913578024691357802	41.15226300411522630033
 1234.567890123456	2469.135780246912	411.522630041152
-1234.567890123456789012345678901235	2469.13578024691357802469135780247	411.522630041152263004115226300412
-1234.567890123456789012345678901235	2469.13578024691357802469135780247	411.522630041152263004115226300412
+1234.567890123456789012	2469.135780246913578024	411.522630041152263004
+1234.567890123456789012	2469.135780246913578024	411.522630041152263004
 12345.67890123456	24691.35780246912	4115.22630041152
-12345.678901234567890123456789012346	24691.357802469135780246913578024692	4115.226300411522630041152263004115
+12345.678901234567890123	24691.357802469135780246	4115.226300411522630041
 123456.7890123456	246913.5780246912	41152.2630041152
-123456.789012345678901234567890123457	246913.578024691357802469135780246914	41152.263004115226300411522630041152
+123456.789012345678901235	246913.57802469135780247	41152.26300411522630041167
 1234567.890123456	2469135.780246912	411522.630041152
-1234567.890123456789012345678901234568	2469135.780246913578024691357802469136	411522.630041152263004115226300411523
+1234567.890123456789012346	2469135.780246913578024692	411522.63004115226300411533
 12345678.90123456	24691357.80246912	4115226.30041152
-12345678.901234567890123456789012345678	24691357.802469135780246913578024691356	4115226.300411522630041152263004115226
+12345678.901234567890123457	24691357.802469135780246914	4115226.30041152263004115233
 123456789.0123456	246913578.0246912	41152263.0041152
-123456789.01234567890123456789012345678	246913578.02469135780246913578024691356	41152263.00411522630041152263004115226
+123456789.012345678901234568	246913578.024691357802469136	41152263.00411522630041152267
 1234567890.123456	2469135780.246912	411522630.041152
-1234567890.1234567890123456789012345678	2469135780.2469135780246913578024691356	411522630.0411522630041152263004115226
+1234567890.123456789012345679	2469135780.246913578024691358	411522630.04115226300411522633
 12345678901.23456	24691357802.46912	4115226300.41152
-12345678901.234567890123456789012345678	24691357802.469135780246913578024691356	4115226300.411522630041152263004115226
+12345678901.234567890123456789	24691357802.469135780246913578	4115226300.411522630041152263
 123456789012.3456	246913578024.6912	41152263004.1152
-123456789012.34567890123456789012345678	246913578024.69135780246913578024691356	41152263004.11522630041152263004115226
+123456789012.34567890123456789	246913578024.69135780246913578	41152263004.11522630041152263
 1234567890123.456	2469135780246.912	411522630041.152
-1234567890123.4567890123456789012345678	2469135780246.9135780246913578024691356	411522630041.1522630041152263004115226
+1234567890123.456789012345678901	2469135780246.913578024691357802	411522630041.15226300411522630033
 12345678901234.56	24691357802469.12	4115226300411.52
-12345678901234.567890123456789012345678	24691357802469.135780246913578024691356	4115226300411.522630041152263004115226
+12345678901234.567890123456789012	24691357802469.135780246913578024	4115226300411.522630041152263004
 123456789012345.6	246913578024691.2	41152263004115.2
-123456789012345.67890123456789012345678	246913578024691.35780246913578024691356	41152263004115.22630041152263004115226
-1234567890123456.7890123456789012345678	2469135780246913.5780246913578024691356	411522630041152.2630041152263004115226
-12345678901234567.890123456789012345678	24691357802469135.780246913578024691356	4115226300411522.630041152263004115226
-123456789012345678.90123456789012345678	246913578024691357.80246913578024691356	41152263004115226.30041152263004115226
-1234567890123456789.0123456789012345678	2469135780246913578.0246913578024691356	411522630041152263.0041152263004115226
-12345678901234567890.123456789012345678	24691357802469135780.246913578024691356	4115226300411522630.041152263004115226
-123456789012345678901.23456789012345678	246913578024691357802.46913578024691356	41152263004115226300.41152263004115226
-1234567890123456789012.3456789012345678	2469135780246913578024.6913578024691356	411522630041152263004.1152263004115226
-12345678901234567890123.456789012345678	24691357802469135780246.913578024691356	4115226300411522630041.152263004115226
-123456789012345678901234.56789012345678	246913578024691357802469.13578024691356	41152263004115226300411.52263004115226
-1234567890123456789012345.6789012345678	2469135780246913578024691.3578024691356	411522630041152263004115.2263004115226
-12345678901234567890123456.789012345678	24691357802469135780246913.578024691356	4115226300411522630041152.263004115226
-123456789012345678901234567.89012345678	246913578024691357802469135.78024691356	41152263004115226300411522.63004115226
-1234567890123456789012345678.9012345678	2469135780246913578024691357.8024691356	411522630041152263004115226.3004115226
-12345678901234567890123456789.012345678	24691357802469135780246913578.024691356	4115226300411522630041152263.004115226
-123456789012345678901234567890.12345678	246913578024691357802469135780.24691356	41152263004115226300411522630.04115226
+123456789012345.678901234567890123	246913578024691.357802469135780246	41152263004115.226300411522630041
+1234567890123456.789012345678901235	2469135780246913.57802469135780247	411522630041152.26300411522630041167
+12345678901234567.890123456789012346	24691357802469135.780246913578024692	4115226300411522.63004115226300411533
+123456789012345678.901234567890123457	246913578024691357.802469135780246914	41152263004115226.30041152263004115233
+1234567890123456789.012345678901234568	2469135780246913578.024691357802469136	NULL
+12345678901234567890.123456789012345678	24691357802469135780.246913578024691356	NULL
 PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -295,62 +295,62 @@ 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.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.013717333333333333333333333333
-1234567890.1234567890123456789012345678	137174210.0137174210013717421001371742
-12345678901.23456	1371742100.137173333333333333333333333333
-12345678901.234567890123456789012345678	1371742100.137174210013717421001371742
-123456789012.3456	13717421001.371733333333333333333333333333
-123456789012.34567890123456789012345678	13717421001.37174210013717421001371742
-1234567890123.456	137174210013.717333333333333333333333333333
-1234567890123.4567890123456789012345678	137174210013.7174210013717421001371742
-12345678901234.56	1371742100137.173333333333333333333333333333
-12345678901234.567890123456789012345678	1371742100137.174210013717421001371742
-123456789012345.6	13717421001371.733333333333333333333333333333
-123456789012345.67890123456789012345678	13717421001371.74210013717421001371742
-1234567890123456.7890123456789012345678	137174210013717.4210013717421001371742
-12345678901234567.890123456789012345678	1371742100137174.210013717421001371742
-123456789012345678.90123456789012345678	13717421001371742.10013717421001371742
-1234567890123456789.0123456789012345678	137174210013717421.0013717421001371742
-12345678901234567890.123456789012345678	1371742100137174210.013717421001371742
-123456789012345678901.23456789012345678	13717421001371742100.13717421001371742
-1234567890123456789012.3456789012345678	137174210013717421001.3717421001371742
-12345678901234567890123.456789012345678	1371742100137174210013.717421001371742
-123456789012345678901234.56789012345678	13717421001371742100137.17421001371742
-1234567890123456789012345.6789012345678	137174210013717421001371.7421001371742
-12345678901234567890123456.789012345678	1371742100137174210013717.421001371742
-123456789012345678901234567.89012345678	13717421001371742100137174.21001371742
-1234567890123456789012345678.9012345678	137174210013717421001371742.1001371742
-12345678901234567890123456789.012345678	1371742100137174210013717421.001371742
-123456789012345678901234567890.12345678	13717421001371742100137174210.01371742
+0.123456789012345	0.01371742100137166667
+0.123456789012345679	0.01371742100137174211
+1.234567890123456	0.13717421001371733333
+1.234567890123456789	0.137174210013717421
+1.234567890123456789	0.137174210013717421
+12.34567890123456	1.37174210013717333333
+12.34567890123456789	1.37174210013717421
+12.34567890123456789	1.37174210013717421
+123.4567890123456	13.71742100137173333333
+123.456789012345678901	13.71742100137174210011
+123.456789012345678901	13.71742100137174210011
+1234.567890123456	137.17421001371733333333
+1234.567890123456789012	137.17421001371742100133
+1234.567890123456789012	137.17421001371742100133
+12345.67890123456	1371.74210013717333333333
+12345.678901234567890123	1371.74210013717421001367
+123456.7890123456	13717.42100137173333333333
+123456.789012345678901235	13717.42100137174210013722
+1234567.890123456	137174.21001371733333333333
+1234567.890123456789012346	137174.21001371742100137178
+12345678.90123456	1371742.10013717333333333333
+12345678.901234567890123457	1371742.10013717421001371744
+123456789.0123456	13717421.00137173333333333333
+123456789.012345678901234568	13717421.00137174210013717422
+1234567890.123456	137174210.01371733333333333333
+1234567890.123456789012345679	137174210.01371742100137174211
+12345678901.23456	1371742100.13717333333333333333
+12345678901.234567890123456789	1371742100.137174210013717421
+123456789012.3456	13717421001.37173333333333333333
+123456789012.34567890123456789	13717421001.37174210013717421
+1234567890123.456	137174210013.71733333333333333333
+1234567890123.456789012345678901	137174210013.71742100137174210011
+12345678901234.56	1371742100137.17333333333333333333
+12345678901234.567890123456789012	1371742100137.17421001371742100133
+123456789012345.6	13717421001371.73333333333333333333
+123456789012345.678901234567890123	13717421001371.74210013717421001367
+1234567890123456.789012345678901235	137174210013717.42100137174210013722
+12345678901234567.890123456789012346	1371742100137174.21001371742100137178
+123456789012345678.901234567890123457	13717421001371742.10013717421001371744
+1234567890123456789.012345678901234568	NULL
+12345678901234567890.123456789012345678	NULL
 PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -378,62 +378,62 @@ 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.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.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
+0.123456789012345	0.004572473667123888889
+0.123456789012345679	0.004572473667123914037
+1.234567890123456	0.045724736671239111111
+1.234567890123456789	0.045724736671239140333
+1.234567890123456789	0.045724736671239140333
+12.34567890123456	0.457247366712391111111
+12.34567890123456789	0.457247366712391403333
+12.34567890123456789	0.457247366712391403333
+123.4567890123456	4.572473667123911111111
+123.456789012345678901	4.57247366712391403337
+123.456789012345678901	4.57247366712391403337
+1234.567890123456	45.724736671239111111111
+1234.567890123456789012	45.724736671239140333778
+1234.567890123456789012	45.724736671239140333778
+12345.67890123456	457.247366712391111111111
+12345.678901234567890123	457.247366712391403337889
+123456.7890123456	4572.473667123911111111111
+123456.789012345678901235	4572.473667123914033379074
+1234567.890123456	45724.736671239111111111111
+1234567.890123456789012346	45724.736671239140333790593
+12345678.90123456	457247.366712391111111111111
+12345678.901234567890123457	457247.366712391403337905815
+123456789.0123456	4572473.667123911111111111111
+123456789.012345678901234568	4572473.667123914033379058074
+1234567890.123456	45724736.671239111111111111111
+1234567890.123456789012345679	45724736.671239140333790580704
+12345678901.23456	457247366.712391111111111111111
+12345678901.234567890123456789	457247366.712391403337905807
+123456789012.3456	4572473667.123911111111111111111
+123456789012.34567890123456789	4572473667.12391403337905807
+1234567890123.456	45724736671.239111111111111111111
+1234567890123.456789012345678901	45724736671.239140333790580700037
+12345678901234.56	457247366712.391111111111111111111
+12345678901234.567890123456789012	457247366712.391403337905807000444
+123456789012345.6	4572473667123.911111111111111111111
+123456789012345.678901234567890123	4572473667123.914033379058070004556
+1234567890123456.789012345678901235	45724736671239.140333790580700045741
+12345678901234567.890123456789012346	457247366712391.403337905807000457259
+123456789012345678.901234567890123457	NULL
+1234567890123456789.012345678901234568	NULL
+12345678901234567890.123456789012345678	NULL
 PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -461,62 +461,62 @@ 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.123456789012345	0.015241578753238669120562399025
-0.12345678901234567890123456789	NULL
+0.123456789012345679	0.015241578753238836774881877789971041
 1.234567890123456	1.524157875323881726870921383936
-1.234567890123456789012345678901	NULL
-1.234567890123456789012345678901	NULL
-12.34567890123456	152.4157875323881726870921383936
-12.345678901234567890123456789012	NULL
-12.345678901234567890123456789012	NULL
-123.4567890123456	15241.57875323881726870921383936
-123.456789012345678901234567890123	NULL
-123.456789012345678901234567890123	NULL
-1234.567890123456	1524157.875323881726870921383936
-1234.567890123456789012345678901235	NULL
-1234.567890123456789012345678901235	NULL
-12345.67890123456	152415787.5323881726870921383936
-12345.678901234567890123456789012346	NULL
-123456.7890123456	15241578753.23881726870921383936
-123456.789012345678901234567890123457	NULL
-1234567.890123456	1524157875323.881726870921383936
-1234567.890123456789012345678901234568	NULL
-12345678.90123456	152415787532388.1726870921383936
-12345678.901234567890123456789012345678	NULL
-123456789.0123456	15241578753238817.26870921383936
-123456789.01234567890123456789012345678	NULL
-1234567890.123456	1524157875323881726.870921383936
-1234567890.1234567890123456789012345678	NULL
-12345678901.23456	152415787532388172687.0921383936
-12345678901.234567890123456789012345678	NULL
-123456789012.3456	15241578753238817268709.21383936
-123456789012.34567890123456789012345678	NULL
-1234567890123.456	1524157875323881726870921.383936
-1234567890123.4567890123456789012345678	NULL
-12345678901234.56	152415787532388172687092138.3936
-12345678901234.567890123456789012345678	NULL
-123456789012345.6	15241578753238817268709213839.36
-123456789012345.67890123456789012345678	NULL
-1234567890123456.7890123456789012345678	NULL
-12345678901234567.890123456789012345678	NULL
-123456789012345678.90123456789012345678	NULL
-1234567890123456789.0123456789012345678	NULL
+1.234567890123456789	1.524157875323883675019051998750190521
+1.234567890123456789	1.524157875323883675019051998750190521
+12.34567890123456	NULL
+12.34567890123456789	NULL
+12.34567890123456789	NULL
+123.4567890123456	NULL
+123.456789012345678901	NULL
+123.456789012345678901	NULL
+1234.567890123456	NULL
+1234.567890123456789012	NULL
+1234.567890123456789012	NULL
+12345.67890123456	NULL
+12345.678901234567890123	NULL
+123456.7890123456	NULL
+123456.789012345678901235	NULL
+1234567.890123456	NULL
+1234567.890123456789012346	NULL
+12345678.90123456	NULL
+12345678.901234567890123457	NULL
+123456789.0123456	NULL
+123456789.012345678901234568	NULL
+1234567890.123456	NULL
+1234567890.123456789012345679	NULL
+12345678901.23456	NULL
+12345678901.234567890123456789	NULL
+123456789012.3456	NULL
+123456789012.34567890123456789	NULL
+1234567890123.456	NULL
+1234567890123.456789012345678901	NULL
+12345678901234.56	NULL
+12345678901234.567890123456789012	NULL
+123456789012345.6	NULL
+123456789012345.678901234567890123	NULL
+1234567890123456.789012345678901235	NULL
+12345678901234567.890123456789012346	NULL
+123456789012345678.901234567890123457	NULL
+1234567890123456789.012345678901234568	NULL
 12345678901234567890.123456789012345678	NULL
-123456789012345678901.23456789012345678	NULL
-1234567890123456789012.3456789012345678	NULL
-12345678901234567890123.456789012345678	NULL
-123456789012345678901234.56789012345678	NULL
-1234567890123456789012345.6789012345678	NULL
-12345678901234567890123456.789012345678	NULL
-123456789012345678901234567.89012345678	NULL
-1234567890123456789012345678.9012345678	NULL
-12345678901234567890123456789.012345678	NULL
-123456789012345678901234567890.12345678	NULL
 PREHOOK: query: SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
@@ -525,47 +525,47 @@ POSTHOOK: query: SELECT avg(dec), sum(de
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-2449539464530670681706817092.661571403901626461618141287233	137174210013717558175581757189.047998618491081850615912085061
-PREHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal(39,9)) FROM DECIMAL_PRECISION LIMIT 1
+298207786425690373.674956491924017375	13717558175581757189.04799862850479927
+PREHOOK: query: SELECT dec * cast('12345678901234567890.12345678' as decimal(38,18)) 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(39,9)) FROM DECIMAL_PRECISION LIMIT 1
+POSTHOOK: query: SELECT dec * cast('12345678901234567890.12345678' as decimal(38,18)) 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(39,9)) LIMIT 1
+PREHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('1234567890123456789012345678.12345678' as decimal(38,18)) 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(39,9)) LIMIT 1
+POSTHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('1234567890123456789012345678.12345678' as decimal(38,18)) LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-PREHOOK: query: SELECT dec * 123456789012345678901234567890.123456789 FROM DECIMAL_PRECISION LIMIT 1
+PREHOOK: query: SELECT dec * 12345678901234567890.12345678 FROM DECIMAL_PRECISION LIMIT 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dec * 123456789012345678901234567890.123456789 FROM DECIMAL_PRECISION LIMIT 1
+POSTHOOK: query: SELECT dec * 12345678901234567890.12345678 FROM DECIMAL_PRECISION LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
 NULL
-PREHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
+PREHOOK: query: SELECT MIN(cast('12345678901234567890.12345678' as decimal(38,18))) 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(39,9))) FROM DECIMAL_PRECISION
+POSTHOOK: query: SELECT MIN(cast('12345678901234567890.12345678' as decimal(38,18))) FROM DECIMAL_PRECISION
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####
-123456789012345678901234567890.123456789
-PREHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
+12345678901234567890.12345678
+PREHOOK: query: SELECT COUNT(cast('12345678901234567890.12345678' as decimal(38,18))) 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(39,9))) FROM DECIMAL_PRECISION
+POSTHOOK: query: SELECT COUNT(cast('12345678901234567890.12345678' as decimal(38,18))) FROM DECIMAL_PRECISION
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_precision
 #### A masked pattern was here ####

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=1545564&r1=1545563&r2=1545564&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 Nov 26 08:19:25 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(65,30), value int) 
+PREHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal(38,18), value int)
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
 PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal(65,30), value int) 
+POSTHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal(38,18), value int)
 ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ' '
 STORED AS TEXTFILE
@@ -41,7 +41,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key + key)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -89,7 +89,7 @@ NULL
 6.28
 6.28
 6.28
-1.9999999999999999999999998
+2
 -2469135780.246913578
 2469135780.24691356
 PREHOOK: query: EXPLAIN SELECT key + value FROM DECIMAL_UDF
@@ -112,7 +112,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key + value)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -160,7 +160,7 @@ NULL
 6.14
 6.14
 7.14
-1.9999999999999999999999999
+2
 -2469135780.123456789
 2469135780.12345678
 PREHOOK: query: EXPLAIN SELECT key + (value/2) FROM DECIMAL_UDF
@@ -183,7 +183,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key + (value / 2))
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -231,7 +231,7 @@ NULL
 4.64
 4.64
 5.14
-1.4999999999999999999999999
+1.5
 -1851851835.123456789
 1851851835.12345678
 PREHOOK: query: EXPLAIN SELECT key + '1.0' FROM DECIMAL_UDF
@@ -254,7 +254,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key + '1.0')
-                  type: decimal(65,30)
+                  type: double
             outputColumnNames: _col0
             ListSink
 
@@ -267,44 +267,44 @@ POSTHOOK: query: SELECT key + '1.0' FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--4399
+-4399.0
 NULL
-1
-1
-101
-11
-2
+1.0
+1.0
+101.0
+11.0
+2.0
 1.1
 1.01
-201
-21
-3
-1
+201.0
+21.0
+3.0
+1.0
 1.2
 1.02
 1.3
 1.33
 1.333
 0.7
-0.67
+0.6699999999999999
 0.667
-2
-3
-4.14
--0.12
--0.12
--0.122
+2.0
+3.0
+4.140000000000001
+-0.1200000000000001
+-0.1200000000000001
+-0.12200000000000011
 2.12
 2.122
-125
+125.0
 126.2
 -1254.49
-4.14
-4.14
-4.14
-1.9999999999999999999999999
--1234567889.123456789
-1234567891.12345678
+4.140000000000001
+4.140000000000001
+4.140000000000001
+2.0
+-1.2345678891234567E9
+1.2345678911234567E9
 PREHOOK: query: -- substraction
 EXPLAIN SELECT key - key FROM DECIMAL_UDF
 PREHOOK: type: QUERY
@@ -327,7 +327,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key - key)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -398,7 +398,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key - value)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -446,7 +446,7 @@ NULL
 0.14
 0.14
 -0.86
--0.0000000000000000000000001
+0
 -0.123456789
 0.12345678
 PREHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF
@@ -469,7 +469,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key - (value / 2))
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -517,7 +517,7 @@ NULL
 1.64
 1.64
 1.14
-0.4999999999999999999999999
+0.5
 -617283945.123456789
 617283945.12345678
 PREHOOK: query: EXPLAIN SELECT key - '1.0' FROM DECIMAL_UDF
@@ -540,7 +540,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key - '1.0')
-                  type: decimal(65,30)
+                  type: double
             outputColumnNames: _col0
             ListSink
 
@@ -553,44 +553,44 @@ POSTHOOK: query: SELECT key - '1.0' FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--4401
+-4401.0
 NULL
--1
--1
-99
-9
-0
+-1.0
+-1.0
+99.0
+9.0
+0.0
 -0.9
 -0.99
-199
-19
-1
--1
+199.0
+19.0
+1.0
+-1.0
 -0.8
 -0.98
 -0.7
--0.67
+-0.6699999999999999
 -0.667
 -1.3
 -1.33
 -1.333
-0
-1
+0.0
+1.0
 2.14
 -2.12
 -2.12
 -2.122
-0.12
-0.122
-123
+0.1200000000000001
+0.12200000000000011
+123.0
 124.2
 -1256.49
 2.14
 2.14
 2.14
--0.0000000000000000000000001
--1234567891.123456789
-1234567889.12345678
+0.0
+-1.2345678911234567E9
+1.2345678891234567E9
 PREHOOK: query: -- multiplication
 EXPLAIN SELECT key * key FROM DECIMAL_UDF
 PREHOOK: type: QUERY
@@ -613,7 +613,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key * key)
-                  type: decimal(65,30)
+                  type: decimal(38,36)
             outputColumnNames: _col0
             ListSink
 
@@ -626,17 +626,17 @@ POSTHOOK: query: SELECT key * key FROM D
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-19360000
+NULL
 NULL
 0
 0
-10000
-100
+NULL
+NULL
 1
 0.01
 0.0001
-40000
-400
+NULL
+NULL
 4
 0
 0.04
@@ -655,15 +655,15 @@ NULL
 1.258884
 1.2544
 1.258884
-15376
-15675.04
-1576255.1401
+NULL
+NULL
+NULL
 9.8596
 9.8596
 9.8596
+1
+NULL
 NULL
-1524157875323883675.019051998750190521
-1524157875323883652.7968299765279684
 PREHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF
@@ -684,7 +684,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key * value)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -732,7 +732,7 @@ NULL
 9.42
 9.42
 12.56
-0.9999999999999999999999999
+1
 1524157875171467887.50190521
 1524157875171467876.3907942
 PREHOOK: query: EXPLAIN SELECT key * (value/2) FROM DECIMAL_UDF
@@ -755,7 +755,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key * (value / 2))
-                  type: decimal(65,30)
+                  type: decimal(38,24)
             outputColumnNames: _col0
             ListSink
 
@@ -803,9 +803,9 @@ NULL
 4.71
 4.71
 6.28
-0.49999999999999999999999995
-762078937585733943.750952605
-762078937585733938.1953971
+0.5
+NULL
+NULL
 PREHOOK: query: EXPLAIN SELECT key * '2.0' FROM DECIMAL_UDF
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT key * '2.0' FROM DECIMAL_UDF
@@ -826,7 +826,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key * '2.0')
-                  type: decimal(65,30)
+                  type: double
             outputColumnNames: _col0
             ListSink
 
@@ -839,19 +839,19 @@ POSTHOOK: query: SELECT key * '2.0' FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--8800
+-8800.0
 NULL
-0
-0
-200
-20
-2
+0.0
+0.0
+200.0
+20.0
+2.0
 0.2
 0.02
-400
-40
-4
-0
+400.0
+40.0
+4.0
+0.0
 0.4
 0.04
 0.6
@@ -860,23 +860,23 @@ NULL
 -0.6
 -0.66
 -0.666
-2
-4
+2.0
+4.0
 6.28
 -2.24
 -2.24
 -2.244
 2.24
 2.244
-248
+248.0
 250.4
 -2510.98
 6.28
 6.28
 6.28
-1.9999999999999999999999998
--2469135780.246913578
-2469135780.24691356
+2.0
+-2.4691357802469134E9
+2.4691357802469134E9
 PREHOOK: query: -- division
 EXPLAIN SELECT key / 0 FROM DECIMAL_UDF limit 1
 PREHOOK: type: QUERY
@@ -899,7 +899,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key / 0)
-                  type: decimal(65,30)
+                  type: decimal(38,20)
             outputColumnNames: _col0
             Limit
               ListSink
@@ -934,7 +934,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key / null)
-                  type: decimal(65,30)
+                  type: double
             outputColumnNames: _col0
             Limit
               ListSink
@@ -973,7 +973,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key / key)
-                    type: decimal(65,30)
+                    type: decimal(38,38)
               outputColumnNames: _col0
               ListSink
 
@@ -986,40 +986,40 @@ POSTHOOK: query: SELECT key / key FROM D
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
+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
+NULL
 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
@@ -1044,7 +1044,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key / value)
-                    type: decimal(65,30)
+                    type: decimal(38,29)
               outputColumnNames: _col0
               ListSink
 
@@ -1066,7 +1066,7 @@ POSTHOOK: Input: default@decimal_udf
 1
 1
 1
-1.046666666666666666666666666667
+1.04666666666666666666666666667
 1.12
 1.12
 0.102
@@ -1074,13 +1074,13 @@ POSTHOOK: Input: default@decimal_udf
 1.122
 1
 1.0016
-1.000390438247011952191235059761
-1.046666666666666666666666666667
-1.046666666666666666666666666667
+1.00039043824701195219123505976
+1.04666666666666666666666666667
+1.04666666666666666666666666667
 0.785
-0.9999999999999999999999999
-1.0000000001
-1.000000000099999992709999933661
+1
+NULL
+NULL
 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
@@ -1105,7 +1105,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: (key / (value / 2))
-                    type: decimal(65,30)
+                    type: decimal(38,35)
               outputColumnNames: _col0
               ListSink
 
@@ -1118,7 +1118,7 @@ POSTHOOK: query: SELECT key / (value/2) 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--2
+NULL
 2
 2
 2
@@ -1127,7 +1127,7 @@ POSTHOOK: Input: default@decimal_udf
 2
 2
 2
-2.093333333333333333333333333333
+2.09333333333333333333333333333333333
 2.24
 2.24
 0.204
@@ -1135,13 +1135,13 @@ POSTHOOK: Input: default@decimal_udf
 2.244
 2
 2.0032
-2.000780876494023904382470119522
-2.093333333333333333333333333333
-2.093333333333333333333333333333
+NULL
+2.09333333333333333333333333333333333
+2.09333333333333333333333333333333333
 1.57
-1.9999999999999999999999998
-2.0000000002
-2.000000000199999985419999867322
+2
+NULL
+NULL
 PREHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
@@ -1162,7 +1162,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (key / '2.0')
-                  type: decimal(65,30)
+                  type: double
             outputColumnNames: _col0
             ListSink
 
@@ -1175,19 +1175,19 @@ POSTHOOK: query: SELECT key / '2.0' FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_udf
 #### A masked pattern was here ####
--2200
+-2200.0
 NULL
-0
-0
-50
-5
+0.0
+0.0
+50.0
+5.0
 0.5
 0.05
-0.005
-100
-10
-1
-0
+0.0050
+100.0
+10.0
+1.0
+0.0
 0.1
 0.01
 0.15
@@ -1197,22 +1197,22 @@ NULL
 -0.165
 -0.1665
 0.5
-1
+1.0
 1.57
 -0.56
 -0.56
 -0.561
 0.56
 0.561
-62
+62.0
 62.6
 -627.745
 1.57
 1.57
 1.57
-0.49999999999999999999999995
--617283945.0617283945
-617283945.06172839
+0.5
+-6.172839450617284E8
+6.172839450617284E8
 PREHOOK: query: -- abs
 EXPLAIN SELECT abs(key) FROM DECIMAL_UDF
 PREHOOK: type: QUERY
@@ -1235,7 +1235,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: abs(key)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -1283,7 +1283,7 @@ NULL
 3.14
 3.14
 3.14
-0.9999999999999999999999999
+1
 1234567890.123456789
 1234567890.12345678
 PREHOOK: query: -- avg
@@ -1312,7 +1312,7 @@ STAGE PLANS:
                     expr: value
                     type: int
                     expr: key
-                    type: decimal(65,30)
+                    type: decimal(38,18)
               outputColumnNames: value, key
               Group By Operator
                 aggregations:
@@ -1336,11 +1336,11 @@ STAGE PLANS:
                   tag: -1
                   value expressions:
                         expr: _col1
-                        type: decimal(65,30)
+                        type: decimal(38,18)
                         expr: _col2
                         type: bigint
                         expr: _col3
-                        type: struct<count:bigint,sum:decimal(65,30)>
+                        type: struct<count:bigint,sum:decimal(38,18)>
       Reduce Operator Tree:
         Group By Operator
           aggregations:
@@ -1358,9 +1358,9 @@ STAGE PLANS:
                   expr: _col0
                   type: int
                   expr: (_col1 / _col2)
-                  type: decimal(65,30)
+                  type: decimal(38,38)
                   expr: _col3
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0, _col1, _col2
             File Output Operator
               compressed: false
@@ -1385,9 +1385,9 @@ STAGE PLANS:
                     expr: _col0
                     type: int
                     expr: _col1
-                    type: decimal(65,30)
+                    type: decimal(38,38)
                     expr: _col2
-                    type: decimal(65,30)
+                    type: decimal(38,18)
       Reduce Operator Tree:
         Extract
           File Output Operator
@@ -1411,23 +1411,23 @@ POSTHOOK: query: SELECT value, sum(key) 
 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.025384615384615384615384615385	0.025384615384615384615384615385
-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
+-1234567890	NULL	-1234567890.123456789
+-1255	NULL	-1255.49
+-11	NULL	-1.122
+-1	NULL	-1.12
+0	NULL	0.025384615384615385
+1	NULL	1.0484
+2	NULL	2
+3	NULL	3.14
+4	NULL	3.14
+10	NULL	10
+20	NULL	20
+100	NULL	100
+124	NULL	124
+125	NULL	125.2
+200	NULL	200
+4400	NULL	-4400
+1234567890	NULL	1234567890.12345678
 PREHOOK: query: -- negative
 EXPLAIN SELECT -key FROM DECIMAL_UDF
 PREHOOK: type: QUERY
@@ -1450,7 +1450,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: (- key)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -1498,7 +1498,7 @@ NULL
 -3.14
 -3.14
 -3.14
--0.9999999999999999999999999
+-1
 1234567890.123456789
 -1234567890.12345678
 PREHOOK: query: -- positive
@@ -1523,7 +1523,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: key
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -1571,7 +1571,7 @@ NULL
 3.14
 3.14
 3.14
-0.9999999999999999999999999
+1
 -1234567890.123456789
 1234567890.12345678
 PREHOOK: query: -- ceiling
@@ -1596,7 +1596,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: ceil(key)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -1669,7 +1669,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: floor(key)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -1717,7 +1717,7 @@ NULL
 3
 3
 3
-0
+1
 -1234567891
 1234567890
 PREHOOK: query: -- round
@@ -1742,7 +1742,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: round(key, 2)
-                  type: decimal(38,2)
+                  type: decimal(23,2)
             outputColumnNames: _col0
             ListSink
 
@@ -1815,7 +1815,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: power(key, 2)
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             ListSink
 
@@ -1863,7 +1863,7 @@ NULL
 9.8596
 9.8596
 9.8596
-NULL
+1
 1524157875323883675.019051998750190521
 1524157875323883652.7968299765279684
 PREHOOK: query: -- modulo
@@ -1888,7 +1888,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: ((key + 1) % (key / 2))
-                  type: decimal(65,30)
+                  type: decimal(38,20)
             outputColumnNames: _col0
             ListSink
 
@@ -1936,7 +1936,7 @@ NULL
 1
 1
 1
-0.0000000000000000000000001
+0
 -617283944.0617283945
 1
 PREHOOK: query: -- stddev, var
@@ -1964,7 +1964,7 @@ STAGE PLANS:
                     expr: value
                     type: int
                     expr: key
-                    type: decimal(65,30)
+                    type: decimal(38,18)
               outputColumnNames: value, key
               Group By Operator
                 aggregations:
@@ -2073,7 +2073,7 @@ STAGE PLANS:
                     expr: value
                     type: int
                     expr: key
-                    type: decimal(65,30)
+                    type: decimal(38,18)
               outputColumnNames: value, key
               Group By Operator
                 aggregations:
@@ -2180,7 +2180,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal(65,30)
+                    type: decimal(38,18)
               outputColumnNames: key
               Group By Operator
                 aggregations:
@@ -2251,7 +2251,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal(65,30)
+                    type: decimal(38,18)
               outputColumnNames: key
               Group By Operator
                 aggregations:
@@ -2264,7 +2264,7 @@ STAGE PLANS:
                   tag: -1
                   value expressions:
                         expr: _col0
-                        type: decimal(65,30)
+                        type: decimal(38,18)
       Reduce Operator Tree:
         Group By Operator
           aggregations:
@@ -2275,7 +2275,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: _col0
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             File Output Operator
               compressed: false
@@ -2322,7 +2322,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal(65,30)
+                    type: decimal(38,18)
               outputColumnNames: key
               Group By Operator
                 aggregations:
@@ -2335,7 +2335,7 @@ STAGE PLANS:
                   tag: -1
                   value expressions:
                         expr: _col0
-                        type: decimal(65,30)
+                        type: decimal(38,18)
       Reduce Operator Tree:
         Group By Operator
           aggregations:
@@ -2346,7 +2346,7 @@ STAGE PLANS:
           Select Operator
             expressions:
                   expr: _col0
-                  type: decimal(65,30)
+                  type: decimal(38,18)
             outputColumnNames: _col0
             File Output Operator
               compressed: false
@@ -2393,7 +2393,7 @@ STAGE PLANS:
             Select Operator
               expressions:
                     expr: key
-                    type: decimal(65,30)
+                    type: decimal(38,18)
               outputColumnNames: key
               Group By Operator
                 aggregations:

Modified: hive/branches/tez/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out Tue Nov 26 08:19:25 2013
@@ -26,6 +26,8 @@ STAGE PLANS:
         src 
           TableScan
             alias: src
+            Statistics:
+                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -34,11 +36,15 @@ STAGE PLANS:
                     expr: value
                     type: string
               outputColumnNames: _col0, _col1
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
               Reduce Output Operator
                 sort order: 
                 Map-reduce partition columns:
                       expr: UDFToInteger(_col0)
                       type: int
+                Statistics:
+                    numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
                 tag: -1
                 value expressions:
                       expr: _col0
@@ -95,6 +101,8 @@ STAGE PLANS:
       Needs Tagging: false
       Reduce Operator Tree:
         Extract
+          Statistics:
+              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
           Select Operator
             expressions:
                   expr: UDFToInteger(_col0)
@@ -102,11 +110,15 @@ STAGE PLANS:
                   expr: _col1
                   type: string
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 2
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/branches/tez/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out Tue Nov 26 08:19:25 2013
@@ -67,17 +67,23 @@ STAGE PLANS:
         dynamic_part_table 
           TableScan
             alias: dynamic_part_table
+            Statistics:
+                numRows: 1 dataSize: 1 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
                     expr: intcol
                     type: int
               outputColumnNames: _col0
+              Statistics:
+                  numRows: 1 dataSize: 1 basicStatsState: COMPLETE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
 #### A masked pattern was here ####
                 NumFilesPerFileSink: 1
+                Statistics:
+                    numRows: 1 dataSize: 1 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -112,9 +118,9 @@ STAGE PLANS:
 #### A masked pattern was here ####
               name default.dynamic_part_table
               numFiles 1
-              numRows 0
+              numRows 1
               partition_columns partcol1/partcol2
-              rawDataSize 0
+              rawDataSize 1
               serialization.ddl struct dynamic_part_table { i32 intcol}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -168,17 +174,23 @@ STAGE PLANS:
         dynamic_part_table 
           TableScan
             alias: dynamic_part_table
+            Statistics:
+                numRows: 1 dataSize: 1 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
                     expr: intcol
                     type: int
               outputColumnNames: _col0
+              Statistics:
+                  numRows: 1 dataSize: 1 basicStatsState: COMPLETE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
 #### A masked pattern was here ####
                 NumFilesPerFileSink: 1
+                Statistics:
+                    numRows: 1 dataSize: 1 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -213,9 +225,9 @@ STAGE PLANS:
 #### A masked pattern was here ####
               name default.dynamic_part_table
               numFiles 1
-              numRows 0
+              numRows 1
               partition_columns partcol1/partcol2
-              rawDataSize 0
+              rawDataSize 1
               serialization.ddl struct dynamic_part_table { i32 intcol}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -269,17 +281,23 @@ STAGE PLANS:
         dynamic_part_table 
           TableScan
             alias: dynamic_part_table
+            Statistics:
+                numRows: 2 dataSize: 2 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
                     expr: intcol
                     type: int
               outputColumnNames: _col0
+              Statistics:
+                  numRows: 2 dataSize: 2 basicStatsState: COMPLETE colStatsState: NONE
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
 #### A masked pattern was here ####
                 NumFilesPerFileSink: 1
+                Statistics:
+                    numRows: 2 dataSize: 2 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -314,9 +332,9 @@ STAGE PLANS:
 #### A masked pattern was here ####
               name default.dynamic_part_table
               numFiles 1
-              numRows 0
+              numRows 1
               partition_columns partcol1/partcol2
-              rawDataSize 0
+              rawDataSize 1
               serialization.ddl struct dynamic_part_table { i32 intcol}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -356,9 +374,9 @@ STAGE PLANS:
 #### A masked pattern was here ####
               name default.dynamic_part_table
               numFiles 1
-              numRows 0
+              numRows 1
               partition_columns partcol1/partcol2
-              rawDataSize 0
+              rawDataSize 1
               serialization.ddl struct dynamic_part_table { i32 intcol}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

Modified: hive/branches/tez/ql/src/test/results/clientpositive/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/filter_join_breaktask.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/filter_join_breaktask.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/filter_join_breaktask.q.out Tue Nov 26 08:19:25 2013
@@ -42,12 +42,16 @@ STAGE PLANS:
         f 
           TableScan
             alias: f
+            Statistics:
+                numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: key is not null
                   type: boolean
+              Statistics:
+                  numRows: 12 dataSize: 96 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -56,6 +60,8 @@ STAGE PLANS:
                 Map-reduce partition columns:
                       expr: key
                       type: int
+                Statistics:
+                    numRows: 12 dataSize: 96 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 0
                 value expressions:
                       expr: key
@@ -63,12 +69,16 @@ STAGE PLANS:
         m 
           TableScan
             alias: m
+            Statistics:
+                numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: ((key is not null and value is not null) and (value <> ''))
                   type: boolean
+              Statistics:
+                  numRows: 12 dataSize: 96 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: key
@@ -77,6 +87,8 @@ STAGE PLANS:
                 Map-reduce partition columns:
                       expr: key
                       type: int
+                Statistics:
+                    numRows: 12 dataSize: 96 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 1
                 value expressions:
                       expr: value
@@ -137,6 +149,8 @@ STAGE PLANS:
             1 {VALUE._col1}
           handleSkewJoin: false
           outputColumnNames: _col0, _col6
+          Statistics:
+              numRows: 72 dataSize: 1152 basicStatsState: COMPLETE colStatsState: NONE
           File Output Operator
             compressed: false
             GlobalTableId: 0
@@ -169,6 +183,8 @@ STAGE PLANS:
               Map-reduce partition columns:
                     expr: _col6
                     type: string
+              Statistics:
+                  numRows: 72 dataSize: 1152 basicStatsState: COMPLETE colStatsState: NONE
               tag: 0
               value expressions:
                     expr: _col0
@@ -176,12 +192,16 @@ STAGE PLANS:
         g 
           TableScan
             alias: g
+            Statistics:
+                numRows: 25 dataSize: 211 basicStatsState: COMPLETE colStatsState: NONE
             GatherStats: false
             Filter Operator
               isSamplingPred: false
               predicate:
                   expr: (value <> '')
                   type: boolean
+              Statistics:
+                  numRows: 12 dataSize: 96 basicStatsState: COMPLETE colStatsState: NONE
               Reduce Output Operator
                 key expressions:
                       expr: value
@@ -190,6 +210,8 @@ STAGE PLANS:
                 Map-reduce partition columns:
                       expr: value
                       type: string
+                Statistics:
+                    numRows: 12 dataSize: 96 basicStatsState: COMPLETE colStatsState: NONE
                 tag: 1
                 value expressions:
                       expr: value
@@ -271,6 +293,8 @@ STAGE PLANS:
             1 {VALUE._col1}
           handleSkewJoin: false
           outputColumnNames: _col0, _col11
+          Statistics:
+              numRows: 432 dataSize: 10368 basicStatsState: COMPLETE colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -278,11 +302,15 @@ STAGE PLANS:
                   expr: _col11
                   type: string
             outputColumnNames: _col0, _col1
+            Statistics:
+                numRows: 432 dataSize: 10368 basicStatsState: COMPLETE colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 0
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 432 dataSize: 10368 basicStatsState: COMPLETE colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Tue Nov 26 08:19:25 2013
@@ -32,6 +32,8 @@ STAGE PLANS:
         src 
           TableScan
             alias: src
+            Statistics:
+                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -40,6 +42,8 @@ STAGE PLANS:
                     expr: value
                     type: string
               outputColumnNames: key, value
+              Statistics:
+                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
               Group By Operator
                 aggregations:
                       expr: count(DISTINCT substr(value, 5))
@@ -52,6 +56,8 @@ STAGE PLANS:
                       type: string
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics:
+                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -62,6 +68,8 @@ STAGE PLANS:
                   Map-reduce partition columns:
                         expr: _col0
                         type: string
+                  Statistics:
+                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col2
@@ -170,6 +178,8 @@ STAGE PLANS:
                 type: string
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2
+          Statistics:
+              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -179,11 +189,15 @@ STAGE PLANS:
                   expr: concat(_col0, _col2)
                   type: string
             outputColumnNames: _col0, _col1, _col2
+            Statistics:
+                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out?rev=1545564&r1=1545563&r2=1545564&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out Tue Nov 26 08:19:25 2013
@@ -32,6 +32,8 @@ STAGE PLANS:
         src 
           TableScan
             alias: src
+            Statistics:
+                numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
             GatherStats: false
             Select Operator
               expressions:
@@ -40,6 +42,8 @@ STAGE PLANS:
                     expr: value
                     type: string
               outputColumnNames: key, value
+              Statistics:
+                  numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
               Group By Operator
                 aggregations:
                       expr: count(DISTINCT substr(value, 5))
@@ -56,6 +60,8 @@ STAGE PLANS:
                       type: string
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+                Statistics:
+                    numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                 Reduce Output Operator
                   key expressions:
                         expr: _col0
@@ -68,6 +74,8 @@ STAGE PLANS:
                   Map-reduce partition columns:
                         expr: _col0
                         type: string
+                  Statistics:
+                      numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE
                   tag: -1
                   value expressions:
                         expr: _col3
@@ -182,6 +190,8 @@ STAGE PLANS:
                 type: string
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2, _col3, _col4
+          Statistics:
+              numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
           Select Operator
             expressions:
                   expr: _col0
@@ -195,11 +205,15 @@ STAGE PLANS:
                   expr: UDFToInteger(_col4)
                   type: int
             outputColumnNames: _col0, _col1, _col2, _col3, _col4
+            Statistics:
+                numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
             File Output Operator
               compressed: false
               GlobalTableId: 1
 #### A masked pattern was here ####
               NumFilesPerFileSink: 1
+              Statistics:
+                  numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE
 #### A masked pattern was here ####
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat



Mime
View raw message