[
https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5848:
---------------------------------------
And get the result!
That's progress!
External JDBC connection with property teiid.host-name=127.0.0.1 do
not working too
Are you using teiid spring boot 1.2 or a later snapshot?
But how to get this result in odata request?
I don't think that it's possible without using a vdb in this case. You'll
need the vdb to issue an alter to add a key to funnel_leads:
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER vertica;
CREATE SERVER vertica FOREIGN DATA WRAPPER vertica;
CREATE SCHEMA vertica SERVER vertica;
IMPORT FROM SERVER vertica INTO vertica OPTIONS("importer.useFullSchemaName"
'false');
SET SCHEMA vertica;
ALTER view funnel_leads ADD primary key (src_id, account_id);
{code}
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)