Github user fhueske commented on the issue:

    https://github.com/apache/flink/pull/2653
  
    HI @wuchong, thanks for this feature. This looks really interesting :-)
    
    I haven't looked at the PR in detail yet. However, I would like to avoid 
customizing the parser if possible. I haven't tested it but would it be 
possible to express `OUTER APPLY` and `CROSS APPLY` with Calcite's `LATERAL` 
tables?
    
    `CROSS APPLY` corresponds to: 
    
    ```
    SELECT MyTable.*, t.s  FROM MyTable, LATERAL TABLE(split(MyTable.a)) AS t(s)
    ```
    
    `OUTER APPLY` could be:
    
    ```
    SELECT MyTable.*, t.s  
      FROM MyTable LEFT JOIN LATERAL TABLE(split(MyTable.a)) AS t(s)
    ```
    
    Adding `crossApply` and `outerApply` for the Table API is fine with me.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---

Reply via email to