here are my metastore and hive-site.xml. ```<?x...
# troubleshooting
d
here are my metastore and hive-site.xml.
Copy code
<?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>