To track progress on Rel2Sql Converter.
Following is the email conversation that lead to this JIRA:
On Wed, Dec 2, 2015 at 3:13 AM, Julian Hyde <email@example.com> wrote:
Yes, this would definitely be useful in Calcite. Thanks for offering.
I would like to reduce the amount of code copy-pasted from the JdbcXxx relational expressions, but we can work on that after it is committed in and when there are some unit tests.
Can you please create a JIRA case with an initial pull-request?
I think the unit tests could be of the following form:
where “after” is the result of the round trip SQL => SqlNode => RelNode => SqlNode => SQL, and your utility is performing the 3rd “=>”.
> On Dec 1, 2015, at 12:28 AM, Amogh Margoor <firstname.lastname@example.org> wrote:
> We have an usecase where we need to just send back optimized query as SQL,
> without executing it. So we needed an utility to convert RelNode back to
> SQL, and found most of the logic to be in JDBCRel. As we needed it for non
> JDBC source, we created an utility to do so:
> Utility is almost completely copy-pasted from JDBCRels with few fixes from
> our side to make it work. If such utility will be useful in Calcite then
> let us know, we can plan raising PRs with required UTs.