Apache HAWQ (now part of Apache MADlib) was a massively parallel processing (MPP) SQL query engine on Hadoop. It allowed users to query data stored in HDFS using standard SQL, enabling faster and more efficient analysis of large datasets compared to traditional MapReduce.