[teiid-issues] [JBoss JIRA] (TEIID-4704) Importing Flat File with "-" character in one column of the header

[Pedro Inácio (JIRA)]

Pedro Inácio created TEIID-4704:
-----------------------------------

             Summary: Importing Flat File with "-" character in one column of the header 
                 Key: TEIID-4704
                 URL: https://issues.jboss.org/browse/TEIID-4704
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 9.1.2
         Environment: CentOs 7 + Teiid 9.1.2 with Wildfly 10.0.0.Final + Eclipse Neon with Designer 11.
            Reporter: Pedro Inácio
            Assignee: Steven Hawkins


Trying to create a simple Flat File View Model from aCSV file with the following content:


{code:java}
"a-a","b"
1,2
3,4
{code}


Teiid server gives the following exception

{noformat}

  [org.teiid.RUNTIME] (Worker6_async-teiid-threads6)  TEIID50036 VDB PREVIEW-80ce0d21-f22d-431f-bd12-89ac57ac9418.1 model "ViewModel" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10.
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[*]-[*]a string" at line 3, column 10.
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:798)
        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:360)
        at org.teiid.jboss.VDBService$7.run(VDBService.java:411)
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
        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[*]-[*]a string" at line 3, column 10.
Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
        at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
        ... 13 more

{noformat}





--
This message was sent by Atlassian JIRA
(v7.2.3#72005)