This topic describes how to configure a Hive SQL job.

Prerequisites

A project is created. For more information, see Manage projects.

Procedure

  1. Log on to the Alibaba Cloud E-MapReduce console with an Alibaba Cloud account.
  2. Click the Data Platform tab.
  3. In the Projects section, click Edit Job in the row of a project.
  4. In the left-side navigation pane, right-click the required folder and choose Create Job from the shortcut menu.
    Note You can also right-click the folder to create a subfolder, rename the folder, or delete the folder.
  5. In the dialog box that appears, set the Name and Description parameters, and select Hive SQL from the Job Type drop-down list.
    This option indicates that a Hive SQL job will be created. You can use the following command syntax to submit a Hive SQL job:
    hive -e {SQL CONTENT}

    SQL CONTENT refers to the SQL statements that you enter in the job editor.

    HiveSQL
  6. Click OK.
  7. Enter the Hive SQL statements in the Content field.
    -- SQL statement example
    -- The size of SQL statements cannot exceed 64 KB.
    show databases;
    show tables;
    -- LIMIT 2000 is automatically used for the SELECT statement.
    select * from test1;
    HiveSQL_content
  8. Click Save.