Learning ECL

Community Wiki

The HPCC Systems Community Wiki includes information provided by the community covering best practices, tips, sample code and examples. The HPCC Systems Red Book also contains useful information to help users manage the transition between releases.

Learn more


HPCC Data Tutorial: with an Introduction to Thor and Roxie

This tutorial provides a walk-through of the development process from beginning to end and is designed to be an introduction to working with data on HPCC, as well as give an introduction to Thor and Roxie. The Sample Data Files are required references for the tutorial. 

View the PDF

Sample Data File (one needed)
In ZIP Format: OriginalPerson.zip
In tar.gz Format: OriginalPerson.tar.gz
Uncompressed: OriginalPerson


ECL Programmers Guide

The ECL Programmers Guide gives an introduction to the ECL language along with example data and use cases. The supporting ECL Code Files referenced in the guide are included below. 

View the PDF

Supporting ECL Files
In ZIP Format: ECL Code Files.zip


ECL Playground

ECL Playground is a tool hosted on an ESP server. A page runs in your browser, allowing you to access and execute self-contained ECL code on your HPCC system without the use of any other tools. The ECL Playground then shows you the results and the graph in your browser. The view is very similar to what the ECL IDE displays.
Listen to the ECL Playground Podcast and how it can be a helpful tool for developers. 

View the PDF


ECL Best Practices

This guide is a collection of tips and techniques that target the best practices of ECL programming.

View the PDF



ECL Scheduler

The ECL Scheduler is a component process installed with the HPCC system platform. ECL Scheduling provides a means of automating processes within ECL code or to chain processes together to work in sequence.

View the PDF



ECL Language Reference

ECL is the Enterprise Control Language designed specifically for huge data projects using the HPCC platform. Its extreme scalability comes from a design that allows you to leverage every query you create for re-use in subsequent queries as needed. To do this, ECL takes a dictionary approach to building queries wherein each ECL definition defines an Attribute. Each previously defined Attribute can then be used in succeeding ECL Attribute definitions as the language extends itself as you use it. 

View the PDF


Visualizing ECL Results

The ECL compiler now supports adding external resources to a Workunit using a manifest file. The manifest, in XML format, adds external resources such as XSLT transformations, or other objects to the archive before it is compiled and deployed to the server. This document demonstrates how to use this feature to visualize ECL job results using Google Chart Tools. 

View the PDF


Standard Library Reference

The Standard Library Reference includes utility functions for string handling, date manipulation and others. 

View the PDF


Data Handling

These steps explain how to move data on or off an HPCC Cluster. 

View the PDF



All third party trademarks, logos and copyrights are property of their respective owners.

Free Training

Take advantage of our free training resources to get the most out of HPCC Systems.

Sign up today

Free Assessment

Contact us to discuss how your organization can benefit from HPCC Systems.

Introduction to HPCC Systems

Learn more about the types of big data problems the HPCC System platform can solve, and how it solves them.

Learn more