drop index exception

["yinxl@shencai.cc" <yi...@shencai.cc>]

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=10index: ?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!


yinxl@shencai.cc

Re: drop index exception

[Jeffrey Zhong <jz...@hortonworks.com>]

This seems the same issue as PHOENIX-1005
<https://issues.apache.org/jira/browse/PHOENIX-1005>

From:  "yinxl@shencai.cc" <yi...@shencai.cc>
Reply-To:  <us...@phoenix.incubator.apache.org>
Date:  Thursday, May 29, 2014 10:23 PM
To:  user <us...@phoenix.incubator.apache.org>
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!

yinxl@shencai.cc



-- 
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.