Member since
05-22-2016
12
Posts
3
Kudos Received
0
Solutions
05-24-2016
03:12 PM
Yeah..so /usr/hdp/current/hive-server2/bin/hiveserver2 was the culprit :). Do you know how that line got removed? ideally we don't change these files manually.
... View more
12-04-2017
11:50 PM
Hi Just adding another solution of the issue - I noticed that I could connect to localhost:3306 but not hostname.domain:3306 after deploying with "create new mysql" Changing the bind address of mysql and restarting the mysql daemon resolved this issue /# nano /etc/mysql/mysql.conf.d/mysqld.cnf
...
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 0.0.0.0 # Changed from 127.0.0.1 to resolve hive connectivity issue
I dont know if this issue occurred to me because I used docker to deploy (getting some strange network side effects?) or if mysql changed default behaviour lately. //Erik
... View more