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 <codemon...@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?
