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 EMR console by using your Alibaba Cloud account.
  2. In the top navigation bar, select the region where your cluster resides and select a resource group based on your business requirements.
  3. Click the Data Platform tab.
  4. In the Projects section of the page that appears, find the project you want to edit and click Edit Job in the Actions column.
  5. In the Edit Job pane on the left, right-click the folder on which you want to perform operations and select Create Job.
  6. In the Create Job dialog box, specify Name and Description, and select HiveSQL 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
  7. Click OK.
  8. Enter 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
  9. Click Save.