[ https://issues.apache.org/jira/browse/HIVE-18201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-18201: ------------------------------------ Attachment: HIVE-18201.1.patch Patch which makes Hive to decide running cross product using broadcast vs xprod edge using a config. > Disable XPROD_EDGE for sq_count_check() created for scalar subqueries > ---------------------------------------------------------------------- > > Key: HIVE-18201 > URL: https://issues.apache.org/jira/browse/HIVE-18201 > Project: Hive > Issue Type: Bug > Affects Versions: 3.0.0 > Reporter: Nita Dembla > Attachments: HIVE-18201.1.patch, query6.explain2.out > > > sq_count_check() will either return an error at runtime or a single row. In > case of query6, the subquery has avg() function that should return a single > row. Attaching the explain. > This does not need an x-prod, because it is not useful to shuffle the big > table side for a cross-product against 1 row. -- This message was sent by Atlassian JIRA (v6.4.14#64029)