How can I change default s3 storage class of Hive connector of EMR Trino?

Question

I want to change the default s3 storage class to INTELLIGENT_TIERING of Hive connector of EMR Trino 426 (EMR 6.15.0).
I found the [hive.s3.storage-class option in the Trino 426 official manual](https://trino.io/docs/426/connector/hive-s3.html?highlight=s3+storage+class#s3-configuration-properties) but it doesn't work as below.

```
> 1) Error: Configuration property 'hive.s3.storage-class' was not used

1 error
io.airlift.bootstrap.ApplicationConfigurationException: Configuration errors:

1) Error: Configuration property 'hive.s3.storage-class' was not used

1 error
	at io.airlift.bootstrap.Bootstrap.initialize(Bootstrap.java:232)
	at io.trino.plugin.hive.InternalHiveConnectorFactory.createConnector(InternalHiveConnectorFactory.java:148)
	at io.trino.plugin.hive.InternalHiveConnectorFactory.createConnector(InternalHiveConnectorFactory.java:90)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at io.trino.plugin.hive.HiveConnectorFactory.create(HiveConnectorFactory.java:61)
	at io.trino.connector.DefaultCatalogFactory.createConnector(DefaultCatalogFactory.java:224)
	at io.trino.connector.DefaultCatalogFactory.createCatalog(DefaultCatalogFactory.java:133)
	at io.trino.connector.LazyCatalogFactory.createCatalog(LazyCatalogFactory.java:45)
	at io.trino.connector.StaticCatalogManager.lambda$loadInitialCatalogs$1(StaticCatalogManager.java:157)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:31)
	at java.base/java.util.concurrent.ExecutorCompletionService.submit(ExecutorCompletionService.java:184)
	at io.trino.util.Executors.executeUntilFailure(Executors.java:41)
	at io.trino.connector.StaticCatalogManager.loadInitialCatalogs(StaticCatalogManager.java:151)
	at io.trino.server.Server.doStart(Server.java:144)
	at io.trino.server.Server.lambda$start$0(Server.java:91)
	at io.trino.$gen.Trino_426_amzn_0____20240427_030723_1.run(Unknown Source)
	at io.trino.server.Server.start(Server.java:91)
	at io.trino.server.TrinoServer.main(TrinoServer.java:38)
```

Accepted Answer

Found the anwser by myself. EMR Trino uses EMRFS as its storage backend. It means we have to change the storage class setting of EMRFS.
```
    {
      "Classification": "emrfs-site",
      "Properties": {
        "fs.s3.storageClass": "INTELLIGENT_TIERING"
      }
    }
```

Answer

I found `hive.insert-existing-partitions-behavior=STORAGE_CODE:INTELLIGENT_TIERING` is the solution in claude 3. Is it right?

How can I change default s3 storage class of Hive connector of EMR Trino?

Relevanter Inhalt