daily pastebin goal
74%
SHARE
TWEET

Untitled

a guest Dec 9th, 2018 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE orders (
  2.   order_id INT,
  3.   order_date STRING,
  4.   order_customer_id INT,
  5.   order_status STRING
  6. ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
  7.  
  8. LOAD DATA LOCAL INPATH '/home/itversity/data/retail_db/orders' INTO TABLE orders;
  9.  
  10. SELECT * FROM orders LIMIT 10;
  11.  
  12. SELECT order_status, count(1) FROM orders
  13. GROUP BY order_status;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top