[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1928) Flat File Importer has problems with header having double quoted names
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