点击房屋查询:
select ( select 1 as c11, 'ab' as c12, 78 as c13 ) as c1, 'ooo' as c2
format JSONEachRow
退货:
{"c1":[1,"ab",78],"c2":"ooo"}
是否可以将c1作为对象而不是数组来获取?:
{"c1":{"c11":1,"c12":"ab","c13":78},"c2":"ooo"}
格式jsoneachrow是必需的。
点击房屋查询:
select ( select 1 as c11, 'ab' as c12, 78 as c13 ) as c1, 'ooo' as c2
format JSONEachRow
退货:
{"c1":[1,"ab",78],"c2":"ooo"}
是否可以将c1作为对象而不是数组来获取?:
{"c1":{"c11":1,"c12":"ab","c13":78},"c2":"ooo"}
格式jsoneachrow是必需的。
1条答案
按热度按时间wqnecbli1#
不幸的是,这是不可能的。select子查询的结果被解释为元组并作为数组输出。
作为一种解决方法,可以将结果展平,如果需要,还可以应用一些后处理。