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

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Sam Glover
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
Cloudera
Cloudera on TwitterCloudera on FacebookCloudera on LinkedIn




Reply | Threaded
Open this post in threaded view
|

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

Josh Elser-2
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/>
> ------------------------------------------------------------------------
>
>
>
>