The sample Retail demo data set used in the tutorial exercises models an online retail store operation. The store carries different categories of products. Customers order the products. The company …

This example demonstrates loading sample data describing an oil rig using a Joost STX transformation. The data is in the form of a complex XML file downloaded from energistics.org.

Exercise: Create, Add Data to, and Query HAWQ Retail Demo Tables Perform the following steps to create and load HAWQ tables from the sample Retail demo data set.

Sample hawq-site.xml Configuration File <configuration><property><name>default_hash_table_bucket_number</name><value>18</value></property><property><name>hawq_dfs_url ...

Sample Data Set Examples used in this topic will operate on a common data set. This simple data set models a retail sales operation and includes fields with the following names and data types: ...

In the following discussion, a data set defined by a sample schema will be represented using each read mode of the PXF JSON plug-in. The sample schema contains data fields with the following names …

Using PL/R in HAWQ PL/R Examples Example 1: Using PL/R for Single Row Operators Example 2: Returning PL/R data.frames in Tabular Form Example 3: Process Employee Information Using PL/R …

Perform the following steps to create a sample data file, copy the file to HDFS, and use the HdfsTextMulti profile to create a PXF external table to query the data:

The actual XML data is extracted from a ZIP file attached to a MIME “transmission file” message. For more information about MeF, see Modernized e-File (Overview) on the IRS web site. The sample …

#!/bin/bash# input_transform.sh - sample input transformation, # demonstrating use of Java and Joost STX to convert XML into# text to load into HAWQ.# java arguments:# -jar joost.jar joost STX engine# …