Hive
  1. Hive
  2. HIVE-4554

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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.

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

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development