Composing a DB Query

You can query an existing data store using the query composer on the Workbench page.

Prerequisite

You must have an existing data store to query it. You can create a data store from the Explore page.

Note

You can run these commands without bringing up a cluster. See Mapping of Cluster and Command Types for more information.

Perform the following steps to query an existing data store:

  1. Navigate to the Workbench page and click + Create New. Select Db Query from drop-down list near the center of the top of the page.

  2. Query Statement is selected by default from the drop-down list near the right side of the top of the page. Enter the DB query in the text field.

    -or-

    To run a stored query, select Query Path from the drop-down list, then specify the Cloud storage path that contains the DB query file.

  3. From the Select a Data Store drop-down list, select the data store to which the query is to be applied.

  4. Click Run to execute the query.

  5. The query result is displayed in the Results tab and the query logs in the Logs tab. For more information on how to download command results and logs, see Downloading Results and Logs.