[
https://issues.apache.org/jira/browse/AMBARI-20943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15998485#comment-15998485
]
JaySenSharma commented on AMBARI-20943:
---------------------------------------
The hiveserver2.log shows the data was inserted properly:
{code}
hiveserver2.log shows:
2017-05-05 02:51:09,802 INFO [HiveServer2-Background-Pool: Thread-263]:
ql.Driver (Driver.java:execute(1411)) - Starting
command(queryId=hive_20170505025109_812f399d-a3bb-4224-959f-2c962d4e8492):
INSERT INTO customerinfo VALUES ("Envägen")
2017-05-05 02:51:20,017 INFO [HiveServer2-Background-Pool: Thread-263]:
exec.Task (TezTask.java:build(323)) - Dag name: INSERT INTO customerinfo VALUES
("Envägen")(Stage-1)
2017-05-05 02:51:20,242 INFO [HiveServer2-Background-Pool: Thread-263]:
client.TezClient (TezClient.java:submitDAGSession(429)) - Submitting dag to
TezSession, sessionName=HIVE-6eddd621-2b46-4598-bfa7-a435686f236b,
applicationId=application_1493948525801_0001, dagName=INSERT INTO customerinfo
VALUES ("Envägen")(Stage-1), callerContext={ context=HIVE,
callerType=HIVE_QUERY_ID,
callerId=hive_20170505025109_812f399d-a3bb-4224-959f-2c962d4e8492 }
2017-05-05 02:51:20,242 INFO [HiveServer2-Background-Pool: Thread-263]:
client.TezClient (TezClient.java:submitDAGSession(429)) - Submitting dag to
TezSession, sessionName=HIVE-6eddd621-2b46-4598-bfa7-a435686f236b,
applicationId=application_1493948525801_0001, dagName=INSERT INTO customerinfo
VALUES ("Envägen")(Stage-1), callerContext={ context=HIVE,
callerType=HIVE_QUERY_ID,
callerId=hive_20170505025109_812f399d-a3bb-4224-959f-2c962d4e8492 }
2017-05-05 02:51:20,595 INFO [HiveServer2-Background-Pool: Thread-263]:
client.TezClient (TezClient.java:submitDAGSession(501)) - Submitted dag to
TezSession, sessionName=HIVE-6eddd621-2b46-4598-bfa7-a435686f236b,
applicationId=application_1493948525801_0001, dagName=INSERT INTO customerinfo
VALUES ("Envägen")(Stage-1)
2017-05-05 02:51:27,650 INFO [HiveServer2-Background-Pool: Thread-285]:
ql.Driver (Driver.java:execute(1411)) - Starting
command(queryId=hive_20170505025127_56a8c52a-c257-4d33-bbe4-36c4eac82bba):
SELECT * FROM customerinfo
{code}
Attaching screenshots of HiveView 2.0
> Hive View 1.5 and 2.0 result with special characters are being printed as ?
> ---------------------------------------------------------------------------
>
> Key: AMBARI-20943
> URL: https://issues.apache.org/jira/browse/AMBARI-20943
> Project: Ambari
> Issue Type: Bug
> Components: ambari-views
> Affects Versions: 2.5.0
> Environment: All
> Reporter: JaySenSharma
> Attachments: Issue1.png
>
>
> - Hive View result panel is not showing special character data properly. The
> special characters are being replaced with ?
> Example: Run the following queries from Hive View 1.5/2.0 in Ambari 2.5 and
> then check the result section.
> {code}
> CREATE TABLE IF NOT EXISTS customerinfo (address string) ROW FORMAT SERDE
> 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH
> SERDEPROPERTIES("serialization.encoding"='UTF-8','store.charset'='UTF-8',
> 'retrieve.charset'='UTF-8');
> INSERT INTO customerinfo VALUES ("Envägen");
> SELECT * FROM customerinfo;
> {code}
> - Result is printed as following:
> {code}
> Env�gen
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
