[teiid-issues] [JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
[
https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-5848:
-------------------------------------
Not sure how you are running above, if it is just local VM, add a property
`teiid.jdbc-enable=true" then it will open up a JDBC port on 31000. The you can use
Teiid JDBC driver to connect to the VDB. See docs for the URL etc.
If the View is showing there not in OData that means there is no PK or Unique key on the
View this it can not be exposed
views in vertica not found by teiid
-----------------------------------
Key: TEIID-5848
URL: https://issues.jboss.org/browse/TEIID-5848
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Reporter: Renat Eskenin
Assignee: Steven Hawkins
Priority: Major
We created view in vertica DB
Example project with vertica translator+odata not found this view
{code}
src 1 Varchar 4 [NULL] true false false [NULL] false [NULL]
src_id 2 Varchar 18 [NULL] true false false [NULL] false [NULL]
src_name 3 Varchar 363 [NULL] true false false [NULL] false [NULL]
account_id 4 Varchar 18 [NULL] true false false [NULL] false [NULL]
name 5 Varchar 765 [NULL] true false false [NULL] false [NULL]
billing_country 6 Varchar 240 [NULL] true false false [NULL] false [NULL]
root_domain 7 Varchar 192 [NULL] true false false [NULL] false [NULL]
sales_team 8 Varchar 240 [NULL] true false false [NULL] false [NULL]
{code}
{
"error": {
"code": null,
"message": "Cannot find EntitySet, Singleton, ActionImport or
FunctionImport with name 'funnel_leads'."
}
}
But regular tables works properly
--
This message was sent by Atlassian Jira
(v7.13.8#713008)