To run Hive interactively to manage data in DynamoDB, you will need a key pair to connect to the Amazon EC2 instances launched by Amazon EMR (Amazon EMR). You will use this key pair to connect to the master node of the Amazon EMR job flow to run a HiveQL script (a language similar to SQL).
To generate a key pair
Sign in to the AWS Management Console and open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.
In the Navigation pane, select a Region from the Region drop-down menu. This should be the same region that your DynamoDB database is in.
Click Key Pairs in the Navigation pane.
The console displays a list of key pairs associated with your account.
Click Create Key Pair.
Enter a name for the key pair, such as
mykeypair, for the new key pair in the Key Pair
Name field and click Create.
You are prompted to download the key file.
Download the private key file and keep it in a safe place. You will need it to access any instances that you launch with this key pair.
If you lose the key pair, you cannot connect to your Amazon EC2 instances.
For more information about key pairs, see Getting an SSH Key Pair in the Amazon EC2 User Guide for Linux Instances.