Hi,
Did you set hive.auto.convert.join=true and try? It does a runtime check of
input table sizes and autoconverts join operators to mapjoin if possible.
I'm not sure if it does it for subqueries too, need to look into the code
base. If any of the devs can confirm, that would be great.
- Bharath
Hi,
Is there anyway mapjoin works on the subquery(not the underlying table). I
have the following query:
select external_id,count(category_id) from
catalog_products_in_categories_orc pc inner join (select * from
catalog_products_orc where s_id=118) p on pc.product_id=p.id group by
external_id;