Forum Discussion

govindarajan_d's avatar
govindarajan_d
Super User
2 years ago

Running Vacuum on Lakehouse table throws error

Hi All,   I have been trying to run vacuum on multiple tables using both Adhoc maintenance option as well as Spark and I am getting the following error:     These tables are updated by Dat...
data engineering
AndyDDC's avatar
AndyDDC
Most Valuable Professional
2 years ago

Hi govindarajan_d has the VACUUM command ever worked on these tables?

  • govindarajan_d's avatar
    govindarajan_d
    Super User
    2 years ago

    Hi AndyDDC ,

    This is the first time I am running VACUUM on these tables. 

    For few other tables that have been updated by Spark, VACUUM works fine. Two tables that are updated by Dataflow Gen 2 throws the error. 

    • AndyDDC's avatar
      AndyDDC
      Most Valuable Professional
      2 years ago

      govindarajan_d I've tested using a Dataflow Gen2 to load into a Delta table and then ran the VACUUM command and it worked successfully.  What version of Spark are you using in the workspace that the lakehouse is in?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi govindarajan_d ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet . Did you got a chance to look into AndyDDC  reply?
        In case if you have any resolution please do share that same with the community as it can be helpful to others .
        Otherwise, will respond back with the more details and we will try to help .