Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4658

cannot specify tab as a fieldDelimiter in table function

    XMLWordPrintableJSON

    Details

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

      Mac OS X, Java 8

      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)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                vicenteg Vince Gonzalez
                Reviewer:
                Krystal
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: