- 216
- 212 260
Trino
United States
เข้าร่วมเมื่อ 7 ก.พ. 2019
Trino is a high performance, distributed SQL query engine for big data, formerly known as PrestoSQL
Getting ready to summit
Second part of the training series SQL basecamps before Trino Summit 2024
See trino.io/blog/2024/10/07/sql-basecamps and trino.io/blog/2024/11/21/sql-basecamps-view
Slides at trinodb.github.io/presentations/presentations/getting-ready-to-summit/index.html
0:00 Introduction and Trino Summit
1:00 Recap and overview
3:54 Dealing with change on the lakehouse
21:01 Maintenance tips
36:31 MERGE
40:20 Structural data type
42:00 JSON and json_table
48:57 Array, map, and row
58:45 Views
1:08:22 Closing
See trino.io/blog/2024/10/07/sql-basecamps and trino.io/blog/2024/11/21/sql-basecamps-view
Slides at trinodb.github.io/presentations/presentations/getting-ready-to-summit/index.html
0:00 Introduction and Trino Summit
1:00 Recap and overview
3:54 Dealing with change on the lakehouse
21:01 Maintenance tips
36:31 MERGE
40:20 Structural data type
42:00 JSON and json_table
48:57 Array, map, and row
58:45 Views
1:08:22 Closing
มุมมอง: 48
วีดีโอ
Moving supplies into your Trino-powered lakehouse
มุมมอง 17814 วันที่ผ่านมา
First part of the training series SQL basecamps before Trino Summit 2024 See trino.io/blog/2024/10/07/sql-basecamps and trino.io/blog/2024/11/21/sql-basecamps-view Slides at trinodb.github.io/presentations/presentations/moving-supplies/index.html 0:00 Introduction 2:53 Moving supplies 4:14 What is a lakehouse 7:35 Components of a lakehouse 19:08 Metastore 25:13 Catalog concepts? 29:58 Table for...
Trino contributor Call 2024-10-24
มุมมอง 14728 วันที่ผ่านมา
Details at github.com/trinodb/trino/wiki/Contributor-meetings#trino-contributor-call-24-oct-2024 0:00 Introduction 0:30 Trino Summit 2024 1:57 Contribution process doc update 3:12 Issues clean up 4:18 Accumulo connector removal, Kinesis connector 6:50 Java 23 and JDBC driver 10:15 k8s operator meeting 11:05 HTTP/2 12:10 Views, Iceberg views, Coral, different query engines, Substrait and more 30...
Trino Gateway: Because one Trino cluster is not enough
มุมมอง 476หลายเดือนก่อน
Presented by Will Morrison and Manfred Moser at Open Source Data Summit in October 2024. Slides available at trinodb.github.io/trino-gateway/assets/misc/trino-gateway-at-osds-2024.pdf More information at trinodb.github.io/trino-gateway/
Trino Contributor Call 2024-09-26
มุมมอง 256หลายเดือนก่อน
More details in github.com/trinodb/trino/wiki/Contributor-meetings
Trino Contributor Call 2024-08-22
มุมมอง 1063 หลายเดือนก่อน
- 0:00 Introduction and trino-js-client update - 2:15 Work on Preview Web UI in Trino - 16:25 Trino Gateway 10 and related updates - 18:44 Reviews, contributor learning, path to maintainership, issue and PR backlog, and more - 37:39 Details for upcoming switch for file system support (disable legacy) - 39:47 Slack, matrix, community chat and community knowledge More details at github.com/trinod...
Trino Contributor Call 2024-07-25
มุมมอง 1373 หลายเดือนก่อน
More details at github.com/trinodb/trino/wiki/Contributor-meetings#trino-contributor-call-25-jul-2024 0:00 Opening and misc shorter items 3:08 Legacy filesystem deprecation 5:20 Lateral column aliasing 15:07 Scheduling driver for workers 20:20 Query rewriting and changes 43:34 AI trained expert system for Trino
Trino Contributor Call 2024-06-27
มุมมอง 1924 หลายเดือนก่อน
Meeting notes at github.com/trinodb/trino/wiki/Contributor-meetings#trino-contributor-call-27-jun-2024 - 0:00 Intro with Trino Fest and Trino Contributor Congregation recap - 2:17 Project Swift - 6:07 pip install trino-server and related packaging - 17:21 Discussion around github.com/trinodb/trino/pull/22099 - 24:05 Trino connector
How FourKites runs a scalable and cost-effective log analytics solution to handle petabytes of logs
มุมมอง 2065 หลายเดือนก่อน
How FourKites runs a scalable and cost-effective log analytics solution to handle petabytes of logs
The open source journey of the Trino Delta Lake Connector
มุมมอง 1905 หลายเดือนก่อน
The open source journey of the Trino Delta Lake Connector
Bridging the divide: running Trino SQL on a vector data lake powered by Lance
มุมมอง 3695 หลายเดือนก่อน
Bridging the divide: running Trino SQL on a vector data lake powered by Lance
Trino Fest 2024 Keynote - What’s new in Trino this summer
มุมมอง 5115 หลายเดือนก่อน
Trino Fest 2024 Keynote - What’s new in Trino this summer
Best practices and insights when migrating to Apache Iceberg for data engineers
มุมมอง 1.2K5 หลายเดือนก่อน
Best practices and insights when migrating to Apache Iceberg for data engineers
Accelerate performance at scale: Best practices for Trino with Amazon S3
มุมมอง 8575 หลายเดือนก่อน
Accelerate performance at scale: Best practices for Trino with Amazon S3
Tiny Trino; new perspectives in small data
มุมมอง 2115 หลายเดือนก่อน
Tiny Trino; new perspectives in small data
Enhancing Trino's query performance and data management with Hudi: innovations and future
มุมมอง 2665 หลายเดือนก่อน
Enhancing Trino's query performance and data management with Hudi: innovations and future
Trino query intelligence: insights, recommendations, and predictions
มุมมอง 4065 หลายเดือนก่อน
Trino query intelligence: insights, recommendations, and predictions
Enhancing data governance in Trino with the OpenLineage integration
มุมมอง 5415 หลายเดือนก่อน
Enhancing data governance in Trino with the OpenLineage integration
Reducing query cost and query runtimes of Trino powered analytics platforms
มุมมอง 5725 หลายเดือนก่อน
Reducing query cost and query runtimes of Trino powered analytics platforms
Powering Bazaar's business operations with Trino - Bazaar at Trino Summit 2023
มุมมอง 42411 หลายเดือนก่อน
Powering Bazaar's business operations with Trino - Bazaar at Trino Summit 2023
Visualizing Trino with Superset - Preset at Trino Summit 2023
มุมมอง 1.3K11 หลายเดือนก่อน
Visualizing Trino with Superset - Preset at Trino Summit 2023
Keynote - The mountains Trino climbed in 2023 - Trino Summit 2023
มุมมอง 43711 หลายเดือนก่อน
Keynote - The mountains Trino climbed in 2023 - Trino Summit 2023
Trino workload management - Airbnb at Trino Summit 2023
มุมมอง 91711 หลายเดือนก่อน
Trino workload management - Airbnb at Trino Summit 2023
Secure exchange SQL - Treasure Data at Trino Summit 2023
มุมมอง 20411 หลายเดือนก่อน
Secure exchange SQL - Treasure Data at Trino Summit 2023
Efficient Kappa architecture with Trino - SK Telecom at Trino Summit 2023
มุมมอง 44411 หลายเดือนก่อน
Efficient Kappa architecture with Trino - SK Telecom at Trino Summit 2023
Trino upgrades at exabytes scale - LinkedIn at Trino Summit 2023
มุมมอง 25511 หลายเดือนก่อน
Trino upgrades at exabytes scale - LinkedIn at Trino Summit 2023
Hi , I am purely SQL database administrator, is it easy for me to learn the trino or else any other technologies need to add for this in order to learn the trino?
where to add these properties in kubernetes helm file? because i'm not able to run create function, getting error of access denied using admin user.
🚀 Thanks 🙏 for taking in account merge column issue
great presentation! inspired me a lot. thanks!
Well presented talk
Trino has a very cute mascot. On par with Bun
Save time click here 14:30
Thank you for mentioning Mitzu Vincenzo!
Maaan what was this 14min pre talk - is it about you or about your guest ?
Where is the GitHub repo link for the example
one suggestion for you you should need make one playlist how it work it seems very good
I'm new to this! Very helpful starter pack, much appreciated
Nice work here. Great solve for a challenging problem.
Great Presentation. Do you also mind creating a presentation on how OPA setup is one in your infrastructure?
Great presentation Tingting and Jinyang!
What about 2-tier caching, MEM+SSD? Is this still possible with the new caching code?
非常渴求于学长的联系方式!!!
How do I query on data prent in an excel, is some function readily available like openrowset for MyS
Just wondering. How do i use properties with EKS? I mean, where do i need to set my postgress config? thanks
You configure it all with the Trino Helm chart and the YAML file for your specific cluster and deployment
I think this recording lacks clarity on connector part.
Hmmm. But may be such great difference between json+gzip vs iceberg+parquet is not point of the iceberg. Binary parquet (with metadata in it) vs text json...
Great Talk! I have done tutorials, will keep learning Fugue, esp the datawarehouse docs,
WOW
Great talk but this should have been a 4K video, the text is hard to read.
Looking forward to the PR merge!
use malloy to avoid sql
Great talk from Seth Rogen
Promo-SM 🌺
Did PuppyGraph storage could be a s3 or trino throught an apache iceberg connector
Yes.
This is going to be something amazing that I'm really looking forward to testing and using :D - awesome presentation! Thanks, guys!
Whoa, this was awesome, guys! Loved how you showed off Hudi's multi-modal indexing. But first, I've got to upgrade my current Hudi 0.10.1 lakehouse setup. After that, I'm super excited to try this out with Trino. Really looking forward to it. Great stuff! Thanks!
Awesome content guys! Just managed to enable querying my partitioned data on S3 thanks to this! :)
Is there any connector for querying Vertica Analytics DB or at least generic JDBC connector? Thank you.
Is there a way to configure auditing using elasticsearch or solr when deploying Trino using this helm chart?
🎉
thanks a lot , where can I get Trino set up videos?
Rather than considering writing your own task scheduler/runner, consider using the open-source HPC tools out there.. Slurm with auto-scaling is an absolute beast, as it was designed, and is used, to schedule millions of jobs daily for thousands of users against extremely busy/constrained super-computers around the world (over 60% of the supercomputers use it) - job runtimes ranging from sub-second to months. And you benefit from a massive set of other features such as user/team management, quotas, accounting/budgeting, flexible scheduler resources/constraints..
I have a question about difference between physical Input size and Input size in explain plan generated from Trino.
20:32 Is PuppyGraph Storage a graph database?
No, it is more like a data warehouse.
Wasn't Manfred on "Sprockets" on Saturday Night Live?
Nice
1080p please?
Can AirByte communicate with SMB or NFS? Or just simply connect to a window ec2 and get data from it moving to S3, Redshift. Thanks
I want a remake as Trino being pokemon evolution of presto
It would be like Magikarp evolving into Gyrados.
What the.... f.... .... 🐰
The PoochFitness example is very helpful for understand the motivation.
wonderful talk, benefit a lot.
Can airbyte do some form of transformation/aggregation as part T of ETL ? Because I just see 100s of demos of Source-to-Sink - but not enough on Transformation.
Airbyte is mainly focused on EL. T is left to tools like Trino and dbt.
Nice demo. Do you think it is possible to have a read only cluster pointing to alluxio as there is another write cluster pointing to minIO?
Trino is much faster than Hive or Spark on read queries.