Optimize Federation-Query

[boyjoy1127]

Feature Request

Federation Query should be optimized.

Is your feature request related to a problem?

No

Describe the feature you would like.

• Add TranslateTable to support projection and filter push down to the table rel-node.
• Add optimization rules to support projection and filter push down to the table rel-node.
• Optimize rules to support projection and filter push down well.
• Add cache for SQL and query plan.
• Add calcite statistics-related API in the future infra-meta module.
• Optimize rules to support the join well. Collect calcite statistics of the schema and table, to support optimization well.
• Optimize rules to support the sub-query well. Collect calcite statistics of the schema and table, to support optimization well.
• Optimize the procedure of the execution to accelerate the query.

[strongduanmu]

Hi @boyjoy1127, Could we finish this issue in 5.1.3?