您可以从输出中排除“统计”:
设置output_format_write_statistics = 0;
ubuntu-16gb-nbg1-1 :) select 1 format JSON;
SELECT 1
FORMAT JSON
{
"meta":
[
{
"name": "1","type": "UInt8"
}
],"data":
[
{
"1": 1
}
],"rows": 1
}
1 rows in set. Elapsed: 0.003 sec.
,
也许JSONEachRow将满足您的需求?
,
JSONEachRow似乎不能直接使用,因为结果JSON无效。
您可以将数据分组到数组以获取有效的JSON:
SELECT
groupArray(value) AS values,groupArray((value,name)) AS objects
FROM
(
SELECT
1 AS value,'str1' AS name
UNION ALL
SELECT
2 AS value,'str2' AS name
)
FORMAT JSONEachRow
/* Result:
{"values":[1,2],"objects":[[1,"str1"],[2,"str2"]]}
*/
,
您尝试在哪里运行查询?
也许您可以尝试通过管道和JQ过滤此输出
clickhouse-client -q "SELECT value FROM test.json_test FORMAT JSON" | jq .data
本文链接:https://www.f2er.com/3082857.html