Using Apache HiveQL
Also available as:
PDF

Create an insert-only transactional table

You can create a transactional table using any storage format if you do not require update and delete capability.

In this task, you create an insert-only transactional table for storing text.

  1. Start the Hive shell:
    [vagrant@c7401]# hive
  2. Enter your user name and password.
    The Hive 3 connection message appears, followed by the Hive prompt for entering queries on the command line.
  3. Create a insert-only transactional table named T2 having two integer columns, a and b:
    CREATE TABLE T2(a int, b int) 
     TBLPROPERTIES ('transactional'='true', 
     'transactional_properties'='insert_only');