[
https://issues.apache.org/jira/browse/ARROW-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17121516#comment-17121516
]
Michael Pigott commented on ARROW-4144:
---------------------------------------
Hi, and thanks for taking a look at this! I saw Arrow as a tool that
could be used to transfer data between systems, and not just for
in-memory analysis. However, I don't need this today, and if nobody
else has asked for it, then there might be more valuable JIRA tickets
than mine for you to dedicate your time to?
Thanks again!
Mike
> [Java] Arrow-to-JDBC
> --------------------
>
> Key: ARROW-4144
> URL: https://issues.apache.org/jira/browse/ARROW-4144
> Project: Apache Arrow
> Issue Type: Improvement
> Components: Java
> Reporter: Michael Pigott
> Assignee: Chen
> Priority: Major
>
> ARROW-1780 reads a query from a JDBC data source and converts the ResultSet
> to an Arrow VectorSchemaRoot. However, there is no built-in adapter for
> writing an Arrow VectorSchemaRoot back to the database.
> ARROW-3966 adds JDBC field metadata:
> * The Catalog Name
> * The Table Name
> * The Field Name
> * The Field Type
> We can use this information to ask for the field information from the
> database via the
> [DatabaseMetaData|https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html]
> object. We can then create INSERT or UPDATE statements based on the [list
> of primary
> keys|https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getPrimaryKeys(java.lang.String,%20java.lang.String,%20java.lang.String)]
> in the table:
> * If the value in the VectorSchemaRoot corresponding to the primary key is
> NULL, insert that record into the database.
> * If the value in the VectorSchemaRoot corresponding to the primary key is
> not NULL, update the existing record in the database.
> We can also perform the same data conversion in reverse based on the field
> types queried from the database.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
