search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.49k stars 3.02k forks source link

Trino fails to create hive table with textfile_field_separator='\t' #24213

Closed luhea closed 10 hours ago

luhea commented 14 hours ago

trino:464 hive:3.1.3 Trino-cli:463

DDL SQL:CREATE TABLE test1.test1 ( id int,name string) WITH ( format = 'TEXTFILE',textfile_field_separator ='\t') Error:failed: textfile_field_separator must be a single character string, but was: '\t'

ebyhr commented 10 hours ago

Could you use chr(9) instead?