You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/26 09:19:34 UTC
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/...
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