This ECL Tip spotlights the Enterprise Control Language (ECL) AGGREGATE built-in function. ECL AGGREGATE has been seen by many in the community as ‘complex,’ and as such, has been underused. However, in using AGGREGATE you can be sure you’re playing to the strengths of HPCC Systems.
This ECL Tip spotlights the Enterprise Control Language (ECL) DISTRIBUTE function. The ECL DISTRIBUTE function redistributes data across all nodes in a cluster. Using the DISTRIBUTE function can help prevent “cluster skew”, by distributing data evenly across all nodes. This function can be used on Thor or the ROXIE cluster.
This ECL Tip spotlights the Enterprise Control Language (ECL) TABLE function. The TABLE function is a versatile tool for ETL (extract, transform, load) operations, and was one of the first ECL statements available, well before the family of TRANSFORM functions.
This ECL Tip spotlights the top ten most common Enterprise Control Language (ECL) compiler/runtime errors, and how to correct them. Developers often encounter these specific errors while learning ECL. Most of these errors are easy to fix, but it is important to understand what the error message is saying and what needs to be corrected.
This ECL Tip spotlights the Enterprise Control Language (ECL) SET and the functions that incorporate SET. ECL SET is a useful tool in query design and processing. One of the most common applications for ECL SET is to simplify code by eliminating multiple “OR” conditions in a filter.
The Enterprise Control Language (ECL) LOOP function has always been a powerful, yet tough function to understand and use. For this reason, changes were made to the HPCC Systems ECL Language Reference manual. The documentation updates make it easier to understand and effectively use the ECL LOOP function.