How can I get result format JSON from Athena in AWS?

Question

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}}

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

The column format is

map<string,map<string,string>>

Answer 1

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"}} |
+--------------------------------------------------------------------------+