Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-335

External Tables should have the option to be marked Read Only

    XMLWordPrintableJSON

    Details

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

      Description

      When creating an External Table, it'd be awesome to have the option of NOT allowing writes to it (disallow any INSERTs or if hive ever allows UPDATEs). Adding and Dropping Partitions should still be allowed.

      This will enable hive to "play well" with external data stores other than hdfs where data should be non-maleable.

      I'd recomend the following syntax, which applies ONLY to external tables:

      CREATE EXTERNAL [READONLY] TABLE ...

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rl337 Richard Lee
            • Votes:
              13 Vote for this issue
              Watchers:
              21 Start watching this issue

              Dates

              • Created:
                Updated: