Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Contributor
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 SOLUTIONS

avatar
Expert Contributor

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

View solution in original post

avatar
Super Collaborator

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

 

View solution in original post

5 REPLIES 5

avatar
Master Collaborator

Hello @rahuledavalath,

What HDP version and what CDP version are you using?

 

Regards,

Will

avatar
Expert Contributor

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

avatar
Super Collaborator

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

 

avatar
Super Collaborator

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

avatar
Explorer

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

 

Thanks,

Jyothsna