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 upper right hand corner of the console, 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.
Download the private key file. The file name will end with
mykeypair.pem). Keep this private key file 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 Amazon Elastic Compute Cloud Key Pairs in the Amazon EC2 User Guide for Linux Instances.