presto create table from another table with double quotes with comma separated

169 views Asked by At

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

0

There are 0 answers