如何从AWS的Athena获取结果格式JSON? [英] How can I get result format JSON from Athena in AWS?

问题描述

我想从AWS的Athena获取结果值格式JSON.

I want to get result value format JSON from Athena in AWS.

当我从雅典娜中选择时，结果格式如下.

When I select from the Athena then the result format like this.

{test.value={report_1=test, report_2=normal, report_3=hard}}

是否有任何方法可以将JSON格式的结果替换为:"?

Is there any way to get JSON format result without replacing "=" to ":" ?

列格式为

map<string,map<string,string>>

推荐答案

select  mycol
from    mytable
;

---

+--------------------------------------------------------------+
|                            mycol                             |
+--------------------------------------------------------------+
| {test.value={report_3=hard, report_2=normal, report_1=test}} |
+--------------------------------------------------------------+

---

select  cast (mycol as json) as json
from    mytable
;

---

+--------------------------------------------------------------------------+
|                                   json                                   |
+--------------------------------------------------------------------------+
| {"test.value":{"report_1":"test","report_2":"normal","report_3":"hard"}} |
+--------------------------------------------------------------------------+

这篇关于如何从AWS的Athena获取结果格式JSON?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！