Push predicates that are expressed in outer queries into inner queries where possible so that rows will get filtered out sooner.
select a., b. from a join b on (a.uid = b.uid) where a.age = 20 and a.gender = 'm'
current compiler generates the filter predicate in the reducer after the join so all the rows have to be passed from mapper to reducer. by pushing the filter predicate to the mapper, query performance should improve.
|Component/s||Query Processor [ 12312586 ]|
|Status||Open [ 1 ]||Patch Available [ 10002 ]|
|Fix Version/s||0.4.0 [ 12313714 ]|
|Status||Patch Available [ 10002 ]||Resolved [ 5 ]|
|Resolution||Fixed [ 1 ]|
|Affects Version/s||0.6.0 [ 12314524 ]|
|Affects Version/s||0.2.0 [ 12313565 ]|
|Status||Resolved [ 5 ]||Closed [ 6 ]|