We've upgraded to CDH 5.6.0 and we still have the same issue. I've tried both
ALTER TABLE <table> SET FILEFORMAT PARQUET;
ALTER TABLE <table> PARTITION (<partition>) SET FILEFORMAT PARQUET;
but none of this worked. Any ideas how can I resolve it?
The below method worked for us. This is from https://issues.cloudera.org/browse/IMPALA-2048
If the table is MANAGED: