question Re: Cloning Phoenix Hbase table snapshot from a HDP cluster to CDP Cluster not working properly in Support Questions

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

rahuledavalath — Thu, 30 Sep 2021 08:03:58 GMT

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

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

willx — Fri, 01 Oct 2021 14:01:50 GMT

Hello @rahuledavalath,

What HDP version and what CDP version are you using?

Regards,

Will

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

9een — Wed, 13 Oct 2021 17:06:50 GMT

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/323933

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

Regards,

Naveen S

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

smdas — Thu, 21 Oct 2021 07:01:31 GMT

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/323933

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

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

smdas — Sat, 23 Oct 2021 15:04:55 GMT

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

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

bavisetti — Mon, 10 Apr 2023 15:22:47 GMT

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

Thanks,

Jyothsna