[
https://issues.apache.org/jira/browse/PHOENIX-1482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14224906#comment-14224906
]
James Taylor commented on PHOENIX-1482:
---------------------------------------
Which version of Phoenix and HBase are you using?
FYI, an index over a mapped HBase table will not be maintained because the view
is read-only. Changes to the table will need to be made outside of Phoenix, so
the index will never be written to. Phoenix will use the index when it deems
it'd be more efficient to do so, but you'd be required to maintain the index
yourself. Is this what you're expecting?
> Create 2 Index on same column and drop 1 index makes table unusable...
> ----------------------------------------------------------------------
>
> Key: PHOENIX-1482
> URL: https://issues.apache.org/jira/browse/PHOENIX-1482
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0
> Environment: CDH4.7
> Reporter: saravanan
> Priority: Blocker
>
> Mapped hbase table to phoenix with view which has 4 columns
> eg: create view "db_primary"("RowKey" varchar primary key,"cf1"."col1"
> varchar,"cf1"."col2" varchar,"cf1"."col3" varchar,"cf1"."col4" varchar);
> create 2 index on "col2" with 2 different indexname.
> create index "index1" on "db_primary"("col1");
> create index "index2" on "db_primary"("col1");
> now Drop 1 index..
> drop index "index1" on "col1";
> select * from "db_primary"; or Drop view "db_primary";
> ERROR 1012 (42M03): Table undefined. tableName=index1 Index not found
> (state=42M03,code=1012)..
> how can i able to use that table???
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
