I have added the following rules to create cross product of each data source up to the select operator in the query plan.
SimpleUnnestToProductRule PushAssignDownThroughProductRule PushUnnestDownThroughProductRule (new) PushSubplanWithAggregateDownThroughProductRule It appears that algebricks do not have a rule to take a select operator and move it into a join operator that is a cross product as the join condition. I found a rule that pushes a select down through the product rule, but I want to change the join condition to eliminate the select. Just want to confirm this before I write this new rewrite rule. Preston
