×
Blog
Resources
Pages
Documentation
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...
A single point of access to all your data
© Starburst Data, Inc. Starburst and Starburst Data are registered trademarks of Starburst Data, Inc. All rights reserved. Presto®, the Presto logo, Delta Lake, and the Delta Lake logo are trademarks of LF Projects, LLC