I did the following this, mine issue has been Resolved 1) Download the “Requires: perl(DBI)” package ,we are using centos 6.8 version, download the below RPM perl-DBI-1.609-4.el6.x86_64.rpm http://rpmfind.net/linux/rpm2html/search.php?query=perl-DBI 2) Install the perl DBI rpm on Linux server [root@centos2 ~]# rpm -ivh perl-DBI-1.609-4.el6.x86_64.rpm Preparing... ########################################### [100%] 1:perl-DBI ########################################### [100%] [root@centos2 ~]# 3) [root@hostname ~]# sudo yum install mysql-community-server Loaded plugins: fastestmirror Setting up Install Process Repository HDP-UTILS-1.1.0.19 is listed more than once in the configuration Loading mirror speeds from cached hostfile Resolving Dependencies --> Running transaction check ---> Package mysql-community-server.x86_64 0:5.6.35-2.el6 will be installed --> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.35-2.el6.x86_64 --> Running transaction check ---> Package mysql-community-client.x86_64 0:5.6.35-2.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ========================================================================================================================================= Package Arch Version Repository Size ========================================================================================================================================= Installing: mysql-community-server x86_64 5.6.35-2.el6 mysql56-community 54 M Installing for dependencies: mysql-community-client x86_64 5.6.35-2.el6 mysql56-community 18 M Transaction Summary ========================================================================================================================================= Install 2 Package(s) Total download size: 73 M Installed size: 324 M Is this ok [y/N]: y Downloading Packages: (1/2): mysql-community-client-5.6.35-2.el6.x86_64.rpm | 18 MB 00:01 (2/2): mysql-community-server-5.6.35-2.el6.x86_64.rpm | 54 MB 00:04 ----------------------------------------------------------------------------------------------------------------------------------------- Total 11 MB/s | 73 MB 00:06 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. Installing : mysql-community-client-5.6.35-2.el6.x86_64 1/2 Installing : mysql-community-server-5.6.35-2.el6.x86_64 2/2 Verifying : mysql-community-client-5.6.35-2.el6.x86_64 1/2 Verifying : mysql-community-server-5.6.35-2.el6.x86_64 2/2 Installed: mysql-community-server.x86_64 0:5.6.35-2.el6 Dependency Installed: mysql-community-client.x86_64 0:5.6.35-2.el6 Complete! [root@hostname ~]# 4) Verify the packages installed or not [root@hostname ~]# rpm -qa |grep mysql mysql-community-common-5.6.35-2.el6.x86_64 mysql57-community-release-el6-9.noarch mysql-community-libs-compat-5.6.35-2.el6.x86_64 mysql-community-libs-5.6.35-2.el6.x86_64 mysql-community-client-5.6.35-2.el6.x86_64 mysql-community-server-5.6.35-2.el6.x86_64 [root@hostname ~]# [root@hostname ~]# service mysqld status mysqld is stopped [root@hostname ~]# ... View more

Please try to create view with database name parameter as below, instead of default database. CREATE VIEW database.news_split AS SELECT company, nof_lines, title, author, nof_words, keydate, publisher, w.word FROM database.news LATERAL VIEW EXPLODE(words) W AS WORD; ... View more

You need to update in /etc/hosts as well. 1) /etc/sysconfig/network :- this used while internode communication 2) /etc/hosts while client connection this is going to use. We need to set FQDN names on both file, this idle way ... View more