外部結合の方法について

Follow

CE y.nagasaki

• October 23, 2020 05:02

外部結合の方法について知りたいです。

SQLでは left join にて条件を指定して結合できますが、sumo logicではどのように行うのでしょうか。

joinは内部結合のため、使用することができないと考えています。

0

• 

  Shobhit Garg

  • October 23, 2020 10:59

  Hello,

   

  Currently we do not support the outer join and have an open feature request for the same.

  You can create the lookup file for the query which is deficient in the data, then you can lookup that file from the main query. For non matching cases, it will show NULL, which you can handle using IF condition.

  You can check lookup for more info 
  https://help.sumologic.com/05Search/Search-Query-Language/Search-Operators/lookup
  
  Or if you have enabled lookup beta then you go for it as well
  https://help.sumologic.com/Beta/Lookup_Tables_(Beta)/01_Create_and_Manage_Lookup_Tables
  
  Hope this helps to achieve what you are looking for.

   

  Thanks,

  Shobhit

  1

  Comment actions Permalink

Please sign in to leave a comment.