LOAD in Hive

Question

LOAD

• When you want to load data from your local machine,

load data local inpath [FilePath] into table <tablename>

Or

LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename [PARTITION (partcol1=val1, partcol2=val2 ...)]

• When you want to load data directly from HDFS,

load data  inpath  into table <tablename>

{Hive will search for the file in HDFS}