Creating a CRUD transactional table

You create a CRUD transactional table having ACID (atomic, consistent, isolated, and durable) properties when you need a managed table that you can update, delete, and merge. You learn by example how to determine the table type.

In this task, you create a CRUD transactional table. You cannot sort this type of table. To create a CRUD transactional table, you must accept the default ORC format by not specifying any storage during table creation, or by specifying ORC storage explicitly.

  1. Start Hive.
  2. Enter your user name and password.
    The Hive 3 connection message, followed by the Hive prompt for entering SQL queries on the command line, appears.
  3. Create a CRUD transactional table named T having two integer columns, a and b:
    CREATE TABLE T(a int, b int);
  4. Confirm that you created a managed, ACID table.
    DESCRIBE FORMATTED T;
    The table type says MANAGED_TABLE and transactional = true.