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 |