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.
Course Length: 2 days
Class Prerequisites: Students must have attended the Introduction to ECL and Introduction to Thor Training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.
- 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 Monday at 1pm and concludes at 5pm.
Class begins Tuesday at 9am and concludes at 5pm.
Class begins Wednesday at 9am and concludes at 12pm.
When & Where
HPCC Systems® (www.hpccsystems.com) from LexisNexis® Risk Solutions offers a proven, data-intensive supercomputing platform, designed for the enterprise, to process and solve Big Data analytical problems. As an alternative to legacy technology, HPCC Systems offers a consistent data-centric programming language, two processing platforms and a single, complete end-to-end architecture for efficient processing.