Presto

Requires manual creation of JSON files for table metadata, including RowKey formats and ranges, which adds overhead and risk of errors.

CREATE TABLE functionality is listed as 'SUPPORT LATER', meaning users cannot dynamically create tables via SQL, limiting flexibility.

Relies on PrestoSql 315+ and can have conflicts with libraries like Guava, requiring custom fixes and recompilation, as noted in troubleshooting.

Enabling ClientSide scanning involves managing HBase snapshots, dealing with compression codec issues, and periodic cleanup to avoid hitting the 65,536 snapshot limit.