Hive
  1. Hive
  2. HIVE-6048

Hive load data command rejects file with '+' in the name

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.12.0
    • Fix Version/s: 0.13.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      '+' is a valid character in a file name on linux and HDFS. However, loading data from such a file into table results the following error:

      hive> load data local inpath '/home/xzhang/temp/t+est.txt' into table test;
      Copying data from file:/home/xzhang/temp/t est.txt
      No files matching path: file:/home/xzhang/temp/t est.txt
      FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.CopyTask
      
      1. HIVE-6048.4.patch
        49 kB
        Xuefu Zhang
      2. HIVE-6048.3.patch
        50 kB
        Xuefu Zhang
      3. HIVE-6048.2.patch
        57 kB
        Xuefu Zhang
      4. HIVE-6048.1.patch
        24 kB
        Xuefu Zhang
      5. HIVE-6048.patch
        14 kB
        Xuefu Zhang

        Issue Links

          Activity

          Xuefu Zhang created issue -
          Xuefu Zhang made changes -
          Field Original Value New Value
          Attachment HIVE-6048.patch [ 12619258 ]
          Xuefu Zhang made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Xuefu Zhang made changes -
          Description '+' is a valid character in a file name on linux and HDFS. However, loading data from such a file into table results the following error:

          {code}
          hive> load data local inpath './t+est' into table test;
          FAILED: SemanticException Line 1:23 Invalid path ''./t+est'': No files matching path file:/home/xzhang/apache/hive7/t%20est
          {code}
          '+' is a valid character in a file name on linux and HDFS. However, loading data from such a file into table results the following error:

          {code}
          hive> load data local inpath '/home/xzhang/temp/t+est.txt' into table test;
          Copying data from file:/home/xzhang/temp/t est.txt
          No files matching path: file:/home/xzhang/temp/t est.txt
          FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.CopyTask
          {code}
          Xuefu Zhang made changes -
          Attachment HIVE-6048.1.patch [ 12619491 ]
          Xuefu Zhang made changes -
          Attachment HIVE-6048.2.patch [ 12619669 ]
          Xuefu Zhang made changes -
          Remote Link This issue links to "https://reviews.apache.org/r/16412/ (Web Link)" [ 13535 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5565.3.patch [ 12619971 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5565.3.patch [ 12619971 ]
          Xuefu Zhang made changes -
          Attachment HIVE-6048.3.patch [ 12619972 ]
          Xuefu Zhang made changes -
          Attachment HIVE-6048.4.patch [ 12619977 ]
          Ashutosh Chauhan made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Fix Version/s 0.13.0 [ 12324986 ]
          Resolution Fixed [ 1 ]

            People

            • Assignee:
              Xuefu Zhang
              Reporter:
              Xuefu Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development