Two things that immediately jump out at me: - Under "File Formats" both parquet and text are listed. For best performance, we recommend using parquet wherever possible. - The version of Impala you are using is old - 2.5 vs. the latest release of 2.11. There are a number of perf improvements that have gone in recently, though its hard to say if those will help you without knowing more about your use case. If neither of those suggestions help, you might consider posting the complete query profile, available at the "Download profile" link, which contains a lot more info about what was going on during your query.
... View more