hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anitha (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9798) Slash character in HDFS file is displayed as double Slash in Hive
Date Thu, 05 Mar 2015 19:16:38 GMT

    [ 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)

Mime
View raw message