[DRILL-4658] cannot specify tab as a fieldDelimiter in table function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Fix Version/s: 1.8.0
• Component/s: SQL Parser

Environment

Mac OS X, Java 8

• Assignee: Arina Ielchiieva
• Reporter: Vince Gonzalez
• Reviewer: Krystal
• Created: 06/May/16 12:23
• Updated: 21/Jun/17 23:18
• Resolved: 10/Aug/16 09:01

Description

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?

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)

Issue Links

• relates to: DRILL-4660 TextReader should support multibyte field delimiters
• relates to: DRILL-3149 TextReader should support multibyte line delimiters