[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5848:
-------------------------------------
is it visible when using a JDBC client through Teiid?
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
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'."
}
}
But regular tables works properly
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}
{
"error": {
"code": null,
"message": "Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'funnel_leads'."
}
}
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Renat Eskenin updated TEIID-5848:
---------------------------------
Steps to Reproduce:
Project properties
spring.datasource.vertica.jdbc-url=jdbc:vertica://vertica:5433/db?SearchPath=bi
spring.datasource.vertica.username=
spring.datasource.vertica.password=
spring.datasource.vertica.driver-class-name=com.vertica.jdbc.Driver
spring.datasource.vertica.platform=vertica
spring.datasource.vertica.importer.SchemaName=bi
spring.datasource.vertica.importer.DatabaseTimeZone=UTC
spring.datasource.vertica.importer.UseFullSchemaName=false
spring.teiid.model.package=com.model
#when init scripts are defined below property is needed as Hibernate will overwrite otherwise
spring.jpa.hibernate.ddl-auto=none
logging.level.org.teiid=INFO
spring.main.allow-bean-definition-overriding=true
Datasource
{code:java}
import javax.sql.DataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.teiid.spring.autoconfigure.MultiDataSourceTransactionManagement;
@Configuration
public class DataSources extends MultiDataSourceTransactionManagement {
@ConfigurationProperties(prefix = "spring.datasource.vertica")
@Bean
public DataSource vertica() {
return DataSourceBuilder.create().build();
}
}
{code}
used dependencies
spring-odata
teiid-spring-boot-starter
vertica-jdbc
View not found in teiid odata
was:
Project properties
spring.datasource.vertica.jdbc-url=jdbc:vertica://vertica:5433/db?SearchPath=bi
spring.datasource.vertica.username=
spring.datasource.vertica.password=
spring.datasource.vertica.driver-class-name=com.vertica.jdbc.Driver
spring.datasource.vertica.platform=vertica
spring.datasource.vertica.importer.SchemaName=bi
spring.datasource.vertica.importer.DatabaseTimeZone=UTC
spring.datasource.vertica.importer.UseFullSchemaName=false
spring.teiid.model.package=com.model
#when init scripts are defined below property is needed as Hibernate will overwrite otherwise
spring.jpa.hibernate.ddl-auto=none
logging.level.org.teiid=INFO
spring.main.allow-bean-definition-overriding=true
Datasource
{code:java}
import javax.sql.DataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.teiid.spring.autoconfigure.MultiDataSourceTransactionManagement;
@Configuration
public class DataSources extends MultiDataSourceTransactionManagement {
@ConfigurationProperties(prefix = "spring.datasource.vertica")
@Bean
public DataSource vertica() {
return DataSourceBuilder.create().build();
}
}
{code}
used dependencies
spring-odata
teiid-spring-boot-starter
vertica-jdbc
> 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}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Renat Eskenin updated TEIID-5848:
---------------------------------
Summary: views in vertica not found by teiid (was: views in vertica not found bu teiid)
> 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}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found bu teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Renat Eskenin updated TEIID-5848:
---------------------------------
Steps to Reproduce:
Project properties
spring.datasource.vertica.jdbc-url=jdbc:vertica://vertica:5433/db?SearchPath=bi
spring.datasource.vertica.username=
spring.datasource.vertica.password=
spring.datasource.vertica.driver-class-name=com.vertica.jdbc.Driver
spring.datasource.vertica.platform=vertica
spring.datasource.vertica.importer.SchemaName=bi
spring.datasource.vertica.importer.DatabaseTimeZone=UTC
spring.datasource.vertica.importer.UseFullSchemaName=false
spring.teiid.model.package=com.model
#when init scripts are defined below property is needed as Hibernate will overwrite otherwise
spring.jpa.hibernate.ddl-auto=none
logging.level.org.teiid=INFO
spring.main.allow-bean-definition-overriding=true
Datasource
{code:java}
import javax.sql.DataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.teiid.spring.autoconfigure.MultiDataSourceTransactionManagement;
@Configuration
public class DataSources extends MultiDataSourceTransactionManagement {
@ConfigurationProperties(prefix = "spring.datasource.vertica")
@Bean
public DataSource vertica() {
return DataSourceBuilder.create().build();
}
}
{code}
used dependencies
spring-odata
teiid-spring-boot-starter
vertica-jdbc
was:
Project properties
spring.datasource.vertica.jdbc-url=jdbc:vertica://vertica:5433/db?SearchPath=bi
spring.datasource.vertica.username=
spring.datasource.vertica.password=
spring.datasource.vertica.driver-class-name=com.vertica.jdbc.Driver
spring.datasource.vertica.platform=vertica
spring.datasource.vertica.importer.SchemaName=bi
spring.datasource.vertica.importer.DatabaseTimeZone=UTC
spring.datasource.vertica.importer.UseFullSchemaName=false
spring.teiid.model.package=com.model
#when init scripts are defined below property is needed as Hibernate will overwrite otherwise
spring.jpa.hibernate.ddl-auto=none
logging.level.org.teiid=INFO
spring.main.allow-bean-definition-overriding=true
Datasource
{code:java}
/*
* Copyright 2012-2017 the original author or authors.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.veeam.esb.config;
import javax.sql.DataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.teiid.spring.autoconfigure.MultiDataSourceTransactionManagement;
@Configuration
public class DataSources extends MultiDataSourceTransactionManagement {
@ConfigurationProperties(prefix = "spring.datasource.vertica")
@Bean
public DataSource vertica() {
return DataSourceBuilder.create().build();
}
}
{code}
used dependencies
spring-odata
teiid-spring-boot-starter
vertica-jdbc
> views in vertica not found bu 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}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found bu teiid
by Renat Eskenin (Jira)
Renat Eskenin created TEIID-5848:
------------------------------------
Summary: views in vertica not found bu 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
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}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 1 month