Got TableNotFoundException when upgrading from Phoenix 2.2.x

[vincentluu]

when i "select * from TEST ",throw TableNotFoundException .i already added a new phoenix.client.autoUpgradeWhiteList config parameter to my client-side hbase-sites.xml.And make sure HBase finded it.

"org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=TEST"

[JamesRTaylor]

Hello @luyichenn - Phoenix moved about 5mo back from GitHub to Apache. Please repost your question on our mailing list (after subscribing) as described here.

I suspect that you may have had an initial connection without a whitelist specified. The whitelist is only used on the very first ever connection to a 3.0 cluster. Take a look at the upgrade instructions here and in particular this part that describes what to do if you want the upgrade to occur after you've already made the first connection:

• After the first connection has been made to a cluster with Phoenix 3.0/4.0 installed, no further upgrade will take place. However, you may force it to take place again by removing the UpgradeTo30 attribute from the SYSTEM.CATALOG HBase table metadata. Then, on the next connection to the cluster, upgrade will again occur as describe above.