Mark Drilling created TEIIDDES-1928: --------------------------------------- Summary: Flat File Importer has problems with header having double quoted names Key: TEIIDDES-1928 URL: https://issues.jboss.org/browse/TEIIDDES-1928 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 8.2 Reporter: Mark Drilling Assignee: Mark Drilling Fix For: 8.3 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. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira