hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bejoy Ks <bejoy...@yahoo.com>
Subject Re: update a hive table
Date Fri, 16 Mar 2012 12:26:00 GMT
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 whole record (in
a broader context a whole partion/table)

Regards
Bejoy.K.S


________________________________
 From: Richard <codemonkee@163.com>
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 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?
Mime
View raw message