All Forums Aster
rogerbryan 1 post Joined 06/13
01 Nov 2013
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;

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You must sign in to leave a comment.