The following query:
SELECT * FROM TABLE (CSVLD(load_date.data, ',', '"') RETURNS (p1 varchar(100), p2 varchar(100))) as T1;
CSVLD parses the comma-separated strings and returns two VARCHAR columns.
The following query:
SELECT * FROM TABLE (CSVLD(load_date.data, ',', '"') RETURNS (p1 varchar(100), p2 varchar(100))) as T1;
CSVLD parses the comma-separated strings and returns two VARCHAR columns.