Relation between LOAD operation and LOCAL keyword

Question

Hi,

How is LOAD operation and LOCAL keyword are related, can anyone clarify this?

Answer 1

Hey,

The Load operation is used to move the data into corresponding Hive table. If the keyword local is specified, then in the load command will give the local file system path. If the keyword local is not specified we have to use the HDFS path of the file.

Syntax: 

LOAD data <LOCAL> inpath <file path> into table [tablename]