JDBC Driver for Trino
Overview
Trino is a tool designed to efficiently query vast amounts of data using distributed queries. If you work with terabytes or petabytes of data. Trino was designed as an alternative to tools that query HDFS using pipelines of MapReduce jobs, such as Hive or Pig, but Trino is not limited to accessing HDFS. Trino can be and has been extended to operate over different kinds of data sources, including traditional relational databases and other data sources such as Cassandra.
Trino was designed to handle data warehousing and analytics: data analysis, aggregating large amounts of data and producing reports. These workloads are often classified as Online Analytical Processing (OLAP).
More details
Release Notes
- Add support for the CORRESPONDING clause in set operations.
- Add support for the AUTO grouping set that includes all non-aggregated columns in the SELECT clause.
- Publish additional metrics for input tables in event listener.
- Expose dynamic filter statistics in the QueryCompletedEvent.
- Improve scalability of inline data encoding in the spooling client protocol.
- Improve performance of queries involving the exclude_columns table function.
- Disallow dropping the system catalog.
- Fix occasional query failures when adaptive planning is enabled.
- Fix incorrect results when using window functions with DISTINCT.
- Fix query failures with EXCEEDED_LOCAL_MEMORY_LIMIT errors due to incorrect memory accounting.
- Properly handle inline session properties for EXPLAIN queries.
Compatibility
- Trino
- Collibra Data Intelligence Cloud
- Collibra Data Intelligence On-Prem
Dependency
- N/A