As a work around, can you copy the file locally on the server and use the complete path (local to the server) in the query?
On 8/9/09 10:12 PM, "Saurabh Nanda" <[email protected]> wrote: > Is the "add file" command not supported in the JDBC API? I need to use it for > subsequent custom map/reduce scripts in various queries. The file is available > locally to the Hive server. > > 09/08/10 10:40:00 INFO service.HiveServer: Running the query: add file > parse_logs.pl; > 09/08/10 10:40:00 INFO ql.Driver: Starting command: add file parse_logs.pl; > 09/08/10 10:40:00 INFO parse.ParseDriver: Parsing command: add file > parse_logs.pl; > FAILED: Parse Error: line 1:0 cannot recognize input 'add' > > 09/08/10 10:40:01 ERROR ql.Driver: FAILED: Parse Error: line 1:0 cannot > recognize input 'add' > > org.apache.hadoop.hive.ql.parse.ParseException: line 1:0 cannot recognize > input 'add' > > at > org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:357) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:190) > at > org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer > .java:107) > at > org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(ThriftHive > .java:261) > at > org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:24 > 9) > at > com.facebook.thrift.server.TThreadPoolServer$WorkerProcess.run(Unknown Source) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java > :886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908> ) > at java.lang.Thread.run(Thread.java:619) > > Saurabh.
