You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Alexander Denissov (JIRA)" <ji...@apache.org> on 2018/09/07 20:35:00 UTC

[jira] [Commented] (HAWQ-1605) Support INSERT in PXF JDBC plugin

    [ https://issues.apache.org/jira/browse/HAWQ-1605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16607631#comment-16607631 ] 

Alexander Denissov commented on HAWQ-1605:
------------------------------------------

[~leskin-in] – Code from the PR has been checked in, thank you for contributing.

> Support INSERT in PXF JDBC plugin
> ---------------------------------
>
>                 Key: HAWQ-1605
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1605
>             Project: Apache HAWQ
>          Issue Type: Improvement
>          Components: PXF
>            Reporter: Ivan Leskin
>            Assignee: Alexander Denissov
>            Priority: Major
>             Fix For: 2.5.0.0
>
>
> Add support of INSERT queries in PXF JDBC plugin:
>  * Implement `WriteAccessor` and `WriteResolver` interfaces. Both are implemented in the same classes as `ReadAccessor` and `ReadResolver`;
>  * Support query batching in Accessor. The size of a batch is defined by user and may be "infinite";
>  * In Accessor, use `java.sql.PreparedStatement` and built-in functions in it to process queries;
>  * In `setFields()` method of Resolver, perform type conversions of the data tuples received from PXF.
> Optimize and refactor the code in PXF JDBC plugin, make some fixes:
>  * Make functions for building WHERE statements static where possible to reduce the number of InputData checks;
>  * Organize imports;
>  * Check the codestyle;
>  * Fix the handling of TIMESTAMP values when performing SELECT requests.
> Improve documentation:
>  * Correct or rewrite Javadoc strings for plugin functions;
>  * Rewrite README.md.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)