F o u n d   3 0   p a t t e r n s : 
 
 
 
   1 .   s p a r k _ f i l t e r _ e q :   . f i l t e r ( c o l ( " s t a t u s " )   = =   " A c t i v e " 
 
   2 .   s p a r k _ f i l t e r _ e q :   . w h e r e ( c o l ( " T y p e " )   = =   " A C R " 
 
   3 .   s p a r k _ f i l t e r _ s q l :   . f i l t e r ( " s t a t u s   = =   ' A c t i v e ' " 
 
   4 .   s p a r k _ f i l t e r _ s q l :   . w h e r e ( " f l a g   = =   ' Y ' " 
 
   5 .   s p a r k _ s q l _ w h e r e _ h a r d c o d e d :   s p a r k . s q l ( " S E L E C T   *   F R O M   t a b l e   W H E R E   s t a t u s   =   ' A c t i v e ' 
 
   6 .   s p a r k _ s q l _ w h e r e _ i n _ h a r d c o d e d :   s p a r k . s q l ( " S E L E C T   *   F R O M   t a b l e   W H E R E   c o l   I N   ( ' a ' , ' b ' , ' c 
 
   7 .   f i l t e r _ c o l _ e q _ n u m e r i c :   . f i l t e r ( c o l ( " c o u n t " )   = =   1 2 3 ) 
 
   8 .   f i l t e r _ c o l _ n e q _ s t r i n g :   . f i l t e r ( c o l ( " s t a t u s " )   ! =   " I n a c t i v e " 
 
   9 .   f i l t e r _ l o w e r _ c o l _ e q _ s t r i n g :   . f i l t e r ( l o w e r ( c o l ( " n a m e " ) )   = =   " j o h n " 
 
 1 0 .   f i l t e r _ t r i m _ c o l _ e q _ s t r i n g :   . f i l t e r ( t r i m ( c o l ( " c o d e " ) )   = =   " A B C " 
 
 1 1 .   f i l t e r _ l o w e r _ t r i m _ c o l _ e q _ s t r i n g :   . f i l t e r ( l o w e r ( t r i m ( c o l ( " f i e l d " ) ) )   = =   " t e s t " 
 
 1 2 .   f i l t e r _ t r i m _ l o w e r _ c o l _ e q _ s t r i n g :   . f i l t e r ( t r i m ( l o w e r ( c o l ( " f i e l d " ) ) )   = =   " t e s t 2 " 
 
 1 3 .   f i l t e r _ w i t h _ i s i n :   . f i l t e r ( c o l ( " R e l a t i v e Y e a r " ) . i s i n ( " C Y " ,   " C Y - 1 " ,   " C Y - 2 " ) ) 
 
 1 4 .   w h e r e _ c o l _ e q _ n u m e r i c :   . w h e r e ( c o l ( " i d " )   = =   9 9 9 ) 
 
 1 5 .   w h e r e _ l o w e r _ c o l _ e q _ s t r i n g :   . w h e r e ( l o w e r ( c o l ( " c a t e g o r y " ) )   = =   " s a l e s " 
 
 