[jira] Updated: (HIVE-136) SerDe should escape some special characters

["Zheng Shao (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zheng Shao updated HIVE-136:
----------------------------

    Attachment: HIVE-136.1.patch

This patch adds the capability of escaping, following the MySQL way.

The command to create an escaped table is:
{code}
CREATE TABLE table1 (a STRING, b STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\';
{code}


> SerDe should escape some special characters
> -------------------------------------------
>
>                 Key: HIVE-136
>                 URL: https://issues.apache.org/jira/browse/HIVE-136
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Serializers/Deserializers
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>            Priority: Critical
>         Attachments: HIVE-136.1.patch
>
>
> MetadataTypedColumnsetSerDe and DynamicSerDe should escape some special characters like '\n' or the column/item/key separator.
> Otherwise the data will look corrupted.
> We plan to deprecate MetadataTypedColumnsetSerDe and DynamicSerDe for the simple delimited format, and use LazySimpleSerDe instead.
> So LazySimpleSerDe needs to have the capability of escaping and unescaping.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.