portals-project / portals

Portals is a framework for stateful serverless apps, unifying dataflow streaming with actors
https://www.portals-project.org/
Apache License 2.0
19 stars 2 forks source link

Unify the SQL library experimental work #228

Open jspenger opened 1 year ago

jspenger commented 1 year ago

There has been some work on an SQL library which is experimental work. Currently, there are multiple versions and branches, see below for some references.

Context:

This is a very large issue, which needs to be broken down into smaller tasks at some other point in time. At the core, we want to merge the SQL library into the main branch. For this, we need to unify the two separate SQL experiments that we currently have. Additionally, we need to clean up the experiments. For one of them, we are currently using Apache Calcite, which has both performance implications, as well as implementation implications. In my opinion we should remove the Calcite dependency, use some other parser and planner, such that we have more control over the evaluation. I am not sure if the current implementation actually works in a failure-free manner when executed distributed.

See

https://github.com/portals-project/portals/tree/portals-sql-experiment https://github.com/portals-project/portals/tree/portals-sql-experiment/portals-libraries/src/main/scala/portals/libraries/queryable https://github.com/portals-project/portals/tree/portals-sql-experiment/portals-libraries/src/main/scala/portals/libraries/sql