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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.10.0
    • 0.12.0
    • CLI
    • 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.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

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

            Dates

              Created:
              Updated:
              Resolved: