Member since
01-06-2014
4
Posts
4
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
26369 | 01-07-2014 07:31 PM |
05-30-2014
08:53 AM
Hi, sorry to hear you're having problems. CDH 4.4 should work. I have the CDH4.4 VM running on my laptop with NAT and can connect to it. Are you choosing an authentication mechanism or leaving it as no authentication? If you are choosing No Authentication, you will need to disable impersonation for HiveServer2 and add the following to the safety valve for hive-site.xml: <property> <name>hive.server2.authentication</name> <value>NOSASL</value> </property> Another option you could try is to leave HiveServer2 as is and choose User Name authentication and supply a user name. You may also want to try the newest version of the ODBC driver.
... View more
01-08-2014
09:38 AM
You should use port 21050 to connect to Impala, as long as that port hasn't changed in your settings. You should choose no authentication if you do not have security setup on EC2/Quickstart. Glad to see the HS2 connection is up and running!
... View more
01-07-2014
07:31 PM
2 Kudos
I believe in your first post you mention that you are using CM. If you're using CM to manage the cluster then you won't see the hive-server2 service from a command line. You'll have to add the instance and start it from CM. The default settings for HiveServer2 are listed in the configuration, but by default the instance is not added or started. Here is the documentation for adding a role instance. Once you have added the hiveserver2 instance then you can start it and should be able to access it straight away. Hopefully this will get you going. Please let me know your results. You can also use the following commands on the quickstart vm or your ec2 setup to verify that port 10000 is in use once you start hiveserver2: sudo netstat -tulpn | grep 10000 Dave
... View more
01-06-2014
10:53 AM
2 Kudos
Mark, What is the error you are seeing when trying to connect to HS2? Do you have security configured on your cluster or is this unsecured? If it is unsecured, I have seen a problem when using the "No Authenticaiton" mechanism in the DSN setup. There is a workaround for this. First, choose the "User name" mechanism. Then type something in the User name option. It doesn't matter what it is. Can you connect through beeline locally?
... View more