Hello, I’m creating a table using CTA:
create table nas_source.table_name HASH PARTITION BY (id_fecha_dim)
as select ....
Then insert, update, delete data, and then try drop table drop table nas_source.table_name and have error “cannot drop table since it has child tables”
I’ve already check that no has child tables in INFORMATION_SCHEMA."TABLES"
@dacopan if you remove formatting on nas_source.table_name, do you see another promoted folder under it?
Hi @balaji.ramaswamy not, if I removed formatting, only appear folder of iceberg structure, version-hint, sobfolders for each fragment partition, etc
but not other promoted folder
I’ve already check that no has child tables in INFORMATION_SCHEMA."TABLES" and nothing reference it