to continue
Db | Select | Insert/Update | Notes |
---|---|---|---|
Amazon Athena | Yes | No | Query data against S3 |
Engine | (MapReduce Dependency|Batch Mode) | Description |
---|---|---|
Impala | No | Impala is well-suited to executing SQL queries for interactive exploratory analytics on large datasets. |
Apache Hive | Yes | Hive and MapReduce are better tools for very long running, batch-oriented tasks such as ETL. |
Interactive SQL support to data stored in Hadoop:
They are based on Google’s ad-hoc query system called Dremel.
See Hive - Hive command line with Map Reduce