[
https://issues.apache.org/jira/browse/HIVE-4554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13672512#comment-13672512
]
Xuefu Zhang commented on HIVE-4554:
-----------------------------------
Thank you, Ashutosh.
I have updated the batch using URIUtil.decode() to decode the special
characters in the path instead of using getPath(), which does the decoding but
causes the problems as you mentioned.
> Failed to create a table from existing file if file path has spaces
> -------------------------------------------------------------------
>
> Key: HIVE-4554
> URL: https://issues.apache.org/jira/browse/HIVE-4554
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.10.0
> Reporter: Xuefu Zhang
> Assignee: Xuefu Zhang
> Attachments: HIVE-4554.patch, HIVE-4554.patch.1, HIVE-4554.patch.2
>
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
