@Harry Li Do the following as root create the hive user with the following privileges mysql -u root -h localhost Create user hive identified by 'hive'; grant all on hive.* to hive; GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'localhost' IDENTIFIED BY 'hive'; GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'<FQDN_of_Mysql>'IDENTIFIED BY 'hive'; flush privileges; quit; As the hive user with the assumption, here database,user and password are hive for simplicity mysql -u hive -phive create database hive; show databases; quit; Now use these credentials for setting up the hive database and user n Ambari user and test connection to the hive database, it should succeed before you can successfully start hive !! ... View more

@Kalyan Das I didn't see the repos registration step in the snippet you shared Create an internal HDP repository called repo.json with the below contents { "Repositories":{ "base_url":"http://<s3.amazonaws.com-repo-server>/hdp/centos6/HDP-2.6.3.0", "verify_base_url":true } } Create an internal hdputils-repo called hdputils-repo.json with below contents { "Repositories":{ "base_url":"http://<s3.amazonaws.com-repo-server>/hdp/centos6/HDP-UTILS-1.1.0.21", "verify_base_url":true } } Register your blueprint with ambari server Setup Internal repo via REST API curl -H "X-Requested-By: ambari"-X PUT -u admin:admin http://<ambari-server-hostname>:8080/api/v1/stacks/HDP/versions/2.6/operating_systems/redhat6/repositories/HDP-2.6 -d @repo.json Then curl -H "X-Requested-By: ambari"-X PUT -u admin:admin http://<ambari-server-hostname>:8080/api/v1/stacks/HDP/versions/2.6/operating_systems/redhat6/repositories/HDP-UTILS-1.1.0.20 -d @hdputils-repo.json In the above example, you are executing the commands from within the directory where your repo.json and hdputils-repo.json make sure the HDP bits are accessible when you hit the below URL'S http://<s3.amazonaws.com-repo-server>/hdp/centos6/HDP-UTILS-1.1.0.21 http://<s3.amazonaws.com-repo-server>/hdp/centos6/HDP-2.6.3.0 Kuldeep Kulkarni has a great document on the process ... View more

@Lian Jiang Can you share your blueprint after stripping iit of site specific info? ... View more

@Deepak SANAGAPALLI If the MySQL connector doesn't exist just run the below command the default install dir is /usr/share/java/ # yum install -y mysql-connector-java Then rerun the ambari setup # ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar That should resolve the issue ... View more

@Nanda Kumar To my understanding, there is no option of like Dual boot in an HDP installation where you either start the 2.6.x or the 3.0. As reiterated the only option is to have 2 clusters running separately and putting a Knox gateway in front so you can connect to the cluster of your choice. I haven't tested this setup as yet but looks a more logical approach. HTH ... View more

@Nanda Kumar That can't be possible, because when you upgrade all the executables will point to the new version. HDP 3.0 removed some components as you noticed the Ambari views inclusive but there are plans to replace ambari views maybe in tech preview in the new release. I would advise you have a separate version of HDP clusters, especially if you have the last release of 2.6.x the support still runs and HDP 3.0 is still new so most production clusters will still run 2.6. There are many changes in HDP 3.0 like namenode federation etc which will need time to adopt. HTH ... View more

@Sanaz Janbakhsh Yes that should bring back the SQL guru in you 🙂 The is also new Zeppelin 0.8.0 which has new futures I haven't explored. ... View more

@Harry Li I am almost sure the repos are HA configure I just noticed you have double // after updates in your URL is that correct?a ... View more

@Amol Gharpure Can you share your krb5.conf? Is your domain configured and nslookup <hostname> is working verify that your /etc/resolv.conf is well configured? Ensure JCE is installed on the Ambari Server. ... View more