Mithun Radhakrishnan created HIVE-9386:
------------------------------------------

             Summary: FileNotFoundException when using in_file()
                 Key: HIVE-9386
                 URL: https://issues.apache.org/jira/browse/HIVE-9386
             Project: Hive
          Issue Type: Bug
          Components: UDF
            Reporter: Mithun Radhakrishnan
            Assignee: Mithun Radhakrishnan


When a full file-path is specified in {{in_file()}}, and the query runs as a 
local-job (i.e. without MR/Tez), one sees the following FNFE:

java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: 
java.io.FileNotFoundException: int_list.txt (No such file or directory)
        at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:152)
        at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:1651)
        at 
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:227)
        at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:159)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:370)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:305)
        at 
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:702)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:615)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
...

It looks like {{GenericUDFInFile}} trims the file-path to just the file-name, 
perhaps under the assumption that the file would be in DistributedCache. In 
case the job runs locally, the file ought to be read using the full path.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to