Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Remote Training: ROXIE ECL (Part 1) - Indexes and Queries

HPCC Systems

Tuesday, June 20, 2017 at 9:00 AM - Wednesday, June 21, 2017 at 5:00 PM (EDT)

Ticket Information

Ticket Type Sales End Price Fee Quantity
Attendee Ended $995.00 $0.00

Who's Going

Loading your connections...

Share Remote Training: ROXIE ECL (Part 1) - Indexes and Queries

Event Details

HPCC Systems

Remote Training: ROXIE ECL (Part 1) - Indexes and Queries

Note: This course is the first in a two-part ROXIE series. People who attend the Roxie ECL (Part 1) – Indexes and Queries class, should also attend the Roxie ECL (Part 2) – Complex Query Development. Both classes are presented in the same week.

This class is for developers who want to extend their knowledge of ECL to developing Roxie queries for end-user use. In this course you will learn the benefits of payload indexes as well as use of the indexed joins that make query results fast. Anyone planning to write ECL code to provide final product data to end-users should attend this course.

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL and Introduction to ECL (Part 1) - Concepts and Queries, the Introduction to ECL (Part 2) - the Extract, Transform, and Load (ETL) Process, and the Advanced ECL (Part 2) –  Super files, Working with XML, and Free-form Text Parsing training classes. Registered students will receive an invitation to the online details for the course.

Topics include:

  • Defining and Creating INDEXes
  • Using FETCH
  • Creating Roxie Queries (STORED)
  • Testing queries in hThor
  • Deploying to Roxie
  • Payload Indexes
  • Full and Half-Keyed JOINs
  • Optimizing Queries (LIMIT, ATMOST, KEEP)

Class begins at 9am and concludes at 5pm. Breaks will be provided throughout the day for lunch and lab assignments. Your instructor will provide more information before class.

Have questions about Remote Training: ROXIE ECL (Part 1) - Indexes and Queries? Contact HPCC Systems

When

Tuesday, June 20, 2017 at 9:00 AM - Wednesday, June 21, 2017 at 5:00 PM (EDT)


  Add to my calendar

Organizer

HPCC Systems

HPCC Systems is an open source, massive parallel-processing computing platform for big data processing and analytics.

  Contact the Organizer
Remote Training: ROXIE ECL (Part 1) - Indexes and Queries
Class Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.