OpenViSTAI · Agents · Blockchain · Crypto
Submit a project
Menu
Infrastructure

Apache HAWQ and reg

Apache HAWQ is an open-source, Hadoop-native MPP database and SQL analytics engine for interactive queries over large datasets stored in HDFS.

Explore the practical guide ↓

Independent OpenViST project profile, based on linked sources.

Apache HAWQ and reg — OpenViST project profile in Infrastructure.
OpenViST project illustration. See the linked sources for product details.
Understand the project

Practical overview

When it fits

Use HAWQ when SQL analytics needs to run against large Hadoop datasets in HDFS and a HAWQ cluster is available to operate.

Who it is for

  • Teams analyzing large datasets stored in Apache Hadoop.
  • Database and cluster administrators managing HAWQ deployments.
  • Developers building SQL analytics services over HDFS data.

Documented uses

  • Run SQL queries over Hadoop data stored in HDFS.
  • Create and query HAWQ-managed tables.
  • Manage HAWQ clusters and databases.
  • Use PXF to access external HDFS data sources.
Before you choose

Requirements & limits

  • The documented workflow requires a running HAWQ 2.x single-node or multi-node cluster.
  • The tutorial supports several environment routes: a commercial distribution, sandbox virtual machine, Docker environment, or source-built installation.
  • PXF is the tutorial’s documented route for accessing external HDFS data sources.

Check current requirements in the official documentation. Source-based guidance does not mean OpenViST has run or independently tested this project.

Source-based practical guide

Explore HAWQ tables and external HDFS data

Follow the tutorial’s sequence for setting up a HAWQ runtime, creating and querying tables, and accessing external HDFS data with PXF.

Before you start

  • A running HAWQ 2.x single-node or multi-node cluster.
  • A commercial HAWQ distribution, sandbox virtual machine, Docker environment, or installation built from source.

Steps

  1. Examine and set up the HAWQ runtime environment.

  2. Work through the tutorial’s cluster and database administration lessons.

  3. Download the tutorial data and work files, create the Retail demo schema, and load data to HDFS.

  4. Create and query HAWQ-managed tables, then use PXF to access external HDFS data.

Expected outcome

A tutorial-led introduction to HAWQ administration, SQL queries on managed tables, and PXF access to external HDFS data.

Guide limitations

  • The tutorial requires an already running HAWQ 2.x cluster; it does not, in the described prerequisites, provide a standalone hosted service.
Documentation 1 ↗
Evidence and transparency

Sources & review

hawq.apache.org ↗Guide documentation ↗
Source record details
Source availability
Active
Sources checked
12 October 2026
Original website title
Apache HAWQ&reg · Official homepage title · retained in its source language
How we review sourcesSuggest a correction