[ https://issues.apache.org/jira/browse/PHOENIX-1482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-1482: ---------------------------------- Assignee: Dave Hacker > 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 > Assignee: Dave Hacker > 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)