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

Issue when importing Flat files

XMLWordPrintable

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

      Import CSV file

      Show
      Import CSV file

      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.

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

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

                Created:
                Updated:
                Resolved: