The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Is the vertica has the function that converts row to JSON format.?

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'} |
0
Answers
You can use the vmap functions to build a vmap for each row and then get its JSON representation.
Oh.. Thank you so much.. @SergeB
I have one more question..
If i need all column,, then, i have to write all column in the function??
@HyeontaeJu Yes, you will need to list all the columns you wish to include in your JSON result.