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!
[email protected]
