Question

How can we specify in Hive to load an HDFS file in LOAD DATA?

Answer 1

We have to remove the LOCAL clause from LOAD DATA statement to avoid loading  the local file. Once LOCAL clause is removed, we can load HDFS file.