Catalog 'hive' does not support table property 'textfile_field_separator'

Viewed 25

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

0 Answers
Related