Composing a Workflow QueryΒΆ

When more than one command has to be executed in a sequence, use the query composer on the Analyze page to compose a workflow query. (For REST API-related information, see Submit a Composite Command.)

Note

Hadoop-2, Presto, and Spark clusters support workflow queries. However, cluster support depends on the type of query in a sequence. See Mapping of Cluster and Command Types for more information.

Perform the following steps to compose a workflow query:

Note

Using the Supported Keyboard Shortcuts in Analyze describes the supported keyboard shortcuts.

  1. Navigate to the Analyze page and click Compose.

  2. Select Workflow from the Command Type drop-down list. The query composer is displayed as shown below.

    ../../_images/ComposeWorkflowA1.png
  3. Click + Add Command to create a new query. After you click it, the query composer is displayed as shown below.

    ../../_images/ComposeWorkflowB1.png
  4. Select the type of command that you want from the Select Command Type drop-down list.

  5. Compose the query and click + Add Command to add another query. Repeat steps 2-4 to add the next type of query. Similarly, you can add the required number of queries to be executed in a sequence.

    The following figure displays a workflow query composed to execute a data import, Hive, and data export query in the same order.

    ../../_images/ComposeWorkflow1.png
  6. Click Run to execute the query. Click Save if you want to run the same query later. (See Workspace for more information on saving queries.)

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