[teiid-issues] [JBoss JIRA] (TEIID-4386) Vertica Translator - Missing Quote on "date" field.

[Ted Jones (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ted Jones updated TEIID-4386:
-----------------------------
    Attachment: firstError.txt


Attached query plan and exception.

> Vertica Translator - Missing Quote on "date" field.
> ---------------------------------------------------
>
>                 Key: TEIID-4386
>                 URL: https://issues.jboss.org/browse/TEIID-4386
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 9.0.2
>            Reporter: Ted Jones
>            Assignee: Steven Hawkins
>         Attachments: firstError.txt
>
>
> Previewing a Vertica table results in the following error:
> 10:46:53,873 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB PREVIEW-7288da00-a070-45c9-9762-671d641ed431.1 model "rhel_iot_data" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "'Integer'), [*]date[*] date OPTIONS" at line 5, column 9.
> Was expecting: "constraint" | "foreign" | "primary" | "unique" | id: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "'Integer'), [*]date[*] date OPTIONS" at line 5, column 9.
> Was expecting: "constraint" | "foreign" | "primary" | "unique" | id
> 	at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> 	at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:768) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> 	at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> 	at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84) [teiid-runtime-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> 	at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> 	at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> 	at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
> 	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
> 	at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "'Integer'), [*]date[*] date OPTIONS" at line 5, column 9.
> Was expecting: "constraint" | "foreign" | "primary" | "unique" | id
> 	at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> 	... 11 more



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