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?