You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2018/07/02 02:07:57 UTC
[09/20] hive git commit: HIVE-20004: Wrong scale used by
ConvertDecimal64ToDecimal results in incorrect results (Prasanth Jayachandran
reviewed by Matt McCline)
http://git-wip-us.apache.org/repos/asf/hive/blob/6acd74c9/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out
index d6da582..27d6c1c 100644
--- a/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out
@@ -865,7 +865,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
PREHOOK: query: select count(*) from (select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -876,7 +981,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -1038,7 +1143,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 33.66 14 10
+14.00 33.66 14 22
+14.00 33.66 14 34
+14.00 33.66 14 39
+14.00 33.66 14 42
+14.00 33.66 14 45
+14.00 33.66 14 46
+14.00 33.66 14 49
+14.00 33.66 14 5
+17.00 14.26 17 1
+17.00 14.26 17 14
+17.00 14.26 17 16
+17.00 14.26 17 19
+17.00 14.26 17 2
+17.00 14.26 17 22
+17.00 14.26 17 29
+17.00 14.26 17 3
+17.00 14.26 17 4
+17.00 14.26 17 44
+45.00 23.55 45 1
+45.00 23.55 45 2
+45.00 23.55 45 22
+45.00 23.55 45 24
+45.00 23.55 45 42
+6.00 29.78 6 16
+6.00 29.78 6 28
+6.00 29.78 6 30
+6.00 29.78 6 34
+6.00 29.78 6 36
+6.00 29.78 6 44
+62.00 21.02 62 15
+62.00 21.02 62 15
+62.00 21.02 62 21
+62.00 21.02 62 21
+62.00 21.02 62 22
+62.00 21.02 62 25
+62.00 21.02 62 29
+62.00 21.02 62 3
+62.00 21.02 62 34
+62.00 21.02 62 47
+62.00 21.02 62 47
+62.00 21.02 62 49
+64.00 37.76 64 0
+64.00 37.76 64 10
+64.00 37.76 64 10
+64.00 37.76 64 13
+64.00 37.76 64 23
+64.00 37.76 64 25
+64.00 37.76 64 26
+64.00 37.76 64 27
+64.00 37.76 64 27
+64.00 37.76 64 30
+64.00 37.76 64 32
+64.00 37.76 64 34
+64.00 37.76 64 35
+64.00 37.76 64 38
+64.00 37.76 64 40
+64.00 37.76 64 43
+64.00 37.76 64 5
+64.00 37.76 64 50
+70.00 24.59 70 2
+70.00 24.59 70 25
+70.00 24.59 70 27
+70.00 24.59 70 28
+70.00 24.59 70 3
+70.00 24.59 70 32
+70.00 24.59 70 44
+79.00 15.12 79 1
+79.00 15.12 79 15
+79.00 15.12 79 25
+79.00 15.12 79 30
+79.00 15.12 79 35
+79.00 15.12 79 35
+89.00 15.09 89 1
89.00 15.09 89 15
+89.00 15.09 89 23
+89.00 15.09 89 27
+89.00 15.09 89 28
+89.00 15.09 89 29
+89.00 15.09 89 30
+89.00 15.09 89 32
+89.00 15.09 89 39
+89.00 15.09 89 40
+89.00 15.09 89 45
+89.00 15.09 89 7
+9.00 48.96 9 12
+9.00 48.96 9 15
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 20
+9.00 48.96 9 20
+9.00 48.96 9 21
+9.00 48.96 9 21
+9.00 48.96 9 26
+9.00 48.96 9 27
+9.00 48.96 9 34
+9.00 48.96 9 38
+9.00 48.96 9 41
+9.00 48.96 9 42
+9.00 48.96 9 45
+9.00 48.96 9 48
+9.00 48.96 9 49
+9.00 48.96 9 5
+9.00 48.96 9 7
+9.00 48.96 9 7
PREHOOK: query: select count(*) from (select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -1049,7 +1259,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -1212,7 +1422,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
PREHOOK: query: select count(*) from (select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -1223,7 +1538,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -1387,7 +1702,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 33.66 14 10
+14.00 33.66 14 22
+14.00 33.66 14 34
+14.00 33.66 14 39
+14.00 33.66 14 42
+14.00 33.66 14 45
+14.00 33.66 14 46
+14.00 33.66 14 49
+14.00 33.66 14 5
+17.00 14.26 17 1
+17.00 14.26 17 14
+17.00 14.26 17 16
+17.00 14.26 17 19
+17.00 14.26 17 2
+17.00 14.26 17 22
+17.00 14.26 17 29
+17.00 14.26 17 3
+17.00 14.26 17 4
+17.00 14.26 17 44
+45.00 23.55 45 1
+45.00 23.55 45 2
+45.00 23.55 45 22
+45.00 23.55 45 24
+45.00 23.55 45 42
+6.00 29.78 6 16
+6.00 29.78 6 28
+6.00 29.78 6 30
+6.00 29.78 6 34
+6.00 29.78 6 36
+6.00 29.78 6 44
+62.00 21.02 62 15
+62.00 21.02 62 15
+62.00 21.02 62 21
+62.00 21.02 62 21
+62.00 21.02 62 22
+62.00 21.02 62 25
+62.00 21.02 62 29
+62.00 21.02 62 3
+62.00 21.02 62 34
+62.00 21.02 62 47
+62.00 21.02 62 47
+62.00 21.02 62 49
+64.00 37.76 64 0
+64.00 37.76 64 10
+64.00 37.76 64 10
+64.00 37.76 64 13
+64.00 37.76 64 23
+64.00 37.76 64 25
+64.00 37.76 64 26
+64.00 37.76 64 27
+64.00 37.76 64 27
+64.00 37.76 64 30
+64.00 37.76 64 32
+64.00 37.76 64 34
+64.00 37.76 64 35
+64.00 37.76 64 38
+64.00 37.76 64 40
+64.00 37.76 64 43
+64.00 37.76 64 5
+64.00 37.76 64 50
+70.00 24.59 70 2
+70.00 24.59 70 25
+70.00 24.59 70 27
+70.00 24.59 70 28
+70.00 24.59 70 3
+70.00 24.59 70 32
+70.00 24.59 70 44
+79.00 15.12 79 1
+79.00 15.12 79 15
+79.00 15.12 79 25
+79.00 15.12 79 30
+79.00 15.12 79 35
+79.00 15.12 79 35
+89.00 15.09 89 1
89.00 15.09 89 15
+89.00 15.09 89 23
+89.00 15.09 89 27
+89.00 15.09 89 28
+89.00 15.09 89 29
+89.00 15.09 89 30
+89.00 15.09 89 32
+89.00 15.09 89 39
+89.00 15.09 89 40
+89.00 15.09 89 45
+89.00 15.09 89 7
+9.00 48.96 9 12
+9.00 48.96 9 15
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 20
+9.00 48.96 9 20
+9.00 48.96 9 21
+9.00 48.96 9 21
+9.00 48.96 9 26
+9.00 48.96 9 27
+9.00 48.96 9 34
+9.00 48.96 9 38
+9.00 48.96 9 41
+9.00 48.96 9 42
+9.00 48.96 9 45
+9.00 48.96 9 48
+9.00 48.96 9 49
+9.00 48.96 9 5
+9.00 48.96 9 7
+9.00 48.96 9 7
PREHOOK: query: select count(*) from (select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -1398,4 +1818,4 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
http://git-wip-us.apache.org/repos/asf/hive/blob/6acd74c9/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out b/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out
index 9c646c3..f711413 100644
--- a/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out
@@ -731,7 +731,7 @@ STAGE PLANS:
TableScan
alias: t2_small
filterExpr: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
vectorizationSchemaColumns: [0:dec:decimal(14,0)/DECIMAL_64, 1:value_dec:decimal(14,0)/DECIMAL_64, 2:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
@@ -741,7 +741,7 @@ STAGE PLANS:
native: true
predicateExpression: SelectColumnIsNotNull(col 3:decimal(14,0))(children: ConvertDecimal64ToDecimal(col 0:decimal(14,0)/DECIMAL_64) -> 3:decimal(14,0))
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(14,0))
outputColumnNames: _col0
@@ -749,7 +749,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Spark HashTable Sink Operator
Spark Hash Table Sink Vectorization:
className: VectorSparkHashTableSinkOperator
@@ -867,7 +867,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
PREHOOK: query: select count(*) from (select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -878,7 +983,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -904,7 +1009,7 @@ STAGE PLANS:
TableScan
alias: t2_small
filterExpr: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
vectorizationSchemaColumns: [0:dec:decimal(14,0)/DECIMAL_64, 1:value_dec:decimal(14,0)/DECIMAL_64, 2:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
@@ -914,7 +1019,7 @@ STAGE PLANS:
native: true
predicateExpression: SelectColumnIsNotNull(col 3:decimal(14,0))(children: ConvertDecimal64ToDecimal(col 0:decimal(14,0)/DECIMAL_64) -> 3:decimal(14,0))
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(14,0)), value_dec (type: decimal(14,0))
outputColumnNames: _col0, _col1
@@ -922,7 +1027,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0, 1]
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Spark HashTable Sink Operator
Spark Hash Table Sink Vectorization:
className: VectorSparkHashTableSinkOperator
@@ -1040,7 +1145,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 33.66 14 10
+14.00 33.66 14 22
+14.00 33.66 14 34
+14.00 33.66 14 39
+14.00 33.66 14 42
+14.00 33.66 14 45
+14.00 33.66 14 46
+14.00 33.66 14 49
+14.00 33.66 14 5
+17.00 14.26 17 1
+17.00 14.26 17 14
+17.00 14.26 17 16
+17.00 14.26 17 19
+17.00 14.26 17 2
+17.00 14.26 17 22
+17.00 14.26 17 29
+17.00 14.26 17 3
+17.00 14.26 17 4
+17.00 14.26 17 44
+45.00 23.55 45 1
+45.00 23.55 45 2
+45.00 23.55 45 22
+45.00 23.55 45 24
+45.00 23.55 45 42
+6.00 29.78 6 16
+6.00 29.78 6 28
+6.00 29.78 6 30
+6.00 29.78 6 34
+6.00 29.78 6 36
+6.00 29.78 6 44
+62.00 21.02 62 15
+62.00 21.02 62 15
+62.00 21.02 62 21
+62.00 21.02 62 21
+62.00 21.02 62 22
+62.00 21.02 62 25
+62.00 21.02 62 29
+62.00 21.02 62 3
+62.00 21.02 62 34
+62.00 21.02 62 47
+62.00 21.02 62 47
+62.00 21.02 62 49
+64.00 37.76 64 0
+64.00 37.76 64 10
+64.00 37.76 64 10
+64.00 37.76 64 13
+64.00 37.76 64 23
+64.00 37.76 64 25
+64.00 37.76 64 26
+64.00 37.76 64 27
+64.00 37.76 64 27
+64.00 37.76 64 30
+64.00 37.76 64 32
+64.00 37.76 64 34
+64.00 37.76 64 35
+64.00 37.76 64 38
+64.00 37.76 64 40
+64.00 37.76 64 43
+64.00 37.76 64 5
+64.00 37.76 64 50
+70.00 24.59 70 2
+70.00 24.59 70 25
+70.00 24.59 70 27
+70.00 24.59 70 28
+70.00 24.59 70 3
+70.00 24.59 70 32
+70.00 24.59 70 44
+79.00 15.12 79 1
+79.00 15.12 79 15
+79.00 15.12 79 25
+79.00 15.12 79 30
+79.00 15.12 79 35
+79.00 15.12 79 35
+89.00 15.09 89 1
89.00 15.09 89 15
+89.00 15.09 89 23
+89.00 15.09 89 27
+89.00 15.09 89 28
+89.00 15.09 89 29
+89.00 15.09 89 30
+89.00 15.09 89 32
+89.00 15.09 89 39
+89.00 15.09 89 40
+89.00 15.09 89 45
+89.00 15.09 89 7
+9.00 48.96 9 12
+9.00 48.96 9 15
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 20
+9.00 48.96 9 20
+9.00 48.96 9 21
+9.00 48.96 9 21
+9.00 48.96 9 26
+9.00 48.96 9 27
+9.00 48.96 9 34
+9.00 48.96 9 38
+9.00 48.96 9 41
+9.00 48.96 9 42
+9.00 48.96 9 45
+9.00 48.96 9 48
+9.00 48.96 9 49
+9.00 48.96 9 5
+9.00 48.96 9 7
+9.00 48.96 9 7
PREHOOK: query: select count(*) from (select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -1051,7 +1261,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -1077,7 +1287,7 @@ STAGE PLANS:
TableScan
alias: t2_small
filterExpr: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
vectorizationSchemaColumns: [0:dec:decimal(14,0), 1:value_dec:decimal(14,0), 2:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
@@ -1087,7 +1297,7 @@ STAGE PLANS:
native: true
predicateExpression: SelectColumnIsNotNull(col 0:decimal(14,0))
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(14,0))
outputColumnNames: _col0
@@ -1095,7 +1305,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Spark HashTable Sink Operator
Spark Hash Table Sink Vectorization:
className: VectorSparkHashTableSinkOperator
@@ -1215,7 +1425,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
PREHOOK: query: select count(*) from (select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -1226,7 +1541,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -1252,7 +1567,7 @@ STAGE PLANS:
TableScan
alias: t2_small
filterExpr: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
vectorizationSchemaColumns: [0:dec:decimal(14,0), 1:value_dec:decimal(14,0), 2:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
@@ -1262,7 +1577,7 @@ STAGE PLANS:
native: true
predicateExpression: SelectColumnIsNotNull(col 0:decimal(14,0))
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(14,0)), value_dec (type: decimal(14,0))
outputColumnNames: _col0, _col1
@@ -1270,7 +1585,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0, 1]
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Spark HashTable Sink Operator
Spark Hash Table Sink Vectorization:
className: VectorSparkHashTableSinkOperator
@@ -1390,7 +1705,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 33.66 14 10
+14.00 33.66 14 22
+14.00 33.66 14 34
+14.00 33.66 14 39
+14.00 33.66 14 42
+14.00 33.66 14 45
+14.00 33.66 14 46
+14.00 33.66 14 49
+14.00 33.66 14 5
+17.00 14.26 17 1
+17.00 14.26 17 14
+17.00 14.26 17 16
+17.00 14.26 17 19
+17.00 14.26 17 2
+17.00 14.26 17 22
+17.00 14.26 17 29
+17.00 14.26 17 3
+17.00 14.26 17 4
+17.00 14.26 17 44
+45.00 23.55 45 1
+45.00 23.55 45 2
+45.00 23.55 45 22
+45.00 23.55 45 24
+45.00 23.55 45 42
+6.00 29.78 6 16
+6.00 29.78 6 28
+6.00 29.78 6 30
+6.00 29.78 6 34
+6.00 29.78 6 36
+6.00 29.78 6 44
+62.00 21.02 62 15
+62.00 21.02 62 15
+62.00 21.02 62 21
+62.00 21.02 62 21
+62.00 21.02 62 22
+62.00 21.02 62 25
+62.00 21.02 62 29
+62.00 21.02 62 3
+62.00 21.02 62 34
+62.00 21.02 62 47
+62.00 21.02 62 47
+62.00 21.02 62 49
+64.00 37.76 64 0
+64.00 37.76 64 10
+64.00 37.76 64 10
+64.00 37.76 64 13
+64.00 37.76 64 23
+64.00 37.76 64 25
+64.00 37.76 64 26
+64.00 37.76 64 27
+64.00 37.76 64 27
+64.00 37.76 64 30
+64.00 37.76 64 32
+64.00 37.76 64 34
+64.00 37.76 64 35
+64.00 37.76 64 38
+64.00 37.76 64 40
+64.00 37.76 64 43
+64.00 37.76 64 5
+64.00 37.76 64 50
+70.00 24.59 70 2
+70.00 24.59 70 25
+70.00 24.59 70 27
+70.00 24.59 70 28
+70.00 24.59 70 3
+70.00 24.59 70 32
+70.00 24.59 70 44
+79.00 15.12 79 1
+79.00 15.12 79 15
+79.00 15.12 79 25
+79.00 15.12 79 30
+79.00 15.12 79 35
+79.00 15.12 79 35
+89.00 15.09 89 1
89.00 15.09 89 15
+89.00 15.09 89 23
+89.00 15.09 89 27
+89.00 15.09 89 28
+89.00 15.09 89 29
+89.00 15.09 89 30
+89.00 15.09 89 32
+89.00 15.09 89 39
+89.00 15.09 89 40
+89.00 15.09 89 45
+89.00 15.09 89 7
+9.00 48.96 9 12
+9.00 48.96 9 15
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 20
+9.00 48.96 9 20
+9.00 48.96 9 21
+9.00 48.96 9 21
+9.00 48.96 9 26
+9.00 48.96 9 27
+9.00 48.96 9 34
+9.00 48.96 9 38
+9.00 48.96 9 41
+9.00 48.96 9 42
+9.00 48.96 9 45
+9.00 48.96 9 48
+9.00 48.96 9 49
+9.00 48.96 9 5
+9.00 48.96 9 7
+9.00 48.96 9 7
PREHOOK: query: select count(*) from (select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -1401,4 +1821,4 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
http://git-wip-us.apache.org/repos/asf/hive/blob/6acd74c9/ql/src/test/results/clientpositive/vector_decimal_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_decimal_5.q.out b/ql/src/test/results/clientpositive/vector_decimal_5.q.out
index f3e6b72..a2e114b 100644
--- a/ql/src/test/results/clientpositive/vector_decimal_5.q.out
+++ b/ql/src/test/results/clientpositive/vector_decimal_5.q.out
@@ -171,42 +171,42 @@ POSTHOOK: query: SELECT cast(key as decimal) FROM DECIMAL_5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_5
#### A masked pattern was here ####
--440000000
+-4400
NULL
0
0
-10000000
-1000000
-100000
-10000
-1000
-20000000
-2000000
-200000
+100
+10
+1
0
-20000
-2000
-30000
-33000
-33300
--30000
--33000
--33300
-100000
-200000
-314000
--112000
--112000
--112200
-112000
-112200
-12400000
-12520000
--125549000
-314000
-314000
-314000
-100000
+0
+200
+20
+2
+0
+0
+0
+0
+0
+0
+0
+0
+0
+1
+2
+3
+-1
+-1
+-1
+1
+1
+124
+125
+-1255
+3
+3
+3
+1
NULL
NULL
PREHOOK: query: SELECT cast(key as decimal(6,3)) FROM DECIMAL_5
@@ -221,38 +221,38 @@ NULL
NULL
0.000
0.000
-NULL
-NULL
100.000
10.000
1.000
-NULL
-NULL
+0.100
+0.010
200.000
-0.000
20.000
2.000
-30.000
-33.000
-33.300
--30.000
--33.000
--33.300
-100.000
-200.000
-314.000
--112.000
--112.000
--112.200
-112.000
-112.200
-NULL
-NULL
+0.000
+0.200
+0.020
+0.300
+0.330
+0.333
+-0.300
+-0.330
+-0.333
+1.000
+2.000
+3.140
+-1.120
+-1.120
+-1.122
+1.120
+1.122
+124.000
+125.200
NULL
-314.000
-314.000
-314.000
-100.000
+3.140
+3.140
+3.140
+1.000
NULL
NULL
PREHOOK: query: DROP TABLE DECIMAL_5_txt
http://git-wip-us.apache.org/repos/asf/hive/blob/6acd74c9/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out b/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out
index 76bed46..0f090bf 100644
--- a/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out
@@ -663,14 +663,14 @@ STAGE PLANS:
TableScan
alias: t2_small
filterExpr: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(14,0))
outputColumnNames: _col0
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col0 (type: decimal(16,2))
@@ -762,7 +762,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
PREHOOK: query: select count(*) from (select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -773,7 +878,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -801,14 +906,14 @@ STAGE PLANS:
TableScan
alias: t2_small
filterExpr: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(14,0)), value_dec (type: decimal(14,0))
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col0 (type: decimal(16,2))
@@ -900,7 +1005,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 33.66 14 10
+14.00 33.66 14 22
+14.00 33.66 14 34
+14.00 33.66 14 39
+14.00 33.66 14 42
+14.00 33.66 14 45
+14.00 33.66 14 46
+14.00 33.66 14 49
+14.00 33.66 14 5
+17.00 14.26 17 1
+17.00 14.26 17 14
+17.00 14.26 17 16
+17.00 14.26 17 19
+17.00 14.26 17 2
+17.00 14.26 17 22
+17.00 14.26 17 29
+17.00 14.26 17 3
+17.00 14.26 17 4
+17.00 14.26 17 44
+45.00 23.55 45 1
+45.00 23.55 45 2
+45.00 23.55 45 22
+45.00 23.55 45 24
+45.00 23.55 45 42
+6.00 29.78 6 16
+6.00 29.78 6 28
+6.00 29.78 6 30
+6.00 29.78 6 34
+6.00 29.78 6 36
+6.00 29.78 6 44
+62.00 21.02 62 15
+62.00 21.02 62 15
+62.00 21.02 62 21
+62.00 21.02 62 21
+62.00 21.02 62 22
+62.00 21.02 62 25
+62.00 21.02 62 29
+62.00 21.02 62 3
+62.00 21.02 62 34
+62.00 21.02 62 47
+62.00 21.02 62 47
+62.00 21.02 62 49
+64.00 37.76 64 0
+64.00 37.76 64 10
+64.00 37.76 64 10
+64.00 37.76 64 13
+64.00 37.76 64 23
+64.00 37.76 64 25
+64.00 37.76 64 26
+64.00 37.76 64 27
+64.00 37.76 64 27
+64.00 37.76 64 30
+64.00 37.76 64 32
+64.00 37.76 64 34
+64.00 37.76 64 35
+64.00 37.76 64 38
+64.00 37.76 64 40
+64.00 37.76 64 43
+64.00 37.76 64 5
+64.00 37.76 64 50
+70.00 24.59 70 2
+70.00 24.59 70 25
+70.00 24.59 70 27
+70.00 24.59 70 28
+70.00 24.59 70 3
+70.00 24.59 70 32
+70.00 24.59 70 44
+79.00 15.12 79 1
+79.00 15.12 79 15
+79.00 15.12 79 25
+79.00 15.12 79 30
+79.00 15.12 79 35
+79.00 15.12 79 35
+89.00 15.09 89 1
89.00 15.09 89 15
+89.00 15.09 89 23
+89.00 15.09 89 27
+89.00 15.09 89 28
+89.00 15.09 89 29
+89.00 15.09 89 30
+89.00 15.09 89 32
+89.00 15.09 89 39
+89.00 15.09 89 40
+89.00 15.09 89 45
+89.00 15.09 89 7
+9.00 48.96 9 12
+9.00 48.96 9 15
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 20
+9.00 48.96 9 20
+9.00 48.96 9 21
+9.00 48.96 9 21
+9.00 48.96 9 26
+9.00 48.96 9 27
+9.00 48.96 9 34
+9.00 48.96 9 38
+9.00 48.96 9 41
+9.00 48.96 9 42
+9.00 48.96 9 45
+9.00 48.96 9 48
+9.00 48.96 9 49
+9.00 48.96 9 5
+9.00 48.96 9 7
+9.00 48.96 9 7
PREHOOK: query: select count(*) from (select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -911,7 +1121,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -939,14 +1149,14 @@ STAGE PLANS:
TableScan
alias: t2_small
filterExpr: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(14,0))
outputColumnNames: _col0
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col0 (type: decimal(16,2))
@@ -1039,7 +1249,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
PREHOOK: query: select count(*) from (select t1_small.`dec`, t2_small.`dec` from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -1050,7 +1365,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106
PREHOOK: query: explain vectorization detail
select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)
PREHOOK: type: QUERY
@@ -1078,14 +1393,14 @@ STAGE PLANS:
TableScan
alias: t2_small
filterExpr: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: dec is not null (type: boolean)
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: dec (type: decimal(14,0)), value_dec (type: decimal(14,0))
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1049 Data size: 7044 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1049 Data size: 4966 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
keys:
0 _col0 (type: decimal(16,2))
@@ -1178,7 +1493,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
+14.00 33.66 14 10
+14.00 33.66 14 22
+14.00 33.66 14 34
+14.00 33.66 14 39
+14.00 33.66 14 42
+14.00 33.66 14 45
+14.00 33.66 14 46
+14.00 33.66 14 49
+14.00 33.66 14 5
+17.00 14.26 17 1
+17.00 14.26 17 14
+17.00 14.26 17 16
+17.00 14.26 17 19
+17.00 14.26 17 2
+17.00 14.26 17 22
+17.00 14.26 17 29
+17.00 14.26 17 3
+17.00 14.26 17 4
+17.00 14.26 17 44
+45.00 23.55 45 1
+45.00 23.55 45 2
+45.00 23.55 45 22
+45.00 23.55 45 24
+45.00 23.55 45 42
+6.00 29.78 6 16
+6.00 29.78 6 28
+6.00 29.78 6 30
+6.00 29.78 6 34
+6.00 29.78 6 36
+6.00 29.78 6 44
+62.00 21.02 62 15
+62.00 21.02 62 15
+62.00 21.02 62 21
+62.00 21.02 62 21
+62.00 21.02 62 22
+62.00 21.02 62 25
+62.00 21.02 62 29
+62.00 21.02 62 3
+62.00 21.02 62 34
+62.00 21.02 62 47
+62.00 21.02 62 47
+62.00 21.02 62 49
+64.00 37.76 64 0
+64.00 37.76 64 10
+64.00 37.76 64 10
+64.00 37.76 64 13
+64.00 37.76 64 23
+64.00 37.76 64 25
+64.00 37.76 64 26
+64.00 37.76 64 27
+64.00 37.76 64 27
+64.00 37.76 64 30
+64.00 37.76 64 32
+64.00 37.76 64 34
+64.00 37.76 64 35
+64.00 37.76 64 38
+64.00 37.76 64 40
+64.00 37.76 64 43
+64.00 37.76 64 5
+64.00 37.76 64 50
+70.00 24.59 70 2
+70.00 24.59 70 25
+70.00 24.59 70 27
+70.00 24.59 70 28
+70.00 24.59 70 3
+70.00 24.59 70 32
+70.00 24.59 70 44
+79.00 15.12 79 1
+79.00 15.12 79 15
+79.00 15.12 79 25
+79.00 15.12 79 30
+79.00 15.12 79 35
+79.00 15.12 79 35
+89.00 15.09 89 1
89.00 15.09 89 15
+89.00 15.09 89 23
+89.00 15.09 89 27
+89.00 15.09 89 28
+89.00 15.09 89 29
+89.00 15.09 89 30
+89.00 15.09 89 32
+89.00 15.09 89 39
+89.00 15.09 89 40
+89.00 15.09 89 45
+89.00 15.09 89 7
+9.00 48.96 9 12
+9.00 48.96 9 15
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 2
+9.00 48.96 9 20
+9.00 48.96 9 20
+9.00 48.96 9 21
+9.00 48.96 9 21
+9.00 48.96 9 26
+9.00 48.96 9 27
+9.00 48.96 9 34
+9.00 48.96 9 38
+9.00 48.96 9 41
+9.00 48.96 9 42
+9.00 48.96 9 45
+9.00 48.96 9 48
+9.00 48.96 9 49
+9.00 48.96 9 5
+9.00 48.96 9 7
+9.00 48.96 9 7
PREHOOK: query: select count(*) from (select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`)) as t
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_small
@@ -1189,4 +1609,4 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_small
POSTHOOK: Input: default@t2_small
#### A masked pattern was here ####
-1
+106