[Housekeeping] [plugins] Remove Hive/Presto

[wild-endeavor]

Describe the issue

Remove Hive & Presto plugins

What if we do not do this?

They will continue to confuse potential contributors.

Related component(s)

flytekit, flyteplugins.

Are you sure this issue hasn't been raised already?

• Yes

Have you read the Code of Conduct?

• Yes

[github-actions]

Hello 👋, This issue has been inactive for over 9 months. To help maintain a clean and focused backlog, we'll be marking this issue as stale and will close the issue if we detect no activity in the next 7 days. Thank you for your contribution and understanding! 🙏

[github-actions]

Hello 👋, This issue has been inactive for over 9 months and hasn't received any updates since it was marked as stale. We'll be closing this issue for now, but if you believe this issue is still relevant, please feel free to reopen it. Thank you for your contribution and understanding! 🙏

[davidmirror-ops]

Is this still a thing? I mean, should we remove the Hive plugin? It's still referenced in multiple places (at least in the docs)