Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  • Run a basic 'Hello World' program both from the command line and using an editor, such as our ECL IDE.
  • Run a simple anagram query on Thor.
  • Spray a word list file to Thor and run a second anagram query using this file to evaluate which results are actual words. Publishing the query to Roxie allows you to use a web based interface (Ws-ECL) to enter a word from which to make anagrams using this query.


Get started with a tutorial


Tutorial nameTutorial descriptionDownload
Six Degrees of Kevin BaconYou don't have to be an expert in the ECL language to see evidence of the processing power of HPCC Systems. This tutorial perfectly illustrates how to extract links and find relationships in large quantities of data. The code examples are supplied for you to copy and paste into your editor so you can run the queries and see the results you want to see quickly and easily. Find out how many degrees of separation there are between Kevin Bacon and any actor included in the Internet Movie Database (IMDB), which you must download from this external data source.


Data files

Data Handling

Get your data on and off HPCC Systems. Find out how to spray (import) and despray (export) your data from your HPCC Systems landing zone. Learn how to copy data from one cluster to another and also how to replicate data held on a cluster in one HPCC Systems environment, on a cluster in a completely different HPCC Systems environment.

Data TutorialWork through the query development process from beginning to end. See how ECL is used to process and query the data supplied which includes names and addresses. This tutorial also serves as an introduction to our Data Refinery Cluster (Thor) and our Data Delivery Engine (Roxie).


Data file

Extend your knowledge using our guides

Guide NameGuide Description
ECL Programmers GuideTry out some ECL language features. Download some example code and use your chosen development environment (for example our ECL IDE) to see how a sample of the most commonly used ECL language features work.  Learn about ECL programming concepts, working with super files, using Roxie and embedded languages and datastores.

Guide (English)

Guide (Chinese)

Code files

ECL Language ReferenceLearn all you need to know about the ECL language starting with the basics. ECL was designed specifically for the processing of large quantities of data fast and efficiently. Every query you write can be leveraged by other queries which means that the language extends itself as you use it. This guide also contains details about reserved words, special structures, built-in functions and actions, workflow services, template language and using external services.Guide
ECL Best PracticesTips, tricks and best practices for coding in ECL. Learn about syntax, including naming conventions, indentation and how to avoid syntax errors cause by 'lost parentheses'. Find out why SET definitions are more practical than multiple OR conditions and learn how to translate your ECL idea into ECL code. Our Developer Forum Tips and Tricks area is also a great place to find out about other ways our users have found to solve their challenges use ECL.


Go to our Developer Forum

Client Tools

Learn how to master the following command line features:

  • ECLPlus - Used to facilitate the automation of ECL code execution
  • ECL command syntax
  • ECL Compiler as a stand alone option
  • DFUPlus - Used to facilitate the automation of data file spray, despray, and other common file handling tasks
  • ESDL command syntax