Vince Gonzalez created DRILL-4658: ------------------------------------- Summary: 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)