Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2859

Provide identity generation for TEXTTABLE and OBJECTTABLE

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 8.7
    • None
    • Query Engine
    • None

    Description

      Extend the functionality FOR ORDINALITY defined on XMLTABLE, to TEXTTABLE and OBJECTTABLE.

      This will useful in providing a automatic identity key if the data is being read from sources where there is identity column provided. The faced the issue when loading a text file like

      VA,F,1910,Mary,848
      VA,F,1911,Mary,747
      

      Where name each line is a separate row, but they do not have unique identifier attached with them. Also helpful with interfaces like OData where they require a PK on a table. This provides an easier alternative.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-rareddy Ramesh Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: