When I attempt to remove Iceberg table created as ‘CREATE TABLE myschema.mytable as SELECT …’ on NAS data source.
I am getting following explanation:
Cannot drop table [myschema.mytable] since it has child tables
How can I drop/remove such table ?
Thank you
You are hitting a quirky Dremio’s feature that is called “child tables” which we are planning to deprecate. Essentially tables within the tables. Those have some issues associated with them - you are hitting one of them (obscurity).
Can you run this and see if there are other tables under [myschema.mytable]?
SELECT * from INFORMATION_SCHEMA."TABLES" order by "TABLES".TABLE_SCHEMA
If yes - delete child tables first.