[
https://issues.apache.org/jira/browse/PHOENIX-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17030172#comment-17030172
]
Sandeep Guggilam commented on PHOENIX-5714:
-------------------------------------------
Exception:
Error: ERROR 504 (42703): Undefined column.
columnName=SYSTEM.CATALOG.VIEW_INDEX_ID_DATA_TYPE (state=42703,code=504)
org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined
column. columnName=SYSTEM.CATALOG.VIEW_INDEX_ID_DATA_TYPE
at
org.apache.phoenix.schema.PTableImpl.getColumnForColumnName(PTableImpl.java:1106)
at
org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:528)
at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:483)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:798)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:784)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:405)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:395)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:394)
at
org.apache.phoenix.jdbc.PhoenixStatement.access$700(PhoenixStatement.java:216)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:435)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:395)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:394)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:382)
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:173)
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:183)
at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2941)
at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1096)
at
org.apache.phoenix.compile.CreateTableCompiler$CreateTableMutationPlan.execute(CreateTableCompiler.java:384)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:412)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:395)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:394)
at
org.apache.phoenix.jdbc.PhoenixStatement.access$700(PhoenixStatement.java:216)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:435)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:395)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:394)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:382)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1859)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemChildLink(ConnectionQueryServicesImpl.java:3779)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeOtherSystemTablesIfRequired(ConnectionQueryServicesImpl.java:3766)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTables(ConnectionQueryServicesImpl.java:3695)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:3181)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:3094)
at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:3094)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:144)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:154)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:202)
at sqlline.Commands.connect(Commands.java:1165)
at sqlline.Commands.connect(Commands.java:1055)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
at sqlline.SqlLine.dispatch(SqlLine.java:643)
at sqlline.SqlLine.initArgs(SqlLine.java:385)
at sqlline.SqlLine.begin(SqlLine.java:485)
at sqlline.SqlLine.start(SqlLine.java:233)
at sqlline.SqlLine.main(SqlLine.java:175)
> Upgrade to 4.15/4.16 throwing ColumnNotFoundException
> -----------------------------------------------------
>
> Key: PHOENIX-5714
> URL: https://issues.apache.org/jira/browse/PHOENIX-5714
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.16.0
> Reporter: Sandeep Guggilam
> Assignee: Sandeep Guggilam
> Priority: Major
> Fix For: 4.16.0
>
>
> Steps to reproduce:
> # Bring up a server with 4.15 or 4.16 version ( the current 4.x-HBase-1.3 )
> # Connect the 4.14 client to the server using sqlline.py
> # Connect the 4.15 or 4.16 client to the server using sqlline.py which then
> throws the following exception
> ERROR 504 (42703): Undefined column.
> columnName=SYSTEM.CATALOG.VIEW_INDEX_ID_DATA_TYPE (state=42703,code=504)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
