Hi, Rakesh Nair. RelBuilder/RexBuilder are used to construct rel/rex nodes, but parenthesis are not, parenthesis only defines the scope and precedence of the relational algebra. You only need to construct the rel/rex nodes directly with the defined precedence by parenthesis.
Best, Danny Chan 在 2019年3月14日 +0800 PM7:56,Rakesh Nair <[email protected]>,写道: > Hello, > Would you mind giving me some pointers on *creating parenthesis while > building a RelNode*. > For example, how to build RelNode for the sample query: > SELECT * FROM `persons` WHERE *(*`SALARY` >= 10 AND `SALARY` < 20*) *OR > *(*`SALARY` >= 30 AND `SALARY` < 40*)* > > P.S. Need to know how to build the parenthesis only, everything else is > fine.. > -- > Thanks & Regards, > Rakesh
