May 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIIDSB-57) Provide Cassandra data source support

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-57?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIIDSB-57: --------------------------------------- You'll have to check the cassandra driver source/issues unfortunately. Their other driver versions had workarounds to be flexible about the guava version, which of course is now a common problem. > Provide Cassandra data source support > ------------------------------------- > > Key: TEIIDSB-57 > URL: https://issues.redhat.com/browse/TEIIDSB-57 > Project: Teiid Spring Boot > Issue Type: Feature Request > Components: datasource > Reporter: Ramesh Reddy > Assignee: Aditya Manglam Sharma > Priority: Major > Fix For: 1.5.0 > > > Provide data source support for Cassandra -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-57) Provide Cassandra data source support

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-57?page=com.atlassian.jira.plugi... ] Ramesh Reddy commented on TEIIDSB-57: ------------------------------------- I am seeing this {code} [ERROR] Found a problem with the dependency com.google.guava:guava Resolved version is 20.0 Version 19.0 was expected by artifact: org.teiid:spring-data-soap Version 20.0 was expected by artifacts: org.teiid:spring-data-google-spreadsheet, org.teiid:spring-openapi Version 27.0.1-jre was expected by artifact: org.teiid:spring-data-cassandra {code} Any way to downgrade to 20.0? > Provide Cassandra data source support > ------------------------------------- > > Key: TEIIDSB-57 > URL: https://issues.redhat.com/browse/TEIIDSB-57 > Project: Teiid Spring Boot > Issue Type: Feature Request > Components: datasource > Reporter: Ramesh Reddy > Assignee: Aditya Manglam Sharma > Priority: Major > Fix For: 1.5.0 > > > Provide data source support for Cassandra -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5958) Need support Owner and Parent constructions

by Renat Eskenin (Jira)

Renat Eskenin created TEIID-5958: ------------------------------------ Summary: Need support Owner and Parent constructions Key: TEIID-5958 URL: https://issues.redhat.com/browse/TEIID-5958 Project: Teiid Issue Type: Task Components: Salesforce Connector Reporter: Renat Eskenin Assignee: Steven Hawkins We have salesforce requests as: select vlic_Contract__r.Account.*Owner*.Email, vlic_Contract__r.Account.*Parent*.Email from Product_License__c Need to support Owner and Parent SOQL keys in teiid sql or another method to call this requests -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5861) Salesforce translator should support nested joins

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5861?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5861: -------------------------------------- But if you will make this functionality, we immediately return to teiid :) You are made cool project! > Salesforce translator should support nested joins > ------------------------------------------------- > > Key: TEIID-5861 > URL: https://issues.redhat.com/browse/TEIID-5861 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: Backlog > > Original Estimate: 2 days > Remaining Estimate: 2 days > > For this SQL we have wrong generated SOQL > {code} > select > price.Id, > price.IsActive__c, > price.name, > price.PriceBook__c, > book.DefaultCurrency__c, > price.Price__c, > price.ProductCode__c, > price.ProductName__c, > price.Product__c, > product.Id, > product.Name, > product.Description > from > MSRP__c as price > left outer join /*+ MAKEDEP */ Product2 as product on > price.Product__c = product.id > left outer join /*+ MAKEDEP */ Pricebook2 as book on > price.PriceBook__c = book.id > where > price.PriceBook__c =:priceBookId > and ProductCode__c in( > :productCodes > ) > and IsActive__c = true" > {code} > {code} > START DATA SRC COMMAND: startTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=3 executionID=2 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sql=SELECT sf.Pricebook2.DefaultCurrency__c FROM sf.Pricebook2 WHERE sf.Pricebook2.Id = 'xxxxx' > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.COMMAND_LOG.SOURCE [Worker0_QueryProcessorQueue1]: SOURCE SRC COMMAND: endTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=2 executionID=1 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sourceCommand=[SELECT MSRP__c.Id, MSRP__c.IsActive__c, MSRP__c.Name, MSRP__c.PriceBook__c, MSRP__c.Price__c, MSRP__c.ProductCode__c, MSRP__c.ProductName__c, MSRP__c.Product__c, Product__r.Id, Product__r.Name, Product__r.Description FROM MSRP__c WHERE (MSRP__c.PriceBook__c = 'xxxx') AND ((MSRP__c.ProductCode__c IN(xxxxx)) AND (MSRP__c.IsActive__c = true))] > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.CONNECTOR [Worker1_QueryProcessorQueue2]: salesforce.9MPiB/GOwB5f.9MPiB/GOwB5f.0.3: Incoming Query: SELECT Pricebook2.DefaultCurrency__c FROM Pricebook2 WHERE Pricebook2.Id = 'xxxx' > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.COMMAND_LOG.SOURCE [Worker1_QueryProcessorQueue2]: SOURCE SRC COMMAND: endTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=3 executionID=2 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sourceCommand=[Using retrieve: Pricebook2.DefaultCurrency__c Pricebook2 [xxxx]] > {code} > But need to generate one. Because we have two relations in MSRP__c -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5861) Salesforce translator should support nested joins

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5861?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5861: -------------------------------------- So, now we need to make our "simple translator" by antlr, ok. This is sad. > Salesforce translator should support nested joins > ------------------------------------------------- > > Key: TEIID-5861 > URL: https://issues.redhat.com/browse/TEIID-5861 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: Backlog > > Original Estimate: 2 days > Remaining Estimate: 2 days > > For this SQL we have wrong generated SOQL > {code} > select > price.Id, > price.IsActive__c, > price.name, > price.PriceBook__c, > book.DefaultCurrency__c, > price.Price__c, > price.ProductCode__c, > price.ProductName__c, > price.Product__c, > product.Id, > product.Name, > product.Description > from > MSRP__c as price > left outer join /*+ MAKEDEP */ Product2 as product on > price.Product__c = product.id > left outer join /*+ MAKEDEP */ Pricebook2 as book on > price.PriceBook__c = book.id > where > price.PriceBook__c =:priceBookId > and ProductCode__c in( > :productCodes > ) > and IsActive__c = true" > {code} > {code} > START DATA SRC COMMAND: startTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=3 executionID=2 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sql=SELECT sf.Pricebook2.DefaultCurrency__c FROM sf.Pricebook2 WHERE sf.Pricebook2.Id = 'xxxxx' > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.COMMAND_LOG.SOURCE [Worker0_QueryProcessorQueue1]: SOURCE SRC COMMAND: endTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=2 executionID=1 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sourceCommand=[SELECT MSRP__c.Id, MSRP__c.IsActive__c, MSRP__c.Name, MSRP__c.PriceBook__c, MSRP__c.Price__c, MSRP__c.ProductCode__c, MSRP__c.ProductName__c, MSRP__c.Product__c, Product__r.Id, Product__r.Name, Product__r.Description FROM MSRP__c WHERE (MSRP__c.PriceBook__c = 'xxxx') AND ((MSRP__c.ProductCode__c IN(xxxxx)) AND (MSRP__c.IsActive__c = true))] > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.CONNECTOR [Worker1_QueryProcessorQueue2]: salesforce.9MPiB/GOwB5f.9MPiB/GOwB5f.0.3: Incoming Query: SELECT Pricebook2.DefaultCurrency__c FROM Pricebook2 WHERE Pricebook2.Id = 'xxxx' > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.COMMAND_LOG.SOURCE [Worker1_QueryProcessorQueue2]: SOURCE SRC COMMAND: endTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=3 executionID=2 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sourceCommand=[Using retrieve: Pricebook2.DefaultCurrency__c Pricebook2 [xxxx]] > {code} > But need to generate one. Because we have two relations in MSRP__c -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5861) Salesforce translator should support nested joins

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5861?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5861: --------------------------------------- [~i3draven] Sorry this didn't make the cut for 14.0. if you have a support / eval contract with Red Hat / IBM you can also raise this need through support and that will get it more visibility. > Salesforce translator should support nested joins > ------------------------------------------------- > > Key: TEIID-5861 > URL: https://issues.redhat.com/browse/TEIID-5861 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: Backlog > > Original Estimate: 2 days > Remaining Estimate: 2 days > > For this SQL we have wrong generated SOQL > {code} > select > price.Id, > price.IsActive__c, > price.name, > price.PriceBook__c, > book.DefaultCurrency__c, > price.Price__c, > price.ProductCode__c, > price.ProductName__c, > price.Product__c, > product.Id, > product.Name, > product.Description > from > MSRP__c as price > left outer join /*+ MAKEDEP */ Product2 as product on > price.Product__c = product.id > left outer join /*+ MAKEDEP */ Pricebook2 as book on > price.PriceBook__c = book.id > where > price.PriceBook__c =:priceBookId > and ProductCode__c in( > :productCodes > ) > and IsActive__c = true" > {code} > {code} > START DATA SRC COMMAND: startTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=3 executionID=2 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sql=SELECT sf.Pricebook2.DefaultCurrency__c FROM sf.Pricebook2 WHERE sf.Pricebook2.Id = 'xxxxx' > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.COMMAND_LOG.SOURCE [Worker0_QueryProcessorQueue1]: SOURCE SRC COMMAND: endTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=2 executionID=1 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sourceCommand=[SELECT MSRP__c.Id, MSRP__c.IsActive__c, MSRP__c.Name, MSRP__c.PriceBook__c, MSRP__c.Price__c, MSRP__c.ProductCode__c, MSRP__c.ProductName__c, MSRP__c.Product__c, Product__r.Id, Product__r.Name, Product__r.Description FROM MSRP__c WHERE (MSRP__c.PriceBook__c = 'xxxx') AND ((MSRP__c.ProductCode__c IN(xxxxx)) AND (MSRP__c.IsActive__c = true))] > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.CONNECTOR [Worker1_QueryProcessorQueue2]: salesforce.9MPiB/GOwB5f.9MPiB/GOwB5f.0.3: Incoming Query: SELECT Pricebook2.DefaultCurrency__c FROM Pricebook2 WHERE Pricebook2.Id = 'xxxx' > [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.COMMAND_LOG.SOURCE [Worker1_QueryProcessorQueue2]: SOURCE SRC COMMAND: endTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=3 executionID=2 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sourceCommand=[Using retrieve: Pricebook2.DefaultCurrency__c Pricebook2 [xxxx]] > {code} > But need to generate one. Because we have two relations in MSRP__c -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5957) enable EXTRACT DOW from timestamp

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5957?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5957: ---------------------------------- Original Estimate: 2 hours Remaining Estimate: 2 hours Story Points: 0.5 > enable EXTRACT DOW from timestamp > --------------------------------- > > Key: TEIID-5957 > URL: https://issues.redhat.com/browse/TEIID-5957 > Project: Teiid > Issue Type: Enhancement > Components: Grammar > Affects Versions: 13.1 > Reporter: Ken Geis > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > Original Estimate: 2 hours > Remaining Estimate: 2 hours > > Similar to TEIID-5896, I would like Teiid to support > {code:sql} > EXTRACT(DOW FROM ...) > {code} > for Tableau compatibility. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5957) enable EXTRACT DOW from timestamp

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5957?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5957: ---------------------------------- Fix Version/s: 15.0 > enable EXTRACT DOW from timestamp > --------------------------------- > > Key: TEIID-5957 > URL: https://issues.redhat.com/browse/TEIID-5957 > Project: Teiid > Issue Type: Enhancement > Components: Grammar > Affects Versions: 13.1 > Reporter: Ken Geis > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > > Similar to TEIID-5896, I would like Teiid to support > {code:sql} > EXTRACT(DOW FROM ...) > {code} > for Tableau compatibility. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-57) Provide Cassandra data source support

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-57?page=com.atlassian.jira.plugi... ] Ramesh Reddy updated TEIIDSB-57: -------------------------------- Sprint: DV Sprint 63, DV Sprint 64 (was: DV Sprint 63) > Provide Cassandra data source support > ------------------------------------- > > Key: TEIIDSB-57 > URL: https://issues.redhat.com/browse/TEIIDSB-57 > Project: Teiid Spring Boot > Issue Type: Feature Request > Components: datasource > Reporter: Ramesh Reddy > Assignee: Aditya Manglam Sharma > Priority: Major > Fix For: 1.5.0 > > > Provide data source support for Cassandra -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-203) A .vdb file nested inside the Spring Repackage jar can not be read

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-203?page=com.atlassian.jira.plug... ] Work on TEIIDSB-203 started by Ramesh Reddy. -------------------------------------------- > A .vdb file nested inside the Spring Repackage jar can not be read > ------------------------------------------------------------------ > > Key: TEIIDSB-203 > URL: https://issues.redhat.com/browse/TEIIDSB-203 > Project: Teiid Spring Boot > Issue Type: Bug > Components: core > Affects Versions: 1.4.0 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Major > Fix For: 1.5.0 > > > When user is using a .VDB file as VDB and builds a spring repackage based application, at runtime the loading of the VDB is failed as it is being read as classpath resource. The exception you see is > {code} > Caused by: java.lang.IllegalArgumentException: URI: jar:file:/home/rareddy/development/teiid-spring-boot/samples/vdb/target/spring-vdb-example-1.5.0-SNAPSHOT.jar does not contain path info ex. jar:file:/c:/foo.zip!/BAR > at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.getPath(ZipFileSystemProvider.java:155) ~[jdk.zipfs:na] > at java.base/java.nio.file.Path.of(Path.java:208) ~[na:na] > at java.base/java.nio.file.Paths.get(Paths.java:98) ~[na:na] > at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.uriToPath(ZipFileSystemProvider.java:77) ~[jdk.zipfs:na] > at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.getFileSystem(ZipFileSystemProvider.java:167) ~[jdk.zipfs:na] > at java.base/java.nio.file.FileSystems.getFileSystem(FileSystems.java:231) ~[na:na] > at org.teiid.query.metadata.NioZipFileSystem.mount(NioZipFileSystem.java:67) ~[teiid-engine-14.0.0-SNAPSHOT.jar!/:14.0.0-SNAPSHOT] > at org.teiid.query.metadata.NioZipFileSystem.mount(NioZipFileSystem.java:51) ~[teiid-engine-14.0.0-SNAPSHOT.jar!/:14.0.0-SNAPSHOT] > at org.teiid.spring.autoconfigure.TeiidAutoConfiguration.loadVDB(TeiidAutoConfiguration.java:214) ~[teiid-spring-boot-starter-1.5.0-SNAPSHOT.jar!/:1.5.0-SNAPSHOT] > {code} > basically one cannot read a nested jar files. The issue also explained here https://stackoverflow.com/questions/37634452/urlclassloader-cant-handle-j... -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 7 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2020