7HujGFhq

11. Copy File sales_record.csv Via Ambari ke folder User masing-masing
2
32. Buka Ambari Query :
4
5CREATE EXTERNAL TABLE IF NOT EXISTS sales_record(
6      Region STRING,
7      Country STRING,
8      Item_type STRING,
9      Sales_channel STRING,
10      Order_priority STRING,
11      Order_date DATE,
12      Order_id INT,
13      Ship_date DATE,
14      Unit_sold INT,
15      Unit_price INT,
16      Unit_cost INT,
17      Total_revenue INT,
18      Total_cost INT,
19      Total_profit INT)
20COMMENT 'Data about Sales Order from a public database'
21ROW FORMAT DELIMITED
22FIELDS TERMINATED BY ','
23STORED AS TEXTFILE
24location '/user/admin/'
25tblproperties ("skip.header.line.count"="1");
26
27
283. Buka Ambari Query :
29
30CREATE EXTERNAL TABLE IF NOT EXISTS data_sales_record(
31        Region STRING,
32	Country STRING,
33  	Item_type STRING,
34	Sales_channel STRING,
35	Order_priority STRING,
36	Order_date DATE,
37	Order_id INT,
38	Ship_date DATE,
39	Unit_sold INT,
40	Unit_price INT,
41	Unit_cost INT,
42	Total_revenue INT,
43	Total_cost INT,
44	Total_profit INT)
45COMMENT 'Data about Sales Order from a public database'
46ROW FORMAT DELIMITED
47FIELDS TERMINATED BY ','
48STORED AS ORC;
49
504. LOAD DATA INPATH '/user/admin/sales_record.csv' INTO TABLE sales_order;
51
525. INSERT OVERWRITE TABLE data_sales_record SELECT * FROM sales_record;