How to load data from flat files into Hive

Question

I want to load data from flat files into Hive, how can I do that? Can anyone suggest?

Answer 1

Hey,

You can load data from flat files into Hive using the command below:

'LOAD DATA... INTO TABLE' command

You can see the following example below:

• Load from local files

hive> LOAD DATA LOCAL INPATH './files/employees.txt' OVERWRITE INTO TABLE employees;

• Load from Hadoop files

hive> LOAD DATA INPATH './files/employees.txt' OVERWRITE INTO TABLE employees;

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