drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vince Gonzalez (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4658) cannot specify tab as a fieldDelimiter in table function
Date Fri, 06 May 2016 12:23:12 GMT
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)

Mime
View raw message