Hari Prasad G created HIVE-26097:
------------------------------------
Summary: Hive Table containing unicode data is not writing data to
target properly
Key: HIVE-26097
URL: https://issues.apache.org/jira/browse/HIVE-26097
Project: Hive
Issue Type: Bug
Affects Versions: 3.1.2
Reporter: Hari Prasad G
*Source Table data which is staged in Amazon S3 location:*
+----------------------------------------------------+
|all_char.col|
+----------------------------------------------------+
|abcThe Hunger GamesThe Hunger Games 1by Suzanne CollinsPART ITHE
TRIBUTES1.When I wake up the other side of the bed is cold. My fingers stretch
out seeking Prims warmth but finding only the rough canvas cover of the
mattress. She must have had bad dreams|
| |
|NULL|
|abcdefghijklmnopqrstuvwxyz1234567890ABCD|
|'Wonderful with quotes'|
|russian - удивительный мир chineese 美好的世界 japneese 素晴らしき世界 hindi अनोखी दुनियाँ
unicode|
|abcdefghijklmnopqrstuvwxyz1234567890A~`!@#$%^&*();|
|TrailingwithSpace|
*Query which is executed* : INSERT INTO TABLE `all_char_tgt`(`col`) SELECT
`col` FROM `all_char`;
+----------------------------------------------------+
*Target Table Data:*
+----------------------------------------------------+
|all_char_tgt.col|
+----------------------------------------------------+
|abcThe Hunger GamesThe Hunger Games 1by Suzanne CollinsPART ITHE
TRIBUTES1.When I wake up the other side of the bed is cold. My fingers stretch
out seeking Prims warmth but finding only the rough canvas cover of the
mattress. She must have had bad dreams|
|abcdefghijklmnopqrstuvwxyz1234567890ABCD|
|NULL|
|russian - ������������������������ ������ chineese ��������������� japneese
��������������������� hindi ��������������� ��������������������� unicode|
| |
|'Wonderful with quotes'|
|abcdefghijklmnopqrstuvwxyz1234567890A~`!@#$%^&*();|
|TrailingwithSpace|
+----------------------------------------------------+
*Expected*
Data Should be written properly in target table.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
