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

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


+
yaboulna@... 2012-12-10, 00:35
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

+
Shreepadma Venugopalan 2012-12-10, 00:53
+
yaboulna@... 2012-12-10, 01:02
+
Bertrand Dechoux 2012-12-10, 06:32
+
Shreepadma Venugopalan 2012-12-10, 18:32
+
Shreepadma Venugopalan 2012-12-10, 18:36
+
yaboulna@... 2012-12-10, 20:01