DW Lab1

CREATE TABLE IF NOT EXISTS vnr_table

(col1 int COMMENT 'col1',

col2 string,

col3 int,

col4 DECIMAL,

col5 int)

COMMENT 'This is test table'

ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;

Desc vnr_table;

load data LOCAL INPATH '/home/cloudera/Desktop/movies_data.csv' OVERWRITE INTO TABLE vnr_table;

select * from vnr_table;