The datalinks in Hive is created with string datatypes for all numeric fields. Since I have to get the aggregation of all those fields. Changing one by one is time consuming. Is there a way to select multiple fields and change all of them from one datatype to another. I am doing import job and changing even then it take a min of 20sec to max of 40 sec per columns. I have nearly 400 fields which require data type changes.
Appreciate your help
Please sign in to leave a comment.