Creating First Table in Hive and list the tables

#1

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 SHOW tables;

Practice hive on state of the art Big Data cluster - https://labs.itversity.com
You can sign up for our courses on Udemy using $10 coupons - Udemy Coupons - Big Data Courses


0 Likes