alex kim created HIVE-5974:
------------------------------

             Summary: chinese character can not display normally when use hive 
jdbc 0.10.0
                 Key: HIVE-5974
                 URL: https://issues.apache.org/jira/browse/HIVE-5974
             Project: Hive
          Issue Type: Bug
          Components: HiveServer2
    Affects Versions: 0.10.0
         Environment: OS : redhat6.2     hadoop CDH4.4  hive 0.10.0 hive-server2
            Reporter: alex kim
            Priority: Critical


when i query table using hive jdbc which content contains chinese characters 
,it can not be display normally

# hive -S -e "select * from test_alex"
1       我的测试        测试

run java code using hive jdbc output 
1:????:??

here is my test code

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
  
  public class DemoHive {
                
            public static void main(String[] args) throws  Exception {
       
                Class.forName("org.apache.hive.jdbc.HiveDriver");
                
                Connection hiveConn  =  
DriverManager.getConnection("jdbc:hive2://192.168.10.223:10000/default","" ,"");
                
                Statement stat =hiveConn.createStatement(); 

                ResultSet rs = stat.executeQuery( "select * from test_alex" );
                int i=1;
                while(rs.next())
                {
                    
System.out.println(i+":"+rs.getString("name")+":"+rs.getString("email"));
                    i++;
                }

            }
        }



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Reply via email to