Architecturally, at core, both are similiar, they differ in some implementation details. Dremio uses Cache & muti engine while trino/presto does not. Dremio has better UI. Trino is well suited for ad hoc queries.