[teiid-issues] [JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
Steven Hawkins (Jira)
issues at jboss.org
Thu Nov 14 12:51:00 EST 2019
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13813259#comment-13813259 ]
Steven Hawkins commented on TEIID-5848:
---------------------------------------
> What is "main datasource"? Datasource for vertica or datasource for teiid embed metafata db? Can you give example?
In the context of your spring application if you use
{code}
@Autowire
DataSource dataSource;
{code}
Then that should provide the embedded data source for Teiid.
> Another question. What is "primary key for view"?
It's something that can optionally be defined by the source. If the database does not provide that metadata, then the view will not visible in Teiid OData - which requires the notion of key to expose an entity.
> In view we do not have any keys, what about view with multiple back tables and sub tables?
The metadata import only does not try to obtain the view definition and transitively determine if there are unique / primary keys.
In view we do not have any keys, what about view with multiple back tables and sub tables?
> 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)
More information about the teiid-issues
mailing list