Member since 
    
	
		
		
		07-09-2019
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                422
            
            
                Posts
            
        
                97
            
            
                Kudos Received
            
        
                58
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 489 | 07-06-2025 05:24 AM | |
| 525 | 05-28-2025 10:35 AM | |
| 2243 | 08-26-2024 08:17 AM | |
| 2847 | 08-20-2024 08:17 PM | |
| 1177 | 07-08-2024 04:45 AM | 
			
    
	
		
		
		09-04-2019
	
		
		10:28 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 
 Jdbc interpreter is will take default queue to run a job.  
   
 To run the job in specific queue add the queue name in hive.url property in JDBC interpreter settings  as shown below 
   
 
   
   
 hive.url=jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=<Queue Name>  
   
   
   EXAMPLE:    
   
   
 hive.url= jdbc:hive2://c186-node2.-labs.com:2181,c186-node3.-labs.com:2181,c186-node4.-labs.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=sai  
   
   
 Where sai is my queue name. 
   
 To check and confirm execute below query in zeppelin using JDBC interpreter and check-in Yarn Resource manager UI 
   
   
 %jdbc(hive)
show databases;
use <database name>;
show tables;
select count (*) from <table name>; 
   
   
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
	
					
			
		
	
	
	
	
				
		
	
	
			
    
	
		
		
		04-16-2019
	
		
		12:12 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 @Manish  Roy  you need to enable spnego authentication to access webUI after enabling Kerberos ,you can refer to the following article  https://community.hortonworks.com/articles/28537/user-authentication-from-windows-workstation-to-hd.html 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-11-2019
	
		
		01:04 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 @Divya Thaore Are you see any errors in  Browser Inspect element , Also check ambari-server logs 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-10-2019
	
		
		03:15 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 @Divya Thaore 502 Bad Gateway error is usually indicating a networking error, Try restart of the browser or try accessing from Incognito mode 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-10-2019
	
		
		03:11 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							@rajendra use the following to compute the total # of tables you have in Hive.     hive -e "show databases" >db3.out;cat db3.out | while read line; do hive -e "use $line;show tables" >> tables3.out;done; cat tables3.out | wc -l 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-10-2019
	
		
		02:04 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							@Mickke SemSan Try moving /etc/ranger/<Repository name> on namenode to some location and restart Ranger. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-02-2019
	
		
		02:44 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							@rajendra check fs.trash.interval time in hdfs , files deleted completely after the trash interval time. you can restore before trash.interval time 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		12-28-2018
	
		
		12:59 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							@Sedat Kestepe  no it is not related to mainboard changed 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		12-28-2018
	
		
		11:57 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							@Sedat Kestepe this issue occurs when Java is restricting the TLSv1 used by the Ambari Agents. By default, ambari-agent connects to TLSv1, unless specified by force_https_protocol=PROTOCOL_TLSv1_2 in ambari-agent.ini. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		12-28-2018
	
		
		11:48 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 @rajendra babu
 From hdp 2.6.3 zeppelin store notebooks under hdfs location: 
/user/zeppelin/notebook/ , as you have deleted notebook you can re-store 
it from trash.  Check if that notebook exists under trash directory or not 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		 
        













