Trino

Distributed SQL query engine for big data, formerly known as PrestoSQL

[Trino @trinodb]

We’re rebranding PrestoSQL as Trino. We’re not going anywhere - it’s the same software, by the same people, just under a new name.

Read about why we’re doing it: https://t.co/4sDAU39t8g

#presto #prestosql #prestodb #trino

[Trino @trinodb]

Trino 420 is released! In this version:

* Underscores in numeric literals
* Hexadecimal, binary and octal numeric literals
* Comments on view columns in @DeltaLakeOSS
* RENAME COLUMN in @MongoDB
* Mixed case table names in @druidio

See the full list: https://t.co/J9HJETxMkM

[Trino @trinodb]

Trino 419 is released! In this version:

* New array_histogram function
* Faster reading and writing of Parquet data
* Support for Nessie catalog in #ApacheIceberg connector

See the full list: https://t.co/NrhKeX3507

#trino

[Trino @trinodb]

Trino 418 is released! In this version:

* Support for EXECUTE IMMEDIATE
* table_changes function in @DeltaLakeOSS
* Faster joins in Delta Lake, @ApacheHive, @apachehudi and #ApacheIceberg
* Fault tolerant execution in Oracle connector

Full list: https://t.co/4eWHzo53Ec

[Trino @trinodb]

Trino 417 is released! In this version:

* Faster UNION ALL queries
* Faster processing of Parquet data in @apachehudi, #ApacheIceberg, @ApacheHive, and @DeltaLakeOSS connectors
* Faster reads of nested row fields in Delta Lake

See the full list: https://t.co/xic5ttxV5L

[Trino @trinodb]

Trino 414 is released! In this version:

* Experimental support for tracing with @opentelemetry
* Support for Databricks 12.2 LTS in @DeltaLakeOSS
* Support for fault-tolerant execution in Redshift
* "sequence" table function

See the full list: https://t.co/yMwiSdFLng

#trino

[Trino @trinodb]

Trino 413 is released! In this version:

* Support for MERGE in @ApachePhoenix connector
* Support for table comments in Oracle connector
* Improved performance of queries involving window functions or MATCH_RECOGNIZE

See the full list: https://t.co/jyaJG3KquP

#trino

[Trino @trinodb]

Learn from @trinodb Contributor and @starburstdata engineer, @findinpath, about how to optimize data lakehouse performance with #ApacheIceberg's hidden partitioning.

Trino with Iceberg is the fix for data swamps.

#dataengineering #datalakehouse

[findinpath @findinpath]

Date predicates pushdown for @ApacheIceberg in @trinodb https://t.co/mSefqNT3Vp

[Trino @trinodb]

Trino 412 is released! In this version:

* New "exclude_columns" table function
* Support for ADD COLUMN in @ApacheIgnite
* Support for table comments in @PostgreSQL
* Faster sum(DISTINCT ...) queries

See the full list: https://t.co/PIUK2p4DJB

#trino

[Trino @trinodb]

Trino 411 is released! In this version:

* Procedure to convert an @ApacheHive table to #ApacheIceberg
* Join and LIKE pushdown in @ApacheIgnite
* DELETE in Ignite
* Table function for executing stored procedures in @SQLServer

See the full list: https://t.co/gMk2DyZ5b1

[Trino @trinodb]

Trino 409 is released! In this version:

* Nested field support in DROP COLUMN
* Support sorted tables in #ApacheIceberg
* Support TIME type in #ApacheCassandra
* Faster aggregations with DISTINCT
* Faster LIKE with dynamic patterns

See the full list: https://t.co/EmrAsUaOkN

[Trino @trinodb]

Trino 408 is released! In this version:

* New @ApacheIgnite connector
* Support for writing decimal types to #BigQuery
* Improved performance when reading structural types from Parquet files in @DeltaLakeOSS

See the full list: https://t.co/uaYiTb2YWX

#trino

[Trino @trinodb]

Trino 407 is released! In this version:

* Pass-through queries in #ApacheCassandra
* unregister_table procedure in @DeltaLakeOSS/#ApacheIceberg
* Writes to change data feed in Delta Lake
* Faster querying of Parquet data

See the full list: https://t.co/bm9Le6XTLw

[Trino @trinodb]

Trino 406 is released! In this version:

* Support for JDBC catalog in #ApacheIceberg
* Fault-tolerant execution for #BigQuery
* Exchange spooling on HDFS
* Faster Parquet in @DeltaLakeOSS, @ApacheHive, @apachehudi and Iceberg

See the full list: https://t.co/6I396JXeW7

#trino

[Trino @trinodb]

Trino is central to many talks of the #datarebels at Datanova from @starburstdata . Join us for the free virtual event in February.
https://t.co/r6xptdArBy

[Trino @trinodb]

#TrinoDB #GitHub repo just hit 7k 🌟s today!

Federated querying is the future!

Check it out: https://t.co/z2PP2QStY8

#dataengineering #opensource #sql

[Trino @trinodb]

2022 was another incredible year for the #TrinoCommunity. We take stock of everything going on in the community and summarize all the features contributed!

2022 was an amazing year for #trinodb, but 2023 is the #YearOfTheRabbit!

#dataengineering

https://t.co/4MBW53mug0

[Trino @trinodb]

Ever wondered how an open source project manages code contributions coming in from so many places? See our latest blog on how we've cleaned up the Trino pull request backlog, making the project a better place to contribute.

https://t.co/2Fc7Mgwx26

#opensource #dataengineering

[Trino @trinodb]

Release 404 NOT FOUND

https://t.co/8M7L3UKHFR

https://t.co/WVsrYg9EIw

[Trino @trinodb]

Trino 405 is released! In this version:

* Faster reading of Parquet data
* Support for #ApacheIceberg REST catalog
* DELETE and query pushdown in Redshift
* Support for @ApacheArrow when reading from BigQuery
* Views in @DeltaLakeOSS

See the full list: https://t.co/vHLP10GEVj

[Trino @trinodb]

@bitsondatadev walks you through setting up @Alluxio. over a @Minio store. He then points #TrinoDB to Alluxio using the @ApacheIceberg table format. Watch if you want caching on your #datalakehouse!

https://t.co/pZA0FRgWhZ

#dataengineering #opensource #prestodb