rebuilding the whole reverse lookup table should be expensive if I am looking for a million new rows every day in the master table, reading a row manually and then writing the appended row should be a solution but will be a pain.
for a file backed system doing a append should be possible? Vishal Kapoor On Tue, Apr 12, 2011 at 11:34 AM, Buttler, David <[email protected]> wrote: > You have the keys for both tables, is there any reason you can't do a get, > local append, put? > If you do it in batch, then running a reduce job that collects all of the > keys for a given value would be fairly efficient. > > Dave > > > -----Original Message----- > From: Vishal Kapoor [mailto:[email protected]] > Sent: Tuesday, April 12, 2011 8:29 AM > To: [email protected] > Subject: Append value to a cell? > > Do we have any API which can append text values or row Ids to a cell. > > I want to do a control break report and want to append row Ids to a > cell value... > here is an example. > > TableMain > row1 : user1 > row2: user1 > row3 : user2 > row4 : user3 > > > reverse lookup. > TableRLookup. > user1 : row1,row2 > user2: row3 > user3: row4. > > now I get some more data. > > row5 : user4 > row6 : user1 > row7 : user2 > row8 : user3 > > now I want my lookup to get updated incrementally, not the entire run. > TableRLookup. > user1 : row1,row2,row6 > user2: row3,row7 > user3: row4.row8 > user4: row5 > > my rowIds are String., > > how can we do this without rebuilding the entire reverse lookup time > from ground up. > > thanks, > Vishal Kapoor >
