It is decided by the optmiser,the planning .We can not do much on this. ... View more

Excuse me, how did you solve it？ ... View more

Thanks you nailed it indeed. set hiveconf:tez.am.container.reuse.enabled=false; did the trick. ... View more

Thanks @Guillaume Roger I was facing the above issue because the ats-hbase.json file is present under ats-hbase user in hdfs and running the command from any other user doesn't help. I was able to fix the issue by trying couple of things 1. Running below command 2. Restarting Timeline Service V2.0 through ambari. I am not sure whether it actually started the hbase-ats because I cannot see any service running in resource manager which was the case earlier. curl -k -u: -H "Content-Type: application/json" -X PUT http://<ResourceManagerHost>:<ResourceManagerPort>/app/v1/services/ats-hbase?user.name=yarn-ats -d '{"state": "STOPPED" }' curl -k -u: -H "Content-Type: application/json" -X PUT http://<ResourceManagerHost>:<ResourceManagerPort>/app/v1/services/ats-hbase?user.name=yarn-ats -d '{"state": "STARTED" }' I am not sure restarting helped because I had restarted the cluster few times and that might have restarted the timeline server. I used below document for reference. https://docs.hortonworks.com/HDPDocuments/HDP3/HDP-3.0.0/data-operating-system/content/options_to_restart_ats-hbase.html ... View more

@Jordan Moore Not really relevant to the question but no this is not the point. The use case here is data export, where some clients have their own BI tools, processes and so on. They just need the data, csv in a zip file. Other clients do not have this in place and have a different access to this data. ... View more

1) was ok, 2) and 3) were not good and no it's not a kerberized cluster. After the fixes you suggested it all seems to work as expected. Thanks a million! ... View more

Fair enough about the *.period. As I did get metrics there is probably a smart default, but nice to have. I indeed found some messages in the service logs, and all looks good. To be honest, it all worked today. I then happily applied the settings to prod, and lo and behold, I only have 2 metrics there. Carrying on thinking, I understood is that in metrics2.properties I say that I want for instance node manager metrics, but I then actually need to restart the node manages to see those metrics. Indeed, the cluster I worked on yesterday has been rebooted (dev cluster, switched off at night). Now all works as expected. Thanks! ... View more

It's worth reading this https://community.hortonworks.com/questions/146229/hive-llap-has-conflict-with-hive-sql-standadard-au.html ... View more