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
				
			
			
			
			
			
			
			
			
			
		 
         
					
				






