February 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5860: --------------------------------------- I was able to update the visitor logic to use named tables rather than source names so that it can differentiate between the sides of a self join. However the execution/results logic is not equipped to handle the self join scenario as it only finds results by object type. So this will take longer than expected. > Salesforce translator should support self joins > ----------------------------------------------- > > Key: TEIID-5860 > URL: https://issues.redhat.com/browse/TEIID-5860 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > In this query > {code} > SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber > {code} > We have two requests to salesforce, but could generate a single SOQL query. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5846: -------------------------------------- Thanks! > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 3 hours > Remaining Estimate: 0 minutes > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5846: --------------------------------------- You should see commit links on the right hand side of an issue under the Development heading. > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 3 hours > Remaining Estimate: 0 minutes > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugi... ] Ramesh Reddy updated TEIID-5860: -------------------------------- Sprint: DV Sprint 59 > Salesforce translator should support self joins > ----------------------------------------------- > > Key: TEIID-5860 > URL: https://issues.redhat.com/browse/TEIID-5860 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > In this query > {code} > SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber > {code} > We have two requests to salesforce, but could generate a single SOQL query. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugi... ] Ramesh Reddy updated TEIID-5860: -------------------------------- Sprint: (was: DV Sprint 59) > Salesforce translator should support self joins > ----------------------------------------------- > > Key: TEIID-5860 > URL: https://issues.redhat.com/browse/TEIID-5860 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > In this query > {code} > SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber > {code} > We have two requests to salesforce, but could generate a single SOQL query. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5846: -------------------------------------- Hi! Can you give link to commit with this functionality? > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 3 hours > Remaining Estimate: 0 minutes > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5846. ----------------------------------- Resolution: Done [~rareddy] it turns salesforce does provide the filter/search metadata. For some reason that was never utilized... Updated the metadata processor to consult the field level metadata. > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?focusedWorklogId=12450059&pag... ] Steven Hawkins logged work on TEIID-5846: ----------------------------------------- Author: Steven Hawkins Created on: 07/Feb/20 11:02 AM Start Date: 07/Feb/20 11:01 AM Worklog Time Spent: 3 hours Issue Time Tracking ------------------- Remaining Estimate: 0 minutes (was: 3 hours) Time Spent: 3 hours Worklog Id: (was: 12450059) > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 3 hours > Remaining Estimate: 0 minutes > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5860: ---------------------------------- Original Estimate: 3 hours Remaining Estimate: 3 hours Story Points: 0.5 Sprint: DV Sprint 59 > Salesforce translator should support self joins > ----------------------------------------------- > > Key: TEIID-5860 > URL: https://issues.redhat.com/browse/TEIID-5860 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > In this query > {code} > SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber > {code} > We have two requests to salesforce, but could generate a single SOQL query. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5846: ---------------------------------- Original Estimate: 3 hours Remaining Estimate: 3 hours Story Points: 0.5 Sprint: DV Sprint 59 > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2020