Consider adapting the SQL Federation feature for openGauss databases

[strongduanmu]

Feature Request

Is your feature request related to a problem?

No.

Describe the feature you would like.

Currently, ShardingSphere uses Calcite JDBC to implement the SQL federation feature, and provides basic support for MySQL and PostgreSQL database. Due to the importance of the openGauss database, we decided to adapt the SQL federation feature to the openGuass database. In order to adapt to the openGauss database, we need to complete the following subtasks.

• [x] Complete the remaining tasks in issue #13091 to make query optimization and ShardingSphere work well together;
• [ ] Optimize openGuass select statement and view statement parsing——https://opengauss.org/zh/docs/latest/docs/Developerguide/SELECT.html;
• [ ] Convert openGuass statement syntax tree to calcite syntax tree
• [ ] SQL Federation feature adapts to openGauss data type
• [ ] SQL Federation feature supports distributed transaction management
• [ ] SQL Federation feature supports cross-database views

[boyjoy1127]

Mark this.

[strongduanmu]

Hi @boyjoy1127, welcome to join this task. 😀

[FlyingZC]

I want to participate in the task. @strongduanmu

[strongduanmu]

@FlyingZC I will assign this issue to you.

[strongduanmu]

All tasks has been finished, so I will close this issue.