Hive
  1. Hive
  2. HIVE-2786

Throw an error if the user tries to insert a table into a region other than the primary region

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      By default, the user can only insert into the primary region.

      Add an option to insert into the secondary region also.
      The config variable is 'hive.insert.secondary.regions' - default for that variable is false

        Activity

        Hide
        Namit Jain added a comment -

        The semantics are as follows:

        If the table/partition is present in the primary region, and the insert is happening in the secondary region, verify that the table/partition is the same (the file size should be exactly
        the same). Otherwise, the operation fails.

        If the table/partition is present in the secondary region, and the insert is happening in the primary region, verify that the table/partition is the same (the file size should be exactly
        the same). Otherwise, the secondary region needs to be deleted.

        Show
        Namit Jain added a comment - The semantics are as follows: If the table/partition is present in the primary region, and the insert is happening in the secondary region, verify that the table/partition is the same (the file size should be exactly the same). Otherwise, the operation fails. If the table/partition is present in the secondary region, and the insert is happening in the primary region, verify that the table/partition is the same (the file size should be exactly the same). Otherwise, the secondary region needs to be deleted.
        Hide
        Namit Jain added a comment -

        This is not needed

        Show
        Namit Jain added a comment - This is not needed

          People

          • Assignee:
            Namit Jain
            Reporter:
            Namit Jain
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development