Hive
  1. Hive
  2. HIVE-3089

Support for add/drop partition and querying of static table links

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 0.10.0
    • Fix Version/s: None
    • Component/s: Metastore, Query Processor
    • Labels:
      None

      Description

      JIRA HIVE-2989 introduced the ability to create, drop and desc table links in Hive. This improvement adds on to table links, and allows the ability to:
      a) Add partition to a table link
      ALTER TABLELINK T@Y ADD [IF NOT EXISTS] PARTITION partition_spec PARTITION partition_spec ...
      The partition being added must be available on the source of the link table T since it is a link not a real partition.
      b) Drop partition on a table link
      ALTER TABLELINK T@Y DROP [IF EXISTS] PARTITION partition_spec, PARTITION partition_spec, ...
      This drop will not impact the source table of the link
      c) Query table links using T@Y syntax:
      SELECT DISTINCT user from T@Y where partition_key < 'val'
      This query will query the partitions on the source table of the table link.
      a) Set properties on a tablelink
      ALTER TABLELINK T@Y LINKPROPERTIES(PROPERTY='value');

      Once this patch is submitted, in conjunction with HIVE_2989, a user can create a link, add and drop partitions from it and query the data in the table link.

      Dynamic link support is being added in a separate JIRA.

        Activity

        Sambavi Muthukrishnan created issue -

          People

          • Assignee:
            Sambavi Muthukrishnan
            Reporter:
            Sambavi Muthukrishnan
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:

              Time Tracking

              Estimated:
              Original Estimate - 168h
              168h
              Remaining:
              Remaining Estimate - 168h
              168h
              Logged:
              Time Spent - Not Specified
              Not Specified

                Development