Issues while installing Hive

Hi All,

I am getting following issues while installing hive.

Could you please let me know what might be the reason for the failure.

Logs :-

stderr: /var/lib/ambari-agent/data/errors-507.txt

Python script has been killed due to timeout after waiting 300 secs

stdout: /var/lib/ambari-agent/data/output-507.txt

2017-06-15 18:19:29,764 - Using hadoop conf dir: /usr/hdp/current/hadoop-client/conf
2017-06-15 18:19:29,817 - call[‘ambari-python-wrap /usr/bin/hdp-select status hive-server2’] {‘timeout’: 20}
2017-06-15 18:19:29,880 - call returned (0, ‘hive-server2 - 2.5.3.0-37’)
2017-06-15 18:19:29,882 - Stack Feature Version Info: stack_version=2.5, version=None, current_cluster_version=2.5.3.0-37 -> 2.5
2017-06-15 18:19:29,931 - Running Hive Server checks
2017-06-15 18:19:29,932 - --------------------------

2017-06-15 18:19:29,935 - Server Address List : [u’hdp-dn6-rs6.bigdatacluster.org’], Port : 10000, SSL KeyStore : None
2017-06-15 18:19:29,936 - Waiting for the Hive Server to start…
2017-06-15 18:19:29,937 - Execute[’! beeline -u ‘jdbc:hive2://hdp-dn6-rs6.bigdatacluster.org:10000/;transportMode=binary’ -e ‘’ 2>&1| awk ‘{print}’|grep -i -e ‘Connection refused’ -e ‘Invalid URL’’] {‘path’: [’/bin/’, ‘/usr/bin/’, ‘/usr/lib/hive/bin/’, ‘/usr/sbin/’], ‘user’: ‘ambari-qa’, ‘timeout’: 30}
2017-06-15 18:19:52,151 - Connection to hdp-dn6-rs6.bigdatacluster.org on port 10000 failed
2017-06-15 18:19:57,158 - Execute[’! beeline -u ‘jdbc:hive2://hdp-dn6-rs6.bigdatacluster.org:10000/;transportMode=binary’ -e ‘’ 2>&1| awk ‘{print}’|grep -i -e ‘Connection refused’ -e ‘Invalid URL’’] {‘path’: [’/bin/’, ‘/usr/bin/’, ‘/usr/lib/hive/bin/’, ‘/usr/sbin/’], ‘user’: ‘ambari-qa’, ‘timeout’: 30}
2017-06-15 18:20:14,154 - Connection to hdp-dn6-rs6.bigdatacluster.org on port 10000 failed
2017-06-15 18:20:19,160 - Execute[’! beeline -u ‘jdbc:hive2://hdp-dn6-rs6.bigdatacluster.org:10000/;transportMode=binary’ -e ‘’ 2>&1| awk ‘{print}’|grep -i -e ‘Connection refused’ -e ‘Invalid URL’’] {‘path’: [’/bin/’, ‘/usr/bin/’, ‘/usr/lib/hive/bin/’, ‘/usr/sbin/’], ‘user’: ‘ambari-qa’, ‘timeout’: 30}
2017-06-15 18:20:32,692 - Connection to hdp-dn6-rs6.bigdatacluster.org on port 10000 failed
2017-06-15 18:20:37,696 - Execute[’! beeline -u ‘jdbc:hive2://hdp-dn6-rs6.bigdatacluster.org:10000/;transportMode=binary’ -e ‘’ 2>&1| awk ‘{print}’|grep -i -e ‘Connection refused’ -e ‘Invalid URL’’] {‘path’: [’/bin/’, ‘/usr/bin/’, ‘/usr/lib/hive/bin/’, ‘/usr/sbin/’], ‘user’: ‘ambari-qa’, ‘timeout’: 30}
2017-06-15 18:20:52,756 - Connection to hdp-dn6-rs6.bigdatacluster.org on port 10000 failed
2017-06-15 18:20:57,764 - Execute[’! beeline -u ‘jdbc:hive2://hdp-dn6-rs6.bigdatacluster.org:10000/;transportMode=binary’ -e ‘’ 2>&1| awk ‘{print}’|grep -i -e ‘Connection refused’ -e ‘Invalid URL’’] {‘path’: [’/bin/’, ‘/usr/bin/’, ‘/usr/lib/hive/bin/’, ‘/usr/sbin/’], ‘user’: ‘ambari-qa’, ‘timeout’: 30}
2017-06-15 18:21:15,007 - Successfully connected to hdp-dn6-rs6.bigdatacluster.org on port 10000
2017-06-15 18:21:15,008 - Successfully stayed connected to ‘Hive Server’ on host: hdp-zk1.bigdatacluster.org and port 10000 after 105.072026968 seconds
2017-06-15 18:21:15,008 - Running HCAT checks
2017-06-15 18:21:15,008 - -------------------

2017-06-15 18:21:15,011 - checked_call[‘hostid’] {}
2017-06-15 18:21:15,054 - checked_call returned (0, ‘a8c08892’)
2017-06-15 18:21:15,055 - File[’/var/lib/ambari-agent/tmp/hcatSmoke.sh’] {‘content’: StaticFile(‘hcatSmoke.sh’), ‘mode’: 0755}
2017-06-15 18:21:15,065 - Writing File[’/var/lib/ambari-agent/tmp/hcatSmoke.sh’] because it doesn’t exist
2017-06-15 18:21:15,066 - Changing permission for /var/lib/ambari-agent/tmp/hcatSmoke.sh from 644 to 755
2017-06-15 18:21:15,067 - Execute[‘env JAVA_HOME=/usr/local/Java/jdk1.8.0_112 /var/lib/ambari-agent/tmp/hcatSmoke.sh hcatsmokeida8c08892_date211517 prepare true’] {‘logoutput’: True, ‘path’: [’/usr/sbin’, ‘/usr/local/bin’, ‘/bin’, ‘/usr/bin’, u’/usr/sbin:/sbin:/usr/lib/ambari-server/:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/var/lib/ambari-agent:/usr/hdp/current/hive-client/bin:/usr/hdp/current/hadoop-client/bin’], ‘tries’: 3, ‘user’: ‘ambari-qa’, ‘try_sleep’: 5}
TERM environment variable not set.
OK
Time taken: 6.364 seconds
OK
Time taken: 3.846 seconds
OK
Time taken: 8.421 seconds
2017-06-15 18:22:06,983 - ExecuteHadoop[‘fs -test -e /apps/hive/warehouse/hcatsmokeida8c08892_date211517’] {‘logoutput’: True, ‘bin_dir’: '/usr/sbin:/sbin:/usr/lib/ambari-server/
:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/var/lib/ambari-agent:/usr/hdp/current/hive-client/bin:/usr/hdp/current/hadoop-client/bin’, ‘user’: ‘hdfs’, ‘conf_dir’: ‘/usr/hdp/current/hadoop-client/conf’}
2017-06-15 18:22:06,992 - Execute[‘hadoop --config /usr/hdp/current/hadoop-client/conf fs -test -e /apps/hive/warehouse/hcatsmokeida8c08892_date211517’] {‘logoutput’: True, ‘try_sleep’: 0, ‘environment’: {}, ‘tries’: 1, ‘user’: ‘hdfs’, ‘path’: [u’/usr/sbin:/sbin:/usr/lib/ambari-server/*:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/var/lib/ambari-agent:/usr/hdp/current/hive-client/bin:/usr/hdp/current/hadoop-client/bin’]}
TERM environment variable not set.
2017-06-15 18:22:18,826 - Execute[’ /var/lib/ambari-agent/tmp/hcatSmoke.sh hcatsmokeida8c08892_date211517 cleanup true’] {‘logoutput’: True, ‘path’: [’/usr/sbin’, ‘/usr/local/bin’, ‘/bin’, ‘/usr/bin’, u’/usr/sbin:/sbin:/usr/lib/ambari-server/*:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/var/lib/ambari-agent:/usr/hdp/current/hive-client/bin:/usr/hdp/current/hadoop-client/bin’], ‘tries’: 3, ‘user’: ‘ambari-qa’, ‘try_sleep’: 5}
TERM environment variable not set.
OK
Time taken: 13.066 seconds
2017-06-15 18:22:49,994 - Running WEBHCAT checks
2017-06-15 18:22:49,995 - ---------------------

2017-06-15 18:22:50,001 - File[’/var/lib/ambari-agent/tmp/templetonSmoke.sh’] {‘content’: StaticFile(‘templetonSmoke.sh’), ‘mode’: 0755}
2017-06-15 18:22:50,017 - Writing File[’/var/lib/ambari-agent/tmp/templetonSmoke.sh’] because it doesn’t exist
2017-06-15 18:22:50,018 - Changing permission for /var/lib/ambari-agent/tmp/templetonSmoke.sh from 644 to 755
2017-06-15 18:22:50,036 - File[’/var/lib/ambari-agent/tmp/idtest.ambari-qa.1497531170.02.pig’] {‘owner’: ‘hdfs’, ‘content’: Template(‘templeton_smoke.pig.j2’)}
2017-06-15 18:22:50,037 - Writing File[’/var/lib/ambari-agent/tmp/idtest.ambari-qa.1497531170.02.pig’] because it doesn’t exist
2017-06-15 18:22:50,038 - Changing owner for /var/lib/ambari-agent/tmp/idtest.ambari-qa.1497531170.02.pig from 0 to hdfs
2017-06-15 18:22:50,039 - HdfsResource[’/tmp/idtest.ambari-qa.1497531170.02.pig’] {‘security_enabled’: False, ‘hadoop_bin_dir’: ‘/usr/hdp/current/hadoop-client/bin’, ‘keytab’: [EMPTY], ‘source’: ‘/var/lib/ambari-agent/tmp/idtest.ambari-qa.1497531170.02.pig’, ‘dfs_type’: ‘’, ‘default_fs’: ‘hdfs://hdp-nn2-ha.bigdatacluster.org:8020’, ‘hdfs_resource_ignore_file’: ‘/var/lib/ambari-agent/data/.hdfs_resource_ignore’, ‘hdfs_site’: …, ‘kinit_path_local’: ‘/usr/bin/kinit’, ‘principal_name’: ‘missing_principal’, ‘user’: ‘hdfs’, ‘owner’: ‘ambari-qa’, ‘hadoop_conf_dir’: ‘/usr/hdp/current/hadoop-client/conf’, ‘type’: ‘file’, ‘action’: [‘create_on_execute’], ‘immutable_paths’: [u’/apps/hive/warehouse’, u’/mr-history/done’, u’/app-logs’, u’/tmp’]}
2017-06-15 18:22:50,064 - call[‘ambari-sudo.sh su hdfs -l -s /bin/bash -c ‘curl -sS -L -w ‘"’"’%{http_code}’"’"’ -X GET ‘"’"‘http://hdp-nn2-ha.bigdatacluster.org:50070/webhdfs/v1/tmp/idtest.ambari-qa.1497531170.02.pig?op=GETFILESTATUS&user.name=hdfs’"’"’ 1>/tmp/tmpRt651q 2>/tmp/tmpKY5q9T’’] {‘logoutput’: None, ‘quiet’: False}
2017-06-15 18:22:50,386 - call returned (0, ‘TERM environment variable not set.’)
2017-06-15 18:22:50,388 - Creating new file /tmp/idtest.ambari-qa.1497531170.02.pig in DFS
2017-06-15 18:22:50,390 - call[‘ambari-sudo.sh su hdfs -l -s /bin/bash -c ‘curl -sS -L -w ‘"’"’%{http_code}’"’"’ -X PUT --data-binary @/var/lib/ambari-agent/tmp/idtest.ambari-qa.1497531170.02.pig -H ‘"’"‘Content-Type: application/octet-stream’"’"’ ‘"’"‘http://hdp-nn2-ha.bigdatacluster.org:50070/webhdfs/v1/tmp/idtest.ambari-qa.1497531170.02.pig?op=CREATE&user.name=hdfs&overwrite=True’"’"’ 1>/tmp/tmpT49gMy 2>/tmp/tmpZ9XAOI’’] {‘logoutput’: None, ‘quiet’: False}
2017-06-15 18:22:57,362 - call returned (0, ‘TERM environment variable not set.’)
2017-06-15 18:22:57,364 - call[‘ambari-sudo.sh su hdfs -l -s /bin/bash -c ‘curl -sS -L -w ‘"’"’%{http_code}’"’"’ -X PUT ‘"’"‘http://hdp-nn2-ha.bigdatacluster.org:50070/webhdfs/v1/tmp/idtest.ambari-qa.1497531170.02.pig?op=SETOWNER&user.name=hdfs&owner=ambari-qa&group=’"’"’ 1>/tmp/tmp1J2vLB 2>/tmp/tmp25VsXO’’] {‘logoutput’: None, ‘quiet’: False}
2017-06-15 18:22:57,789 - call returned (0, ‘TERM environment variable not set.’)
2017-06-15 18:22:57,792 - HdfsResource[’/tmp/idtest.ambari-qa.1497531170.02.in’] {‘security_enabled’: False, ‘hadoop_bin_dir’: ‘/usr/hdp/current/hadoop-client/bin’, ‘keytab’: [EMPTY], ‘source’: ‘/etc/passwd’, ‘dfs_type’: ‘’, ‘default_fs’: ‘hdfs://hdp-nn2-ha.bigdatacluster.org:8020’, ‘hdfs_resource_ignore_file’: ‘/var/lib/ambari-agent/data/.hdfs_resource_ignore’, ‘hdfs_site’: …, ‘kinit_path_local’: ‘/usr/bin/kinit’, ‘principal_name’: ‘missing_principal’, ‘user’: ‘hdfs’, ‘owner’: ‘ambari-qa’, ‘hadoop_conf_dir’: ‘/usr/hdp/current/hadoop-client/conf’, ‘type’: ‘file’, ‘action’: [‘create_on_execute’], ‘immutable_paths’: [u’/apps/hive/warehouse’, u’/mr-history/done’, u’/app-logs’, u’/tmp’]}
2017-06-15 18:22:57,799 - call[‘ambari-sudo.sh su hdfs -l -s /bin/bash -c ‘curl -sS -L -w ‘"’"’%{http_code}’"’"’ -X GET ‘"’"‘http://hdp-nn2-ha.bigdatacluster.org:50070/webhdfs/v1/tmp/idtest.ambari-qa.1497531170.02.in?op=GETFILESTATUS&user.name=hdfs’"’"’ 1>/tmp/tmpvWbLmM 2>/tmp/tmphPPdnv’’] {‘logoutput’: None, ‘quiet’: False}
2017-06-15 18:22:58,126 - call returned (0, ‘TERM environment variable not set.’)
2017-06-15 18:22:58,127 - Creating new file /tmp/idtest.ambari-qa.1497531170.02.in in DFS
2017-06-15 18:22:58,129 - call[‘ambari-sudo.sh su hdfs -l -s /bin/bash -c ‘curl -sS -L -w ‘"’"’%{http_code}’"’"’ -X PUT --data-binary @/etc/passwd -H ‘"’"‘Content-Type: application/octet-stream’"’"’ ‘"’"‘http://hdp-nn2-ha.bigdatacluster.org:50070/webhdfs/v1/tmp/idtest.ambari-qa.1497531170.02.in?op=CREATE&user.name=hdfs&overwrite=True’"’"’ 1>/tmp/tmpolowgX 2>/tmp/tmpkIUoT2’’] {‘logoutput’: None, ‘quiet’: False}
2017-06-15 18:22:58,860 - call returned (0, ‘TERM environment variable not set.’)
2017-06-15 18:22:58,888 - call[‘ambari-sudo.sh su hdfs -l -s /bin/bash -c ‘curl -sS -L -w ‘"’"’%{http_code}’"’"’ -X PUT ‘"’"‘http://hdp-nn2-ha.bigdatacluster.org:50070/webhdfs/v1/tmp/idtest.ambari-qa.1497531170.02.in?op=SETOWNER&user.name=hdfs&owner=ambari-qa&group=’"’"’ 1>/tmp/tmpyO87oJ 2>/tmp/tmpy4qW49’’] {‘logoutput’: None, ‘quiet’: False}
2017-06-15 18:22:59,179 - call returned (0, ‘TERM environment variable not set.’)
2017-06-15 18:22:59,181 - HdfsResource[None] {‘security_enabled’: False, ‘hadoop_bin_dir’: ‘/usr/hdp/current/hadoop-client/bin’, ‘keytab’: [EMPTY], ‘dfs_type’: ‘’, ‘default_fs’: ‘hdfs://hdp-nn2-ha.bigdatacluster.org:8020’, ‘hdfs_resource_ignore_file’: ‘/var/lib/ambari-agent/data/.hdfs_resource_ignore’, ‘hdfs_site’: …, ‘kinit_path_local’: ‘/usr/bin/kinit’, ‘principal_name’: ‘missing_principal’, ‘user’: ‘hdfs’, ‘action’: [‘execute’], ‘hadoop_conf_dir’: ‘/usr/hdp/current/hadoop-client/conf’, ‘immutable_paths’: [u’/apps/hive/warehouse’, u’/mr-history/done’, u’/app-logs’, u’/tmp’]}
2017-06-15 18:22:59,187 - Execute[’/var/lib/ambari-agent/tmp/templetonSmoke.sh hdp-dn6-rs6.bigdatacluster.org ambari-qa 50111 idtest.ambari-qa.1497531170.02.pig no_keytab false /usr/bin/kinit no_principal /var/lib/ambari-agent/tmp’] {‘logoutput’: True, ‘path’: [’/usr/sbin:/sbin:/usr/local/bin:/bin:/usr/bin’], ‘tries’: 3, ‘try_sleep’: 5}
Templeton Smoke Test (pig cmd): Failed. : {“error”:“User: hcat is not allowed to impersonate ambari-qa”}http_code <500>
2017-06-15 18:23:49,613 - Retrying after 5 seconds. Reason: Execution of ‘/var/lib/ambari-agent/tmp/templetonSmoke.sh hdp-dn6-rs6.bigdatacluster.org ambari-qa 50111 idtest.ambari-qa.1497531170.02.pig no_keytab false /usr/bin/kinit no_principal /var/lib/ambari-agent/tmp’ returned 1. Templeton Smoke Test (pig cmd): Failed. : {“error”:“User: hcat is not allowed to impersonate ambari-qa”}http_code <500>

Command failed after 1 tries

Thank you,

Regards,
Parthiban Mohan