question Re: Can we get better performance for hive queries by using SSD? in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-we-get-better-performance-for-hive-queries-by-using-SSD/m-p/95702#M9030 <P>This thread has all the details needed:</P><P><A href="http://community.hortonworks.com/questions/1405/can-you-please-advise-about-how-best-to-use-this-s.html">http://community.hortonworks.com/questions/1405/can-you-please-advise-about-how-best-to-use-this-s.html</A></P> Wed, 21 Oct 2015 17:29:23 GMT gbraccialli3 2015-10-21T17:29:23Z Can we get better performance for hive queries by using SSD? https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-we-get-better-performance-for-hive-queries-by-using-SSD/m-p/95700#M9028 <P>One of my client is using Azure based IaaS for their HDP cluster. They are open to using more expensive storage to get better performance. </P><P>Is it recommended to use SSD for some of the data in hive tables, to get that boost in performance? Also what are the steps to make your temporary storage to point to SSD, that is used by Tez/MR jobs?</P> Tue, 20 Oct 2015 18:49:39 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-we-get-better-performance-for-hive-queries-by-using-SSD/m-p/95700#M9028 csankaraiah 2015-10-20T18:49:39Z Re: Can we get better performance for hive queries by using SSD? https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-we-get-better-performance-for-hive-queries-by-using-SSD/m-p/95701#M9029 <P>I understood that yarn.nodemanager.local-dirs would be the setting to point to SSD to get better performance on shuffle and other temporary usage. I also would like to confirm it.</P> Tue, 20 Oct 2015 22:13:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-we-get-better-performance-for-hive-queries-by-using-SSD/m-p/95701#M9029 gbraccialli3 2015-10-20T22:13:20Z Re: Can we get better performance for hive queries by using SSD? https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-we-get-better-performance-for-hive-queries-by-using-SSD/m-p/95702#M9030 <P>This thread has all the details needed:</P><P><A href="http://community.hortonworks.com/questions/1405/can-you-please-advise-about-how-best-to-use-this-s.html">http://community.hortonworks.com/questions/1405/can-you-please-advise-about-how-best-to-use-this-s.html</A></P> Wed, 21 Oct 2015 17:29:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Can-we-get-better-performance-for-hive-queries-by-using-SSD/m-p/95702#M9030 gbraccialli3 2015-10-21T17:29:23Z