[
https://issues.apache.org/jira/browse/HIVE-9798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349264#comment-14349264
]
Anitha commented on HIVE-9798:
------------------------------
Single slash character in source is displayed as double slash in HIVE.
Oracle USS DEALER_DIM.DEALER_NM_TXT = BOB RICHARD TOY\N AUGUSTA
Hive USS_DEALER_DIM.DEALER_NM_TXT = BOB RICHARD TOY\\N AUGUSTA
Below are some findings after analysis:
1. The HDFS file is showing correct data with single slash.
2. Imapala shows correct data.
3. Parquet file created through Hive or Impala, when viewed through Impala
shows correct data while with Hive shows double slash.
4. If we do the substr of this data, both in Hive and Impala only single slash
is displayed.
> 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)
