apache / apache/gravitino

[FEATURE] Add view support to Trino connector

Open
#11,925 0 comments 0 reactions 0 assignees View on GitHub
feature
Dominant language
Java
Stars
3.2k
Forks
935
Avg merge
1d 16h
Merged PRs (30d)
298

Description

### Describe the feature

Support creating, reading, replacing, renaming, and dropping views via Trino SQL on Gravitino-backed catalogs.

### Motivation

Gravitino exposes a ViewCatalog API and the Flink connector already consumes it. The Trino connector should allow users to manage and query these views via Trino SQL.

### Describe the solution

Implement the view-related `ConnectorMetadata` methods in the Trino connector by delegating to the ViewCatalog API, and fix the Hive backend's rejection of the `trino` SQL dialect so Hive-backed views work end-to-end.

### Additional context

No additional context.

Contributor guide

Open the contributing guide

Research direction

Start with the Trino connector's ConnectorMetadata implementation and the ViewCatalog API, using the existing Flink connector as a reference. Also inspect the Hive backend's SQL-dialect validation for the trino case. Done means Trino SQL can create, read, replace, rename, drop, and query Gravitino-backed views through Hive-backed catalogs.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
backend, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.