[
https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin...
]
sameer P edited comment on TEIID-4284 at 10/10/16 9:12 AM:
-----------------------------------------------------------
Hi [~shawkins], regarding the query I submitted, Its exactly
{code:java}
SELECT /*+ sh source:'bulk' */ * FROM
"source"."test_table_vz__c"
{code}
where source is the Salesforce Datasource. This I happened to notice because there was
not much difference with the Bulk API with the huge data. So, I tried to debug the teiid
code and I noticed that *(context.getSourceHints() != null &&
context.getSourceHints().contains("bulk")* condition fails. And about changing
the source, I just removed this condition from the if block.
was (Author: sameerp):
Hi [~shawkins], regarding the query I submitted, Its exactly
{code:java}
SELECT /*+ sh source:'bulk' */ * FROM
"source"."test_table_vz__c"
{code}
where source is the Salesforce Datasource. This I happened to notice because there was
not much difference with the Bulk API with the huge data. So, I tried to debug the teiid
code and I noticed that * (context.getSourceHints() != null &&
context.getSourceHints().contains("bulk") * condition fails. And about changing
the source, I just removed this condition from the if block.
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_asy...
.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)