selectview_date,
client_page_id,
CASEWHEN(SUBSTRING(Client_Page_ID,1,8)='PRODUCT:'
ORSUBSTRING(Client_Page_ID,1,15)='MOBILE:PRODUCT:'
ORSUBSTRING(Client_Page_ID,1,16)='MOBILE2:PRODUCT:'
ORSUBSTRING(Client_Page_ID,1,16)='IPPRODUCTDETAIL:'
ORSUBSTRING(Client_Page_ID,1,16)='ADPRODUCTDETAIL:')
ANDSPLIT(REVERSE(Client_Page_Id),'\\\(')[0]ISNOTNULL
THENREVERSE(SPLIT(SPLIT(REVERSE(Client_Page_Id),'\\\(')[0],'\\\)')[1])
ELSE''
ENDASClient_Product_id
FROMPageViewA
--whereClient_Page_IDlike'%PRODUCT%';
如上所示,我加了where条件后就不会报错,但是不加就立马出问题了。。。请教高手帮忙!!
分 -->
|