There are some non-default configuration options that are needed to efficiently run on S3 that can be found here https://www.cloudera.com/documentation/enterprise/5-9-x/topics/impala_s3.html#s3_best_practices What EC2 instance type was used for Impala and how big was the cluster? Also can you please attach the Impala query profile?
... View more
