Support Questions
Find answers, ask questions, and share your expertise

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

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

Hello,

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 :)

SF

1 REPLY 1

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

Expert Contributor