Hive ALTER TABLE Statement ParseException: "cannot recognize input near 'MODIFY'"

The error message 'ParseException line 1:25 cannot recognize input near 'MODIFY' 'split_total_amount' 'FLOAT' in alter table statement' suggests a syntax error within the ALTER TABLE statement at line 1, position 25. The Hive parser is unable to recognize the input around the keywords 'MODIFY', 'split_total_amount', and 'FLOAT'.\n\nTo resolve this issue, review the syntax of your ALTER TABLE statement. Ensure you are using the correct syntax for modifying a column in Hive. \n\nThe proper syntax for modifying a column in Hive is: \n\nsql\nALTER TABLE table_name CHANGE column_name column_name data_type;\n\n\nIn your case, it appears you are attempting to modify the column named 'split_total_amount' to have a data type of 'FLOAT'. Therefore, your ALTER TABLE statement should resemble this: \n\nsql\nALTER TABLE table_name CHANGE split_total_amount split_total_amount FLOAT;\n\n\nRemember to replace 'table_name' with the actual name of your table. \n\nIf the error persists, double-check the table name, column name, and data type for any typos or mistakes. '}