Uploaded image for project: 'Sqoop (READ-ONLY)'
  1. Sqoop (READ-ONLY)
  2. SQOOP-203

Add support for sequence.nextval in the sql export tool

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.2.0
    • Component/s: codegen
    • Labels:
    • Environment:
      Issue is not really environment related but linux OS running on dell poweredge servers with oracle 10.2.0.5 as backend

      Description

      JDBC's prepared statement provides a feature to include sequence.nextval as a string literal in the select statement. This option is provided since prepared statement does not provide any support for passing a value of sequence.nextval through a binding parameter.

      The current version of sqoop export does not provide a feature to include sequence.nextval in the column attribute.

      Without this option, it becomes very difficult to generate surrogate keys and hadoop framework does not provide any support out of the box for generating unique/surrogate keys.

      It will be of great help to add this feature to sqoop query export tool.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              vganeshkumar@gmail.com Ganesh
            • Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: