Question

Please Create a Hive table based on columns present in the csv file. Include the create table command and show the screen snapshot of table schema using describe <tablename> command. Please show output.

Region

Country

Item Type

Sales Channel

Order Priority

Order Date

Order ID

Ship Date

Units Sold

Unit Price

Unit Cost

Total Revenue

Total Cost

Total Profit

Sub-Saharan Africa

South Africa

Fruits

Offline

M

7/27/2012

443368995

7/28/2012

1593

9.33

6.92

14862.69

11023.56

3839.13

Middle East and North Africa

Morocco

Clothes

Online

M

9/14/2013

667593514

10/19/2013

4611

109.28

35.84

503890.08

165258.24

338631.84

Answer 1

Solution

create external table tablename
(region string,
country string,
item_type string,
sales_channel string,
order_priority string,
order_date date,
order_id int,
ship_date date,
units_sold int,
unit_price double,
unit_cost double,
total_revenue double,
total_cost double)
row format delimited fields terminated by',' stored as textfile location'/user/hive/tan/sales_hive_table' TBLPROPERTIES("skip.header.line.count"="1");

--

after TOtal_cost field there is another field which is not visible

using the

describe tablename;

you can view the schema

==

all the best