apache / apache/gravitino

[Subtask] Complete V3 type compatibility for the PostgreSQL catalog

Open
#12,067 0 comments 0 reactions 1 assignee Claimed by @nevzheng View on GitHub
2.0.0 subtask
Dominant language
Java
Stars
3.2k
Forks
935
Avg merge
1d 16h
Merged PRs (30d)
298

Description

### Describe the subtask

Complete and document the five-family compatibility contract for PostgreSQL.

**Compatibility outcomes**

- **Nanosecond timestamps:** Reject precision `> 6`; PostgreSQL cannot preserve nanoseconds faithfully.
- **Variant:** Reject because `json` and `jsonb` do not implement the full Variant contract.
- **Unknown/Null:** Reject.
- **Geometry:** Reject writes until PostGIS subtype and SRID metadata can be recovered faithfully.
- **Geography:** Reject writes until PostGIS subtype and SRID metadata plus Gravitino edge-algorithm semantics can be recovered faithfully.

**Acceptance**

- Reproduce all five families through the connector's public create/conversion path and its alter/load paths where supported.
- A supported mapping must round-trip without losing type identity or parameters.
- An unsupported mapping must return `IllegalArgumentException` before external metadata mutation; no fallback to a narrower or opaque type is allowed.
- Cover nested types where the connector supports complex columns.
- Add focused converter/operation tests and an integration or no-side-effect test appropriate to the connector.
- Update the connector documentation with a five-family compatibility matrix and rejection rationale.
- Keep implementation commits atomic by connector and type family.

**Connector-specific verification**

Keep native JSON and PostGIS reads explicit as external types. Reproduce converter, SQL-generation, and Docker create/no-table paths, proving every rejection occurs before SQL.

**Documentation**

`docs/jdbc-postgresql-catalog.md`

### Parent issue

#12056

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.