Hi devs, Current SqlValidatorImpl doesn't allow queries like following:
select stream orders.orderId, orders.productId, products.name from orders join products on orders.productId = products.id if the 'products' is a relation. This query fails at the modality check. But I am not sure whether fixing (or changing) the modality checking logic is enough to solve this. Do we need to change planner rules as well. Really appreciate any ideas on this. Thanks Milinda p.s. I am trying to get this base case working where every element from a stream is joined with a relation. stream-to-stream joins requires changes to parser as well to support windowing. That's my understanding, Julian may have better ideas. -- Milinda Pathirage PhD Student | Research Assistant School of Informatics and Computing | Data to Insight Center Indiana University twitter: milindalakmal skype: milinda.pathirage blog: http://milinda.pathirage.org
