[jira] [Resolved] (PHOENIX-1013) drop index , query exception

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-1013.
-----------------------------------
       Resolution: Fixed
    Fix Version/s:     (was: 4.0.0)
                   4.1
                   3.1

I believe these issues were fixed, but if you see it occur again, please re-open.

> drop index  , query exception
> -----------------------------
>
>                 Key: PHOENIX-1013
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1013
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.0.0
>         Environment: centos6.5、hadoop2.2、hbase0.98.1
>            Reporter: yxl
>             Fix For: 3.1, 4.1
>
>
> 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(rk) from real; 
> Error: ERROR 1012 (42M03): Table undefined. tableName=REAL_IDX_AT (state=42M03,code=1012)
> 0: jdbc:phoenix:dn2> select /*+NO_INDEX*/ count(*) from real;
> +------------+
> |  COUNT(1)  |
> +------------+
> | 217740307  |
> +------------+
> 1 row selected (157.296 seconds)
> Thanks!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)