ALTER TABLE - event-listener records don't provide the table name

[bhzaeri]

When a table is altered by the ALTER TABLE command (column added, dropped, or renamed), the table names are not included in the triggered events received in the queryCompleted method of the io.trino.spi.eventlistener.EventListener interface.
All of these are empty:

queryCompletedEvent.getMetadata().getTables()
queryCompletedEvent.getIoMetadata().getInputs()
queryCompletedEvent.getIoMetadata().getOutput()

This is an example of the SQL alter command:
alter table sqlserver_sa.dbo.persons add column zip varchar

[mosabua]

Can you verify if the info shows up in the web UI please

[bhzaeri]

Yes, I see the events in the web ui.

[mosabua]

Great is the table info there also missing?

[bhzaeri]

This is what I'm seeing. It looks okay.

[ebyhr]

@mosabua You can simply reproduce this issue with OpenLineageListenerQueryRunner.

[Praveen2112]

I think we don't support capturing events for ALTER events.

[bhzaeri]

@Praveen2112 Raising events for ALTER events is supported. I see them in the event listeners. But the table and schema names are empty.

[moritzia]

@mosabua I also found in Alter, there is no tablename.

@Override
 public void queryCompleted(QueryCompletedEvent event) {

     // Capture input tables and columns
     List<QueryInputMetadata> inputs = event.getIoMetadata().getInputs();
     for (QueryInputMetadata input : inputs) {
         System.out.println("Input Table: " + input.getSchema() + "." + input.getTable());
.....

How can we reach to table name and column name in alter statement?

[mosabua]

Looks like this is a valid issue. I am not aware of anybody working on it so maybe you want to have a look at fixing that and sending a PR @moritzia ?