University of Florida (UF)

Getting up and running with ECL:

Workshop links:

Join us at our HPCC Systems ECL Workshop

 

Event date

April 2-5, 2024

Location

Conference room 7028 Malachowsky Hall

Cost

Free

Hosted by

University of Florida

Eligibility

Must be a UF student who pre-registered for the event

Registration 

FULL

Learn

  • Topics Include:

    • Syntax and Queries

    • ETL (Extract, Transform, and Load)

    • Data Delivery

    • Analytics (featuring Machine Learning)

Data Source

Provided on training cluster (Active March 29 - April 5)

Workshop Trainer, and Hackathon support

Bob Foreman - Software Engineering Lead

 

What you need

  • A laptop

  • Installed VS Code with ECL Extension or ECL IDE

  • Ability to access the public internet (available in workshop room)

Quick start resources

Group messaging application

Microsoft Teams

Internship Opportunities

Find out more about the HPCC Systems intern program

What can I do to prepare?

First thing to do is to watch this series of videos on the introduction to ECL.

Course Title

Video Link

Course Title

Video Link

Introduction to ECL Part 1 Session 1: HPCC Architecture and Introduction to ECL 

Part 1

Introduction to ECL Part 1 Session 2: More ECL Introduction, RECORD and DATASET 

Part 2

Introduction to ECL Part 1 Session 3: ECL Definitions 

Part 3

Introduction to ECL Part 1 Session 4a: Functions and Value Definitions 

Part 4

Introduction to ECL Part 1 Session 4b: Functions and Value Definitions 

Part 5

Introduction to ECL Part 2 Session 1a: ETL with ECL, Crosstab Reports 

Part 6

Introduction to ECL Part 2 Session 1b: ETL with ECL, Crosstab Reports 

Part 7

Introduction to ECL Part 2 Session 2a: Data Evaluation, TRANSFORM functions 

Part 8

Introduction to ECL Part 2 Session 2b: Data Evaluation, TRANSFORM functions 

Part 9

Introduction to ECL Part 2 Session 3a: Transform using Tables, ROLLUP 

Part 10

Introduction to ECL Part 2 Session 3b: Transform using Tables, ROLLUP 

Part 11

Introduction to ECL Part 2 Session 3c: Transform using Tables, ROLLUP 

Part 12

Introduction to ECL Part 2 Session 4a: JOINS and Class Wrap Up 

Part 13

Introduction to ECL Part 2 Session 4b: JOINS and Class Wrap Up 

Part 14

 

We have many resources available for you to use to familiarize yourself with our technology and how to use it. If you are new to us, then take some time to find out about HPCC Systems and what we do. Find out how HPCC Systems works, what ECL is and take a look at what goes on in our community.

  • Watch a quick overview video about HPCC Systems

  • Create your own Localized Container based Cluster. 

    • Note:  We will be using a cloud-based HPCC Systems cluster for the workshop.

  • You can use your preferred editor to write code but we do have our own, a Windows-based ECL IDE which you can download. On the download page, under Operating System, select Windows. Download both the ECL IDE and Client Tools.

  • VS Code is a good code editor if you don't use Windows.  Installation is slightly more complicated see below and also this cheat sheet:

    1. Download and install VS Code from here if you don't already have it installed.

    2. Download the HPCC Systems Client Tools from here.

      1. Choose your operating system from the popup list.

      2. Choose the appropriate "Client Tools" option for your operating system.  Make sure only one checkbox on the entire page is selected.

      3. Download and install.

    3. Launch VS Code, then search for and install the extension named "ECL (Enterprise Control Language) support for Visual Studio Code".

  • Once you’re up and running, try out a few of the tutorials.

  • Learn some ECL. This is the language used to write queries. It's easy to use, try it for yourself. Read the documentation or take a training course. 

  • Take a look at some video tutorials

Be a hero: Help save Missing Kids

Please help HPCC Systems and the ADAM Program to save missing children in your local area by signing up for email alerts!

All pages in this wiki are subject to our site usage guidelines.