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: [email protected] [[email protected]] Sent: Sunday, December 09, 2012 7:35 PM To: [email protected] 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
