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
Hey Richard
First, don't treat hive as a database. Hive is just an interface above
map reduce that help you write SQL like queries that inturn is converted to MR
jobs. Saying that hive doesn't support update.
If you are just experimenting, the query that you wrote would overwrite a who
