[FLINK-20873][Table SQl/API] Update to calcite 1.27

[snuyanzin]

What is the purpose of the change

The PR is to update calcite dependency to 1.27

Verifying this change

From one side it's partially covered by existing tests From another side it would make sense to have multiple end-to-end user tests (probably still discussable )

Does this pull request potentially affect one of the following parts:

• Dependencies (does it add or upgrade a dependency): (yes )
• The public API, i.e., is any changed class annotated with @Public(Evolving): (no )
• The serializers: ( no)
• The runtime per-record code paths (performance sensitive): (no)
• Anything that affects deployment or recovery: JobManager (and its components), Checkpointing, Kubernetes/Yarn, ZooKeeper: (no)
• The S3 file system connector: (no)

Documentation

• Does this pull request introduce a new feature? (no)
• If yes, how is the feature documented? (not applicable)

[flinkbot]

CI report:

• 3c360726f0997d6c48bdbc1f188fceb06d9f09e6 UNKNOWN
• 65a35979284a51c938edaffd9eaed79ef2d70226 Azure: SUCCESS

Bot commands

The @flinkbot bot supports the following commands:

• @flinkbot run azure re-run the last Azure build

[snuyanzin]

@flinkbot run azure

[snuyanzin]

Thanks for your feedback rebased

[snuyanzin]

@flinkbot run azure

for some reason build has not started