[jira] [Created] (DRILL-3395) wide tables data overlap previously written row data in the CLI

["Jim Scott (JIRA)" <ji...@apache.org>]

Jim Scott created DRILL-3395:
--------------------------------

             Summary: wide tables data overlap previously written row data in the CLI
                 Key: DRILL-3395
                 URL: https://issues.apache.org/jira/browse/DRILL-3395
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - CLI
    Affects Versions: 1.0.0
         Environment: Linux
            Reporter: Jim Scott
            Assignee: Daniel Barclay (Drill)


when querying a parquet or csv file with 18 columns the columns from the end of the row overwrite the data at the beginning of the row. You can use the below data and query it and notice that the 01001 will not show up in the output results.

repeat with storage format:
    "nndb": {
      "type": "text",
      "extensions": [ "txt" ],
      "quote": "~",
      "escape": "~",
      "delimiter": "^"
    },

Data records in file NUT_DATA.txt:
~01001~^~203~^0.85^16^0.074^~1~^~~^~~^~~^^^^^^^~~^11/1976^
~01001~^~204~^81.11^580^0.065^~1~^~~^~~^~~^^^^^^^~~^11/1976^
~01001~^~205~^0.06^0^^~4~^~NC~^~~^~~^^^^^^^~~^11/1976^
~01001~^~207~^2.11^35^0.054^~1~^~~^~~^~~^^^^^^^~~^11/1976^
~01001~^~208~^717^0^^~4~^~NC~^~~^~~^^^^^^^~~^08/2010^
~01001~^~221~^0.0^0^^~7~^~~^~~^~~^^^^^^^~~^04/1985^
~01001~^~255~^15.87^522^0.061^~1~^~~^~~^~~^^^^^^^~~^11/1976^
~01001~^~262~^0^0^^~7~^~Z~^~~^~~^^^^^^^~~^02/2001^
~01001~^~263~^0^0^^~7~^~Z~^~~^~~^^^^^^^~~^02/2001^
~01001~^~268~^3000^0^^~4~^~~^~~^~~^^^^^^^~~^06/2013^

select columns[0], columns[1], columns[2], columns[3], columns[4], columns[5], columns[6], columns[7], columns[8], columns[9], columns[10], columns[11], columns[12], columns[13], columns[14], columns[15], columns[16], columns[17] from dfs.tmp.`sr27asc/NUT_DATA.txt`




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)