and heres the hive-site.xml ```<?xml version="1...
# troubleshooting
d
and heres the 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>hive.s3.endpoint</name>
        <value><http://minio:9000></value>
    </property>

    <property>
        <name>hive.s3.aws-access-key</name>
        <value>hive</value>
    </property>

    <property>
        <name>hive.s3.aws-secret-key</name>
        <value>hive</value>
    </property>

    <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>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>aws.region</name>
        <value>us-west-2</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.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>
    <property>
       <name>hive.s3.endpoint</name>
        <value><http://minio:9000></value>
    </property>
</configuration>