Let us create our first table in Hive. We will also have a look into how to list the tables.
- We will get into details related to DDL Commands at a later point in time.
- For now we will just create our first table.
CREATE TABLE orders ( order_id INT, order_date STRING, order_customer_id INT, order_status STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
- We can list the tables using