[PHOENIX-1972] !describe throws exception when used with sqlline-thin/pqs

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.4.0
• Assignee: Josh Elser
• Reporter: Nick Dimiduk
• Created: 15/May/15 04:07
• Updated: 25/Jan/16 05:49
• Resolved: 25/Jan/16 05:49

Description

Seems we're dropping some metadata about column types.

0: jdbc:phoenix:thin:url=http://localhost:876> !describe TABLE1
+------------------------------------------+-----------------------------------+
|                TABLE_CAT                 |               TABLE_SCHEM         |
+------------------------------------------+-----------------------------------+
java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long
	at org.apache.calcite.avatica.util.AbstractCursor$LongAccessor.getLong(AbstractCursor.java:497)
	at org.apache.calcite.avatica.AvaticaParameter.get(AvaticaParameter.java:320)
	at org.apache.calcite.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:380)
	at sqlline.Rows$Row.<init>(Rows.java:157)
	at sqlline.IncrementalRows.hasNext(IncrementalRows.java:63)
	at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
	at sqlline.SqlLine.print(SqlLine.java:1653)
	at sqlline.Commands.metadata(Commands.java:199)
	at sqlline.Commands.columns(Commands.java:360)
	at sqlline.Commands.describe(Commands.java:1367)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
	at sqlline.SqlLine.dispatch(SqlLine.java:804)
	at sqlline.SqlLine.begin(SqlLine.java:681)
	at sqlline.SqlLine.start(SqlLine.java:398)
	at sqlline.SqlLine.main(SqlLine.java:292)

Issue Links

• is related to: CALCITE-927 ColumnsRequest Service call doesn't "fix" ResultSetResponse.