Excel comparison by doing file lookup
We are trying to comapre the structure of two same tables in different machines. We can see that the data type in machine1 (hive) is String and coresponding data type in machine2 (Greenplum) is text.However, for some other column the data type in machine1 (hive) is String and coresponding data type in machine2 (Greenplum) is Character varying. So, when we are trying to comapre the data type between machine1 and machine2 it is not matching. We tried replacing the datatype in machine2 as per machine1 datatype but the problem is we can see different dataypes against one datatype in machine1. Eg below:
Machine1(Hive) has datatype as String while Machine2(GP) have corrsponding datatype as Text for one column and Character varying for other column.
We have come up with an approch where we need to create one lookup file which will hold the corresponding datatypes for each datatype of machine1.The machine2's datatype will be compared with the lookup file and if it is not matching then a report will be generated with the mismatch message.
Can anyone please help us to write shell script for this scenario.