http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/insert_into_with_schema.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/insert_into_with_schema.q.out b/ql/src/test/results/clientpositive/insert_into_with_schema.q.out deleted file mode 100644 index 040d118..0000000 --- a/ql/src/test/results/clientpositive/insert_into_with_schema.q.out +++ /dev/null @@ -1,348 +0,0 @@ -PREHOOK: query: -- set of tests HIVE-9481 - -drop database if exists x314 cascade -PREHOOK: type: DROPDATABASE -POSTHOOK: query: -- set of tests HIVE-9481 - -drop database if exists x314 cascade -POSTHOOK: type: DROPDATABASE -PREHOOK: query: create database x314 -PREHOOK: type: CREATEDATABASE -PREHOOK: Output: database:x314 -POSTHOOK: query: create database x314 -POSTHOOK: type: CREATEDATABASE -POSTHOOK: Output: database:x314 -PREHOOK: query: use x314 -PREHOOK: type: SWITCHDATABASE -PREHOOK: Input: database:x314 -POSTHOOK: query: use x314 -POSTHOOK: type: SWITCHDATABASE -POSTHOOK: Input: database:x314 -PREHOOK: query: create table source(s1 int, s2 int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:x314 -PREHOOK: Output: x314@source -POSTHOOK: query: create table source(s1 int, s2 int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:x314 -POSTHOOK: Output: x314@source -PREHOOK: query: create table target1(x int, y int, z int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:x314 -PREHOOK: Output: x314@target1 -POSTHOOK: query: create table target1(x int, y int, z int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:x314 -POSTHOOK: Output: x314@target1 -PREHOOK: query: create table target2(x int, y int, z int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:x314 -PREHOOK: Output: x314@target2 -POSTHOOK: query: create table target2(x int, y int, z int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:x314 -POSTHOOK: Output: x314@target2 -PREHOOK: query: insert into source(s2,s1) values(2,1) -PREHOOK: type: QUERY -PREHOOK: Output: x314@source -POSTHOOK: query: insert into source(s2,s1) values(2,1) -POSTHOOK: type: QUERY -POSTHOOK: Output: x314@source -POSTHOOK: Lineage: source.s1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: source.s2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: -- expect source to contain 1 row (1,2) -select * from source -PREHOOK: type: QUERY -PREHOOK: Input: x314@source -#### A masked pattern was here #### -POSTHOOK: query: -- expect source to contain 1 row (1,2) -select * from source -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@source -#### A masked pattern was here #### -1 2 -PREHOOK: query: insert into target1(z,x) select * from source -PREHOOK: type: QUERY -PREHOOK: Input: x314@source -PREHOOK: Output: x314@target1 -POSTHOOK: query: insert into target1(z,x) select * from source -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@source -POSTHOOK: Output: x314@target1 -POSTHOOK: Lineage: target1.x SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null), ] -POSTHOOK: Lineage: target1.y SIMPLE [] -POSTHOOK: Lineage: target1.z SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null), ] -PREHOOK: query: -- expect target1 to contain 1 row (2,NULL,1) -select * from target1 -PREHOOK: type: QUERY -PREHOOK: Input: x314@target1 -#### A masked pattern was here #### -POSTHOOK: query: -- expect target1 to contain 1 row (2,NULL,1) -select * from target1 -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@target1 -#### A masked pattern was here #### -2 NULL 1 -PREHOOK: query: -- note that schema spec for target1 and target2 are different -from source insert into target1(x,y) select * insert into target2(x,z) select s2,s1 -PREHOOK: type: QUERY -PREHOOK: Input: x314@source -PREHOOK: Output: x314@target1 -PREHOOK: Output: x314@target2 -POSTHOOK: query: -- note that schema spec for target1 and target2 are different -from source insert into target1(x,y) select * insert into target2(x,z) select s2,s1 -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@source -POSTHOOK: Output: x314@target1 -POSTHOOK: Output: x314@target2 -POSTHOOK: Lineage: target1.x SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null), ] -POSTHOOK: Lineage: target1.y SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null), ] -POSTHOOK: Lineage: target1.z SIMPLE [] -POSTHOOK: Lineage: target2.x SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null), ] -POSTHOOK: Lineage: target2.y SIMPLE [] -POSTHOOK: Lineage: target2.z SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null), ] -PREHOOK: query: --expect target1 to have 2rows (2,NULL,1), (1,2,NULL) -select * from target1 order by x,y,z -PREHOOK: type: QUERY -PREHOOK: Input: x314@target1 -#### A masked pattern was here #### -POSTHOOK: query: --expect target1 to have 2rows (2,NULL,1), (1,2,NULL) -select * from target1 order by x,y,z -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@target1 -#### A masked pattern was here #### -1 2 NULL -2 NULL 1 -PREHOOK: query: -- expect target2 to have 1 row: (2,NULL,1) -select * from target2 -PREHOOK: type: QUERY -PREHOOK: Input: x314@target2 -#### A masked pattern was here #### -POSTHOOK: query: -- expect target2 to have 1 row: (2,NULL,1) -select * from target2 -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@target2 -#### A masked pattern was here #### -2 NULL 1 -PREHOOK: query: from source insert into target1(x,y,z) select null as x, * insert into target2(x,y,z) select null as x, source.* -PREHOOK: type: QUERY -PREHOOK: Input: x314@source -PREHOOK: Output: x314@target1 -PREHOOK: Output: x314@target2 -POSTHOOK: query: from source insert into target1(x,y,z) select null as x, * insert into target2(x,y,z) select null as x, source.* -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@source -POSTHOOK: Output: x314@target1 -POSTHOOK: Output: x314@target2 -POSTHOOK: Lineage: target1.x EXPRESSION [] -POSTHOOK: Lineage: target1.y SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null), ] -POSTHOOK: Lineage: target1.z SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null), ] -POSTHOOK: Lineage: target2.x EXPRESSION [] -POSTHOOK: Lineage: target2.y SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null), ] -POSTHOOK: Lineage: target2.z SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null), ] -PREHOOK: query: -- expect target1 to have 3 rows: (2,NULL,1), (1,2,NULL), (NULL, 1,2) -select * from target1 order by x,y,z -PREHOOK: type: QUERY -PREHOOK: Input: x314@target1 -#### A masked pattern was here #### -POSTHOOK: query: -- expect target1 to have 3 rows: (2,NULL,1), (1,2,NULL), (NULL, 1,2) -select * from target1 order by x,y,z -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@target1 -#### A masked pattern was here #### -NULL 1 2 -1 2 NULL -2 NULL 1 -PREHOOK: query: -- expect target2 to have 2 rows: (2,NULL,1), (NULL, 1,2) -select * from target2 order by x,y,z -PREHOOK: type: QUERY -PREHOOK: Input: x314@target2 -#### A masked pattern was here #### -POSTHOOK: query: -- expect target2 to have 2 rows: (2,NULL,1), (NULL, 1,2) -select * from target2 order by x,y,z -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@target2 -#### A masked pattern was here #### -NULL 1 2 -2 NULL 1 -PREHOOK: query: truncate table target1 -PREHOOK: type: TRUNCATETABLE -PREHOOK: Output: x314@target1 -POSTHOOK: query: truncate table target1 -POSTHOOK: type: TRUNCATETABLE -POSTHOOK: Output: x314@target1 -PREHOOK: query: create table source2(s1 int, s2 int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:x314 -PREHOOK: Output: x314@source2 -POSTHOOK: query: create table source2(s1 int, s2 int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:x314 -POSTHOOK: Output: x314@source2 -PREHOOK: query: insert into target1 (x,z) select source.s1,source2.s2 from source left outer join source2 on source.s1=source2.s2 -PREHOOK: type: QUERY -PREHOOK: Input: x314@source -PREHOOK: Input: x314@source2 -PREHOOK: Output: x314@target1 -POSTHOOK: query: insert into target1 (x,z) select source.s1,source2.s2 from source left outer join source2 on source.s1=source2.s2 -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@source -POSTHOOK: Input: x314@source2 -POSTHOOK: Output: x314@target1 -POSTHOOK: Lineage: target1.x SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null), ] -POSTHOOK: Lineage: target1.y SIMPLE [] -POSTHOOK: Lineage: target1.z SIMPLE [(source2)source2.FieldSchema(name:s2, type:int, comment:null), ] -PREHOOK: query: --expect target1 to have 1 row (1,NULL,NULL) -select * from target1 -PREHOOK: type: QUERY -PREHOOK: Input: x314@target1 -#### A masked pattern was here #### -POSTHOOK: query: --expect target1 to have 1 row (1,NULL,NULL) -select * from target1 -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@target1 -#### A masked pattern was here #### -1 NULL NULL -PREHOOK: query: -- partitioned tables -CREATE TABLE pageviews (userid VARCHAR(64), link STRING, source STRING) PARTITIONED BY (datestamp STRING, i int) CLUSTERED BY (userid) INTO 256 BUCKETS STORED AS ORC -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:x314 -PREHOOK: Output: x314@pageviews -POSTHOOK: query: -- partitioned tables -CREATE TABLE pageviews (userid VARCHAR(64), link STRING, source STRING) PARTITIONED BY (datestamp STRING, i int) CLUSTERED BY (userid) INTO 256 BUCKETS STORED AS ORC -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:x314 -POSTHOOK: Output: x314@pageviews -PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp = '2014-09-23', i = 1)(userid,link) VALUES ('jsmith', 'mail.com') -PREHOOK: type: QUERY -PREHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=1 -POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp = '2014-09-23', i = 1)(userid,link) VALUES ('jsmith', 'mail.com') -POSTHOOK: type: QUERY -POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=1 -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=1).link SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=1).source SIMPLE [] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=1).userid EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: -- expect 1 row: ('jsmith', 'mail.com', NULL) in partition '2014-09-23'/'1' -select * from pageviews -PREHOOK: type: QUERY -PREHOOK: Input: x314@pageviews -PREHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=1 -#### A masked pattern was here #### -POSTHOOK: query: -- expect 1 row: ('jsmith', 'mail.com', NULL) in partition '2014-09-23'/'1' -select * from pageviews -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@pageviews -POSTHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=1 -#### A masked pattern was here #### -jsmith mail.com NULL 2014-09-23 1 -PREHOOK: query: -- dynamic partitioning - - - -INSERT INTO TABLE pageviews PARTITION (datestamp='2014-09-23',i)(userid,i,link) VALUES ('jsmith', 7, '7mail.com') -PREHOOK: type: QUERY -PREHOOK: Output: x314@pageviews@datestamp=2014-09-23 -POSTHOOK: query: -- dynamic partitioning - - - -INSERT INTO TABLE pageviews PARTITION (datestamp='2014-09-23',i)(userid,i,link) VALUES ('jsmith', 7, '7mail.com') -POSTHOOK: type: QUERY -POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=7 -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).link SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).source SIMPLE [] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).userid EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp) VALUES ('jsmith', 17, '17mail.com', '2014-09-23') -PREHOOK: type: QUERY -PREHOOK: Output: x314@pageviews -POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp) VALUES ('jsmith', 17, '17mail.com', '2014-09-23') -POSTHOOK: type: QUERY -POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=17 -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).link SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).source SIMPLE [] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).userid EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp) VALUES ('jsmith', 19, '19mail.com', '2014-09-24') -PREHOOK: type: QUERY -PREHOOK: Output: x314@pageviews -POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp) VALUES ('jsmith', 19, '19mail.com', '2014-09-24') -POSTHOOK: type: QUERY -POSTHOOK: Output: x314@pageviews@datestamp=2014-09-24/i=19 -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).link SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).source SIMPLE [] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).userid EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: -- here the 'datestamp' partition column is not provided and will be NULL-filled -INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link) VALUES ('jsmith', 23, '23mail.com') -PREHOOK: type: QUERY -PREHOOK: Output: x314@pageviews -POSTHOOK: query: -- here the 'datestamp' partition column is not provided and will be NULL-filled -INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link) VALUES ('jsmith', 23, '23mail.com') -POSTHOOK: type: QUERY -POSTHOOK: Output: x314@pageviews@datestamp=__HIVE_DEFAULT_PARTITION__/i=23 -POSTHOOK: Lineage: pageviews PARTITION(datestamp=__HIVE_DEFAULT_PARTITION__,i=23).link SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=__HIVE_DEFAULT_PARTITION__,i=23).source SIMPLE [] -POSTHOOK: Lineage: pageviews PARTITION(datestamp=__HIVE_DEFAULT_PARTITION__,i=23).userid EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: -- expect 5 rows: --- expect ('jsmith', 'mail.com', NULL) in partition '2014-09-23'/'1' --- expect ('jsmith', '7mail.com', NULL) in partition '2014-09-23'/'7' --- expect ('jsmith', '17mail.com', NULL) in partition '2014-09-23'/'17' --- expect ('jsmith', '19mail.com', NULL) in partition '2014-09-24'/'19' --- expect ('jsmith', '23mail.com', NULL) in partition '__HIVE_DEFAULT_PARTITION__'/'23' -select * from pageviews order by link -PREHOOK: type: QUERY -PREHOOK: Input: x314@pageviews -PREHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=1 -PREHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=17 -PREHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=7 -PREHOOK: Input: x314@pageviews@datestamp=2014-09-24/i=19 -PREHOOK: Input: x314@pageviews@datestamp=__HIVE_DEFAULT_PARTITION__/i=23 -#### A masked pattern was here #### -POSTHOOK: query: -- expect 5 rows: --- expect ('jsmith', 'mail.com', NULL) in partition '2014-09-23'/'1' --- expect ('jsmith', '7mail.com', NULL) in partition '2014-09-23'/'7' --- expect ('jsmith', '17mail.com', NULL) in partition '2014-09-23'/'17' --- expect ('jsmith', '19mail.com', NULL) in partition '2014-09-24'/'19' --- expect ('jsmith', '23mail.com', NULL) in partition '__HIVE_DEFAULT_PARTITION__'/'23' -select * from pageviews order by link -POSTHOOK: type: QUERY -POSTHOOK: Input: x314@pageviews -POSTHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=1 -POSTHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=17 -POSTHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=7 -POSTHOOK: Input: x314@pageviews@datestamp=2014-09-24/i=19 -POSTHOOK: Input: x314@pageviews@datestamp=__HIVE_DEFAULT_PARTITION__/i=23 -#### A masked pattern was here #### -jsmith 17mail.com NULL 2014-09-23 17 -jsmith 19mail.com NULL 2014-09-24 19 -jsmith 23mail.com NULL __HIVE_DEFAULT_PARTITION__ 23 -jsmith 7mail.com NULL 2014-09-23 7 -jsmith mail.com NULL 2014-09-23 1 -PREHOOK: query: drop database if exists x314 cascade -PREHOOK: type: DROPDATABASE -PREHOOK: Input: database:x314 -PREHOOK: Output: database:x314 -PREHOOK: Output: x314@pageviews -PREHOOK: Output: x314@source -PREHOOK: Output: x314@source2 -PREHOOK: Output: x314@target1 -PREHOOK: Output: x314@target2 -PREHOOK: Output: x314@values__tmp__table__1 -PREHOOK: Output: x314@values__tmp__table__2 -PREHOOK: Output: x314@values__tmp__table__3 -PREHOOK: Output: x314@values__tmp__table__4 -PREHOOK: Output: x314@values__tmp__table__5 -PREHOOK: Output: x314@values__tmp__table__6 -POSTHOOK: query: drop database if exists x314 cascade -POSTHOOK: type: DROPDATABASE -POSTHOOK: Input: database:x314 -POSTHOOK: Output: database:x314 -POSTHOOK: Output: x314@pageviews -POSTHOOK: Output: x314@source -POSTHOOK: Output: x314@source2 -POSTHOOK: Output: x314@target1 -POSTHOOK: Output: x314@target2 -POSTHOOK: Output: x314@values__tmp__table__1 -POSTHOOK: Output: x314@values__tmp__table__2 -POSTHOOK: Output: x314@values__tmp__table__3 -POSTHOOK: Output: x314@values__tmp__table__4 -POSTHOOK: Output: x314@values__tmp__table__5 -POSTHOOK: Output: x314@values__tmp__table__6
http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/join1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join1.q.out b/ql/src/test/results/clientpositive/join1.q.out deleted file mode 100644 index 5d54ee3..0000000 --- a/ql/src/test/results/clientpositive/join1.q.out +++ /dev/null @@ -1,1143 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@dest_j1 -POSTHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@dest_j1 -PREHOOK: query: EXPLAIN -FROM src src1 JOIN src src2 ON (src1.key = src2.key) -INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN -FROM src src1 JOIN src src2 ON (src1.key = src2.key) -INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value -POSTHOOK: type: QUERY -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 - Map Operator Tree: - TableScan - alias: src1 - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: key is not null (type: boolean) - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string) - outputColumnNames: _col0 - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE - TableScan - alias: src2 - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: key is not null (type: boolean) - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: string) - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col0 (type: string) - 1 _col0 (type: string) - outputColumnNames: _col0, _col2 - Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: UDFToInteger(_col0) (type: int), _col2 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE - 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.dest_j1 - - 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.dest_j1 - - Stage: Stage-2 - Stats-Aggr Operator - -PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) -INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@dest_j1 -POSTHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) -INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@dest_j1 -POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: dest_j1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT dest_j1.* FROM dest_j1 -PREHOOK: type: QUERY -PREHOOK: Input: default@dest_j1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT dest_j1.* FROM dest_j1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@dest_j1 -#### A masked pattern was here #### -0 val_0 -0 val_0 -0 val_0 -0 val_0 -0 val_0 -0 val_0 -0 val_0 -0 val_0 -0 val_0 -10 val_10 -100 val_100 -100 val_100 -100 val_100 -100 val_100 -103 val_103 -103 val_103 -103 val_103 -103 val_103 -104 val_104 -104 val_104 -104 val_104 -104 val_104 -105 val_105 -11 val_11 -111 val_111 -113 val_113 -113 val_113 -113 val_113 -113 val_113 -114 val_114 -116 val_116 -118 val_118 -118 val_118 -118 val_118 -118 val_118 -119 val_119 -119 val_119 -119 val_119 -119 val_119 -119 val_119 -119 val_119 -119 val_119 -119 val_119 -119 val_119 -12 val_12 -12 val_12 -12 val_12 -12 val_12 -120 val_120 -120 val_120 -120 val_120 -120 val_120 -125 val_125 -125 val_125 -125 val_125 -125 val_125 -126 val_126 -128 val_128 -128 val_128 -128 val_128 -128 val_128 -128 val_128 -128 val_128 -128 val_128 -128 val_128 -128 val_128 -129 val_129 -129 val_129 -129 val_129 -129 val_129 -131 val_131 -133 val_133 -134 val_134 -134 val_134 -134 val_134 -134 val_134 -136 val_136 -137 val_137 -137 val_137 -137 val_137 -137 val_137 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -143 val_143 -145 val_145 -146 val_146 -146 val_146 -146 val_146 -146 val_146 -149 val_149 -149 val_149 -149 val_149 -149 val_149 -15 val_15 -15 val_15 -15 val_15 -15 val_15 -150 val_150 -152 val_152 -152 val_152 -152 val_152 -152 val_152 -153 val_153 -155 val_155 -156 val_156 -157 val_157 -158 val_158 -160 val_160 -162 val_162 -163 val_163 -164 val_164 -164 val_164 -164 val_164 -164 val_164 -165 val_165 -165 val_165 -165 val_165 -165 val_165 -166 val_166 -167 val_167 -167 val_167 -167 val_167 -167 val_167 -167 val_167 -167 val_167 -167 val_167 -167 val_167 -167 val_167 -168 val_168 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -169 val_169 -17 val_17 -170 val_170 -172 val_172 -172 val_172 -172 val_172 -172 val_172 -174 val_174 -174 val_174 -174 val_174 -174 val_174 -175 val_175 -175 val_175 -175 val_175 -175 val_175 -176 val_176 -176 val_176 -176 val_176 -176 val_176 -177 val_177 -178 val_178 -179 val_179 -179 val_179 -179 val_179 -179 val_179 -18 val_18 -18 val_18 -18 val_18 -18 val_18 -180 val_180 -181 val_181 -183 val_183 -186 val_186 -187 val_187 -187 val_187 -187 val_187 -187 val_187 -187 val_187 -187 val_187 -187 val_187 -187 val_187 -187 val_187 -189 val_189 -19 val_19 -190 val_190 -191 val_191 -191 val_191 -191 val_191 -191 val_191 -192 val_192 -193 val_193 -193 val_193 -193 val_193 -193 val_193 -193 val_193 -193 val_193 -193 val_193 -193 val_193 -193 val_193 -194 val_194 -195 val_195 -195 val_195 -195 val_195 -195 val_195 -196 val_196 -197 val_197 -197 val_197 -197 val_197 -197 val_197 -199 val_199 -199 val_199 -199 val_199 -199 val_199 -199 val_199 -199 val_199 -199 val_199 -199 val_199 -199 val_199 -2 val_2 -20 val_20 -200 val_200 -200 val_200 -200 val_200 -200 val_200 -201 val_201 -202 val_202 -203 val_203 -203 val_203 -203 val_203 -203 val_203 -205 val_205 -205 val_205 -205 val_205 -205 val_205 -207 val_207 -207 val_207 -207 val_207 -207 val_207 -208 val_208 -208 val_208 -208 val_208 -208 val_208 -208 val_208 -208 val_208 -208 val_208 -208 val_208 -208 val_208 -209 val_209 -209 val_209 -209 val_209 -209 val_209 -213 val_213 -213 val_213 -213 val_213 -213 val_213 -214 val_214 -216 val_216 -216 val_216 -216 val_216 -216 val_216 -217 val_217 -217 val_217 -217 val_217 -217 val_217 -218 val_218 -219 val_219 -219 val_219 -219 val_219 -219 val_219 -221 val_221 -221 val_221 -221 val_221 -221 val_221 -222 val_222 -223 val_223 -223 val_223 -223 val_223 -223 val_223 -224 val_224 -224 val_224 -224 val_224 -224 val_224 -226 val_226 -228 val_228 -229 val_229 -229 val_229 -229 val_229 -229 val_229 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -233 val_233 -233 val_233 -233 val_233 -233 val_233 -235 val_235 -237 val_237 -237 val_237 -237 val_237 -237 val_237 -238 val_238 -238 val_238 -238 val_238 -238 val_238 -239 val_239 -239 val_239 -239 val_239 -239 val_239 -24 val_24 -24 val_24 -24 val_24 -24 val_24 -241 val_241 -242 val_242 -242 val_242 -242 val_242 -242 val_242 -244 val_244 -247 val_247 -248 val_248 -249 val_249 -252 val_252 -255 val_255 -255 val_255 -255 val_255 -255 val_255 -256 val_256 -256 val_256 -256 val_256 -256 val_256 -257 val_257 -258 val_258 -26 val_26 -26 val_26 -26 val_26 -26 val_26 -260 val_260 -262 val_262 -263 val_263 -265 val_265 -265 val_265 -265 val_265 -265 val_265 -266 val_266 -27 val_27 -272 val_272 -272 val_272 -272 val_272 -272 val_272 -273 val_273 -273 val_273 -273 val_273 -273 val_273 -273 val_273 -273 val_273 -273 val_273 -273 val_273 -273 val_273 -274 val_274 -275 val_275 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -277 val_277 -278 val_278 -278 val_278 -278 val_278 -278 val_278 -28 val_28 -280 val_280 -280 val_280 -280 val_280 -280 val_280 -281 val_281 -281 val_281 -281 val_281 -281 val_281 -282 val_282 -282 val_282 -282 val_282 -282 val_282 -283 val_283 -284 val_284 -285 val_285 -286 val_286 -287 val_287 -288 val_288 -288 val_288 -288 val_288 -288 val_288 -289 val_289 -291 val_291 -292 val_292 -296 val_296 -298 val_298 -298 val_298 -298 val_298 -298 val_298 -298 val_298 -298 val_298 -298 val_298 -298 val_298 -298 val_298 -30 val_30 -302 val_302 -305 val_305 -306 val_306 -307 val_307 -307 val_307 -307 val_307 -307 val_307 -308 val_308 -309 val_309 -309 val_309 -309 val_309 -309 val_309 -310 val_310 -311 val_311 -311 val_311 -311 val_311 -311 val_311 -311 val_311 -311 val_311 -311 val_311 -311 val_311 -311 val_311 -315 val_315 -316 val_316 -316 val_316 -316 val_316 -316 val_316 -316 val_316 -316 val_316 -316 val_316 -316 val_316 -316 val_316 -317 val_317 -317 val_317 -317 val_317 -317 val_317 -318 val_318 -318 val_318 -318 val_318 -318 val_318 -318 val_318 -318 val_318 -318 val_318 -318 val_318 -318 val_318 -321 val_321 -321 val_321 -321 val_321 -321 val_321 -322 val_322 -322 val_322 -322 val_322 -322 val_322 -323 val_323 -325 val_325 -325 val_325 -325 val_325 -325 val_325 -327 val_327 -327 val_327 -327 val_327 -327 val_327 -327 val_327 -327 val_327 -327 val_327 -327 val_327 -327 val_327 -33 val_33 -331 val_331 -331 val_331 -331 val_331 -331 val_331 -332 val_332 -333 val_333 -333 val_333 -333 val_333 -333 val_333 -335 val_335 -336 val_336 -338 val_338 -339 val_339 -34 val_34 -341 val_341 -342 val_342 -342 val_342 -342 val_342 -342 val_342 -344 val_344 -344 val_344 -344 val_344 -344 val_344 -345 val_345 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -35 val_35 -35 val_35 -35 val_35 -35 val_35 -35 val_35 -35 val_35 -35 val_35 -35 val_35 -35 val_35 -351 val_351 -353 val_353 -353 val_353 -353 val_353 -353 val_353 -356 val_356 -360 val_360 -362 val_362 -364 val_364 -365 val_365 -366 val_366 -367 val_367 -367 val_367 -367 val_367 -367 val_367 -368 val_368 -369 val_369 -369 val_369 -369 val_369 -369 val_369 -369 val_369 -369 val_369 -369 val_369 -369 val_369 -369 val_369 -37 val_37 -37 val_37 -37 val_37 -37 val_37 -373 val_373 -374 val_374 -375 val_375 -377 val_377 -378 val_378 -379 val_379 -382 val_382 -382 val_382 -382 val_382 -382 val_382 -384 val_384 -384 val_384 -384 val_384 -384 val_384 -384 val_384 -384 val_384 -384 val_384 -384 val_384 -384 val_384 -386 val_386 -389 val_389 -392 val_392 -393 val_393 -394 val_394 -395 val_395 -395 val_395 -395 val_395 -395 val_395 -396 val_396 -396 val_396 -396 val_396 -396 val_396 -396 val_396 -396 val_396 -396 val_396 -396 val_396 -396 val_396 -397 val_397 -397 val_397 -397 val_397 -397 val_397 -399 val_399 -399 val_399 -399 val_399 -399 val_399 -4 val_4 -400 val_400 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -401 val_401 -402 val_402 -403 val_403 -403 val_403 -403 val_403 -403 val_403 -403 val_403 -403 val_403 -403 val_403 -403 val_403 -403 val_403 -404 val_404 -404 val_404 -404 val_404 -404 val_404 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -407 val_407 -409 val_409 -409 val_409 -409 val_409 -409 val_409 -409 val_409 -409 val_409 -409 val_409 -409 val_409 -409 val_409 -41 val_41 -411 val_411 -413 val_413 -413 val_413 -413 val_413 -413 val_413 -414 val_414 -414 val_414 -414 val_414 -414 val_414 -417 val_417 -417 val_417 -417 val_417 -417 val_417 -417 val_417 -417 val_417 -417 val_417 -417 val_417 -417 val_417 -418 val_418 -419 val_419 -42 val_42 -42 val_42 -42 val_42 -42 val_42 -421 val_421 -424 val_424 -424 val_424 -424 val_424 -424 val_424 -427 val_427 -429 val_429 -429 val_429 -429 val_429 -429 val_429 -43 val_43 -430 val_430 -430 val_430 -430 val_430 -430 val_430 -430 val_430 -430 val_430 -430 val_430 -430 val_430 -430 val_430 -431 val_431 -431 val_431 -431 val_431 -431 val_431 -431 val_431 -431 val_431 -431 val_431 -431 val_431 -431 val_431 -432 val_432 -435 val_435 -436 val_436 -437 val_437 -438 val_438 -438 val_438 -438 val_438 -438 val_438 -438 val_438 -438 val_438 -438 val_438 -438 val_438 -438 val_438 -439 val_439 -439 val_439 -439 val_439 -439 val_439 -44 val_44 -443 val_443 -444 val_444 -446 val_446 -448 val_448 -449 val_449 -452 val_452 -453 val_453 -454 val_454 -454 val_454 -454 val_454 -454 val_454 -454 val_454 -454 val_454 -454 val_454 -454 val_454 -454 val_454 -455 val_455 -457 val_457 -458 val_458 -458 val_458 -458 val_458 -458 val_458 -459 val_459 -459 val_459 -459 val_459 -459 val_459 -460 val_460 -462 val_462 -462 val_462 -462 val_462 -462 val_462 -463 val_463 -463 val_463 -463 val_463 -463 val_463 -466 val_466 -466 val_466 -466 val_466 -466 val_466 -466 val_466 -466 val_466 -466 val_466 -466 val_466 -466 val_466 -467 val_467 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -469 val_469 -47 val_47 -470 val_470 -472 val_472 -475 val_475 -477 val_477 -478 val_478 -478 val_478 -478 val_478 -478 val_478 -479 val_479 -480 val_480 -480 val_480 -480 val_480 -480 val_480 -480 val_480 -480 val_480 -480 val_480 -480 val_480 -480 val_480 -481 val_481 -482 val_482 -483 val_483 -484 val_484 -485 val_485 -487 val_487 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -489 val_489 -490 val_490 -491 val_491 -492 val_492 -492 val_492 -492 val_492 -492 val_492 -493 val_493 -494 val_494 -495 val_495 -496 val_496 -497 val_497 -498 val_498 -498 val_498 -498 val_498 -498 val_498 -498 val_498 -498 val_498 -498 val_498 -498 val_498 -498 val_498 -5 val_5 -5 val_5 -5 val_5 -5 val_5 -5 val_5 -5 val_5 -5 val_5 -5 val_5 -5 val_5 -51 val_51 -51 val_51 -51 val_51 -51 val_51 -53 val_53 -54 val_54 -57 val_57 -58 val_58 -58 val_58 -58 val_58 -58 val_58 -64 val_64 -65 val_65 -66 val_66 -67 val_67 -67 val_67 -67 val_67 -67 val_67 -69 val_69 -70 val_70 -70 val_70 -70 val_70 -70 val_70 -70 val_70 -70 val_70 -70 val_70 -70 val_70 -70 val_70 -72 val_72 -72 val_72 -72 val_72 -72 val_72 -74 val_74 -76 val_76 -76 val_76 -76 val_76 -76 val_76 -77 val_77 -78 val_78 -8 val_8 -80 val_80 -82 val_82 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -85 val_85 -86 val_86 -87 val_87 -9 val_9 -90 val_90 -90 val_90 -90 val_90 -90 val_90 -90 val_90 -90 val_90 -90 val_90 -90 val_90 -90 val_90 -92 val_92 -95 val_95 -95 val_95 -95 val_95 -95 val_95 -96 val_96 -97 val_97 -97 val_97 -97 val_97 -97 val_97 -98 val_98 -98 val_98 -98 val_98 -98 val_98
