Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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

New Contributor

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
Don't have an account?
Coming from Hortonworks? Activate your account here