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
- New to the ECL language? We have a number of resources to get you started from tutorials and guides to videos and online training courses. Take a look and see which suit your needs the best.
- Know the basic and want to extend your knowledge? Become an expert using these resources and training courses.
- Want to embed another programming language in your ECL code? Find out which languages we support and how to use the EMBED feature.
Learn some ECL
|Tutorial name||Tutorial description||Download|
|Six Degrees of Kevin Bacon||You 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.|
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 Tutorial||Work 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).|
Extend your knowledge using our guides
|Guide Name||Guide Description|
|ECL Programmers Guide||Try 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.|
|ECL Language Reference||Learn 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 Practices||Tips, 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.|
Learn how to master the following command line features: