About aliyesami

bandarusridhar1 · ‎07-12-2017

@Sami Ahmad For changing the Ranger Admin password, we need to change the password in 3 different locations. 1. In Ambari you need to change the password at highlighted places: 2. Login to ranger using admin/admin, click on the profile at right-top, then click on change password. Below screenshot helps you to navigate Note: Password should be same across all the places and it should be minimum 8 characters. Hope this helps you.

aliyesami · ‎07-11-2017

this article fixed the issue. The key version number was mismatching between the keytab and the kdc . The keytab files must have been hanging around from previous installation . https://cwiki.apache.org/confluence/display/AMBARI/Automated+Kerberization+Troubleshooting

vperiasamy · ‎07-11-2017

where is ranger running? If it is on 'hadoop1', then it is connecting to db from 'hadoop1'. You could also create 'root'@'%' user.

aliyesami · ‎07-11-2017

awesome .. that worked . thanks

aliyesami · ‎07-07-2017

ok I found this jar at the following location and errors are fixed http://repo.hortonworks.com/content/groups/public/org/apache/hive/hcatalog/hive-hcatalog-hbase-storage-handler/0.13.0.2.1.1.0-385/

ssahi · ‎07-06-2017

hi @Sami Ahmad The pig view isnt created by default, nor created with teh installation of the pig service. Using an admin account in Ambari, navigate to Manage Ambari -> Views -> Pig and click the Create Instance view and fill out the details. The view will then appear in the dropdown list.

narendrakumar · ‎07-10-2017

@Sami Ahmad Please check the metastore and hiveserver2 logs (just to confirm if they started fine or noe). Also, check if the user which fires the connection command has proper permission for the '/user/hive' folder in the hdfs.

jsensharma · ‎07-05-2017

@Sami Ahmad Your Compilation Issue is resolved. For which the thread was opened. Regarding Connection refused, the troubleshooting is completely different. Please open separate HCC thread. And in Parallel check if the 10000 port is opened by the hive process on the mentioned host "localhost" or not? Or check the hostname is pointing to correct hive instance? # netstat -tnlpa | grep 10000 . Also check if there is any firewall issue in accessing the hive 10000 port if hive is running on remote host? # telnet localhost 1000 # telnet $HIVE_HOSTNAME 10000

ssahi · ‎06-29-2017

Hi @Sami Ahmad Check out the parameters --target-dir and --warehouse-dir that can be used with the sqoop-import command. There are more details here: https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_controlling_the_import_process_2

jsensharma · ‎07-05-2017

Duplicate Thread Answered Here: https://community.hortonworks.com/questions/110307/please-help-compile.html#answer-110322

Online	Offline
Last Visited	‎11-03-2016 03:37 PM

Member Since	‎04-22-2016 08:38 AM
Last Visited	‎11-03-2016 03:37 PM
Posts	931
Kudos received	46

Cloudera Community

Re: NON-ANSI JOIN in hive

Re: insert query hangs from hive view ONLY

Re: cant start rest server

Re: hbase rest api failing

Re: how to read time reported by yarn

Re: ranger Admin UI password change

Re: Kerberos authentication issue

Re: Ranger test db connection failing

Re: cant run yarn-utils.py , with python 3.3.3

Re: errors when invoking pig with useHCatalog opti...

Re: pig view missing from Ambari console

Re: hives jdbc connection refused issue

Re: please help compile

Re: hive related questions

Re: jdbc class not found error