通过

你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

serialize operator

Applies to: ✅Microsoft Fabric✅Azure Data Explorer✅Azure Monitor✅Microsoft Sentinel

标记输入行集的顺序可安全用于开窗函数。

运算符具有声明性含义。 It marks the input row set as serialized (ordered), so that window functions can be applied to it.

Syntax

serialize [Name1=Expr1 [,Name2=Expr2]...]

Learn more about syntax conventions.

Parameters

Name 类型 Required Description
Name string 要添加或更新的列的名称。 如果省略，则会自动生成输出列名称。
Expr string ✔️ 要对输入执行的计算。

Examples

本节中的示例演示如何使用语法帮助你入门。

The examples in this article use publicly available tables in the help cluster, such as the StormEvents table in the Samples database.

The examples in this article use publicly available tables, such as the Weather table in the Weather analytics sample gallery. 可能需要修改示例查询中的表名称以匹配工作区中的表。

按条件序列化行子集

This query retrieves all log entries from the TraceLogs table that have a specific ClientRequestId and preserves the order of these entries during processing.

运行查询

TraceLogs
| where ClientRequestId == "5a848f70-9996-eb17-15ed-21b8eb94bf0e"
| serialize

Output

此表仅显示前 5 个查询结果。

Timestamp Node Component ClientRequestId Message
2014-03-08T12:24:55.5464757Z Engine000000000757 INGESTOR_GATEWAY 5a848f70-9996-eb17-15ed-21b8eb94bf0e $$IngestionCommand table=fogEvents format=json
2014-03-08T12:24:56.0929514Z Engine000000000757 DOWNLOADER 5a848f70-9996-eb17-15ed-21b8eb94bf0e 正在下载文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_0.json.gz"”
2014-03-08T12:25:40.3574831Z Engine000000000341 INGESTOR_EXECUTER 5a848f70-9996-eb17-15ed-21b8eb94bf0e IngestionCompletionEvent：完成引入文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_0.json.gz"”
2014-03-08T12:25:40.9039588Z Engine000000000341 DOWNLOADER 5a848f70-9996-eb17-15ed-21b8eb94bf0e 正在下载文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_1.json.gz"”
2014-03-08T12:26:25.1684905Z Engine000000000057 INGESTOR_EXECUTER 5a848f70-9996-eb17-15ed-21b8eb94bf0e IngestionCompletionEvent：完成引入文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_1.json.gz"”
... ... ... ... ...

向序列化的表添加行号

To add a row number to the serialized table, use the row_number() function.

运行查询

TraceLogs
| where ClientRequestId == "5a848f70-9996-eb17-15ed-21b8eb94bf0e"
| serialize rn = row_number()

Output

此表仅显示前 5 个查询结果。

Timestamp rn Node Component ClientRequestId Message
2014-03-08T13:00:01.6638235Z 1 Engine000000000899 INGESTOR_EXECUTER 5a848f70-9996-eb17-15ed-21b8eb94bf0e IngestionCompletionEvent：完成引入文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_46.json.gz"”
2014-03-08T13:00:02.2102992Z 2 Engine000000000899 DOWNLOADER 5a848f70-9996-eb17-15ed-21b8eb94bf0e 正在下载文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_47.json.gz"”
2014-03-08T13:00:46.4748309Z 3 Engine000000000584 INGESTOR_EXECUTER 5a848f70-9996-eb17-15ed-21b8eb94bf0e IngestionCompletionEvent：完成引入文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_47.json.gz"”
2014-03-08T13:00:47.0213066Z 4 Engine000000000584 DOWNLOADER 5a848f70-9996-eb17-15ed-21b8eb94bf0e 正在下载文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_48.json.gz"”
2014-03-08T13:01:31.2858383Z 5 Engine000000000380 INGESTOR_EXECUTER 5a848f70-9996-eb17-15ed-21b8eb94bf0e IngestionCompletionEvent：完成引入文件路径：“”https://benchmarklogs3.blob.core.windows.net/benchmark/2014/IMAGINEFIRST0_1399_48.json.gz"”
... ... ... ... ...

运算符的序列化行为

以下运算符的输出行集标记为已序列化。

以下运算符的输出行集会标记为非序列化。

所有其他运算符保留序列化属性。 如果输入行集已序列化，则输出行集也会序列化。