[PHOENIX-2805] Support array type from avatica and sqlline-thin

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 4.6.0

Environment

Phoenix 4.7.0-HBase-1.1

• Assignee: Unassigned
• Reporter: YoungWoo Kim
• Created: 29/Mar/16 04:42
• Updated: 05/Aug/21 09:28
• Resolved: 05/Aug/21 09:28

Description

While fetching result from queryserver, I got an error from sqlline-thin:

Error: Error -1 (00000) : Error while executing SQL "select param_name from my.tbl limit 100": Remote driver error: UnsupportedOperationException: Currently not supported (state=00000,code=-1)
org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : Error while executing SQL "select param_name from my.tbl limit 100": Remote driver error: UnsupportedOperationException: Currently not supported
	at org.apache.calcite.avatica.Helper.createException(Helper.java:53)
	at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
	at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:143)
	at org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:177)
	at sqlline.Commands.execute(Commands.java:822)
	at sqlline.Commands.sql(Commands.java:732)
	at sqlline.SqlLine.dispatch(SqlLine.java:808)
	at sqlline.SqlLine.begin(SqlLine.java:681)
	at sqlline.SqlLine.start(SqlLine.java:398)
	at sqlline.SqlLine.main(SqlLine.java:292)
java.lang.UnsupportedOperationException: Currently not supported
	at org.apache.phoenix.schema.types.PhoenixArray.getResultSet(PhoenixArray.java:201)
	at org.apache.calcite.avatica.jdbc.JdbcResultSet.getValue(JdbcResultSet.java:189)
	at org.apache.calcite.avatica.jdbc.JdbcResultSet.frame(JdbcResultSet.java:142)
	at org.apache.calcite.avatica.jdbc.JdbcResultSet.create(JdbcResultSet.java:91)
	at org.apache.calcite.avatica.jdbc.JdbcResultSet.create(JdbcResultSet.java:71)
	at org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:706)
	at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:186)
	at org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:868)
	at org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:842)
	at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102)
	at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38)
	at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:68)
	at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:497)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
	at java.lang.Thread.run(Thread.java:745)