Versions Compared

Old Version 13

changes.mady.by.user Alan Gates

Saved on

compared with

New Version 14

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: add version for TRANSACTIONAL and link to TBLPROPERTIES in DDL doc

...

If a table is to be used in ACID writes (insert, update, delete) , then the table property TRANSACTIONAL must be set on that table, starting with Hive 0.14.0.  Without this value, inserts will be done in the old style; updates and deletes will be prohibited.  However, this does not apply to Hive 0.13.0.

If a table owner does not wish the system to automatically determine when to compact, then the table property NO_AUTO_COMPACTION can be set.  This will prevent all automatic compactions.  Manual compactions can still be done with Alter Table/Partition Compact statements.

Table properties are set with the TBLPROPERTIES clause when a table is created or altered, as described in the Create Table and Alter Table Properties sections of Hive Data Definition Language.