About Shelton

Shelton · ‎02-02-2016

I think you need to run the below statement for the user bigotes this will allow him to grant the privileges to others. > su - hive > hive hive > GRANT SELECT ON TABLE logs TO bigotes WITH GRANT OPTION;

Shelton · ‎02-01-2016

@Kibrom Gebrehiwot Grab Artem Ervits answer

Shelton · ‎02-01-2016

The ZooKeeper server continually saves znode snapshot files and, optionally, transactional logs in a Data Directory to enable you to recover data. It's a good idea to back up the ZooKeeper Data Directory periodically. Although ZooKeeper is highly reliable because a persistent copy is replicated on each server, recovering from backups may be necessary if a catastrophic failure or user error occurs. When you use the default configuration, the ZooKeeper server does not remove the snapshots and log files, so they will accumulate over time. You will need to clean up this directory occasionally, taking into account on your backup schedules and processes. To automate the cleanup, a zkCleanup.sh script is provided in the bin directory of thezookeeper base package. Modify this script as necessary for your situation. In general, you want to run this as a cron task based on your backup schedule. The data directory is specified by the dataDir parameter in the ZooKeeper configuration file, and the data log directory is specified by the dataLogDir parameter.

Shelton · ‎02-01-2016

@Bharathkumar B First comment out the modified IP address in /etc/hosts .. Dont remove these 2 lines 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 # 192.168.192.100 # Modified IP Don't panic if you can access the console as root run #ifconfig This will display your new IP and use that to acces ambari or whatever UI you. http://newIP:8080 The original IP address is not hard code in any config files !

Shelton · ‎02-01-2016

Of course that possible. This doc could help you Topology scripts are used by Hadoop to determine the rack location of nodes Topology configuration

Shelton · ‎01-21-2016

Those blocks are already replicated or will be reconstructed so from the survivng nodes In order to forcefully let the namenode leave safemode, following command should be executed depending on the version of hadoop bin/hadoop dfsadmin -safemode leave hdfs dfsadmin -safemode leave

Shelton · ‎01-18-2016

@emaxwel @Artem @neeraj Gentlemen thanks for all your responses.Its unfortunate the bits can't be installed elsewhere except in /usr/hdp and furthermore administration of the various named used could have been simplified I am from the Oracle Application background at most there are 2 users for the ebs application and database. I will reformat the 4 servers. @emaxwell you have a very valid argument on the segregation of duties I will try to incorporate that "security concern" I dont want some dark angel poke holes in my production cluster

Shelton · ‎01-14-2016

@Artem@neeraj Thanks guys for your responses as you realise HDP creates a couple of users and bit difficult to manage across the cluster. 1. I want to have only one user eg.tom to own all the hive,hdfs,pig etc as it easy to ssh to any server and quickly be effective avoiding the su or sudo which file should I edit to achieve this ? 2. I have done a lot of Linux installs the default HDP FS layout doesn't please me at all I want to install HDP outside the /var /usr or /etc directories so if anything goes wrong I can just delete all files in that partition and and relaunch after some minor cleanup. My reasoning is I would like to allocate /u01 like 300 GB HDD on each of the 4 server in the cluster so I end up with 1.2 T after HDFS format for data.

Shelton · ‎01-14-2016

failed-cluster-install.pdfHi all, I have test driven the sandbox for a while and I decided to take my knowledge to another level. I got 4 refurbished PowerEdge servers 2 Dell 2850 and 2 Dell 2950. The Ambari server preparation and host discovery was successful see attached pdf. In the assign master I realised the Ambari server was overloaded so I reassigned some components to other servers. I was lost when it came to assign slave and client ONLY one of the servers have been check so I decided to go with the default. The Install start and smoke test failed.(Attached pdf) I don't intend to create multiple users across the cluster ,how do I achieve this which file should I edit prior to the launch ? Below extract of the user creation error 2016-01-14 00:25:23,320 - Group['hadoop'] {'ignore_failures': False} 2016-01-14 00:25:23,320 - Group['users'] {'ignore_failures': False} 2016-01-14 00:25:23,320 - Group['knox'] {'ignore_failures': False} 2016-01-14 00:25:23,320 - User['hive'] {'gid': 'hadoop', 'ignore_failures': False, 'groups': ['hadoop']} 2016-01-14 00:25:23,321 - User['storm'] {'gid': 'hadoop', 'ignore_failures': False, 'groups': ['hadoop']} 2016-01-14 00:25:23,322 - User['zookeeper'] {'gid': 'hadoop', 'ignore_failures': False, 'groups': ['hadoop']} Any advice is welcome

Shelton · ‎01-07-2016

Just reset the root password I had to reset the MySQL password to do so follow the below process.Start the DB if its down [root@sandbox]# service mysqld start Starting mysqld: [ OK ] Reset the MySQL password [root@sandbox]# mysqladmin -u root -h sandbox.hortonworks.com password 'newpassword' [root@sandbox]# mysqladmin -u root password 'newpassword' Try out the new password and it seems to work out well [root@sandbox]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select user(); After validating the successful logon retry

Online	Offline
Last Visited	‎01-21-2025 02:33 AM

Member Since	‎01-19-2017 04:35 AM
Last Visited	‎01-21-2025 02:33 AM
Posts	3,654
Kudos received	618

Cloudera Community

Re: NiFi ERR_CONNECTION_REFUSED from other compute...

Re: What is the difference between spark_shuffle &...

Re: Getting java warning after staring NiFi

Re: When enabling Kerberos using the wizard, an er...

Re: ambari metrics collector not starting on a nod...

Re: hive error GRANT PERMISSIONS

Re: How to solve "Connection refused " errors in H...

Re: How to clean up files in Zookeeper Directory

Re: i have accidentally changed the hortonworks IP...

Re: Deploying hadoop cluster

Re: How to verify if NameNode is good to leave saf...

Re: Ambari custom install failure

Re: Ambari custom install failure

Ambari custom install failure

Re: SQOOP - MYSQL - Practice test instance