| DROP TABLE IF EXISTS joinsrc1; |
| DROP TABLE IF EXISTS joinsrc2; |
| DROP TABLE IF EXISTS u6_large_card_join; |
| |
| -- create the tables and load the data |
| create external table joinsrc1 (ID_1 INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' |
| STORED AS TEXTFILE LOCATION '/test/joinsrc1'; |
| |
| create external table joinsrc2 (ID_2 INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' |
| STORED AS TEXTFILE LOCATION '/test/joinsrc2'; |
| |
| -- create the result tables |
| create table u6_large_card_join(col1 int, col2 int); |
| |
| -- the query |
| insert overwrite table u6_large_card_join |
| select |
| ID_1, ID_2 |
| from |
| joinsrc1 join joinsrc2 |
| on |
| joinsrc1.ID_1=joinsrc2.ID_2; |
| |