Skip Main Navigation
Page Content

Save This Event

Event Saved

ONLINE: ROXIE ECL (Part 2) - Complex Query Development

HPCC Systems

ONLINE: ROXIE ECL (Part 2) - Complex Query Development

Registration Information

Registration Type Price Fee Quantity
Attendee $495.00 $0.00

Event Details

ROXIE ECL (Part 2)- Complex Query Development

Learn how to optimize and organize your ROXIE queries for optimal performance. This class reviews and recommends best practices used in ROXIE development, including INTERFACE, Half Keyed JOINS, LIMIT, superkeys, and package maps.

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

Topics include:

• Using INTERFACE structures with ROXIE queries
• Limiting your ROXIE results (LIMIT, JOIN, CHOOSEN)
• Designing queries using multiple datasets
• Case insensitive searches
• Use of Superkeys in ROXIE queries
• Use of package maps for Query organization
• ROXIE-specific functions (PRELOAD, ALLNODES, etc.)
• ROXIE Post filtering

Have questions about ONLINE: ROXIE ECL (Part 2) - Complex Query Development? Contact HPCC Systems

Save This Event

Event Saved

Organizer

HPCC Systems

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

  Contact the Organizer

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.