Assuming you mean 5.1.2 (as there is no such release 5.2.1) and without
any other data that would be necessary to properly diagnose what happened...
I would assume that the upgrade code inside of Phoenix to automatically
upgrade the Phoenix system tables is not effective across such a large
release gap. (4.8 was released approximately 5 years ago)
Unless you are prepared to look at Phoenix code and perform surgery on
your system.catalog table, I'd suggest that dropping the system tables
via HBase, re-creating the system tables by connecting, and then
recreating your Phoenix tables using `CREATE TABLE` is going to be less
painful.
Of other things, beware of the change where column encoding is turned on
by default in Phoenix 5.x http://phoenix.apache.org/columnencoding.html.
You would need to disable column encoding, assuming that you retain the
original data layout (e.g. COLUMN_ENCODED_BYTES=0)
On 6/22/21 8:57 AM, Ankit Joshi wrote:
Hello Team,
Getting error while upgrading from 4.8.2 to 5.2.1.
ERROR 504 (42703) : Undefined column:
ColumnName=SYSTEM.CATALOG.COLUMN_QUALIFIER
Failed upgrading System tables.
Kindly help.
Thanks & Regards,
Ankit Joshi