Unable to query some tables in SQL explorer using EMR studio

Hello,

You can connect to primary instance of EMR cluster and refer to /var/log/presto/server.log presto server log file which provides the actual exception.

Or you can run presto-cli in primary node and run the query which will also give the actual error. Based on the error you can fix the issue.

This seems you are running into an issue when querying specific delta tables which is not compatible with Presto. If your data catalog is created with Glue and accessing delta table using SQL Explorer(presto), then I am not sure if you can achieve this as of today. On the other hand, if your data catalog is hive metastore, then you need to configure the hive/delta connector to read the delta table.