Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> FROM INSERT after ADD COLUMN


Copy link to this message
-
RE: FROM INSERT after ADD COLUMN
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