What are the fundamental architectural, SQL compliance, and data use scenario differences between Presto and Impala?

Question

Can some experts give some succinct answers to the differences between Presto and Impala from these perspectives?

1. Fundamental architecture design
2. SQL compliance
3. Real-world latency
4. Any SPOF or fault-tolerance functionality
5. Structured and unstructured data use scenario performance

Answer 1

Apache Impala is a query engine for HDFS/Hive systems only.

Presto on the other hand is a generic query engine, which support HDFS as just one of many choices. There is a long list of connectors available, Hive/HDFS support is just one of them. This also means that you can query different data source in the same system, at the same time.