语法对比

prestodb 文档地址：prestodb.io/docs/curren…

trinodb 文档地址：trino.io/docs/curren…

SHOW

	SHOW CATALOGS	SHOW COLUMNS	SHOW CREATE FUNCTION	SHOW CREATE MATERIALIZED VIEW	SHOW CREATE TABLE	SHOW CREATE VIEW	SHOW FUNCTIONS	SHOW GRANTS	SHOW ROLE GRANTS	SHOW ROLES	SHOW SCHEMAS	SHOW SESSION	SHOW STATS	SHOW TABLES
TrinoDB	×	✓	×	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
PrestoDB	✓	✓	✓	×	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓

ALTER

	ALTER FUNCTION	ALTER SCHEMA	ALTER TABLE	ALTER VIEW	ALTER MATERIALIZED VIEW
TrinoDB	×	✓	✓	✓	✓
PrestoDB	✓	✓	✓	×	×

CREATE

	CREATE FUNCTION	CREATE ROLE	CREATE SCHEMA	CREATE TABLE	CREATE TABLE AS	CREATE VIEW	CREATE MATERIALIZED VIEW
TrinoDB	×	✓	✓	✓	✓	✓	✓
PrestoDB	✓	✓	✓	✓	****✓	✓	×

DROP

	DROP FUNCTION	DROP ROLE	DROP SCHEMA	DROP TABLE	DROP VIEW	DEALLOCATE PREPARE
TrinoDB	×	✓	✓	✓	✓	✓
PrestoDB	✓	✓	✓	✓	****✓	×

DELETE & INSERT & MERGE

	DELETE	INSERT	MERGE
TrinoDB	✓	✓	✓
PrestoDB	✓	✓	×

PREPARE + EXECUTE

	PREPARE	EXECUTE	DEALLOCATE PREPARE	DESCRIBE INPUT	DESCRIBE OUTPUT
TrinoDB	✓	✓	✓	✓	✓
PrestoDB	✓	✓	✓	✓	✓

事务

	START TRANSACTION	ROLLBACK	COMMIT
TrinoDB	✓	✓	✓
PrestoDB	✓	✓	✓

其他

	CALL	ANALYZE	EXPLAIN	EXPLAIN ANALYZE	DESCRIBE	GRANT	GRANT ROLES	USE
TrinoDB	✓	✓	✓	✓	✓	✓	✓	✓
PrestoDB	✓	✓	✓	✓	✓	✓	✓	✓

集群功能

	Multi Coordinator	HIVE UDF 支持	查询重试	多级缓存（ALLUXIO）	Presto on Spark	ORC文件类型的查询优化	支持 exchange materialization 减少峰值内存占用	Router	Dynamic filtering
TrinoDB	×	×	✓						✓
PrestoDB	✓	✓	×	✓prestodb.io/blog/2021/0…	✓	支持全部表达式的下推engineering.fb.com/2019/06/10/…	赋能未bucketed的表prestodb.io/blog/2019/0…	✓	✓

社区活跃度

	commit	腾讯	字节	阿里(DLA)	阿里(EMR)	滴滴
TrinoDB	3W+			✓		✓
PrestoDB	2W+	✓	✓		✓

CATALOG

	Accumulo	Atop	BigQuery	Black Hole	Cassandra	ClickHouse	Delta Lake	Druid	Elasticsearch	Google Sheets	Hive	Hudi
TrinoDB	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
PrestoDB	✓	×	✓	✓	✓	✓	✓	✓	✓	×	✓	✓

	Iceberg	JMX	Kafka	Kinesis	Kudu	Lark Sheets	Local File	Memory	MongoDB	MySQL	Oracle	Apache Pinot
TrinoDB	✓	✓	✓	✓	✓	×	✓	✓	✓	✓	✓	✓
PrestoDB	✓	✓	✓	×	✓	✓	✓	✓	✓	✓	✓	✓

	Phoenix	PostgreSQL	Prometheus	Redis	Redshift	SingleStore	SQL Server	System	Thrift	TPCDS	TPCH
TrinoDB	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
PrestoDB	×	✓	✓	✓	✓	×	✓	✓	✓	✓	✓

HIVE

	ALTER TABLE EXECUTE支持合并小文件	非事务表的整分区删除	事务表的行删除	事务表的UPDATE	事务表的MERGE	数据湖catalog重定向	Parquet支持	CSV支持
TrinoDB	✓	✓	✓	✓（ORC）	✓	✓支持重定向到iceberg、datalake的catalog 进行处理	更好一些，配置更多一些	✓
PrestoDB	×	✓	×	×	×			×

MYSQL

TrinoDB	✓
PrestoDB	×

ICEBERG

	TIME TRAVEL QUERIES	ROLLING BACK TO A PREVIOUS SNAPSHOT	INSERT	UPDATE	MERGE	DELETE
TrinoDB	✓	✓	✓	✓	✓	✓
PrestoDB	×	✓	✓	✓

Hudi

	Copy on write table	Merge on read	Metadata tables
TrinoDB	Snapshot queries	Read-optimized queries	✓
PrestoDB	Snapshot queries	Snapshot Queries + Read Optimized Queries