hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karen Vuong <kar...@apache.org>
Subject [VIRTUAL] Apache HAWQ Nest - GPORCA: The Next Generation Query Optimizer is Now Open Source
Date Tue, 02 Feb 2016 21:20:57 GMT
Hi all,

It’s time for the next HAWQ Nest Virtual Meeting on February 23rd at 9AM

This meeting will start with a 20-minute technology discussion topic,
followed by a contributor discussion and open Q&A.

20-minute User Tech Talk - GPORCA: The Next Generation Query Optimizer is
Now Open Source

GPORCA is newly open source advanced query optimizer that is a subproject
of Greenplum Database open source project.  GPORCA is the query optimizer
used in commercial distributions of both Greenplum and HAWQ.  In these
distributions GPORCA has achieved 1000x performance improvement across
TPC-DS queries by focusing on three distinct areas: Dynamic Partition
Elimination, SubQuery Unnesting, and Common Table Expression.

Now that GPORCA is open source, we are looking for collaborators to help us
realize the ultimate dream for GPORCA - to work with any database.

The new breed of data management systems in Big Data have to process so
much data that optimization mistakes are magnified in traditional
optimizers.  Furthermore, coding and manual optimization of complex queries
has proven to be hard.

In this session, Venkatesh will discuss:

- Overview of GPORCA
- How to add GPORCA to HAWQ with a build option
- How GPORCA could be made to work with any database
- Future vision for GPORCA and more immediate plans
- How to work with GPORCA, and how to contribute to GPORCA

Speaker: Venkatesh Raghavan - Staff 1, Query Processing Team

Venky is a core member of Pivotal’s Query Processing team. He holds
multiple patents focusing on Big Data processing and database design. He
joined Pivotal, then Greenplum, after received his Ph.D. from the Worcester
Polytechnic Institute in Massachusetts, where he focused on database

Standing agenda:

-Open Jiras, and ways to contribute
-Next release coordination
-Open Q&A

Please join us on February 23, 2016 at:

2/23 San Francisco, CA 9:00 AM PST UTC-8 hours
2/23 New York, NY 12:00 PM EST UTC-5 hours
If you have never attended an Adobe Connect meeting before:

Test your connection:

Get a quick overview: http://www.adobe.com/products/adobeconnect.html



  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message