[jira] [Updated] (PHOENIX-1482) Create 2 Index on same column and drop 1 index makes table unusable...

["James Taylor (JIRA)" <ji...@apache.org>]

     [ 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)