E-MapReduce:Hive SQL job configuration

Procedure

1. Go to the Projects page in Data Platform.

   1. Log in to the E-MapReduce console with your Alibaba Cloud account.

   2. In the top navigation bar, select the region and resource group.
      

   3. Click the Data Development tab.

2. In the row of the project you want to edit, click Edit Job.

3. Create a Hive SQL job.
   1. On the left side of the page, right-click the target folder and select Create Job.
   2. In the Create Job dialog box, enter a Job Name and Job Description, and select Hive SQL from the Job Type drop-down list.
      EMR submits this type of job by running the following command:

      hive -e {SQL CONTENT}

      SQL_CONTENTIn this command, is the SQL statements that you enter in the job editor.
   3. Click OK.
4. Edit the job content.
   1. In the Content field, enter the Hive SQL statements.

      -- Example SQL statements.
      -- The maximum size of the SQL statements is 64 KB.
      show databases;
      show tables;
      -- The system automatically adds 'LIMIT 2000' to SELECT statements.
      select * from test1;

   2. Click Save.