[
https://issues.apache.org/jira/browse/HIVE-9798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349307#comment-14349307
]
Anitha commented on HIVE-9798:
------------------------------
Hive is behaving weirdly for this issue. In some cases \ is considered by the
length function and in some cases not.And when the data is of maximum length
defined due to extra slash last character of the data is being truncated ( as
shown in second case below)
Source Data1: BOB RICHARD TOY\N AUGUSTA [Dealer_Dim table]
Length: 25
Hive Data1: BOB RICHARD TOY"\\"N AUGUSTA
Length: 25
Source Data2: VEH- ALLSTATE-POLICY #-01485550011\08 CLAIM# 2071985861 NOT HAVE
CUST HAS NO MED [DST_CASE table]
Length: 80
Hive Data2: VEH- ALLSTATE-POLICY #-01485550011\\08 CLAIM# 2071985861 NOT HAVE
CUST HAS NO ME
Length: 80
> Slash character in HDFS file is displayed as double Slash in Hive
> -----------------------------------------------------------------
>
> Key: HIVE-9798
> URL: https://issues.apache.org/jira/browse/HIVE-9798
> Project: Hive
> Issue Type: Bug
> Reporter: Anitha
>
> Single slash character in source is displayed as double slash in HIVE.
> Example:
> Oracle Source: BOB RICHARD TOY\N AUGUSTA
> Hive = BOB RICHARD TOY\\N AUGUSTA
> Note: HDFS file has correct data, single slash only. Also, Impala displays
> the data correctly, issue is with Hive display only.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
