[
https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin...
]
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_asy...
.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)