Return-Path: 
 <user-return-14955-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-user-archive@www.apache.org
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id C36FC1013C
	for <apmail-hive-user-archive@www.apache.org>;
 Thu, 28 Nov 2013 02:09:18 +0000 (UTC)
Received: (qmail 8861 invoked by uid 500); 28 Nov 2013 02:09:17 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 8813 invoked by uid 500); 28 Nov 2013 02:09:17 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 8805 invoked by uid 99); 28 Nov 2013 02:09:17 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Nov 2013 02:09:17 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of justlooks@gmail.com designates
 209.85.128.50 as permitted sender)
Received: from [209.85.128.50] (HELO mail-qe0-f50.google.com) (209.85.128.50)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Nov 2013 02:09:10 +0000
Received: by mail-qe0-f50.google.com with SMTP id 1so6491429qec.9
        for <user@hive.apache.org>; Wed, 27 Nov 2013 18:08:49 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=jW5znyQoGIOZ98U2xToGjZrnHbXlj3hOTNc3Z0SVqB8=;
        b=u9yC7BJzetNN65IYl0qQGMkT+pd65+/DhHcFi8FF5GDOnRhNbUUzGt0SGVH8ClGadf
         cvrDV56NQdandNGNIpT0DcxFgJLtBv9qHyL1Qfl5hpC5hXimg5OIE6K8r04gK7U7Iv1O
         SEevaIXoqk0iJ045CBUpJpzAtHo1c+ncmH7p85GoOy0b+4PdahmAzuIBt2TS2v+Gf9ms
         iexqyuujO0q5/hnavi/iNTT8R2Q7mClJ9K4n6XM8zm42gISUNMSfjhSKpo196zaAy6K5
         daUITsucyaEBnATFiaPl2C1CZuGGHCwaXnY6rCcmO/0hqcU8UmKX8AHiSJKBqMv2jYWL
         ZkHw==
MIME-Version: 1.0
X-Received: by 10.49.116.5 with SMTP id js5mr71959941qeb.36.1385604529270;
 Wed, 27 Nov 2013 18:08:49 -0800 (PST)
Received: by 10.140.20.37 with HTTP; Wed, 27 Nov 2013 18:08:49 -0800 (PST)
Date: Thu, 28 Nov 2013 10:08:49 +0800
Message-ID: 
 <CACeqxwTWnpnxRqswKOTSeSib2SzQazVtCzyfcRJHdUMbhwxTeQ@mail.gmail.com>
Subject: issure about add new columns in table ,but use hive-jdbc can not get
 these clumns value
From: ch huang <justlooks@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=047d7b677d60c434a904ec333160
X-Virus-Checked: Checked by ClamAV on apache.org

--047d7b677d60c434a904ec333160
Content-Type: text/plain; charset=ISO-8859-1

hi,maillist:
              i add some new columns to hive table ,but find when i use
beeline, or write my own java code,i can not get these new columns
value,but when i use hive shell,it's ok


0: jdbc:hive2://localhost:10000> desc  test_alex1;
+-----------+------------+----------+
| col_name  | data_type  | comment  |
+-----------+------------+----------+
| id        | string     |          |
| myname    | string     |          |
+-----------+------------+----------+
2 rows selected (0.187 seconds)
0: jdbc:hive2://localhost:10000> alter table test_alex1 add columns (bee
string);
No rows affected (0.239 seconds)
0: jdbc:hive2://localhost:10000> desc
test_alex1;
+-----------+------------+----------+
| col_name  | data_type  | comment  |
+-----------+------------+----------+
| id        | string     |          |
| myname    | string     |          |
| bee       | string     |          |
+-----------+------------+----------+
3 rows selected (0.183 seconds)


0: jdbc:hive2://localhost:10000> select id,myname,bee from test_alex1;
+-------------------------------------------------------------------+----------+
|                                id                                 |
myname   |
+-------------------------------------------------------------------+----------+
| 20501B55B0C64273A5316C5078442569E425CC318ADC454CA163D72503489436  |
1        |
| 20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994  |
1        |
| 20501B55B0C64273A5316C5078442569814086424B2942919C97DF1D2D2C1F55  |
1        |
| 205018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B  |
1        |
| 205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01  |
1        |
| 205016D04EDA435CB578D059F931221E205016D04EDA435CB578D059F931221E  |
1        |
| 20500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36  |
1        |
| 205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B  |
1        |
| 2050054E19B44C4D992D97C1661A26C32050054E19B44C4D992D97C1661A26C3  |
1        |
| 204fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1  |
1        |
+-------------------------------------------------------------------+----------+
10 rows selected (11.679 seconds)


hive (default)> select * from test_alex1;
OK
20501B55B0C64273A5316C5078442569E425CC318ADC454CA163D72503489436
1       1
20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994
1       2
20501B55B0C64273A5316C5078442569814086424B2942919C97DF1D2D2C1F55
1       3
205018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B
1       4
205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01
1       5
205016D04EDA435CB578D059F931221E205016D04EDA435CB578D059F931221E
1       6
20500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36
1       7
205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B
1       8
2050054E19B44C4D992D97C1661A26C32050054E19B44C4D992D97C1661A26C3
1       9
204fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1
1       10

--047d7b677d60c434a904ec333160
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>hi,maillist:</div>
<div>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 i add some new=A0columns to hi=
ve table ,but find when i use beeline, or write my own java code,i can not =
get these new columns value,but when i use hive=A0shell,it&#39;s ok</div>
<div>=A0</div>
<div>=A0=20
<div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">0: jd=
bc:hive2://localhost:10000&gt; desc=A0 test_alex1;<br>+-----------+--------=
----+----------+<br>
| col_name=A0 | data_type=A0 | comment=A0 |<br>+-----------+------------+--=
--------+<br>| id=A0=A0=A0=A0=A0=A0=A0 | string=A0=A0=A0=A0 |=A0=A0=A0=A0=
=A0=A0=A0=A0=A0 |<br>| myname=A0=A0=A0 | string=A0=A0=A0=A0 |=A0=A0=A0=A0=
=A0=A0=A0=A0=A0 |<br>+-----------+------------+----------+<br>2 rows select=
ed (0.187 seconds)<br>
0: jdbc:hive2://localhost:10000&gt; alter table test_alex1 add columns (bee=
 string);<br>No rows affected (0.239 seconds)<br>0: jdbc:hive2://localhost:=
10000&gt; desc=A0 test_alex1;=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 +-----------+------------+------=
----+<br>
| col_name=A0 | data_type=A0 | comment=A0 |<br>+-----------+------------+--=
--------+<br>| id=A0=A0=A0=A0=A0=A0=A0 | string=A0=A0=A0=A0 |=A0=A0=A0=A0=
=A0=A0=A0=A0=A0 |<br>| myname=A0=A0=A0 | string=A0=A0=A0=A0 |=A0=A0=A0=A0=
=A0=A0=A0=A0=A0 |<br>| bee=A0=A0=A0=A0=A0=A0 | string=A0=A0=A0=A0 |=A0=A0=
=A0=A0=A0=A0=A0=A0=A0 |<br>+-----------+------------+----------+<br>
3 rows selected (0.183 seconds)<br></div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px"><br><=
/div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px"><br><=
/div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">0: jd=
bc:hive2://localhost:10000&gt; select id,myname,bee from test_alex1;<br>
+-------------------------------------------------------------------+------=
----+<br>|=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 id=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | myname=A0=A0 |<br>=
+-------------------------------------------------------------------+------=
----+<br>
| 20501B55B0C64273A5316C5078442569E425CC318ADC454CA163D72503489436=A0 | 1=
=A0=A0=A0=A0=A0=A0=A0 |<br>| 20501B55B0C64273A5316C5078442569E3D87D24CA4E42=
D9A200E391417A7994=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<br>| 20501B55B0C64273A5316=
C5078442569814086424B2942919C97DF1D2D2C1F55=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<b=
r>
| 205018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B=A0 | 1=
=A0=A0=A0=A0=A0=A0=A0 |<br>| 205016D04EDA435CB578D059F931221EB9F06E42815243=
A486B611B96366DD01=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<br>| 205016D04EDA435CB578D=
059F931221E205016D04EDA435CB578D059F931221E=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<b=
r>
| 20500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36=A0 | 1=
=A0=A0=A0=A0=A0=A0=A0 |<br>| 205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4C=
A1997D947D89C5FD1B=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<br>| 2050054E19B44C4D992D9=
7C1661A26C32050054E19B44C4D992D97C1661A26C3=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<b=
r>
| 204fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1=A0 | 1=
=A0=A0=A0=A0=A0=A0=A0 |<br>+-----------------------------------------------=
--------------------+----------+<br>10 rows selected (11.679 seconds)<br></=
div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px"><br><=
/div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px"><br><=
/div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;COLOR:rgb(0,0,0);WORD-SPACING:0px">hive =
(default)&gt; select * from test_alex1;<br>OK<br>20501B55B0C64273A5316C5078=
442569E425CC318ADC454CA163D72503489436=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=
=A0=A0 1<br>
20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994=A0=A0=A0=
=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 2<br>20501B55B0C64273A5316C507844256981408=
6424B2942919C97DF1D2D2C1F55=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 3<br>2=
05018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B=A0=A0=A0=A0=
=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 4<br>
205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01=A0=A0=A0=
=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 5<br>205016D04EDA435CB578D059F931221E20501=
6D04EDA435CB578D059F931221E=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 6<br>2=
0500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36=A0=A0=A0=A0=
=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 7<br>
205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B=A0=A0=A0=
=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 8<br>2050054E19B44C4D992D97C1661A26C320500=
54E19B44C4D992D97C1661A26C3=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 9<br>2=
04fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1=A0=A0=A0=A0=
=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 10<br>
</div><br></div></div>

--047d7b677d60c434a904ec333160--