We can change the column data type by using ALTER and CHANGE as follows:
ALTER TABLE table_name CHANGE column_namecolumn_namenew_datatype;
For example, if we want to change the data type of the salary column from integer to bigint in the employee table, we can use the following:
ALTER TABLE employee CHANGE salary salary BIGINT;
RLIKE: Its full form is Right-Like and it is a special function in Hive. It helps examine two substrings, i.e., if the substring of A matches with B, then it evaluates to true.
Example:
‘Intellipaat’ RLIKE ‘tell’  True
‘Intellipaat’ RLIKE ‘^I.*’  True (this is a regular expression)