Load data into the hive table

Question

Hi 

I"m working on the project and I already copied the file from which I have to copy the data on local FS and then I copy that to hdfs. Now, how do I load that data into the table which I have created on the hive? I tried using

load data local inpath "filename" into table tablename

Answer 1

You can try something like this:

hadoop dfs -put dataset.txt Vaibhav

hive

load data inpath Vaibhav/dataset.txt into table table_name;

To know more, It's recommended to join Big Data Course today.

Answer 2

Hi,

We can use a normal insert query to load data into a sequence file format table. Data will be converted into a sequence file format while loading the data.

$ insert into table employee_seq select * from employee;