I tried to create hive table by presto sql:
CREATE TABLE IF NOT EXISTS tmp.test_q WITH (
format = 'TEXTFILE',
textfile_field_separator = ','
),
but got
com.facebook.presto.spi.PrestoException: Catalog 'hive' does not support table property 'textfile_field_separator'
Our presto is about 0.26X version. how to set the delimiter?
Thanks