Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-8948

[hive] Support creating examples inside a transactional table

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.5.0
    • Fix Version/s: 4.6.0
    • Component/s: con.hive
    • Labels:
      None

      Description

      1. Switching to transactional by default only works in Hive 3+ (need ORC)
      2. LOAD won't work without an upload to HDFS currently (so not even S3)
      3. Text data files currently ranges from about 50 to 150k

      "transactional_properties"="insert_only" --> no DELETE

      Either the tables should be external or they should be created with tblproperties ("transactional"="true", "transactional_properties"="insert_only") e.g.
      
      create table foo (
      x int
      )
      stored as parquet
      tblproperties ("transactional"="true", "transactional_properties"="insert_only");
      
      insert into table foo2 values(1),(2);
      

        Attachments

          Activity

            People

            • Assignee:
              romain Romain Rigaux
              Reporter:
              romain Romain Rigaux
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: