search

linkedin / coral

Coral is a translation, analysis, and query rewrite engine for SQL and other relational languages.
BSD 2-Clause "Simplified" License
797 stars 189 forks source link

Support Presto as the input SQL #170

Open wenruimeng opened 3 years ago

wenruimeng commented 3 years ago

We had a few offline conversations about the n-to-one-to-n proposal, which is to support any engine query to any other engine query.

This issue is the feature quest to introduce Presto SQL as the input query and translate it into intermediate Coral representation and then it can be translated to other engines that are already supported in Coral output.

There are a few stages for this feature: 1) Parse Trino SQL to Calcite SqlNode 2) Calcite SqlNode to Trino RelNode (most work is about the function resolver) 3) Trino RelNode to Intermediate Coral RelNode 4) End to end test

JiajunBernoulli commented 3 years ago

Sounds good, have you used it in the production environment?