This seems the same issue as PHOENIX-1005 <https://issues.apache.org/jira/browse/PHOENIX-1005>
From: "[email protected]" <[email protected]> Reply-To: <[email protected]> Date: Thursday, May 29, 2014 10:23 PM To: user <[email protected]> Subject: drop index exception hi, I am create a table, at the same time index was established (phoenix 4.0 hbase0.98.1 hadoop2.2), table: create table Real(RK varchar not null primary key,RD varchar,SC varchar, A0 varchar,A1 varchar,A2 varchar,A3 varchar,A4 varchar,A5 varchar, B0 varchar,B1 varchar,B2 varchar,B3 varchar,B4 varchar,B5 varchar, C0 varchar,C1 varchar,C2 varchar,C3 varchar,C4 varchar,C5 varchar, D0 varchar,D1 varchar,D2 varchar,D3 varchar,D4 varchar,D5 varchar ) SALT_BUCKETS=10 index: create index real_idx_at on real (RD,SC) ; I import the data to the table (30milion rows) via JDBC, and then I created another index : create indexreal_idx_sc_rd on real (SC,RD) include (A0 ,A1 ,A2 ) SALT_BUCKETS=10; and then I imported the data (70milion rows) via JDBC . Now, the total data is 100milion. I drop index real_idx_at. 0: jdbc:phoenix:dn2> drop index REAL_IDX_AT on real; No rows affected (6.916 seconds) When I issue the following command in sqlline.sh I get the error message: 0: jdbc:phoenix:dn2> select count(*) from real; Error: ERROR 1012 (42M03): Table undefined. tableName=REAL_IDX_AT (state=42M03,code=1012) Thanks! [email protected] -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
