phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Saravanan A <asarava...@alphaworkz.com>
Subject Re: Create 2 Index on single and Drop 1 Index makes the view not usable...
Date Tue, 25 Nov 2014 13:27:11 GMT
Hi James,

I have Filed  JIRA PHOENIX-1482
<https://issues.apache.org/jira/browse/PHOENIX-1482>...

Thanks,
Saravanan.A

On Tue, Nov 25, 2014 at 8:03 AM, James Taylor <jamestaylor@apache.org>
wrote:

> Please file a JIRA. If you can put together a unit test that repros
> the issue, that'd be much appreciated.
> Thanks,
> James
>
> On Wed, Nov 19, 2014 at 6:02 AM, Saravanan A <asaravanan@alphaworkz.com>
> wrote:
> > Hi,
> >
> >
> > I have a UseCase  where am trying to create two index on same column on
> same
> > table with different indexname.
> >
> > 1.create view on hbase table(MainTable).
> > 2.create index1 on column (A).
> > 3.create index2 on column(A)/
> > 4.Drop index index1.
> >
> > select * from MainTable where A='xyz';
> >
> > Gives following error
> >   Error: ERROR 1012 (42M03): ERROR 1012 (42M03): Table undefined.
> > tableName=test_status_2 Index not found (state=42M03,code=1012)
> >
> > This brings down the entire table i can't do any process on that view
> even
> > drop view is giving error...
> >
> > what is the problem???
> >
> >
> > Regards,
> > Saravanan.A
>

Mime
View raw message