Cloning Phoenix Hbase table snapshot from a HDP cluster to CDP Cluster not working properly

[#1]

I am having a HDP hadoop cluster. I took snapshot of phoenix table from this cluster & I cloned that table to a CDP cluster. Hbase table was created from the snapshot & the hfiles are imported to the table's data directory . While selecting the table from phoenix shell, empty data it is showing. If I do a scan operation from hbase shell data is displaying (encoded). Is there any workaround for this issue. Thanks

[#2 · Accepted solution]

Hi Rahul @rahuledavalath 

you can to refer below link for performing phoenix tables migration from HDP to CDP

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

If the answer helps kindly accept as solution and click thumbs up button.

Regards,

Naveen S

[#3]

Hello @rahuledavalath,

What HDP version and what CDP version are you using?

Regards,

Will

[#4 · Accepted solution]

Hi Rahul @rahuledavalath 

you can to refer below link for performing phoenix tables migration from HDP to CDP

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

If the answer helps kindly accept as solution and click thumbs up button.

Regards,

Naveen S

[#5 · Accepted solution]

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

[#6]

Hello @rahuledavalath 

We are marking the Post as Solved. If your Team have any further concerns, Please update the Post, if your Team face any issues with either of the Recommendation shared [Migrate the System Tables Or Create a Phoenix Table afresh on Top of HBase Table].

Thank You for using Cloudera Community. 

Regards, Smarak

[#7]

Hi @rahuledavalath, when you migrated HDP to CDP, Were you able to ingest data through Phoenix driver to hbase?

Thanks,

Jyothsna