Return-Path: 
 <user-return-14956-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 431A310194
	for <apmail-hive-user-archive@www.apache.org>;
 Thu, 28 Nov 2013 02:34:32 +0000 (UTC)
Received: (qmail 46729 invoked by uid 500); 28 Nov 2013 02:34:30 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 46682 invoked by uid 500); 28 Nov 2013 02:34:30 -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 46674 invoked by uid 99); 28 Nov 2013 02:34:30 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Nov 2013 02:34:30 +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 (athena.apache.org: domain of justlooks@gmail.com
 designates 209.85.216.45 as permitted sender)
Received: from [209.85.216.45] (HELO mail-qa0-f45.google.com) (209.85.216.45)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Nov 2013 02:34:25 +0000
Received: by mail-qa0-f45.google.com with SMTP id o15so243175qap.18
        for <user@hive.apache.org>; Wed, 27 Nov 2013 18:34:04 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        bh=kZ6snIYTVOMAaNfx3JskiVFJukEb0a8i6z6ha5n40/4=;
        b=GW8yj9oXyVP+XyG4s0L9L5K59fWK/qUGRavfFzJqBrDyt40gdD0vibfwsshR0mbG3v
         w7t0KnXTlhFf4aAqQRoookf8lS7VXgy4ZPJc4Wo8vM7cXn/uuAfSjYkb1WmQGRsNDIcR
         qpTvg7DRnDCEFfun7fuuxSDtZ13BZ8lvzKfR6ObwFMIYso2PLktnFGMvsDOEUMlobpsc
         AFaKxBy3VSMB1Y60NKvv7IKgcEa56OLC5UUTLut5d/RKz4/WE0o77qGmJLTv2wod4fO5
         YD+UxhUm7IeYNWJB3s9nvXof61JdwULqUfWGBdfpR+MpDXy7fI9vINplrRHqvbMU9hHG
         pz6Q==
MIME-Version: 1.0
X-Received: by 10.224.5.202 with SMTP id 10mr72467144qaw.8.1385606044269; Wed,
 27 Nov 2013 18:34:04 -0800 (PST)
Received: by 10.140.20.37 with HTTP; Wed, 27 Nov 2013 18:34:04 -0800 (PST)
In-Reply-To: 
 <CACeqxwTWnpnxRqswKOTSeSib2SzQazVtCzyfcRJHdUMbhwxTeQ@mail.gmail.com>
References: 
 <CACeqxwTWnpnxRqswKOTSeSib2SzQazVtCzyfcRJHdUMbhwxTeQ@mail.gmail.com>
Date: Thu, 28 Nov 2013 10:34:04 +0800
Message-ID: 
 <CACeqxwQ_k8YcL4Y0XaLj+E583047F+X_tco-h+vZ-w-Oujxv6w@mail.gmail.com>
Subject: Re: 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=001a11c2e70a11408a04ec338c60
X-Virus-Checked: Checked by ClamAV on apache.org

--001a11c2e70a11408a04ec338c60
Content-Type: text/plain; charset=ISO-8859-1

seems hive jdbc cache the metadata from remote metadata database,but when i
test on partition table ,it's not a metadata sync problem ,the all new
column value is NULL


hive (default)> create external table test_alex1_part (id string,myname
string) partitioned by(dt string);
OK
Time taken: 0.263 seconds
hive (default)> alter table test_alex1_part add partition (dt='2013-11-28')
location '2013-11-28';

0: jdbc:hive2://localhost:10000>  insert overwrite table test_alex1_part
partition(dt='2013-11-28') select id,myname from test_alex1;
+-----+---------+
| id  | myname  |
+-----+---------+
+-----+---------+
No rows selected (11.91 seconds)
0: jdbc:hive2://localhost:10000> select * from test_alex1_part;
+-------------------------------------------------------------------+---------+-------------+
|                                id                                 |
myname  |     dt      |
+-------------------------------------------------------------------+---------+-------------+
| 20501B55B0C64273A5316C5078442569E425CC318ADC454CA163D72503489436  |
1       | 2013-11-28  |
| 20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994  |
1       | 2013-11-28  |
| 20501B55B0C64273A5316C5078442569814086424B2942919C97DF1D2D2C1F55  |
1       | 2013-11-28  |
| 205018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B  |
1       | 2013-11-28  |
| 205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01  |
1       | 2013-11-28  |
| 205016D04EDA435CB578D059F931221E205016D04EDA435CB578D059F931221E  |
1       | 2013-11-28  |
| 20500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36  |
1       | 2013-11-28  |
| 205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B  |
1       | 2013-11-28  |
| 2050054E19B44C4D992D97C1661A26C32050054E19B44C4D992D97C1661A26C3  |
1       | 2013-11-28  |
| 204fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1  |
1       | 2013-11-28  |
+-------------------------------------------------------------------+---------+-------------+




0: jdbc:hive2://localhost:10000> alter table test_alex1_part add
columns(number string);
No rows affected (0.187 seconds)


0: jdbc:hive2://localhost:10000> select * from test_alex1_part;
+-------------------------------------------------------------------+---------+---------+-------------+
|                                id                                 |
myname  | number  |     dt      |
+-------------------------------------------------------------------+---------+---------+-------------+
| 20501B55B0C64273A5316C5078442569E425CC318ADC454CA163D72503489436  |
1       |         | 2013-11-28  |
| 20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994  |
1       |         | 2013-11-28  |
| 20501B55B0C64273A5316C5078442569814086424B2942919C97DF1D2D2C1F55  |
1       |         | 2013-11-28  |
| 205018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B  |
1       |         | 2013-11-28  |
| 205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01  |
1       |         | 2013-11-28  |
| 205016D04EDA435CB578D059F931221E205016D04EDA435CB578D059F931221E  |
1       |         | 2013-11-28  |
| 20500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36  |
1       |         | 2013-11-28  |
| 205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B  |
1       |         | 2013-11-28  |
| 2050054E19B44C4D992D97C1661A26C32050054E19B44C4D992D97C1661A26C3  |
1       |         | 2013-11-28  |
| 204fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1  |
1       |         | 2013-11-28  |
+-------------------------------------------------------------------+---------+---------+-------------+
10 rows selected (0.385 seconds)

hive (default)> select * from test_alex1_part where dt='2013-11-28';
OK
20501B55B0C64273A5316C5078442569E425CC318ADC454CA163D72503489436
1       NULL    2013-11-28
20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994
1       NULL    2013-11-28
20501B55B0C64273A5316C5078442569814086424B2942919C97DF1D2D2C1F55
1       NULL    2013-11-28
205018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B
1       NULL    2013-11-28
205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01
1       NULL    2013-11-28
205016D04EDA435CB578D059F931221E205016D04EDA435CB578D059F931221E
1       NULL    2013-11-28
20500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36
1       NULL    2013-11-28
205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B
1       NULL    2013-11-28
2050054E19B44C4D992D97C1661A26C32050054E19B44C4D992D97C1661A26C3
1       NULL    2013-11-28
204fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1
1       NULL    2013-11-28





On Thu, Nov 28, 2013 at 10:08 AM, ch huang <justlooks@gmail.com> wrote:

> 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
>
>

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

<div>seems hive jdbc cache the metadata from remote metadata database,but w=
hen i test on partition table ,it&#39;s not a metadata sync problem ,the al=
l new column value is NULL</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">hive =
(default)&gt; create external table test_alex1_part (id string,myname strin=
g) partitioned by(dt string);<br>
OK<br>Time taken: 0.263 seconds<br>hive (default)&gt; alter table test_alex=
1_part add partition (dt=3D&#39;2013-11-28&#39;) location &#39;2013-11-28&#=
39;;<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;=A0 insert overwrite table test_alex1_part pa=
rtition(dt=3D&#39;2013-11-28&#39;) select id,myname from test_alex1;<br>
+-----+---------+<br>| id=A0 | myname=A0 |<br>+-----+---------+<br>+-----+-=
--------+<br>No rows selected (11.91 seconds)<br>0: jdbc:hive2://localhost:=
10000&gt; select * from test_alex1_part;<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=A0=A0=A0 dt=
=A0=A0=A0=A0=A0 |<br>+-----------------------------------------------------=
--------------+---------+-------------+<br>| 20501B55B0C64273A5316C50784425=
69E425CC318ADC454CA163D72503489436=A0 | 1=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0=
 |<br>
| 20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994=A0 | 1=
=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 20501B55B0C64273A5316C50784425698=
14086424B2942919C97DF1D2D2C1F55=A0 | 1=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<=
br>| 205018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B=A0 | =
1=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>
| 205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01=A0 | 1=
=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 205016D04EDA435CB578D059F931221E2=
05016D04EDA435CB578D059F931221E=A0 | 1=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<=
br>| 20500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36=A0 | =
1=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>
| 205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B=A0 | 1=
=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 2050054E19B44C4D992D97C1661A26C32=
050054E19B44C4D992D97C1661A26C3=A0 | 1=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<=
br>| 204fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1=A0 | =
1=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>
+-------------------------------------------------------------------+------=
---+-------------+<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"><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; alter table test_alex1_part add columns(numb=
er string);<br>
No rows affected (0.187 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 * from test_alex1_part;<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 | number=A0 |=A0=
=A0=A0=A0 dt=A0=A0=A0=A0=A0 |<br>+-----------------------------------------=
--------------------------+---------+---------+-------------+<br>| 20501B55=
B0C64273A5316C5078442569E425CC318ADC454CA163D72503489436=A0 | 1=A0=A0=A0=A0=
=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>
| 20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994=A0 | 1=
=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 20501B5=
5B0C64273A5316C5078442569814086424B2942919C97DF1D2D2C1F55=A0 | 1=A0=A0=A0=
=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 205018A818FB43A3=
8CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B=A0 | 1=A0=A0=A0=A0=A0=A0 |=
=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>
| 205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01=A0 | 1=
=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 205016D=
04EDA435CB578D059F931221E205016D04EDA435CB578D059F931221E=A0 | 1=A0=A0=A0=
=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 20500D24895641DB=
BBDBE71640E57887EA06A0AEB4324117B8125FC815297B36=A0 | 1=A0=A0=A0=A0=A0=A0 |=
=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>
| 205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B=A0 | 1=
=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 2050054=
E19B44C4D992D97C1661A26C32050054E19B44C4D992D97C1661A26C3=A0 | 1=A0=A0=A0=
=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>| 204fa32a43ef4aef=
ac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1=A0 | 1=A0=A0=A0=A0=A0=A0 |=
=A0=A0=A0=A0=A0=A0=A0=A0 | 2013-11-28=A0 |<br>
+-------------------------------------------------------------------+------=
---+---------+-------------+<br>10 rows selected (0.385 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">hive =
(default)&gt; select * from test_alex1_part where dt=3D&#39;2013-11-28&#39;=
;<br>
OK<br>20501B55B0C64273A5316C5078442569E425CC318ADC454CA163D72503489436=A0=
=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 NULL=A0=A0=A0 2013-11-28<br>20501B55=
B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994=A0=A0=A0=A0=A0=A0=
=A0 1=A0=A0=A0=A0=A0=A0 NULL=A0=A0=A0 2013-11-28<br>20501B55B0C64273A5316C5=
078442569814086424B2942919C97DF1D2D2C1F55=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=
=A0=A0=A0 NULL=A0=A0=A0 2013-11-28<br>
205018A818FB43A38CC29FF701E47D8B205018A818FB43A38CC29FF701E47D8B=A0=A0=A0=
=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 NULL=A0=A0=A0 2013-11-28<br>205016D04EDA43=
5CB578D059F931221EB9F06E42815243A486B611B96366DD01=A0=A0=A0=A0=A0=A0=A0 1=
=A0=A0=A0=A0=A0=A0 NULL=A0=A0=A0 2013-11-28<br>205016D04EDA435CB578D059F931=
221E205016D04EDA435CB578D059F931221E=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=
=A0 NULL=A0=A0=A0 2013-11-28<br>
20500D24895641DBBBDBE71640E57887EA06A0AEB4324117B8125FC815297B36=A0=A0=A0=
=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 NULL=A0=A0=A0 2013-11-28<br>205006E8A3EB4C=
A1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B=A0=A0=A0=A0=A0=A0=A0 1=
=A0=A0=A0=A0=A0=A0 NULL=A0=A0=A0 2013-11-28<br>2050054E19B44C4D992D97C1661A=
26C32050054E19B44C4D992D97C1661A26C3=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=
=A0 NULL=A0=A0=A0 2013-11-28<br>
204fa32a43ef4aefac3b391562c5a25b7149D57B47E74C6F8C22CC30292FADF1=A0=A0=A0=
=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0 NULL=A0=A0=A0 2013-11-28<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><br></div></div>
<div><br><br>=A0</div>
<div class=3D"gmail_quote">On Thu, Nov 28, 2013 at 10:08 AM, ch huang <span=
 dir=3D"ltr">&lt;<a href=3D"mailto:justlooks@gmail.com" target=3D"_blank">j=
ustlooks@gmail.com</a>&gt;</span> wrote:<br>
<blockquote style=3D"BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PA=
DDING-LEFT:1ex" class=3D"gmail_quote">
<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;WORD-SPACING:0px">0: jdbc:hive2://localh=
ost: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;WORD-SPACING:0px"><br></div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;WORD-SPACING:0px"><br></div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;WORD-SPACING:0px">0: jdbc:hive2://localh=
ost: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>
| 20501B55B0C64273A5316C5078442569E3D87D24CA4E42D9A200E391417A7994=A0 | 1=
=A0=A0=A0=A0=A0=A0=A0 |<br>| 20501B55B0C64273A5316C5078442569814086424B2942=
919C97DF1D2D2C1F55=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<br>| 205018A818FB43A38CC29=
FF701E47D8B205018A818FB43A38CC29FF701E47D8B=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<b=
r>
| 205016D04EDA435CB578D059F931221EB9F06E42815243A486B611B96366DD01=A0 | 1=
=A0=A0=A0=A0=A0=A0=A0 |<br>| 205016D04EDA435CB578D059F931221E205016D04EDA43=
5CB578D059F931221E=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<br>| 20500D24895641DBBBDBE=
71640E57887EA06A0AEB4324117B8125FC815297B36=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<b=
r>
| 205006E8A3EB4CA1997D947D89C5FD1B205006E8A3EB4CA1997D947D89C5FD1B=A0 | 1=
=A0=A0=A0=A0=A0=A0=A0 |<br>| 2050054E19B44C4D992D97C1661A26C32050054E19B44C=
4D992D97C1661A26C3=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<br>| 204fa32a43ef4aefac3b3=
91562c5a25b7149D57B47E74C6F8C22CC30292FADF1=A0 | 1=A0=A0=A0=A0=A0=A0=A0 |<b=
r>
+-------------------------------------------------------------------+------=
----+<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;WORD-SPACING:0px"><br></div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;WORD-SPACING:0px"><br></div>
<div style=3D"TEXT-TRANSFORM:none;TEXT-INDENT:0px;FONT:medium Tahoma;WHITE-=
SPACE:normal;LETTER-SPACING:normal;WORD-SPACING:0px">hive (default)&gt; sel=
ect * from test_alex1;<br>OK<br>20501B55B0C64273A5316C5078442569E425CC318AD=
C454CA163D72503489436=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></blockquote></div><br>

--001a11c2e70a11408a04ec338c60--