Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-4554

Failed to create a table from existing file if file path has spaces

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.10.0
    • Fix Version/s: 0.12.0
    • Component/s: CLI
    • Labels:
      None

      Description

      To reproduce the problem,

      1. Create a table, say, person_age (name STRING, age INT).
      2. Create a file whose name has a space in it, say, "data set.txt".
      3. Try to load the date in the file to the table.

      The following error can be seen in the console:

      hive> LOAD DATA INPATH '/home/xzhang/temp/data set.txt' INTO TABLE person_age;
      Loading data to table default.person_age
      Failed with exception Wrong file format. Please check the file's format.
      FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

      Note: the error message is confusing.

        Attachments

        1. HIVE-4554.patch
          0.7 kB
          Xuefu Zhang
        2. HIVE-4554.patch.1
          5 kB
          Xuefu Zhang
        3. HIVE-4554.patch.2
          4 kB
          Xuefu Zhang
        4. HIVE-4554.patch.3
          4 kB
          Xuefu Zhang
        5. HIVE-4554.patch.4
          8 kB
          Xuefu Zhang
        6. HIVE-4554.patch.5
          8 kB
          Xuefu Zhang

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: