The error that you are getting, is due the path that you are specifying in load statement.
Please make sure the path that you are specifying is correct and file is present there.

Abhishek Tiwari
edureka! Support Team
On Sun, 3 Apr at 1:16 PM , Sid23.vyas <> wrote:
hive> LOAD DATA LOCAL INPATH   "home/edureka/Desktop/LMS/hive/hive---advance-hive-codes/txns1.txt"   INTO TABLE txnrecordss;                 
FAILED: SemanticException Line 1:25 Invalid path ""home/edureka/Desktop/LMS/hive/hive---advance-hive-codes/txns1.txt"": No files matching path file:/home/edureka/home/edureka/Desktop/LMS/hive/hive---advance-hive-codes/txns1.txt
what kind of problem iam getting