ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JaySenSharma (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-20943) Hive View 1.5 and 2.0 result with special characters are being printed as ?
Date Fri, 05 May 2017 15:47:04 GMT

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

Mime
View raw message