ECL (Enterprise Control Language) is a C++ based query language for use with HPCC Systems Big Data platform. ECLs syntax and format is very simple and easy to learn.

// Schema to use on data
Layout_Person := RECORD
 UNSIGNED1 PersonID;
 STRING15 FirstName;
 STRING25 LastName;
END;

//Calling the data to be used. Similar to USE DATABASE; (SQL)
//Example inline data
allPeople := DATASET([ {1,'Fred','Smith'},{2,'Joe','Blow'},{3,'Jane','Smith'}],Layout_Person);

//FILTER by Lastname 
somePeople := allPeople(LastName = 'Smith');

// Outputs ---
OUTPUT(somePeople);

 

small_pig_thin

Hadoop Pig

Note – ECL is very similar to Hadoop’s pig ,but more expressive and feature rich.

Tagged on:         

Leave a Reply

Your email address will not be published. Required fields are marked *