azure - 如何使用内联摄取将 Json 写入表中，而不使用逗号作为 Json 中的分隔符

Question

我想将以下值写入表中使用内联摄取。

.ingest inline into table Purchases1 <|
{"19node_0x0101010002":{"values":{"nodeValue":"11139","timestampTssReceived":"2022-07-20T09:13:18.4590000Z"}}},xxx,30

但是 json 会像下面的 resalt 一样被逗号分割，是否有一些方法可以避免逗号作为此 json 中的分割符？

.create table Purchases2 (name: dynamic, country: string, age: long)

Purchases2

Answer 1

如文档 ( ingest inline command (push) ) 中所示，内联摄取支持 with ( IngestionPropertyName = IngestionPropertyValue [, ...] )

您可以将数据提取为 json 或其他分隔格式(例如 psv)

• Azure Data Explorer data ingestion properties
• Data formats supported by Azure Data Explorer for ingestion

埃因霍温

.ingest inline into table Purchases with (format = "psv") <|
{"19node_0x0101010002":{"values":{"nodeValue":"11139","timestampTssReceived":"2022-07-20T09:13:18.4590000Z"}}}|xxx|30

JSON

.ingest inline into table Purchases with (format = "json") <|
{"name": {"19node_0x0101010002":{"values":{"nodeValue":"11139","timestampTssReceived":"2022-07-20T09:13:18.4590000Z"}}}, "country": "xxx", "age": 30}