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

[Fanhong Li (JIRA)]

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

Fanhong Li commented on HIVE-9907:
----------------------------------

i found that

 DEBUG orc.OrcRecordUpdater (OrcRecordUpdater.java:insert(331)) -   
org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct bs = 
(org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct) row;

        List ls = bs.getFieldsAsList();
        for (int i = 0; i < ls.size(); i++) {
            LOG.debug(" lfh insert ls " + i  + " = " + ls.get(i));
        }


 lfh insert ls 0 = -�_2

> 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
>            Priority: Critical
>
> 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)