Pivotal Engineering Journal
Technical articles from Pivotal engineers.
Mar 14, 2017
Plotting Using an MPP Database
A tutorial on how to build histograms, scatter plots, and ROC curves using an MPP database and plot them in Python or R.
Jan 31, 2017
Making Hive profile dynamic
Post about efficient usage of all existing PXF Hive-related profiles with minimal user interfaction
Xin (Shin) Zhang
Oct 12, 2016
Profiling Query Compilation Time with GPORCA
GPORCA is Pivotal’s Query Optimizer for Greenplum Database and Apache HAWQ (incubating). In this post, we describe how users can profile query compilation with GPORCA. This will aid users in understanding which of GPORCA’s steps is the most resource intensive, and what transformations are being triggered. Based on this information, users can provide query hints to reduce or increase the search space, see where the time and memory is being spent, and learn how to influence its decision making.