[jira] [Assigned] (HIVE-17675) verify SMB join with multiple inserts

["Deepak Jaiswal (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-17675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Deepak Jaiswal reassigned HIVE-17675:
-------------------------------------

    Assignee: Deepak Jaiswal

> verify SMB join with multiple inserts
> -------------------------------------
>
>                 Key: HIVE-17675
>                 URL: https://issues.apache.org/jira/browse/HIVE-17675
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Sergey Shelukhin
>            Assignee: Deepak Jaiswal
>
> Hive has a family of joins that interact with sorted and bucketed tables. Afaik one (all?) of them actually rely on the table being sorted, rather than sorting it. 
> If one runs insert on such a table without merge more than once, there'd be 2+ files for every bucket that are individually sorted; but globally, the table would no longer be sorted.
> Would these joins work/disable themselves correctly in this case, or could it produce incorrect results? We might need a q file.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)