Member since
10-16-2013
3
Posts
0
Kudos Received
0
Solutions
04-11-2014
12:42 PM
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.
... View more
Labels:
- Labels:
-
Apache Hive