[teiid-issues] [JBoss JIRA] (TEIID-5848) views in vertica not found by teiid

[Renat Eskenin (Jira)]

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

Renat Eskenin updated TEIID-5848:
---------------------------------
    Description: 
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'."
  }
}


  was:
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}




> 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'."
>   }
> }



--
This message was sent by Atlassian Jira
(v7.13.8#713008)