CODEWITHSUNDEEP
azure-log-analyticsazure-data-explorerkql
SqlWorldWide
SqlWorldWide

Reputation: 369

Azure Data Explorer Query Language-batches and materialize

Reference: https://learn.microsoft.com/en-us/azure/kusto/query/materializefunction https://learn.microsoft.com/en-us/azure/kusto/query/batches

I am using Microsoft's demo portal: https://aka.ms/LADemo

A query can include multiple tabular expression statements, as long as they are delimited by a semicolon (;) character. The query then returns multiple tabular results, as produced by the tabular expression statements, and ordered according to the order of the statements in the query text.

When I run following code I am only getting result from the first expression and not the second and third one. Which is contrary to the above statement. Why?

let randomSet = materialize(range x from 1 to 30000000 step 1 | project value = rand(10000000));
randomSet | summarize dcount(value);
randomSet | top 3 by value;
randomSet | summarize sum(value)

Picture of the result set: enter image description here

Upvotes: 1

Views: 995

Answers (1)

Avnera
Avnera

Reputation: 7618

Log Analytics does not support this feature, to try it out use the Kusto (Azure Data Explorer) demo cluster, you will see multiple tables in the output pane: enter image description here

Upvotes: 3

Related Questions