yes, it was a typo. thank you very much for this one. ... View more

thank you both. yes at ambari-server setup. ... View more

I have deployed cluster on Amazon EC2. I have followed this steps for Ranger as I want to add rule for Ranger in inbound rule. I have added inbound rule TYPE as Custom TCP and SOURCE as 6080. And now I want to open Ranger UI by using http://ec2-xx-xxx-xx-xxx.compute-1.amazonaws.com:6080. I still couldn't able to resolve my problem. ... View more

thank you all, I have to download the ambari.repo file separately in this case -- without internet access. now I am done with ambari setup and start. ... View more

@Robin Dong It looks like you accepted your own comment. I converted it to comment. Please do accept the answer to close the thread ..If it's useful ... View more

sure thing ... View more

@Robin Dong As mentioned by Ancil, you might want to have a script to do the sqoop download in parallel. And you need to control quite well how big is your parallelism. Above all if you want to avoid the typical "No more spool space in...". Here's a script to do that: https://community.hortonworks.com/articles/23602/sqoop-fetching-lot-of-tables-in-parallel.html Another problem I saw in Teradata, is that it is some data types are not supported when you try to directly insert the data into Hive from Sqoop. So the solution I took was the traditional one: 1) Sqoop to HDFS. 2) Build external tables on top of them 3) Create ORC file and then insert the data or the external tables ... View more

I run into the same problem, where the Ambari says it's installed, but the sqoop directory is not there on the data nodes. I am running in a cluster, but it should be the same for sandbox. The current answer does not address this, but the only way to fix this is to uninstall the sqoop client, and re-install it with Ambari. Unfortunately, current web UI does not allow uninstall of clients. Fortunately, you can do it through API calls. Command Syntax is follows: URL=https://${AMBARI_HOST}/api/v1/clusters/${CLUSTER_NAME}/hosts/${HOST_FQDN}/host_components/SQOOP curl -k -u admin:admin -H "X-Requested-By:ambari" -i -X DELETE $URL After that, you can re-install the sqoop client from the Web UI. ... View more

https://community.hortonworks.com/content/kbentry/10551/apache-drill-unofficial-introduction.html "Unofficial" ... View more