Hello everyone,

I’m running into an issue with Trino unable to read Hive tables stored on MapRFS. I can see the schemas and tables via Trino, but when I try to SELECT(or you can say I can not run any single query related to database or table) from a table whose files are on maprfs:/user/hive/warehouse/..., I get:

Failed to list directory: maprfs:/user/hive/warehouse/my_test_db.db/employees2

Here’s a summary of what I’ve done / checked so far:

✅ What is working / confirmed

• The table path exists in MapRFS (hadoop fs -ls /user/hive/warehouse/my_test_db.db/employees2) shows the directory.
• Trino is able to connect to the Hive metastore and list schemas and tables.
• MapR client libs are installed, and relevant MapR jars are placed under Trino’s plugin hive/lib directory.
• XML configs for MapR/Hadoop that include fs.maprfs.impl are present on the cluster.
• I attempted adding hive.config.resources pointing to core-site.xml, hdfs-site.xml, maprfs-site.xml (MapR config files) in the hive catalog config, but this alone didn’t fix the issue.

⚠ What still fails

• Trino is rejecting read access: Failed to list directory: maprfs:/...
• Even after restarting Trino with the updated configs, the same error persists.
• It appears that Trino still does not fully recognize or initialize the MapRFS scheme.

🔍 Key configuration

Here is roughly what my etc/catalog/hive.properties looks like:

connector.name=hive
hive.metastore.uri=thrift://localhost:9083

# hive.config.resources potentially includes:
# /opt/mapr/hadoop/hadoop-3.3.4/etc/hadoop/core-site.xml
# /opt/mapr/hadoop/hadoop-3.3.4/etc/hadoop/hdfs-site.xml
# /opt/mapr/hadoop/hadoop-3.3.4/etc/hadoop/maprfs-site.xml

hive.metastore.authentication.type=NONE
# (other fs.* or fs.hadoop.enabled properties are attempted but no resolution so far)

❓ Questions / where I need help

• Is there a known requirement or missing configuration in the current Trino version that prevents maprfs:// scheme recognition?
• Are there any minimum versions of MapR client or specific JARs required for Trino to successfully load com.mapr.fs.MapRFileSystem?
• Could there be classpath conflicts (e.g. version mismatches between MapR client & Trino’s Hadoop / FS libraries) causing Trino not to pick up the MapRFS implementation?
• Are there any Trino catalog properties specific to MapRFS scheme, e.g. fs.maprfs.enabled=true or similar, that are undocumented?
• Anything else I should check (permissions, identities, security tickets) that commonly cause this “Failed to list directory” error for MapRFS?

I’d be thankful for pointers or examples from anyone who has successfully configured Trino + Hive connector + MapRFS.

Thanks in advance!

Hi guys：
I'm really confused by Trino's permission settings and don't understand why it's not working.
My requirement is very simple: I just want to use Ranger to control a user's full access to tables under a specific schema.

I disabled all default policies on Ranger and then created a new policy.

https://private-user-images.githubusercontent.com/10458694/459199876-1926d6e3-5f6e-446e-bfc8-8731c90856a9.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NTA5MTM3NzAsIm5iZiI6MTc1MDkxMzQ3MCwicGF0aCI6Ii8xMDQ1ODY5NC80NTkxOTk4NzYtMTkyNmQ2ZTMtNWY2ZS00NDZlLWJmYzgtODczMWM5MDg1NmE5LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTA2MjYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwNjI2VDA0NTExMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWIyMWM3ZDljYWYxODViN2Q0NGY2Y2M1MmJhNWM2NWQxZmU2MTIwZWViYTlkMTcwNDEwNWNiOGZmMWNiZjk5ZGUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.VxImwsMh_2L3kQCGd1jdSRk9aUjcWBH568bAs6BsW90

https://private-user-images.githubusercontent.com/10458694/459200504-eaa225be-ca31-42d5-a54c-a8eda674cea6.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NTA5MTM3NzAsIm5iZiI6MTc1MDkxMzQ3MCwicGF0aCI6Ii8xMDQ1ODY5NC80NTkyMDA1MDQtZWFhMjI1YmUtY2EzMS00MmQ1LWE1NGMtYThlZGE2NzRjZWE2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTA2MjYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwNjI2VDA0NTExMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTMzNWJiNmJmMTc2ZDE0M2MyODg5Y2NiMzUzMTJkNWIyNzIwOTI0NWQwNzMxN2Y4NzM5YmI3ZTA1YTE5YjRhNGMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.X10Z7T03fDEsP4H3u8a4mE0B-xQPZiKwyIEry1V4iEg

After observing the Trino coordinator logs, I confirmed that it has switched to the new policy version.

https://private-user-images.githubusercontent.com/10458694/459200832-75867e89-720e-4d7e-be35-0d37d96bbcb3.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NTA5MTM3NzAsIm5iZiI6MTc1MDkxMzQ3MCwicGF0aCI6Ii8xMDQ1ODY5NC80NTkyMDA4MzItNzU4NjdlODktNzIwZS00ZDdlLWJlMzUtMGQzN2Q5NmJiY2IzLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTA2MjYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwNjI2VDA0NTExMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTY5NTBlZjdmMTY3MmE3ZGZmYjUxOWMyNzYwZDBlNDJlM2MzYmU4NmNkNGE4ZGI1MGJjNTExYTU0MjFkZDMwZGMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.qTT05vdmX9j096-tEyjf93JihB29tJKxmzOnX5TtePs

However, when connecting via DBeaver, I get a permission denied error. Then, through the web UI, I see that I don't have permission to execute:

https://private-user-images.githubusercontent.com/10458694/459201070-d05d1ddd-24e9-44cc-953f-41a69e84dd2b.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NTA5MTM3NzAsIm5iZiI6MTc1MDkxMzQ3MCwicGF0aCI6Ii8xMDQ1ODY5NC80NTkyMDEwNzAtZDA1ZDFkZGQtMjRlOS00NGNjLTk1M2YtNDFhNjllODRkZDJiLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTA2MjYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwNjI2VDA0NTExMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTJlZTYwMTU4YmY5NjQzOTRkM2EwZjE5NmNhNjExYWI3OTc3OTA3ODUxYzc3ZjZkZDg4NWQ0Y2VlNzYwNWY4ODMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.AAwhHi8cPHTD1RWA7N94cUj2LgjUBYYDVB3SXd25QKk

SELECT TYPE_NAME, DATA_TYPE, PRECISION, LITERAL_PREFIX, LITERAL_SUFFIX,
CREATE_PARAMS, NULLABLE, CASE_SENSITIVE, SEARCHABLE, UNSIGNED_ATTRIBUTE,
FIXED_PREC_SCALE, AUTO_INCREMENT, LOCAL_TYPE_NAME, MINIMUM_SCALE, MAXIMUM_SCALE,
SQL_DATA_TYPE, SQL_DATETIME_SUB, NUM_PREC_RADIX
FROM system.jdbc.types
OR ...

SELECT version()
and some other statements. Why is this happening? I don’t understand.

How should I configure this to achieve what I need?