Hi all,
I am trying to understand why I receive the following exception;
java.sql.SQLException: Error while processing statement: FAILED:
SemanticException Line 1:23 Invalid path
''/Users/jonelura/tmp/dual1676162777709284665.csv'': No files matching path
file:/Users/jonelura/tmp/dual1676162777709284665.csv
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:161)
at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:149)
at
org.apache.hive.jdbc.HivePreparedStatement.executeImmediate(HivePreparedStatement.java:187)
at
org.apache.hive.jdbc.HivePreparedStatement.execute(HivePreparedStatement.java:137)
at
no.ecc.nais.io.storage.HiveSQLStorage.createDualTable(HiveSQLStorage.java:545)
...
...
I have two computers.
Computer A - Running Hadoop (1.2.1) and Hiveserver (0.11.0) and web application
myApp, connected to Hive with Hive JDBC driver 0.11.0
Computer B - Running web application myApp connected to Hive with Hive JDBC
driver 0.11.0
The exception above is thrown on Computer B, whilst Computer A works fine.
The SQL for loading the data is;
LOAD DATA LOCAL INPATH '/Users/jonelura/tmp/dual1676162777709284665.csv'
OVERWRITE INTO TABLE dual
For some reason it looks for the
/Users/jonelura/tmp/dual1676162777709284665.csv on Computer A (Hive and
Hadoop), instead of Computer B (where the file exists)
Is there another load syntax I should have used?
Best regards,
Jone
