Danila Maksimenko
05/05/2023, 6:54 PM<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:<postgresql://postgres:5432/metastore></value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>org.postgresql.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
</property>
<property>
<name>hive.metastore.schema.verification</name>
<value>true</value>
</property>
<property>
<name>metastore.thrift.port</name>
<value>9083</value>
</property>
<property>
<name>aws.region</name>
<value>us-west-2</value>
</property>
<property>
<name>metastore.task.threads.always</name>
<!-- <value>org.apache.hadoop.hive.metastore.events.EventCleanerTask,org.apache.hadoop.hive.metastore.MaterializationsCacheCleanerTask</value>-->
<value>org.apache.hadoop.hive.metastore.events.EventCleanerTask</value>
</property>
<property>
<name>metastore.expression.proxy</name>
<value>org.apache.hadoop.hive.metastore.DefaultPartitionExpressionProxy</value>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value><s3://tenant1/tenant1/data/></value>
</property>
<property>
<name>fs.s3a.access.key</name>
<value>sql-demo</value>
</property>
<property>
<name>fs.s3a.secret.key</name>
<value>demo-sql</value>
</property>
<property>
<name>fs.s3a.connection.ssl.enabled</name>
<value>true</value>
</property>
<property>
<name>fs.s3a.path.style.access</name>
<value>true</value>
</property>
<property>
<name>fs.s3.access.key</name>
<value>sql-demo</value>
</property>
<property>
<name>fs.s3.secret.key</name>
<value>demo-sql</value>
</property>
<property>
<name>fs.s3.connection.ssl.enabled</name>
<value>true</value>
</property>
<property>
<name>fs.s3.path.style.access</name>
<value>true</value>
</property>
<property>
<name>s3.access.key</name>
<value>sql-demo</value>
</property>
<property>
<name>s3.secret.key</name>
<value>demo-sql</value>
</property>
<property>
<name>s3.connection.ssl.enabled</name>
<value>true</value>
</property>
<property>
<name>s3.path.style.access</name>
<value>true</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value><thrift://localhost:9083></value>
</property>
<property>
<name>hive.metastore.client.factory.class</name>
<value>com.amazonaws.glue.catalog.metastore.AWSGlueDataCatalogHiveClientFactory</value>
</property>
<property>
<name>fs.s3a.impl</name>
<value>org.apache.hadoop.fs.s3a.S3AFileSystem</value>
</property>
</configuration>