...

Additional Configuration for YARN Shims

To get information on configuring EMR shims, click here.

Configuring CDH, HDP, and MapR Shims

Prerequisite: Make sure that your client has been configured so it can access any node in your cluster.

1. If you are looking for Amazon EMR instructions, please go here.   
2. Set the active Hadoop distribution.
3. Configure the cluster settings. 

NOTE: For all supported hadoop distributions except MapR, add the yarn user on the cluster to the group defined by dfs.permissions.superusergroup property. The dfs.permissions.superusergroup property can be found in hdfs-site.xml file on your cluster or in the cluster management application.
3. Navigate to the folder that contains the shim, then open the yarn-site.xml file in a text editor.  Adjust the following parameters as needed.

...

4. (CDH 5.1 and 5.2 only): * Navigate to the folder that contains the shim, then open the hive-site.xml file in a text editor. Modify the hive.metastore.uris property so that it points to the location of your hive metastore. Save and close the hive-site.xml file.

5. (All shims): Navigate to the folder that contains the shim, then open the mapred-site.xml file, in a text editor. Then make the changes in the table.

<name>mapreduce.app-submission.cross-platform</name>
<value>true</value>

6. (HDP 2.2): In the mapred-site.xml file, make the changes shown in the table.

<property>
    <name>mapreduce.application.classpath</name>
    <value>$PWD/mr-framework/hadoop/share/hadoop/mapreduce/*
:$PWD/mr-framework/hadoop/share/hadoop/mapreduce/lib/*
:$PWD/mr-framework/hadoop/share/hadoop/common/*:$PWD/mr-framework/hadoop/share/hadoop/common/lib/*
:$PWD/mr-framework/hadoop/share/hadoop/yarn/*:$PWD/mr-framework/hadoop/share/hadoop/yarn/lib/*
:$PWD/mr-framework/hadoop/share/hadoop/hdfs/*:$PWD/mr-framework/hadoop/share/hadoop/hdfs/lib/*
:/usr/hdp/${hdp.version}/hadoop/lib/hadoop-lzo-0.6.0.${hdp.version}.jar:/etc/hadoop/conf/secure<secure
</value>
  </property>

<property>
 <name>mapreduce.application.framework.path</name>
 <value>/hdp/apps/${hdp.version}/mapreduce/mapreduce.tar.gz#mr-framework</value>
 </property> 

...

java.system.hdp.version=2.2.0.0-2041

Note: Not all shim properties can be set in the Spoon user interface, nor are instructions for modifying them listed here. If you need to set additional properties that are not addressed in these instructions, you will need to set them manually in the *-site.xml files that are in the shim directory. Consult your Hadoop distribution's vendor for details about the properties you want to set.

High Availability for CDH 5.3

Note: If you are configuring CDH 5.3 to be used in High Availability mode, we recommend that you use the Cloudera Manager "Download Client Configuration" feature. The Download Client Configuration

...

feature provides a convenient way to get configuration files from the cluster for a service (such as HBase, HDFS, or Yarn). Use this feature to download the unzip the configuration zip files to the pentaho-big-data-plugin/hadoop-configurations/cdh5x directory.​For more information on how to do this, see Cloudera documentation:
http://www.cloudera.com/content/cloudera/en/documentation/core/v5-3-x/topics/cm_mc_client_config.html.

Configuring EMR Shims

EMR is an Amazon Web Service (AWS) for big data processing and analysis that is a popular alternative to hosting in-house cluster computing. 

NOTENote: Pentaho  Pentaho does not support HBase on HDFS in EMR 3.4.

Versions Supported

The versions of EMR that Pentaho supports for 5.4 appears in the Support Matrix.

Prerequisiteshttps://help.pentaho.com/Draft_Content/Chantel_5.4_Work/Big_Data_Placeholder/020/010?action=edit&sectionId=3

...

Prerequisites

• Set the active Hadoop distribution.
• PDI should be installed on an EC2 instance. 
• A working EC2 cluster should already be set up and configured.
• We also recommend also recommend that you review Amazon review Amazon EMR documentation.  Here are a few links to get you started.
  • http://docs.aws.amazon.com/ElasticMapReduce/latest/DeveloperGuide/emr-what-is-emr.html
  • http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/concepts.html
  • http://docs.aws.amazon.com/AmazonVPC/latest/GettingStartedGuide/ExerciseOverview.html
  • http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_Introduction.html
  • http://docs.aws.amazon.com/AmazonVPC/latest/NetworkAdminGuide/Welcome.html
  • http://docs.aws.amazon.com/AmazonS3/latest/dev/Welcome.html

Copy *-site.xml

...

Cluster Files To PDI Directories 

Copy the core-site.xml,   hdfs-site.xml,   httpfs-site.xml,   mapred-site.xml,   yarn-site.xml, and and emrfs-site.xml files to these directories: 

• data-integration/plugins/pentaho-big-data-plugin/hadoop-configurations/emr3x
• server/data-integration-server/pentaho-solutions/system/kettle/plugins/pentaho-big-data-plugin/hadoop-configurations/emr3x

Edit *-site.xml Files in

...

PDI Directories 

Edit *-site.xml files using the instructions that follow.
If Note:  If you need more information, consult the Apache documentation for Apache documentation for additional details about the properties below.

Edit the core-site.xml

...

File 

Open the core-site.xml file and do these things.

Add these lines. Enter your AWS Access Key ID and Access Key as indicated.

In the core-site.xml file, change this:

...

1

...

<property>

...

2

...

<name>fs.s3n.impl</name>

...

3

<property>   
   <name>fs.s3.awsAccessKeyId</name>   
   <value>[INSERT YOUR VALUE HERE]</value>
</property>


<property>   
   <name>fs.s3.awsSecretAccessKey</name>   
   <value>[INSERT YOUR VALUE HERE]</value>
</property>

If needed enter the AWS Access Key ID and Access Key for S3N, like this:

<property>
   <name>fs.s3n.awsAccessKeyId</name>
   <value>[INSERT YOUR VALUE HERE]</value>
</property>

<property>
   <name>fs.s3n.awsSecretAccessKey</name>
   <value>[INSERT YOUR VALUE HERE]</value>
</property>

Then, change this:

<property>   
   <name>fs.s3n.impl</name>   
   <value>com.amazon.ws.emr.hadoop.fs.EmrFileSystem</value>

...

4

...

</property>

...

5

...

<property>

...

6

</property> 


<property>   
   <name>fs.s3.impl</

...

7

name>   
   <value>com.amazon.ws.emr.hadoop.fs.EmrFileSystem</value>

...

8

</property>

to this:

...

...

<property>

...

2

...

<property>
   <name>fs.s3n.impl</name>

...

3

...

   <value>org.apache.hadoop.fs.

...

s3native.

...

NativeS3FileSystem</value>

...

4

</property>

...

5

...

<property>

...

6

...

<property>
   <name>fs.s3.impl</name>

...

7

...

   <value>org.apache.hadoop.fs.

...

s3.

...

S3FileSystem</value>

...

8

</property>

Edit

...

the mapred-site.xml

...

File 

Navigate to the folder that contains the shim, then open the the mapred-site.xml  filefile, in a text editor.  Then Then make the changes in the table.  When you are finished, save and close the file.

<name>mapreduce.app-submission.cross-platform</name>

<value>true</value>

...

...

...

...

...

Configure for LZO

...

Compression 

LZO is a compression format that EMR supports.  If you want to configure for LZO compressionLZO compression, you will need to download a jar file.  If If you do not, you will need to remove a parameter from the the core-site.xml  filefile.

1. If you are not going to use LZO compression:

...

1. Remove any references to

...

1. the io.compression.codecs parameter in the core-site.xml

...

1. file:

...

1. com.hadoop.compression.lzo.LzoCodec
2. If you are going to use LZO compression:

...

1.  Download the LZO jar and add it

...

1. to pentaho-big-data-plugin/hadoop-configurations/emr3x/lib

...

1. directory.  The

...

1. LZO jar can be found here:

...

1. http://maven.twttr.com/com/hadoop/gplcompression/hadoop-lzo/0.4.19

...

High Availability for CDH 5.3

...

1. /

...