Question

10-25. Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name, Seller, Price; the sec- ond to load data into the table from file ProductInfo.csv. Make all necessary assumptions.

Answer 1

1. To Create Table:-

create table if not exists PRODUCT (ProdID int, Name string, Seller string, Price float)  row format delimited  fields terminated by ',' ;  

Output:

INFO : Executing command (queryId=hive_20200129020612_e6cc96a-1243-4843-9689-ace442b99f78): create table if not exists PRODUCT (ProdID int, Name string, Seller string, Price float) row format delimite d fields terminated by : INFO : Completed executing command(queryId=hive_20200129020612_e6c6c96a-1243-4843-9689-ace 442b99f7 8): Time taken: 0.004 seconds INFO : OK

2. Assuming that the file that is to be loaded int the table is product.csv and it is present in the downloads folder of my computer it's location will be "/Users/my_name/Downloads/product.csv". So the query to load data will be:-

LOAD DATA INPATH '/Users/my_name/Downloads/product.csv' INTO TABLE PRODUCT;

Note:- file product.csv will get automatically deleted after loading data into the PRODUCT table.