narrow 插件narrow plugin

T | evaluate narrow()

narrow 插件将宽表“逆透视”为只包含三列的表:行号、列类型和列值(作为 string)。The narrow plugin "unpivots" a wide table into a table with just three columns: Row number, column type, and column value (as string).

narrow 插件主要用于显示目的,它可以让你在不需要水平滚动的情况下轻松显示宽表。The narrow plugin is designed mainly for display purposes, as it allows wide tables to be displayed comfortably without the need of horizontal scrolling.

语法Syntax

T | evaluate narrow()

示例Examples

以下示例演示了如何使用简单的方法来读取 Kusto 的 .show diagnostics 控制命令的输出。The following example shows an easy way to read the output of the Kusto .show diagnostics control command.

.show diagnostics
 | evaluate narrow()

.show diagnostics 本身的结果是一个具有单个行和 33 个列的表。The results of .show diagnostics itself is a table with a single row and 33 columns. 通过使用 narrow 插件,我们将输出“旋转”为如下所示的结果:By using the narrow plugin we "rotate" the output to something like this:

Row Column “值”Value
00 IsHealthyIsHealthy TrueTrue
00 IsRebalanceRequiredIsRebalanceRequired 错误False
00 IsScaleOutRequiredIsScaleOutRequired 错误False
00 MachinesTotalMachinesTotal 22
00 MachinesOfflineMachinesOffline 00
00 NodeLastRestartedOnNodeLastRestartedOn 2017-03-14 10:59:18.92630232017-03-14 10:59:18.9263023
00 AdminLastElectedOnAdminLastElectedOn 2017-03-14 10:58:41.67419342017-03-14 10:58:41.6741934
00 ClusterWarmDataCapacityFactorClusterWarmDataCapacityFactor 0.1305528476733330.130552847673333
00 ExtentsTotalExtentsTotal 136136
00 DiskColdAllocationPercentageDiskColdAllocationPercentage 55
00 InstancesTargetBasedOnDataCapacityInstancesTargetBasedOnDataCapacity 22
00 TotalOriginalDataSizeTotalOriginalDataSize 51676280705167628070
00 TotalExtentSizeTotalExtentSize 17791652301779165230
00 IngestionsLoadFactorIngestionsLoadFactor 00
00 IngestionsInProgressIngestionsInProgress 00
00 IngestionsSuccessRateIngestionsSuccessRate 100100
00 MergesInProgressMergesInProgress 00
00 BuildVersionBuildVersion 1.0.6281.198821.0.6281.19882
00 BuildTimeBuildTime 2017-03-13 11:02:44.00000002017-03-13 11:02:44.0000000
00 ClusterDataCapacityFactorClusterDataCapacityFactor 0.1305528476733330.130552847673333
00 IsDataWarmingRequiredIsDataWarmingRequired 错误False
00 RebalanceLastRunOnRebalanceLastRunOn 2017-03-21 09:14:53.85234552017-03-21 09:14:53.8523455
00 DataWarmingLastRunOnDataWarmingLastRunOn 2017-03-21 09:19:54.14388002017-03-21 09:19:54.1438800
00 MergesSuccessRateMergesSuccessRate 100100
00 NotHealthyReasonNotHealthyReason [null][null]
00 IsAttentionRequiredIsAttentionRequired 错误False
00 AttentionRequiredReasonAttentionRequiredReason [null][null]
00 ProductVersionProductVersion KustoRelease_2017.03.13.2KustoRelease_2017.03.13.2
00 FailedIngestOperationsFailedIngestOperations 00
00 FailedMergeOperationsFailedMergeOperations 00
00 MaxExtentsInSingleTableMaxExtentsInSingleTable 6464
00 TableWithMaxExtentsTableWithMaxExtents KustoMonitoringPersistentDatabase.KustoMonitoringTableKustoMonitoringPersistentDatabase.KustoMonitoringTable
00 WarmExtentSizeWarmExtentSize 17791652301779165230