CREATE TABLE orders (
  order_id INT,
  order_date STRING,
  order_customer_id INT,
  order_status STRING
) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';

LOAD DATA LOCAL INPATH '/home/itversity/data/retail_db/orders' INTO TABLE orders;

SELECT * FROM orders LIMIT 10;

SELECT order_status, count(1) FROM orders
GROUP BY order_status;