[
https://issues.apache.org/jira/browse/DRILL-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14312542#comment-14312542
]
Daniel Barclay (Drill/MapR) commented on DRILL-2188:
----------------------------------------------------
> the JDBC driver gets complex data as a complex type which it then converts to
> JSON.
Which case are you referring to, the case when ResultSet.getString(...) is
called or some other case?
In particular, when ResultSet.getObject(...) is called, should we return a JDBC
Struct representing a SQL STRUCT type, or something similar?
> JDBC should default to getting complex data as JSON
> ---------------------------------------------------
>
> Key: DRILL-2188
> URL: https://issues.apache.org/jira/browse/DRILL-2188
> Project: Apache Drill
> Issue Type: Improvement
> Components: Client - JDBC
> Reporter: Parth Chandra
> Assignee: Daniel Barclay (Drill/MapR)
> Priority: Minor
> Fix For: 0.9.0
>
>
> Currently the ODBC driver gets complex data as a JSON string while the JDBC
> driver gets complex data as a complex type which it then converts to JSON.
> The conversion to JSON in the JDBC path uses an expensive method that also
> consumes excessive amounts of CPU.
> Since client applications are unable to consume complex data, the default
> should be to get JSON data and there should be a client side setting (session
> paramater) to revert to getting complex data.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
