Support Questions

Find answers, ask questions, and share your expertise

alter table concat : why do i have to run it several times ?


I have a table (not partitioned), with tons of small files...

So, I had run an "alter table concat" and it works, but not in the way i thought...

From tons of small files (let say 10 000), i get 1 000 ; i run again and i get 100, to converge to 5 files...

I use a lot of SET instructions but I think I used them without understanding their purpose.

So, is there a way to concat a table in a only file, in a one shot ?

Thanks 🙂



Expert Contributor