@Michel Meulpolder You may have a valid point. This thread definitely introduce you to new docs and ideas. ... View more

@Michel Meulpolder Generally, Ambari does good job in predicting the settings. You can use this too https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_installing_manually_book/content/determine-hdp-memory-config.html Follow the above link and I think you will get enough details about your cluster. ... View more

@Michel Meulpolder Try the same query set hive.execution.enginer=mr; select max(mpg)from truck_mileage; ... View more

@Michel Meulpolder Could you check the yarn log through ambari ? What's in the application log for app id 004? ... View more

@Jonas Straub Very nice! Thank you for sharing this. 🙂 ... View more

@Michel Meulpolder I have accepted this as best answer because you were able to proceed by changing the browser. Hope it's ok ... View more

@Robin Dong You can install the cluster using those nodes. Don't install the components that you don't need as it can save you resources in the cluster for the components you need. So...In you case 1 master node and 4 worker nodes. No edge node. This is old pic has it has Nagios and Ganglia which is replaced by ambari metrics server. Node 1 - Ambari Server , Namode and Snode (or there is no harm having this on Node2 with DN),RM,Hive,Hive metastore Node 2 to Node 4 - Datanode, Nodemanager and other processes. Main question: Can I install ambari on the namenode, in other words, do I have to have separate node to install ambari? Yes and you don't need separate server for ambari. The design for production environment is different from dev, qa and POC environments ... View more

@Andrea Squizzato Perfect! Did above link help? I am glad that the issue is resolved. Please accept the best answer to close the thread and if you can share the doc link that your followed then it would be very helpful for future users. ... View more

@Michel Meulpolder Hive tuning guide http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_performance_tuning/content/ch_hive_architectural_overview.html ... View more

@sivasaravanakumar k You have this ..Doc sqoop import --connect jdbc:mysql://db.foo.com/bar --table EMPLOYEES --where "id > 100000" --target-dir /incremental_dataset --append ... View more