Yes it's correct what   elserj said, but inside your crontab job please add . $HOME/.bashrc; for example: 09 15 * * 1 . $HOME/.bashrc; PATH:/compact.sh > /home/user/logfile.log 2>&1 ... View more

Thanks for the Solution ... View more

Hi @singhvNt, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

Thank you, clear and solid explanation. ... View more

I faced the same exception with Ambari 2.7.1 with different scenario. The scenario happens like that: I was trying to install Apache Solr with HDP Search as mpack. I wrongly installed the old version of mpack and when I restart the Ambari, Ambari couldn't open. I looked into ambari-server.log and the error was like below: An unexpected error occured during starting Ambari Server. com.google.inject.ProvisionException: Unable to provision, see the following errors: 1) Error injecting method, java.lang.NullPointerException at org.apache.ambari.server.api.services.AmbariMetaInfo.init(AmbariMetaInfo.java:250) at org.apache.ambari.server.api.services.AmbariMetaInfo.class(AmbariMetaInfo.java:123) while locating org.apache.ambari.server.api.services.AmbariMetaInfo for field at org.apache.ambari.server.controller.AmbariServer.ambariMetaInfo(AmbariServer.java:179) at org.apache.ambari.server.controller.AmbariServer.class(AmbariServer.java:179) while locating org.apache.ambari.server.controller.AmbariServer 1 error at com.google.inject.internal.InjectorImpl$2.get(InjectorImpl.java:1028) at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1054) at org.apache.ambari.server.controller.AmbariServer.main(AmbariServer.java:1101) Caused by: java.lang.NullPointerException at org.apache.ambari.server.stack.StackModule.mergeRoleCommandOrder(StackModule.java:1336) at org.apache.ambari.server.stack.StackModule.finalizeModule(StackModule.java:244) at org.apache.ambari.server.stack.StackManager.fullyResolveStacks(StackManager.java:413) at org.apache.ambari.server.stack.StackManager.<init>(StackManager.java:186) at org.apache.ambari.server.stack.StackManager$$FastClassByGuice$$33e4ffe0.newInstance(<generated>) at   I tried to start ambari-server as you said with --skip-database-check but it still couldn't open. Then I install the mpack with the same version before it down again, with this command:   sudo ambari-server install-mpack --mpack=/tmp/hdf-ambari-mpack-3.2.0.0-520.tar.gz --verbose   and I restart the ambari-server. Then ambari-server works without problem and I can access Ambari  from web. Perhaps it helps. ... View more

@Naresh P R I checked hiveserde2 jar and hive-exec jar ... View more

@Bala Vignesh N V I have resolved the issue with increasing spark_daemon_memory to 20 GB. Is that right approach. If not then please help me with right approach. ... View more

@Sindhu Thanks for the information. ... View more

Hi @Ashnee Sharma, can you please try by setting "hive.groupby.skewindata=true" to make randomized shuffle before reduce. In any case the following syntax should produce the accurate result select count(1) from ( select a21.company_code from dim_investment a21 group by a21.company_code) aa inner group by ensure that there should be a mapper executed before counting the distinct rows. ... View more