@nejm hadjmbarek Set below property in oozie-site.xml to * to resolve this issue hadoop.proxyuser.oozie.host ... View more

@Tajinderpal Singh Below are the valid examples for running hive queries Example of running a query from the command line $HIVE_HOME/bin/hive -e 'select a.col from tab1 a' Example of setting Hive configuration variables $HIVE_HOME/bin/hive -e 'select a.col from tab1 a' --hiveconf hive.exec.scratchdir=/home/my/hive_scratch --hiveconf mapred.reduce.tasks=32 Example of dumping data out from a query into a file using silent mode $HIVE_HOME/bin/hive -S -e 'select a.col from tab1 a' > a.txt Example of running a script non-interactively from local disk $HIVE_HOME/bin/hive -f /home/my/hive-script.sql Example of running a script non-interactively from a Hadoop supported filesystem (starting in Hive 0.14) $HIVE_HOME/bin/hive -f hdfs://<namenode>:<port>/hive-script.sql $HIVE_HOME/bin/hive -f s3://mys3bucket/s3-script.sql Example of running an initialization script before entering interactive mode $HIVE_HOME/bin/hive -i /home/my/hive-init.sql ... View more

@Manish Bhandari Please try below steps: 1. You are logged in as root user so you can easily change permission of any file/directory using below command chown root:root -R /var/log/ambari-server 2. Try to check logs again by less/cat command 3. Please check if your ambari-server is running service ambari-server status 4. If its not running then please try to start it using below command service ambari-server start 5. If ambari-server is running, can you please check if it is listening on port 8080? netstat -tulpn|grep 8080 6. If above command shows that your ambari-server is running however you are still unable to access it from your local machine then please check if your home/corporate firewall is blocking connection to 8080. Please try to telnet to 8080 from your local machine, if you are using windows then try to run telnet command from cmd telnet <ambari-server-ip-address> 8080 7. If you find that your ambari-server is running and listening on 8080 then you can check your virtualbox port frowarding settings, please refer below link to verify your VirtualBox network settings https://community.hortonworks.com/questions/17168/lab-0-setup-start-the-sandbox-vm-and-open-ambari.html 8. If above step doesn't work then you can create SSH tunnel and can access ambari UI via http://localhost:8080 from your browser Run below command from your terminal if you are using Mac/Linux ssh -L 8080:<ambari-server-ip-address>:8080 root@<ambari-server-ip-address> Hope this information helps! Happy Hadooping 🙂 ... View more