USE training_retail;

CREATE TABLE order_items_stage (
  order_item_id INT,
  order_item_order_id INT,
  order_item_product_id INT,
  order_item_quantity INT,
  order_item_subtotal FLOAT,
  order_item_product_price FLOAT
) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';

LOAD DATA LOCAL INPATH '/data/retail_db/order_items' INTO TABLE order_items_stage;

INSERT INTO TABLE order_items
SELECT * FROM order_items_stage;

SELECT * FROM order_items;
SELECT count(1) FROM order_items;