[FEATURE] Add Calcite JDBC executor as new frontend in shardingsphere-proxy
to allow federated querying of any datasources via MySQL/PG clients
#32020
Replies: 4 comments
-
Good idea, but it need more time to design and impl, I just set it as |
Beta Was this translation helpful? Give feedback.
-
Hello , this issue has not received a reply for several days. |
Beta Was this translation helpful? Give feedback.
-
It sounds like this involves dialect conversion and calcite translator adaptation when querying with tables |
Beta Was this translation helpful? Give feedback.
-
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale. |
Beta Was this translation helpful? Give feedback.
-
Proposal
I would like to propose adding two new executors to
ShardingSphere Proxy
:Postgres
Frontend,Calcite
JDBC ExecutorMySQL
Frontend,Calcite
JDBC ExecutorThis would allow using any tool/client that is compatible with either the MySQL or Postgres wire protocols to query across datasources:
Design
shardingsphere-proxy-frontend-calcite-mysql
shardingsphere-proxy-frontend-calcite-postgres
openGauss
executor does with Postgres)jdbc://calcite
sourceroot Schema
IE:
Beta Was this translation helpful? Give feedback.
All reactions