Error in demonstration KQL queries

Olivier SANS 0 Reputation points

I was training on the KQL queries and I noticed an error.

Write multi-table queries by using Kusto Query Language
Unit 5 of 9 :Exercise - Combine table results by using the lookup operator

User's image

On this page, demonstrating the usage and better performance of lookup on table,

-->the query below should return the same results as the join kind=leftouter from the page

Write multi-table queries by using Kusto Query Language
Unit 4 of 9: Exercise - Combine table results by using the join operator

User's image

User's image

I don't know if I missed something, but I don't have the same results, and the screenshot of both pages are also showing different results :D

Join leftouter results :User's image

Lookup screen shot : User's image

Only the first row is identical.


Azure Training
Azure Training
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Training: Instruction to develop skilled behavior.
640 questions
{count} votes

1 answer

Sort by: Most helpful
  1. SaiKishor-MSFT 17,141 Reputation points

    @Olivier SANS Thanks for your patience while we were looking into this issue.

    This document was updated with the correct query and result. Please check it out and let us know if this helps. If you have any further questions, please do let me know. Thank you!

    0 comments No comments