Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] (trino-connector) Support update catalog operations in trino-connector #2417

Closed
diqiu50 opened this issue Mar 4, 2024 · 0 comments
Assignees
Labels
feature New feature or request

Comments

@diqiu50
Copy link
Contributor

diqiu50 commented Mar 4, 2024

Describe the feature

Trino connector support stored procedure to update catalog attributes.

alter_catalog(CATALOG varchar, SET_PROPERTIES MAP(VARCHAR, VARCHAR), REMOVE_PROPERTIES ARRY[VARCHAR]);
  • CATALOG: The catalog name to be altered.
  • SET_PROPERTIES: The properties to be set.
  • REMOVE_PROPERTIES: The properties to be removed.

These stored procedures are under the gravitino connector, and the system schema.
So you need to use the following SQL to call them in the trino-cli:
Example:

call gravitino.system.alter_catalog(
    catalog => 'mysql',
    set_properties=> Map(
        Array['jdbc-url'],
        Array['jdbc:mysql:127.0.0.1:3306?useSSL=false']
    ),
    remove_properties => Array['jdbc-driver']
)

Motivation

No response

Describe the solution

No response

Additional context

No response

@diqiu50 diqiu50 added the feature New feature or request label Mar 4, 2024
@diqiu50 diqiu50 added this to the Gravitino 0.5.0 milestone Mar 4, 2024
@diqiu50 diqiu50 self-assigned this Mar 4, 2024
diqiu50 added a commit that referenced this issue Mar 26, 2024
…rino-connector (#2564)

### What changes were proposed in this pull request?

Trino connector support stored procedure to update catalog attributes.

### Why are the changes needed?

FEATURE: #2417

### Does this PR introduce _any_ user-facing change?

Add  stored procedure alter_catalog. 

### How was this patch tested?

Add new IT
coolderli pushed a commit to coolderli/gravitino that referenced this issue Apr 2, 2024
…s in trino-connector (apache#2564)

### What changes were proposed in this pull request?

Trino connector support stored procedure to update catalog attributes.

### Why are the changes needed?

FEATURE: apache#2417

### Does this PR introduce _any_ user-facing change?

Add  stored procedure alter_catalog. 

### How was this patch tested?

Add new IT
@diqiu50 diqiu50 closed this as completed Apr 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant