[ https://issues.apache.org/jira/browse/DRILL-4658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15277759#comment-15277759 ]
Roger Dielrton commented on DRILL-4658: --------------------------------------- Execuse me for the intervention, but I suffer a related problem with {{fieldDelimiter}}: Data file {{/tmp/foo.txt}} contents: {noformat} 0::2::3 0::3::1 0::5::2 0::9::4 0::11::1 0::12::2 0::15::1 {noformat} Query: {code:sql} select columns from table(dfs.`/tmp/foo.txt`(type => 'text', fieldDelimiter => '::')) {code} Results in a error message: {noformat} PARSE ERROR: Expected single character but was String: :: table /tmp/foo.txt parameter fieldDelimiter SQL Query null {noformat} It would be nice that {{fieldDelimiter}} accepts text of any length. > 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 > > 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)