[ https://issues.apache.org/jira/browse/DRILL-4658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15277809#comment-15277809 ]
Arina Ielchiieva commented on DRILL-4658: ----------------------------------------- Roger, currently field delimiters can only be one byte long. Based on your comment I have created Jira DRILL-4660 - TextReader should support multibyte field delimiters. > cannot specify tab as a fieldDelimiter in table function > -------------------------------------------------------- > > Key: DRILL-4658 > URL: https://issues.apache.org/jira/browse/DRILL-4658 > Project: Apache Drill > Issue Type: Bug > Components: SQL Parser > Affects Versions: 1.6.0 > Environment: Mac OS X, Java 8 > Reporter: Vince Gonzalez > Assignee: Arina Ielchiieva > > I can't specify a tab delimiter in the table function because it maybe counts > the characters rather than trying to interpret as a character escape code? > {code} > 0: jdbc:drill:zk=local> select columns[0] as a, cast(columns[1] as bigint) as > b from table(dfs.tmp.`sample_cast.tsv`(type => 'text', fieldDelimiter => > '\t', skipFirstLine => true)); > Error: PARSE ERROR: Expected single character but was String: \t > table sample_cast.tsv > parameter fieldDelimiter > SQL Query null > [Error Id: 3efa82e1-3810-4d4a-b23c-32d6658dffcf on 172.30.1.144:31010] > (state=,code=0) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)