[teiid-issues] [JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

[sameer P (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13304851#comment-13304851 ] 

sameer P commented on TEIID-4284:
---------------------------------

Hi [~shawkins], [~rareddy]. I tried with the latest salesforce v34 and looks like there is something wrong. As I debugged and checked, the source hint will not be considered at all by the *QueryExecutionImpl* as *(context.getSourceHints() != null && context.getSourceHints().contains("bulk")* is false always irrespective of the source hint I specify (looks like *bulk*  is not a keyword yet in the query parser). And, when I  removed this condition at all which checks the source hint, it goes in an infinite loop for the second query, with huge many requests and it does not return from it. Am I missing something here? or am I doing something wrong? .  

> Implement Salesforce Bulk API for SELECTS to Salesforce Connector
> -----------------------------------------------------------------
>
>                 Key: TEIID-4284
>                 URL: https://issues.jboss.org/browse/TEIID-4284
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Salesforce Connector
>    Affects Versions: 8.13.5
>         Environment: With Salesforce datasource
>            Reporter: sameer P
>            Assignee: Steven Hawkins
>             Fix For: 9.1
>
>
> There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT.  
> The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_code_curl_walkthrough_pk_chunking.htm . 



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)