Skip to main content
Pentaho Documentation

Amazon Hive Job Executor

Parent article

The Amazon Hive Job Executor entry runs Hive jobs in the Amazon Elastic MapReduce (EMR) tool. You can use this entry to access the job flows in your Amazon Web Services (AWS) account.

Before you begin

You must have an AWS account configured for EMR to use this entry, and a Hive script created to control the remote job.

General

Enter the following information in the job entry field:

  • Entry name: Specifies the unique name of the Amazon Hive Job Executor entry on the canvas. You can customize the name or leave it as the default.

Options

The Amazon Hive Job Executor entry features tabs for Hive and job settings. Each tab is described below.

Hive settings tab

Hive settings tab, Amazon Hive Job             Executor

This tab includes options for connecting to your AWS account and cluster.

AWS connection

Use the following options to specify your AWS account:

OptionDescription
Access keySpecify the unique identifier for your account. Your Access key combined with your Secret key are used to sign AWS requests. A signed request identifies the sender and prevents the request from being altered.
Secret keySpecify the encoded key generated from either your AWS account, individual Identity and Access Management (IAM) users, or temporary sessions. Your Secret key combined with your Access key are used to sign AWS requests. A signed request identifies the sender and prevents the request from being altered.
RegionSelect which isolated Amazon Elastic Compute Cloud (EC2) geographical area you want use to execute your job flow. The regions available in this list depend on your AWS account. See https://docs.aws.amazon.com/AWSEC2/l...lability-zones for more information.

Click Connect to establish the connection.

Cluster

Select New if you want to create a new job flow (cluster), or Existing if you already have a job flow ID. Your job flow specifies all the functions you are trying to apply to your data. The ID identifies the job flow.

If you select New, use the following options to generate a new job flow:

OptionDescription
EC2 roleSelect the Amazon EC2 instance of the EMR role within your cluster. The processes that run on cluster instances use this role when they call other AWS services. The instances available in this list depend on your AWS account.
EMR roleSelect the role that permits Amazon EMR to call other AWS services such as Amazon EC2 on your behalf. See https://docs.aws.amazon.com/emr/late...iam-roles.html for more information. The roles available in this list depend on your AWS account.
Master instance typeSelect the Amazon EC2 instance type that will act as the Hadoop master in the cluster. This type will handle MapReduce task distribution.
Slave instance typeSelect the Amazon EC2 instance type that will act as one or more Hadoop slaves in the cluster. Slaves are assigned tasks from the master. This setup is only valid if the number of instances is greater than 1.
EMR releaseSelect the EMR Hadoop cluster release version, which defines the set of service components and their versions.
Number of instancesSpecify the number of Amazon EC2 instances you want to assign to this job.
Bootstrap actionsSpecify references to the scripts you want to execute before the node begins processing data. See https://docs.aws.amazon.com/emr/late...bootstrap.html for more information.

If you select Existing, specify the existing ID through the Existing JobFlow ID option.

Job settings tab

Job settings tab, Amazon Hive Job Executor

This tab includes the following options:

OptionDescription
Hive job flow nameSpecify the name of the Hive job flow to execute.
S3 staging directorySpecify the Amazon Simple Storage Service (S3) address for the container of stored objects (the bucket) in which your job flow logs will be stored. Artifacts required for execution (for example, Hive Script) will also be stored in this bucket before execution.
Hive scriptSpecify the address of the Hive script to execute within Amazon S3 or on your local file system.
Command line argumentsEnter in any command line arguments you want to pass into the specified Hive script. Use spaces to separate multiple arguments.
Keep job flow aliveSelect if you want to keep your job flow active after the PDI entry finishes. If this option is not selected, the job flow will terminate when the PDI entry finishes.
Enabling blocking

Select if you want the PDI entry to wait until the EMR Hive job completes. Blocking is the only way for PDI to be aware of the status of a Hive job. Additionally, selecting this option enables proper error handling and routing.

When you clear this option, the Hive job is blindly executed and PDI moves on to the next entry.

Logging intervalIf you Enable blocking, specify the number of seconds between status log messages.