-
Notifications
You must be signed in to change notification settings - Fork 480
Top asks
noakup edited this page Sep 16, 2020
·
7 revisions
Users ask for contributions for the following services and scenarios:
-
Azure Synapse and Azure Data Warehouse
-
Azure Data Factory v2 (Resource-Specific Diagnostics)
-
Security Center Continuous Export
-
Azure Databricks
-
a query that identifies sequences (sequence_detect doesn't provide the desired results). For example:
input:
| Datetime | ProcId | EventStr |
|---|---|---|
| datetime(2020-06-01 8:00) | 0 | "Start" |
| datetime(2020-06-01 8:01) | 1 | "Start" |
| datetime(2020-06-01 8:02) | 1 | "Exit" |
| datetime(2020-06-01 8:03) | 2 | "Start" |
| datetime(2020-06-01 8:04) | 2 | "Exit" |
| datetime(2020-06-01 8:05) | 1 | "Start" |
| datetime(2020-06-01 8:06) | 1 | "Exit" |
| datetime(2020-06-01 8:10) | 0 | "Exit" |
The expected output:
| ProcId | Start_Time | Stop_Time | Duration |
|---|---|---|---|
| 0 | 2020-06-01T08:00:00Z | 2020-06-01T08:10:00Z | 00:10:00 |
| 1 | 2020-06-01T08:01:00Z | 2020-06-01T08:02:00Z | 00:01:00 |
| 1 | 2020-06-01T08:05:00Z | 2020-06-01T08:06:00Z | 00:01:00 |
| 2 | 2020-06-01T08:03:00Z | 2020-06-01T08:04:00Z | 00:01:00 |