Presto Connector cannot handle new Timestamp column type from PR #1788

[coderabbitai]

Issue Description

The CLP Presto Connector currently cannot handle the new Timestamp column type introduced in PR #1788, causing internal errors when querying with Presto.

Context

• Breaking PR: feat(clp-s)!: Add Timestamp column type to replaceDateString column type; Bump the archive version to 0.5.0. #1788 (commit f82e611)
• Affected Component: CLP Presto Connector
• Impact: Presto queries fail with internal errors

The issue was discovered during testing of PR #2004 (Presto Helm chart support). The error can be reproduced after merging main into the Presto feature branch.

References

• PR feat(clp-s)!: Add Timestamp column type to replaceDateString column type; Bump the archive version to 0.5.0. #1788: feat(clp-s)!: Add Timestamp column type to replaceDateString column type; Bump the archive version to 0.5.0. #1788
• PR feat(helm)!: Add Presto query engine support to the Helm chart. #2004: feat(helm)!: Add Presto query engine support to the Helm chart. #2004
• Comment: feat(helm)!: Add Presto query engine support to the Helm chart. #2004 (comment)

Reported by: @junhaoliao

[20001020ycx]

The issue requires Presto/Velox to be upgraded to 0.297 for resolving the fmt version introduced by the latest log surgeon dependency.
Upgrade of Presto 0.297 is now merged: y-scope/presto#147
Upgrade of Velox 0.297 is now merged: y-scope/velox#53

[20001020ycx]

In terms of the actual code that makes the new timestamp type adapted at Presto/Velox, the PR linked below:

Timestamp Type Adaption at Presto, approved, will merge after ci finishes validation: y-scope/presto#148.
Timestamp Type Adaption at Velox, merged: y-scope/velox#54.

[20001020ycx]

We shall be closing the issue early tmr when all of the PRs are merged, so that we can unblock the progress of #2004.

[20001020ycx]

Closing the issue as all related PRs are merged