erwrite a partition
(not even a record/file) if you frame an optimized query.
Hope it helps!...
Regards
Bejoy.K.S
From: Bejoy Ks
To: "user@hive.apache.org"
Sent: Friday, March 16, 2012 5:56 PM
Subject: Re: update a hive table
Hey Richard
First, don't treat h
create a new table and copy the data from your source table by doing
lower(col1), drop the old table and rename the new table to old table.
On Fri, Mar 16, 2012 at 3:56 AM, Richard wrote:
> if I wang to update a table, e.g,
>
> insert overwrite table mytable
> select lower(col1), col2, col3 from
zed query.
Hope it helps!...
Regards
Bejoy.K.S
From: Bejoy Ks
To: "user@hive.apache.org"
Sent: Friday, March 16, 2012 5:56 PM
Subject: Re: update a hive table
Hey Richard
First, don't treat hive as a database. Hive is just an interfac
verwrite a whole
record (in a broader context a whole partion/table)
Regards
Bejoy.K.S
From: Richard
To: user@hive.apache.org
Sent: Friday, March 16, 2012 4:26 PM
Subject: update a hive table
if I wang to update a table, e.g,
insert overwrite table myta
if I wang to update a table, e.g,
insert overwrite table mytable
select lower(col1), col2, col3 from mytable;
if mytable has many columns but I only need to update one of them, how can I
write the
statement short?
