@arjun more You can follow below steps to get it resolved, - Add the following classpath in file "/etc/sqoop/conf/sqoop-env.sh" export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/usr/hdp/current/hive-client/lib/* - Make sure you have installed the Hive client in the node where Oozie server is running. - Add hive-exec jar in oozie lib - Also make sure yarn user is present in HDFS(/user/yarn directory). And restart Oozie server and try again. ... View more

@arjun more This might help you please try it, There should be a table named by namespace for maintaining the inforamtion of tables, which is already exists as your error states. While starting the process HMaster it will create the namespace directory under /hbase directory So thats why it i showing the Table Exists Exception. We have to manually repair the Hbase Metastore by using offline command as, $HBASE_HOME/bin/hbase org.apache.hadoop.hbase.util.hbck.OfflineMetaRepair Start Hbase. If it is not working use the zookeeper client for removing it from the Hbase Master host, $ZK_HOME/bin/zkCli.sh -server <ZK_SERVER> -> ls / -> rmr /hbase -> exit ... View more

@ed day This Error "Access denied for user 'hive'@'s2.royble.co.uk' (using password: YES)" itself states that you are entering wrong password for hive user crerated in Mysql. To solve this Login to mysql mysql> drop database hive; And retry the installation of Hive service in ambari. ... View more

@Hugo Felix Can you put value of following properties in job.properties and try again, Current values in job.properties, job-tracker=hdfs://192.168.0.73:8021 jobTracker=hdfs://192.168.0.73:8021 Replace with job-tracker=192.168.0.73:<PORT> jobTracker=192.168.0.73:<PORT> where <PORT>= Value from Ambari UI -> YARN ->yarn.resourcemanager.address And then try again. ... View more