search

forcedotcom / phoenix

BSD 3-Clause "New" or "Revised" License
558 stars 227 forks source link

TableExistsException for SYSTEM.TABLE - HBase 0.94.14 #624

Closed mujtabachohan closed 10 years ago

mujtabachohan commented 10 years ago

Using HBase 0.94.14, initiating Phoenix connection when SYSTEM.TABLE is not present causes:

com.salesforce.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.TableExistsException: SYSTEM.TABLE at com.salesforce.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:107) at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:712) at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1052) at com.salesforce.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:827) at com.salesforce.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:337) at com.salesforce.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:83) at com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.executeUpdate(PhoenixStatement.java:357) at com.salesforce.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1036) at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1217) at com.salesforce.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:87) at com.salesforce.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:115) at java.sql.DriverManager.getConnection(DriverManager.java:615) at java.sql.DriverManager.getConnection(DriverManager.java:167) at com.salesforce.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:197)

Note:

  1. This exception does not happen with HBase 0.94.12 or lower.
  2. This exception happens when running HBase in distributed mode.
jtaylor-sfdc commented 10 years ago

Closing, as it looks like this was more of a test issue.

blwin2010 commented 10 years ago

I encountered this problem,and do not know why.Is it ok now? phoenix version :2.0.2 Hbase version :0.94.17 Or can you tell me how to resolve it?