289:
27:
36:
376:
architecture. Trino first distributes work over multiple workers by running ad-hoc partitioning operations or relying on existing partitions in the data of the underlying data store. Once this data has reached the worker, the data is processed over pipelined operators carried out on multiple threads.
250:
of the Presto project. They initially kept the name Presto and used the PrestoSQL web handle to distinguish it from the original PrestoDB project. Simultaneously, they announced the Presto
Software Foundation. The foundation is a not-for-profit organization dedicated to the advancement of the Presto
276:
Trino is used in many data platforms and products from cloud providers and other vendors. Customization of these products varies from pure Trino usage to heavily customized systems to run a data platform or integration in specialized data platforms for usage with specific data.
319:
The workers are responsible for executing the tasks and operators fed to them by the scheduler. These tasks process rows from the data sources which produce results that are returned to the coordinator and ultimately back to the
254:
In
December 2020, PrestoSQL was rebranded as Trino. The Trino Software Foundation, code base, and all other PrestoSQL assets were renamed as part of the rebrand.
312:
The coordinator is responsible for parsing, analyzing, optimizing, planning, and scheduling a query submitted by a client. The coordinator interacts with the
577:
203:
269:. Trino shares the first six years of development with the Presto project. To learn more about the earlier history of Trino, you can reference
677:
652:
601:
163:
query engine designed to query large data sets distributed over one or more heterogeneous data sources. Trino can query
206:
table formats. Trino also has the ability to run federated queries that query tables in different data sources such as
772:
747:
722:
514:
112:
811:
270:
168:
316:(SPI) to obtain the available tables, table statistics, and other information needed to carry out its tasks.
183:
56:
297:
247:
73:
313:
738:
Fuller, Matt; Moser, Manfred; Traverso, Martin (2021). "Chapter 2. Installing and
Configuring Trino".
386:
362:
Trino supports the separation of compute and storage and may be deployed both on-premises and in the
243:
821:
396:
257:
Presto and Trino were originally designed and developed by Martin, Dain, David, and Eric Hwang at
195:
826:
370:
191:
171:
156:
763:
Fuller, Matt; Moser, Manfred; Traverso, Martin (2021). "Chapter 13. Real-World
Examples".
8:
627:
713:
Fuller, Matt; Moser, Manfred; Traverso, Martin (2021). "Chapter 4. Trino
Architecture".
555:
505:
Fuller, Matt; Moser, Manfred; Traverso, Martin (2021). "Chapter 1. Introducing Trino".
373:
92:
768:
743:
718:
510:
475:
406:
215:
124:
80:
816:
363:
454:
288:
262:
231:
179:
129:
117:
85:
800:
578:"Presto Software Foundation Launches to Advance Presto Open Source Community"
266:
227:
806:
530:
401:
219:
426:
331:
standard and includes various parts of the following ANSI specifications:
199:
279:
Examples include Amazon Athena, Starburst Galaxy, Dune, and many others.
626:
Traverso, Martin; Sundstrom, Dain; Phillips, David (27 December 2020).
211:
175:
46:
300:. It runs on a cluster of servers that contains two types of nodes, a
187:
164:
602:"Presto's New Foundation Signals Growth for the Big Data SQL Engine"
791:
391:
356:
352:
348:
344:
340:
336:
258:
62:
35:
26:
246:, Martin Traverso, Dain Sundstrom, and David Phillips, created a
223:
792:
Trino
Software Foundation (formerly Presto Software Foundation)
332:
261:
to allow data analysts to run interactive queries on its large
708:
706:
704:
702:
700:
698:
207:
500:
498:
496:
756:
325:
105:
98:
51:
Martin
Traverso, Dain Sundstrom, David Phillips, Eric Hwang
731:
695:
625:
493:
328:
278:
160:
101:
292:
Trino architecture overview with coordinator and workers
762:
737:
712:
504:
470:
468:
141:
798:
465:
449:
447:
767:. O'Reilly Media, Inc, USA. pp. 267–272.
476:"Iceberg connector — Trino 393 Documentation"
444:
742:. O'Reilly Media, Inc, USA. pp. 19–24.
717:. O'Reilly Media, Inc, USA. pp. 43–72.
509:. O'Reilly Media, Inc, USA. pp. 3–17.
182:residing on different storage systems like
455:"Hive connector — Trino 393 Documentation"
251:open source distributed SQL query engine.
242:In January 2019, the original creators of
34:
25:
619:
287:
16:Open-source distributed SQL query engine
594:
799:
570:
531:"Connectors — Trino 393 Documentation"
628:"We're rebranding PrestoSQL as Trino"
427:"Overview — Trino 393 Documentation"
13:
14:
838:
785:
678:"Contributors to prestodb/presto"
670:
653:"Contributors to trinodb/trino"
645:
283:
548:
523:
419:
230:. Trino is released under the
1:
412:
7:
765:Trino: The Definitive Guide
740:Trino: The Definitive Guide
715:Trino: The Definitive Guide
507:Trino: The Definitive Guide
380:
10:
843:
314:service provider interface
271:the Presto history section
237:
387:Presto (SQL query engine)
136:
123:
111:
91:
79:
69:
55:
45:
33:
24:
397:Data Intensive Computing
558:. Trino. 25 August 2022
556:"trinodb/trino LICENSE"
174:data file formats like
293:
371:Distributed computing
324:Trino adheres to the
291:
812:Free system software
296:Trino is written in
192:Google Cloud Storage
40:Trino UI Version 358
21:
294:
196:Azure Blob Storage
47:Original author(s)
19:
150:
149:
834:
779:
778:
760:
754:
753:
735:
729:
728:
710:
693:
692:
690:
688:
674:
668:
667:
665:
663:
649:
643:
642:
640:
638:
623:
617:
616:
614:
613:
598:
592:
591:
589:
588:
574:
568:
567:
565:
563:
552:
546:
545:
543:
541:
527:
521:
520:
502:
491:
490:
488:
486:
472:
463:
462:
451:
442:
441:
439:
437:
423:
407:Computer cluster
146:
143:
81:Operating system
65:
63:Trino Repository
38:
29:
22:
18:
842:
841:
837:
836:
835:
833:
832:
831:
822:Cloud platforms
797:
796:
788:
783:
782:
775:
761:
757:
750:
736:
732:
725:
711:
696:
686:
684:
676:
675:
671:
661:
659:
651:
650:
646:
636:
634:
624:
620:
611:
609:
600:
599:
595:
586:
584:
576:
575:
571:
561:
559:
554:
553:
549:
539:
537:
529:
528:
524:
517:
503:
494:
484:
482:
474:
473:
466:
453:
452:
445:
435:
433:
425:
424:
420:
415:
383:
286:
240:
172:column-oriented
140:
61:
41:
17:
12:
11:
5:
840:
830:
829:
824:
819:
814:
809:
795:
794:
787:
786:External links
784:
781:
780:
773:
755:
748:
730:
723:
694:
669:
644:
618:
593:
569:
547:
522:
515:
492:
464:
443:
417:
416:
414:
411:
410:
409:
404:
399:
394:
389:
382:
379:
322:
321:
317:
285:
282:
263:data warehouse
239:
236:
232:Apache License
148:
147:
138:
134:
133:
130:Apache License
127:
121:
120:
118:Data Warehouse
115:
109:
108:
96:
89:
88:
86:Cross-platform
83:
77:
76:
71:
67:
66:
59:
53:
52:
49:
43:
42:
39:
31:
30:
15:
9:
6:
4:
3:
2:
839:
828:
827:Java platform
825:
823:
820:
818:
815:
813:
810:
808:
805:
804:
802:
793:
790:
789:
776:
774:9781098107710
770:
766:
759:
751:
749:9781098107710
745:
741:
734:
726:
724:9781098107710
720:
716:
709:
707:
705:
703:
701:
699:
683:
679:
673:
658:
654:
648:
633:
629:
622:
607:
606:The New Stack
603:
597:
583:
579:
573:
557:
551:
536:
532:
526:
518:
516:9781098107710
512:
508:
501:
499:
497:
481:
477:
471:
469:
460:
456:
450:
448:
432:
428:
422:
418:
408:
405:
403:
400:
398:
395:
393:
390:
388:
385:
384:
378:
375:
372:
367:
365:
360:
358:
354:
350:
346:
342:
338:
334:
330:
327:
318:
315:
311:
310:
309:
307:
303:
299:
290:
281:
280:
274:
272:
268:
267:Apache Hadoop
264:
260:
255:
252:
249:
245:
235:
233:
229:
228:Elasticsearch
225:
221:
217:
213:
209:
205:
201:
197:
193:
189:
185:
181:
177:
173:
170:
167:that contain
166:
162:
158:
154:
145:
139:
135:
131:
128:
126:
122:
119:
116:
114:
110:
107:
103:
100:
97:
94:
90:
87:
84:
82:
78:
75:
72:
68:
64:
60:
58:
54:
50:
48:
44:
37:
32:
28:
23:
764:
758:
739:
733:
714:
687:20 September
685:. Retrieved
681:
672:
662:20 September
660:. Retrieved
656:
647:
635:. Retrieved
631:
621:
610:. Retrieved
608:. 2019-01-31
605:
596:
585:. Retrieved
581:
572:
560:. Retrieved
550:
538:. Retrieved
534:
525:
506:
483:. Retrieved
479:
458:
434:. Retrieved
430:
421:
402:Apache Drill
369:Trino has a
368:
361:
323:
305:
301:
295:
284:Architecture
275:
256:
253:
241:
159:distributed
152:
151:
637:7 September
302:coordinator
157:open-source
801:Categories
612:2019-02-01
587:2019-02-01
413:References
212:PostgreSQL
198:using the
165:data lakes
70:Written in
57:Repository
562:25 August
540:25 August
485:25 August
436:25 August
216:Cassandra
632:trino.io
535:trino.io
480:trino.io
459:trino.io
431:trino.io
392:Big data
381:See also
357:SQL:2023
353:SQL:2016
349:SQL:2011
345:SQL:2008
341:SQL:2003
337:SQL:1999
259:Facebook
93:Standard
320:client.
238:History
224:MongoDB
204:Iceberg
180:Parquet
137:Website
125:License
817:Hadoop
771:
746:
721:
682:GitHub
657:GitHub
513:
333:SQL-92
306:worker
304:and a
244:Presto
188:AWS S3
155:is an
582:PRWeb
364:cloud
220:Kafka
208:MySQL
194:, or
153:Trino
142:trino
20:Trino
769:ISBN
744:ISBN
719:ISBN
689:2021
664:2021
639:2021
564:2022
542:2022
511:ISBN
487:2022
438:2022
326:ANSI
298:Java
248:fork
226:and
202:and
200:Hive
184:HDFS
169:open
113:Type
106:JDBC
99:ANSI
74:Java
807:SQL
374:MPP
329:SQL
265:in
178:or
176:ORC
161:SQL
144:.io
132:2.0
102:SQL
95:(s)
803::
697:^
680:.
655:.
630:.
604:.
580:.
533:.
495:^
478:.
467:^
457:.
446:^
429:.
366:.
359:.
355:,
351:,
347:,
343:,
339:,
335:,
308:.
273:.
234:.
222:,
218:,
214:,
210:,
190:,
186:,
104:,
777:.
752:.
727:.
691:.
666:.
641:.
615:.
590:.
566:.
544:.
519:.
489:.
461:.
440:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.