Hello, The "LOAD DATA LOCAL INPATH ..." will search the file into the local file system of the server where Hive is running, ie computer A for you.
"LOAD DATA INPATH" will look for the file into the hadoop file system. More information here : <goog_1319724303> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML And i have no clue how to actually insert the data only through the jdbc client. Regards David On Fri, Feb 28, 2014 at 10:22 AM, Jone Lura <jone.l...@ecc.no> wrote: > 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 > > >
