beam icon indicating copy to clipboard operation
beam copied to clipboard

[SQL] Alter Catalog and Table statements

Open ahmedabu98 opened this issue 2 months ago • 7 comments

Addresses #35637

Adds the following features:

Modify a catalog's properties

ALTER CATALOG my_catalog 
[ RESET ('prop1', 'prop2', ...) ] 
[ SET ('prop5'='val5', 'prop6'='val6', ...) ]

Modify a table's properties, schema, or partition spec

ALTER TABLE my_table
[ DROP COLUMNS (col1, col2, ...) ]
[ ADD COLUMNS (col5 VARCHAR COMMENT 'some-comment', col6 INTEGER, ...) ]
[ DROP PARTITIONS ('col1', 'month(col4)', ...) ]
[ ADD PARTITIONS ('truncate(col5, 3)', 'col4', ...) ]
[ RESET ('prop1', 'prop2', ...) ] 
[ SET ('prop5'='val5', 'prop6'='val6', ...) ]

Limitations:

  • Does not support adding a required/non-null column to an Iceberg table (introduced in V3). Iceberg requires such a column to specify a default value (so that existing rows can adapt that value to their new column), but Beam Schemas do not support a "default value"

ahmedabu98 avatar Oct 20 '25 20:10 ahmedabu98

Assigning reviewers:

R: @Abacn for label java.

Note: If you would like to opt out of this review, comment assign to next reviewer.

Available commands:

  • stop reviewer notifications - opt out of the automated review tooling
  • remind me after tests pass - tag the comment author after tests pass
  • waiting on author - shift the attention set back to the author (any comment or push by the author will return the attention set to the reviewers)

The PR bot will only process comments in the main thread (not review comments).

github-actions[bot] avatar Nov 11 '25 20:11 github-actions[bot]

/gemini review

ahmedabu98 avatar Nov 13 '25 22:11 ahmedabu98

Reminder, please take a look at this pr: @Abacn

github-actions[bot] avatar Nov 21 '25 12:11 github-actions[bot]

assign to next reviewer

Abacn avatar Nov 21 '25 20:11 Abacn

Assigning reviewers:

R: @kennknowles for label java.

Note: If you would like to opt out of this review, comment assign to next reviewer.

Available commands:

  • stop reviewer notifications - opt out of the automated review tooling
  • remind me after tests pass - tag the comment author after tests pass
  • waiting on author - shift the attention set back to the author (any comment or push by the author will return the attention set to the reviewers)

The PR bot will only process comments in the main thread (not review comments).

github-actions[bot] avatar Nov 21 '25 20:11 github-actions[bot]

Reminder, please take a look at this pr: @kennknowles

github-actions[bot] avatar Nov 29 '25 12:11 github-actions[bot]

Assigning new set of reviewers because Pr has gone too long without review. If you would like to opt out of this review, comment assign to next reviewer:

R: @Abacn for label java.

Available commands:

  • stop reviewer notifications - opt out of the automated review tooling
  • remind me after tests pass - tag the comment author after tests pass
  • waiting on author - shift the attention set back to the author (any comment or push by the author will return the attention set to the reviewers)

github-actions[bot] avatar Dec 03 '25 12:12 github-actions[bot]

/gemini review

ahmedabu98 avatar Dec 10 '25 16:12 ahmedabu98

Reminder, please take a look at this pr: @Abacn

github-actions[bot] avatar Dec 18 '25 12:12 github-actions[bot]