drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arina Ielchiieva (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-4658) cannot specify tab as a fieldDelimiter in table function
Date Wed, 10 Aug 2016 09:02:22 GMT

     [ https://issues.apache.org/jira/browse/DRILL-4658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Arina Ielchiieva resolved DRILL-4658.
-------------------------------------
       Resolution: Fixed
    Fix Version/s:     (was: 1.9.0)
                   1.8.0

Merged with 5ca2340a0a83412aa8fc8b077b72eca5f55e4226

> 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
>             Fix For: 1.8.0
>
>
> 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