Member since 
    
	
		
		
		10-29-2015
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                128
            
            
                Posts
            
        
                31
            
            
                Kudos Received
            
        
                4
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 2190 | 06-27-2024 02:42 AM | |
| 3427 | 06-24-2022 09:06 AM | |
| 4761 | 01-19-2021 06:56 AM | |
| 59618 | 01-18-2016 06:59 PM | 
			
    
	
		
		
		03-23-2021
	
		
		04:01 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hello All,     We have a around 22 databases and their respective tables which are accessible via Impala in Hue, but not via Hive for 3 newly added users. We get below error which is related to permissions to databases via Sentry, however, this looks strange to me since the permissions are managed at DB level and not specific to service. So if permissions are not correct, we should not have been able to access them via Impala as well.     Error message:  Error while compiling statement: FAILED: SemanticException No valid privileges User xxxxxx does not have privileges for SWITCHDATABASE The required privileges: Server=server1->Db=*->Table=+->Column=*->action=select->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=insert->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=alter->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=create->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=drop->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=index->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=lock->grantOption=false;     Query that works fine in Impala but not Hive:  select * from dbname.tablename limit 5;     Please suggest what can be checked / done to fix this.     Thanks  snm1523 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Hive
 - 
						
							
		
			Apache Impala
 - 
						
							
		
			Cloudera Hue
 
			
    
	
		
		
		02-08-2021
	
		
		07:15 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hello,     We have a strange issue here.     We are on CDH 6.3.0 and have sentry in place for authorizations. A user is trying to execute queries from Hue on Impala Editor and fails with Authorization errors. However, same query works fine via Hive and also via Impala shell. It fails only from Hue editor.     We have:  1. Refreshed metadata  2. Invalidated metadata  3. Verified permissions are in place in Sentry  4. There are no logs generated (I checked in Hue, Sentry Server and Catalog server). Please suggest if any other place should also be checked.     Example query:  select * from DB.table limit 5;     Kindly help to diagnose and resolve this issue.     Thanks  Snm1523 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
	
					
			
		
	
	
	
	
				
		
	
	
			
    
	
		
		
		01-19-2021
	
		
		06:56 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Thank you for the reply @smdas      After looking at the privilege logs, found that the port was reported to be used. In reality it was not being used so possible some caching issue. We rebooted the server and were able to then restart the DN successfully.     Thanks  snm1523 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-11-2021
	
		
		04:05 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hello,     Does anyone has any clue about below error. Datanode is not coming up with this error in the logs.  We are on Cloudera Hadoop 6.3.0.     RECIEVED SIGNAL 15: SIGTERM     Thanks  snm1523 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Hadoop
 
			
    
	
		
		
		10-07-2020
	
		
		05:12 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hello @Elf ,     Yes I was able to.     Have prepared a quick guide detailing the steps to be taken which in turn refers to Apache Griffin documentations and other required pre-reqs.     Unsure, how do i share with you since I am unable to attach it here.     Thanks  snm1523 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		10-07-2020
	
		
		05:07 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hello Shishir,     Would you mind to please how do we migrate a standalone Nifi setup to cluster mode?     Thanks  snm1523 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		08-31-2020
	
		
		04:25 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Thank you... This helped. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		08-20-2020
	
		
		07:22 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi All, 
   
 Need opinions / thoughts / best practices. 
   
 Has anyone tried integrating Apache Griffin (An open source Data Quality solution for Big Data. More details at http://griffin.apache.org/#about_page) with deployed CDH clusters? 
   
 If yes, any documentation available on how to get this done? What are the requirements / prereqs? Any recommendations on best practices?    Any additional information or help or documentation (apart from the link shared) shared would be highly beneficial. 
   
 Please share your thoughts / feedback / comments. 
   Thanks 
 SNM1523 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels: