https://community.cloudera.com/t5/Support-Questions/Unable-To-Upload-A-Table-In-Hive-java-sql-SQLException-Error/m-p/185233#M147340 <P><A rel="user" href="https://community.cloudera.com/users/51358/amoghsuman.html" nodeid="51358">@Amogh Suman</A>,</P><P>Can you please try running the below commands and see if core-site.xml is created in /usr/hdp/current/hadoop-client/conf/ folder and also /etc/hadoop/conf is created</P><PRE># curl -k -u {username}:{password} -H "X-Requested-By:ambari" -i -X PUT -d '{"HostRoles": {"state": "INSTALLED"}}' <A href="http://{ambari-host}:{ambari-port}/api/v1/clusters/{clustername}/hosts/{hostname}/host_components/HDFS_CLIENT" target="_blank">http://{ambari-host}:{ambari-port}/api/v1/clusters/{clustername}/hosts/{hostname}/host_components/HDFS_CLIENT</A> # curl -k -u {username}:{password} -H "X-Requested-By:ambari" -i -X PUT -d '{"HostRoles": {"state": "INSTALLED"}}' <A href="http://{ambari-host}:{ambari-port}/api/v1/clusters/{clustername}/hosts/{hostname}/host_components/YARN_CLIENT" target="_blank">http://{ambari-host}:{ambari-port}/api/v1/clusters/{clustername}/hosts/{hostname}/host_components/YARN_CLIENT</A> # curl -k -u {username}:{password} -H "X-Requested-By:ambari" -i -X PUT -d '{"HostRoles": {"state": "INSTALLED"}}' <A href="http://{ambari-host}:{ambari-port}/api/v1/clusters/{clustername}/hosts/{hostname}/host_components/MAPREDUCE2_CLIENT" target="_blank">http://{ambari-host}:{ambari-port}/api/v1/clusters/{clustername}/hosts/{hostname}/host_components/MAPREDUCE2_CLIENT</A> # yum install -y hadoop hadoop-hdfs hadoop-libhdfs hadoop-yarn hadoop-mapreduce hadoop-client openssl</PRE><P>In the curl commands replace the {username} with ambari username, {password} with ambari password , {ambari-host} with hostname, {port} with ambari port(default 8080) ,{clustername} and {hostname}.</P><P>Thanks,</P><P>Aditya</P> Wed, 10 Jan 2018 01:48:54 GMT asirna 2018-01-10T01:48:54Z