Support Questions
Find answers, ask questions, and share your expertise

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

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

Accepted Solutions

Cloudera Employee

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

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

4 REPLIES 4

Contributor

Hello @rahuledavalath,

What HDP version and what CDP version are you using?

 

Regards,

Will

Cloudera Employee

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

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

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