This page shows how to operate Hive on MR3 on Amazon EKS with autoscaling. By following the instruction, the user will learn:
- how to create and configure an EKS cluster for running Hive on MR3 with autoscaling
- how to run Hive on MR3 in the EKS cluster
This scenario has the following prerequisites:
- The user can create an EKS cluster with the command
eksctl. - The user can create and update IAM policies.
- The user either can create EFS or has access to an S3 bucket for storing transient data.
- The user can configure LoadBalancers.
- A database server for Metastore is running and accessible from the EKS cluster.
- The user has access to an S3 bucket storing the warehouse and all S3 buckets containing datasets.
- The user can run Beeline to connect to HiveServer2 running at a given address.
The user may create new resources (such as IAM policies) either on the AWS console or by executing AWS CLI.
Although this page is self-contained, we recommend the user to read the page on Autoscaling and the guide on running Hive on MR3 on Amazon EKS before proceeding. Since Amazon EKS is a particular case of Kubernetes, it also helps to try running Hive on MR3 on Minikube as explained in the page On Minikube.
We use a pre-built Docker image mr3project/hive3:1.4 available at DockerHub,
so the user does not have to build a new Docker image.
In our example, we use a MySQL server for Metastore, but Postgres and MS SQL are also okay.
This scenario should take 1 hour to 2 hours to complete, including the time for creating an EKS cluster.
This page has been tested with MR3 release 1.4 and eksctl 0.86.0.
Installation
Download an MR3 release containing the executable scripts.
$ git clone https://github.com/mr3project/mr3-run-k8s.git
$ cd mr3-run-k8s/kubernetes/
$ git reset --hard 472f095a54c51ec51a78eb446ffdcee58445f21f
Restore those files created for Amazon EKS.
$ mv -f env.sh.eks env.sh
$ mv -f conf/core-site.xml.eks conf/core-site.xml
$ mv -f conf/mr3-site.xml.eks conf/mr3-site.xml
$ mv -f conf/hive-site.xml.eks conf/hive-site.xml
$ mv -f yaml/metastore.yaml.eks yaml/metastore.yaml
$ mv -f yaml/hive.yaml.eks yaml/hive.yaml
$ mv -f yaml/ranger.yaml.eks yaml/ranger.yaml
$ mv -f yaml/ats.yaml.eks yaml/ats.yaml
IAM policy for autoscaling
Create an IAM policy EKSAutoScalingWorkerPolicy.
Get the ARN (Amazon Resource Name) of the IAM policy.
$ vi EKSAutoScalingWorkerPolicy.json
{
"Version": "2012-10-17",
"Statement": [
{
"Action": [
"autoscaling:DescribeAutoScalingGroups",
"autoscaling:DescribeAutoScalingInstances",
"autoscaling:DescribeLaunchConfigurations",
"autoscaling:DescribeTags",
"autoscaling:SetDesiredCapacity",
"autoscaling:TerminateInstanceInAutoScalingGroup",
"ec2:DescribeLaunchTemplateVersions"
],
"Resource": "*",
"Effect": "Allow"
}
]
}
$ aws iam create-policy --policy-name EKSAutoScalingWorkerPolicy --policy-document file://EKSAutoScalingWorkerPolicy.json
{
"Policy": {
...
"Arn": "arn:aws:iam::111111111111:policy/EKSAutoScalingWorkerPolicy",
...
IAM policy for accessing S3 buckets
Create an IAM policy for allowing every Pod to access S3 buckets storing the warehouse and containing datasets. If S3 (instead of EFS) is used to store transient data, extend the policy so that every Pod can access the S3 bucket for the scratch directory.
Adjust the Action field to restrict the set of operations permitted to Pods.
Get the ARN of the IAM policy.
In our example, we create an IAM policy called MR3AccessS3.
$ vi MR3AccessS3.json
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:*"
],
"Resource": [
"arn:aws:s3:::hivemr3-warehouse-dir",
"arn:aws:s3:::hivemr3-warehouse-dir/*",
"arn:aws:s3:::hivemr3-partitioned-10-orc",
"arn:aws:s3:::hivemr3-partitioned-10-orc/*"
]
}
]
}
$ aws iam create-policy --policy-name MR3AccessS3 --policy-document file://MR3AccessS3.json
{
"Policy": {
...
"Arn": "arn:aws:iam::111111111111:policy/MR3AccessS3",
...
Configuring the EKS cluster
Open eks/cluster.yaml.
Set the region for an EKS cluster.
$ vi eks/cluster.yaml
metadata:
region: ap-northeast-2
We create an EKS cluster with two node groups: mr3-master and mr3-worker.
- The
mr3-masternode group is intended for HiveServer2, DAGAppMaster, and Metastore Pods, and uses a single on-demand instance of typem5.xlargefor the master node. - The
mr3-workernode group is intended for ContainerWorker Pods, and uses up to three spot instances of typem5d.xlargefor worker nodes. Note that worker nodes have instance storage. Ifeksctlrequires at least two instance types for themr3-workernode group, upgrade it to the latest version.
nodeGroups:
- name: mr3-master
instanceType: m5.xlarge
desiredCapacity: 1
- name: mr3-worker
desiredCapacity: 0
minSize: 0
maxSize: 3
instancesDistribution:
instanceTypes: ["m5d.xlarge"]
onDemandBaseCapacity: 0
onDemandPercentageAboveBaseCapacity: 0
In the iam/attachPolicyARNs field of both node groups mr3-master and mr3-worker,
use the ARNs of the IAM policies created in the previous steps.
(Without using the ARN for mr3-master, the user cannot check the status of the Kubernetes Autoscaler.)
nodeGroups:
- name: mr3-master
iam:
attachPolicyARNs:
- arn:aws:iam::aws:policy/AmazonEKSWorkerNodePolicy
- arn:aws:iam::aws:policy/AmazonEKS_CNI_Policy
- arn:aws:iam::111111111111:policy/EKSAutoScalingWorkerPolicy
- arn:aws:iam::111111111111:policy/MR3AccessS3
- name: mr3-worker
iam:
attachPolicyARNs:
- arn:aws:iam::aws:policy/AmazonEKSWorkerNodePolicy
- arn:aws:iam::aws:policy/AmazonEKS_CNI_Policy
- arn:aws:iam::111111111111:policy/EKSAutoScalingWorkerPolicy
- arn:aws:iam::111111111111:policy/MR3AccessS3
In the preBootstrapCommands field of the node group mr3-worker,
list commands for initializing instance storage.
In our example, we format /dev/nvme1n1 as ext4 and mount a single local disk on the directory /ephemeral1.
Note that the owner of /ephemeral1 is set to ec2-user
whose UID 1000 matches the UID of user hive in the Docker image mr3project/hive3:1.4.
nodeGroups:
- name: mr3-worker
preBootstrapCommands:
- "mkfs -t ext4 /dev/nvme1n1"
- "mkdir -p /ephemeral1"
- "mount /dev/nvme1n1 /ephemeral1"
- "chown ec2-user:ec2-user /ephemeral1"
By default, the command eksctl uses all Availability Zones (AZs) from the region specified by the field metadata/region.
The user should be aware that
Amazon charges for data transfer between different AZs ($0.01/GB to $0.02/GB)
and intermediate data exchanged by ContainerWorkers can cross the AZ boundary.
The user can use a single AZ by updating eks/cluster.yaml as follows:
$ vi eks/cluster.yaml
availabilityZones: ["ap-northeast-2a", "ap-northeast-2b", "ap-northeast-2c"]
nodeGroups:
- name: mr3-master
availabilityZones: ["ap-northeast-2a"]
- name: mr3-worker
availabilityZones: ["ap-northeast-2a"]
If eksctl does not accept this update, upgrade it to the latest version.
Creating the EKS cluster
Create an EKS cluster by executing the command eksctl.
The following diagram shows an example of the EKS cluster after launch:
Creating an EKS cluster can take 15 minutes or longer.
Get the name of the CloudFormation stack eksctl-hive-mr3-cluster.
$ eksctl create cluster -f eks/cluster.yaml
2022-03-11 12:34:11 [ℹ] eksctl version 0.86.0
2022-03-11 12:34:11 [ℹ] using region ap-northeast-2
...
2022-03-11 12:34:12 [ℹ] deploying stack "eksctl-hive-mr3-cluster"
2022-03-11 12:34:42 [ℹ] waiting for CloudFormation stack "eksctl-hive-mr3-cluster"
...
2022-03-11 12:47:14 [ℹ] building nodegroup stack "eksctl-hive-mr3-nodegroup-mr3-master"
...
2022-03-11 12:47:14 [ℹ] building nodegroup stack "eksctl-hive-mr3-nodegroup-mr3-worker"
...
2022-03-11 12:51:16 [✔] EKS cluster "hive-mr3" in "ap-northeast-2" region is ready
Get the VPC ID of CloudFormation eksctl-hive-mr3-cluster.
$ aws ec2 describe-vpcs --filter Name=tag:aws:cloudformation:stack-name,Values=eksctl-hive-mr3-cluster --query "Vpcs[*].[VpcId]"
[
[
"vpc-098d1e9d96e52e7a1"
]
]
$ VPCID=vpc-098d1e9d96e52e7a1
Get the public subnet ID of CloudFormation eksctl-hive-mr3-cluster.
$ aws ec2 describe-subnets --filter Name=vpc-id,Values=$VPCID Name=availability-zone,Values=ap-northeast-2a Name=tag:aws:cloudformation:stack-name,Values=eksctl-hive-mr3-cluster Name=tag:Name,Values="*Public*" --query "Subnets[*].[SubnetId]"
[
[
"subnet-064ac33663b1accd2"
]
]
$ SUBNETID=subnet-064ac33663b1accd2
The user can find that serveral security groups are created.
Get the ID of the security group for the EKS cluster
that matches the pattern eksctl-hive-mr3-cluster-ClusterSharedNodeSecurityGroup-*.
$ aws ec2 describe-security-groups --filters Name=vpc-id,Values=$VPCID Name=group-name,Values="eksctl-hive-mr3-cluster-ClusterSharedNodeSecurityGroup-*" --query "SecurityGroups[*].[GroupName,GroupId]"
[
[
"eksctl-hive-mr3-cluster-ClusterSharedNodeSecurityGroup-1B3741SF80D5H",
"sg-0b8f891462773e4d5"
]
]
$ SGROUPALL=sg-0b8f891462773e4d5
The user can find that two Auto Scaling groups are created.
$ aws autoscaling describe-auto-scaling-groups --region ap-northeast-2 --query "AutoScalingGroups[*].[AutoScalingGroupName]"
[
[
"eksctl-hive-mr3-nodegroup-mr3-master-NodeGroup-1BZ0HHU8CZTD8"
],
[
"eksctl-hive-mr3-nodegroup-mr3-worker-NodeGroup-175O8A98ZB3MY"
]
]
In our example, the mr3-master node group starts with a single master node
whereas the mr3-worker node group starts with no node and can attach up to three nodes.
The user can verify that only the master node is available in the EKS cluster.
$ kubectl get nodes
NAME STATUS ROLES AGE VERSION
ip-192-168-75-56.ap-northeast-2.compute.internal Ready <none> 4m39s v1.21.5-eks-9017834
The user can get the public IP address of the master node.
$ kubectl describe node ip-192-168-75-56.ap-northeast-2.compute.internal
...
Addresses:
InternalIP: 192.168.75.56
ExternalIP: 3.34.43.80
Configuring Kubernetes Autoscaler
Open eks/cluster-autoscaler-autodiscover.yaml and change the configuration for autoscaling if necessary.
By default, the Kubernetes Autoscaler removes nodes that stay idle for 1 minute (as specified by --scale-down-unneeded-time).
$ vi eks/cluster-autoscaler-autodiscover.yaml
spec:
template:
spec:
containers:
command:
- --scale-down-delay-after-add=5m
- --scale-down-unneeded-time=1m
Start the Kubernetes Autoscaler.
$ kubectl apply -f eks/cluster-autoscaler-autodiscover.yaml
serviceaccount/cluster-autoscaler created
clusterrole.rbac.authorization.k8s.io/cluster-autoscaler created
role.rbac.authorization.k8s.io/cluster-autoscaler created
clusterrolebinding.rbac.authorization.k8s.io/cluster-autoscaler created
rolebinding.rbac.authorization.k8s.io/cluster-autoscaler created
deployment.apps/cluster-autoscaler created
The user can check that the Kubernetes Autoscaler has started properly.
$ kubectl logs -f deployment/cluster-autoscaler -n kube-system
...
I0311 03:56:55.819851 1 utils.go:543] Skipping ip-192-168-75-56.ap-northeast-2.compute.internal - no node group config
I0311 03:56:55.819890 1 static_autoscaler.go:393] Scale down status: unneededOnly=true lastScaleUpTime=2022-03-11 03:56:45.818427872 +0000 UTC m=+2.720450391 lastScaleDownDeleteTime=2022-03-11 03:56:45.818427936 +0000 UTC m=+2.720450453 lastScaleDownFailTime=2022-03-11 03:56:45.818428007 +0000 UTC m=+2.720450530 scaleDownForbidden=false isDeleteInProgress=false
Directory for storing transient data
The user can use either EFS or S3 to store transient data. For using EFS, follow the instruction in 1. Creating and mounting EFS. For using S3, follow the instruction in 2. Using S3 instead of EFS.
For running Hive on MR3 in production, using EFS is recommended.
1. Creating and mounting EFS (efs/manifest.yaml)
The user can create EFS on the AWS Console.
When creating EFS, choose the VPC of the EKS cluster.
Make sure that a mount target is created for each Availability Zone.
Get the file system ID of EFS (e.g., fs-06326d8618a282ce5).
If the user can choose the security group for mount targets,
use the security group for the EKS cluster (in SGROUPALL).
Alternatively the user can create EFS using AWS CLI. Create EFS in the Availability Zone where Hive on MR3 is to run. Get the file system ID of EFS.
$ aws efs create-file-system --performance-mode generalPurpose --throughput-mode bursting --availability-zone-name ap-northeast-2a
...
"FileSystemId": "fs-06326d8618a282ce5",
...
$ EFSID=fs-06326d8618a282ce5
Create a mount target using the subnet ID of CloudFormation eksctl-hive-mr3-cluster
and the security group ID for the EKS cluster.
Get the mount target ID which is necessary when deleting the EKS cluster.
$ aws efs create-mount-target --file-system-id $EFSID --subnet-id $SUBNETID --security-groups $SGROUPALL
...
"MountTargetId": "fsmt-0e249b07631d42823",
...
$ MOUNTID=fsmt-0e249b07631d42823
After creating EFS,
get the address of EFS (e.g., fs-06326d8618a282ce5.efs.ap-northeast-2.amazonaws.com).
Open efs/manifest.yaml and update the following fields.
$ vi efs/manifest.yaml
data:
file.system.id: fs-06326d8618a282ce5
aws.region: ap-northeast-2
spec:
template:
spec:
volumes:
- name: pv-volume
nfs:
server: fs-06326d8618a282ce5.efs.ap-northeast-2.amazonaws.com
Execute the script mount-efs.sh to create a PersistentVolume.
$ ./mount-efs.sh
namespace/hivemr3 created
serviceaccount/efs-provisioner created
clusterrole.rbac.authorization.k8s.io/efs-provisioner-runner created
clusterrolebinding.rbac.authorization.k8s.io/run-efs-provisioner created
role.rbac.authorization.k8s.io/leader-locking-efs-provisioner created
rolebinding.rbac.authorization.k8s.io/leader-locking-efs-provisioner created
configmap/efs-provisioner created
deployment.apps/efs-provisioner created
storageclass.storage.k8s.io/aws-efs created
persistentvolumeclaim/workdir-pvc created
The user can find a new StorageClass aws-efs, a new Pod, and a new PersistentVolumeClaim (workdir-pvc).
$ kubectl get sc
NAME PROVISIONER RECLAIMPOLICY VOLUMEBINDINGMODE ALLOWVOLUMEEXPANSION AGE
aws-efs example.com/aws-efs Delete Immediate false 11s
gp2 (default) kubernetes.io/aws-ebs Delete WaitForFirstConsumer false 23m
$ kubectl get pods -n hivemr3
NAME READY STATUS RESTARTS AGE
efs-provisioner-c85bb8c6c-qkvps 1/1 Running 0 30s
$ kubectl get pvc -n hivemr3
NAME STATUS VOLUME CAPACITY ACCESS MODES STORAGECLASS AGE
workdir-pvc Bound pvc-35196017-efe5-40af-afd8-2534bfe6dda2 1Mi RWX aws-efs 118s
2. Using S3 instead of EFS
Set the configuration keys hive.exec.scratchdir and hive.query.results.cache.directory in conf/hive-site.xml to point to the directory on S3 for storing transient data.
Note that we should use prefix s3a, not s3.
$ vi conf/hive-site.xml
<property>
<name>hive.exec.scratchdir</name>
<value>s3a://hivemr3-warehouse-dir/workdir/${user.name}</value>
</property>
<property>
<name>hive.query.results.cache.directory</name>
<value>s3a://hivemr3-warehouse-dir/workdir/${user.name}/_resultscache_</value>
</property>
Open env.sh and set the following two environment variables to empty values
because we do not use PersistentVolumes.
$ vi env.sh
WORK_DIR_PERSISTENT_VOLUME_CLAIM=
WORK_DIR_PERSISTENT_VOLUME_CLAIM_MOUNT_DIR=
Open yaml/metastore.yaml and comment out the following lines:
$ vi yaml/metastore.yaml
# - name: work-dir-volume
# mountPath: /opt/mr3-run/work-dir/
# - name: work-dir-volume
# persistentVolumeClaim:
# claimName: workdir-pvc
Open yaml/hive.yaml and comment out the following lines:
$ vi yaml/hive.yaml
# - name: work-dir-volume
# mountPath: /opt/mr3-run/work-dir
# - name: work-dir-volume
# persistentVolumeClaim:
# claimName: workdir-pvc
Access to the MySQL server for Metastore
Check if the MySQL server for Metastore is accessible from the master node. If the MySQL server is running on Amazon AWS, the user may have to update its security group or VPC configuration.
Configuring Metastore in env.sh
Open env.sh and
set the environment variable HIVE_DATABASE_HOST to the IP address of the MySQL server for Metastore.
In our example, the MySQL server is running at the IP address 3.36.101.45.
Set the environment variable HIVE_DATABASE_NAME to the database name for Metastore in the MySQL server.
Set the environment variable HIVE_WAREHOUSE_DIR to the S3 bucket storing the warehouse.
Note that we should use prefix s3a, not s3.
$ vi env.sh
HIVE_DATABASE_HOST=3.36.101.45
HIVE_DATABASE_NAME=hive5mr3
HIVE_WAREHOUSE_DIR=s3a://hivemr3-warehouse-dir/warehouse
If the user sets the environment variable HIVE_DATABASE_HOST to the host name of the MySQL server (instead of its IP address),
the user should update: 1) the spec/template/spec/hostAliases field in yaml/metastore.yaml and yaml/hive.yaml,
and 2) the configuration key mr3.k8s.host.aliases in conf/mr3-site.xml.
Checking configurations for MR3
For conf/core-site.xml and conf/mr3-site.xml, the user should use the default values for all configuration keys.
There are three configuration keys that the user may want to update.
-
mr3.k8s.pod.worker.hostpathsinconf/mr3-site.xmlis set to/ephemeral1because the instance typem5d.xlargefor worker nodes is equipped with a single local disk mounted on the directory/ephemeral1. If the user uses different instance types with multiple local disks, thepreBootstrapCommandsfield of the node groupmr3-workershould be expanded to mount all local disks and the configuration keymr3.k8s.pod.worker.hostpathsshould include additional directories. -
Since the Kubernetes Autoscaler is configured to remove nodes that remain idle for 1 minute for fast scale-in,
mr3.auto.scale.in.grace.period.secsinconf/mr3-site.xmlis set to 90 seconds (60 seconds of idle time and extra 30 seconds to account for delays). If the user wants to increase the value of--scale-down-unneeded-timeineks/cluster-autoscaler-autodiscover.yaml, the configuration keymr3.auto.scale.in.grace.period.secsshould be adjusted accordingly. -
mr3.auto.scale.out.grace.period.secsinconf/mr3-site.xmlshould be set to a sufficiently large value so as to prevent MR3 from prematurely cancelling the provisioning of worker nodes. For example, if it takes about 3 minutes to create and initialize a new worker node,mr3.auto.scale.out.grace.period.secscan be set to 360 (equivalent to 6 minutes). For more details, see Autoscaling.
Configuring Metastore
Open conf/hive-site.xml and update configurations for Metastore as necessary.
Below we list some of configuration keys that the user should check.
The two configuration keys javax.jdo.option.ConnectionUserName and javax.jdo.option.ConnectionPassword should match
the user name and password of the MySQL server for Metastore.
$ vi conf/hive-site.xml
<property>
<name>hive.metastore.db.type</name>
<value>MYSQL</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.cj.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>passwd</value>
</property>
<property>
<name>hive.security.metastore.authenticator.manager</name>
<value>org.apache.hadoop.hive.ql.security.HadoopDefaultMetastoreAuthenticator</value>
</property>
<property>
<name>hive.security.metastore.authorization.manager</name>
<value>org.apache.hadoop.hive.ql.security.authorization.DefaultHiveMetastoreAuthorizationProvider</value>
</property>
<property>
<name>hive.security.authenticator.manager</name>
<value>org.apache.hadoop.hive.ql.security.ProxyUserAuthenticator</value>
</property>
By default, Metastore does not initialize schema.
In order to initialize schema when starting Metastore, update yaml/metastore.yaml as follows:
$ vi yaml/metastore.yaml
spec:
template:
spec:
containers:
args: ["start", "--kubernetes", "--init-schema"]
Docker image
By default, we use a pre-built Docker image mr3project/hive3:1.4.
If the user wants to use a different Docker image,
check the environment variable DOCKER_HIVE_IMG in env.sh
and the field spec/template/spec/containers/image in yaml/metastore.yaml and yaml/hive.yaml.
$ vi env.sh
DOCKER_HIVE_IMG=${DOCKER_HIVE_IMG:-mr3project/hive3:1.4}
$ vi yaml/metastore.yaml
spec:
template:
spec:
containers:
- image: mr3project/hive3:1.4
$ vi yaml/hive.yaml
spec:
template:
spec:
containers:
- image: mr3project/hive3:1.4
Running Metastore and HiveServer2
Depending on the characteristics of datasets and queries, the user may have to change configurations for Hive on MR3 before running Metastore and HiveServer2. Here are a couple of examples.
- Change resources to be allocated to each mapper, reducer, and ContainerWorker by updating
conf/hive-site.xml. In particular, the configuration keyshive.mr3.all-in-one.containergroup.memory.mbandhive.mr3.all-in-one.containergroup.vcoresshould be adjusted so that a ContainerWorker can fit in a worker node. For example, we can use the following values for worker nodes of instance typem5d.xlarge.$ vi conf/hive-site.xml <property> <name>hive.mr3.all-in-one.containergroup.memory.mb</name> <value>15360</value> </property> <property> <name>hive.mr3.all-in-one.containergroup.vcores</name> <value>3</value> </property>For more details, see Performance Tuning.
- Change the parameters for accessing S3
to avoid
SdkClientException: Unable to execute HTTP request: Timeout waiting for connection from pool. For more details, see Troubleshooting.
The user can start Metastore by executing the script run-metastore.sh.
After a Metastore Pod is created,
the user can start HiveServer2 by executing the script run-hive.sh.
$ ./run-metastore.sh
Error from server (AlreadyExists): namespaces "hivemr3" already exists
...
configmap/client-am-config created
statefulset.apps/hivemr3-metastore created
service/metastore created
$ ./run-hive.sh
...
deployment.apps/hivemr3-hiveserver2 created
service/hiveserver2 created
HiveServer2 creates a DAGAppMaster Pod. Note, however, that no ContainerWorkers Pods are created until queries are submitted. Depending on the configuration for readiness probe, HiveServer2 may restart once before running normally. In our example, HiveServer2 becomes ready in 2 minutes.
$ kubectl get pods -n hivemr3
NAME READY STATUS RESTARTS AGE
efs-provisioner-c85bb8c6c-qkvps 1/1 Running 0 12m
hivemr3-hiveserver2-856486bd78-cwxbh 1/1 Running 0 2m
hivemr3-metastore-0 1/1 Running 0 2m23s
mr3master-6228-0-57ff476fc6-6twv8 1/1 Running 0 104s
The user can check the log of the DAGAppMaster Pod to make sure that it has started properly.
$ kubectl logs -f -n hivemr3 mr3master-6228-0-57ff476fc6-6twv8
...
2022-03-11T04:17:12,793 INFO [DAGAppMaster-1-18] HeartbeatHandler$: Timeout check in HeartbeatHandler:Task
2022-03-11T04:17:12,841 INFO [K8sContainerLauncher-3-1] K8sContainerLauncher: Resynchronizing Pod states for appattempt_6228_0000_000000: 0
Configuring the LoadBalancer
Executing the script run-hive.sh creates a new LoadBalancer for HiveServer2.
Get the security group associated with the LoadBalancer.
If necessary, edit the inbound rule in order to restrict the source IP addresses (by changing the source from 0.0.0.0/0 to (IP address)/32.
The LoadBalancer disconnects Beeline showing no activity for the idle timeout period, which is 60 seconds by default. The user may want to increase the idle timeout period, e.g., to 1200 seconds. Otherwise Beeline loses the connection to HiveServer2 even after a brief period of inactivity.
Running Beeline
To run Beeline, get the LoadBalancer Ingress of the Service hiveserver2.
$ kubectl describe service -n hivemr3 hiveserver2
Name: hiveserver2
Namespace: hivemr3
Labels: <none>
Annotations: <none>
Selector: hivemr3_app=hiveserver2
Type: LoadBalancer
IP: 10.100.203.119
External IPs: 10.1.91.41
LoadBalancer Ingress: a8b77990647b24340be132c7380d0b8b-420212146.ap-northeast-2.elb.amazonaws.com
...
Get the IP address of the LoadBalancer Ingress.
$ nslookup a8b77990647b24340be132c7380d0b8b-420212146.ap-northeast-2.elb.amazonaws.com
...
Non-authoritative answer:
Name: a8b77990647b24340be132c7380d0b8b-420212146.ap-northeast-2.elb.amazonaws.com
Address: 13.124.39.89
Name: a8b77990647b24340be132c7380d0b8b-420212146.ap-northeast-2.elb.amazonaws.com
Address: 3.37.187.176
In this example, the user can use 13.124.39.89 or 3.37.187.176 as the IP address of HiveServer2 when running Beeline.
This is because Beeline connects first to the LoadBalancer, not directly to HiveServer2.
Here is an example of running Beeline using the address of 13.124.39.89
on another machine where the script hive/run-beeline.sh is installed.
$ hive/run-beeline.sh --tpcds --hivesrc3
...
Connecting to jdbc:hive2://13.124.39.89:9852/;;
Connected to: Apache Hive (version 3.1.3)
Driver: Hive JDBC (version 3.1.3)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.3 by Apache Hive
0: jdbc:hive2://13.124.39.89:9852/>
After running a few queries, new worker nodes are attached and ContainerWorker Pods are created.
In our example, the EKS cluster ends up with three worker nodes.
The last ContainerWorker Pod stays in the state of Pending
because the number of worker nodes has reached its maximum (3 in our example) and no more worker nodes can be attached.
$ kubectl get pods -n hivemr3
NAME READY STATUS RESTARTS AGE
efs-provisioner-c85bb8c6c-qkvps 1/1 Running 0 31m
hivemr3-hiveserver2-856486bd78-cwxbh 1/1 Running 0 21m
hivemr3-metastore-0 1/1 Running 0 21m
mr3master-6228-0-57ff476fc6-6twv8 1/1 Running 0 20m
mr3worker-3af9-1 1/1 Running 0 3m19s
mr3worker-3af9-2 1/1 Running 0 3m19s
mr3worker-3af9-3 1/1 Running 0 3m19s
mr3worker-3af9-4 0/1 Pending 0 3m19s
Here is the progress of scale-out operations
when the configuration key mr3.auto.scale.out.num.initial.containers is set to 1
in conf/mr3-site.xml:
Here is the progress of scale-in operations:
Note that the EKS cluster does not remove all worker nodes
because the configuration key mr3.auto.scale.in.min.hosts in mr3-site.xml is set to 1,
which means that no scale-in operation is performed if the number of worker nodes is 1.
The user can check the progress of autoscaling from the log of the DAGAppMaster Pod.
$ kubectl logs -n hivemr3 mr3master-6228-0-57ff476fc6-6twv8 -f | grep -e Scale -e Scaling -e average
Deleting the EKS cluster
Because of the additional components configured manually,
it take a few extra steps to delete the EKS cluster.
In order to delete the EKS cluster (created with eksctl), proceed in the following order.
- Stop HiveServer2, DAGAppMaster, and Metastore.
$ kubectl -n hivemr3 delete deployment hivemr3-hiveserver2 deployment.apps "hivemr3-hiveserver2" deleted $ kubectl delete deployment -n hivemr3 mr3master-6228-0 deployment.apps "mr3master-6228-0" deleted $ kubectl -n hivemr3 delete statefulset hivemr3-metastore statefulset.apps "hivemr3-metastore" deleted - Delete all the resources for Hive on MR3.
$ kubectl -n hivemr3 delete configmap hivemr3-conf-configmap client-am-config mr3conf-configmap-master mr3conf-configmap-worker $ kubectl -n hivemr3 delete svc --all $ kubectl -n hivemr3 delete secret env-secret hivemr3-keytab-secret hivemr3-worker-secret $ kubectl -n hivemr3 delete serviceaccount hive-service-account master-service-account worker-service-account $ kubectl -n hivemr3 delete role hive-role master-role worker-role $ kubectl -n hivemr3 delete rolebinding hive-role-binding master-role-binding worker-role-binding $ kubectl delete clusterrole node-reader $ kubectl delete clusterrolebinding hive-clusterrole-binding - Delete the resources for EFS.
$ kubectl delete -f efs/service-account.yaml $ kubectl delete -f efs/workdir-pvc.yaml $ kubectl delete -f efs/manifest.yaml $ kubectl delete -f efs/rbac.yaml - Delete the namespace
hivemr3.$ kubectl delete namespace hivemr3 - If EFS was created, remove the mount targe for EFS.
$ aws efs delete-mount-target --mount-target-id $MOUNTID - If EFS was created, delete EFS.
$ aws efs delete-file-system --file-system-id $EFSID - Stop Kubernetes Autoscaler
$ kubectl delete -f eks/cluster-autoscaler-autodiscover.yaml - Delete EKS with
eksctl.$ eksctl delete cluster -f eks/cluster.yaml ... 2022-03-11 13:54:46 [✔] all cluster resources were deleted
If the last command fails, the user should delete the EKS cluster manually. Proceed in the following order on the AWS console.
- Delete security groups manually.
- Delete the NAT gateway created for the EKS cluster, delete the VPC, and then delete the Elastic IP address.
- Delete the LoadBalancer.
- Delete IAM roles.
- Delete CloudFormations.
