Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Inserting to text table compressed

avatar
Rising Star

I see no way to specify a compression default in the create table statement, so I tried:

 

SET COMPRESSION_CODEC=gzip;insert overwrite <text_table> select .. from <another_table>

 

and got "Writing to compressed text table is not supported. Use query option ALLOW_UNSUPPORTED_FORMATS to override." but ALLOW_UNSUPPORTED_FORMATS shouldn't be used according to docs.

 

Is there a trick to having impala write text files compressed?

 

-Mauricio

 

1 ACCEPTED SOLUTION

avatar
Super Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
Super Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login