I haven't exhaustively perf. tested but I have a Phoenix table with 15K columns in a single column family storing values in only 20 or so columns per row and it's performance seems on par with table with few columns.
On Wed, Jun 29, 2016 at 3:27 AM, Siddharth Ubale < siddharth.ub...@syncoms.com> wrote: > Hi , > > > > Is there any limit on the number of columns that can be stored in a > Phoenix table where all the columns are qualifiers of a single Column > family ? > > I would like to create a table which will scale horizontally with dynamic > columns and should not be more than 2500 columns , each of these columns > will be column qualifier for one column family in hbase table. > > I intend to store data in only 100 columns of the 2500 created columns for > each row as the remaining will not serve any purpose for the row data. > > How would phoenix perform in such a situation? > > > > > > > > Thanks, > > Siddharth Ubale, > > >
