[jira] [Commented] (HIVE-9907) insert into table values() when UTF-8 character is not correct

["Hao Chen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-9907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15128413#comment-15128413 ] 

Hao Chen commented on HIVE-9907:
--------------------------------

1. Aleksei Statkevich had fixed this bug (see HIVE-11721 and HIVE-12207).
2. In addition, If you're using Hive CLI or Beeline, you should export LC_ALL=zh_CN.UTF-8, because both of them use JLine ConsoleReader, Whose characterset encoding depends on your system configuration.

> insert into table values()   when UTF-8 character is not correct
> ----------------------------------------------------------------
>
>                 Key: HIVE-9907
>                 URL: https://issues.apache.org/jira/browse/HIVE-9907
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI, Clients, JDBC
>    Affects Versions: 0.14.0, 0.13.1, 1.0.0
>         Environment: centos 6   LANG=zh_CN.UTF-8
> hadoop 2.6
> hive 1.1.0
>            Reporter: Fanhong Li
>            Assignee: niklaus xiao
>            Priority: Critical
>         Attachments: HIVE-9907.1.patch
>
>
> insert into table test_acid partition(pt='pt_2')
> values( 2, '中文_2' , 'city_2' )
> ;
> hive> select *
>     > from test_acid 
>     > ;
> OK
> 2	-�_2	city_2	pt_2
> Time taken: 0.237 seconds, Fetched: 1 row(s)
> hive> 
> CREATE TABLE test_acid(id INT, 
> name STRING, 
> city STRING) 
> PARTITIONED BY (pt STRING)
> clustered by (id) into 1 buckets
> stored as ORCFILE
> TBLPROPERTIES('transactional'='true')
> ;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)