Need help on steps to copy Phoenix table from HDP 2.6 to HDP 3.1

[Sam Glover <sa...@cloudera.com>]

Hi Phoenix users group,

We need help on steps to copy Phoenix table from HDP 2.6 to HDP 3.1

All replies appreciated.
-- 

*Sam Glover* | Solutions Architect
t. (512) 550-5363
cloudera.com <https://www.cloudera.com>
[image: Cloudera] <https://www.cloudera.com/>
[image: Cloudera on Twitter] <https://twitter.com/cloudera> [image:
Cloudera on Facebook] <https://www.facebook.com/cloudera> [image: Cloudera
on LinkedIn] <https://www.linkedin.com/company/cloudera>
<https://www.cloudera.com/>
------------------------------

Re: Need help on steps to copy Phoenix table from HDP 2.6 to HDP 3.1

[Josh Elser <el...@apache.org>]

I reached out to Sam in private since he's dealing non-Apache releases.

His solution was to bulk load files from the old version of Phoenix to 
the new (HDP 2.6 to 3.1, respectively), but when he ran a query in the 
new system, he did not see the records despite them being there in HBase.

The problem was that the column encoding feature was introduced between 
these two versions, so the data was not in the correct column families 
for the newer version of Phoenix. Following his same process, but 
creating the table with COLUMN_ENCODED_BYTES=0, resulted in the data 
being visible from Phoenix queries.

On 9/11/19 9:14 AM, Sam Glover wrote:
> Hi Phoenix users group,
> 
> We need help on steps to copy Phoenix table from HDP 2.6 to HDP 3.1
> 
> All replies appreciated.
> -- 
> 
> *Sam Glover* | Solutions Architect
> t. (512) 550-5363
> cloudera.com <https://www.cloudera.com>
> 
> Cloudera <https://www.cloudera.com/>
> 
> 	
> Cloudera on Twitter <https://twitter.com/cloudera>	Cloudera on Facebook 
> <https://www.facebook.com/cloudera>	Cloudera on LinkedIn 
> <https://www.linkedin.com/company/cloudera>
> 
> <https://www.cloudera.com/>
> ------------------------------------------------------------------------
> 
> 
> 
>