Hadoop Hive How to insert data in Hive table

Question

I created a table in hive:

create table foo (id int, name string);

Now, I want to insert data into this table. Can I do something like this?

insert into foo (id, name) VALUES (12,"xyz);

Also, I have a csv file which contains data in the format:

1,name1
2,name2
..
..

..


1000,name1000

How can I load this data in the table?

Answer 1

First, copy data into HDFS. Then create external table over your CSV like this

CREATE EXTERNAL TABLE TableName (id int, name string)
ROW FORMAT DELIMITED   
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION 'place in HDFS';

Now you can insert data into other Hive table: 

insert overwrite table finalTable select * from table name;