E-MapReduce:Configure a Hive SQL job

Create and configure a Hive SQL job

1. Log on to the Alibaba Cloud EMR console.

2. In the top navigation bar, select the region where your cluster resides and select a resource group.

3. Click the Data Platform tab.

4. In the Projects section, find your project and click Edit Job in the Actions column.

5. In the Edit Job pane, right-click a folder and select Create Job.

6. In the Create Job dialog box, enter a name and description, and select HiveSQL from the Job Type drop-down list.

   

7. Click OK.

8. In the Content field, enter your Hive SQL statements. For example:

   -- 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;

   Statement	Description
   show databases;	Lists all databases in the Hive metastore.
   show tables;	Lists all tables in the current database.
   select * from test1;	Queries all rows from test1. EMR automatically applies LIMIT 2000 to SELECT statements.

   SQL statements cannot exceed 64 KB.

   

9. Click Save.