[teiid-issues] [JBoss JIRA] (TEIID-4429) Special characters in column names when importing CSV files
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)