[jira] [Commented] (HIVE-9798) Slash character in HDFS file is displayed as double Slash in Hive

["Gayathiri Duraikannu (JIRA)" <ji...@apache.org>]

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

Gayathiri Duraikannu commented on HIVE-9798:
--------------------------------------------

We are also having a similar issue in our project where the data is HDFS is having a single backslash but when queried with hive, double backslash is displayed. As this field is a varchar(60) and having 60 length, the last character is getting truncated. Hive is considering the escape backslash internally added by the hive program as one character and ignoring the last character in the actual data.

HDFS: 
Org_!@#\ab%^()_test1tt2t928dbb73-e4e4-4c7c-a948-0391ba34f8cf

Hive: 
Org_!@#\\ab%^()_test1tt2t928dbb73-e4e4-4c7c-a948-0391ba34f8c

Clients are missing the 'f' at the end when viewing the data with hive. 

when the data is selected and written to a file, it's displaying correctly. As a work around we are casting the column to String. 

Please let me know if there is any permanent solution for it. 


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