[teiid-issues] [JBoss JIRA] (TEIID-4429) Special characters in column names when importing CSV files

[João Matos (JIRA)]

João Matos created TEIID-4429:
---------------------------------

             Summary: Special characters in column names when importing CSV files
                 Key: TEIID-4429
                 URL: https://issues.jboss.org/browse/TEIID-4429
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 9.0.3
         Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
            Reporter: João Matos
            Assignee: Steven Hawkins


Hi,

I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:

Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
	at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
	at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
	at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
	at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
	at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
	at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
	at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
	at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
	... 13 more



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)