Member since 
    
	
		
		
		11-26-2018
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                3
            
            
                Posts
            
        
                0
            
            
                Kudos Received
            
        
                0
            
            
                Solutions
            
        
			
    
	
		
		
		11-27-2018
	
		
		06:44 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 This will not satisfy - FLAT NO 601 1ST FLOOR Sayali APTT NR Tomato MARKET Rajapur PUNE   411035 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		11-27-2018
	
		
		05:25 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi Sir,  Thanks for giving me way but this thing i tried and not getting satisafactory results.  I want solution over  My sql query having SUBSTRING_INDEX(string, delimiter, number)  this solution is not handling each and every apsect of my data. I implemented using this in mysql but right now because of more data size i want to implement in hive and i am not getting exact solution over this by these queries. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		11-26-2018
	
		
		06:20 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 I have one data like >>> Room no 601, Sayali Nivas , MG Road Delhi....... From this i want to pick Only 'Sayali' Based on Nivas string. How do i write query in hive for this  , 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
- 
						
							
		
			Apache Hive
 
        

