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.
edureka! Support Team
On Sun, 3 Apr at 1:16 PM , Sid23.vyas <email@example.com> 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.txthive>what kind of problem iam getting