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.

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_properties'='insert_only');