thoughts?
On Tue, Nov 22, 2016 at 3:41 PM, Jess Balint <jbal...@gmail.com> wrote:
> Hi,
>
> Using the RelBuilder API, I would like to create a join condition using
> table aliases. The RelBuilder.field(relationAlias, fieldName) method only
> checks the top of the stack. The top of the stack is not yet a join node if
> using the RelBuilder.join(joinType, joinCondition) method. Here's an
> example:
>
> rb.scan("EMP").as("t0").scan("DEPT").as("t1")
> .join(JoinRelType.LEFT, rb.field("t0", "emp_dept_no"), rb.field("t1",
> "dept_dept_no"));
>
>
> I'm getting an error "java.lang.IllegalArgumentException: no relation
> wtih alias 't0'; aliases are: [t1]". Would it make sense for the RelBuilder
> to check the entire stack in anticipation that it's contents will be used?
>
> Thx.
> Jess
>
