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 ?
here is a thread that can help you: