[CALCITE-911] Add a variant of CalciteSchema that does not cache sub-objects

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Jinfeng Ni
• Reporter: Jinfeng Ni
• Created: 06/Oct/15 02:03
• Updated: 27/Feb/24 22:24
• Resolved: 06/Nov/15 07:44

Description

CalciteSchema by default uses cache to store table, sub-schema, function. This would work perfectly for schema-based system, yet would create problem for Drill, which dynamically explore the schema on the fly during query execution.

One solution is to refactor CalciteSchema and make it as an interface. The default implementation would still use the current implementation. Further, it would other system to extend the default behavior and make CalciteSchema works for Drill as well.

Background information: The issue around CalciteSchema is one of the reasons that Drill has to use a forked version of Calcite. Hopefully, if we could resolve this issue, we are one step further to remove the forked Calcite in the near future.

Issue Links

• incorporates: CALCITE-1742 Create a read-consistent view of CalciteSchema for each statement compilation
• relates to: DRILL-4093 Use CalciteSchema from Calcite master branch