Phoenix Error - ERROR 504 (4203)

[Ankit Joshi <an...@gmail.com>]

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

Re: Phoenix Error - ERROR 504 (4203)

[Josh Elser <el...@apache.org>]

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