---
schema_version: "1"
id: bd36deb4a61dbcf8a7c7a6eabe00a128ea31c23445a1990f399bb4969d138007
title: Understanding Bulk API 2.0 Query
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/api-asynch/guides/api-bulk-v2/bulk-query/queries.md
canonical_url: https://developer.salesforce.com/docs/platform/api-asynch/guide/queries.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 403465fe8772e4a52441b6b60811254f3f4960e1a78b514b199218e781ea9974
products:
  - Bulk API 2.0 and Bulk API Developer Guide
  - Platform Developer Content
---

# Understanding Bulk API 2.0 Query

Learn about Bulk API 2.0 query availability, supported methods, and SOQL considerations.

Bulk API 2.0 query jobs enable asynchronous processing of SOQL queries. There is always an empty “parent” batch which is related to the initial upload, followed by sub-batches for processing the upload in parallel. The API automatically handles retries. If you receive a message that the API retried more than 15 times, apply a filter criteria and try again. When you get the results of a query job, the response body is always compressed.

## Availability

Query jobs in Bulk API 2.0 are available in API version 47.0 and later.

## Supported URIs and Methods

This table lists the URIs and methods supported by queries in Bulk API 2.0.

| URI                                                  | HTTP Method | Description                                       |
| ---------------------------------------------------- | ----------- | ------------------------------------------------- |
| `/services/data/vXX.X/jobs/query`                    | POST        | Creates a query job.                              |
| `/services/data/vXX.X/jobs/query`                    | GET         | Gets information about all query jobs in the org. |
| `/services/data/vXX.X/jobs/query/queryJobId`         | GET         | Gets information about one query job.             |
| `/services/data/vXX.X/jobs/query/queryJobId/results` | GET         | Gets the results for a query job.                 |
| `/services/data/vXX.X/jobs/query/queryJobId`         | PATCH       | Aborts a query job.                               |
| `/services/data/vXX.X/jobs/query/queryJobId`         | DELETE      | Deletes a query job.                              |

## Chunking Query Jobs

Bulk API 2.0 is optimized to chunk large query jobs if the object being queried supports chunking. This optimization includes custom objects, and any Sharing and History tables that support standard objects. Instead of manually configuring batches, Bulk API 2.0 query jobs automatically determine the best way to divide your query job into smaller chunks, helping to avoid failures or timeouts.

To determine whether an object supports PK chunking, refer to the `isPkChunkingSupported` field in the response body of the [Get Information About a Query Job](https://developer.salesforce.com/docs/platform/api-asynch/guide/query-get-one-job.md) query.

## SOQL Considerations

LIMIT and ORDER BY disable PKChunking for SOQL queries. With PKChunking disabled, queries take longer to execute, and potentially result in query timeouts. If ORDER BY or LIMIT is used, and you experience query time outs, then remove the ORDER BY or LIMIT clause before any subsequent troubleshooting.

Bulk API 2.0 doesn’t support SOQL queries that include any of these items:

- GROUP BY, OFFSET, or TYPEOF clauses.
- Aggregate Functions such as `COUNT()`.
- Date functions in GROUP BY clauses. (Date functions in WHERE clauses are supported.)
- Compound address fields or compound geolocation fields. (Instead, query the individual components of compound fields.)
- Parent-to-child [relationship queries](https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_understanding.htm). (Child-to-parent relationship queries are supported.)