[PHOENIX-6568] NullPointerException in phoenix-queryserver-client not in phoenix-client-hbase

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.2.0
• Fix Version/s: 4.17.0, 5.2.0, 4.16.2, 5.1.3
• Component/s: core
• Assignee: Istvan Toth
• Reporter: Alejandro Anadon
• Created: 07/Oct/21 10:05
• Updated: 13/Oct/21 18:50
• Resolved: 13/Oct/21 14:33

Description

It may not be a bug and it's simply because I'm missing some concepts, but I guess the behavior of phoenix-client-hbase should be the same as phoenix-queryserver-client.

If I run a simple query like:
select null;
In phoenix-queryserver-client I get a java.lang.NullPointerException, but in phoenix-client-hbase not.

the query is reduced to the minimal concept, but I have the same result with other queries like:

select null as SEQUENCE_CATALOG , SEQUENCE_SCHEMA , SEQUENCE_NAME , START_WITH as START_VALUE , MIN_VALUE as MINIMUM_VALUE , MAX_VALUE as MAXIMUM_VALUE , INCREMENT_BY as "INCREMENT" FROM SYSTEM."SEQUENCE";

 

this is the exception:

 

org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : Error while executing SQL "select null": Remote driver error: NullPointerException: (null exception message)
at org.apache.calcite.avatica.Helper.createException(Helper.java:54)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163)
at org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:217)
at sqlline.Commands.executeSingleQuery(Commands.java:1054)
at sqlline.Commands.execute(Commands.java:1003)
at sqlline.Commands.sql(Commands.java:967)
at sqlline.SqlLine.dispatch(SqlLine.java:734)
at sqlline.SqlLine.begin(SqlLine.java:541)
at sqlline.SqlLine.start(SqlLine.java:267)
at sqlline.SqlLine.main(SqlLine.java:206)
at org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:64)
java.lang.NullPointerException
at java.base/java.util.Objects.requireNonNull(Objects.java:221)
at org.apache.calcite.avatica.ColumnMetaData$AvaticaType.<init>(ColumnMetaData.java:528)
at org.apache.calcite.avatica.ColumnMetaData$ScalarType.<init>(ColumnMetaData.java:598)
at org.apache.calcite.avatica.ColumnMetaData.scalar(ColumnMetaData.java:265)
at org.apache.calcite.avatica.jdbc.JdbcMeta.columns(JdbcMeta.java:247)
at org.apache.calcite.avatica.jdbc.JdbcMeta.signature(JdbcMeta.java:288)
at org.apache.calcite.avatica.jdbc.JdbcMeta.signature(JdbcMeta.java:294)
at org.apache.calcite.avatica.jdbc.JdbcResultSet.create(JdbcResultSet.java:80)

......

 

Issue Links

• links to: GitHub Pull Request #1331