外部結合の方法について
外部結合の方法について知りたいです。
SQLでは left join にて条件を指定して結合できますが、sumo logicではどのように行うのでしょうか。
joinは内部結合のため、使用することができないと考えています。
-
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
Please sign in to leave a comment.
Comments
1 comment