Apache HAWQ edit  

A port of the Greenplum MPP database (which itself is based on PostgreSQL) to run over YARN and HDFS. Supports all the features of Greenplum (ACID transactions, broad SQL support and in database language and analytics support, including support for Apache MADLib), integration with Apache Ambari, an Input Format for MapReduce to read HAWQ tables, and both row and Parquet (column) based storage of data managed by HAWQ. Also supports queries over data not managed by HAWQ via external tables, with a Java based framework (PXF) for accessing external data, and out of the box support for accessing data in HDFS (text, Avro, JSON), Hive and HBase, with a number of open source connectors also available. Fault tolerant and horizontally scalable, with the ability to scale up or down on the fly. Originally created as Pivotal HAWQ based on a fork of Greenplum in 2011, with an initial 1.0 release as part of Pivotal HD in July 2013. Open sourced and donated to the Apache Foundation in September 2015, becoming Apache HAWQ, with the first open source release (2.0) in October 2016, and graduating in August 2018. Development led by Pivotal, who also distribute binaries as Pivotal HDB and provide training, consultancy and support. Pivotal HDB is also available as Hortonworks HDB, with support and consultancy provided by Hortonworks.

Technology Information

Other NamesPivotal HDB, Hortonworks HDB
VendorsThe Apache Software Foundation, Pivotal, Hortonworks
TypeCommercial Open Source
Last UpdatedSeptember 2018 - v2.4

Related Technologies

Add on toHortonworks Data Platform

Release History

versionrelease daterelease linksrelease comment


  • News via Pivotal blog
  • Latest release detailed on Pivotal HDB documentation page

Blog Posts