Is the vertica has the function that converts row to JSON format.? The table is not a flex table*example) select * from table; ** general result**id text 1 amy 2 john if i use the json function select json(*) from table; ** json result **result {'id':1, 'text':'amy'} {'id':2, 'text':'john'}

Question

Is the vertica has the function that converts row to JSON format.?

Forum|Forum|5 years ago
March 22, 2021
3 replies
9 views

+2

HyeontaeJu
Participating Frequently

Is the vertica has the function that converts row to JSON format.?

The table is not a flex table*
example)
select * from table;
** general result**
id text
1 amy
2 john

id	text
1	amy
2	john

if i use the json function
select json(*) from table;
** json result **

result
{'id':1, 'text':'amy'}
{'id':2, 'text':'john'}

SergeB
Participating Frequently
Forum|Forum|5 years ago
March 22, 2021

You can use the vmap functions to build a vmap for each row and then get its JSON representation.

 select maptoString(mapput(emptymap(),id,"text" using parameters keys=SetMapKeys('id','text'))) as json_string from foo;
              json_string
---------------------------------------
 {
    "id": "1",
      "text": "amy"
}
 {
    "id": "2",
    "text": "john"
}