Yes, this is PHOENIX-6534. There is no released Apache version with the fix, you need to manually apply the fix to 5.1.2, or use the 5.1 branch head.
regards István On Fri, Jul 22, 2022 at 10:35 PM Arshad, Mohammad <mohammad.ars...@visa.com> wrote: > Hello All, > > > > Upgraded HBase from 1.1.2 to 2.3.0. After applying HBASE-25902, hbase > upgrade was successful. > > > > But phoenix upgrade from version 4.7.0(hbase version 1.1.2) to 5.1.2(hbase > version 2.3,0) is failing with following error. > > > > 22/07/18 10:53:26 WARN query.ConnectionQueryServicesImpl: Failed upgrading > System tables. Snapshots for system tables created so far: > {SYSTEM.CATALOG=SNAPSHOT_SYSTEM.CATALOG_4.7.x_TO_5.1.0_20220718105325} > > Error: ERROR 504 (42703): Undefined column. > columnName=SYSTEM.CATALOG.COLUMN_QUALIFIER (state=42703,code=504) > > org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): > Undefined column. columnName=SYSTEM.CATALOG.COLUMN_QUALIFIER > > at > org.apache.phoenix.schema.PTableImpl.getColumnForColumnName(PTableImpl.java:1175) > > at > org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:528) > > > > When phoenix clients connect above error is logged. > > > > is anyone faced this issue earlier, is there known solution for this issue? > > > > Thanks & Regards > > Arshad > -- *István Tóth* | Staff Software Engineer st...@cloudera.com <https://www.cloudera.com> [image: Cloudera] <https://www.cloudera.com/> [image: Cloudera on Twitter] <https://twitter.com/cloudera> [image: Cloudera on Facebook] <https://www.facebook.com/cloudera> [image: Cloudera on LinkedIn] <https://www.linkedin.com/company/cloudera> <https://www.cloudera.com/> ------------------------------