You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2013/10/28 19:44:09 UTC
svn commit: r1536480 [9/12] - in /hive/branches/maven: ./
ant/src/org/apache/hadoop/hive/ant/ common/src/java/conf/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/test/org/apache/hadoop/hive/common/type/ data/files/
hcatalog/core/src/ma...
Modified: hive/branches/maven/ql/src/test/results/clientpositive/decimal_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/decimal_2.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/decimal_2.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/decimal_2.q.out Mon Oct 28 18:44:01 2013
@@ -2,9 +2,9 @@ PREHOOK: query: drop table decimal_2
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table decimal_2
POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table decimal_2 (t decimal)
+PREHOOK: query: create table decimal_2 (t decimal(18,9))
PREHOOK: type: CREATETABLE
-POSTHOOK: query: create table decimal_2 (t decimal)
+POSTHOOK: query: create table decimal_2 (t decimal(18,9))
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@decimal_2
PREHOOK: query: alter table decimal_2 set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe'
@@ -16,12 +16,12 @@ POSTHOOK: type: ALTERTABLE_SERIALIZER
POSTHOOK: Input: default@decimal_2
POSTHOOK: Output: default@decimal_2
PREHOOK: query: insert overwrite table decimal_2
- select cast('17.29' as decimal) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@decimal_2
POSTHOOK: query: insert overwrite table decimal_2
- select cast('17.29' as decimal) from src limit 1
+ select cast('17.29' as decimal(4,2)) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@decimal_2
@@ -107,12 +107,12 @@ POSTHOOK: Input: default@decimal_2
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
17.29
PREHOOK: query: insert overwrite table decimal_2
- select cast('3404045.5044003' as decimal) from src limit 1
+ select cast('3404045.5044003' as decimal(18,9)) from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@decimal_2
POSTHOOK: query: insert overwrite table decimal_2
- select cast('3404045.5044003' as decimal) from src limit 1
+ select cast('3404045.5044003' as decimal(18,9)) from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@decimal_2
@@ -206,33 +206,33 @@ POSTHOOK: Input: default@decimal_2
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3404045.5044003
-PREHOOK: query: select cast(3.14 as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(3.14 as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(3.14 as decimal(4,2)) from decimal_2 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3.14
-PREHOOK: query: select cast(cast(3.14 as float) as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast(3.14 as float) as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(cast(3.14 as float) as decimal(4,2)) from decimal_2 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3.14
-PREHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as decimal(30,8)) from decimal_2 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
@@ -294,22 +294,22 @@ POSTHOOK: Input: default@decimal_2
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
3
-PREHOOK: query: select cast(0.99999999999999999999 as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast(0.99999999999999999999 as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) from decimal_2 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
POSTHOOK: Lineage: decimal_2.t EXPRESSION []
1
-PREHOOK: query: select cast('0.99999999999999999999' as decimal) from decimal_2 limit 1
+PREHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-POSTHOOK: query: select cast('0.99999999999999999999' as decimal) from decimal_2 limit 1
+POSTHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
Modified: hive/branches/maven/ql/src/test/results/clientpositive/decimal_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/decimal_3.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/decimal_3.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/decimal_3.q.out Mon Oct 28 18:44:01 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, value int)
+PREHOOK: query: CREATE TABLE DECIMAL_3(key decimal(65,30), value int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_3(key decimal, value int)
+POSTHOOK: query: CREATE TABLE DECIMAL_3(key decimal(65,30), value int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
@@ -28,7 +28,6 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL 0
-NULL 0
-1234567890.123456789 -1234567890
-4400 4400
-1255.49 -1255
@@ -40,6 +39,7 @@ NULL 0
-0.3 0
0 0
0 0
+0 0
0.01 0
0.02 0
0.1 0
@@ -100,6 +100,7 @@ POSTHOOK: Input: default@decimal_3
0.01 0
0 0
0 0
+0 0
-0.3 0
-0.33 0
-0.333 0
@@ -110,7 +111,6 @@ POSTHOOK: Input: default@decimal_3
-4400 4400
-1234567890.123456789 -1234567890
NULL 0
-NULL 0
PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -120,7 +120,6 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL 0
-NULL 0
-1234567890.123456789 -1234567890
-4400 4400
-1255.49 -1255
@@ -132,6 +131,7 @@ NULL 0
-0.3 0
0 0
0 0
+0 0
0.01 0
0.02 0
0.1 0
@@ -281,6 +281,11 @@ POSTHOOK: Input: default@decimal_3
0 0 0 0
0 0 0 0
0 0 0 0
+0 0 0 0
+0 0 0 0
+0 0 0 0
+0 0 0 0
+0 0 0 0
0.01 0 0.01 0
0.02 0 0.02 0
0.1 0 0.1 0
Modified: hive/branches/maven/ql/src/test/results/clientpositive/decimal_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/decimal_4.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/decimal_4.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/decimal_4.q.out Mon Oct 28 18:44:01 2013
@@ -6,21 +6,21 @@ PREHOOK: query: DROP TABLE IF EXISTS DEC
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_2
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE DECIMAL_4_1(key decimal, value int)
+PREHOOK: query: CREATE TABLE DECIMAL_4_1(key decimal(35,25), value int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_4_1(key decimal, value int)
+POSTHOOK: query: CREATE TABLE DECIMAL_4_1(key decimal(35,25), value int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_4_1
-PREHOOK: query: CREATE TABLE DECIMAL_4_2(key decimal, value decimal)
+PREHOOK: query: CREATE TABLE DECIMAL_4_2(key decimal(35,25), value decimal(35,25))
STORED AS ORC
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_4_2(key decimal, value decimal)
+POSTHOOK: query: CREATE TABLE DECIMAL_4_2(key decimal(35,25), value decimal(35,25))
STORED AS ORC
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@DECIMAL_4_2
@@ -38,8 +38,8 @@ POSTHOOK: query: INSERT OVERWRITE TABLE
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_1
POSTHOOK: Output: default@decimal_4_2
-POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
-POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
+POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
+POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
PREHOOK: query: SELECT * FROM DECIMAL_4_1 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_4_1
@@ -48,9 +48,8 @@ POSTHOOK: query: SELECT * FROM DECIMAL_4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_1
#### A masked pattern was here ####
-POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
-POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
-NULL 0
+POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
+POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
NULL 0
-1234567890.123456789 -1234567890
-4400 4400
@@ -63,6 +62,7 @@ NULL 0
-0.3 0
0 0
0 0
+0 0
0.01 0
0.02 0
0.1 0
@@ -96,9 +96,8 @@ POSTHOOK: query: SELECT * FROM DECIMAL_4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_2
#### A masked pattern was here ####
-POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
-POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
-NULL NULL
+POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
+POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
NULL NULL
-1234567890.123456789 -3703703670.370370367
-4400 -13200
@@ -111,6 +110,7 @@ NULL NULL
-0.3 -0.9
0 0
0 0
+0 0
0.01 0.03
0.02 0.06
0.1 0.3
@@ -144,8 +144,8 @@ POSTHOOK: query: DROP TABLE DECIMAL_4_1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@decimal_4_1
POSTHOOK: Output: default@decimal_4_1
-POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
-POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
+POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
+POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
PREHOOK: query: DROP TABLE DECIMAL_4_2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_4_2
@@ -154,5 +154,5 @@ POSTHOOK: query: DROP TABLE DECIMAL_4_2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@decimal_4_2
POSTHOOK: Output: default@decimal_4_2
-POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
-POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]
+POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
+POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
Modified: hive/branches/maven/ql/src/test/results/clientpositive/decimal_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/decimal_join.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/decimal_join.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/decimal_join.q.out Mon Oct 28 18:44:01 2013
@@ -1,10 +1,10 @@
PREHOOK: query: -- HIVE-5292 Join on decimal columns fails
-create table src_dec (key decimal, value string)
+create table src_dec (key decimal(3,0), value string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: -- HIVE-5292 Join on decimal columns fails
-create table src_dec (key decimal, value string)
+create table src_dec (key decimal(3,0), value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@src_dec
PREHOOK: query: load data local inpath '../../data/files/kv1.txt' into table src_dec
Modified: hive/branches/maven/ql/src/test/results/clientpositive/decimal_precision.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/decimal_precision.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/decimal_precision.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/decimal_precision.q.out Mon Oct 28 18:44:01 2013
@@ -2,12 +2,12 @@ PREHOOK: query: DROP TABLE IF EXISTS DEC
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_PRECISION
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal)
+PREHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(60,30))
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal)
+POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(60,30))
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
@@ -35,28 +35,42 @@ NULL
NULL
NULL
NULL
--99999999999999999999999999999999999999
--999999999999999999999999999999999999
--99999999999999999999999999999999999
--0.0000000000000000000000000000000000001
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+0
+0
+0
+0
0
-0.0000000000000000000000000000000000001
0.123456789012345
-0.1234567890123456789012345678901234578
+0.12345678901234567890123456789
1.234567890123456
-1.2345678901234567890123456789012345678
+1.234567890123456789012345678901
+1.234567890123456789012345678901
12.34567890123456
-12.345678901234567890123456789012345678
+12.345678901234567890123456789012
+12.345678901234567890123456789012
123.4567890123456
-123.45678901234567890123456789012345678
+123.456789012345678901234567890123
+123.456789012345678901234567890123
1234.567890123456
-1234.5678901234567890123456789012345678
+1234.567890123456789012345678901235
+1234.567890123456789012345678901235
12345.67890123456
-12345.678901234567890123456789012345678
+12345.678901234567890123456789012346
123456.7890123456
-123456.78901234567890123456789012345678
+123456.789012345678901234567890123457
1234567.890123456
-1234567.8901234567890123456789012345678
+1234567.890123456789012345678901234568
12345678.90123456
12345678.901234567890123456789012345678
123456789.0123456
@@ -88,20 +102,6 @@ NULL
1234567890123456789012345678.9012345678
12345678901234567890123456789.012345678
123456789012345678901234567890.12345678
-1234567890123456789012345678901.2345678
-12345678901234567890123456789012.345678
-123456789012345678901234567890123.45678
-1234567890123456789012345678901234.5678
-12345678901234567890123456789012345.678
-99999999999999999999999999999999999
-123456789012345678901234567890123456.78
-999999999999999999999999999999999999
-12345678901234567890123456789012345678
-12345678901234567890123456789012345678
-12345678901234567890123456789012345678
-12345678901234567890123456789012345678
-12345678901234567890123456789012345678
-99999999999999999999999999999999999999
PREHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -118,28 +118,42 @@ NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
--99999999999999999999999999999999999999 -99999999999999999999999999999999999998 NULL
--999999999999999999999999999999999999 -999999999999999999999999999999999998 -1000000000000000000000000000000000000
--99999999999999999999999999999999999 -99999999999999999999999999999999998 -100000000000000000000000000000000000
--0.0000000000000000000000000000000000001 0.9999999999999999999999999999999999999 -1.0000000000000000000000000000000000001
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+0 1 -1
+0 1 -1
+0 1 -1
+0 1 -1
0 1 -1
-0.0000000000000000000000000000000000001 1.0000000000000000000000000000000000001 -0.9999999999999999999999999999999999999
0.123456789012345 1.123456789012345 -0.876543210987655
-0.1234567890123456789012345678901234578 1.1234567890123456789012345678901234578 -0.8765432109876543210987654321098765422
+0.12345678901234567890123456789 1.12345678901234567890123456789 -0.87654321098765432109876543211
1.234567890123456 2.234567890123456 0.234567890123456
-1.2345678901234567890123456789012345678 2.2345678901234567890123456789012345678 0.2345678901234567890123456789012345678
+1.234567890123456789012345678901 2.234567890123456789012345678901 0.234567890123456789012345678901
+1.234567890123456789012345678901 2.234567890123456789012345678901 0.234567890123456789012345678901
12.34567890123456 13.34567890123456 11.34567890123456
-12.345678901234567890123456789012345678 13.345678901234567890123456789012345678 11.345678901234567890123456789012345678
+12.345678901234567890123456789012 13.345678901234567890123456789012 11.345678901234567890123456789012
+12.345678901234567890123456789012 13.345678901234567890123456789012 11.345678901234567890123456789012
123.4567890123456 124.4567890123456 122.4567890123456
-123.45678901234567890123456789012345678 124.45678901234567890123456789012345678 122.45678901234567890123456789012345678
+123.456789012345678901234567890123 124.456789012345678901234567890123 122.456789012345678901234567890123
+123.456789012345678901234567890123 124.456789012345678901234567890123 122.456789012345678901234567890123
1234.567890123456 1235.567890123456 1233.567890123456
-1234.5678901234567890123456789012345678 1235.5678901234567890123456789012345678 1233.5678901234567890123456789012345678
+1234.567890123456789012345678901235 1235.567890123456789012345678901235 1233.567890123456789012345678901235
+1234.567890123456789012345678901235 1235.567890123456789012345678901235 1233.567890123456789012345678901235
12345.67890123456 12346.67890123456 12344.67890123456
-12345.678901234567890123456789012345678 12346.678901234567890123456789012345678 12344.678901234567890123456789012345678
+12345.678901234567890123456789012346 12346.678901234567890123456789012346 12344.678901234567890123456789012346
123456.7890123456 123457.7890123456 123455.7890123456
-123456.78901234567890123456789012345678 123457.78901234567890123456789012345678 123455.78901234567890123456789012345678
+123456.789012345678901234567890123457 123457.789012345678901234567890123457 123455.789012345678901234567890123457
1234567.890123456 1234568.890123456 1234566.890123456
-1234567.8901234567890123456789012345678 1234568.8901234567890123456789012345678 1234566.8901234567890123456789012345678
+1234567.890123456789012345678901234568 1234568.890123456789012345678901234568 1234566.890123456789012345678901234568
12345678.90123456 12345679.90123456 12345677.90123456
12345678.901234567890123456789012345678 12345679.901234567890123456789012345678 12345677.901234567890123456789012345678
123456789.0123456 123456790.0123456 123456788.0123456
@@ -171,20 +185,6 @@ NULL NULL NULL
1234567890123456789012345678.9012345678 1234567890123456789012345679.9012345678 1234567890123456789012345677.9012345678
12345678901234567890123456789.012345678 12345678901234567890123456790.012345678 12345678901234567890123456788.012345678
123456789012345678901234567890.12345678 123456789012345678901234567891.12345678 123456789012345678901234567889.12345678
-1234567890123456789012345678901.2345678 1234567890123456789012345678902.2345678 1234567890123456789012345678900.2345678
-12345678901234567890123456789012.345678 12345678901234567890123456789013.345678 12345678901234567890123456789011.345678
-123456789012345678901234567890123.45678 123456789012345678901234567890124.45678 123456789012345678901234567890122.45678
-1234567890123456789012345678901234.5678 1234567890123456789012345678901235.5678 1234567890123456789012345678901233.5678
-12345678901234567890123456789012345.678 12345678901234567890123456789012346.678 12345678901234567890123456789012344.678
-99999999999999999999999999999999999 100000000000000000000000000000000000 99999999999999999999999999999999998
-123456789012345678901234567890123456.78 123456789012345678901234567890123457.78 123456789012345678901234567890123455.78
-999999999999999999999999999999999999 1000000000000000000000000000000000000 999999999999999999999999999999999998
-12345678901234567890123456789012345678 12345678901234567890123456789012345679 12345678901234567890123456789012345677
-12345678901234567890123456789012345678 12345678901234567890123456789012345679 12345678901234567890123456789012345677
-12345678901234567890123456789012345678 12345678901234567890123456789012345679 12345678901234567890123456789012345677
-12345678901234567890123456789012345678 12345678901234567890123456789012345679 12345678901234567890123456789012345677
-12345678901234567890123456789012345678 12345678901234567890123456789012345679 12345678901234567890123456789012345677
-99999999999999999999999999999999999999 NULL 99999999999999999999999999999999999998
PREHOOK: query: SELECT dec, dec * 2, dec / 3 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -201,28 +201,42 @@ NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
--99999999999999999999999999999999999999 NULL -33333333333333333333333333333333333333
--999999999999999999999999999999999999 -1999999999999999999999999999999999998 -333333333333333333333333333333333333
--99999999999999999999999999999999999 -199999999999999999999999999999999998 -33333333333333333333333333333333333
--0.0000000000000000000000000000000000001 -0.0000000000000000000000000000000000002 0
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+NULL NULL NULL
+0 0 0
+0 0 0
+0 0 0
+0 0 0
0 0 0
-0.0000000000000000000000000000000000001 0.0000000000000000000000000000000000002 0
0.123456789012345 0.24691357802469 0.041152263004115
-0.1234567890123456789012345678901234578 0.2469135780246913578024691357802469156 0.0411522630041152263004115226300411526
+0.12345678901234567890123456789 0.24691357802469135780246913578 0.04115226300411522630041152263
1.234567890123456 2.469135780246912 0.411522630041152
-1.2345678901234567890123456789012345678 2.4691357802469135780246913578024691356 0.4115226300411522630041152263004115226
+1.234567890123456789012345678901 2.469135780246913578024691357802 0.4115226300411522630041152263
+1.234567890123456789012345678901 2.469135780246913578024691357802 0.4115226300411522630041152263
12.34567890123456 24.69135780246912 4.11522630041152
-12.345678901234567890123456789012345678 24.691357802469135780246913578024691356 4.115226300411522630041152263004115226
+12.345678901234567890123456789012 24.691357802469135780246913578024 4.115226300411522630041152263004
+12.345678901234567890123456789012 24.691357802469135780246913578024 4.115226300411522630041152263004
123.4567890123456 246.9135780246912 41.1522630041152
-123.45678901234567890123456789012345678 246.91357802469135780246913578024691356 41.15226300411522630041152263004115226
+123.456789012345678901234567890123 246.913578024691357802469135780246 41.152263004115226300411522630041
+123.456789012345678901234567890123 246.913578024691357802469135780246 41.152263004115226300411522630041
1234.567890123456 2469.135780246912 411.522630041152
-1234.5678901234567890123456789012345678 2469.1357802469135780246913578024691356 411.5226300411522630041152263004115226
+1234.567890123456789012345678901235 2469.13578024691357802469135780247 411.522630041152263004115226300412
+1234.567890123456789012345678901235 2469.13578024691357802469135780247 411.522630041152263004115226300412
12345.67890123456 24691.35780246912 4115.22630041152
-12345.678901234567890123456789012345678 24691.357802469135780246913578024691356 4115.226300411522630041152263004115226
+12345.678901234567890123456789012346 24691.357802469135780246913578024692 4115.226300411522630041152263004115
123456.7890123456 246913.5780246912 41152.2630041152
-123456.78901234567890123456789012345678 246913.57802469135780246913578024691356 41152.26300411522630041152263004115226
+123456.789012345678901234567890123457 246913.578024691357802469135780246914 41152.263004115226300411522630041152
1234567.890123456 2469135.780246912 411522.630041152
-1234567.8901234567890123456789012345678 2469135.7802469135780246913578024691356 411522.6300411522630041152263004115226
+1234567.890123456789012345678901234568 2469135.780246913578024691357802469136 411522.630041152263004115226300411523
12345678.90123456 24691357.80246912 4115226.30041152
12345678.901234567890123456789012345678 24691357.802469135780246913578024691356 4115226.300411522630041152263004115226
123456789.0123456 246913578.0246912 41152263.0041152
@@ -254,20 +268,6 @@ NULL NULL NULL
1234567890123456789012345678.9012345678 2469135780246913578024691357.8024691356 411522630041152263004115226.3004115226
12345678901234567890123456789.012345678 24691357802469135780246913578.024691356 4115226300411522630041152263.004115226
123456789012345678901234567890.12345678 246913578024691357802469135780.24691356 41152263004115226300411522630.04115226
-1234567890123456789012345678901.2345678 2469135780246913578024691357802.4691356 411522630041152263004115226300.4115226
-12345678901234567890123456789012.345678 24691357802469135780246913578024.691356 4115226300411522630041152263004.115226
-123456789012345678901234567890123.45678 246913578024691357802469135780246.91356 41152263004115226300411522630041.15226
-1234567890123456789012345678901234.5678 2469135780246913578024691357802469.1356 411522630041152263004115226300411.5226
-12345678901234567890123456789012345.678 24691357802469135780246913578024691.356 4115226300411522630041152263004115.226
-99999999999999999999999999999999999 199999999999999999999999999999999998 33333333333333333333333333333333333
-123456789012345678901234567890123456.78 246913578024691357802469135780246913.56 41152263004115226300411522630041152.26
-999999999999999999999999999999999999 1999999999999999999999999999999999998 333333333333333333333333333333333333
-12345678901234567890123456789012345678 24691357802469135780246913578024691356 4115226300411522630041152263004115226
-12345678901234567890123456789012345678 24691357802469135780246913578024691356 4115226300411522630041152263004115226
-12345678901234567890123456789012345678 24691357802469135780246913578024691356 4115226300411522630041152263004115226
-12345678901234567890123456789012345678 24691357802469135780246913578024691356 4115226300411522630041152263004115226
-12345678901234567890123456789012345678 24691357802469135780246913578024691356 4115226300411522630041152263004115226
-99999999999999999999999999999999999999 NULL 33333333333333333333333333333333333333
PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -284,43 +284,57 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
--99999999999999999999999999999999999999 -11111111111111111111111111111111111111
--999999999999999999999999999999999999 -111111111111111111111111111111111111
--99999999999999999999999999999999999 -11111111111111111111111111111111111
--0.0000000000000000000000000000000000001 0
-0 0
-0.0000000000000000000000000000000000001 0
-0.123456789012345 0.0137174210013716666666666666666666667
-0.1234567890123456789012345678901234578 0.0137174210013717421001371742100137175
-1.234567890123456 0.1371742100137173333333333333333333333
-1.2345678901234567890123456789012345678 0.1371742100137174210013717421001371742
-12.34567890123456 1.3717421001371733333333333333333333333
-12.345678901234567890123456789012345678 1.371742100137174210013717421001371742
-123.4567890123456 13.717421001371733333333333333333333333
-123.45678901234567890123456789012345678 13.71742100137174210013717421001371742
-1234.567890123456 137.17421001371733333333333333333333333
-1234.5678901234567890123456789012345678 137.1742100137174210013717421001371742
-12345.67890123456 1371.7421001371733333333333333333333333
-12345.678901234567890123456789012345678 1371.742100137174210013717421001371742
-123456.7890123456 13717.421001371733333333333333333333333
-123456.78901234567890123456789012345678 13717.42100137174210013717421001371742
-1234567.890123456 137174.21001371733333333333333333333333
-1234567.8901234567890123456789012345678 137174.2100137174210013717421001371742
-12345678.90123456 1371742.1001371733333333333333333333333
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+0 0
+0 0
+0 0
+0 0
+0 0
+0.123456789012345 0.013717421001371666666666666667
+0.12345678901234567890123456789 0.01371742100137174210013717421
+1.234567890123456 0.137174210013717333333333333333
+1.234567890123456789012345678901 0.1371742100137174210013717421
+1.234567890123456789012345678901 0.1371742100137174210013717421
+12.34567890123456 1.371742100137173333333333333333
+12.345678901234567890123456789012 1.371742100137174210013717421001
+12.345678901234567890123456789012 1.371742100137174210013717421001
+123.4567890123456 13.717421001371733333333333333333
+123.456789012345678901234567890123 13.717421001371742100137174210014
+123.456789012345678901234567890123 13.717421001371742100137174210014
+1234.567890123456 137.174210013717333333333333333333
+1234.567890123456789012345678901235 137.174210013717421001371742100137
+1234.567890123456789012345678901235 137.174210013717421001371742100137
+12345.67890123456 1371.742100137173333333333333333333
+12345.678901234567890123456789012346 1371.742100137174210013717421001372
+123456.7890123456 13717.421001371733333333333333333333
+123456.789012345678901234567890123457 13717.421001371742100137174210013717
+1234567.890123456 137174.210013717333333333333333333333
+1234567.890123456789012345678901234568 137174.210013717421001371742100137174
+12345678.90123456 1371742.100137173333333333333333333333
12345678.901234567890123456789012345678 1371742.100137174210013717421001371742
123456789.0123456 13717421.001371733333333333333333333333
123456789.01234567890123456789012345678 13717421.00137174210013717421001371742
-1234567890.123456 137174210.01371733333333333333333333333
+1234567890.123456 137174210.013717333333333333333333333333
1234567890.1234567890123456789012345678 137174210.0137174210013717421001371742
-12345678901.23456 1371742100.1371733333333333333333333333
+12345678901.23456 1371742100.137173333333333333333333333333
12345678901.234567890123456789012345678 1371742100.137174210013717421001371742
-123456789012.3456 13717421001.371733333333333333333333333
+123456789012.3456 13717421001.371733333333333333333333333333
123456789012.34567890123456789012345678 13717421001.37174210013717421001371742
-1234567890123.456 137174210013.71733333333333333333333333
+1234567890123.456 137174210013.717333333333333333333333333333
1234567890123.4567890123456789012345678 137174210013.7174210013717421001371742
-12345678901234.56 1371742100137.1733333333333333333333333
+12345678901234.56 1371742100137.173333333333333333333333333333
12345678901234.567890123456789012345678 1371742100137.174210013717421001371742
-123456789012345.6 13717421001371.733333333333333333333333
+123456789012345.6 13717421001371.733333333333333333333333333333
123456789012345.67890123456789012345678 13717421001371.74210013717421001371742
1234567890123456.7890123456789012345678 137174210013717.4210013717421001371742
12345678901234567.890123456789012345678 1371742100137174.210013717421001371742
@@ -337,20 +351,6 @@ NULL NULL
1234567890123456789012345678.9012345678 137174210013717421001371742.1001371742
12345678901234567890123456789.012345678 1371742100137174210013717421.001371742
123456789012345678901234567890.12345678 13717421001371742100137174210.01371742
-1234567890123456789012345678901.2345678 137174210013717421001371742100.1371742
-12345678901234567890123456789012.345678 1371742100137174210013717421001.371742
-123456789012345678901234567890123.45678 13717421001371742100137174210013.71742
-1234567890123456789012345678901234.5678 137174210013717421001371742100137.1742
-12345678901234567890123456789012345.678 1371742100137174210013717421001371.742
-99999999999999999999999999999999999 11111111111111111111111111111111111
-123456789012345678901234567890123456.78 13717421001371742100137174210013717.42
-999999999999999999999999999999999999 111111111111111111111111111111111111
-12345678901234567890123456789012345678 1371742100137174210013717421001371742
-12345678901234567890123456789012345678 1371742100137174210013717421001371742
-12345678901234567890123456789012345678 1371742100137174210013717421001371742
-12345678901234567890123456789012345678 1371742100137174210013717421001371742
-12345678901234567890123456789012345678 1371742100137174210013717421001371742
-99999999999999999999999999999999999999 11111111111111111111111111111111111111
PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -367,73 +367,73 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
--99999999999999999999999999999999999999 -3703703703703703703703703703703703703.7
--999999999999999999999999999999999999 -37037037037037037037037037037037037
--99999999999999999999999999999999999 -3703703703703703703703703703703703.6667
--0.0000000000000000000000000000000000001 0
-0 0
-0.0000000000000000000000000000000000001 0
-0.123456789012345 0.0045724736671238888888888888888888889
-0.1234567890123456789012345678901234578 0.0045724736671239140333790580700045725
-1.234567890123456 0.0457247366712391111111111111111111111
-1.2345678901234567890123456789012345678 0.0457247366712391403337905807000457247
-12.34567890123456 0.4572473667123911111111111111111111111
-12.345678901234567890123456789012345678 0.4572473667123914033379058070004572473
-123.4567890123456 4.5724736671239111111111111111111111111
-123.45678901234567890123456789012345678 4.5724736671239140333790580700045724733
-1234.567890123456 45.724736671239111111111111111111111111
-1234.5678901234567890123456789012345678 45.724736671239140333790580700045724733
-12345.67890123456 457.24736671239111111111111111111111111
-12345.678901234567890123456789012345678 457.24736671239140333790580700045724733
-123456.7890123456 4572.4736671239111111111111111111111111
-123456.78901234567890123456789012345678 4572.4736671239140333790580700045724733
-1234567.890123456 45724.736671239111111111111111111111111
-1234567.8901234567890123456789012345678 45724.736671239140333790580700045724733
-12345678.90123456 457247.36671239111111111111111111111111
-12345678.901234567890123456789012345678 457247.36671239140333790580700045724733
-123456789.0123456 4572473.6671239111111111111111111111111
-123456789.01234567890123456789012345678 4572473.6671239140333790580700045724733
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+0 0
+0 0
+0 0
+0 0
+0 0
+0.123456789012345 0.004572473667123888888888888889
+0.12345678901234567890123456789 0.00457247366712391403337905807
+1.234567890123456 0.045724736671239111111111111111
+1.234567890123456789012345678901 0.0457247366712391403337905807
+1.234567890123456789012345678901 0.0457247366712391403337905807
+12.34567890123456 0.457247366712391111111111111111
+12.345678901234567890123456789012 0.457247366712391403337905807
+12.345678901234567890123456789012 0.457247366712391403337905807
+123.4567890123456 4.572473667123911111111111111111
+123.456789012345678901234567890123 4.572473667123914033379058070005
+123.456789012345678901234567890123 4.572473667123914033379058070005
+1234.567890123456 45.724736671239111111111111111111
+1234.567890123456789012345678901235 45.724736671239140333790580700046
+1234.567890123456789012345678901235 45.724736671239140333790580700046
+12345.67890123456 457.247366712391111111111111111111
+12345.678901234567890123456789012346 457.247366712391403337905807000457
+123456.7890123456 4572.473667123911111111111111111111
+123456.789012345678901234567890123457 4572.473667123914033379058070004572
+1234567.890123456 45724.736671239111111111111111111111
+1234567.890123456789012345678901234568 45724.736671239140333790580700045725
+12345678.90123456 457247.366712391111111111111111111111
+12345678.901234567890123456789012345678 457247.366712391403337905807000457247
+123456789.0123456 4572473.667123911111111111111111111111
+123456789.01234567890123456789012345678 4572473.667123914033379058070004572473
1234567890.123456 45724736.671239111111111111111111111111
1234567890.1234567890123456789012345678 45724736.671239140333790580700045724733
-12345678901.23456 457247366.71239111111111111111111111111
-12345678901.234567890123456789012345678 457247366.71239140333790580700045724733
-123456789012.3456 4572473667.1239111111111111111111111111
-123456789012.34567890123456789012345678 4572473667.1239140333790580700045724733
-1234567890123.456 45724736671.239111111111111111111111111
-1234567890123.4567890123456789012345678 45724736671.239140333790580700045724733
-12345678901234.56 457247366712.39111111111111111111111111
-12345678901234.567890123456789012345678 457247366712.39140333790580700045724733
-123456789012345.6 4572473667123.9111111111111111111111111
-123456789012345.67890123456789012345678 4572473667123.9140333790580700045724733
-1234567890123456.7890123456789012345678 45724736671239.140333790580700045724733
-12345678901234567.890123456789012345678 457247366712391.40333790580700045724733
-123456789012345678.90123456789012345678 4572473667123914.0333790580700045724733
-1234567890123456789.0123456789012345678 45724736671239140.333790580700045724733
-12345678901234567890.123456789012345678 457247366712391403.33790580700045724733
-123456789012345678901.23456789012345678 4572473667123914033.3790580700045724733
-1234567890123456789012.3456789012345678 45724736671239140333.790580700045724733
-12345678901234567890123.456789012345678 457247366712391403337.90580700045724733
-123456789012345678901234.56789012345678 4572473667123914033379.0580700045724733
-1234567890123456789012345.6789012345678 45724736671239140333790.580700045724733
-12345678901234567890123456.789012345678 457247366712391403337905.80700045724733
-123456789012345678901234567.89012345678 4572473667123914033379058.0700045724733
-1234567890123456789012345678.9012345678 45724736671239140333790580.700045724733
-12345678901234567890123456789.012345678 457247366712391403337905807.00045724733
-123456789012345678901234567890.12345678 4572473667123914033379058070.0045724733
-1234567890123456789012345678901.2345678 45724736671239140333790580700.045724733
-12345678901234567890123456789012.345678 457247366712391403337905807000.45724733
-123456789012345678901234567890123.45678 4572473667123914033379058070004.5724733
-1234567890123456789012345678901234.5678 45724736671239140333790580700045.724733
-12345678901234567890123456789012345.678 457247366712391403337905807000457.24733
-99999999999999999999999999999999999 3703703703703703703703703703703703.6667
-123456789012345678901234567890123456.78 4572473667123914033379058070004572.4733
-999999999999999999999999999999999999 37037037037037037037037037037037037
-12345678901234567890123456789012345678 457247366712391403337905807000457247.33
-12345678901234567890123456789012345678 457247366712391403337905807000457247.33
-12345678901234567890123456789012345678 457247366712391403337905807000457247.33
-12345678901234567890123456789012345678 457247366712391403337905807000457247.33
-12345678901234567890123456789012345678 457247366712391403337905807000457247.33
-99999999999999999999999999999999999999 3703703703703703703703703703703703703.7
+12345678901.23456 457247366.712391111111111111111111111111
+12345678901.234567890123456789012345678 457247366.712391403337905807000457247333
+123456789012.3456 4572473667.123911111111111111111111111111
+123456789012.34567890123456789012345678 4572473667.123914033379058070004572473333
+1234567890123.456 45724736671.239111111111111111111111111111
+1234567890123.4567890123456789012345678 45724736671.239140333790580700045724733333
+12345678901234.56 457247366712.391111111111111111111111111111
+12345678901234.567890123456789012345678 457247366712.391403337905807000457247333333
+123456789012345.6 4572473667123.911111111111111111111111111111
+123456789012345.67890123456789012345678 4572473667123.914033379058070004572473333333
+1234567890123456.7890123456789012345678 45724736671239.140333790580700045724733333333
+12345678901234567.890123456789012345678 457247366712391.403337905807000457247333333333
+123456789012345678.90123456789012345678 4572473667123914.033379058070004572473333333333
+1234567890123456789.0123456789012345678 45724736671239140.333790580700045724733333333333
+12345678901234567890.123456789012345678 457247366712391403.337905807000457247333333333333
+123456789012345678901.23456789012345678 4572473667123914033.379058070004572473333333333333
+1234567890123456789012.3456789012345678 45724736671239140333.790580700045724733333333333333
+12345678901234567890123.456789012345678 457247366712391403337.905807000457247333333333333333
+123456789012345678901234.56789012345678 4572473667123914033379.058070004572473333333333333333
+1234567890123456789012345.6789012345678 45724736671239140333790.580700045724733333333333333333
+12345678901234567890123456.789012345678 457247366712391403337905.807000457247333333333333333333
+123456789012345678901234567.89012345678 4572473667123914033379058.070004572473333333333333333333
+1234567890123456789012345678.9012345678 45724736671239140333790580.700045724733333333333333333333
+12345678901234567890123456789.012345678 457247366712391403337905807.000457247333333333333333333333
+123456789012345678901234567890.12345678 4572473667123914033379058070.004572473333333333333333333333
PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -450,28 +450,42 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
--99999999999999999999999999999999999999 NULL
--999999999999999999999999999999999999 NULL
--99999999999999999999999999999999999 NULL
--0.0000000000000000000000000000000000001 NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+NULL NULL
+0 0
+0 0
+0 0
+0 0
0 0
-0.0000000000000000000000000000000000001 NULL
0.123456789012345 0.015241578753238669120562399025
-0.1234567890123456789012345678901234578 NULL
+0.12345678901234567890123456789 NULL
1.234567890123456 1.524157875323881726870921383936
-1.2345678901234567890123456789012345678 NULL
+1.234567890123456789012345678901 NULL
+1.234567890123456789012345678901 NULL
12.34567890123456 152.4157875323881726870921383936
-12.345678901234567890123456789012345678 NULL
+12.345678901234567890123456789012 NULL
+12.345678901234567890123456789012 NULL
123.4567890123456 15241.57875323881726870921383936
-123.45678901234567890123456789012345678 NULL
+123.456789012345678901234567890123 NULL
+123.456789012345678901234567890123 NULL
1234.567890123456 1524157.875323881726870921383936
-1234.5678901234567890123456789012345678 NULL
+1234.567890123456789012345678901235 NULL
+1234.567890123456789012345678901235 NULL
12345.67890123456 152415787.5323881726870921383936
-12345.678901234567890123456789012345678 NULL
+12345.678901234567890123456789012346 NULL
123456.7890123456 15241578753.23881726870921383936
-123456.78901234567890123456789012345678 NULL
+123456.789012345678901234567890123457 NULL
1234567.890123456 1524157875323.881726870921383936
-1234567.8901234567890123456789012345678 NULL
+1234567.890123456789012345678901234568 NULL
12345678.90123456 152415787532388.1726870921383936
12345678.901234567890123456789012345678 NULL
123456789.0123456 15241578753238817.26870921383936
@@ -503,20 +517,6 @@ NULL NULL
1234567890123456789012345678.9012345678 NULL
12345678901234567890123456789.012345678 NULL
123456789012345678901234567890.12345678 NULL
-1234567890123456789012345678901.2345678 NULL
-12345678901234567890123456789012.345678 NULL
-123456789012345678901234567890123.45678 NULL
-1234567890123456789012345678901234.5678 NULL
-12345678901234567890123456789012345.678 NULL
-99999999999999999999999999999999999 NULL
-123456789012345678901234567890123456.78 NULL
-999999999999999999999999999999999999 NULL
-12345678901234567890123456789012345678 NULL
-12345678901234567890123456789012345678 NULL
-12345678901234567890123456789012345678 NULL
-12345678901234567890123456789012345678 NULL
-12345678901234567890123456789012345678 NULL
-99999999999999999999999999999999999999 NULL
PREHOOK: query: SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -525,21 +525,21 @@ POSTHOOK: query: SELECT avg(dec), sum(de
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
-NULL NULL
-PREHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal) FROM DECIMAL_PRECISION LIMIT 1
+2449539464530670681706817092.661571403901626461618141287233 137174210013717558175581757189.047998618491081850615912085061
+PREHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal(39,9)) FROM DECIMAL_PRECISION LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal) FROM DECIMAL_PRECISION LIMIT 1
+POSTHOOK: query: SELECT dec * cast('123456789012345678901234567890.123456789' as decimal(39,9)) FROM DECIMAL_PRECISION LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
NULL
-PREHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal) LIMIT 1
+PREHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal(39,9)) LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal) LIMIT 1
+POSTHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('123456789012345678901234567890.123456789' as decimal(39,9)) LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
@@ -552,24 +552,24 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
NULL
-PREHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+PREHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
-POSTHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+POSTHOOK: query: SELECT MIN(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
-NULL
-PREHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+123456789012345678901234567890.123456789
+PREHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
-POSTHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal)) FROM DECIMAL_PRECISION
+POSTHOOK: query: SELECT COUNT(cast('123456789012345678901234567890.123456789' as decimal(39,9))) FROM DECIMAL_PRECISION
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_precision
#### A masked pattern was here ####
-0
+75
PREHOOK: query: DROP TABLE DECIMAL_PRECISION
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_precision
Modified: hive/branches/maven/ql/src/test/results/clientpositive/decimal_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/decimal_serde.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/decimal_serde.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/decimal_serde.q.out Mon Oct 28 18:44:01 2013
@@ -40,43 +40,43 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_text
#### A masked pattern was here ####
NULL 0
-NULL 0
--1234567890.123456789 -1234567890
+-1234567890 -1234567890
-4400 4400
--1255.49 -1255
--1.122 -11
--1.12 -1
--1.12 -1
--0.333 0
--0.33 0
--0.3 0
-0 0
-0 0
-0.01 0
-0.02 0
-0.1 0
-0.2 0
-0.3 0
-0.33 0
-0.333 0
-0.9999999999999999999999999 1
+-1255 -1255
+-1 -11
+-1 -1
+-1 -1
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+1 1
+1 1
+1 1
1 1
1 1
-1.12 1
-1.122 1
2 2
2 2
-3.14 3
-3.14 3
-3.14 3
-3.14 4
+3 3
+3 3
+3 3
+3 4
10 10
20 20
100 100
124 124
-125.2 125
+125 125
200 200
-1234567890.12345678 1234567890
+1234567890 1234567890
PREHOOK: query: CREATE TABLE DECIMAL_RC
STORED AS RCFile AS
SELECT * FROM DECIMAL_TEXT
@@ -129,43 +129,43 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_sequence
#### A masked pattern was here ####
NULL 0
-NULL 0
--1234567890.123456789 -1234567890
+-1234567890 -1234567890
-4400 4400
--1255.49 -1255
--1.122 -11
--1.12 -1
--1.12 -1
--0.333 0
--0.33 0
--0.3 0
-0 0
-0 0
-0.01 0
-0.02 0
-0.1 0
-0.2 0
-0.3 0
-0.33 0
-0.333 0
-0.9999999999999999999999999 1
+-1255 -1255
+-1 -11
+-1 -1
+-1 -1
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+1 1
+1 1
+1 1
1 1
1 1
-1.12 1
-1.122 1
2 2
2 2
-3.14 3
-3.14 3
-3.14 3
-3.14 4
+3 3
+3 3
+3 3
+3 4
10 10
20 20
100 100
124 124
-125.2 125
+125 125
200 200
-1234567890.12345678 1234567890
+1234567890 1234567890
PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_TEXT
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_text
Modified: hive/branches/maven/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/decimal_udf.q.out Mon Oct 28 18:44:01 2013
@@ -2,12 +2,12 @@ PREHOOK: query: DROP TABLE IF EXISTS DEC
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_UDF
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal, value int)
+PREHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal(65,30), value int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal, value int)
+POSTHOOK: query: CREATE TABLE DECIMAL_UDF (key decimal(65,30), value int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
@@ -42,7 +42,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key + key)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -67,7 +67,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-NULL
+0
0
200
20
@@ -124,7 +124,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key + value)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -149,7 +149,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
NULL
-NULL
+0
0
200
20
@@ -206,7 +206,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key + (value / 2))
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -231,7 +231,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-2200
NULL
-NULL
+0
0
150
15
@@ -288,7 +288,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key + '1.0')
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -313,7 +313,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4399
NULL
-NULL
+1
1
101
11
@@ -372,7 +372,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key - key)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -397,7 +397,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
NULL
-NULL
+0
0
0
0
@@ -454,7 +454,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key - value)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -479,7 +479,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-NULL
+0
0
0
0
@@ -536,7 +536,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key - (value / 2))
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -561,7 +561,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-6600
NULL
-NULL
+0
0
50
5
@@ -618,7 +618,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key - '1.0')
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -643,7 +643,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4401
NULL
-NULL
+-1
-1
99
9
@@ -702,7 +702,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key * key)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -727,7 +727,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
19360000
NULL
-NULL
+0
0
10000
100
@@ -784,7 +784,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key * value)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -809,7 +809,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-19360000
NULL
-NULL
+0
0
10000
100
@@ -866,7 +866,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key * (value / 2))
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -891,7 +891,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-9680000
NULL
-NULL
+0
0
5000
50
@@ -948,7 +948,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key * '2.0')
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -973,7 +973,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-NULL
+0
0
200
20
@@ -1032,7 +1032,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key / 0)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
Limit
File Output Operator
@@ -1078,7 +1078,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key / null)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
Limit
File Output Operator
@@ -1128,7 +1128,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key / key)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1210,7 +1210,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key / value)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1242,7 +1242,7 @@ POSTHOOK: Input: default@decimal_udf
1
1
1
-1.0466666666666666666666666666666666667
+1.046666666666666666666666666667
1.12
1.12
0.102
@@ -1250,13 +1250,13 @@ POSTHOOK: Input: default@decimal_udf
1.122
1
1.0016
-1.0003904382470119521912350597609561753
-1.0466666666666666666666666666666666667
-1.0466666666666666666666666666666666667
+1.000390438247011952191235059761
+1.046666666666666666666666666667
+1.046666666666666666666666666667
0.785
0.9999999999999999999999999
1.0000000001
-1.0000000000999999927099999336609993963
+1.000000000099999992709999933661
PREHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1282,7 +1282,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key / (value / 2))
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1314,7 +1314,7 @@ POSTHOOK: Input: default@decimal_udf
2
2
2
-2.0933333333333333333333333333333333333
+2.093333333333333333333333333333
2.24
2.24
0.204
@@ -1322,13 +1322,13 @@ POSTHOOK: Input: default@decimal_udf
2.244
2
2.0032
-2.0007808764940239043824701195219123506
-2.0933333333333333333333333333333333333
-2.0933333333333333333333333333333333333
+2.000780876494023904382470119522
+2.093333333333333333333333333333
+2.093333333333333333333333333333
1.57
1.9999999999999999999999998
2.0000000002
-2.0000000001999999854199998673219987926
+2.000000000199999985419999867322
PREHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key / '2.0' FROM DECIMAL_UDF
@@ -1350,7 +1350,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (key / '2.0')
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1375,7 +1375,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-2200
NULL
-NULL
+0
0
50
5
@@ -1434,7 +1434,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: abs(key)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1459,7 +1459,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-NULL
+0
0
100
10
@@ -1521,7 +1521,7 @@ STAGE PLANS:
expr: value
type: int
expr: key
- type: decimal
+ type: decimal(65,30)
outputColumnNames: value, key
Group By Operator
aggregations:
@@ -1545,11 +1545,11 @@ STAGE PLANS:
tag: -1
value expressions:
expr: _col1
- type: decimal
+ type: decimal(65,30)
expr: _col2
type: bigint
expr: _col3
- type: struct<count:bigint,sum:decimal>
+ type: struct<count:bigint,sum:decimal(65,30)>
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -1567,9 +1567,9 @@ STAGE PLANS:
expr: _col0
type: int
expr: (_col1 / _col2)
- type: decimal
+ type: decimal(65,30)
expr: _col3
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0, _col1, _col2
File Output Operator
compressed: false
@@ -1594,9 +1594,9 @@ STAGE PLANS:
expr: _col0
type: int
expr: _col1
- type: decimal
+ type: decimal(65,30)
expr: _col2
- type: decimal
+ type: decimal(65,30)
Reduce Operator Tree:
Extract
File Output Operator
@@ -1624,7 +1624,7 @@ POSTHOOK: Input: default@decimal_udf
-1255 -1255.49 -1255.49
-11 -1.122 -1.122
-1 -1.12 -1.12
-0 0.0275 0.0275
+0 0.025384615384615384615384615385 0.025384615384615384615384615385
1 1.04839999999999999999999998 1.04839999999999999999999998
2 2 2
3 3.14 3.14
@@ -1660,7 +1660,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: (- key)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1685,7 +1685,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-NULL
+0
0
-100
-10
@@ -1744,7 +1744,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: key
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1769,7 +1769,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4400
NULL
-NULL
+0
0
100
10
@@ -1828,7 +1828,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: ceil(key)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1853,7 +1853,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4400
NULL
-NULL
+0
0
100
10
@@ -1912,7 +1912,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: floor(key)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -1937,7 +1937,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4400
NULL
-NULL
+0
0
100
10
@@ -1996,7 +1996,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: round(key, 2)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -2021,7 +2021,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4400
NULL
-NULL
+0
0
100
10
@@ -2080,7 +2080,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: power(key, 2)
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -2105,7 +2105,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
19360000
NULL
-NULL
+0
0
10000
100
@@ -2164,7 +2164,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: ((key + 1) % (key / 2))
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -2250,7 +2250,7 @@ STAGE PLANS:
expr: value
type: int
expr: key
- type: decimal
+ type: decimal(65,30)
outputColumnNames: value, key
Group By Operator
aggregations:
@@ -2321,7 +2321,7 @@ POSTHOOK: Input: default@decimal_udf
-1255 0.0 0.0
-11 0.0 0.0
-1 0.0 0.0
-0 0.23469892060538614 0.055083583333333345
+0 0.22561046704494161 0.050900082840236685
1 0.05928102563215321 0.0035142400000000066
2 0.0 0.0
3 0.0 0.0
@@ -2359,7 +2359,7 @@ STAGE PLANS:
expr: value
type: int
expr: key
- type: decimal
+ type: decimal(65,30)
outputColumnNames: value, key
Group By Operator
aggregations:
@@ -2430,7 +2430,7 @@ POSTHOOK: Input: default@decimal_udf
-1255 0.0 0.0
-11 0.0 0.0
-1 0.0 0.0
-0 0.24513502772590828 0.06009118181818183
+0 0.2348228191855647 0.055141756410256405
1 0.06627820154470102 0.004392800000000008
2 0.0 0.0
3 0.0 0.0
@@ -2466,7 +2466,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: key
- type: decimal
+ type: decimal(65,30)
outputColumnNames: key
Group By Operator
aggregations:
@@ -2513,7 +2513,7 @@ POSTHOOK: query: SELECT histogram_numeri
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-[{"x":-1.2345678901234567E9,"y":1.0},{"x":-148.75058823529412,"y":34.0},{"x":1.2345678901234567E9,"y":1.0}]
+[{"x":-1.2345678901234567E9,"y":1.0},{"x":-144.50057142857142,"y":35.0},{"x":1.2345678901234567E9,"y":1.0}]
PREHOOK: query: -- min
EXPLAIN SELECT MIN(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -2537,7 +2537,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: key
- type: decimal
+ type: decimal(65,30)
outputColumnNames: key
Group By Operator
aggregations:
@@ -2550,7 +2550,7 @@ STAGE PLANS:
tag: -1
value expressions:
expr: _col0
- type: decimal
+ type: decimal(65,30)
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -2561,7 +2561,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: _col0
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -2608,7 +2608,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: key
- type: decimal
+ type: decimal(65,30)
outputColumnNames: key
Group By Operator
aggregations:
@@ -2621,7 +2621,7 @@ STAGE PLANS:
tag: -1
value expressions:
expr: _col0
- type: decimal
+ type: decimal(65,30)
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -2632,7 +2632,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: _col0
- type: decimal
+ type: decimal(65,30)
outputColumnNames: _col0
File Output Operator
compressed: false
@@ -2679,7 +2679,7 @@ STAGE PLANS:
Select Operator
expressions:
expr: key
- type: decimal
+ type: decimal(65,30)
outputColumnNames: key
Group By Operator
aggregations:
@@ -2726,7 +2726,7 @@ POSTHOOK: query: SELECT COUNT(key) FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-36
+37
PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_UDF
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_udf
Modified: hive/branches/maven/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out Mon Oct 28 18:44:01 2013
@@ -128,8 +128,8 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
@@ -141,8 +141,8 @@ POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
0 1 00.0 0 3
1 71 116414.0 10044 115
@@ -154,3 +154,173 @@ POSTHOOK: Lineage: dest1.key EXPRESSION
7 6 7735.0 447 10
8 8 8762.0 595 10
9 7 91047.0 577 12
+PREHOOK: query: -- HIVE-5560 when group by key is used in distinct funtion, invalid result are returned
+
+EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.key,1,1)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1)
+PREHOOK: type: QUERY
+POSTHOOK: query: -- HIVE-5560 when group by key is used in distinct funtion, invalid result are returned
+
+EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.key,1,1)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1)
+POSTHOOK: type: QUERY
+POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1))) (TOK_SELEXPR (TOK_FUNCTION concat (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1) (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_SELEXPR (TOK_FUNCTIONDI sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION count (. (TOK_TABLE_OR_COL src) value)))) (TOK_GROUPBY (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+ Stage-2 depends on stages: Stage-0
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: key, value
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(key, 1, 1))
+ expr: sum(substr(value, 5))
+ expr: sum(DISTINCT substr(value, 5))
+ expr: count(value)
+ bucketGroup: false
+ keys:
+ expr: substr(key, 1, 1)
+ type: string
+ expr: substr(value, 5)
+ type: string
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col2
+ type: bigint
+ expr: _col3
+ type: double
+ expr: _col4
+ type: double
+ expr: _col5
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT KEY._col1:0._col0)
+ expr: sum(VALUE._col1)
+ expr: sum(DISTINCT KEY._col1:1._col0)
+ expr: count(VALUE._col3)
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: string
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: UDFToInteger(_col1)
+ type: int
+ expr: concat(_col0, _col2)
+ type: string
+ expr: UDFToInteger(_col3)
+ type: int
+ expr: UDFToInteger(_col4)
+ type: int
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace: true
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
+
+ Stage: Stage-2
+ Stats-Aggr Operator
+
+
+PREHOOK: query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.key,1,1)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.key,1,1)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@dest1
+POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest1
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+0 1 00.0 0 3
+1 1 116414.0 10044 115
+2 1 225571.0 15780 111
+3 1 332004.0 20119 99
+4 1 452763.0 30965 124
+5 1 5397.0 278 10
+6 1 6398.0 331 6
+7 1 7735.0 447 10
+8 1 8762.0 595 10
+9 1 91047.0 577 12
Modified: hive/branches/maven/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out Mon Oct 28 18:44:01 2013
@@ -51,7 +51,7 @@ STAGE PLANS:
Group By Operator
aggregations:
expr: count(DISTINCT KEY._col1:0._col0)
- expr: sum(KEY._col1:1._col0)
+ expr: sum(KEY._col1:0._col0)
expr: sum(DISTINCT KEY._col1:1._col0)
expr: count(VALUE._col0)
bucketGroup: false
@@ -108,8 +108,8 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest_g2
POSTHOOK: Lineage: dest_g2.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest_g2.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest_g2.c4 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest_g2.c3 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest_g2.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT dest_g2.* FROM dest_g2
PREHOOK: type: QUERY
@@ -121,8 +121,8 @@ POSTHOOK: Input: default@dest_g2
#### A masked pattern was here ####
POSTHOOK: Lineage: dest_g2.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest_g2.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest_g2.c4 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest_g2.c3 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest_g2.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
0 1 00.0 0 3
1 71 116414.0 10044 115
Modified: hive/branches/maven/ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/maven/ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out?rev=1536480&r1=1536479&r2=1536480&view=diff
==============================================================================
--- hive/branches/maven/ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out (original)
+++ hive/branches/maven/ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out Mon Oct 28 18:44:01 2013
@@ -199,8 +199,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c10 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c11 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c10 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c11 EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -218,8 +218,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c10 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c11 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c10 EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: dest1.c11 EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]