Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5848

views in vertica not found by teiid

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Major Major
    • None
    • None
    • JDBC Connector
    • None
    • Hide

      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

      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();
    }	
}

      used dependencies

      spring-odata
      teiid-spring-boot-starter
      vertica-jdbc

      View not found in teiid odata

      Show
      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 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(); } } used dependencies spring-odata teiid-spring-boot-starter vertica-jdbc View not found in teiid odata

      We created view in vertica DB
      Example project with vertica translator+odata not found this view

      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]

      {
      "error":

      { "code": null, "message": "Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'funnel_leads'." }

      }

      But regular tables works properly

            rhn-engineering-shawkins Steven Hawkins
            3draven Renat Eskenin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: