You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vg...@apache.org on 2018/04/10 19:37:04 UTC
[2/4] hive git commit: HIVE-19153 : Update golden files for few tests
HIVE-19153 : Update golden files for few tests
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/b64fe747
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/b64fe747
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/b64fe747
Branch: refs/heads/branch-3
Commit: b64fe747926eb8fcf3945069323bd761fec238ef
Parents: ec6a8d7
Author: Ashutosh Chauhan <ha...@apache.org>
Authored: Tue Apr 10 10:14:26 2018 -0700
Committer: Vineet Garg <vg...@apache.org>
Committed: Tue Apr 10 12:35:17 2018 -0700
----------------------------------------------------------------------
.../clientpositive/acid_table_stats.q.out | 18 +-
.../llap/bucket_map_join_tez_empty.q.out | 4 +-
.../llap/default_constraint.q.out | 64 +++----
.../insert_values_orig_table_use_metadata.q.out | 32 ++--
.../results/clientpositive/llap/tez_smb_1.q.out | 176 ++++++++++---------
5 files changed, 147 insertions(+), 147 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/b64fe747/ql/src/test/results/clientpositive/acid_table_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/acid_table_stats.q.out b/ql/src/test/results/clientpositive/acid_table_stats.q.out
index 39777a6..215de13 100644
--- a/ql/src/test/results/clientpositive/acid_table_stats.q.out
+++ b/ql/src/test/results/clientpositive/acid_table_stats.q.out
@@ -93,9 +93,7 @@ Table: acid
#### A masked pattern was here ####
Partition Parameters:
numFiles 2
- numRows 0
- rawDataSize 0
- totalSize 3980
+ totalSize 4013
#### A masked pattern was here ####
# Storage Information
@@ -133,9 +131,9 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: acid
- Statistics: Num rows: 81 Data size: 39800 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 82 Data size: 40130 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 81 Data size: 39800 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 82 Data size: 40130 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
mode: hash
@@ -210,7 +208,7 @@ Partition Parameters:
numFiles 2
numRows 1000
rawDataSize 208000
- totalSize 3980
+ totalSize 4013
#### A masked pattern was here ####
# Storage Information
@@ -261,7 +259,7 @@ Partition Parameters:
numFiles 2
numRows 1000
rawDataSize 208000
- totalSize 3980
+ totalSize 4013
#### A masked pattern was here ####
# Storage Information
@@ -384,9 +382,7 @@ Table: acid
#### A masked pattern was here ####
Partition Parameters:
numFiles 4
- numRows 1000
- rawDataSize 208000
- totalSize 7952
+ totalSize 8019
#### A masked pattern was here ####
# Storage Information
@@ -433,7 +429,7 @@ Partition Parameters:
numFiles 4
numRows 2000
rawDataSize 416000
- totalSize 7952
+ totalSize 8019
#### A masked pattern was here ####
# Storage Information
http://git-wip-us.apache.org/repos/asf/hive/blob/b64fe747/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out
index 08df574..33825da 100644
--- a/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket_map_join_tez_empty.q.out
@@ -71,10 +71,10 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3
input vertices:
1 Map 2
- Statistics: Num rows: 3 Data size: 546 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 2 Data size: 364 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 546 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 2 Data size: 364 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/b64fe747/ql/src/test/results/clientpositive/llap/default_constraint.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/default_constraint.q.out b/ql/src/test/results/clientpositive/llap/default_constraint.q.out
index 2b4e0c9..95302da 100644
--- a/ql/src/test/results/clientpositive/llap/default_constraint.q.out
+++ b/ql/src/test/results/clientpositive/llap/default_constraint.q.out
@@ -60,7 +60,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -319,19 +319,19 @@ Storage Desc Params:
# Default Constraints
Table: default.table1
Constraint Name: #### A masked pattern was here ####
-Column Name:d1 Default Value:CURRENT_DATE()
+Column Name:d1 Default Value:current_date()
Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:DATE'2018-02-14'
Constraint Name: #### A masked pattern was here ####
-Column Name:t Default Value:TIMESTAMP'2016-02-22 12:45:07.0'
+Column Name:t Default Value:TIMESTAMP'2016-02-22 12:45:07.000000000'
Constraint Name: #### A masked pattern was here ####
-Column Name:t1 Default Value:CURRENT_TIMESTAMP()
+Column Name:t1 Default Value:current_timestamp()
Constraint Name: #### A masked pattern was here ####
-Column Name:tz Default Value:TIMESTAMPLOCALTZ'2016-01-03 12:26:34.0 America/Los_Angeles'
+Column Name:tz Default Value:TIMESTAMPLOCALTZ'2016-01-03 12:26:34 America/Los_Angeles'
PREHOOK: query: EXPLAIN INSERT INTO table1(t) values ("1985-12-31 12:45:07")
PREHOOK: type: QUERY
@@ -550,16 +550,16 @@ Storage Desc Params:
# Default Constraints
Table: default.table2
Constraint Name: #### A masked pattern was here ####
-Column Name:j Default Value:CURRENT_USER()
+Column Name:j Default Value:current_user()
Constraint Name: #### A masked pattern was here ####
Column Name:k Default Value:'Current_User()'
Constraint Name: #### A masked pattern was here ####
-Column Name:v Default Value:CAST( 'varchar_default_value' AS varchar(350))
+Column Name:v Default Value:cast('varchar_default_value' as varchar(350))
Constraint Name: #### A masked pattern was here ####
-Column Name:c Default Value:CAST( 'char_value' AS CHAR(20))
+Column Name:c Default Value:cast('char_value' as char(20))
Constraint Name: #### A masked pattern was here ####
Column Name:i Default Value:'current_database()'
@@ -811,7 +811,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:b Default Value:true
Constraint Name: #### A masked pattern was here ####
-Column Name:b1 Default Value:CAST( 'bin' AS BINARY)
+Column Name:b1 Default Value:cast('bin' as binary)
PREHOOK: query: EXPLAIN INSERT INTO misc(b) values(false)
PREHOOK: type: QUERY
@@ -1077,46 +1077,46 @@ Storage Desc Params:
# Default Constraints
Table: default.t11
Constraint Name: #### A masked pattern was here ####
-Column Name:tz1 Default Value:CAST( '2016-01-03 12:26:34 America/Los_Angeles' AS timestamp with local time zone)
+Column Name:tz1 Default Value:cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone)
Constraint Name: #### A masked pattern was here ####
-Column Name:b1 Default Value:UDFToBoolean('true')
+Column Name:b1 Default Value:cast ('true' as boolean)
Constraint Name: #### A masked pattern was here ####
-Column Name:i Default Value:UDFToInteger(UDFToDouble(4))
+Column Name:i Default Value:cast(cast(4 as double) as int)
Constraint Name: #### A masked pattern was here ####
-Column Name:b2 Default Value:UDFToInteger(5.67)
+Column Name:b2 Default Value:cast (5.67 as int)
Constraint Name: #### A masked pattern was here ####
-Column Name:j Default Value:CAST( CURRENT_TIMESTAMP() AS varchar(50))
+Column Name:j Default Value:cast(current_timestamp() as varchar(50))
Constraint Name: #### A masked pattern was here ####
-Column Name:b3 Default Value:UDFToByte(45)
+Column Name:b3 Default Value:cast (45 as tinyint)
Constraint Name: #### A masked pattern was here ####
-Column Name:k Default Value:UDFToString(CAST( CURRENT_USER() AS varchar(50)))
+Column Name:k Default Value:cast(cast(current_user() as varchar(50)) as string)
Constraint Name: #### A masked pattern was here ####
-Column Name:b4 Default Value:UDFToFloat(45.4)
+Column Name:b4 Default Value:cast (45.4 as float)
Constraint Name: #### A masked pattern was here ####
-Column Name:b5 Default Value:UDFToLong(567)
+Column Name:b5 Default Value:cast (567 as bigint)
Constraint Name: #### A masked pattern was here ####
-Column Name:b6 Default Value:UDFToShort(88)
+Column Name:b6 Default Value:cast (88 as smallint)
Constraint Name: #### A masked pattern was here ####
-Column Name:c2 Default Value:UDFToDouble(5)
+Column Name:c2 Default Value:cast(5 as double)
Constraint Name: #### A masked pattern was here ####
-Column Name:c4 Default Value:CAST( CAST( 'ab' AS varchar(2)) AS CHAR(2))
+Column Name:c4 Default Value:cast(cast(cast('ab' as string) as varchar(2)) as char(2))
Constraint Name: #### A masked pattern was here ####
-Column Name:ts Default Value:CAST( '2016-01-01 12:01:01' AS TIMESTAMP)
+Column Name:ts Default Value:cast('2016-01-01 12:01:01' as timestamp)
Constraint Name: #### A masked pattern was here ####
-Column Name:dc Default Value:CAST( 4.5 AS decimal(8,2))
+Column Name:dc Default Value:cast(4.5 as decimal(8,2))
PREHOOK: query: EXPLAIN INSERT INTO t11(c4) values('vi')
PREHOOK: type: QUERY
@@ -1365,7 +1365,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -1527,7 +1527,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -1701,7 +1701,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -1779,7 +1779,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -1954,7 +1954,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -2031,7 +2031,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -2109,7 +2109,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -2513,7 +2513,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
@@ -2675,7 +2675,7 @@ Constraint Name: #### A masked pattern was here ####
Column Name:d Default Value:9223372036854775807L
Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38D
+Column Name:e Default Value:3.4E38
Constraint Name: #### A masked pattern was here ####
Column Name:f Default Value:1234567.89
http://git-wip-us.apache.org/repos/asf/hive/blob/b64fe747/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out b/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
index b295d0f..9179be5 100644
--- a/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
+++ b/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
@@ -168,9 +168,7 @@ Retention: 0
Table Type: MANAGED_TABLE
Table Parameters:
numFiles 1
- numRows 0
- rawDataSize 0
- totalSize 295399
+ totalSize 295438
transactional true
transactional_properties default
#### A masked pattern was here ####
@@ -205,9 +203,9 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: acid_ivot
- Statistics: Num rows: 1 Data size: 2953990 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 5861 Data size: 2954380 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 1 Data size: 2953990 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 5861 Data size: 2954380 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
@@ -375,9 +373,7 @@ Retention: 0
Table Type: MANAGED_TABLE
Table Parameters:
numFiles 1
- numRows 0
- rawDataSize 0
- totalSize 1554
+ totalSize 1574
transactional true
transactional_properties default
#### A masked pattern was here ####
@@ -412,9 +408,9 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: acid_ivot
- Statistics: Num rows: 1 Data size: 15540 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 31 Data size: 15740 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 1 Data size: 15540 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 31 Data size: 15740 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
@@ -509,9 +505,7 @@ Retention: 0
Table Type: MANAGED_TABLE
Table Parameters:
numFiles 2
- numRows 0
- rawDataSize 0
- totalSize 3109
+ totalSize 3149
transactional true
transactional_properties default
#### A masked pattern was here ####
@@ -546,9 +540,9 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: acid_ivot
- Statistics: Num rows: 1 Data size: 31090 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 62 Data size: 31490 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 1 Data size: 31090 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 62 Data size: 31490 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
@@ -639,9 +633,7 @@ Retention: 0
Table Type: MANAGED_TABLE
Table Parameters:
numFiles 3
- numRows 0
- rawDataSize 0
- totalSize 298508
+ totalSize 298588
transactional true
transactional_properties default
#### A masked pattern was here ####
@@ -676,9 +668,9 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: acid_ivot
- Statistics: Num rows: 1 Data size: 2985080 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 5924 Data size: 2985880 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- Statistics: Num rows: 1 Data size: 2985080 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 5924 Data size: 2985880 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
http://git-wip-us.apache.org/repos/asf/hive/blob/b64fe747/ql/src/test/results/clientpositive/llap/tez_smb_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_smb_1.q.out b/ql/src/test/results/clientpositive/llap/tez_smb_1.q.out
index faa94862..57e5e1a 100644
--- a/ql/src/test/results/clientpositive/llap/tez_smb_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_smb_1.q.out
@@ -123,49 +123,61 @@ STAGE PLANS:
Tez
#### A masked pattern was here ####
Edges:
+ Map 1 <- Map 3 (CUSTOM_EDGE)
Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
Map Operator Tree:
TableScan
- alias: s3
- Statistics: Num rows: 242 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: int)
- outputColumnNames: _col0
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
- Map Operator Tree:
- TableScan
alias: s1
- Statistics: Num rows: 242 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
+ Map Join Operator
condition map:
Inner Join 0 to 1
keys:
0 _col0 (type: int)
1 _col0 (type: int)
- Statistics: Num rows: 253 Data size: 3647 Basic stats: COMPLETE Column stats: NONE
+ input vertices:
+ 1 Map 3
+ Statistics: Num rows: 382 Data size: 3056 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Execution mode: llap
+ LLAP IO: no inputs
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: s3
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
+ Filter Operator
+ predicate: key is not null (type: boolean)
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: key (type: int)
+ outputColumnNames: _col0
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
+ Reduce Output Operator
+ key expressions: _col0 (type: int)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: int)
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
+ Execution mode: llap
+ LLAP IO: no inputs
Reducer 2
Execution mode: llap
Reduce Operator Tree:
@@ -173,10 +185,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -222,37 +234,37 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: vt1
- Statistics: Num rows: 242 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: no inputs
Map 4
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 500 Data size: 94800 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -264,15 +276,15 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col0 (type: int)
- Statistics: Num rows: 522 Data size: 99066 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 391 Data size: 3128 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reducer 3
Execution mode: llap
@@ -281,10 +293,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -295,12 +307,12 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
Stage: Stage-0
Fetch Operator
@@ -367,37 +379,37 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 500 Data size: 94800 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: no inputs
Map 5
Map Operator Tree:
TableScan
alias: vt1
- Statistics: Num rows: 242 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 230 Data size: 3316 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -406,12 +418,12 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
Reducer 3
Execution mode: llap
Reduce Operator Tree:
@@ -421,15 +433,15 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col0 (type: int)
- Statistics: Num rows: 522 Data size: 99066 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 391 Data size: 3128 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reducer 4
Execution mode: llap
@@ -438,10 +450,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -513,36 +525,36 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 242 Data size: 45994 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 22990 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 22990 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 22990 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 22990 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: no inputs
Map 3
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 500 Data size: 94800 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: no inputs
Reducer 4
@@ -550,28 +562,28 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator
condition map:
Inner Join 0 to 1
keys:
0 _col0 (type: int)
1 _col0 (type: int)
- Statistics: Num rows: 522 Data size: 99066 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 391 Data size: 3128 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reducer 5
Execution mode: llap
@@ -580,10 +592,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -659,36 +671,36 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 242 Data size: 45994 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 22990 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 22990 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 22990 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 22990 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: no inputs
Map 5
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 500 Data size: 94800 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: int), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -697,12 +709,12 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 230 Data size: 43713 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Reducer 3
Execution mode: llap
Reduce Operator Tree:
@@ -712,15 +724,15 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col0 (type: int)
- Statistics: Num rows: 522 Data size: 99066 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 391 Data size: 3128 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count()
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Reducer 4
Execution mode: llap
@@ -729,10 +741,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -743,12 +755,12 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 475 Data size: 90060 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
Stage: Stage-0
Fetch Operator