You need to sign in to do that
Don't have an account?
deepak_naik
Bulk Query with PK chunking enabled where is the location of the original batch when we read the BatchInfo[] from the Bulk Job Id
For bulk query jobs if the job has PK chunking enabled, will the original batch (that contains the query when the subsequent batches are created) will be created with the id as "0" in an BatchInfo List
For example if we have the following
BatchInfo[] bListInfo = bulkConnection.getBatchInfoList(job.getId()).getBatchInfo();
Will the Original Query Batch will always be in bListInfo[0] ? If not, how can this be ensured
For example if we have the following
BatchInfo[] bListInfo = bulkConnection.getBatchInfoList(job.getId()).getBatchInfo();
Will the Original Query Batch will always be in bListInfo[0] ? If not, how can this be ensured
The batch which will be returned with the createBatchFromStream() API is the "original" batch, and we need to wait for the state of this batch to be as "BatchStateEnum.NotProcessed", to make sure that all the batches have completed processing.
The code method for doBulkQuery() is as follows
All Answers
"Not Processed: The batch won’t be processed. This state is assigned when a job is aborted while the batch is queued. For bulk queries, if the job has PK chunking enabled, this state is assigned to the original batch that contains the query when the subsequent batches are created. After the original batch is changed to this state, you can monitor the subsequent batches and retrieve each batch’s results when it’s completed. Then you can safely close the job"
But how do I identify this original batch from the list of batches
The batch which will be returned with the createBatchFromStream() API is the "original" batch, and we need to wait for the state of this batch to be as "BatchStateEnum.NotProcessed", to make sure that all the batches have completed processing.
The code method for doBulkQuery() is as follows