Member since 
    
	
		
		
		02-01-2017
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                3
            
            
                Posts
            
        
                0
            
            
                Kudos Received
            
        
                0
            
            
                Solutions
            
        
			
    
	
		
		
		02-02-2017
	
		
		02:01 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi.  I was trying to execute a right deep join and found that the following syntax seems to not be supported by Impala parser:  SELECT *
FROM viewA a
JOIN (
	viewB b JOIN (
		viewC c JOIN viewD d ON (c.fieldC = d.fieldD)
		) ON (b.fieldB = d.fieldD)
	) ON (a.fieldA = d.fieldD)
	
	  Also not working:  SELECT *
FROM viewA a
JOIN (
	viewB b JOIN (
		viewC c JOIN viewD d ON (c.fieldC = d.fieldD)
		) ON (b.fieldB = d.fieldD)
	) ON (a.fieldA = d.fieldD)  I can execute them by creating a full subquery in each join, but i am used to write this and does not seems to be a problem for other database parsers. Should this syntax work or it is intended to give a syntax error?    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
- 
						
							
		
			Apache Impala
 
        

