[ADAP-799] [Feature] Investigate removing dependency on PyHive

[colin-rogers-dbt]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-spark functionality, rather than a Big Idea better suited to a discussion

Describe the feature

PyHive is in KTLO mode and is not well supported. We should investigate if we still need this dependency or if we can replace it with something else. If we truly need this dependency we may need to look into forking and maintaining ourselves.

Currently PyHive is blocking support for py3.11 simply because we need them to publish a release.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[colin-rogers-dbt]

@JCZuurmond - This is a more future oriented idea than #864

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.