You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Anitha (JIRA)" <ji...@apache.org> on 2015/03/12 23:08:38 UTC

[jira] [Commented] (SQOOP-319) The --hive-drop-import-delims option should accept a replacement string

    [ https://issues.apache.org/jira/browse/SQOOP-319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14359520#comment-14359520 ] 

Anitha commented on SQOOP-319:
------------------------------

Hi Team,
  This option --hive-delims-replacement is not working for Oracle CLOB data with 0D 0A characters. Can you please check on this. 

Thanks,
AnithaKS

> The --hive-drop-import-delims option should accept a replacement string
> -----------------------------------------------------------------------
>
>                 Key: SQOOP-319
>                 URL: https://issues.apache.org/jira/browse/SQOOP-319
>             Project: Sqoop
>          Issue Type: Bug
>          Components: hive-integration
>    Affects Versions: 1.3.0
>            Reporter: Joey Echeverria
>            Assignee: Joey Echeverria
>            Priority: Minor
>             Fix For: 1.4.0-incubating
>
>         Attachments: SQOOP-319-1.patch, SQOOP-319-2.patch
>
>
> When importing data into hive, you have the option of dropping the hive delimiters in data fields. It would be more useful to replace the delimiters with a user defined string. Often times the dropped delimiters (like \n) are separating words. If I want to split on white space in my hive queries, I'll now get two words merged together. A more desirable behavior would be to replace it with a space. Making it user configurable will give the most flexibility.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)