jVKcdSj9

1Step 1: create Database
2hive> CREATE DATABASE driverdata;
3OK
4Time taken: 0.504 seconds
5
6Step 2: create table if not exista
7hive> CREATE TABLE IF NOT EXISTS driver(
8    driverId INT,
9    name STRING,
10    ssn STRING,
11    location STRING,
12    certified STRING,
13    wageplan STRING)
14    ROW FORMAT DELIMITED
15    FIELDS TERMINATED BY ',';
16OK
17Time taken: 2.041 seconds
18
19Step 3: Load data
20hive> LOAD DATA LOCAL INPATH '/root/Downloads/driver_data/driver_data/drivers.csv'OVERWRITE INTO TABLE driver;
21Loading data to table driverdata.driver
22OK
23Time taken: 3.445 seconds
24
25Step 4: Select the first 30
26hive> select * from driver limit 30;