addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Facebook's PRESTO: Distributed, fast SQL query engine for petabyte scale data

Facebook uses Presto for interactive queries against several internal data stores, including their 300PB data warehouse. Over 1,000 Facebook employees use Presto daily to run more than 30,000 queries that in total scan over a petabyte each per day.

In this session, I will go through Hive , we will insert some real time tweets to one table. Join another table from structured database to this tweet table.

I will go through Presto installation and configuration from scratch, describing the architecture.

Then we will use Presto to query the joined data we created earlier, and I will show you that there is no MapReduce involved, unlike Hive queries !

Now lets use a business intelligence reporting tool to access that data through Presto JDBC driver.

In summary, you will know how to get your results from petabyte scale data faster.

As usual, this will probably the very first discussion about Presto in our area. And please be the first to master it too.

All are welcome and thanks for your support.


Join or login to comment.

  • PK G.

    Great Presentation! Made a good case for Presto! Seemed like meetup was down after the presentation and I just got back on!

    1 · March 19, 2014

    • Ravishankar

      You are right Gnanam, thanks for the note

      March 19, 2014

  • Raj

    Great presentation Ravi.

    March 2, 2014

  • Jack C.

    Wow! Amazing end-to-end open source solution. Thank you for sharing. Can you share the links?

    February 28, 2014

  • John

    Excellent example of using PRESTO with R!

    February 28, 2014

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy