# Querying Data

Treasure Data allows users to issues queries from the following:

* TD Console
* API
* JDBC/ODBC
* Scheduled queries
* Hosted workflow execution framework


Every query is managed as separate jobs, and for each job you can specify the one of these data processing engines:

* [Presto](https://api-docs.treasuredata.com/en/tools/presto/quickstart/#how-presto-works) for ad hoc and shorter batch workloads. Presto provides low-latency SQL access to the data set.
* [Hive](https://api-docs.treasuredata.com/en/tools/hive/quickstart/#about-the-hive-engine) for large or complex batch workloads. Hive is a MapReduce-based SQL engine. This engine is very powerful and can support large data processing and heavy JOINs. This is often used for "extract, transform, and load" (ETL) or sessionization.


For additional detail about the differences between the query engines see [Choosing an Analytics Engine](https://api-docs.treasuredata.com/en/tools/hive/quickstart/#choosing-an-analytics-engine).

The following topics are covered in this section:

* [About Queries](/products/customer-data-platform/data-workbench/queries)
* [Specifying Your Query Engine for a Specific Query](/products/customer-data-platform/data-workbench/queries/specifying-the-query-engine-for-a-specific-query)
* [Creating or Editing a Query in the TD Console](/products/customer-data-platform/data-workbench/queries/creating-or-editing-a-query)
* [Defining a Query in the TD Console](/products/customer-data-platform/data-workbench/queries/defining-a-query)
* [Scheduling a Query in the TD Console](/products/customer-data-platform/data-workbench/queries/scheduling-a-query)
* [Running Queries in the TD Console](/products/customer-data-platform/data-workbench/getting-started/run-a-query-and-download-results)


Reference information can be found here:

* [Treasure Data Hive Function Reference](https://api-docs.treasuredata.com/en/tools/hive/td_hive_function_reference/#treasure-data-hive-function-reference)
* [Hivemall Function Reference](https://api-docs.treasuredata.com/en/tools/hive/hivemall_reference/#hivemall-function-reference)
* [Treasure Data Presto API Reference](https://api-docs.treasuredata.com/en/tools/presto/api/#td-presto-api-reference)


Additional [Hive documentation](https://api-docs.treasuredata.com/en/tools/hive/quickstart/#about-the-hive-engine) and [Presto documentation](https://api-docs.treasuredata.com/en/tools/hive/quickstart/#about-the-hive-engine) can be found on the [Treasure Data Developer Portal](https://api-docs.treasuredata.com/).