[teiid-issues] [JBoss JIRA] (TEIID-4386) Vertica Translator - Missing Quote on "date" field.
Ted Jones (JIRA)
issues at jboss.org
Tue Aug 16 11:18:00 EDT 2016
Ted Jones created TEIID-4386:
--------------------------------
Summary: 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
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)
More information about the teiid-issues
mailing list