About prashanthshetty

prashanthshetty · ‎07-14-2020

Adding a bit of clarification to above mentioned solution. Find "Ranger External URL" in the field Ranger > Configs > Advanced > Ranger Settings. It will be something like "http://<ranger_admin_host>:6080" . Copy this URL and update the particular service to which Ranger plugin is enabled. For example : If its HDFS, HDFS > Configs > Advanced > Advanced ranger-hdfs-security > ranger. plugin. hdfs. policy. rest. url. Usually this field should be auto populated by Ranger External URL value. If its not, it will be like "{{policy_mgr_url}}" . Update this field by adding "Ranger External URL". Restart Ranger service, ranger KMS service and all required services.

prashanthshetty · ‎05-31-2020

@ccibi75Thanks for the solution to resolve timeline server v2.0 start issue in HDP3.x. It worked!!!

prashanthshetty · ‎05-07-2019

Hi, Thanks for the resolution. Is there any specific procedures to upgrade krb packages to 1.15.1-19?.. Detailed steps to upgrade and post upgrade to start hadoop cluster would be more helpful

prashanthshetty · ‎03-14-2019

do sudo yum install -y mysql-connector-java to install mysql-connector-java.jar Check the path where mysql-connector-java is installed. [root@c902f08x05 ~]# rpm -ql mysql-connector-java-* /usr/share/doc/mysql-connector-java-5.1.25 /usr/share/doc/mysql-connector-java-5.1.25/CHANGES /usr/share/doc/mysql-connector-java-5.1.25/COPYING /usr/share/doc/mysql-connector-java-5.1.25/docs /usr/share/doc/mysql-connector-java-5.1.25/docs/README.txt /usr/share/doc/mysql-connector-java-5.1.25/docs/connector-j.html /usr/share/doc/mysql-connector-java-5.1.25/docs/connector-j.pdf /usr/share/java/mysql-connector-java.jar /usr/share/maven-fragments/mysql-connector-java /usr/share/maven-poms/JPP-mysql-connector-java.pom [root@c902f08x05 ~]# check the path and run ambari-server setup with jdbc driver path ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar and re-try hive-client install,.it should work.

prashanthshetty · ‎03-13-2019

@Jay Kumar SenSharma [root@c902f10x09 ~]# grep 'database_name' /etc/ambari-server/conf/ambari.properties server.jdbc.database_name=ambari [root@c902f10x09 ~]# grep 'schema' /etc/ambari-server/conf/ambari.properties server.jdbc.postgres.schema=ambari [root@c902f10x09 ~]# grep 'jdbc' /etc/ambari-server/conf/ambari.properties custom.mysql.jdbc.name=mysql-jdbc-driver.jar previous.custom.mysql.jdbc.name=mysql-connector-java.jar server.jdbc.connection-pool=internal server.jdbc.database=postgres server.jdbc.database_name=ambari server.jdbc.driver=org.postgresql.Driver server.jdbc.hostname=localhost server.jdbc.port=5432 server.jdbc.postgres.schema=ambari server.jdbc.rca.driver=org.postgresql.Driver server.jdbc.rca.url=jdbc:postgresql://c902f10x09.gpfs.net:5432/ambari server.jdbc.rca.user.name=ambari server.jdbc.rca.user.passwd=/etc/ambari-server/conf/password.dat server.jdbc.url=jdbc:postgresql://c902f10x09.gpfs.net:5432/ambari server.jdbc.user.name=ambari server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat For your reference.

prashanthshetty · ‎03-13-2019

@Jay Kumar SenSharma It tried adding "ambari." to query and it works. ambari=# update ambari.repo_version set stack_id = (select stack_id from ambari.stack where stack_version = '2.3') where display_name like 'BigInsights%'; UPDATE 1 ambari=#

prashanthshetty · ‎03-13-2019

Hi, I am trying to run below SQL query in ambari database to update one of the configuration, but query is failing with following error. I am trying to run query in ambari database. [root@c902f10x09 ~]# su - postgres Last login: Tue Mar 12 22:10:31 EDT 2019 on pts/0 JAVA at /usr/jdk64/jdk1.8.0_112 -bash-4.2$ /usr/pgsql-9.6/bin/psql psql (9.6.12) Type "help" for help. postgres=# \connect ambari You are now connected to database "ambari" as user "postgres". ambari=# update repo_version set stack_id = (select stack_id from stack where stack_version = '2.3') where display_name like 'BigInsights%'; ERROR: relation "repo_version" does not exist LINE 1: update repo_version set stack_id = (select stack_id from sta... ^ ambari=# When I try to run "update repo_version set stack_id = (select stack_id from stack where stack_version = '2.3') where display_name like 'BigInsights%';" I am getting error as "ERROR: relation "repo_version" does not exist LINE 1: update repo_version set stack_id = (select stack_id from sta..." How to resolve this?. @Aditya Sirna, any thoughts?.

prashanthshetty · ‎03-11-2019

Hi I am performing express upgrade from BigInsights 4.2.5 to HDP 2.6.4 and express upgrade pre-check, I am seeing critical warning " CRITICAL: Ambari Agent Distro/Conf Select Versions: on all my hosts. I did verify in "/usr/hdp" of my hosts and I see files only of HDP 2.6.4.0-91 version [root@c902f10x09 hdp]# pwd /usr/hdp [root@c902f10x09 hdp]# ls -la total 8 drwxr-xr-x 4 root root 39 Mar 10 22:21 . drwxr-xr-x. 18 root root 213 Mar 10 22:20 .. drwxr-xr-x 38 root root 4096 Mar 10 22:27 2.6.4.0-91 drwxr-xr-x 2 root root 4096 Mar 10 22:27 current [root@c902f10x09 hdp]# How can I resolve this issue?..

prashanthshetty · ‎03-11-2019

Hi I am performing express upgrade from BigInsights4.2.5 to HDP2.6.4 and during express upgrade I am seeing CRITICAL: Ambari Agent Distro/Conf Select Versions on all the hosts. I verified in /usr/hdp folder of all hosts and I see "2.6.4.0-91" version on all the hosts. [root@node1 hdp]# pwd/usr/hdp[root@node1 hdp]# ls -latotal 8drwxr-xr-x 4 root root 39 Mar 10 22:12 .drwxr-xr-x. 18 root root 213 Mar 10 22:12 ..drwxr-xr-x 34 root root 4096 Mar 10 22:18 2.6.4.0-91drwxr-xr-x 2 root root 4096 Mar 10 22:18 current[root@node1 hdp]# hdp-select versions also returns single version. [root@node1 hdp]# hdp-select versions 2.6.4.0-91 [root@node1 hdp]# How this issue can be resolved to resolve the critical warnings during express upgrade?..

prashanthshetty · ‎03-11-2019

Hi I am performing express upgrade from BigInsights4.2.5 to HDP2.6.4 and during express upgrade I am seeing CRITICAL: Ambari Agent Distro/Conf Select Versionson on all the hosts. I verified in /usr/hdp folder of all hosts and I see "2.6.4.0-91" version on all the hosts. [root@c902f10x11 hdp]# pwd /usr/hdp [root@c902f10x11 hdp]# ls -la total 8 drwxr-xr-x 4 root root 39 Mar 10 22:12 . drwxr-xr-x. 18 root root 213 Mar 10 22:12 .. drwxr-xr-x 34 root root 4096 Mar 10 22:18 2.6.4.0-91 drwxr-xr-x 2 root root 4096 Mar 10 22:18 current [root@c902f10x11 hdp]# How this issue can be resolved?.. Thanks

prashanthshetty · ‎01-22-2019

Hi, In order to find the adequate space in any directory during installation or upgrade procedures, for example while doing HDP upgrade you should verify about the availability of adequate space on /usr/hdp for the target HDP version. For that use below format: df -h <Path_of_interest> Example : [alex@machine1]# df -h /usr/hdp/ Filesystem Size Used Avail Use% Mounted on /dev/mapper/system-root 528G 22G 506G 5% / [alex@machine1]# You can all parameters like Size of disk, used space, available spave and percentage of usage.

prashanthshetty · ‎07-12-2018

@Aditya : Thank, this is really informative

prashanthshetty · ‎03-27-2018

Back up all the data that resides under <File_system_mount point>/apps/accumulo/data directory. Remove the <File_system_mount point>/apps/accumulo/data directory by running sudo -u hdfs hdfs dfs -rm -R /apps/accumulo/data Reinitialize the Accumulo service, run sudo -u accumulo ACCUMULO_CONF_DIR=/etc/accumulo/conf/server accumulo init --instance-name hdp-accumulo-instance --clear-instance-name. Enter a valid password when asked for initial password for root. Update the Accumulo root password and trace user password from the Ambari GUI. Set it to the same password as provided in the previous step. Restart Accumulo. After the Accumulo service gets started successfully and the service check passes, you can restore the data.

prashanthshetty · ‎12-07-2017

This works absolutely fine. Thanks for workaround.

Online	Offline
Last Visited	‎07-13-2020 10:35 PM

Date Registered	‎05-07-2019 12:16 AM
Last Visited	‎07-13-2020 10:35 PM
Total Messages Posted	14
Total Kudos Received	1

Re: Unable Start NameNode after Ranger HDFS Plugin...

Re: Timeline Service V2.0 Reader not starting

Re: Kerberos ticket expired ( kinit keytab success...

Re: Cannot install Hive clients

Re: SQL query is failing in ambari database

Re: SQL query is failing in ambari database

SQL query is failing in ambari database

Re: ambari agent distro/conf alert

Re: ambari agent distro/conf alert

Re: ambari agent distro/conf alert

Re: Releasing storage space from host

Re: How To: Upgrade Spectrum Scale transparency

Re: Cant start the services because of Accumulo T...

Re: Falcon Web UI is inaccessible(HTTP 503 error) ...