EXASOL: Convert table data generated from query to json data (For creating graphs)

Question

I am trying to convert data from sql query to json format where different data would be considered for categories, Data values, Series directly in a graph. In SQL server we have a function called FOR JSON AUTO ; is there something similar in Exasol to achieve data conversion to JSON

Hello CodeMan, As we can convert data into json hierarchy in SQL can we do it same in EXASOL server. — Ganesh Gadakar, Jan 02 '19 at 08:37

score 0 · Answer 1 · edited Jul 26 '19 at 04:32

0

There are no built-in functions available in Exasol. However, try to create a UDF that could convert sql into json format. This can be done within the Exasol server.

edited Jul 26 '19 at 04:32

Bhargav Rao

50,140
28
121
140

answered Jul 23 '19 at 13:12

Exasol

26
3

EXASOL: Convert table data generated from query to json data (For creating graphs)

1 Answers1