jayendra13 opened a new pull request, #20864:
URL: https://github.com/apache/datafusion/pull/20864

   ## Which issue does this PR close?                                           
                                                                                
                             
                                            
     - Closes #14660 (partial — adds DROP pipe operator only)                   
                                                                                
                               
                                                                                
                                                                                
                               
     ## Rationale for this change                                               
                                                                                
                               
                                                               
     The DROP pipe operator (`|> DROP x, y`) is part of the BigQuery pipe 
syntax tracked in #14660. It removes columns from the output, equivalent to 
`SELECT * EXCEPT(x, y)`.                 
                                                               
     ## What changes are included in this PR?                                   
                                                                                
                               
                                                               
     - Added `PipeOperator::Drop` match arm in `query.rs` that reuses existing 
`SELECT * EXCEPT` infrastructure (`WildcardOptions` with `ExceptSelectItem`)    
                                
     - Added SLT tests covering single column drop, multi-column drop, chaining 
with other pipe operators, and error case for non-existent columns
     - Added DROP to the pipe operator documentation in `select.md`             
                                                                                
                               
                                                                                
                                                                                
                               
     ## Are these changes tested?
                                                                                
                                                                                
                               
     Yes, four sqllogictest cases added in `pipe_operator.slt`:                 
                                                                                
                               
     - Drop two columns
     - Drop single column                                                       
                                                                                
                               
     - Chained with WHERE                                      
     - Error on non-existent column
   
     ## Are there any user-facing changes?                                      
                                                                                
                               
      
     Yes, users can now use `|> DROP column1, column2` in pipe operator queries 
(BigQuery dialect).  


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to