LAG function Error. Same type of Error as another post on the forum.

Aster

LAG function Error. Same type of Error as another post on the forum.







select *                         -- Query 1     
FROM nPath                       -- [AsterData][nCluster] ERROR: column "_tmp_169155105"."acct_id" does not exist ()
(                              
  on                            
  (                            
    select * from attmbm.rb_cp_1_20_131022 where event_type = 'Call' and acct_id = '390464503'        
  )                            
  PARTITION BY acct_id                        
  ORDER BY event_time                        
  MODE(OVERLAPPING)                        
  PATTERN('A.B+.C.D$')                        
  SYMBOLS                          
  (                            
    event_description1 is not null as A,                    
    lag(event_description1,1) != event_description1 as B,                
    TRUE as C,                        
    TRUE as D                        
                               
                               
  )                            
  RESULT                            
  (                            
    first(acct_id of A) as acct_id,                      
    first(outcome of A) as outcome,                    
    first(event_description1 of A) as call_purpose,                  
    first(event_description1 of B) as call_purpose1,                  
    first(event_description1 of C) as call_purpose2,                  
    first(event_description1 of D) as call_purpose3                  
  )                            
) n                              
limit 10;