forcedotcom / phoenix

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

ERROR 1012 (42M03): Table undefined #736

Closed xuxc closed 9 years ago

xuxc commented 9 years ago

wheather "select" clause only works with table which be created in phoenix?

I first create table by java API using hbase copeocessor ,I use copeocessor to create secordary index,but when i want to query ,the error cames below:

com.salesforce.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=TB at com.salesforce.phoenix.schema.PMetaDataImpl.getTable(PMetaDataImpl.java:51) at com.salesforce.phoenix.compile.FromCompiler$SingleTableColumnResolver.(FromCompiler.java:146) at com.salesforce.phoenix.compile.FromCompiler.getResolver(FromCompiler.java:106) at com.salesforce.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:106) at com.salesforce.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:46) at com.salesforce.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:41) at com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.optimizePlan(PhoenixStatement.java:223) at com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.executeQuery(PhoenixStatement.java:200) at com.salesforce.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:1030)

JamesRTaylor commented 9 years ago

Phoenix moved to Apache about a year ago. Please upgrade to our latest version, subscribe to our Apache mailing list here, and repost your question if you're on an Apache release.

xuxc commented 9 years ago

does the latest version support Hbase 0.94.8(hindex)?

JamesRTaylor commented 9 years ago

Yes, the 4.1 release supports HBase 0.94.8 and above with local indexes - Rajeshbabu implemented those for us.

xuxc commented 9 years ago

that's to say, I can use hindex(HUAWEI secondary index) and phoenix together whithout errors above?

JamesRTaylor commented 9 years ago

unlikely. Phoenix has local indexes now - I'd suggest you use those.

On Sat, Oct 11, 2014 at 1:45 AM, xuxc notifications@github.com wrote:

that's to say, I can use hindex(HUAWEI secondary index) and phoenix together whithout errors above?

— Reply to this email directly or view it on GitHub https://github.com/forcedotcom/phoenix/issues/736#issuecomment-58742849.

JamesRTaylor commented 9 years ago

http://phoenix.apache.org/download.html

On Sun, Oct 12, 2014 at 11:02 PM, xuxc notifications@github.com wrote:

thx, where should i get the the 4.1 release ?

— Reply to this email directly or view it on GitHub https://github.com/forcedotcom/phoenix/issues/736#issuecomment-58849170.