Support Questions

Find answers, ask questions, and share your expertise

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

Expert Contributor

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

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

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.