hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Connell, Chuck" <Chuck.Conn...@nuance.com>
Subject RE: FROM INSERT after ADD COLUMN
Date Mon, 10 Dec 2012 00:53:50 GMT
I don't think you can do this. Populating new columns is the same as "row level updates" which
Hive does not do. AFAIK, your only option is to write a new table, by reading the old table,
selecting all of it, appending new values to each row, then writing the longer rows to a new
table. 

Chuck

________________________________________
From: yaboulna@uwaterloo.ca [yaboulna@uwaterloo.ca]
Sent: Sunday, December 09, 2012 7:35 PM
To: user@hive.apache.org
Subject: FROM INSERT after ADD COLUMN

Hello,

I couldn't find any example of how to populate columns that were added
to a table. How would Hive tell which row to append by each value of
the newly added columns? Does it do a column name matching?

Sincerely,
Younos




Mime
View raw message