/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/smb_mapjoin_3.q
text | 53 lines | 33 code | 20 blank | 0 comment | 0 complexity | 5615bce4d5dceefa27d05a9a3f09a80e MD5 | raw file
1 2 3 4 5create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE; 6create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE; 7create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE; 8 9load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1; 10load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2; 11load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3; 12 13set hive.optimize.bucketmapjoin = true; 14set hive.optimize.bucketmapjoin.sortedmerge = true; 15set hive.input.format = org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat; 16 17explain 18select /*+mapjoin(a)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key; 19select /*+mapjoin(a)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key; 20 21explain 22select /*+mapjoin(a)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key; 23select /*+mapjoin(a)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key; 24 25explain 26select /*+mapjoin(a)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key; 27select /*+mapjoin(a)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key; 28 29explain 30select /*+mapjoin(a)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key; 31select /*+mapjoin(a)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key; 32 33 34explain 35select /*+mapjoin(b)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key; 36select /*+mapjoin(b)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key; 37 38explain 39select /*+mapjoin(b)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key; 40select /*+mapjoin(b)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key; 41 42explain 43select /*+mapjoin(b)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key; 44select /*+mapjoin(b)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key; 45 46explain 47select /*+mapjoin(b)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key; 48select /*+mapjoin(b)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key; 49 50 51 52 53