Hello @rahuledavalath 

Thanks for using Cloudera Community. As suggested by @9een, Kindly use the [1] created by @willx for migrating the Tables from HDP to CDP. In short, Your Team migrated the Table yet Phoenix relies on "System" Tables as HBase Tables relies on "HBase:Meta". As such, Your Team needs to either use [1] for Exporting Phoenix "System" Tables Or, follow [2] wherein your Team create a Phoenix Table on top of the Exported HBase Table. Either way, We are ensuring Phoenix "System" Tables are reflecting the Table's Metadata as well. 

Regards, Smarak

[1] https://community.cloudera.com/t5/Community-Articles/Phoenix-tables-migration-from-HDP-to-CDP/ta-p/3...

[2] https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table