Sep 23–26, 2019
Please log in

Learning Presto: SQL on anything

Matt Fuller (Starburst)
9:00am12:30pm Tuesday, September 24, 2019
Location: 1E 08
Average rating: *****
(5.00, 2 ratings)

Who is this presentation for?

  • Data engineers, data architects, software engineers, and those in IT

Level

Beginner

Description

Used by Facebook, Netflix, Airbnb, LinkedIn, Twitter, Uber, and others, Presto has become the ubiquitous open source software for SQL on anything. Presto was built from the ground up for fast interactive SQL analytics against disparate data sources ranging in size from GBs to PBs.

Join Matt Fuller to learn how to use Presto and explore use cases and best practices you can implement today. You’ll have the opportunity to join in on a hands-on exercise, but you can simply follow along if you prefer. Matt will provide an overview of Presto and its history, Presto architecture and technical concepts, getting started with Presto, migrating from Hive, administering Presto, security in Presto, query federation, Presto on cloud environments (including AWS Athena), advanced Presto concepts and tuning, and joining the Presto open source community.

Prerequisite knowledge

  • A basic understanding of SQL, databases, Hadoop, and distributed systems

Materials or downloads needed in advance

  • A laptop with the ability to SSH into a remote machine and an AWS account or Docker installed

What you'll learn

  • Learn Presto fundamentals as well as some advanced topics
Photo of Matt Fuller

Matt Fuller

Starburst

Matt Fuller is cofounder at Starburst, the Presto company. Previously, Matt has held engineering roles in the data warehousing and analytics space for the past 10 years, including director of engineering at Teradata, where he led engineering teams working on Presto and was part of the team that led the initiative to bring open source, in particular Presto, to Teradata’s products; architected and led development efforts for the next-generation distributed SQL engine at Hadapt (acquired by Teradata in 2014); and was an early engineer at Vertica (acquired by HP), where he worked on the query optimizer.

Comments on this page are now closed.

Comments

Arun kumar | Platform Manager – Business Intelligence and Analytics
09/24/2019 12:28pm EDT

great session.
thanks

  • Cloudera
  • O'Reilly
  • Google Cloud
  • IBM
  • Cisco
  • Dataiku
  • Intel
  • Io-Tahoe
  • MemSQL
  • Microsoft Azure
  • Oracle Cloud Infrastructure
  • SAS
  • Arcadia Data
  • BMC Software
  • Hazelcast
  • SAP
  • Amazon Web Services
  • Anaconda
  • Esri
  • Infoworks.io, Inc.
  • Kyligence
  • Pitney Bowes
  • Talend
  • Google Cloud
  • Confluent
  • DataStax
  • Dremio
  • Immuta
  • Impetus Technologies Inc.
  • Keyence
  • Kyvos Insights
  • StreamSets
  • Striim
  • Syncsort
  • SK holdings C&C

    Contact us

    confreg@oreilly.com

    For conference registration information and customer service

    partners@oreilly.com

    For more information on community discounts and trade opportunities with O’Reilly conferences

    strataconf@oreilly.com

    For information on exhibiting or sponsoring a conference

    pr@oreilly.com

    For media/analyst press inquires