I was trying to install the hawq plugin on ambari on top of hdp 2.3 and it fails. The command I am using to check the status is
curl -u admin:admin -H X-Requested-By:devops -i -X GET "http://localhost:8080/api/v1/clusters/Sandbox/services/HAWQ?fields=ServiceInfo/state"
And the procedure for creating hawq on hdp is here [link] ( http://blog.pivotal.io/big-data-pivotal/p-o-v/pivotal-hawq-lands-in-the-hortonworks-sandbox). I would be grateful if someone can say what could be the reason for failure
You are using the wrong version of HDP with HAWQ 1.3. You need to use HDP 2.2, not 2.3. Support for HDP 2.3 is coming but not available yet.