Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Fri, 6 Dec 2013 06:01:40 +0000 (UTC)
From: "alex kim (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12683060.1386309611226.83388.1386309700584@arcas>
In-Reply-To: <JIRA.12683060.1386309611226@arcas>
References: <JIRA.12683060.1386309611226@arcas>
Subject: [jira] [Created] (HIVE-5974) chinese character can not display
 normally when use hive jdbc 0.10.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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

             Summary: chinese character can not display normally when use h=
ive 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-se=
rver2
            Reporter: alex kim
            Priority: Critical


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

# hive -S -e "select * from test_alex"
1       =E6=88=91=E7=9A=84=E6=B5=8B=E8=AF=95        =E6=B5=8B=E8=AF=95

run java code using hive jdbc output=20
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;
 =20
  public class DemoHive {
=09       =20
            public static void main(String[] args) throws  Exception {
      =20
                Class.forName("org.apache.hive.jdbc.HiveDriver");
               =20
                Connection hiveConn  =3D  DriverManager.getConnection("jdbc=
:hive2://192.168.10.223:10000/default","" ,"");
               =20
                Statement stat =3DhiveConn.createStatement();=20

                ResultSet rs =3D stat.executeQuery( "select * from test_ale=
x" );
                int i=3D1;
                while(rs.next())
                {
                    System.out.println(i+":"+rs.getString("name")+":"+rs.ge=
tString("email"));
                    i++;
                }

            }
        }


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