https://community.cloudera.com/t5/Support-Questions/Unable-To-Upload-A-Table-In-Hive-java-sql-SQLException-Error/m-p/185236#M147343 <P><A rel="user" href="https://community.cloudera.com/users/14200/asirna.html" nodeid="14200">@Aditya Sirna</A> </P><P>I tried running the first three commands using :</P><PRE>{username} as admin<BR />{password} as admin<BR />{ambari-host} as sandbox.hortonworks.com<BR />{port} with ambari port(default 8080) <BR />{clustername} as Sandbox<BR />{hostname} as sandbox.hortonworks.com</PRE><P style="margin-left: 20px;"></P><P style="margin-left: 20px;"></P><P>E.g. I ran the following command : </P><PRE>curl -k -u admin:admin -H "X-Requested-By:ambari" -i -X PUT -d '{"HostRoles": {"state": "INSTALLED"}}' <A href="http://sandbox.hortonworks.com:8080/api/v1/clusters/Sandbox/hosts/sandbox.hortonworks.com/host_components/HDFS_CLIENT" target="_blank">http://sandbox.hortonworks.com:8080/api/v1/clusters/Sandbox/hosts/sandbox.hortonworks.com/host_components/HDFS_CLIENT</A></PRE><P>But I got the following error : </P><PRE>HTTP/1.1 404 Not Found X-Frame-Options: DENY X-XSS-Protection: 1; mode=block X-Content-Type-Options: nosniff Cache-Control: no-store Pragma: no-cache Set-Cookie: AMBARISESSIONID=14jxcimd3368rh42fh6lsxsnx;Path=/;HttpOnly Expires: Thu, 01 Jan 1970 00:00:00 GMT User: admin Content-Type: text/plain Content-Length: 279 { "status" : 404, "message" : "org.apache.ambari.server.controller.spi.NoSuchParentResourceException: Parent Host resource doesn't exist. Host not found, cluster=Sa ndbox, hostname=sandbox.hortonworks.com. Host not found, cluster=Sandbox, hostname=sandbox.hortonworks.com" </PRE><P>What to do now ?</P> Wed, 10 Jan 2018 08:35:34 GMT amoghsuman 2018-01-10T08:35:34Z