Hi Sean,   Thanks for the information.  I will work on AWS and see if I can access from outside.    Can you tell me how much time I have with this free trial?  I want to do some more work to understand the environment better.   Mark ... View more

Hi Sean,   Thanks very much.  The documentation is helpful and I am making progress.    I have one more request.  I have Microstrategy on my local machine and I want to connect to Impala on Cloudera Live.  I tried using the ip address that I am using with Tableau but I am not able to connect from my machine.  Is there a public dns I could use when I am not going through remote desktop. I would appreciate your reply.   Mark ... View more

Hi Sean,   Thanks for your reply.  I could connect to one of the worker nodes using 10.0.0.70:21050.  But, in Tableau, I am not seeing any of the tables that I could access in both Hive and Impala.  I am not very familiar with Tableau but very proficient with Business Objects & Microstrategy.  Is there anything I need to do more than just connecting to the server?  I would appreciate your response back.   Mark ... View more

Hi Sean,   Thanks for the information.  The problem I had with Impala was that I could connect but I am not seeing any of the tables that I could see through Hue.  Can you tell me what the host IP, port and userid I should use?   I will try to install odbc driver for Hive and try connecting.   Please reply when you get a chance.   Mark ... View more

Hi Sean   I could get everything on the server to work and I finished all tutorial exercises.    The only outstanding issue is connectivity from Tableau.  I am connecting from a windows machine using remote desktop.  I am not sure why I even need odbc driver on my machine.  It looks like there is something with connectivity parameters that is not correct.  I would appreciate your help.   Mark ... View more

Hi Sean,   I think I finally found out where the problem was. I was not connecting to the Manager node in Putty.  I just did that and the script is running.  I will let you know once it finishes. I am hoping new tables will be created and I can query through hive or impala.  Thanks for your help.    I still need to work through Tableau.  Please let me know if you find the solution on the right driver/connectivity parameters I should use.   Mark ... View more

Hi Sean,   With regards to Sqoop:   I added the new service Sqoop Client 1 and it seems to be running.  I went back to putty and ran the script again.  I still get the same error.   -bash: Sqoop: Command not found   Is there any other way I can test if Sqoop is running?   Thanks for your help.   Mark ... View more

Hi Sean,   I appreciate your feedback.  With regards to Putty, I am not good at Unix.  All I did was to connect to ec2-52-91-172-186.compute-1.amazonaws.com using mykeypair.ppk.  I used ec2-user as the userid. when I used /opt/cloudera/parcels/CDH/bin/sqoop at the prompt, I get an error - no such file or directory.  I am not good at Unix and I need your help with commands if you want me to check something.   With regards to Tableau, I tried to create a odbc connection using Cloudera odbc driver for Hive.  I did not use JDBC driver.  Can you confirm if I should use ODBC or JDBC for connecting to manager node?   Mark     ... View more

Thanks for the reply.   I tried with Sqoop in front and I get the error:   -bash: sqoop: command not found   It looks like I am not in the right environment or the master node I am connecting to doesn't have sqoop installed.   Please check and let me know.   Mark ... View more

Just to clarify   I used the private IP to connect using Coludera Live ODBC driver.  I tried different userids including ec2-user and I was not able to connect to Hive Server 2.    When I try to connect using Impala directly in Tableau, I can connect using ec2-user as id but cannot access the tables that I can see through Hue/Hive.   Please let me know what I am missing in the workflow.   Mark ... View more