[JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-213?page=com.atlassian.jira.plug... ]
Steven Hawkins commented on TEIIDSB-213:
----------------------------------------
I don't quite follow what is happening here.
Is the query with aliases the Teiid query you are issuing?
What is the source SOQL query that you are seeing as a result?
What is the nature of the problem with the salesforce response to that?
What version of Teiid Spring Boot is this?
If I for example on Teiid/Teiid Spring Boot master issue the Teiid query: "SELECT a.id FROM Opportunity as a where a.amount > 100000000 LIMIT 5"
The SOQL issued is actually: "SELECT Opportunity.Id FROM Opportunity WHERE Opportunity.Amount > 100000000 LIMIT 5" -- the user query alias does not appear.
> We have strange behavior with aliases
> -------------------------------------
>
> Key: TEIIDSB-213
> URL: https://issues.redhat.com/browse/TEIIDSB-213
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: datasource
> Reporter: Renat Eskenin
> Priority: Major
>
> We have two SOQL
> SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
>
> SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5
> This SOQL requests get different responses from SF because in second request we have alias for table.
> It is mystics from SF (we made bug in sf)
> How we can call
> SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
> in Teiid without aliases?
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months
[JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-213?page=com.atlassian.jira.plug... ]
Renat Eskenin updated TEIIDSB-213:
----------------------------------
Description:
We have two SOQL
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5
This SOQL requests get different responses from SF because in second request we have alias for table.
It is mystics from SF (we made bug in sf)
How we can call
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
in Teiid without aliases?
was:
We have two SOQL
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5
This SOQL requests get different responses from SF because in second request we have alias for table.
It is mystics from SF
How we can call
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
in Teiid without aliases?
> We have strange behavior with aliases
> -------------------------------------
>
> Key: TEIIDSB-213
> URL: https://issues.redhat.com/browse/TEIIDSB-213
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: datasource
> Reporter: Renat Eskenin
> Priority: Major
>
> We have two SOQL
> SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
>
> SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5
> This SOQL requests get different responses from SF because in second request we have alias for table.
> It is mystics from SF (we made bug in sf)
> How we can call
> SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
> in Teiid without aliases?
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months
[JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases
by Renat Eskenin (Jira)
Renat Eskenin created TEIIDSB-213:
-------------------------------------
Summary: We have strange behavior with aliases
Key: TEIIDSB-213
URL: https://issues.redhat.com/browse/TEIIDSB-213
Project: Teiid Spring Boot
Issue Type: Bug
Components: datasource
Reporter: Renat Eskenin
We have two SOQL
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5
This SOQL requests get different responses from SF because in second request we have alias for table.
It is mystics from SF
How we can call
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5
in Teiid without aliases?
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months
[JBoss JIRA] (TEIID-5974) Can't Use Console to Change Logging Configuration
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5974?page=com.atlassian.jira.plugi... ]
Steven Hawkins updated TEIID-5974:
----------------------------------
Fix Version/s: 15.0
> Can't Use Console to Change Logging Configuration
> -------------------------------------------------
>
> Key: TEIID-5974
> URL: https://issues.redhat.com/browse/TEIID-5974
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 12.2
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 15.0
>
>
> Could be a problem on my end, but Installing this version with Wildfly does not let me access the configuration->logging web console page. It comes up blank. I use this to change the command logging level on a running server.
> Seems to happen in version 13, also.
> I tried using the checkboxes in subsystem>teiid>configure>logging but they did not seem to change the level.
>
> Please let me know if this if reproducible for you.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months
[JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugi... ]
Renat Eskenin commented on TEIID-5962:
--------------------------------------
Ok, I will try
> Teiid locks many threads when Salesforce is disconnected
> --------------------------------------------------------
>
> Key: TEIID-5962
> URL: https://issues.redhat.com/browse/TEIID-5962
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 12.3.1
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
> Attachments: Снимок экрана от 2020-05-31 11-09-10.png
>
> Original Estimate: 1 hour
> Time Spent: 45 minutes
> Remaining Estimate: 15 minutes
>
> We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service.
> Why teiid do not send response as "Salesforce is down - error" or connection timeout?
> Micro schema:
> HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months
[JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugi... ]
Steven Hawkins commented on TEIID-5962:
---------------------------------------
In general fork and then clone the git repository, then add your changes locally, push them and open a pull request.
> Teiid locks many threads when Salesforce is disconnected
> --------------------------------------------------------
>
> Key: TEIID-5962
> URL: https://issues.redhat.com/browse/TEIID-5962
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 12.3.1
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
> Attachments: Снимок экрана от 2020-05-31 11-09-10.png
>
> Original Estimate: 1 hour
> Time Spent: 45 minutes
> Remaining Estimate: 15 minutes
>
> We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service.
> Why teiid do not send response as "Salesforce is down - error" or connection timeout?
> Micro schema:
> HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months
[JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected
by Renat Eskenin (Jira)
[ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugi... ]
Renat Eskenin commented on TEIID-5962:
--------------------------------------
Hi! How to contribute to teiid spring boot? I have some modifications in salesforce connection and connection fabric.
> Teiid locks many threads when Salesforce is disconnected
> --------------------------------------------------------
>
> Key: TEIID-5962
> URL: https://issues.redhat.com/browse/TEIID-5962
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 12.3.1
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
> Attachments: Снимок экрана от 2020-05-31 11-09-10.png
>
> Original Estimate: 1 hour
> Time Spent: 45 minutes
> Remaining Estimate: 15 minutes
>
> We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service.
> Why teiid do not send response as "Salesforce is down - error" or connection timeout?
> Micro schema:
> HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months
[JBoss JIRA] (TEIID-5950) Create an athena translator
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5950?focusedWorklogId=12451587&pag... ]
Steven Hawkins logged work on TEIID-5950:
-----------------------------------------
Author: Steven Hawkins
Created on: 25/Jun/20 2:14 PM
Start Date: 25/Jun/20 2:14 PM
Worklog Time Spent: 2 hours
Issue Time Tracking
-------------------
Remaining Estimate: 2 hours (was: 4 hours)
Time Spent: 2 hours
Worklog Id: (was: 12451587)
> Create an athena translator
> ---------------------------
>
> Key: TEIID-5950
> URL: https://issues.redhat.com/browse/TEIID-5950
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 15.0
>
> Original Estimate: 4 hours
> Time Spent: 2 hours
> Remaining Estimate: 2 hours
>
> There have been several issues seen with athena using the jdbc ansi translator - subquery support and bind variables specifically. There should be a specific translator so that we can account for those better.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months
[JBoss JIRA] (TEIID-5950) Create an athena translator
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5950?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-5950.
-----------------------------------
Resolution: Done
Added a simply extension of the prestodb translator to account for ENTESB-13704 and ENTESB-13703. There will likely be more issues to address with broader usage. Also things my further bifurcate when we account for the presto db / sql split.
> Create an athena translator
> ---------------------------
>
> Key: TEIID-5950
> URL: https://issues.redhat.com/browse/TEIID-5950
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 15.0
>
> Original Estimate: 4 hours
> Remaining Estimate: 4 hours
>
> There have been several issues seen with athena using the jdbc ansi translator - subquery support and bind variables specifically. There should be a specific translator so that we can account for those better.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 9 months