How to load data from flat files into different partitions of Hive table

Question

I want to load data from flat files into different partitions of hive table? How do I do that? Can anyone suggest?

Answer 1

Hi,

You can load data from flat files into different partitions of Hive tables using this command below:

LOAD DATA...INTO TABLE...PARTITION...

You can see the below example to have a clear idea:

• Load from local files

hive> LOAD DATA LOCAL INPATH './files/employees.txt' OVERWRITE INTO TABLE employees PARTITION (ds='2008-08-15');

• Load from Hadoop files:

hive> LOAD DATA INPATH './examples/files/employees.txt' OVERWRITE INTO TABLE employees PARTITION (ds='2008-08-15');

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