来自 Azure 流分析的表存储输出Table storage output from Azure Stream Analytics

Azure 表存储 提供了具有高可用性且可大规模缩放的存储,因此应用程序可以自动缩放以满足用户需求。Azure Table storage offers highly available, massively scalable storage, so that an application can automatically scale to meet user demand. 表存储是 Microsoft 推出的 NoSQL 键/属性存储,适用于对架构的约束性较少的结构化数据。Table storage is Microsoft's NoSQL key/attribute store, which you can use for structured data with fewer constraints on the schema. Azure 表存储可用于持久地存储数据,方便进行高效的检索。Azure Table storage can be used to store data for persistence and efficient retrieval.

下表列出了用于创建表输出的属性名称及其说明。The following table lists the property names and their descriptions for creating a table output.

属性名称Property name 说明Description
输出别名Output alias 该名称是在查询中使用的友好名称,用于将查询输出定向到此表存储。A friendly name used in queries to direct the query output to this table storage.
存储帐户Storage account 存储帐户的名称(正在向该存储帐户发送输出)。The name of the storage account where you're sending your output.
存储帐户密钥Storage account key 与存储帐户关联的访问密钥。The access key associated with the storage account.
表名称Table name 表的名称。The name of the table. 如果表不存在,则创建该表。The table gets created if it doesn't exist.
分区键Partition key 包含分区键的输出列的名称。The name of the output column that contains the partition key. 分区键是某个表中分区的唯一标识符,分区键构成了实体主键的第一部分。The partition key is a unique identifier for the partition within a table that forms the first part of an entity's primary key. 它是最大可为 1 KB 的字符串值。It's a string value that can be up to 1 KB in size.
行键Row key 包含行键的输出列的名称。The name of the output column that contains the row key. 行键是分区中实体的唯一标识符。The row key is a unique identifier for an entity within a partition. 行键构成了实体主键的第二部分。It forms the second part of an entity's primary key. 行键是一个最大为 1 KB 的字符串值。The row key is a string value that can be up to 1 KB in size.
批大小Batch size 批处理操作的记录数。The number of records for a batch operation. 默认值 (100) 对大部分作业来说都已足够。The default (100) is sufficient for most jobs. 有关修改设置的详细信息,请参阅表批处理操作规范See the Table Batch Operation spec for more details on modifying this setting.

分区Partitioning

分区键为任何输出列。The partition key is any output column. 输出编写器的数量与完全并行化的查询的输入分区一致。The number of output writers follows the input partitioning for fully parallelized queries.

输出批大小Output batch size

有关最大消息大小,请参阅 Azure 存储限制For the maximum message size, see Azure Storage limits. 默认为每个单一事务 100 个实体,但可根据需要将其配置为更小的值。The default is 100 entities per single transaction, but you can configure it to a smaller value as needed.

后续步骤Next steps