帆软用户Dcu3auzqkx 回复 钱钱钱丶(提问者)WITH grouped_data AS (
SELECT
supplierCode,
inventoryType,
inventoryDate,
collect_list(productBarcodes) AS productBarcodes_array
FROM $[DB表输入]
GROUP BY supplierCode, inventoryType, inventoryDate
)
SELECT
to_json(
named_struct(
'supplierCode', supplierCode,
'inventoryType', inventoryType,
'inventoryDate', inventoryDate,
'productBarcodes', productBarcodes_array
)
) AS json_result
FROM grouped_data
看你的数据结构，可以让AI帮你调试
1min目标场景问卷
立即参与
