@Praneender Vuppala I wonder if you are hitting this issue: https://issues.apache.org/jira/browse/AMBARI-15727, probably not. You can try setting Hive queries to MR instead of Tez to see if the problem still exists. Can you provide more information about your environment? What version of Ambari are you using? What version of HDP? You said you can run a query from the hive shell. Are you use the "hive" or the "beeline" client. The hive client talks to the metastore directly. The beeline client uses the thrift server and uses more of the overall stack. Here is the documentation for the beeline client: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-BeelineExample ... View more

@Navin Ladda I've run into this problem several times, but it was intermittent. I'm on Mac OS X, and the file failed to download using Chrome and Firefox. However, I was able to successfully download it using Safari. Here is the MD5 check of my file (successfully imported into VirtualBox): $ md5 HDP_2.4_virtualbox_v3.ova MD5 (HDP_2.4_virtualbox_v3.ova) = 6991bc1276053c27f82688fd42c5352d And here is the size, in bytes: $ ls -la HDP_2.4_virtualbox_v3.ova -rw-r--r--@ 1 username group 9168198144 Mar 21 20:11 HDP_2.4_virtualbox_v3.ova On Windows, you can use the Microsoft File Checksum Integrity Verifier tool to check the MD5: https://www.microsoft.com/en-us/download/details.aspx?id=11533 fciv.exe C:\Users\username\Downloads\HDP_2.4_virtualbox_v3.ova File Checksum Integrity Verifier version 2.05. 6991bc1276053c27f82688fd42c5352d c:\users\username\downloads\hdp_2.4_virtualbox_v 3.ova ... View more