Member since 
    
	
		
		
		12-12-2015
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                16
            
            
                Posts
            
        
                6
            
            
                Kudos Received
            
        
                2
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 3208 | 03-04-2017 03:47 PM | |
| 1793 | 02-16-2016 11:07 PM | 
			
    
	
		
		
		03-04-2017
	
		
		03:47 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 After further troubleshooting and the changing of properties (with no success), I took the last resort of deleting the Oozie service and setting up on a new DB.    For now everything is back to normal.  Root cause I suspect is db corruption.  This StackOverflow post kind of led me to do the inevitable. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-04-2017
	
		
		05:27 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Here are the 2 files.  This is what is used when I run the service check which fails.  workflow.xml  jobproperties.txt 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-04-2017
	
		
		05:14 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 When running any jobs, that were previously working, the job goes to PREP state (after the Start).  Jobs were previously working with no issue.  When running an Oozie Service check, the following is received.        We recently upgraded from 2.3.0 to 2.5.3 and the jobs ran for a couple of days with no issue then in the middle of the day the jobs started acting like this.    When on the phone with Hortonworks Tech Support, we did set oozie.service.AuthorizationService.security.enabled to false and it temporarily started working and then quit again.  We do have HA enabled, but any of the posts that I have found didn't fix the issue. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
	
					
			
		
	
	
	
	
				
		
	
	
			
    
	
		
		
		03-16-2016
	
		
		01:57 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @Shishir Saxena - That worked!  I previously saw that but just didn't think that would solve it. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-14-2016
	
		
		06:15 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @Takahiko Saito   I've seen where you can do that with the CSVSerde, but haven't found anything that states that you could use that with the OrcSerde.  Do you have any examples?
 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-14-2016
	
		
		03:16 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Let me clarify - the external table is using the CSVSerde to read the data and then we are loading an ORC table which uses the OrcSerde 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-14-2016
	
		
		02:48 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 @Shishir Saxena   We are loading the data from an external table via the CSVSerde.  In the temp table we can view the backslashes, but once we load it into the ORC format via the CSVSerde the backslashes, no matter how many there are, they disappear. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-14-2016
	
		
		02:14 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 We have some data that has a backslash (\) and noticed that when loading into Hive, it treats it as an escape character.  Is there a way to get around it treating this as an escape character?    I have tried replacing a single backslash with 2 backslashes and it still give me the same result.  The only other thing i could think of doing is just replacing the backslash with the encoded version of that value. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Hive
 
			
    
	
		
		
		02-16-2016
	
		
		11:07 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		2 Kudos
		
	
				
		
	
		
					
							 @Neeraj Sabharwal - We found the issue:    There is a bug in our version of Ambari (which
we need to upgrade).  It requires the baseDN property set for hive LDAP
(which we don’t use since we authenticate in Ranger).  It was set to
“empty”, restarted, and pushed through the install. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-15-2016
	
		
		09:57 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		2 Kudos
		
	
				
		
	
		
					
							 
	I'm trying to install Sqoop and it appears that Ranger is blocking the install.  What do I need to do to allow for the install of Sqoop?  Traceback
(most recent call last):
File "/var/lib/ambari-server/resources/scripts/stack_advisor.py",
line 154, in <module>
main(sys.argv)
File "/var/lib/ambari-server/resources/scripts/stack_advisor.py",
line 113, in main
result = stackAdvisor.validateConfigurations(services, hosts)
File
"/var/lib/ambari-server/resources/scripts/../stacks/stack_advisor.py",
line 463, in validateConfigurations
validationItems = self.getConfigurationsValidationItems(services, hosts)
File
"/var/lib/ambari-server/resources/scripts/./../stacks/HDP/2.0.6/services/stack_advisor.py",
line 348, in getConfigurationsValidationItems
resultItems = method(siteProperties, siteRecommendations, configurations,
services, hosts)
File
"/var/lib/ambari-server/resources/scripts/./../stacks/HDP/2.3/services/stack_advisor.py",
line 231, in validateHiveServer2Configurations
super(HDP23StackAdvisor, self).validateHiveServer2Configurations(properties,
recommendedDefaults, configurations, services, hosts)
File
"/var/lib/ambari-server/resources/scripts/./../stacks/HDP/2.2/services/stack_advisor.py",
line 906, in validateHiveServer2Configurations
if hive_server2[prop_name] != prop_val:
	KeyError:
'hive.security.authorization.manager' 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Ranger
 - 
						
							
		
			Apache Sqoop