[GitHub] [incubator-doris] EmmyMiao87 edited a comment on issue #8191: [Bug] Select sql cause an NullPointerException on Fe

[GitBox <gi...@apache.org>]

EmmyMiao87 edited a comment on issue #8191:
URL: https://github.com/apache/incubator-doris/issues/8191#issuecomment-1049830923


   with id_34 as
   (
   SELECT new_srv_workorder_id as unresolved_id
   FROM ods_new_srv_outsidelineBase_dd ol
   group by new_srv_workorder_id
   having count(1) >=2
   ),
   unresolved as
   (
   SELECT bd.* ,'非一次性解决' as '解决情况'
   FROM dwd_srv_solutionprocess_dd bd
   join id_34 on bd.workorderId = id_34.unresolved_id
   ),
   solved as
   (
   SELECT *, '一次性解决' as '解决情况'
   FROM dwd_srv_solutionprocess_dd b
   WHERE workorderId not in (select workorderId from unresolved)
   )
   select * from solved;


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org