Managed Delta Table corrupted

[Rafael-Sousa]

Hey guys,

Recently, we have add some properties to our delta table and after that, the table shows error and we cannot do anything. The error is that: (java.util.NoSuchElementException) key not found: spark.sql.statistics.totalSize

I think maybe this is a bug related to spark connect client in databricks.

[Alberto_Umana]

Hi @Rafael-Sousa,

This issue can occur when certain statistics are missing or not properly updated in the Delta table's metadata.

You can try to manually update the statistics for the Delta table. This can be done by running the ANALYZE TABLE command to compute statistics for the table:

ANALYZE TABLE your_table_name COMPUTE STATISTICS;

[Rafael-Sousa]

Hey @Alberto_Umana ,

The problem is that I am not able to run this commando too. The error persists for any kind of operation that I try to run on the table.

[Alberto_Umana]

Hi @Rafael-Sousa,

Could you please raise a support case for this, to investigate this further?

help@databricks.com