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

Issue when importing Flat files

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Do
    • Affects Version/s: 11.0.1
    • Fix Version/s: None
    • Component/s: Editors
    • Labels:
      None
    • Environment:

      Teiid Version 8.12.10

    • Steps to Reproduce:
      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.

        Gliffy Diagrams

          Attachments

          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

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                mcouliba Madou Coulibaly
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: