Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-3015

Importing Flat File with "-" character in one column of the header

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 11.1
    • None
    • None
    • Hide
      1. On Designer Select import.
      2. Choose "File Source (Flat) >> Source and View Model"
      3. Choose "Flat file on local file system"
        1. Create a new Flat File Data Source pointing to the file with the contend as referred in the description (UTF-8, CSV, Use first line as column name indicator).
        2. Choose the file
        3. Give a name to Source Model
      4. Use the given JNDI Name (with auto-create Data Source selected)
      5. Next
      6. Next
      7. Finish
      8. Save all
      9. Select the created table and click preview
      10. Teiid server gives the error.
      Show
      On Designer Select import. Choose "File Source (Flat) >> Source and View Model" Choose "Flat file on local file system" Create a new Flat File Data Source pointing to the file with the contend as referred in the description (UTF-8, CSV, Use first line as column name indicator). Choose the file Give a name to Source Model Use the given JNDI Name (with auto-create Data Source selected) Next Next Finish Save all Select the created table and click preview Teiid server gives the error.

    Description

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

      "a-a","b"
1,2
3,4

      Teiid server gives the following exception

        [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

      Attachments

        Activity

          People

            blafond Barry LaFond
            pringi Pedro Inácio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: