How to create table in presto from a select query that has comma-separated values inside the column itself.
e.g
select statement has values look like
Column1 | column2 | column3 |
---|---|---|
1 | 2 | abc,xyz |
below is the create statement for table
CREATE TABLE resultTable
WITH (format = 'TEXTFILE',textfile_field_separator = ',')
AS
select Column1 ,column2 column3 from sourceTable
but this ends up with missing placing fields which have comma separated values