Support Questions
Find answers, ask questions, and share your expertise

Phoenix table design

I am using Ambari version 2.4.1 with 8 region servers (16 VCPU). Is it ok to have 8*3= 24 buckets for my table? How to upgrade the phoenix to 4.6 where I can create a table and have row timestamp to a Phoenix column? if I create a view on top a table in phoenix, is it going to claim a physical space?

1 ACCEPTED SOLUTION

Accepted Solutions

Mentor

Please read the follo2ing reference:

http://phoenix.apache.org/performance.html#Salting

For optimal performance, number of salt buckets should match number of region servers). You càn upgrade t HdP 2.5.3 with Phoenix 4.7. Any design decision should be followed by testing.

View solution in original post

6 REPLIES 6

Mentor

Please read the follo2ing reference:

http://phoenix.apache.org/performance.html#Salting

For optimal performance, number of salt buckets should match number of region servers). You càn upgrade t HdP 2.5.3 with Phoenix 4.7. Any design decision should be followed by testing.

View solution in original post

If I create a view on top a table in phoenix, is it going to claim a physical space?

Explorer

No it doesn't (except for metadata). Phoenix doesn't materialize the tables (i.e. physically store the data), but only runs the query mapped by the views.

Is it possible to ad index on the views?

Also, I want to add a table with defined column families and few qualifiers. My requirement is to store the data with qualifiers at runtime. How can I make sure to fetch the valid qualifiers while fetching particular record?

Explorer

Yes, index on views work but with some limitations: https://phoenix.apache.org/views.html

I don't have an answer for the second part of your question on cf and qualifiers.

for the second question:-

bq. Also, I want to add a table with defined column families and few qualifiers. My requirement is to store the data with qualifiers at runtime. How can I make sure to fetch the valid qualifiers while fetching particular record?

You can use dynamic columns while upserting data and doing SELECT.

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