Page 1 of 1

Range Lookup in Join stage

Posted: Fri Dec 10, 2010 3:54 am
by rohithmuthyala
Hi,

Is it possible to do the range lookup in a join stage..?

Meaning, if the data volume if large then it's not feasible to use a lookup, so how to execute the concept of range lookup in a join stage...!

Posted: Fri Dec 10, 2010 3:16 pm
by ray.wurlod
It's not possible. The Join stage only performs equi-joins.

Push the join back into the database (if possible) with a BETWEEN operator in the join condition.