Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Can we partition a phoenix table and overwrite data existing in a single partition?

Highlighted

Can we partition a phoenix table and overwrite data existing in a single partition?

Expert Contributor

Can we partition a phoenix table and overwrite data existing in a single partition?

3 REPLIES 3

Re: Can we partition a phoenix table and overwrite data existing in a single partition?

Expert Contributor

Our requirement is to partition phoenix table by a column and overwriting the records at the partition level from SPARK .

Re: Can we partition a phoenix table and overwrite data existing in a single partition?

Super Collaborator

There is no partitioning in Apache Phoenix. It supports salting:

https://phoenix.apache.org/salted.html

The easiest way to move data is to create a new table with salting and copy your data using upsert select statement

Re: Can we partition a phoenix table and overwrite data existing in a single partition?

Expert Contributor
@Sergey Soldatov

Our requirement is to partition phoenix table by a column and overwriting the records at the partition level from SPARK .

Exact requirement would be like, we will be processing the data at client level, so we will process the data for a single client and wants to overwrite partition corresponding to the client. I don't think SALTED tables can resolve the same as they are like random ordering but not splitting by a particular value.

Don't have an account?
Coming from Hortonworks? Activate your account here