If you create a secondary index over a view that was directly created over an existing HBase table, the secondary index will not be maintained by Phoenix. You'd need to maintain it yourself manually. I'd recommend doing what you've mentioned in (1) above.
If you have a follow up question, please post an example of your DDL statements and indicate the HBase and Phoenix versions. Thanks, James On Mon, Jun 23, 2014 at 2:38 AM, X <[email protected]> wrote: > hi all: > I have a phoenix very anxious to solve the problem, thanks for reply. > 1. This way: I created table and view in the phoenix ,then used secondary > indexing . > Result : everything is fine; > 2.This way: I created view in the phoenix for an existing HBase table. I > mush use double quotes to succeed. > then used secondary indexing . > Result: secondary indexing is invalid, the other normal > > How can I use secondary indexing in a view created for an existing HBase > table? > > thank you very much! > > best wishes~ > > > > yours > > > Yufeng Wen
