Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Phoenix table design

avatar
Rising Star

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

avatar
Master 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

avatar
Master 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.

avatar
Rising Star

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

avatar
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.

avatar
Rising Star

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?

avatar
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.

avatar

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