HIVE SSL mTLS capability

[alexio215]

Description

Add HIVE provider capability to use SSL and perform mTLS handshake with connecting host

Use case/motivation

Airflow runs in a different network from HIVE due to policy and company support.
Require mTLS encrypted connection between the two instances to securely run HIVE jobs remotely.

Related issues

None that I am aware of

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

[alexio215]

Hello, thank you for having me. It is my first time contributing to any open source project, so please bear with me.

Happy to learn from any wisdom shared

[alexio215]

My current inclination in solving this problem is to use jpype to funnel python requests through a JVM running the JDBC Driver adjacent to Airflow.

The goal with this is to use the Python natively to write HIVE DAGs but communicate in Java which is more native to HIVE and supports the JKS key format, which is the default to HIVE

[alexio215]

On pause for now and considering ramifications of this in my environment