Support ALTER for Hive tables

Why it matters

This feature enables users to modify the schema of Hive tables directly within ClickHouse using the ALTER statement. It solves the problem of lack of schema management capabilities for Hive tables and improves usability by allowing seamless schema changes without migrating data.

How to use it

Users can perform ALTER statements on Hive tables as they would on other ClickHouse tables. Simply use the ALTER TABLE syntax targeting a Hive table, for example:

ALTER TABLE hive_table_name
MODIFY COLUMN column_name String