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

TextReader should support multibyte field delimiters

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.6.0
    • Fix Version/s: Future
    • Component/s: Storage - Text & CSV
    • Labels:
      None

      Description

      Data file /tmp/foo.txt contents:

      0::2::3
      0::3::1
      0::5::2
      0::9::4
      0::11::1
      0::12::2
      0::15::1
      

      Query:

      select
      	columns
      from
      	table(dfs.`/tmp/foo.txt`(type => 'text', fieldDelimiter => '::'))
      

      Results in a error message:

      PARSE ERROR:
      Expected single character but was String: ::
      table /tmp/foo.txt
      parameter fieldDelimiter SQL Query null
      

      It would be nice that fieldDelimiter accepts text of any length.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                arina Arina Ielchiieva
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: