[PHOENIX-5210] NullPointerException when alter options of a table that is appendOnlySchema

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.15.0, 4.14.3
• Fix Version/s: 5.1.0, 4.16.0
• Assignee: Toshihiro Suzuki
• Reporter: Toshihiro Suzuki
• Created: 24/Mar/19 15:35
• Updated: 02/Nov/20 22:30
• Resolved: 02/Nov/20 22:30

Description

I'm facing the following NullPointerException when alter options of a table that is appendOnlySchema.

java.lang.NullPointerException
	at org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3545)
	at org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3517)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:1440)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)
	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1833)
	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAlterTableOptions(AppendOnlySchemaIT.java:368)

Steps to reproduce is as follows:
1. Create a table that is appendOnlySchema:

CREATE TABLE tbl (id INTEGER PRIMARY KEY, col INTEGER) APPEND_ONLY_SCHEMA = true, UPDATE_CACHE_FREQUENCY = 1;

2. Alter a option of the table:

ALTER TABLE tbl SET STORE_NULLS = true;

After step 2, we will face the NullPointerException.