[
https://issues.apache.org/jira/browse/HIVE-21432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yx91490 updated HIVE-21432:
---------------------------
Description:
when the show locks sql contains chinese character, the result will show
unreadable codes, this is caused by not set utf-8 character encoding in
org.apache.hadoop.hive.ql.exec.DDLTask.showLocks()
example:
executing sql:
hive> select id from db.table1 where id != '你好';
show locks sql:
hive> show locks db.table1 extended;
OK
db@table1 SHARED
LOCK_QUERYID:hive_20190312212222_05425a80-c6f7-43e3-a784-ad690b469b4d
LOCK_TIME:1552396936424
LOCK_MODE:IMPLICIT
LOCK_QUERYSTRING:select id from db.table1 where id != '`}'
Time taken: 0.039 seconds, Fetched: 5 row(s)
was:
when the show locks sql contains chinese character, the result will show
unreadable codes, this is caused by not set utf-8 character encoding in
org.apache.hadoop.hive.ql.exec.DDLTask.showLocks()
example:
executing sql:
hive> select id from db.table1 – 搜索
group by id;
show locks sql:
hive> show locks db.table1 extended;
OK
db@table1 SHARED
LOCK_QUERYID:hive_20190312175151_3df05c4b-0402-459b-ac82-67b15ac45d57
LOCK_TIME:1552384291462
LOCK_MODE:IMPLICIT
LOCK_QUERYSTRING:select id from db.table1 group by id – " *
Time taken: 0.028 seconds, Fetched: 10 row(s)
> unreadable code in show locks sql result caused by wrong character encoding
> ----------------------------------------------------------------------------
>
> Key: HIVE-21432
> URL: https://issues.apache.org/jira/browse/HIVE-21432
> Project: Hive
> Issue Type: Bug
> Reporter: yx91490
> Priority: Major
>
> when the show locks sql contains chinese character, the result will show
> unreadable codes, this is caused by not set utf-8 character encoding in
> org.apache.hadoop.hive.ql.exec.DDLTask.showLocks()
>
> example:
> executing sql:
> hive> select id from db.table1 where id != '你好';
> show locks sql:
> hive> show locks db.table1 extended;
> OK
> db@table1 SHARED
> LOCK_QUERYID:hive_20190312212222_05425a80-c6f7-43e3-a784-ad690b469b4d
> LOCK_TIME:1552396936424
> LOCK_MODE:IMPLICIT
> LOCK_QUERYSTRING:select id from db.table1 where id != '`}'
> Time taken: 0.039 seconds, Fetched: 5 row(s)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
