Confused about after add columns for hive table

[SingoWong <si...@gmail.com>]

Hi,

I had execute "ALTER TABLE tablename ADD COLUMNS (newcolumns STRING)" to add
column,
before i add this column, got 4 columns, the new column will after the 4th
column, and before partition column, and now the new data in hdfs was exist
in the 5th columns, but i execute "SELECT * FROM tablename", the newcolumns
is empty.

Means i cat the file in hdfs is exist data, but how come the newcolumns is
empty?

Regards,
Singo

Re: Confused about after add columns for hive table

[SingoWong <si...@gmail.com>]

resolved, thx

On Tue, Aug 31, 2010 at 2:53 AM, SingoWong <si...@gmail.com> wrote:

> everyone can help me? the columns cannot match the data~~~
>
>
> On Thu, Aug 26, 2010 at 1:09 PM, SingoWong <si...@gmail.com> wrote:
>
>> Hi,
>>
>> I had execute "ALTER TABLE tablename ADD COLUMNS (newcolumns STRING)" to
>> add column,
>> before i add this column, got 4 columns, the new column will after the 4th
>> column, and before partition column, and now the new data in hdfs was exist
>> in the 5th columns, but i execute "SELECT * FROM tablename", the newcolumns
>> is empty.
>>
>> Means i cat the file in hdfs is exist data, but how come the newcolumns is
>> empty?
>>
>> Regards,
>> Singo
>>
>
>

Re: Confused about after add columns for hive table

[SingoWong <si...@gmail.com>]

everyone can help me? the columns cannot match the data~~~

On Thu, Aug 26, 2010 at 1:09 PM, SingoWong <si...@gmail.com> wrote:

> Hi,
>
> I had execute "ALTER TABLE tablename ADD COLUMNS (newcolumns STRING)" to
> add column,
> before i add this column, got 4 columns, the new column will after the 4th
> column, and before partition column, and now the new data in hdfs was exist
> in the 5th columns, but i execute "SELECT * FROM tablename", the newcolumns
> is empty.
>
> Means i cat the file in hdfs is exist data, but how come the newcolumns is
> empty?
>
> Regards,
> Singo
>