Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-3086

Issue when importing Flat files

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 11.0.1
    • Editors
    • None
    • Hide

      Import CSV file

      Show
      Import CSV file

    Description

      Several issues when importing CSV file using Teiid Designer

      1. Double quotes are added on the first fields of the file. (wizard.png)
      2. When we remove these double quotes from the Transformation Editor, we got a mapping error. (editor1.png)
      3. We are not able anymore to add double quotes (because of SQL validation and Auto-Syntax), we have to click on "Reconcile Transformation SQL with Target Columns" button and bind the missing field. This will have an alias with double quotes and add "ROW DELIMITER ';'" information. (editor2.png)
      4. After removing the "ROW DELIMITER ';'" information, we execute the query and we got another error "org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30181 HEADER entry missing for column name airlinePartner in file:xxxx"
      5. We have to replace "HEADER" to "SKIP 1" to get a result (execution.png) but we still need to keep the alias with double quotes for the first field in the projection area.

      Attachments

        1. editor1.png
          294 kB
          Madou Coulibaly
        2. editor2.png
          290 kB
          Madou Coulibaly
        3. execution.png
          257 kB
          Madou Coulibaly
        4. wizard.png
          275 kB
          Madou Coulibaly

        Activity

          People

            blafond Barry LaFond
            mcouliba Madou Coulibaly (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: