bash - jq 错误 “object is not valid in a csv row”

Question

我正在尝试通过 jq 将 json 对象转换为 csv。以下是示例结构:

[
  "193.176.211.70",
  [
    "2697131889764497b2beef1bac8e742d"
  ]
]
[
  "193.176.211.70",
  [
    "2697131889764497b2beef1bac8e742d"
  ]
]
[
  "205.169.39.30",
  []
]
[
  "65.155.30.101",
  []
]
[
  "45.64.241.129",
  [
    "2697131889764497b2beef1bac8e742d"
  ]
]
[
  "45.64.241.129",
  [
    "2697131889764497b2beef1bac8e742d"
  ]
]

尝试使用 jq -r '。 | @csv' output2.json > output.csv 但它返回 jq: error (at output2.json:9486): array (["269713188...) is not valid in a csv row

引用stackoverflow上与jq相关的唯一问题，也不起作用有什么建议吗？

Answer 1

您需要先使用flatten 展开/展平数组，然后才能将数据存储为 CSV。这将为数组的每个元素创建一条记录。

$ jq -r 'flatten | @csv' output2.json
"193.176.211.70","2697131889764497b2beef1bac8e742d"
"193.176.211.70","2697131889764497b2beef1bac8e742d"
"205.169.39.30"
"65.155.30.101"
"45.64.241.129","2697131889764497b2beef1bac8e742d"
"45.64.241.129","2697131889764497b2beef1bac8e742d"