In this example, each CSV record is converted to one output row composed of one JSON object.
CREATE TABLE csv_table_1(pkey INTEGER, csv DATASET STORAGE FORMAT CSV); INSERT INTO csv_table_1 values(0, 'ItemID,ItemName,Quantity,Price;10021,Paint Brush,10,10.99;10033,Paint,3,24.99'); SELECT data FROM CSV_TO_JSON ( ON (SELECT csv FROM csv_table_1) USING SCHEMA('{"record_delimiter":";"}') ) AS csv;
Result:
> {"ItemID":"10021","ItemName":"Paint Brush","Quantity":"10","Price": "10.99"} > {"ItemID":"10033","ItemName":"Paint","Quantity":"3","Price":"24.99"}