string to smallint hive code example

Example: string to smallint hive

ALTER TABLE table_name CHANGE old_column_name new_column_name new_data_type