Day: January 16, 2021

Internal error while querying the Host Monitor


Graphs are not displayed in the cloudera dashboard and throwing error after starting the cluster


Click on the cloudera management service and click restart.

It take sometime for the realtime graphs to reflect on the dashboard!

-bash: locate: command not found (Solved)


[root@ip-xxx ~]# which locate
/usr/bin/which: no locate in (/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)

Use yum to install mlocate package

[root@ip-xxx ~]# yum install mlocate -y
Loaded plugins: amazon-id, rhui-lb, search-disabled-repos
cloudera-manager                                                                                                                                                      |  951 B  00:00:00
mysql-connectors-community                                                                                                                                            | 2.6 kB  00:00:00
mysql-tools-community                                                                                                                                                 | 2.6 kB  00:00:00
mysql56-community                                                                                                                                                     | 2.6 kB  00:00:00
rhui-REGION-client-config-server-7                                                                                                                                    | 2.1 kB  00:00:00
rhui-REGION-rhel-server-releases                                                                                                                                      | 2.0 kB  00:00:00
rhui-REGION-rhel-server-rh-common                                                                                                                                     | 2.1 kB  00:00:00
Resolving Dependencies
--> Running transaction check
---> Package mlocate.x86_64 0:0.26-8.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

 Package                               Arch                                 Version                                     Repository                                                      Size
 mlocate                               x86_64                               0.26-8.el7                                  rhui-REGION-rhel-server-releases                               113 k

Transaction Summary
Install  1 Package

Total download size: 113 k
Installed size: 379 k
Downloading packages:
mlocate-0.26-8.el7.x86_64.rpm                                                                                                                                         | 113 kB  00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mlocate-0.26-8.el7.x86_64                                                                                                                                                 1/1
  Verifying  : mlocate-0.26-8.el7.x86_64                                                                                                                                                 1/1

  mlocate.x86_64 0:0.26-8.el7


Update the locate repository

[root@ip-xxx ~]# updatedb

/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.


While executing export data from HDFS to RDBMS using sqoop ,because of non existing accumulo home,this error is triggered in hadoop

[root@ip-xxx ~]# [root@ip-172-31-60-27 ~]# sqoop export --connect jdbc:mysql://localhost:3306/tes                                                                                                             t \
> --table t \
> --username root --password 123 \
> --export-dir root/data \
> --fields-terminated-by ',' --lines-terminated-by '\n'

Warning: /opt/cloudera/parcels/CDH-5.15.1-1.cdh5.15.1.p0.4/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
21/01/15 18:48:01 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.15.1
Missing argument for option: connect


Make a accumulo home directory in var/lib

Add the environment variable for accumulo home in the /etc/profile file

[root@ip-xxx ~]# mkdir -p /var/lib/accumulo
[root@ip-xxx~]# vi /etc/profile
[root@ip-xxx ~]# cat /etc/profile|grep 'ACCU'
[root@ip-xxx ~]# source /etc/profile