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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4284:
---------------------------------------

> As I debugged and checked, the source hint will not be considered at all by the QueryExecutionImpl

More than likely there's an issue with your user query.  What are you submitting?

> like bulk is not a keyword yet in the query parser

As a hint, it is not expected to be.

>  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?

You mean you are modifying the source?  I can't really say without fully say what you are seeing without seeing the full change you are making.

> 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)