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

Flat File Importer has problems with header having double quoted names

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.3
    • 8.2
    • Import/Export
    • None

    Description

      Problem scenario is described below. Designer should strip off the double quotes on header names when generating column names. (It does so for single quoted names)

      =======================================================
      I am having an issue with a CSV whose header row has its columns surrounded by quotes. For example, "ID" becomes """ID""". When I create a source/view for the file, it seems to do it successfully, but does make me reconcile the SQL. To reconcile the SQL I have to match the unmatched SQL symbols. An example of this is where ID equals "ID". Once reconciled, the VDB deploys but fails to find the view once I try to query it. This is the warning that I am getting fromt he server, but it seems more like an error to me because it halts execution of the query at that point.

      15:47:33,293 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) TEIID30020 Processing exception for request 7v7hMSEj9U7c.0 'TEIID30181 HEADER entry missing for column name "ID" in file:/home/coty/data/ACCOUNT.csv.'. Originally TeiidProcessingException TextTableNode.java:373.: org.teiid.core.TeiidProcessingException: TEIID30181 HEADER entry missing for column name "ID" in file:/home/coty/data/ACCOUNT.csv.
      at org.teiid.query.processor.relational.TextTableNode.processHeader(TextTableNode.java:373) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]

      When I strip the quotes from the header row and put it back everything works fine.

      Attachments

        Activity

          People

            mdrillin1@redhat.com Mark Drilling (Inactive)
            mdrillin1@redhat.com Mark Drilling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: