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

Drill stops reading columns > 4095

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.7.0
    • 0.9.0
    • Storage - Text & CSV
    • None
    • CentOS 6.4
      sqlline 1.1.6
      Drill 0.7

    Description

      Querying a CSV file with 10000 columns, it looks like I can't query past column 4095.
      0: jdbc:drill:localhost:5181> SELECT columns[4094] FROM `dfs`.`tmp`.`manycols.csv` limit 1;
      ------------

      EXPR$0

      ------------

      833

      ------------
      1 row selected (0.269 seconds)
      0: jdbc:drill:localhost:5181> SELECT columns[4095] FROM `dfs`.`tmp`.`manycols.csv` limit 1;
      --

       

      --
      --
      No rows selected (0.198 seconds)
      0: jdbc:drill:localhost:5181>

      [mapr@drilltwitter tmp]$ awk -F, '

      { print $4095,$4096,$4097 }

      ' manycols.csv | head -1
      833 2552 2222
      [mapr@drilltwitter tmp]$

      Attachments

        1. manyColumns.csv
          19 kB
          Khurram Faraaz
        2. mcols.csv
          46 kB
          Nick Amato

        Issue Links

          Activity

            People

              cwestin Chris Westin
              namato Nick Amato
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: