hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ivan Leskin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1605) Support INSERT in PXF JDBC plugin
Date Sun, 08 Apr 2018 08:30:00 GMT
Ivan Leskin created HAWQ-1605:

             Summary: 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: Ed Espino

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

View raw message