I create table via SQL in Dremio. Data was inserted by Spark after that . SELECT query is working.
But when I try run ANALYZE or VACUUM I have error - Unable to find requested dataset ...
@abukreev I just tried on the table I created via Spark SQL and Vacuum works fine. It could be possible that either the full path is not set or the context is not set right .Can you please try this, navigate to the dataset via the Dremio UI then click the copy icon to the right of the table name and then use that in your command, see screenshot below
@balaji.ramaswamy I use Nessie catalog and and I think the reason for this problem is this
@abukreev For Nessie only VACUUM CATALOG is supported