1) what this log for /var/log/hbase/gc.log-201706041710 ? 2) Error as below on Hbase log GC ? centos:/var/log/hbase # tailf gc.log-201706041710 2017-06-05T09:02:36.768+0800: 57127.541: [GC (Allocation Failure) 2017-06-05T09:02:36.769+0800: 57127.541: [ParNew: 600799K->49774K(629120K), 0.0073147 secs] 1457924K->907076K(2027264K), 0.0075249 secs] [Times: user=0.12 sys=0.00, real=0.01 secs] 2017-06-05T09:02:40.990+0800: 57131.762: [GC (Allocation Failure) 2017-06-05T09:02:40.990+0800: 57131.762: [ParNew: 609006K->44417K(629120K), 0.0074685 secs] 1466308K->907097K(2027264K), 0.0076719 secs] [Times: user=0.12 sys=0.00, real=0.01 secs] 2017-06-05T09:03:33.493+0800: 57184.265: [GC (Allocation Failure) 2017-06-05T09:03:33.493+0800: 57184.265: [ParNew: 603649K->40908K(629120K), 0.0089747 secs] 1466329K->903627K(2027264K), 0.0091741 secs] [Times: user=0.09 sys=0.01, real=0.01 secs] 2017-06-05T09:03:37.142+0800: 57187.915: [GC (Allocation Failure) 2017-06-05T09:03:37.142+0800: 57187.915: [ParNew: 600140K->46821K(629120K), 0.0105207 secs] 1462859K->915053K(2027264K), 0.0107302 secs] [Times: user=0.13 sys=0.00, real=0.01 secs] 2017-06-05T09:03:53.208+0800: 57203.980: [GC (Allocation Failure) 2017-06-05T09:03:53.208+0800: 57203.980: [ParNew: 606053K->46967K(629120K), 0.0062205 secs] 1474285K->915216K(2027264K), 0.0064273 secs] [Times: user=0.09 sys=0.01, real=0.01 secs] 2017-06-05T09:04:34.979+0800: 57245.752: [GC (Allocation Failure) 2017-06-05T09:04:34.979+0800: 57245.752: [ParNew: 606199K->43336K(629120K), 0.0098484 secs] 1474448K->919955K(2027264K), 0.0100675 secs] [Times: user=0.13 sys=0.00, real=0.01 secs] 2017-06-05T09:04:38.378+0800: 57249.150: [GC (Allocation Failure) 2017-06-05T09:04:38.378+0800: 57249.150: [ParNew: 602568K->40051K(629120K), 0.0076083 secs] 1479187K->922158K(2027264K), 0.0078408 secs] [Times: user=0.10 sys=0.00, real=0.01 secs] 2017-06-05T09:05:30.275+0800: 57301.047: [GC (Allocation Failure) 2017-06-05T09:05:30.275+0800: 57301.047: [ParNew: 599283K->32614K(629120K), 0.0057252 secs] 1481390K->914735K(2027264K), 0.0512496 secs] [Times: user=0.08 sys=0.00, real=0.05 secs] 2017-06-05T09:05:38.363+0800: 57309.135: [GC (Allocation Failure) 2017-06-05T09:05:38.363+0800: 57309.135: [ParNew: 591846K->35399K(629120K), 0.0083321 secs] 1473967K->922741K(2027264K), 0.0085566 secs] [Times: user=0.10 sys=0.01, real=0.00 secs] ... View more

Server 1 :- 192.168.154.111 (centos) Server 2 :- 192.168.154.113 (centos2) 1) First install the client on server from where you want to connect Configure Repository and install client [root@centos2 ~]# yum install mysql-client 2) My Sql software installed on centos2 [root@centos2 ~]# yum install mysql-server 3)Connected to Mysql on Centos2, Following user exist before creating Hive user and Database. #mysql -u root -p password mysql> Select host,user from mysql.user; +-----------------+-------+ | host | user | +-----------------+-------+ | localhost | root | +-----------------+-------+ 8 rows in set (0.00 sec) Creating hive user and database mysql> create user 'hive'@'192.168.154.111' identified by 'hive'; Query OK, 0 rows affected (0.05 sec) mysql> create user 'hive'@'localhost' identified by 'hive'; Query OK, 0 rows affected (0.00 sec) mysql> create database hive; Query OK, 1 row affected (0.00 sec) mysql> grant ALL ON hive.* TO 'hive'@'192.168.154.111'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> flush hosts; Query OK, 0 rows affected (0.00 sec) mysql> grant ALL ON hive.* TO 'hive'@'localhost'; Query OK, 0 rows affected (0.00 sec) mysql> Select host,user from mysql.user; +-----------------+-------+ | host | user | +-----------------+-------+ | % | oozie | | 127.0.0.1 | oozie | | 127.0.0.1 | root | | 192.168.154.111 | hive | | 192.168.154.111 | oozie | | 192.168.154.113 | oozie | | ::1 | root | | localhost | hive | | localhost | oozie | | localhost | root | +-----------------+-------+ 10 rows in set (0.00 sec) 4) Verify you able to connect server MySQL server using the client ( Client Must be installed from which server you connecting), Verify user from ambari-server 192.168.154.111(Client) and 192.168.154.113(server) is MySQL Server IP address [root@centos ~]# mysql -u hive -h 192.168.154.113 -p Enter password: Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select user(); +----------------------+ | user() | +----------------------+ | hive@centos.test.com | +----------------------+ 1 row in set (0.01 sec) mysql> exit; [root@centos ~]# 5) Above Client not able to connect to MY sql server , we need to grant permission as below. mysql> grant ALL ON hive.* TO 'hive'@'%' identified by 'hive'; Query OK, 0 rows affected (0.00 sec) mysql> show grants for hive; +-----------------------------------------------------------------------------------------------| Grants for hive@% -----------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'hive'@'%' IDENTIFIED BY PASSWORD '*4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC' | | GRANT ALL PRIVILEGES ON `hive`.* TO 'hive'@'%' |+-------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) Once more verification from Ambari-server, is Hive username and password is working fine [root@centos]#/usr/lib/hive/bin/schematool -initSchema -dbType mysql -userName hive -passWord hive Metastore connection URL: jdbc:mysql://centos2.test.com/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive Starting metastore schema initialization to 0.13.0 Initialization script hive-schema-0.13.0.mysql.sql Initialization script completed schemaTool completeted [root@centos ~]# ... View more