resident load

[#1]

hieee

Can anyone make me understand what is resident load with some scenareio and is it necessay to drop previous table while using resident load

[arulsettu]

hi

we can load a field from already loaded table

[MayilVahanan]

Hi

resident is used if data should be loaded from a previously loaded table.

For ex:

T1:

Load Id, field1, field2, value from tableA;

T2:

Load Id, field3 from tableB;

Join(T2)

Load Id, sum(Value) as Value resident T1;

In this example, you need to have field1, field2, value separately and also need to do some aggregation function with same field (Value). so don' t need to load the table again for do that operation.