How many nodes are in the cluster? How fast do you expect this table to grow? In the current state, 1.5 mill rows is not a massive dataset, so, having an index for every possibility will result in more effort towards index maintenance and not produce comparable query improvements. If you can narrow down your use case to prioritize few of the column qualifiers as "heavy-use", those will be good candidates for an index(s).
On Fri, Oct 24, 2014 at 7:58 AM, xuxc1120 <xuxc1...@vip.qq.com> wrote: > Hi, i am sorry to conduct such question: > > i already have a hbase table with 1.5 million rows ,(e.g table1 with rowkey > and column Family :info),under CF "info",these are almost 100 qualifies, such > as "info:name","info:age","info:addr".... > > when I want to use index in phoenix to query data on any column,e.g > > select * from table where "name"="cond1" and "addr"="cond2"; > > select * from table where "age" ="cond3" and "name"= "cond4"; > > ... > > I want to use index to query for every possibility may select clause > conduct . > > > > Are there some ways to do that? > > that is to say ,how to create table/view and indexes in phoenix ? > > thanks. > > xuxc > >
