You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "alex kim (JIRA)" <ji...@apache.org> on 2013/12/06 07:01:40 UTC

[jira] [Created] (HIVE-5974) chinese character can not display normally when use hive jdbc 0.10.0

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)