Details
-
Bug
-
Resolution: Done
-
Major
-
8.2
-
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.