Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

So you've installed the HPCC Systems platform, Client Tools and ECL IDE (or an editor of your choice):

Certify your system is functioning correctly

  • Preflight - Open ECL Watch and navigate to the Operations area to run a preflight check on all Systems Servers and Cluster Processes to make sure all machines are running and operating as expected with available disk space, memory and CPU. Failed components or results falling outside the expected norm are shown in orange. Find out more using our Preflight and Certification Guide or Using ECL Watch Guide.
  • _Certification - Check that your Thor and Roxie components are working correctly and giving results as expected. The folder containing the files you need is located in your C:\Users\Public\Documents\HPCC Systems\ECL\My Files\Examples folder and is stored here automatically when you download HPCC Systems Client Tools. ECL IDE (or the editor you are using) displays the _Certification folder in your repository tree. Take a look at ReadMeFirst.ecl to make sure you are set up correctly, find out the sequence you should use to run the files in the correct order and to make any necessary changes to the code that may be unique to your environment, such as IP addresses etc. More information about running these tests is available in our Preflight and Certification Guide.

Follow the examples in our installation guide to run some simple programs

  • 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.

Learn some ECL

Learn some ECL

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


  • No labels