Tag: Trino

Showing 73 results

Learning SQL with the Trino experts from Starburst

October 4, 2023

Ever wondered how to get the most out of Trino and Starburst Galaxy as a data engineer or analyst wrangling SQL statements? Or what a catalog is compared to a database and a schema? You want to learn more about SQL statements like MERGE and UPDATE. Or scalar, window, aggregate and table functions for powerful analysis of your data. We have the right thing for you. Join the Trino creators and Starburst CTOs Martin Traverso, Dain Sundstrom, and David Phillips, as well as myself, Manfred Moser, author of Trino: The Definitive Guide and Trino maintainer, in our upcoming SQL training series.

BestSecret’s data journey: Moving beyond Snowflake

August 16, 2023

Of all the seventy-plus speakers at the festival, there was one presentation that I found to be particularly interesting – and not because the speaker also happens to be our customer. That presentation was from Lutz Künneke, Director of Engineering, and Isa Inalcik, Senior Data Engineer, at BestSecret, a leading European online destination for off-price fashion based near Munich, Germany. As Künneke got to the stage, the first words out of his mouth were: “We are moving off of Snowflake.” 

Leveraging zero-cost reporting with plain text files and Git

August 15, 2023

Discover a cost-effective alternative to traditional business intelligence tools by utilizing plain text files, Git version control, and GitHub Actions for automated, zero-cost reporting solutions.

Harnessing Trino for performance engineering and data analytics at Salesforce

August 8, 2023

Learn how Salesforce uses Trino for data analytics and performance engineering, boosting service availability and customer experiences through efficient insights and real-time data access.

Run optimized geospatial queries with Trino

March 23, 2023

The Trino open source distributed query engine is known as a choice for running ad-hoc analysis where there’s no need to model the data and...

Shopify cuts execution time from hours to seconds with Iceberg and Trino

February 21, 2023

Over a decade ago, the founders of Shopify launched a store to sell snowboards online. The existing e-commerce solutions at the time didn’t give...

Trino for Large-Scale ETL @ Lyft

January 25, 2023

Lyft operates one of the largest transportation networks in the world. A business like ours depends on data on so many levels. Data relating...

Apache Iceberg Time Travel & Rollbacks in Trino

December 7, 2022

This post is part of the Iceberg blog series. Read the entire series: Introduction to Apache Iceberg in Trino Iceberg Partitioning and Performance Optimizations...

Building lakehouse with dbt and Trino

November 30, 2022

In this series, we demonstrate how to build data pipelines using dbt and Trino with data directly from your operational systems. They can use...

Apache Iceberg Schema Evolution in Trino

November 22, 2022

This post is part of the Iceberg blog series. Read the entire series: Introduction to Apache Iceberg in Trino Iceberg Partitioning and Performance Optimizations...

Reliving the Hype: Highlights from Trino Summit 2022

November 18, 2022

Last week in San Francisco was one for the Trino history books. After three years of planning, rescheduling, planning, and rescheduling some more, Starburst...

Apache Iceberg DML (update/delete/merge) & Maintenance in Trino

November 17, 2022

This post is part of the Iceberg blog series. Read the entire series: Introduction to Apache Iceberg in Trino Iceberg Partitioning and Performance Optimizations...

Iceberg Partitioning and Performance Optimizations in Trino

November 8, 2022

This post is part of the Iceberg blog series. Read the entire series: Introduction to Apache Iceberg in Trino Iceberg Partitioning and Performance Optimizations...

Countdown to Trino Summit 2022

November 1, 2022

It’s finally here! We are closing in on the final countdown to Trino Summit 2022, and I can feel myself getting more excited with...

Introduction to Apache Iceberg In Trino

October 20, 2022

This post is part of the Iceberg blog series. Read the entire series: Introduction to Apache Iceberg in Trino Iceberg Partitioning and Performance Optimizations...

Second Edition of Trino: The Definitive Guide

October 5, 2022

Starburst has played a key role in the Trino community for a long time now. We contribute  to the success of Trino every day....

Moonlighting for Trino

October 5, 2022

Starburst was founded all around the Trino project and community, and it shows! The passion to work on Trino, Java, and other open source...

Trino Turns Ten!

August 8, 2022

Starburst is thrilled to wish Trino a very happy tenth birthday! We have lots of reasons to celebrate, most importantly because we at Starburst...

Near Real-Time Ingestion For Trino

August 4, 2022

It is quite popular in today's data climate for modern data architectures to have some sort of batch processing system to move data into...

Use Metabase as a Starburst BI tool

August 3, 2022

Metabase can now be used to connect to SEP, Starburst Galaxy, and Trino as a BI tool and client.Metabase excels at providing BI insights...

Announcing the 2022 Trino Summit

July 7, 2022

It’s happening! Starburst is excited to act as the lead sponsor for the 2022 Trino Summit. Join us online or in-person on November 10th,...

Announcing the 2022 Trino Summit

July 6, 2022

It's happening! Starburst is excited to act as the lead sponsor for the 2022 Trino Summit. ...

The Past, Present, and Future of Trino

May 24, 2022

Recently, I had the pleasure of chatting with Ravit Jain on his show “The Ravit Show” to discuss the evolution of Trino and where...

Cinco De Trino 2022: A Trino-tastic Celebration!

May 11, 2022

What a day! On May 5, 2022, we had a truly worldwide gathering with people tuning in from six different continents to celebrate Cinco...

New release of the dbt-trino adapter

May 9, 2022

dbt labs released version 1.1 of the dbt-core project in late April, 2022. This did not catch the maintainers of the dbt-trino project by...

Starburst and Databricks Collaborate on the Trino Delta Lake Connector

March 24, 2022

This blog was co-authored by Claudius Li, Product Manager at Starburst, and Joe Lodin, Information Engineer at Starburst. Starburst recently donated the Delta Lake...

Welcome to Starburst, Andrii Rosa!

March 18, 2022

Andrii Rosa is one of the top 5 all-time contributors to Presto. He was also the last remaining top 5 contributor at Facebook until...

Starburst donates the Delta Lake connector to Trino

March 15, 2022

Starburst was founded around the Trino open source project. Many contributors and maintainers of the project are part of our teams. Our products, Starburst...

What A SQL Query Engine Can Do For Big Data

February 16, 2022

Nod with me if you’ve suffered from the following problems with processing and analyzing Big Data via a centralized approach: different query languages, niche...

Increased CPU utilization in Trino

February 3, 2022

While working on performance enhancements at Starburst, engineering focuses on reducing the amount of time that a CPU has to work on a given...

A Trino and dbt community success story

January 3, 2022

The community around the open source project Trino is at the heart of Starburst. The creators and many maintainers are on our teams. Our...

Intro to Trino for the Trinewbie

November 2, 2021

If you haven’t heard of Trino before, it is a query engine that speaks the language of many genres of databases. As such, Trino...

How Assurance Unlocked More Business Value with Starburst

September 9, 2021

By leveraging Starburst, Assurance was able to improve conversion rates, reduce costs, and enable robust modeling. Read the full case study here. ...

Accelerating Data Science with Trino

August 31, 2021

At our Datanova for Data Scientists conference on July 14, I held a discussion with Dain Sundstrom and David Philips, CTOs of Starburst, about...

Starburst Elements: What is Trino?

July 15, 2021

Data engineers are struggling to keep up with the demands of their data consumers. Every team has their favorite database object storage or other...

Announcing: Trino Summit 2021!

July 7, 2021

Greetings Trino nation, As mentioned in last year’s Presto Summit blog, “It’s not goodbye, it’s see you later!” We may not have guessed at...

Query Federation Made Simple at Comcast

June 24, 2021

The media and telecommunications provider now known as Comcast began as a regional operator with just five channels and 12,000 customers. Today, Comcast has...

Trino on Ice IV: Deep Dive Into Iceberg Internals

June 8, 2021

Welcome back to the Trino on Ice blog series that has so far covered some very interesting high level concepts of the Iceberg model,...

Managing Secrets in Trino

June 3, 2021

Most companies want to follow good security practices. With the number of security breaches coming out daily, it almost feels like a matter of...

Trino on Ice III: Iceberg Concurrency Model, Snapshots, and the Iceberg Spec

May 25, 2021

Welcome back to this blog series discussing the amazing features of Apache Iceberg. In the last two blog posts, we’ve covered a lot of...

Trino on Ice II: In-Place Table Evolution and Cloud Compatibility with Iceberg

May 11, 2021

In-place table evolution and cloud compatibility with Iceberg ...

Trino On Ice I: A Gentle Introduction To Iceberg

April 27, 2021

We’re excited to debut this blog series ‘Trino on Ice’ with a gentle introduction to Iceberg. Stay tuned for future posts from the Trino...

Trino, Data Governance, and Accelerating Data Science

April 22, 2021

Back during the Datanova conference, I had the pleasure of interviewing Martin, Dain, and David, three of the original creators of Presto. They started...

Understanding the Starburst and Trino Hive Connector Architecture

February 18, 2021

After a decade of running Hive queries on their data lakes, many companies are astonished at the speeds in which they are able to...

A Gentle Introduction to the Hive Connector

February 12, 2021

TL;DR: The Hive connector is what you use in Starburst Enterprise for reading data from object storage that is organized according to the rules...

PrestoSQL becomes Trino

December 28, 2020

Just like Linux, there are multiple derivatives of Presto. Trino is the one maintained by the creators of Presto. “What's in a name? That...

Top 10 Reasons to Migrate from OS Presto on EMR to Starburst Enterprise Presto

November 13, 2020

In today’s data architecture economy, there are no shortages of options when it comes to choosing various distributions and deployment strategies for a given...

Presto Turns Eight Years Old!

August 26, 2020

Presto just turned eight years old only a few weeks ago, and it's just getting started.  ...

The Death of Apache Drill

August 6, 2020

One of the things that really drew me to and got me excited about Presto over 4 years ago was that it wasn’t tied...

Presto & Data Science: Getting Data Into the Hands of Data Scientists (Faster)

June 26, 2020

A few days ago I read a Gartner report stating that data scientists spend 23% of their time on data collection and preparation. I...

Presto Summit SF, Postponed to 2021

June 1, 2020

It’s not goodbye, it’s see you later! We’ve made the difficult decision to postpone the Presto Summit SF to February 24, 2021. We've reached...

Starburst and The Presto Foundation

June 1, 2020

Since the first day I met Presto creators Martin, Dain, and David at Facebook back in 2014, I was convinced that they were building...

Podcast: Justin Borgman Interviews with The VentureFizz Podcast

March 23, 2020

Our CEO & Co-Founder, Justin Borgman, was recently interviewed for the 169th episode of The VentureFizz Podcast. ...

Presto at Pinterest

March 12, 2020

Article reposted from Medium with permission from the author,  Ashish Singh | Pinterest Engineer, Data Engineering As a data-driven company, many critical business decisions...

Piotr Findeisen, a profile of one of Starburst’s Presto experts

January 7, 2020

We call ourselves the Presto experts here at Starburst Data, but what does that actually mean?  ...

Presto on Kubernetes

August 2, 2019

Kubernetes (K8s) eases the burden and complexity of configuring, deploying, managing, and monitoring containerized applications. We are excited to announce the availability and support...

Consumption Layers 101

July 12, 2019

The typical big data infrastructure is a Frankenstein’s monster of legacy hardware, cloud connections, and storage environments. Data exists in different silos, in every...

Presto Summit 2019 Recap

June 25, 2019

*If you are looking for the 2019 NYC Presto Summit, event info and registration can be found here.* Presentation Slides Presentation Videos   The...

Your analysts don’t care where the data lives, neither should you

April 30, 2019

In today’s enterprise, data is arguably one of the most valuable assets. With advances in data analytics technology, enterprises can more easily convert enormous...

The Presto Software Foundation

January 31, 2019

By now, we all know the Presto origin story: Three brilliant developers, Martin, Dain, and David, join Facebook in 2012 and start the Presto...

General SQL Features in Presto

January 1, 2019

Welcome to the Advanced SQL Features in Presto series. In this series you are going to cover a set of SQL features that expands...

Securing Presto with Apache Ranger

October 3, 2018

Starburst is excited to announce the general availability of Starburst Presto Enterprise 208e. This is the first Presto release to bring you Apache Ranger...

Presto Summit 2018 recap

July 23, 2018

A few weeks ago, together with the Presto team at Facebook, we announced the first-ever Presto Summit. In less than 2 weeks the event...

Querying data in S3 using Presto and Looker

July 10, 2018

With more and more companies using AWS for their many data processing and storage needs,  it’s never been easier to query this data with...

Presto Available on AWS Marketplace!

June 19, 2018

  Today I am excited to announce the availability of Presto on AWS Marketplace by Starburst. The Presto AWS Marketplace offering is based on...

Data Lakes without Hadoop

May 14, 2018

It seems like migrating to the cloud has dominated the news and a lot of companies are shuttering their data centers and letting cloud...

Presto Memory Connector

May 1, 2018

Originally posted http://prestodb.rocks/news/presto-memory There is a highly efficient connector for Presto! It works by storing all data in memory on Presto Worker nodes, which...

Presto Join Enumeration

April 17, 2018

Karol Sobczak, Co-founder and Software Engineer at Starburst Welcome back to the series of blog posts (checkout our previous post!) about Presto's first Cost-Based...

Introduction to Trino Cost-Based Optimizer

April 9, 2018

The Cost-Based Optimizer (CBO) we have released just recently achieves stunning results in industry standard benchmarks (and not only in benchmarks)! The CBO makes...

Presto Cost-Based Optimizer rocks the TPC benchmarks!

April 3, 2018

Wojciech Biela, Co-founder at Starburst Introduction As mentioned in our previous blog about the Starburst Presto release and its hottest addition - the Cost...

Presto gets EVEN FASTER, with a 10-15x performance boost in upcoming release!

March 20, 2018

Next week, we will be releasing the Starburst Distribution of Presto 195e. Based on prestosql/presto 0.195, Starburst’s 195e will ship with Presto’s first cost-based...

Starburst @ Strata — 3x Presto!

March 13, 2018

The Strata Data conference in San Jose last week was another great event in the Strata series. Those coming from the Hadoop background definitely noticed...

Presto – Next Chapter

December 13, 2017

As you may have learned from our first press release, we have announced the creation of Starburst, a new independent company solely focused on...

Start Free with
Starburst Galaxy

Up to $500 in usage credits included

  • Query your data lake fast with Starburst's best-in-class MPP SQL query engine
  • Get up and running in less than 5 minutes
  • Easily deploy clusters in AWS, Azure and Google Cloud
For more deployment options:
Download Starburst Enterprise

Please fill in all required fields and ensure you are using a valid email address.