A housing open-data team wants ad-hoc, SQL-like queries over tables stored on HDFS without hand-writing low-level MapReduce Java for every ask. Which layer best matches that need?
Select an answer to reveal the explanation.
Short Explanation
Analysts asking "how many permits by ZIP?" want SQL, not a weekend of Java MapReduce. Hive puts a SQL-like face on HDFS tables. Kafka meters, cart locks, and CAP slides don't answer that ad-hoc ask.
Full Explanation
Hive provides SQL-like access and metadata over data stored in the Hadoop ecosystem, compiling queries into execution plans rather than requiring hand-coded MapReduce for every summary. That fits ad-hoc civic analytics on cataloged HDFS tables. Kafka ingestion, OLTP checkout, and CAP theory discussions address different BDPC concerns.