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

Create new system function to dump temp table contents to file.

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 7.2
    • 6.0.0
    • Query Engine
    • None
    • Documentation (Ref Guide, User Guide, etc.), Release Notes
    • Medium

    Description

      A requirement to produce a CSV file reflecting the contents of a query result set so it can be subsequently FTP'd or email'd. In Nov 07 implemented this feature using the exec connector, a shell script and mods to JDBCISQL.

      Suggested capability: function will take the following parameters:

      • Temp table name as string
      • Target file name (path qualified) as string
      • Delimiter as string

      When invoked, the specified temp table contents will be written out to the specified file using the specified delimiter to separate the column values.
      This generic capability will allow the CSV file thats needed and subsequently process it with other UDF functionality as necessary.

      Open questions:
      1. How does file path behave in a clustered environment? Is it relative to the MM Server install dir or fully qualified?

      Suggest this feature remain undocumented for the short term.

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            kzj_08 Ken Johnson
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: