Kusto scan operator is having trouble with Materialized Views

Zirkel, Werner 1 Reputation point

It seems the Kusto scan operator is having trouble with Materialized Views.

Here is an example:
| scan   declare ( wert2: datetime, wert3:timespan)  with
step s2: (modulo_zeilenwert == 1 ) => wert2= event_timestamp; 
step s3: modulo_zeilenwert == 0 and serial_id == s2.serial_id => wert3 = event_timestamp - s2.wert2; 

@message": "Unsupported number of extents (!= 1): 3985\r\nTimestamp=2022-07-12T06:48:46.0681095Z\r\nServiceAlias=...ProcessName=Kusto.WinSvc.Svc\r\nProcessId=8040\r\nThreadId=4628\r\nAppDomainName=Kusto.WinSvc.Svc.exe

As a workaround, I am using the same statement with materialized_view('myview')

Is this a known issue ?

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
462 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 73,891 Reputation points Microsoft Employee

    Hello @Zirkel, Werner ,

    Thanks for reporting this issue.

    This issue has been fixed by the product team. Fix will be available as part of next deployment to your cluster - most probably by end of next week, or beginning of the week after. If this is urgent, please open a support ticket to request a hotfix for the cluster.

    Hope this will help. Please let us know if any further queries.


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments