There's a firewall set up that may be your problem. The Live clusters only
expose ports that are considered secure and are required for the tutorials.
If you go beyond that, you may need to open some ports in the firewall, and
then you need to make sure you configure the services to be secure enough
to meet your needs. The authentication configuration with Hive and Impala
is the default, so the firewall blocks access to those ports by default.
The firewall in question is the Network ACL. You can find the ID of the
specific ACL in the Resources Tab in CloudFormation, and then edit the
configuration of the Network ACL from the EC2 Management Console. Remember
the Network ACL is stateless, meaning it is unaware of established
connections, etc. and filters individual packets based on their ports.
The EC2 security group and any operating-system-level firewall should not
be getting in the way here, but keep those in mind as other options if you
need to change the networking configuration. Remember that EC2 security
groups are stateful, but they apply to traffic even between the nodes of
your cluster.
I'd also make sure you've confirmed the credentials and other details of
your connection string by connecting from a node in the cluster, so you can
differentiate between the firewall blocking the connection and any other
potential problems.
