Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search

Who agreed with this topic

Load data local inpath says "invalid path" when my file is right where I tell it to look!

Labels:
avatar
author-rank Bozz
New Contributor

Created on ‎04-11-2014 12:42 PM - edited ‎09-16-2022 01:57 AM

I'm writing a program in Java, where I need to load a file from my local disk into Hive. I'm using the JDBC driver for this. The query my program generates looks like this:

 

load data local inpath '/home/cloudera/temp/testpart/90d0584c080a6607128e03c0cee8a2a666bf83f1b11882d24b72ae420e60e8a3.lzo' into table checkpoint_part partition(year=2014, month=04, day=03, hour=12, minute=17)

 

Yes, the program is running in the same machine where both the file and Hive are. I'm getting this exception:


java.sql.SQLException: Error while processing statement: FAILED: SemanticException Line 1:23 Invalid path '"/home/cloudera/temp/testpart/90d0584c080a6607128e03c0cee8a2a666bf83f1b11882d24b72ae420e60e8a3.lzo"': No files matching path file:/home/cloudera/temp/testpart/90d0584c080a6607128e03c0cee8a2a666bf83f1b11882d24b72ae420e60e8a3.lzo
    at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:159)
    at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:147)
    at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:182)
    at Program.main(Program.java:230)

Anyone could help me with this? I'm completely lost. I mean, the file is right there.

26,422
0 Kudos
1
Who agreed with this topic