Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Remote Training: Roxie ECL (Part 2) – Complex Query Development

HPCC Systems

Thursday, June 22, 2017 at 9:00 AM - Friday, June 23, 2017 at 5:00 PM (EDT)

Ticket Information

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

Share Remote Training: Roxie ECL (Part 2) – Complex Query Development

Event Details

HPCC Systems

Remote Training: Roxie ECL (Part 2) – Complex Query Development

Note: This course is the second in a two-part ROXIE series. People who attend the
Roxie ECL (Part 1) – Indexes and Queries class should continue with this class.

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.

Course Length: 2 days

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

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

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 2) – Complex Query Development? Contact HPCC Systems

When

Thursday, June 22, 2017 at 9:00 AM - Friday, June 23, 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 2) – Complex Query Development
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.