Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-1605

Support INSERT in PXF JDBC plugin

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5.0.0
    • Component/s: PXF
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              adenissov Alexander Denissov
              Reporter:
              leskin-in Ivan Leskin
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: