phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Saravanan A <asarava...@alphaworkz.com>
Subject Create 2 Index on single and Drop 1 Index makes the view not usable...
Date Wed, 19 Nov 2014 14:02:34 GMT
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