RE: Table drop problem in phoenix-3.0.0

[Job Thomas]

Hi,
 
I have faced same issue as you felt.
Even though error  thrown, tables are getting dropped.
Please help me if any solution found....
 
 
Can you please try the below steps ?.
 
CREATE TABLE DEMO(R VARCHAR PRIMARY KEY,A DOUBLE,C VARCHAR);
CREATE INDEX DEMO_idx ON DEMO (A) INCLUDE(C);
upsert into DEMO values('cc1',null,'abc');
select * from DEMO;

I am not getting any data while querying !!.

________________________________

From: Seonghwan Moon [mailto:sofan...@gmail.com]
Sent: Tue 4/29/2014 11:58 AM
To: user@phoenix.incubator.apache.org
Subject: Table drop problem in phoenix-3.0.0



hello,  

I have a problem with running phoenix-3.0.0 on hbase-0.94.18 and hadoop-2.2.0

Every phoenix function works fine But, 'drop' function is failed. 


Here is the stack trace. any idea??

Thanks in advance~

create table t1 (a integer not null primary key);
upsert into t1 values(1)
drop table t1;


14/04/29 15:23:54 WARN client.HConnectionManager$HConnectionImplementation: 
Encountered problems when prefetch META table: 
org.apache.hadoop.hbase.TableNotFoundException: Cannot find row in .META. for 
table: _IDX_T1, row=_IDX_T1,,99999999999999
        at 
org.apache.hadoop.hbase.client.MetaScanner.metaScan(MetaScanner.java:151)
        at 
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.prefetchRegionCache(HConnectionManager.java:1062)
        at 
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:1124)
        at 
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:1004)
        at 
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:961)
        at org.apache.hadoop.hbase.client.HTable.finishSetup(HTable.java:251)
        at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:243)
        at 
org.apache.phoenix.query.HTableFactory$HTableFactoryImpl.getTable(HTableFactory.java:51)
        at 
org.apache.phoenix.query.ConnectionQueryServicesImpl.getTable(ConnectionQueryServicesImpl.java:249)
        at 
org.apache.phoenix.query.ConnectionQueryServicesImpl.getTableDescriptor(ConnectionQueryServicesImpl.java:261)
        at 
org.apache.phoenix.util.MetaDataUtil.hasViewIndexTable(MetaDataUtil.java:269)
        at 
org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:1309)
        at 
org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:1250)
        at 
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDropTableStatement$1.execute(PhoenixStatement.java:521)
        at 
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:227)
        at 
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:921)
        at sqlline.SqlLine$Commands.execute(SqlLine.java:3673)
        at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
        at sqlline.SqlLine.dispatch(SqlLine.java:821)
        at sqlline.SqlLine.begin(SqlLine.java:699)
        at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
        at sqlline.SqlLine.main(SqlLine.java:424)
No rows affected (2.557 seconds)

<<winmail.dat>>