[ https://issues.apache.org/jira/browse/HIVE-18201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16563908#comment-16563908 ]
Jesus Camacho Rodriguez commented on HIVE-18201: ------------------------------------------------ [~ashutoshc], thanks for letting me know. I have created HIVE-20281, I will take a look at it. If you want to push this patch already, feel free to comment the test, since issue seems to be already existing (not created by this patch). > 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 > Assignee: Ashutosh Chauhan > Priority: Major > Attachments: HIVE-18201.1.patch, HIVE-18201.2.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 (v7.6.3#76005)