ONLINE: ROXIE ECL (Part 1) - Indexes and Queries

Actions Panel

ONLINE: ROXIE ECL (Part 1) - Indexes and Queries

ONLINE: ROXIE ECL (Part 1) - Indexes and Queries

By HPCC Systems

Location

Online

Refund Policy

Contact the organizer to request a refund.

About this event

Introduction to ROXIE - Indexes and Queries

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.

Class Prerequisites: Students must have completed the Introduction to ECL (Part 1) & (Part 2) and Advanced ECL (Part 2) online courses. 

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)

Organized by

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

Sales Ended