You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by "Ivan Leskin (JIRA)" <ji...@apache.org> on 2018/04/08 08:30:00 UTC
[jira] [Created] (HAWQ-1605) Support INSERT in PXF JDBC plugin
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
(v7.6.3#76005)