Got exception: org.apache.hadoop.fs.UnsupportedFileSystemException No FileSystem for scheme "s3"

[AR-X4]

I'm trying to use the hive connector to create a table for parquet data in Wasabi s3. Wasabi is AWS s3 compatible storage. I'm using Trino 443 docker image. When I try to create a table I receive the error 'No FileSystem for scheme "s3"'.

This is my hive.properties file:

connector.name=hive
fs.native-s3.enabled=true
s3.endpoint=https://s3.wasabisys.com
s3.aws-access-key=redacted
s3.aws-secret-key=redacted
s3.region=us-east-1
s3.path-style-access=true
hive.metastore.uri=thrift://host.docker.internal:9083

This is my command:

CREATE TABLE hive.default.test_table (
Company VARCHAR,
Ticker VARCHAR,
FilingDate TIMESTAMP,
PrimaryIndex VARCHAR,
FilingMonth BIGINT,
FilingYear BIGINT,
FiscalQuarter BIGINT,
FiscalYear BIGINT
)
WITH (
format = 'PARQUET',
external_location = 's3://trino-test/data/'
);

[AR-X4]

Seems like the issue might be with the Hive metastore service? Any documentation / additional configuration required for using a metastore service with s3?

2024-04-01T22:18:17.834Z WARN transaction-finishing-0 io.trino.plugin.hive.metastore.SemiTransactionalHiveMetastore Rolling back due to metastore commit failure: Got exception: org.apache.hadoop.fs.UnsupportedFileSystemException No FileSystem for scheme "s3"

Metastore database:

docker run --rm -d --name postgres-metastore -p 5432:5432 -e POSTGRES_PASSWORD=redacted -v $PWD/pg-data:/var/lib/postgresql/data postgres

Metastore server:

docker run --rm -d -p 9083:9083 --env SERVICE_NAME=metastore --env VERBOSE=true --env DB_DRIVER=postgres --env SERVICE_OPTS="-Djavax.jdo.option.ConnectionDriverName=org.postgresql.Driver -Djavax.jdo.option.ConnectionURL=jdbc:postgresql://host.docker.internal:5432/metastore -Djavax.jdo.option.ConnectionUserName=hive -Djavax.jdo.option.ConnectionPassword=redacted" -v $PWD/postgresql-42.7.3.jar:/opt/hive/lib/postgresql-jdbc.jar --name metastore-service apache/hive:4.0.0

Trino:

docker run --rm --name trino -d -p 8080:8080 -v $PWD/catalog:/etc/trino/catalog trinodb/trino:443

[hashhar]

Your HMS seems to missing requires libraries to talk to S3 (or S3-compatible storage). Most likely it's the hadoop-aws JARs.