Skip to content

Use YDB Date32 for Trino dates - #262

Merged
KirillKurdyukov merged 14 commits into
mainfrom
codex/trino-date-types
Sep 14, 2026
Merged

KirillKurdyukov merged 14 commits into
mainfrom
codex/trino-date-types

Conversation

@KirillKurdyukov

@KirillKurdyukov KirillKurdyukov commented Sep 11, 2026

Copy link
Copy Markdown
Collaborator

New Trino DATE columns use YDB Date32, and connector-created JDBC connections pass forceSignedDatetimes=true. The connector retains the standard Trino date reader/writer and physical column metadata. There is no separate adapter option.

The change restores the three original inherited date tests and the original DATE cases in the data-mapping test by removing earlier overrides. Temporary diagnostic tests, alternate catalogs and CI modes are removed; the workflow matches main.

Exact head: c33cd6d1ca8da1deb1dcb8b2173a67b46d643ba2. Four files, +9/-25 = 34 changed lines against main 119d4bce. Independent exact-commit source review and JDK25 test compilation passed.

Fresh full CI passed on merge 874b30e14cf2cdc579f384a1edd5736cccbe7ecf: 307 total, 222 passed, 85 skipped, 0 failures, 0 errors. Smoke: 35 total / 31 passed / 4 skipped. Connector: 272 total / 191 passed / 81 skipped. The ordinary unfiltered suite includes the restored inherited date cases and TopN. Restoring their bodies does not increase the test count. Runtime is verified in CI; local Docker is unavailable.

Known limits: this change does not fix the previously observed range-filter and UPDATE problems for legacy Date columns. Do not set forceSignedDatetimes=false in the JDBC URL, whose values override connection properties. Timestamp mappings are unchanged. No new support claim for legacy writes or other temporal types.

@KirillKurdyukov
KirillKurdyukov marked this pull request as ready for review September 11, 2026 12:55
@KirillKurdyukov

KirillKurdyukov commented Sep 11, 2026

Copy link
Copy Markdown
Collaborator Author

Ready for review, 1/1 among current ready changes. Final scope: JDBC forceSignedDatetimes=true and Date32 for new Trino DATE columns. Exact head c33cd6d; 4 files, +9/-25 = 34 lines.

Independent source review and JDK25 compilation passed. Fresh ordinary full CI34818905331 passed: 307 total, 222 passed, 85 skipped, 0 failures/errors. Three original inherited date-test bodies and original DATE mapping cases are restored; temporary diagnostics and special CI modes are removed. Legacy Date range/UPDATE limitations and URL override precedence are documented. This supersedes earlier experimental readiness messages; no automatic merge.

@KirillKurdyukov
KirillKurdyukov marked this pull request as draft September 11, 2026 13:03
@KirillKurdyukov KirillKurdyukov changed the title Support physical YDB Date and Date32 columns in Trino Use YDB Date32 for Trino dates Sep 14, 2026
@KirillKurdyukov
KirillKurdyukov marked this pull request as ready for review September 14, 2026 07:45
@KirillKurdyukov
KirillKurdyukov merged commit 2c1c7b2 into main Sep 14, 2026
1 check passed
@KirillKurdyukov
KirillKurdyukov deleted the codex/trino-date-types branch September 14, 2026 07:48
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant