[CALCITE-2386] Support columns containing struct / nested rows

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: avatica-1.13.0
• Component/s: avatica
• Assignee: Kenneth Knowles
• Reporter: Kenneth Knowles
• Created: 27/Jun/18 13:18
• Updated: 03/Dec/18 00:27
• Resolved: 28/Jun/18 19:56

Description

Avatica row / struct support appears not quite wired up. Using sqlline with the Beam JDBC driver:

> select row(1, 2);
+--------+
| EXPR$0 |
+--------+
java.lang.RuntimeException: not implemented
	at org.apache.calcite.avatica.AvaticaSite.notImplemented(AvaticaSite.java:420)
	at org.apache.calcite.avatica.AvaticaSite.get(AvaticaSite.java:302)
	at org.apache.calcite.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:377)
	at sqlline.Rows$Row.<init>(Rows.java:175)
	at sqlline.IncrementalRows.hasNext(IncrementalRows.java:66)
	at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
	at sqlline.SqlLine.print(SqlLine.java:1648)
	at sqlline.Commands.execute(Commands.java:834)
	at sqlline.Commands.sql(Commands.java:733)
	at sqlline.SqlLine.dispatch(SqlLine.java:795)
	at sqlline.SqlLine.begin(SqlLine.java:668)
	at sqlline.SqlLine.start(SqlLine.java:373)
	at sqlline.SqlLine.main(SqlLine.java:265)

Currently Avatica 1.11.0 but checking the code it looks like the same problem exists today.

Issue Links

• links to: GitHub Pull Request #62